PHP MySQL Update
The UPDATE statement is used to modify data in a database table.
Update Data In a Database
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:
<?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:
| FirstName |
LastName |
Age |
| Peter |
Griffin |
36 |
| Glenn |
Quagmire |
33 |
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a free 30-day trial today!
Click to see a demo!
Learn what’s new in v2008
 |
|
Get Your Diploma!
W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.
The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.
The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.
|
|