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, 1561🔥, 0💬
Popular Posts:
How to use the "@(...)" expression in Azure API Policy? The "@(...)" expression in Azure API Policy ...
Where to find tutorials on EPUB file format? I want to know how to create EPUB books. Here is a larg...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to login to Azure API Management Publisher Dashboard? If you have given access permission to an ...
How To Read the Entire File into a Single String in PHP? If you have a file, and you want to read th...