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

No comments:

Post a Comment