call store procedure with php

[ky0shiro]

Hi, wanna ask about store procedure & php to call it :-)

i have already created this store procedure, but i can't call it in my php code..

can someone help me please.. ?? the result won't appear in the browser..

 

here is my store procedure code :

 

CREATE PROCEDURE `select_users`(id int(11), username varchar(100))

select * from users where id='id';

 

and here is my php code to call the store procedure above :

<?

$conn = mysqli_connect('localhost','root','','store_procedure');

$id = 2;

 

if ($result = mysqli_query($conn, "call select_users('$id', '$username')")) {

while( $row = mysqli_fetch_array($result) ){

echo $row['id']." - ".$row['username'] . "<br>";

}

}

mysqli_free_result($result);

mysqli_close($conn);

?>

 

 

after i execute that php code in my browser, it wont appear the result with id=2

my database just have 2 tables, 'id' & 'username'

php code above is just to view the result with id=2

but it won't appear.. does anyone know where is my mistake?

Thx before.. :-)