Insert New data from PHP
$SqlCmd = "INSERT INTO SensorStatus ".
"(slot_num, bay_num, sensor_status,entry_time) ".
"VALUES ".
"('$SlotNum','$BayNum1','$SensorStatus',now())";
$retval = mysqli_query( $SqlCmd, $conn );
Update a data from PHP
mysqli_query($con,"UPDATE Persons SET Age=36
WHERE FirstName='Peter' AND LastName='Griffin'");
Delete a Row from Table
mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'")