mysql_query()


Transmitting a SQL query string

Description

bool/string mysql_query(string $query)

Parameters

Return Value

Example

<?php
include_once "/lib/sn_dns.php";                 // include DNS library
include_once "/lib/sn_mysql.php";

$query_create_db = "CREATE DATABASE testdb;";   // SQL sentance to make a database
$query_drop_db = "DROP DATABASE testdb;";       // SQL sentance to delete a database

$server_addr = "192.168.0.100";                 // IP address of MySQL server
$user_name = "user_id";                         // MySQL ID
$password = "password";                         // MySQL password

// connect to a MySQL server
if(mysql_connect($server_addr, $user_name, $password) === false)
    exit(mysql_error());                        // print the error message and quit

if(mysql_query($query_create_db) === true)      // send a query to make a database
    echo "create db success!\r\n";
else
    exit(mysql_error());                        // print the error message and quit

if(mysql_query($query_drop_db) === true)        // send a query to delete the database
    echo "drop db success!\r\n";
else
    exit(mysql_error());                        // print the error message and quit

mysql_close();                                  // disconnecting from the MySQL server
?>

See also