我是php的新手,我尝试调用以下函数,以便在mysql中填充先前插入的数据数组,但我得到null。
function GetBusiness($con, $email)
{
$query = "SELECT * from Business WHERE B_EMAIL ='".$email."'";
$res = mysqli_query($con,$query);
$result_arr = array();
while($row = mysqli_fetch_array($res))
{
$result_arr[] = $row;
}
return $result_arr;
}
然后我尝试构建json对象为。
$result_business = array();
$result_business = GetBusiness($con, $email);
$json['result'] = "Success";
$json['message'] = "Successfully registered the Business";
$json["uid"] = $result_business["id"];
$json["business"]["name"] = $result_business["name"];
$json["business"]["email"] = $result_business["email"];
但是即使数据被成功插入,$result_business的部分是空的,为什么我得到空?我的$query打错了吗?
谢谢
问题是,你的函数GetBusiness
返回一个多维数组,你可以使用这个代替:
function GetBusiness($con, $email)
{
$query = "SELECT * from Business WHERE B_EMAIL ='".$email."'";
$res = mysqli_query($con,$query);
return mysqli_fetch_array($res);
}
另外,您必须使用您选择的MySQL列来访问行集的数据。就像
$json["uid"] = $result_business["B_ID"];
$json["business"]["name"] = $result_business["B_NAME"];