PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table test (id int, value varchar(20)); insert into test set value='first';
Copy Clear
Copy Format Clear
<?php $sql = "SELECT 1,2 where 1=0"; $stmt = $mysqli->prepare($sql); $stmt->bind_param("s", $item_code); $stmt->execute(); $item_name = ''; $credits = 0; $stmt->bind_result($item_name, $credits); var_dump($item_name, $credits);
Show:  
Copy Clear