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, 1855🔥, 0💬
Popular Posts:
What Is HTML? HTML (HyperText Markup Language) is the standard markup language for creating Web page...
FYIcenter JSON Validator and Formatter is an online tool that checks for syntax errors of JSON text ...
How to use the "set-body" Policy Statement for an Azure API service operation? The "set-body" Policy...
How to use the XML to JSON Conversion Tool at freeformatter.com? If you want to try the XML to JSON ...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....