Tools, FAQ, Tutorials:
Inserting Data into a Table in PHP
How To Insert Data into a Table in PHP?
✍: FYIcenter.com
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 (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } $sql = "INSERT INTO fyi_links (id, url) VALUES (" . " 102, 'dba.fyicenter.com')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print(mysql_errno($link).": ".mysql_error($link)."\n"); } mysql_close($con); ?>
Remember that mysql_query() returns integer/FALSE on INSERT statements. If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted.
⇒ Inserting Rows Based on SELECT Statement in PHP
⇐ Number of Rows Affected by a SQL Statement in PHP
2016-10-20, 1265👍, 0💬
Popular Posts:
What is EPUB 3.0 Metadata "dc:publisher" and "dc:rights" elements? EPUB 3.0 Metadata "dc:publisher" ...
How to Instantiate Chaincode on BYFN Channel? You can follow this tutorial to Instantiate Chaincode ...
How to view API details on the Publisher Dashboard of an Azure API Management Service? You can follo...
How To Get the Minimum or Maximum Value of an Array in PHP? If you want to get the minimum or maximu...
How To Use an Array as a Queue in PHP? A queue is a simple data structure that manages data elements...