php mysql 多张表,PHP话语在MYSQL中查询多张表 并显示在页面上

PHP语句在MYSQL中查询多张表 并显示在页面上

用PHP语句实现查询多张表 表的字段是相同的、表名不同。例如：

abc201202,abc201203,abc201204...表名按月建的表

我新手不知道怎么一次遍历多张表，提取MYSQL中的数据。

------解决思路----------------------

$table = array("abc201202","abc201203","abc201204");

$result =array();

foreach($table as $table_name) {

$sql = "select * from ".$table_name;

$rec =mysql_query($sql);

while($row=mysql_fetch_row($rec)) {

$result[] = $row;

}

}

------解决思路----------------------

$select = array();

$table = array("abc201202","abc201203","abc201204");

foreach($table as $v) {

$select[] = "(select * from $v)";

}

$sql = join(' UNION ', $select);

$res = mysql_query($sql);

------解决思路----------------------

$table = array("abc201202","abc201203","abc201204");

$result=array();

$count = count($table)-1;//减去一个数组下标

for ($i=0;$i $sql = $sql." select * from '".$table[$i]."' union all";

}

$sql=$sql." select * from '".$table[$count]."'";

$rec =mysql_query($sql);

while($row=mysql_fetch_row($rec)) {

$result[] = $row;

}

相关文章

相关视频