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, 1980🔥, 0💬
Popular Posts:
How to add an API to an API product for internal testing on the Publisher Portal of an Azure API Man...
How to attach console to a Running Container using the "docker container exec" command? I want to ge...
How to use "link" command tool to link objet files? If you have object files previously compiled by ...
Where to find tutorials on JSON (JavaScript Object Notation) text string format? I want to know how ...
How to use the JSON to XML Conversion Tool at utilities-online.info? If you want to try the JSON to ...