• php执行多个存储过程


        $viewPages = 0;
        $db = new mysqli('localhost',$MYSQL_USER,$MYSQL_PASS,$MYSQL_DB);  
        if (!mysqli_connect_errno()){
            $sql = "call proc_getrelativeviewids('201605101715444261')";
            $result = $db->query($sql);
            if($result) {
                if($row= $result->fetch_assoc()){
                    $count = $row['cnt'];
                }
                if (!empty($count))
                    $viewPages = ceil($count/PAGE_SIZE);
               
                var_dump($viewPages);
                $result->close();
                $db->next_result();
                $sql = "call proc_getrelativeviewids('201605101715444261')";
                $result = $db->query($sql);
            }
            if($result) {
                if($row= $result->fetch_assoc()){
                    $count = $row['cnt'];
                }
                if (!empty($count))
                    $viewPages = ceil($count/PAGE_SIZE);
           
                var_dump($viewPages);
                $result->close();
                $db->next_result();      
            } 
        }
        $db->close();

  • 相关阅读:
    anime.js 学习笔记
    swiper 报错 ‘ Can't find variable: Dom7’
    团队管理(二)
    团队管理(一)
    针对数值型数据的相关记录
    react+echarts折柱图实现
    侧边广告之心跳动画
    浅谈尾调用和尾递归
    elementUI 日期选择器获取CRON值
    elementUI 日期选择器之禁止年份事件二
  • 原文地址:https://www.cnblogs.com/xihong2014/p/5527422.html
Copyright © 2020-2023  润新知