| Formally Mikor. Name: Michael Walker Location: East Yorkshire, England Join Date: Aug 2005
Posts: 2,538
NP$: 163.25 ( Donate)
| 2 handy MySQL functions!
Functions: set_database_vars( $mysql_server, $mysql_username, $mysql_password, $database_name) - Stores the MySQL conenction information. Returns an error message if it fails. sql( $query) - Creates a mysql connection, queries the database, and closes the conenction. Returns the results if sucecssful, if it fails, it returns an error message. Code: PHP Code: <?php
$mod_db['Server'] = '';
$mod_db['Username'] = '';
$mod_db['Password'] = '';
$mod_db['Name'] = '';
function set_database_vars($server, $username, $password, $name){
$mod_db['Server'] = $server;
$mod_db['Username'] = $username;
$mod_db['Password'] = $password;
$mod_db['Name'] = $name;
return true;
}
function sql($query){
mysql_connect($mod_db['Server'], $mod_db['Username'], $mod_db['Password'], $mod_db['Name'])or return 'Error 1 - Please check your database variables are correct.<br /><br />';
$result = mysql_query($query)or return 'Error 2 - Please check your SQL query is correct for your version of MySQL.<br /><br />';
return $result;
mysql_close();
}
?>
Handy if you need to do a lot of queries - just include that code in a seperate file and you can query in 1 line of code.
|
