你如何从计数查询中获取表名,我有多个查询,我需要从查询结果中获取表名,这是我的查询
$myquery = "select count(tb_id) as num_rows from table1; select count(tb1_id) from table2...";
if (myqli_multi_query($connection, $myquery){
..
$row = mysqli_fetch_assoc($result);
$num_rows = $row["num_rows"];
..
}
查询工作正常,因为我可以获得行数,但是无法将表名链接到行数(结果)
我试过了,它执行没有错误,但是仍然无法获取表名
select count(tb_id) as num_rows, 'table1' as TableName from table1
您可以在查询中添加一个标识符,以供日后参考。
$myquery = "select 'table1' as tablename, count(tb_id) as num_rows from table1;
select 'table2' as tablename, count(tb1_id) as num_rows from table2;"
// and so on
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句