القسم php - الزيارات 1764 - التاريخ 20/3/2008
The UPDATE statement is used to modify data in a database table. -------------------------------------------------------------------------------- [color=FA0309]Update Data In a Database[/color]
The UPDATE statement is used to modify data in a database table. [color=FA0309]Syntax[/color]
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. [color=FA0309]Example[/color]
Earlier in the tutorial we created a table named 'Person'. Here is how it looks:

i

The following example updates some data in the 'Person' table:
<?php
$con = mysql_connect('localhost','peter','abc123');
if (!$con)
{
die('Could not connect: ' . mysql_error());
} mysql_select_db('my_db', $con); mysql_query('UPDATE Person SET Age = '36'
WHERE FirstName = 'Peter' AND LastName = 'Griffin''); mysql_close($con);
?>
After the update, the 'Person' table will look like this:

i

مشاركة الموضوع

كن أول من يقيم الموضوع
12345