Cannot use object of type mysqli_result as array [duplicate]

Question

 $hasil=mysqli_query($connect, $ambil);
$hasil_id=$hasil['id'];
$hasil_name=$hasil['name'];
$hasil_email=$hasil['email'];
$hasil_comment=$hasil['comment'];

I got this fatal error from the code above, is it something to do with the php version? especialy when using mysqli

Puneet · Accepted Answer · 2016-06-15 03:37:32Z

1

Use mysqli_fetch_assoc or mysqli_fetch_array to fetch a result row as an associative array.

query = "SELECT 1";

$result = $mysqli->query($query); $followingdata = $result->fetch_assoc()

answered Jun 15, 2016 at 3:37

Puneet

1083 bronze badges

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

Comments

ksealey · Accepted Answer · 2016-06-15 03:36:22Z

0

Edits below. You're trying to use the mysqli result as an array.

  $hasil=mysqli_query($connect, $ambil);
  //Assuming you're expecting a single result
  $hasil = mysqli_fetch_array($hasil); //Create array from first result
  $hasil_id=$hasil['id'];
  $hasil_name=$hasil['name'];
  $hasil_email=$hasil['email'];
  $hasil_comment=$hasil['comment'];

answered Jun 15, 2016 at 3:36

ksealey

1,7381 gold badge17 silver badges16 bronze badges

1 Comment

Tristan Over a year ago

Should specify the resulttype variable as MYSQLI_ASSOC to get the data in associative indices - $hasil = mysqli_fetch_array($hasil, MYSQLI_ASSOC);

Collectives™ on Stack Overflow

Cannot use object of type mysqli_result as array [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related