PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table user ( id int, name varchar(255) ); Insert into user values (1, 'misha');
Copy Clear
Copy Format Clear
<?php $id = 1; $query = "UPDATE user SET name ='boris' WHERE id=?"; $sqlSearch = $mysqli->prepare($query); $sqlSearch->bind_param('i', $id); $sqlSearch->execute(); $users = $mysqli->query("SELECT * FROM user;")->fetch_all(); print_r($users);
Show:  
Copy Clear