BAB 27 PHP MySQL Update

BAB 27 PHP MySQL Update ________________________________________ The UPDATE statement is used to modify data in a database table. Syntax UPDATE table_name SET column_name = new_value WHERE column_name = some_value Note: SQL statements are not case sensitive. UPDATE is the same as update. To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection. Example Earlier in the tutorial we created a table named "Person". Here is how it looks: FirstName LastName Age Peter Griffin 35 Glenn Quagmire 33 The following example updates some data in the "Person" table: After the update, the "Person" table will look like this: FirstName LastName Age Peter Griffin 36 Glenn Quagmire 33 ________________________________________ BAB 28 PHP MySQL Delete From ________________________________________ The DELETE FROM statement is used to delete records from a database table. Syntax DELETE FROM table_name WHERE column_name = some_value Note: SQL statements are not case sensitive. DELETE FROM is the same as delete from. To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection. Example Earlier in the tutorial we created a table named "Person". Here is how it looks: FirstName LastName Age Peter Griffin 35 Glenn Quagmire 33 The following example deletes all the records in the "Person" table where LastName='Griffin': After the deletion, the table will look like this: FirstName LastName Age Glenn Quagmire 33 ________________________________________