Code: Select all
<?php
// Database Functions
function db($action,$sql){
if ($action=="connect")
mysql_connect("$db_host", "$db_user", "$db_password");
elseif ($action=="connection")
mysql_connect("$db_host", "$db_user", "$db_password");
elseif ($action=="disconnect")
mysql_close($db_connect);
elseif ($action=="test")
if (!mysql_connect("$db_host", "$db_user", "$db_password"))
die('Cannot connect to database: ' . mysql_error());
elseif (mysql_connect("$db_host", "$db_user", "$db_password"))
echo('Connection seems to be active');
else
echo('Cannot tell whether database is connected or not :S How strange!');
elseif($action=="createtable")
if ($sql)
mysql_select_db($db_name,mysql_connect("$db_host", "$db_user", "$db_password"));
mysql_query($sql,mysql_connect("$db_host", "$db_user", "$db_password"));
else
echo('Please Provide SQL');
elseif ($action=="validate")
echo("validate");
else
echo('Invalid request');
}
?>Code: Select all
db(connect,na);
db(createtable,"CREATE TABLE Persons(FirstName varchar(15),LastName varchar(15),Age int)");Code: Select all
Parse error: parse error in C:\xampp\htdocs\cms\inc\db.php on line 22