开发者

I am executing two stored procedures but only first section is getting executed & section section returning null

开发者 https://www.devze.com 2023-03-27 07:31 出处:网络
$link = mysqli_connect(\'localhost\',\'root\',\'\',\'icoachswim_sp\'); if($result1 = mysqli_query($link,\"call sp_SetupGroupsManageEventsGroups(\".$uid.\")\")) {
$link = mysqli_connect('localhost','root','','icoachswim_sp');
if($result1 = mysqli_query($link,"call sp_SetupGroupsManageEventsGroups(".$uid.")")) {
    while($row1 = mysqli_fetch_array($result1)) {
        echo '<pre>';
        print_r($row1);
        echo '</pre>';
        array_push($array_gids,$row1['id']);
    }
 }                    

 if($result = mysqli_query($link,"call sp_SetupGroupsManageEvents('".$groupID."',".$uid.")")) {
     while($row = mysqli_fetch_array($result)) {
         echo '<开发者_运维百科pre>';
         print_r($row);
         echo '</pre>';
         array_push($arr_group_events,$row);
     }
}


mysqli_query will not execute multiple queries. Check out this answer: Multiple queries within a single mysqli_result

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号