douluanzhao6689 2017-09-08 18:47
浏览 162
已采纳

注意:类mysqli_result的对象无法转换为int

I've searched all the questions that are almost identical to my case. but I am still confused .I just learned php programming and got an problem like this: Notice: Object of class mysqli_result could not be converted to int in ... please help me to solve the above problem.

    <?php
 $per_hal=10;
$jumlah_record="SELECT COUNT(*) from user";
$d=mysqli_query($link, $jumlah_record);
if($d == FALSE) { die(mysql_error()); } 
$halaman=ceil($d / $per_hal);  //error here
$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $per_hal;
?>
  • 写回答

1条回答 默认 最新

  • duanli3277 2017-09-08 18:52
    关注

    1.$d is the mysqli_result object. first get data from it and then use it.

    2.don't mix mysql_* with mysqli_*.

    <?php
      $per_hal=10;
      $jumlah_record="SELECT COUNT(*) as total_count from user";
      $d=mysqli_query($link, $jumlah_record);
      if($d) {
        $result = mysqli_fetch_assoc($d); //fetch record
        $halaman=ceil($result['total_count'] / $per_hal);  //error here
        $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
        $start = ($page - 1) * $per_hal;
      }else{
        die(mysqli_error($link));  // you used mysql_error() which is incorrect
      }
    ?>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥200 uniapp长期运行卡死问题解决
  • ¥15 latex怎么处理论文引理引用参考文献
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?