Collections:
Execute SQL Statements in MySQL
How To Execute a SQL Statement in MySQL?
✍: 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'; $res = mysql_query($sql, $con); $row = mysql_fetch_array($res); 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-07-01 21:34:57
⇒ Managing Tables and Running Queries with PHP for MySQL
⇐ Selecting Other User's Database in MySQL
2017-10-23, 1424🔥, 0💬
Popular Posts:
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...