/SQL/Mysqli_connect using prepare statement

Mysqli_connect using prepare statement

$stmt = $mysqli->prepare("UPDATE myTable SET name = ? WHERE id = ?");
$stmt->bind_param("si", $_POST['name'], $_SESSION['id']);
$stmt->execute();
$stmt->close();
Copy

Source: websitebeaver.com

Similar codes

4 votes193 views1 answer
Force drop all tables postgres
SQL
0 vote262 views1 answer
Updating database in sql
SQL
23 votes215 views1 answer
How remove column in mysql
SQL
1 vote284 views1 answer
Sql oracle update multiple rows
SQL
0 vote152 views1 answer
Sql query with date
SQL
0 vote219 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote276 views1 answer
Sql select merge multiple values
SQL
0 vote156 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
5 votes197 views2 answers
Mysqldump password
SQL
2 votes184 views1 answer
Mysql auto increment jumping
SQL