PHP · Theory

with MySQL

Theory

322/352

with MySQL

with MySQL is a PHP topic. In plain words you use it for fetch marks by roll in the college DB. Don’t start with a slogan — start with that picture.

Smallest example: prepared statement. Type it, run it, and say what you see. If you can do that from memory, you know with MySQL.

From the example next to this theory — with MySQL: scores array, print avg, then high marks.

Trap — string-concat SQL. Fix that before you talk about advanced PHP.

Viva — what is with MySQL? Then show prepared statement. Then name the trap.

Exam tip

What is with MySQL? Show this: prepared statement. Trap: string-concat SQL.

Example

<?php
// with MySQL
$scores = [80, 90, 70];
$avg = array_sum($scores) / count($scores);
echo "avg=" . number_format($avg, 1) . "\n";
foreach ($scores as $s) {
  if ($s >= 80) echo "high: $s\n";
}

with MySQL: scores array, print avg, then high marks. Say the output.

Short notes

Defwith MySQL — fetch marks by roll in the college DB.
Ruleprepared statement
Trapstring-concat SQL
Usethe college DB

PHP · Theory

with MySQL

← All stacks

Theory

322/352

with MySQL

with MySQL is a PHP topic. In plain words you use it for fetch marks by roll in the college DB. Don’t start with a slogan — start with that picture.

Smallest example: prepared statement. Type it, run it, and say what you see. If you can do that from memory, you know with MySQL.

From the example next to this theory — with MySQL: scores array, print avg, then high marks.

Trap — string-concat SQL. Fix that before you talk about advanced PHP.

Viva — what is with MySQL? Then show prepared statement. Then name the trap.

Exam tip

What is with MySQL? Show this: prepared statement. Trap: string-concat SQL.

Example

<?php
// with MySQL
$scores = [80, 90, 70];
$avg = array_sum($scores) / count($scores);
echo "avg=" . number_format($avg, 1) . "\n";
foreach ($scores as $s) {
  if ($s >= 80) echo "high: $s\n";
}

with MySQL: scores array, print avg, then high marks. Say the output.

Short notes

Defwith MySQL — fetch marks by roll in the college DB.
Ruleprepared statement
Trapstring-concat SQL
Usethe college DB

with MySQL

Example

Short notes

Questions

with MySQL

Example

Short notes

Questions