$db = mysqli_connect();

$db = mysqli_connect($host, $uname, $pword, $db_name); 	

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");
       }
    }
    $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->fetch_array(); 
$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.

class MyClass
{
   public $field_var1;
   public $field_var2 = 5;
   ...
   const $constant1;
   const $constant2;
   ...

   function __construct($arg1, $arg2) {
     //constructor code
   }

   function myFun1() {
     // code
   }
   ...
}

require("MyClass.php");
//or more likely
require_once("MyClass.php");