Tools, FAQ, Tutorials:
Running a SQL Statement in PHP
How To Run a SQL Statement in PHP?
✍: FYIcenter.com
You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status:
Here is a good example of running a SQL statement with the mysql_query() function:
<?php include "mysql_connection.php"; $sql = 'SELECT sysdate() FROM dual'; $rs = mysql_query($sql, $con); $row = mysql_fetch_array($rs); print("Database current time: ". $row[0] ."\n"); mysql_close($con); ?>
If you run this script, you will get something like this:
Database current time: 2006-02-26 21:34:57
⇐ Selecting an Existing Database in PHP
2016-10-20, 1615🔥, 0💬
Popular Posts:
Where to get the detailed description of the json_encode() Function in PHP? Here is the detailed des...
FYIcenter.com Online Tools: FYIcenter JSON Validator and Formatter FYIcenter JSON to XML Converter F...
How To Protect Special Characters in Query String in PHP? If you want to include special characters ...
How to start Visual Studio Command Prompt? I have Visual Studio 2017 Community version with Visual C...
How to add request URL Template Parameters to my Azure API operation to make it more user friendly? ...