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, 1361👍, 0💬
Popular Posts:
How To Open Standard Output as a File Handle in PHP? If you want to open the standard output as a fi...
How to convert JSON Objects to PHP Associative Arrays using the json_decode() function? Actually, JS...
How to include additional claims in Azure AD v2.0 id_tokens? If you want to include additional claim...
How to view API details on the Publisher Dashboard of an Azure API Management Service? You can follo...
Where to find tutorials on OpenID? Here is a large collection of tutorials to answer many frequently...