Cannot use object of type mysqli_result as array error [duplicate]

Question

I just learned mysqli since Mysql_ queries is deprecated and people keep telling me to use mysqli instead

so for starter I make a simple code to connect, insert and show data I have no problem making connection, inserting data to database but I cannot show the data using mysqli_fetch_array

here is my code :

<?php
 $sql=("SELECT * from data_orang");
 $hasil=mysqli_query($con,$sql);
  while(mysqli_fetch_array($hasil)){
  echo "nama : $hasil[nama] <br>
      umur : $hasil[umur] <br>
      kelamin : $hasil[kelamin] <br>";
  }
 ?>

this is what I've tried

   echo " nama : $hasil['nama'] <br>
          umur : $hasil['umur'] <br>
          kelamin : $hasil['kelamin'] <br>

I also tried adding mysqli_assoc and mysqli_free_result($hasil) but it does not work

I use procedural since I'm used to it, if you want to give answer please give it using procedural style I haven't tried the object-oriented style yet — Citra45Abadi
– Citra45Abadi, Commented Jul 29, 2016 at 8:08

Mehmet SÖĞÜNMEZ · Accepted Answer · 2016-07-29 08:08:57Z

1

As its says: "Cannot use object of type mysqli_result as array error". You have to create an array from result.

while($result = mysqli_fetch_array($hasil)){
  echo "nama : $result[nama] <br>
      umur : $result[umur] <br>
      kelamin : $result[kelamin] <br>";
  }

answered Jul 29, 2016 at 8:08

Mehmet SÖĞÜNMEZ

6056 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Naga · Accepted Answer · 2016-07-29 08:30:43Z

0

You have to assign the fetch array to an array variable. I this is common both in mysql and mysqli.

while($row = mysqli_fetch_array($hasil)){
  echo "nama : ".$row ['nama'] ."<br>
      umur : ". $row ['umur'] ."<br>
      kelamin :". $row ['kelamin'] ."<br>";
  }

edited Jul 29, 2016 at 8:30

answered Jul 29, 2016 at 8:11

Naga

2,1683 gold badges18 silver badges21 bronze badges

Collectives™ on Stack Overflow

Cannot use object of type mysqli_result as array error [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related