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
Â
⇒Working with MySQL Database in PHP
⇒⇒PHP Tutorials
2016-10-20, 1135👍, 0💬
Popular Posts:
Where to find tutorials on RSS specifications? I want to learn it to describe my API services. Here ...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to Instantiate Chaincode on BYFN Channel? You can follow this tutorial to Instantiate Chaincode ...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to Build my "sleep" Docker image from the Alpine image? I want the container to sleep for 10 hou...