papillonstudios Posted July 28, 2009 Share Posted July 28, 2009 ok i have been creating a install script for my cms, but well its not working right, and i dont know what is wrong i have went of the code many times, and tried different things and cant find whats wrong. heres the code for step 1 where the problem is <?php if (!defined('error_check')) die('You Cannot Access This Page From This Location'); //If the form hasn't been submitted, show it. if (!$_POST['post']) { ?> <form method="post"> <table width="75%"> <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr> <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr> <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr> <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr> <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr> </table> </form> <?php } //Or else it has been submitted... else { //Get information from the forms secure it all. $host= secure($_POST['host']); $db = secure($_POST['dname']); $dbuser = secure($_POST['dbuser']); $dbpass = secure($_POST['dbpass']); $connect = mysql_connect($host,$db,dbpass); if ($connect) { $select = mysql_select_db ($dbname); if ($select) { $users = "CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `location` varchar(50) NOT NULL, `aim` varchar(30) NOT NULL, `msn` varchar(30) default NULL, `gtalk` varchar(30) NOT NULL, `ip` varchar(30) NOT NULL, `signup` varchar(30) NOT NULL, `membergroup` varchar(30) NOT NULL, `bio` varchar(400) NOT NULL, PRIMARY KEY (`id`) );"; $permissions = " CREATE TABLE `permissions` ( mg_id INT(10) NOT NULL AUTO_INCREMENT, mg_name VARCHAR(50) NOT NULL, editprofile INT(1) NOT NULL, viewprofile INT(1) NOT NULL, admin INT(1) NOT NULL, moderate INT(1) NOT NULL, PRIMARY KEY (`mg_id`) );"; $addperm = " INSERT INTO `permissions` (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES (1, 'user', 1, 1, 0, 0), (2, 'admin', 1, 1, 1, 1), (3, 'guest', 0, 0, 0, 0); (4, 'mod', 1, 1, 0, 1); "; $info = "CREATE TABLE `info` ( `id` INT( 11 ) NOT NULL , `version` VARCHAR( 50 ) NOT NULL , `sitename` VARCHAR( 100 ) NOT NULL , `siteurl` VARCHAR( 100 ) NOT NULL , `sitedesc` TEXT NOT NULL , `aemail` VARCHAR( 300 ) NOT NULL , `emailink` VARCHAR( 300 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $news = "CREATE TABLE `news` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 50 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , `date` TIMESTAMP NOT NULL `body` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $nav = "CREATE TABLE `nav` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `linkname` VARCHAR( 50 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $donwloads = "CREATE TABLE `downloads` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 100 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , `date` VARCHAR( 20 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $games = "CREATE TABLE `games` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 20 ) NOT NULL , `source` VARCHAR( 100 ) NOT NULL , `gamedesc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM "; $mysqlfile = fopen('../defs.php', 'w+'); $content = " <?php //Database Information \n DEFINE ('DB_USER', '$dbuser'); \n DEFINE ('DB_PASSWORD', '$dbpass'); \n DEFINE ('DB_HOST', '$host'); \n DEFINE ('DB_NAME', '$db'); \n ?>"; header("Location: index.php?step=step2"); }else{ echo "Error message = ".mysql_error(); } }else{ echo "Error message = ".mysql_error(); } //A query to update everything } ?> i also have a example up on a server http://isustest.hostzi.com Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 What do you get on screen? Is there an error, blank screen.... Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 $db = secure($_POST['dname']); where is this function? secure() and there's a couple of little changes in this... <?php if (!defined('error_check')) die('You Cannot Access This Page From This Location'); //If the form hasn't been submitted, show it. if (isset($_POST['post'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> <input type="hidden" value="1" name="post" /> <table width="75%"> <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr> <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr> <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr> <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr> <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr> </table> </form> <?php } //Or else it has been submitted... else { //Get information from the forms secure it all. $host= secure($_POST['host']); $db = secure($_POST['dname']); $dbuser = secure($_POST['dbuser']); $dbpass = secure($_POST['dbpass']); $connect = mysql_connect($host,$db,dbpass); if ($connect) { $select = mysql_select_db ($dbname); if ($select) { $users = "CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `location` varchar(50) NOT NULL, `aim` varchar(30) NOT NULL, `msn` varchar(30) default NULL, `gtalk` varchar(30) NOT NULL, `ip` varchar(30) NOT NULL, `signup` varchar(30) NOT NULL, `membergroup` varchar(30) NOT NULL, `bio` varchar(400) NOT NULL, PRIMARY KEY (`id`) );"; $permissions = " CREATE TABLE `permissions` ( mg_id INT(10) NOT NULL AUTO_INCREMENT, mg_name VARCHAR(50) NOT NULL, editprofile INT(1) NOT NULL, viewprofile INT(1) NOT NULL, admin INT(1) NOT NULL, moderate INT(1) NOT NULL, PRIMARY KEY (`mg_id`) );"; $addperm = " INSERT INTO `permissions` (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES (1, 'user', 1, 1, 0, 0), (2, 'admin', 1, 1, 1, 1), (3, 'guest', 0, 0, 0, 0); (4, 'mod', 1, 1, 0, 1); "; $info = "CREATE TABLE `info` ( `id` INT( 11 ) NOT NULL , `version` VARCHAR( 50 ) NOT NULL , `sitename` VARCHAR( 100 ) NOT NULL , `siteurl` VARCHAR( 100 ) NOT NULL , `sitedesc` TEXT NOT NULL , `aemail` VARCHAR( 300 ) NOT NULL , `emailink` VARCHAR( 300 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $news = "CREATE TABLE `news` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 50 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , `date` TIMESTAMP NOT NULL `body` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $nav = "CREATE TABLE `nav` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `linkname` VARCHAR( 50 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $donwloads = "CREATE TABLE `downloads` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 100 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , `date` VARCHAR( 20 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $games = "CREATE TABLE `games` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 20 ) NOT NULL , `source` VARCHAR( 100 ) NOT NULL , `gamedesc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM "; $mysqlfile = fopen('../defs.php', 'w+'); $content = " <?php //Database Information \n DEFINE ('DB_USER', '$dbuser'); \n DEFINE ('DB_PASSWORD', '$dbpass'); \n DEFINE ('DB_HOST', '$host'); \n DEFINE ('DB_NAME', '$db'); \n ?>"; header("Location: index.php?step=step2"); }else{ echo "Error message = ".mysql_error(); } }else{ echo "Error message = ".mysql_error(); } //A query to update everything } ?> Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 with the way i code it doesnt show php errors but if theres a problem then it just doesn't show any after the error and thats what happening but the code syntax is right not sure whats wrong. to see what i mean go to http://isustest.hostzi.com Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 Turn errors on when you're developing. or do some checks in the code to see where its stopping and why it's stopping there. also... $db = secure($_POST['dname']); where is this function? secure() Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 ok i got the function put that i forgot about function secure($string) { $string = strip_tags($string); $string = htmlspecialchars($string); $string = trim($string); $string = stripslashes($string); return $string; } so now when i load the page i get this. Access denied for user 'GamingFusion'@'localhost' (using password: YES) its a MYDQL Error but im not doign anything with MYsql untill the button is clicked Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 Show your updated code Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 <?php if (!defined('error_check')) die('You Cannot Access This Page From This Location'); //If the form hasn't been submitted, show it. if (isset($_POST['post'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> <input type="hidden" value="1" name="post" /> <table width="75%"> <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr> <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr> <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr> <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr> <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr> </table> </form> <?php } //Or else it has been submitted... else { //Get information from the forms secure it all. $host= secure($_POST['host']); $db = secure($_POST['dname']); $dbuser = secure($_POST['dbuser']); $dbpass = secure($_POST['dbpass']); $connect = mysql_connect($host,$db,dbpass); if ($connect) { $select = mysql_select_db ($dbname); if ($select) { $users = "CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `location` varchar(50) NOT NULL, `aim` varchar(30) NOT NULL, `msn` varchar(30) default NULL, `gtalk` varchar(30) NOT NULL, `ip` varchar(30) NOT NULL, `signup` varchar(30) NOT NULL, `membergroup` varchar(30) NOT NULL, `bio` varchar(400) NOT NULL, PRIMARY KEY (`id`) );"; $permissions = " CREATE TABLE `permissions` ( mg_id INT(10) NOT NULL AUTO_INCREMENT, mg_name VARCHAR(50) NOT NULL, editprofile INT(1) NOT NULL, viewprofile INT(1) NOT NULL, admin INT(1) NOT NULL, moderate INT(1) NOT NULL, PRIMARY KEY (`mg_id`) );"; $addperm = " INSERT INTO `permissions` (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES (1, 'user', 1, 1, 0, 0), (2, 'admin', 1, 1, 1, 1), (3, 'guest', 0, 0, 0, 0); (4, 'mod', 1, 1, 0, 1); "; $info = "CREATE TABLE `info` ( `id` INT( 11 ) NOT NULL , `version` VARCHAR( 50 ) NOT NULL , `sitename` VARCHAR( 100 ) NOT NULL , `siteurl` VARCHAR( 100 ) NOT NULL , `sitedesc` TEXT NOT NULL , `aemail` VARCHAR( 300 ) NOT NULL , `emailink` VARCHAR( 300 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $news = "CREATE TABLE `news` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 50 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , `date` TIMESTAMP NOT NULL `body` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $nav = "CREATE TABLE `nav` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `linkname` VARCHAR( 50 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $donwloads = "CREATE TABLE `downloads` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 100 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , `date` VARCHAR( 20 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $games = "CREATE TABLE `games` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 20 ) NOT NULL , `source` VARCHAR( 100 ) NOT NULL , `gamedesc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM "; $mysqlfile = fopen('../defs.php', 'w+'); $content = " <?php //Database Information \n DEFINE ('DB_USER', '$dbuser'); \n DEFINE ('DB_PASSWORD', '$dbpass'); \n DEFINE ('DB_HOST', '$host'); \n DEFINE ('DB_NAME', '$db'); \n ?>"; header("Location: index.php?step=step2"); }else{ echo "Error message = ".mysql_error(); } }else{ echo "Error message = ".mysql_error(); } //A query to update everything } ?> Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 typo if (isset($_POST['post'])) { should be if (!isset($_POST['post'])) { Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 those typos the pop out of no where lol Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 has that fixed the problem? if yes please hit solved Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 ok now after filling out the form with proper information it gives me that error Error message = Access denied for user 'root'@'localhost' (using password: YES)Could not Connect Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 ok now after filling out the form with proper information it gives me that error What error? the db connect error? Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 ok i looked at the mysql_connect lesson on w3schools and i modified the code heres the new code. <?php if (!defined('error_check')) die('You Cannot Access This Page From This Location'); //If the form hasn't been submitted, show it. if (!isset($_POST['post'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> <input type="hidden" value="1" name="post" /> <table width="75%"> <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr> <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr> <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr> <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr> <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr> </table> </form> <?php } //Or else it has been submitted... else { //Get information from the forms secure it all. $host= secure($_POST['host']); $db = secure($_POST['dname']); $dbuser = secure($_POST['dbuser']); $dbpass = secure($_POST['dbpass']); $connect = mysql_connect($host,$dbuser,dbpass); if (!$con) { die('Could not connect: ' . mysql_error()); } $select = mysql_select_db ($dbname); if (!$con) { die('Could not Select: ' . mysql_error()); } $users = "CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `location` varchar(50) NOT NULL, `aim` varchar(30) NOT NULL, `msn` varchar(30) default NULL, `gtalk` varchar(30) NOT NULL, `ip` varchar(30) NOT NULL, `signup` varchar(30) NOT NULL, `membergroup` varchar(30) NOT NULL, `bio` varchar(400) NOT NULL, PRIMARY KEY (`id`) );"; $permissions = " CREATE TABLE `permissions` ( mg_id INT(10) NOT NULL AUTO_INCREMENT, mg_name VARCHAR(50) NOT NULL, editprofile INT(1) NOT NULL, viewprofile INT(1) NOT NULL, admin INT(1) NOT NULL, moderate INT(1) NOT NULL, PRIMARY KEY (`mg_id`) );"; $addperm = " INSERT INTO `permissions` (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES (1, 'user', 1, 1, 0, 0), (2, 'admin', 1, 1, 1, 1), (3, 'guest', 0, 0, 0, 0); (4, 'mod', 1, 1, 0, 1); "; $info = "CREATE TABLE `info` ( `id` INT( 11 ) NOT NULL , `version` VARCHAR( 50 ) NOT NULL , `sitename` VARCHAR( 100 ) NOT NULL , `siteurl` VARCHAR( 100 ) NOT NULL , `sitedesc` TEXT NOT NULL , `aemail` VARCHAR( 300 ) NOT NULL , `emailink` VARCHAR( 300 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $news = "CREATE TABLE `news` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 50 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , `date` TIMESTAMP NOT NULL `body` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $nav = "CREATE TABLE `nav` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `linkname` VARCHAR( 50 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $donwloads = "CREATE TABLE `downloads` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 100 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , `date` VARCHAR( 20 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $games = "CREATE TABLE `games` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 20 ) NOT NULL , `source` VARCHAR( 100 ) NOT NULL , `gamedesc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM "; $mysqlfile = fopen('../defs.php', 'w+'); $content = " <?php //Database Information \n DEFINE ('DB_USER', '$dbuser'); \n DEFINE ('DB_PASSWORD', '$dbpass'); \n DEFINE ('DB_HOST', '$host'); \n DEFINE ('DB_NAME', '$db'); \n ?>"; header("Location: index.php?step=step2"); } ?> heres the error i get when submitting the form with proper information for my local server. Could not connect: Access denied for user 'root'@'localhost' (using password: YES) Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 if (!$con) { die('Could not connect: ' . mysql_error()); } You don't use $con you uesa $connect if (!$connect) { die('Could not connect: ' . mysql_error()); } Though the fact that you're getting that error tells me there's more to come! Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 ok it connects and selects the database btu its not putting the tables in Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 I don't mind helping, but are you trying to fix this at all your self, or have you just given up? Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 i got it goin i forgot a piece at the end to run the mysql query to inert the table lol Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 UPDATE: Ok i got everything working except the redirect. but i can get that myself thanks dude Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 ok i modified it a bit and now its not working now. i need help i have triend it a different way and couldnt get it. it's not doing any of the mysql queries or anything index.php <?php include ('functions.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Isus 2.0 Install | Isus Reinvented</title> <link rel="stylesheet" type="text/css" href="install.css" /> </head> <body> <center> <div class="wrapper"> <div class="banner"> <img src="i/logo.png" alt="Isus 2.0 Install Script"/> </div> <div class="form" align="left"> <?php define('error_check', 1); $step = $_GET['step']; if($_GET['step'] == NULL) { include('welcome.php'); } else if ($_GET['step'] == 'step1') { include('steps/step1.php'); } else if ($_GET['step'] == 'step2') { include('steps/step2.php'); } else if ($_GET['step'] == 'step3') { include('steps/step3.php'); } ?> </div> <div class="info"> <?php echo 'Isus 2.0 Installer<br />'; echo 'Coded By: gfadmin(Chad Gregory)<br />'; echo 'Contributors: PHPFreaks users and Akura<br />'; echo '<p>Thanks everyone for helpin out.</p>'; ?> </div> </div> </center> </body> </html> step1.php <?php if (!defined('error_check')) die('You Cannot Access This Page From This Location'); //If the form hasn't been submitted, show it. if (!isset($_POST['post'])) { ?> <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post"> <input type="hidden" value="1" name="post" /> <table width="75%"> <tr><td>Host </td><td><input type="text" class="input" name="host" /></td></tr> <tr><td>Database Name </td><td><input type="text" class="input" name="db" /></td></tr> <tr><td>Database Username </td><td><input type="text" class="input" name="dbuser" /></td></tr> <tr><td>Database Password </td><td><input type="password" class="input" name="dbpass" /></td></tr> <tr><td><input type="submit" class="input" name="submit" value="Continue ->" /></td></tr> </table> </form> <?php } //Or else it has been submitted... else { //Get information from the forms secure it all. $host= secure($_POST['host']); $db = secure($_POST['db']); $dbuser = secure($_POST['dbuser']); $dbpass = secure($_POST['dbpass']); $connect = mysql_connect($host,$dbuser,dbpass); if (!connect) { die('Could not connect: ' . mysql_error()); } $select = mysql_select_db ($db); if (!$select) { die('Could not Select: ' . mysql_error()); } $users = "CREATE TABLE `users` ( `id` int(5) NOT NULL auto_increment, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(50) NOT NULL, `location` varchar(50) NOT NULL, `aim` varchar(30) NOT NULL, `msn` varchar(30) default NULL, `gtalk` varchar(30) NOT NULL, `ip` varchar(30) NOT NULL, `signup` varchar(30) NOT NULL, `membergroup` varchar(30) NOT NULL, `bio` varchar(400) NOT NULL, PRIMARY KEY (`id`) );"; $permissions = " CREATE TABLE `permissions` ( mg_id INT(10) NOT NULL AUTO_INCREMENT, mg_name VARCHAR(50) NOT NULL, editprofile INT(1) NOT NULL, viewprofile INT(1) NOT NULL, admin INT(1) NOT NULL, moderate INT(1) NOT NULL, PRIMARY KEY (`mg_id`) );"; $addperm = " INSERT INTO `permissions` (`mg_id`, `mg_name`, `editprofile`, `viewprofile`, `admin`, `moderate`) VALUES (1, 'user', 1, 1, 0, 0), (2, 'admin', 1, 1, 1, 1), (3, 'guest', 0, 0, 0, 0); (4, 'mod', 1, 1, 0, 1); "; $info = "CREATE TABLE `info` ( `id` INT( 11 ) NOT NULL , `version` VARCHAR( 50 ) NOT NULL , `sitename` VARCHAR( 100 ) NOT NULL , `siteurl` VARCHAR( 100 ) NOT NULL , `sitedesc` TEXT NOT NULL , `aemail` VARCHAR( 300 ) NOT NULL , `emailink` VARCHAR( 300 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $news = "CREATE TABLE `news` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `title` VARCHAR( 50 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , `date` TIMESTAMP NOT NULL `body` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $nav = "CREATE TABLE `nav` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `linkname` VARCHAR( 50 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $downloads = "CREATE TABLE `downloads` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT , `name` VARCHAR( 100 ) NOT NULL , `url` VARCHAR( 100 ) NOT NULL , `date` VARCHAR( 20 ) NOT NULL , `username` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM"; $games = "CREATE TABLE `games` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR( 20 ) NOT NULL , `source` VARCHAR( 100 ) NOT NULL , `gamedesc` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM "; mysql_query($users) or 'Couldn\'t create users table.'; mysql_query($permissons) or 'Couldn\'t create permissions table.'; mysql_query($addperm) or 'Couldn\'t insert data into permissions table.'; mysql_query($info) or 'Couldn\'t create info table.'; mysql_query($news) or 'Couldn\'t create news table.'; mysql_query($nav) or 'Couldn\'t create navigation table.'; mysql_query($downloads) or 'Couldn\'t create downloads table.'; mysql_query($games) or 'Couldn\'t create games table.'; $mysqlfile = fopen('defs.php', 'w+'); $content = " <?php //Database Information \n DEFINE ('DB_USER', '$dbuser'); \n DEFINE ('DB_PASSWORD', '$dbpass'); \n DEFINE ('DB_HOST', '$host'); \n DEFINE ('DB_NAME', '$db'); \n ?>"; fwrite($mysqlfile, $content); fclose($mysqlfile); echo 'Click the link below to continue'; echo ''.anchor ('index.php?step=step2'.'Continue ->').''; } ?> Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 You need to be more clear on your output, what happens when you attempt to run the script, what doesnt happen. And just as a starting point; mysql_query($users) or 'Couldn\'t create users table.'; should be mysql_query($users) or die('Couldn\'t create users table.'); Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 I ahve a welcome page that says click here to begin, when submitting the form it goes back to that welcome page and doesn't create the tables in the database or write data the file called defs.php Quote Link to comment Share on other sites More sharing options...
gevans Posted July 28, 2009 Share Posted July 28, 2009 Did you fix the problem I showed you? and the secure() function still isnt in the second script. Quote Link to comment Share on other sites More sharing options...
papillonstudios Posted July 28, 2009 Author Share Posted July 28, 2009 the function is included in the functions page [quote]<?php include('functions.php'); ?>[/quote] and yes i did fix that problem Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.