PHP mysql_query() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_query() function executes a query on a MySQL database.
This function returns the query handle for SELECT queries,
TRUE/FALSE for other queries, or FALSE on failure.
Syntax
mysql_query(query,connection)
|
| Parameter |
Description |
| query |
Required. Specifies the SQL query to send (should not end
with a semicolon) |
| connection |
Optional. Specifies the MySQL connection. If not specified,
the last connection opened by mysql_connect() or mysql_pconnect() is used. |
Tips and Notes
Note: This function fetches and buffers the recordset automatically.
To run an unbuffered query, use mysql_unbuffered_query() instead.
Example 1
<?php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql = "SELECT * FROM Person";
mysql_query($sql,$con);
// some code
mysql_close($con);
?>
|
Example 2
Create a new database with the mysql_query() function:
<?php
$con = mysql_connect("localhost","mysql_user","mysql_pwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql = "CREATE DATABASE my_db";
if (mysql_query($sql,$con))
{
echo "Database my_db created";
}
else
{
echo "Error creating database: " . mysql_error();
}
?>
|
Complete PHP MySQL Reference
 |
|
|
See why there are 20,000+ Ektron integrations worldwide.
Request an INSTANT DEMO or download a FREE TRIAL today. |
|
|
|
