Showing posts with label insert. Show all posts
Showing posts with label insert. Show all posts

Sunday, March 9, 2014

Insert, Update and Delete data in MySQL

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'")