binding results into php array

Question

I am trying the following code to get results from query and display it in the tes.php page.

db.inc.php

<?php
function db_connect()
{
    $handle=new mysqli('localhost','rekandoa','rekandoa','rekandoa');
 if (!$handle)
{
       return false;
   }
return $handle;
}

function get_member()
{
    $handle=db_connect();
$sql="Select email,nama,alamat,kota,propinsi from users where email=?";
    $stmt=$handle->prepare($sql);
  $mail='[email protected]';
    $stmt->bind_param("s",$mail); 
 $stmt->execute();
  $stmt->bind_result($email,$nama,$alamat,$kota,$propinsi);
  $result=$stmt->fetch();
    return $result;
}
?>

tes.php

<?php
error_reporting(E_ALL & ~E_NOTICE);
include('db.inc.php');
$w=get_member();
echo $w['member_id'];
echo '<br>';
echo $w['email'];
echo '<br>';
echo $w['status'];
echo '<br>';
?>

I got no error message but the results are not shown, it is just a blank page.

What did I do wrong?

When pasting code, please use the code function in the editor (binary icon) — nduplessis
– nduplessis, Commented Mar 4, 2009 at 13:19
@nduplessis: Nothing wrong with the question, lets stay productive. — GEOCHET
– GEOCHET, Commented Mar 4, 2009 at 13:20
Are there 3 <br> tags in the "blank document"s source? If not, there could be an exception which you just don't see. Try to check your apaches error.log. Maybe the mysqli extension is missing? — Karsten
– Karsten, Commented Mar 4, 2009 at 15:18

ohaal · Accepted Answer · 2012-06-28 07:15:16Z

5

$stmt->bind_result($email,$nama,$alamat,$kota,$propinsi);

The above line will make sure that the results are stored in the variables that you provide. The fetch() function returns TRUE or FALSE - whether the query was successfull, not the actual result. You would need something like

return array(
    'email'    => $email,
    'nama'     => $nama,
    'alamat'   => $alamat,
    'kota'     => $kota,
    'propinsi' => $propinsi);

edited Jun 28, 2012 at 7:15

ohaal

5,2682 gold badges37 silver badges56 bronze badges

answered Mar 4, 2009 at 13:39

soulmerge

76.2k20 gold badges121 silver badges160 bronze badges

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

Comments

Martijn Laarman · Accepted Answer · 2009-03-04 13:43:58Z

1

fetch() itself doesnt return an array it returns a boolean indicating wheter it got a row. thus you can do:

while($stmt->fetch()) {
     //$email,$nama,$alamat,$kota,$propinsi are now filled
}

binding values into an array dynamically (unlike soulmerge's solution) takes a little more craft. I created a Database class that does just that. It acts as a wrapper arround mysqli prepared statements to return results as objects where the select columns act as properties on the object. If you take out the cast to object in the class it will return arrays as you want.

edited Mar 4, 2009 at 13:43

answered Mar 4, 2009 at 13:38

Martijn Laarman

13.5k47 silver badges64 bronze badges

Collectives™ on Stack Overflow

binding results into php array

db.inc.php

tes.php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

db.inc.php

tes.php

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related