Updating Existing Rows in PHP

Q

How To Update Existing Rows in a Table in PHP?

✍: FYIcenter.com

A

Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values:

<?php
  include "mysql_connection.php";

  $sql = "UPDATE fyi_links SET notes='Nice site.', counts=8"
    . " WHERE id = 102";
  if (mysql_query($sql, $con)) {
    print(mysql_affected_rows() . " rows updated.\n");
  } else {
    print("SQL statement failed.\n");
  }

  mysql_close($con); 
?>

If you run this script, you will get something like this:

1 rows updated.

⇒ Deleting Existing Rows in PHP

⇐ Looping through Returning Rows from a Query in PHP

⇑ Working with MySQL Database in PHP

⇑⇑ PHP Tutorials

2016-10-19, ∼2493🔥, 0💬

Quoting Date and Time Values in PHP
How To Quote Date and Time Values in SQL Statements in PHP? If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first one uses... 2016-10-19, ∼3395🔥, 0💬

Inserting Rows Based on SELECT Statement in PHP
How To Insert Rows Based on SELECT Statements in PHP? If want to insert rows into a table based on data rows from other tables, you can use a sub-query inside the INSERT statement as shown in the following script example: <?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links" . ... 2016-10-20, ∼2843🔥, 0💬

Number of Rows Affected by a SQL Statement in PHP
How To Get the Number of Rows Selected or Affected by a SQL Statement in PHP? There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($rs) - Returns the number of rows selected in a result set object returned from SELECT statement. mysql... 2016-10-20, ∼2662🔥, 0💬

Inserting Data into a Table in PHP
How To Insert Data into a Table in PHP? If you want to insert a row of data into a table, you can use the INSERT INTO statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 101, 'dev.fyicenter.com')"; if (... 2016-10-20, ∼2567🔥, 0💬

Looping through Returning Rows from a Query in PHP
How To Query Tables and Loop through the Returning Rows in PHP? The best way to query tables and loop through the returning rows is to run the SELECT statement with the catch the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_asso... 2016-10-19, ∼2502🔥, 0💬

Updating Existing Rows in PHP
How To Update Existing Rows in a Table in PHP? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: <?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET no... 2016-10-19, ∼2494🔥, 0💬

Querying Multiple Tables Jointly in PHP
How To Query Multiple Tables Jointly in PHP? If you want to query information stored in multiple tables, you can use the SELECT statement with a WHERE condition to make an inner join. Assuming that you have 3 tables in a forum system: "users" for user profile, "forums" for forums information, and "p... 2016-10-17, ∼2478🔥, 0💬

Performing Key Word Search in PHP
How To Perform Key Word Search in Tables in PHP? The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any number of... 2016-10-17, ∼2223🔥, 0💬

Quoting Text Values in PHP
How To Quote Text Values in SQL Statements in PHP? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one single... 2016-10-19, ∼2211🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.