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, 1505🔥, 0💬
Popular Posts:
How to reinstall npm with a node version manager? I am getting permission errors with the current ve...
How to use the urllib.request.Request object to build more complex HTTP request? The urllib.request....
How to add request query string Parameters to my Azure API operation to make it more user friendly? ...
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...
Can Multiple Paragraphs Be Included in a List Item? Yes. You can include multiple paragraphs in a si...