• php
  • 1915
  • 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