SQL VS PHP (Object oriented connection)
HOW TO ESTABLISH THE CONNECTION WITH DATABASE
$db = new mysqli(<HOST NAME>,<DB USER>,<DB PASS>,<DB NAME>);
HOW TO EXECUTE QUERY
$query = “YOUR QUERY”;
$result = $db->query($query);
HOW TO LIST YOUR QUERY RESULT
while($row = $result->fetch_array(MYSQLI_ASSOC)){
echo “Hi ” .$row[‘Name’]. “, Your Email is” .$row[‘Email’]. ” and your phone number is ” .$row[‘Phone’] ;
}
