PHP · Theory

MySQLi DELETE

← All stacks

Theory

74/352

MySQLi DELETE

Sara only reaches for MySQLi DELETE when fetch marks by roll has to stay correct in the college DB.

For MySQLi DELETE, Apache/Nginx is in play. Don’t blame it until you have traced fetch marks by roll.

Without MySQLi DELETE, the college DB gets messy and fetch marks by roll is hard to trust.

Use MySQLi DELETE when fetch marks by roll must stay clear. If a simpler PHP step works, use that instead.

If fetch marks by roll breaks under MySQLi DELETE, check string-concat SQL first.

After MySQLi DELETE, Sara should still remember string-concat SQL.

Close MySQLi DELETE with — “If I skip it, fetch marks by roll goes wrong like this: string-concat SQL.”

Exam tip

Say MySQLi DELETE in one breath, then prepared statement, then string-concat SQL.

Example

<?php
// PDO sketch (connection details omitted)
// $pdo = new PDO($dsn, $user, $pass);
// $stmt = $pdo->prepare("SELECT id, name FROM users WHERE id = ?");
// $stmt->execute([1]);
// $row = $stmt->fetch();
$demo = ["id" => 1, "name" => "Asha"];
echo $demo["name"];

MySQLi DELETE — use prepared statements with PDO/MySQLi — never concatenate raw SQL.

Short notes

DefMySQLi DELETE — Sara uses it for fetch marks by roll in the college DB.
RuleMySQLi DELETE → prepared statement.
RememberMySQLi DELETE + Apache/Nginx (the college DB).
UseMySQLi DELETE in the college DB (fetch marks by roll).
TrapMySQLi DELETE — string-concat SQL.
ExMySQLi DELETE → fetch marks by roll.

<?php // PDO sketch (connection details omitted) // $pdo = new PDO($dsn, $user, $pass); // $stmt = $pdo->prepare("SELECT id, name FROM users WHERE id = ?"); // $stmt->execute([1]); // $row = $stmt->fetch(); $demo = ["id" => 1, "name" => "Asha"]; echo $demo["name"];

MySQLi DELETE

Example

Short notes

Questions

MySQLi DELETE

Example

Short notes

Questions