doulong2782 2013-12-02 09:46
浏览 33
已采纳

Mysqli查询回声结果

Hi I am trying to make status of user so it will check how many post this user has and echo out the result, it was working fine when I was using mysql but after converting it to mysqli it giving me some errors

Here is my code:

<?php
    if(!isset($_COOKIE['loggedin'])){
        header("location:index.php");
    }

session_start();

if(!isset($_SESSION['user'])){

header("location: index.php");
}
else {

?>

<?php 
$con=mysqli_connect("localhost","root","123","user");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$resule = "SELECT count(ID) from save_data where username = '".$_SESSION['user']."'"
    or die(mysql_error()); 

$result = $con->query($resule);

$row = $result->fetch_array(MYSQLI_NUM);
echo $row[0], $row[1];

?>

<?php }?>

Error:

Notice: Undefined offset: 1 in C:\xampp\htdocs\mysql_login\status.php on line 30
  • 写回答

4条回答 默认 最新

  • dstd2129 2013-12-02 09:47
    关注

    Try removing $row[1] from:

    echo $row[0], $row[1];
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?

悬赏问题

  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输