Modify and test the program access_cars.php to handle UPDATE and INSERT SQL commands, as well as SELECT.

<?php

$db_hostname = 'localhost';

$db_username = 'root'; //enter your username

$db_password = ''; // enter password else leave it as default

$db_name = 'test'; // enter the name of your database on which you are working

$conn = mysqli_connect($db_hostname, $db_username, $db_password, $db_name);

if(!$conn) {

echo "An error occurred can’t connect to DataBase ".mysqli_error($conn);die;

} else {

echo “connected to DataBase";

}

//----------------------------------Insert--------------------------------------------

mysqli_select_db($conn, $db_name);

$sql = "INSERT INTO cars (id,name, price) VALUES (123432,’Swift’,50000)";

$query = mysqli_query($conn, $sql);

if (!$query) {

echo "Car does not inserted. " . mysqli_error($conn);

} else {

echo "Car inserted successfully.";

}

//-------------------------Update------------------------------------------------

$sql = "UPDATE cars SET name= 'Honda’  WHERE id=123432 ";

$query = mysqli_query($conn,$sql);

if(!$query)

{

echo "Record is not Updated.".mysqli_error($conn);die;

}

else

{

echo "Data successfully updated";

}

//--------------------------------------select------------------------------------

$sql = "SELECT * FROM cars";

$query = mysqli_query($conn,$sql);

if(!$query)

{

echo "Query does not work.".mysqli_error($conn);die;

}

while($data = mysqli_fetch_array($query))

{

echo "id = ".$data['id']."<br>";

echo "car_name = ".$data['name']."<br>";

echo "price = ".$data[‘price’]."<br>";

}

?>