mysqli_select_db($db, "vehicles");

$query ="SELECT * FROM CAR";
$result = mysqli_query($db, $query);
$num_rows = mysqli_num_rows($result);
$num_fields = mysqli_num_fields($result);
echo $num_fields;
for($j = 1; $j <= $num_rows; $j++)
{
	$row = mysqli_fetch_array($result);
	print_r($row);
}

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "my_db"); 
// note: here we are using the OO interface to mysqli
// we'll talk more about OO in PHP later today; for now, pretend its like Java/C++
$stmt =  $mysqli->stmt_init();
if ($stmt->prepare("SELECT FNAME, AGE FROM EMPLOYEE WHERE LNAME=? AND AGE > ?")) {
    $lnames = ["Smith", "Jones", "Pollett"];
    $min_age = 25;
    foreach($lnames as $lname) {
       $stmt->bind_param("si", $lname, $min_age); //s == string, i == int, d==double
       $stmt->execute();
       $stmt->bind_result($fname, $age);
       $i = 0;
       while($stmt->fetch()) {
          print("The {$i}th person I found with last name $lname and age greater than $min_age was  $fname, $age\n");
          $i++;
       }
    }
    $stmt->close();
}
$mysqli->close();

$dbh = sqlite_open($filename, $write_mode); 
$result = sqlite_query($query);
$row = sqlite_fetch_array($result);
sqlite_close($dbh);

$dbh = new SQLite3($filename, $mode); 
$results=$dbh->query($query); 
$row = $results->fetchArray(); 
$dbh->close();

SSN, PNUMBER--> HOURS
SSN --> ENAME
PNUMBER --> PNAME, PLOCATION.

• To insert an employee before they have a project means, null padding rows.
• Deleting the last employee from a project might end up deleting the project.
• When we add an employee to a second project we are duplicating ENAME unnecessarily, as once we know the SSN we've already fixed the ENAME.