跳转到主内容
趣航编程网 - 趣学编程,启航技术之路!

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

PHP语句在MYSQL中查询多张表 并显示在页面上 用PHP语句实现查询多张表 表的字段是相同的、表名不同。例如: abc201202,abc201203,abc201204...表名按月建的表 我新手不知道怎么一次遍历多张表,提取MYSQL中的数据。 ------解决方案-------------------- PHP code
$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; }}
------解决方案--------------------
PHP code
$select = array();$table = array("abc201202","abc201203","abc201204");foreach($table as $v) { $select[] = "(select * from $v)";}$sql = join(' UNION ', $select);$res = mysql_query($sql);
------解决方案--------------------
PHP code
$table = array("abc201202","abc201203","abc201204");$result=array();$count = count($table)-1;//减去一个数组下标for ($i=0;$i

相关文章