i have a code that create the mysql tables in my defined database. It is working very fine on my localhost but when i test is on my web server it does nothing
i want to create the database tables automatically through running a php script. here is my code.
please help me. Thanks in Advance
Code: Select all
<?php
$h = $_REQUEST['dbhost'];
$d = $_REQUEST['dbname'];
$u = $_REQUEST['dbuname'];
$p = $_REQUEST['dbpass'];
$connection = mysql_connect($h, $u, $p) or die ("Unable to connect to web server, invalid username or password!");
mysql_select_db($d) or die ("Unable to select database!");
if (mysql_num_rows(mysql_query("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '". $d ."'"))) {
mysql_select_db("$d");
mysql_query("CREATE TABLE table (...)");
$vlsSql = "
CREATE TABLE `banners` (
`bannerid` int(11) NOT NULL AUTO_INCREMENT,
`bannertitle` varchar(200) DEFAULT NULL,
`bannerimage` varchar(250) DEFAULT NULL,
`bannerlink` varchar(250) DEFAULT NULL,
`published` int(11) DEFAULT NULL,
`aadedon` varchar(80) DEFAULT NULL,
`updatedon` varchar(80) DEFAULT NULL,
PRIMARY KEY (`bannerid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
INSERT INTO banners VALUES ('1', null, 'uploads/banners/Untitled_2.png', '#', '1', null, null);
CREATE TABLE `pagesetting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(150) DEFAULT NULL,
`description` text,
`active` int(11) DEFAULT NULL,
`updatedon` varchar(80) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
INSERT INTO pagesetting VALUES ('1', 'Meta Page Title', 'My Landing Page', '1', '2011/09/08 16:51:34');
INSERT INTO pagesetting VALUES ('2', 'Meta Page Keywords', 'landing, page, seo, sem, search, engine, marketing, search, engine, optimization, page, ranking, back, links, advertisement', '1', '2011/09/08 16:51:34');
INSERT INTO pagesetting VALUES ('3', 'Meta Page Description', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '1', '2011/09/08 16:51:34');
INSERT INTO pagesetting VALUES ('4', 'Logo', 'uploads/logo/logo.jpg', '1', null);
INSERT INTO pagesetting VALUES ('5', 'Slogan', 'My website slogan lorem ipsum', '1', '2011/09/08 17:44:28');
INSERT INTO pagesetting VALUES ('6', 'Page Background', 'uploads/pagebg/jean_victor_balin_dove_clip_art_22251.jpg', '1', null);
INSERT INTO pagesetting VALUES ('7', 'Inner Container Background', 'uploads/innerbg/grey.jpg', '1', null);
INSERT INTO pagesetting VALUES ('8', 'Banner Status', 'Banner setting (Show/Hide)', '1', null);
INSERT INTO pagesetting VALUES ('9', 'Call Us', '21212-432456', '1', '2011/09/08 17:59:13');
INSERT INTO pagesetting VALUES ('10', 'Footer', 'Copyrights © All rights reserved', '1', '2011/09/09 17:41:48');
INSERT INTO pagesetting VALUES ('11', 'Open Close', 'Mon-Fri 9:30am - 5:30pm | Sat 11:00am – 2:00pm', '1', '2011/09/09 18:12:01');
CREATE TABLE `users` (
`userid` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(150) DEFAULT NULL,
`loginid` varchar(15) NOT NULL DEFAULT '',
`password` varchar(12) DEFAULT NULL,
`securitylevel` int(2) DEFAULT '10',
`active` int(2) DEFAULT '-1',
PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=7863 DEFAULT CHARSET=latin1;
INSERT INTO users VALUES ('7862', 'Admin', 'admin', '".$p."', '1', '1');
";
$vlaSql = explode (";\r", $vlsSql);
foreach ($vlaSql as $vlsSql)
{
if ($vlsSql != "")
$vlsResult = mysql_query ($vlsSql);
}
header('location:create_config_file.php?status=success');
}
else {
echo "Database ($d) not found on your server, Please first create the database and user.";
}
?>