Izabele Renata
Izabele Renata
Programming language:SQL
2021-03-18 13:33:29
0
Q:

mysqli_connect using prepare statement

Fin
Fin
Code: SQL
2021-07-06 00:08:56 
$stmt = $mysqli->prepare("INSERT INTO myTable (name, age) VALUES (?, ?)");
$stmt->bind_param("si", $_POST['name'], $_POST['age']);
$stmt->execute();
$stmt->close();
Copy
1
JonBonJvi
JonBonJvi
Code: SQL
2021-02-14 16:40:56 
$stmt = $mysqli->prepare("DELETE FROM myTable WHERE id = ?");
$stmt->bind_param("i", $_SESSION['id']);
$stmt->execute();
$stmt->close();
Copy
1
Alex
Alex
Code: SQL
2021-02-14 16:39:16 
$stmt = $mysqli->prepare("UPDATE myTable SET name = ? WHERE id = ?");
$stmt->bind_param("si", $_POST['name'], $_SESSION['id']);
$stmt->execute();
$stmt->close();
Copy
0

Tags

Related

New to Communities?

Join the community