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, 1245👍, 0💬
Popular Posts:
How to send an FTP request with the urllib.request.urlopen() function? If an FTP server supports ano...
How to create a new API on the Publisher Portal 2017 version of an Azure API Management Service? If ...
How to use "xsl-transform" Azure API Policy Statement? The "xsl-transform" Policy Statement allows y...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to login to Azure API Management Publisher Dashboard? If you have given access permission to an ...