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, 1505🔥, 0💬
Popular Posts:
What is EPUB 2.0 Metadata "dc:publisher" and "dc:rights" elements? EPUB 2.0 Metadata "dc:publisher" ...
What properties and functions are supported on http.client.HTTPResponse objects? If you get an http....
How to include additional claims in Azure AD v2.0 id_tokens? If you want to include additional claim...
Where Is the Submitted Form Data Stored in PHP? When a user submit a form on your Web server, user e...
How to use the "@(...)" expression in Azure API Policy? The "@(...)" expression in Azure API Policy ...