如何在执行多个查询时返回多个结果？(How to return multiple results while executing multiple queries?)

如何在执行多个查询时返回多个结果？(How to return multiple results while executing multiple queries?)

我在一个函数内执行4个查询。 我如何一次返回4个结果，以便在调用函数时可以使用全部4个结果？ 我应该创建一个数组并将所有结果存储在该数组中吗？ 我试着一个接一个地返回结果，但是在调用了return命令之后，函数从那一点退出。 有没有办法单独返回每个查询结果？ 这是我的代码：

function select_all_category_name() { require 'admin/db_connect.php'; $sql="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1"; if (mysqli_query($db_connect, $sql)) { $sql1="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid='' AND spid='' AND pid=''"; $sql2="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid='' AND pid=''"; $sql3="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid=''"; $sql4="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid!=''"; $query_result1=mysqli_query($db_connect, $sql1); $query_result2=mysqli_query($db_connect, $sql2); $query_result3=mysqli_query($db_connect, $sql3); $query_result4=mysqli_query($db_connect, $sql4); } else { die("Query Problem". mysqli_error($db_connect)); } }

db_connect.php文件包含连接。

I am executing 4 queries inside a function. How I can return those 4 results at a time so that I can use all 4 results while calling the function? Should I create an array and store all of the results inside that array? I tried to return the result one by one but after calling return command, function exits from that point. Is there any way to return each of the query result individually? Here's my code:

function select_all_category_name() { require 'admin/db_connect.php'; $sql="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1"; if (mysqli_query($db_connect, $sql)) { $sql1="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid='' AND spid='' AND pid=''"; $sql2="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid='' AND pid=''"; $sql3="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid=''"; $sql4="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid!=''"; $query_result1=mysqli_query($db_connect, $sql1); $query_result2=mysqli_query($db_connect, $sql2); $query_result3=mysqli_query($db_connect, $sql3); $query_result4=mysqli_query($db_connect, $sql4); } else { die("Query Problem". mysqli_error($db_connect)); } }

db_connect.php file contains the connection.

最满意答案

也许这样？

function select_all_category_name() { require 'admin/db_connect.php'; $sql="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1"; if (mysqli_query($db_connect, $sql)) { $sql1="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid='' AND spid='' AND pid=''"; $sql2="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid='' AND pid=''"; $sql3="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid=''"; $sql4="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid!=''"; $result_array = array( "query_result1" => mysqli_query($db_connect, $sql1), "query_result2" => mysqli_query($db_connect, $sql2), "query_result3" => mysqli_query($db_connect, $sql3), "query_result4" => mysqli_query($db_connect, $sql4) ); return $result_array; } else { die("Query Problem". mysqli_error($db_connect)); } }

Perhaps something like this ?

function select_all_category_name() { require 'admin/db_connect.php'; $sql="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1"; if (mysqli_query($db_connect, $sql)) { $sql1="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid='' AND spid='' AND pid=''"; $sql2="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid='' AND pid=''"; $sql3="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid=''"; $sql4="SELECT * FROM tbl_category WHERE publication_status=1 AND deletion_status=1 AND mpid!='' AND spid!='' AND pid!=''"; $result_array = array( "query_result1" => mysqli_query($db_connect, $sql1), "query_result2" => mysqli_query($db_connect, $sql2), "query_result3" => mysqli_query($db_connect, $sql3), "query_result4" => mysqli_query($db_connect, $sql4) ); return $result_array; } else { die("Query Problem". mysqli_error($db_connect)); } }