Jump to content

DeanWhitehouse

Members
 View Profile  See their activity

  • Posts

    2,527

  • Joined

  • Last visited

 Content Type 

Everything posted by DeanWhitehouse

  1. DeanWhitehouse
    ok, thanks, can you give me an example of how to use this, as i am not very good with loops
  2. DeanWhitehouse
    how can i start a new line after every three database entry's ? here is my code <div id="body"> <?php if (isset($_GET['image_id'])) { if ((int) $_GET['image_id'] > 0) { $imageid = $_GET['image_id']; $sql = "SELECT * FROM hayleyimages WHERE image_id=$imageid"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); $imageprofname = $row['image_name']; $imageprofcaption = $row['image_caption']; $imageproflink = $row['image_link']; if(mysql_num_rows($result) > 0) { ?> <table align="center" border="1"><th><?php echo "$imageprofname"; ?></th> <tr><td><?php echo '<a href="'.$row['image_link'].'" rel="lightbox" title="'.$row['image_caption']. '" ><img src="'.$row['image_link'].'"width="200px" /></a>'; ?></td><td width="200px"><?php echo 'Image ID :'.$row['image_id'].''; ?></td></tr><tr><td><?php echo ' '.$row['image_caption']. ' </a>'; ?></td></tr></table> <?php } if (mysql_num_rows($result) < 1) { echo 'This ID does not exist in the database<br>'; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } exit(); } else { echo "Unknown Image ID! <br />"; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } } //No ID passed to page, display user list: $query = "SELECT image_id, image_name, image_link, image_caption FROM `hayleyimages`"; $result = mysql_query($query) or die("Error:" . mysql_error()); if (mysql_num_rows($result) > 0) { ?> <table border="1"><th>Images</th> <?php while($row=mysql_fetch_array($result)){ // Start looping table row ?> <tr><td><?php echo ' <a href="?image_id='.$row['image_id'].'">'.$row['image_name']. ' Details</a>'; ?></td><td><?php echo ' <a href="'.$row['image_link'].'" rel="lightbox [main]" title="'.$row['image_caption']. '" >'.$row['image_name']. ' </a>'; ?></td><td><?php echo ' <img src="'.$row['image_link'].'"width="150px" /></a>'; ?></td></tr> <?php } ?> </table> <?php if (mysql_num_rows($result) < 1) { echo "No Images To Display"; } } mysql_close(); ?> </div> </body> </html>
  3. DeanWhitehouse
    BUMP anyone?
  4. DeanWhitehouse
    ok, soz, i am still learning. Is it just the content not loading?
  5. DeanWhitehouse
    they shouldn't affect it , are they closed?
  6. DeanWhitehouse
    what are the HTML tags in the database? also try this ?> <div class="editor" style="text-align: center"> <p class="editortitle" style="font-size: 175%; padding: 4px 0px 4px 0px; margin: 0px;">Welcome Letter</p> <textarea cols="80" rows="25" name="welcome"><?php echo"" . $row['welcome'] . ""; ?></textarea> </div> <?php
  7. DeanWhitehouse
    with this code i need to have pagination for it, and i need it so only 3 images a row on the page. so like , |image1|image2|image3| instead of image1 image2 image3 this is my code <!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=iso-8859-1" /> <title>Hayley - Home</title> <script type="text/javascript" src="js/prototype.js"></script> <script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script> <script type="text/javascript" src="js/lightbox.js"></script> <link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" /> <link rel="stylesheet" href="css/style.css" type="text/css" media="screen" /> </head> <body> <div id="body"> <?php if (isset($_GET['image_id'])) { if ((int) $_GET['image_id'] > 0) { $imageid = $_GET['image_id']; $sql = "SELECT * FROM hayleyimages WHERE image_id=$imageid"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); $imageprofname = $row['image_name']; $imageprofcaption = $row['image_caption']; $imageproflink = $row['image_link']; if(mysql_num_rows($result) > 0) { ?> <table align="center" border="1"><th><?php echo "$imageprofname"; ?></th> <tr><td><?php echo '<a href="'.$row['image_link'].'" rel="lightbox" title="'.$row['image_caption']. '" ><img src="'.$row['image_link'].'"width="200px" /></a>'; ?></td><td width="200px"><?php echo 'Image ID :'.$row['image_id'].''; ?></td></tr><tr><td><?php echo ' '.$row['image_caption']. ' </a>'; ?></td></tr></table> <?php } if (mysql_num_rows($result) < 1) { echo 'This ID does not exist in the database<br>'; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } exit(); } else { echo "Unknown Image ID! <br />"; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } } //No ID passed to page, display user list: $query = "SELECT image_id, image_name, image_link, image_caption FROM `hayleyimages`"; $result = mysql_query($query) or die("Error:" . mysql_error()); if (mysql_num_rows($result) > 0) { while($row=mysql_fetch_array($result)){ // Start looping table row ?> <table border="1"><th>Images</th> <tr><td><?php echo ' <a href="?image_id='.$row['image_id'].'">'.$row['image_name']. ' Details</a>'; ?></td><td><?php echo ' <a href="'.$row['image_link'].'" rel="lightbox [main]" title="'.$row['image_caption']. '" >'.$row['image_name']. ' </a>'; ?></td><td><?php echo ' <img src="'.$row['image_link'].'"width="200px" /></a>'; ?><br /></td></tr> </table> <?php } if (mysql_num_rows($result) < 1) { echo "No Images To Display"; } } mysql_close(); ?> </div> </body> </html>
  8. DeanWhitehouse
    AJAX?
  9. DeanWhitehouse
    i found this on the net. <? if(isset($HTTP_COOKIE_VARS["users_resolution"])) $screen_res = $HTTP_COOKIE_VARS["users_resolution"]; else //means cookie is not found set it using Javascript { ?> <script language="javascript"> <!-- writeCookie(); function writeCookie() { var today = new Date(); var the_date = new Date("December 31, 2023"); var the_cookie_date = the_date.toGMTString(); var the_cookie = "users_resolution="+ screen.width +"x"+ screen.height; var the_cookie = the_cookie + ";expires=" + the_cookie_date; document.cookie=the_cookie location = 'get_resolution.php'; } //--> </script> <? } ?> or this Put this on the page: <script language="javascript"> window.location.href = "screen.php?width=" + screen.width + "&height=" + screen.height; </script> Then create a file called screen.php and use this: <?php $width = $_GET['width']; $height = $_GET['height']; echo "You are using a $width x $height screen resolution"; ?>
  10. DeanWhitehouse
    just changed some of the variables, therefore fixed. Thanks for tidying up the code a bit.
  11. DeanWhitehouse
    this is my code <?php if (isset($_GET['image_id'])) { if ((int) $_GET['image_id'] > 0) { $imageid = $_GET['image_id']; $sql = "SELECT * FROM `hayleyimages` WHERE `image_id`='{$imageid}' LIMIT 0,1;"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); $imageprofname = $row['image_name']; $imageprofcaption = $row['image_caption']; $imageproflink = $row['image_link']; echo "$imageprofname<br>$imageprofcaption<br>"; ?> <table align="center" border="1"><th>Image<?php echo "$imageprofname"; ?></th> <tr><td><?php echo ' <img src="'.$rows['image_link'].'"width="200px" /></a>'; ?></td><td><?php echo 'ID'.$rows['image_id'].''; ?></td></tr><td><?php echo ' <a href="'.$rows['image_link'].'" rel="lightbox" title="'.$rows['image_caption']. '" >'.$rows['image_name']. ' </a>'; ?></td><td><br /></td></tr> </table> <?php if (mysql_num_rows($result) < 1) { echo 'This ID does not exist in the database<br>'; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } exit(); } else { echo "Unknown Image ID! <br />"; echo "<a href=\"index.php\">Return to Image Page</a>"; exit(); } } //No ID passed to page, display user list: $query = "SELECT image_id, image_name, image_link, image_caption FROM `hayleyimages`"; $result = mysql_query($query) or die("Error:" . mysql_error()); if (mysql_num_rows($result) > 0) { while($rows=mysql_fetch_array($result)){ // Start looping table row ?> <table align="center" border="1"><th>Images</th> <tr><td><?php echo ' <a href="?image_id'.$rows['image_id'].'">'.$rows['image_name']. ' Details</a>'; ?></td><td><?php echo ' <a href="'.$rows['image_link'].'" rel="lightbox" title="'.$rows['image_caption']. '" >'.$rows['image_name']. ' </a>'; ?></td><td><?php echo ' <img src="'.$rows['image_link'].'"width="200px" /></a>'; ?><br /></td></tr> </table> <?php } if (mysql_num_rows($result) < 1) { echo "No Images To Display"; } } mysql_close(); ?> But this is not working, the page has a table with a dynamic link in it, this links address is http://hayley.awardspace.com?image_id(then the image id number) but when you click on the link it has the same content, it shouldn't. the URL changes in the address bar, but the page remains unchanged . any ideas?
  12. DeanWhitehouse
    how can i get the name of an uploaded file, this is my code <?php if(isset($_POST['upload'])) { $target = "images/"; $image = $_POST['uploaded']; $imagename = $_POST['imagename']; $imagecaption = $_POST['imagecaption']; $user_check = mysql_num_rows(mysql_query("SELECT * FROM `hayleyimages` WHERE image_name = 1 ")); $target = $target . basename( $_FILES['uploaded']['name']) ; $ok=1; //This is our size condition if ($uploaded_size > 350000) { echo "Your file is too large.<br>"; $ok=0; } //This is our limit file type condition if ($uploaded_type =="text/php") { echo "No PHP files<br>"; $ok=0; } //Here we check that $ok was not set to 0 by an error if ($ok==0) { Echo "Sorry your file was not uploaded"; } if($user_check >= 1) { echo "$imagename already exists, please rename it."; } //If everything is ok we try to upload it else { //if($image && $imagename && $imagecaption) //{ mysql_query("INSERT INTO `hayleyimages` (image_link, image_name, image_caption, image_id) VALUES ( '$image','$imagename','$imagecaption', '')") or die('Error ' . mysql_error()); if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; } else { echo "Sorry, there was a problem uploading your file."; } //} //else //{ //echo "<br>Please make sure all fields are filled in."; //} } } ?> <form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">Image Name: <input type="text" name="imagename" /><br />Image Caption: <input type="text" name="imagecaption" /><br /> Please choose a file: <input name="uploaded" type="file" /><br /> <input type="submit" value="Submit" name="upload" /> </form> this "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; only echos The file has been uploaded
  13. DeanWhitehouse
    how can i get the name of the uploaded file (and the extension e.g. jpg)?
  14. DeanWhitehouse
    ok, i solved that part now for this problem <?php if(isset($_POST['upload'])) { $target = "images/"; $image = basename( $_FILES['uploadedfile']['name']); $imagename = $_POST['imagename']; $imagecaption = $_POST['imagecaption']; $image_thumb = '<img src='.$image.' width="200px"/>'; $image_link = '<a href='.$image.' rel="lightbox" title='.$imagecaption.'>'.$imagename.'</a>'; $user_check = mysql_num_rows(mysql_query("SELECT * FROM `hayleyimages` WHERE image_name=1 ")); $target = $target . basename( $_FILES['uploaded']['name']) ; $ok=1; //This is our size condition if ($uploaded_size > 350000) { echo "Your file is too large.<br>"; $ok=0; } //This is our limit file type condition if ($uploaded_type =="text/php") { echo "No PHP files<br>"; $ok=0; } //Here we check that $ok was not set to 0 by an error if ($ok==0) { Echo "Sorry your file was not uploaded"; } if($user_check >= 1) { echo "$imagename already exists, please rename it."; } //If everything is ok we try to upload it else { //if($image && $imagename && $imagecaption) //{ mysql_query("INSERT INTO `hayleyimages` (image_link, image_name, image_caption, image_id, image_thumb) VALUES ('$image_link','$imagename','$imagecaption', '', '$image_thumb')") or die('Error ' . mysql_error()); if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; } else { echo "Sorry, there was a problem uploading your file."; } //} //else //{ //echo "<br>Please make sure all fields are filled in."; //} } } ?> <form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">Image Name: <input type="text" name="imagename" /><br />Image Caption: <input type="text" name="imagecaption" /><br /> Please choose a file: <input name="uploaded" type="file" /><br /> <input type="submit" value="Submit" name="upload" /> </form> </body> </html> these two bits $image_thumb = '<img src='.$image.' width="200px"/>'; $image_link = '<a href='.$image.' rel="lightbox" title='.$imagecaption.'>'.$imagename.'</a>'; are being inserted to the database as <a href= rel="lightbox" title=test>test</a> <img src= width="200px"/> without links , and title=test should be title="test" does anyone know how to fix this
  15. DeanWhitehouse
    this is my code <?php if(isset($_POST['upload'])) { $target = "images/"; $image = basename( $_FILES['uploadedfile']['name']); $imagename = $_POST['imagename']; $imagecaption = $_POST['imagecaption']; $image_thumb = "<img src='$image' width='200px'/>"; $image_link = '<a href='.$image.' rel="lightbox" title='.$imagecaption.'>'.$imagename.'</a>'; $user_check = mysql_num_rows(mysql_query("SELECT * FROM `hayleyimages` WHERE image_name=1 ")); $target = $target . basename( $_FILES['uploaded']['name']) ; $ok=1; //This is our size condition if ($uploaded_size > 350000) { echo "Your file is too large.<br>"; $ok=0; } //This is our limit file type condition if ($uploaded_type =="text/php") { echo "No PHP files<br>"; $ok=0; } //Here we check that $ok was not set to 0 by an error if ($ok==0) { Echo "Sorry your file was not uploaded"; } if($user_check >= 1) { echo "$imagename already exists, please rename it."; } //If everything is ok we try to upload it else { //if($image && $imagename && $imagecaption) //{ mysql_query("INSERT INTO `hayleyimages` (image_link, image_name, image_caption, image_id) VALUES ('$image_link','$imagename','$imagecaption', '')") or die('Error ' . mysql_error()); if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; } else { echo "Sorry, there was a problem uploading your file."; } //} //else //{ //echo "<br>Please make sure all fields are filled in."; //} } } ?> <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">Image Name: <input type="text" name="imagename" /><br />Image Caption: <input type="text" name="imagecaption" /></form> <form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF'] ?>" method="POST"> Please choose a file: <input name="uploaded" type="file" /><br /> <input type="submit" value="Submit" name="upload" /> </form> </body> </html> i have already connected to the database, and the file inserts properly , but it doesn't seem to insert the name and caption into the database. Can anybody see why?
  16. DeanWhitehouse
    ok , i have found this one and i will use this one, if anyone can recomend a better one, i am open for suggestions. http://php.about.com/od/advancedphp/ss/php_file_upload_5.htm
  17. DeanWhitehouse
    This will sound stupid, but how can i make an upload form and script. I looked at a few tutorials (w3 schools, tizag) and i didn't really get them. can anyone explain the code for it, i think with that i can make my own.
  18. DeanWhitehouse
    just a quick quest, how do i check if an email is sent? this is my email code $to = $user_email; $subject = 'Welcome,'$user_name; $message = "Hello,$user_name<br> welcome to the Random Game Design Template System<br> Congratulations on succesfully creating your site. This email can be fully customised in the admin centre $homepage."; $headers = 'From: RGD TS' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers); can i just add if(mail() { //my code } else { }
  19. DeanWhitehouse
    yer, i had , i had just noticed, i had them typed so that they would be correct in the .inc.php file.
  20. DeanWhitehouse
    still having a problem with this, this is my code variables $mainpage = "/home.php"; $sitetitle = "Random Template System"; $homepage = "http://" . $_SERVER["SERVER_NAME"]; $titlepage = "http://" . $_SERVER["SERVER_NAME"].$mainpage; $customheader = "<a class='title' href='$home_page.$main_page'>$site_title</a>"; $h_ome = "Home"; $int_ro = "Welcome, this is a test of the sites features.Please go to the admin centre to cutomize the site."; $wel_come = wordwrap($intro, 70, "<br />\n", true); $di_sc = "This is the site disclaimer. Here is where most sites have copyright information and other things."; $sitedisclaimer = wordwrap($disc, 130, "<br />\n", true); $st_yle = "style.css"; and this is what is wrote <?php $home_page = "http://deanwhitehouse.awardspace.co.uk"; $main_page = "/home.php"; $site_title = "Random Template System"; $title_page = "http://deanwhitehouse.awardspace.co.uk/home.php"; $custom_header = "<a class='title' href='.'></a>"; $home = "Home"; $intro = "Welcome, this is a test of the sites features.Please go to the admin centre to cutomize the site."; $style = "style.css"; $site_disclaimer = ""; $disc = "This is the site disclaimer. Here is where most sites have copyright information and other things."; $welcome = ""; ?> the writing code <?php // Random Game Design: PHP Website Template // Version 1 // Copyright Dean Whitehouse, 2008 require_once 'install.php'; $config_file = "../includes/main.inc.php"; $fw=fopen($config_file,"w+") or die("Unable to open file!"); // Unable to open file $config_homepg = "\$home_page = \"".$homepage."\";\n"; $config_main = "\$main_page = \"".$mainpage."\";\n"; $config_title = "\$site_title = \"".$sitetitle."\";\n"; $config_titlepg = "\$title_page = \"".$titlepage."\";\n"; $config_customhead = "\$custom_header = \"".$customheader."\";\n"; $config_home2 = "\$home = \"".$h_ome."\";\n"; $config_intro = "\$intro = \"".$int_ro."\";\n"; $config_welcome = "\$welcome = \"".$wel_come."\";\n"; $config_disc = "\$disc = \"".$di_sc."\";\n"; $config_sitedisc = "\$site_disclaimer = \"".$sitedisclaimer."\";\n"; $config_style = "\$style = \"".$st_yle."\";\n"; $config_write = $config_homepg.$config_main.$config_title.$config_titlepg.$config_customhead.$config_home2.$config_intro.$config_style.$config_sitedisc.$config_disc.$config_welcome; fwrite($fw, "<?php\n".$config_write."\n?>"); fclose($fw); ?>
  21. DeanWhitehouse
    i am trying to write this to a file this is only an extract of the code $mainpage = "/home.php"; $sitetitle = "Random Template System"; $homepage = "http://" . $_SERVER["SERVER_NAME"]; $titlepage = "http://" . $_SERVER["SERVER_NAME"].$mainpage; $customheader = '<a class="title" href="$home_page.$main_page">$site_title</a>'; $h_ome = "Home"; $int_ro = "Welcome, this is a test of the sites features.Please go to the admin centre to cutomize the site."; $wel_come = 'wordwrap($intro, 70, "<br />\n", true)'; $di_sc = "This is the site disclaimer. Here is where most sites have copyright information and other things."; $sitedisclaimer = 'wordwrap($disc, 130, "<br />\n", true)'; $st_yle = "style.css"; this is the code i am using to write it <?php // Random Game Design: PHP Website Template // Version 1 // Copyright Dean Whitehouse, 2008 require_once 'install.php'; $config_file = "../includes/main.inc.php"; $fw=fopen($config_file,"w+") or die("Unable to open file!"); // Unable to open file $config_homepg = "\$home_page = \"".$homepage."\";\n"; $config_main = "\$main_page = \"".$mainpage."\";\n"; $config_title = "\$site_title = \"".$sitetitle."\";\n"; $config_titlepg = "\$title_page = \"".$titlepage."\";\n"; $config_customhead = "\$custom_header = \"".$customheader."\";\n"; $config_home2 = "\$home = \"".$h_ome."\";\n"; $config_intro = "\$intro = \"".$int_ro."\";\n"; $config_welcome = "\$welcome = \"".$wel_come."\";\n"; $config_disc = "\$disc = \"".$di_sc."\";\n"; $config_sitedisc = "\$site_disclaimer = \"".$sitedisclaimer."\";\n"; $config_style = "\$style = \"".$st_yle."\";\n"; $config_write = $config_homepg.$config_main.$config_title.$config_titlepg.$config_customhead.$config_home2.$config_intro.$config_style.$config_sitedisc.$config_disc.$config_welcome; fwrite($fw, "<?php\n".$config_write."\n?>"); fclose($fw); ?> i can't seem to write some of the variables properly these are the one's that don't work $custom_header = "<a class="title" href="$home_page.$main_page">$site_title</a>"; $site_disclaimer = "wordwrap($disc, 130, "<br />\n", true)"; $welcome = "wordwrap($intro, 70, "<br />\n", true)"; i get a page error when viewing a page using the custom_header variable. can anyone help?
  22. DeanWhitehouse
    yer, but i have a quick fix solution. this is what i am using now <?php // Random Game Design: PHP Website Template // Version 1 // Copyright Dean Whitehouse, 2008 ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['table_names'])) { require_once '../includes/db_connect.php'; $dbhost = $_POST["dbhost"]; $user = $_POST["user"]; $forum_quest = $_POST["forum_question"]; $forum_answ = $_POST ["forum_answers"]; if ($user.$forum_quest.$forum_answ) { require_once "config_writetable.php"; echo "Table details saved:<br>User details saved: $user<br>Forum Questions saved: $forum_quest<br>Forum Answers saved: $forum_answ"; ?> <p>Table name's saved, press continue to create the table.<form action="<?php $_SERVER['PHP_SELF'] ?>?stage3" method="post"> <input type='submit' value='Continue' name='table_saved'> </form> </p> <?php } else { echo ("Please go back and fill in the required fields"); } mysql_close(); exit(); } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['table_saved'])) { require_once '../includes/db_connect.php'; require_once '../includes/config_table.inc.php'; mysql_connect($dbhost,$dbuser,$dbpass) or die('Could not connect: ' . mysql_error()); // Select database mysql_select_db($dbname) or die('Could not find the database: ' . mysql_error()); $sql_user = "CREATE TABLE $user( user_id int(11) AUTO_INCREMENT NOT NULL PRIMARY KEY, user_name varchar(100) NOT NULL, user_password varchar(100) NOT NULL, user_email varchar(100) NOT NULL, user_ip varchar(20) NOT NULL, user_ban varchar(3) NOT NULL, ban_reason varchar(100) NOT NULL, ban_length varchar(25) NOT NULL, userlevel tinyint(1) unsigned NOT NULL, random_key varchar(32) NOT NULL, user_activated varchar(25) NOT NULL, show_email int(1) NOT NULL )"; $sql_forum1 = "CREATE TABLE $forum_quest( id int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, topic varchar(255) NOT NULL default '', detail longtext NOT NULL, name varchar(65) NOT NULL default '', email varchar(65) NOT NULL default '', datetime varchar(25) NOT NULL default '', view int(4) NOT NULL default '0', reply int(4) NOT NULL default '0' )"; $sql_forum2 = "CREATE TABLE $forum_answ( question_id int(4) NOT NULL default '0', a_id int(4) NOT NULL default '0', a_name varchar(65) NOT NULL default '', a_email varchar(65) NOT NULL default '', a_answer longtext NOT NULL, a_datetime varchar(25) NOT NULL default '', KEY a_id (`a_id`) )"; $make_user= mysql_query($sql_user); $make_forum = mysql_query($sql_forum1); $make_forum1 = mysql_query($sql_forum2); $checkifexist_user = mysql_query ("SELECT * FROM '$user' LIMIT 0,1"); $checkifexist_quest = mysql_query ("SELECT * FROM '$forum_quest' LIMIT 0,1"); $checkifexist_answ = mysql_query ("SELECT * FROM '$forum_answ' LIMIT 0,1"); if (!$make_user) { echo("'$user' Table already exists.<br>'$user' table could not be created.<br>"); } else { echo("'$user' Table Created.<br>"); } if (!make_forum) { echo("'$forum_quest' Table already exists.<br>'$forum_quest' table could not be created.<br>"); } else { echo("'$forum_quest' Table Created.<br>"); } if (!make_forum1) { echo("'$forum_quest' Table already exists.<br>'$forum_quest' table could not be created.<br>"); } else { echo("'$forum_answ' Table Created.<br>"); } ?><form action="<?php $_SERVER['PHP_SELF'] ?>?stage4" method="post"> <input type="submit" value="Continue" name="continue_saved"/> <? mysql_close(); exit(); } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['continue_saved'])) { require_once '../includes/db_connect.php'; ?> <html> <table bgcolor='#999999' align='center' width="400px"> <form action="<?php $_SERVER['PHP_SELF']; ?>?stage5" method="POST"> <tr><td width="10px">Username: </td><td><input type='text' name='user_name' maxlength="20" width="400px" /><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">E-mail Address:</td> <td><input type='text' name='user_email' /><br /></td></tr> <tr><td width="10px">Confirm E-mail Address: </td><td><input type='text' name='user_email2'/><br /></td></tr> <tr><td width="10px">Password:</td><td> <input type='password' name='user_password' maxlength="30"/><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">Confirm Password:</td><td> <input type='password' name='user_password2' maxlength="30" /><br /></td></tr> <tr><td><input type='submit' value='Complete Registration' name='admin_signup' /></td><td><input type="reset" value="Reset Fields" name="reset" /></td></tr> </form> </table> </html> <?php mysql_close(); exit(); } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['admin_signup'])){ require_once '../includes/db_connect.php'; $user_name = mysql_real_escape_string($_POST["user_name"]); $user_password =mysql_real_escape_string($_POST["user_password"]); $user_password2 =mysql_real_escape_string ($_POST["user_password2"]); $user_email =mysql_real_escape_string ($_POST["user_email"]); $user_email2 =mysql_real_escape_string ($_POST["user_email2"]); $ip = $_SERVER['REMOTE_ADDR']; $checkpw = $user_password == $user_password2; $checkem = $user_email == $user_email2; if ($user_name && $user_password && $user_password2 && $user_email && $user_email2) { $user_check = mysql_num_rows(mysql_query("SELECT * FROM `$user` WHERE userlevel=1 ")); $length = strlen($user_password); $length1 = strlen($user_name); if ($length >= 6) { if ($length1 >= 4) { if ($user_check >= 1) { echo "Sorry, but the head admin account is already created. Please delete the table in your mysql database and run the install.php file."; } elseif ($checkpw.$checkem) { $userPswd = md5($user_password); $userpwsd = sha1($userPswd); mysql_query("INSERT INTO `$user` (user_id, user_name, user_password, user_email, user_ip, userlevel) VALUES ('','$user_name','$userpwsd','$user_email','$ip','1')") or die('Error ' . mysql_error()); require_once 'main_write.php'; require_once 'redirect_install.php'; } } } if($length <= 5) { echo "Password Too Short<br>"; } if($length1 <= 3) { echo "Username Too Short.<br>"; } if(!$checkpw) { echo "The passwords you entered do not match. Please check these details and try again.<br>"; } if(!$checkem) { echo "The emails you entered do not match. Please check these details and try again.<br>"; } } else { echo "Please fill in all of the required fields."; } mysql_close(); exit(); } ?><!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['check'])) { // Database Connection Information $dbhost = $_POST["dbhost"]; // Database Host $dbuser = $_POST["dbuser"]; // Database Username $dbpass = $_POST["dbpass"]; // Database Password $dbname = $_POST["dbname"]; // Database Name // Attempt to connect to the database using the user submitted form. $con = mysql_connect($dbhost, $dbuser, $dbpass); if ($con) { require_once 'config_write.php'; echo "You have successfully connected with these details to '$dbname'. <br>Username - '$dbuser'<br> Password - '$dbpass'<br> Database Host - '$dbhost'<br>Please enter the table names you want, or if you want to use the preset names click continue. NOTE: Each table must be a different name. Please do not leave any blank spaces. "; ?> <table align="center" bgcolor="#333333" width="300px" border="0"> <form method="post" action="<?php $_SERVER['PHP_SELF']; ?>?stage2"> <tr><td><font color="#FFFFFF">User Details:</td><td><input type='text' name='user' onClick="this.value=''" value="Users"></td></tr> <tr><td><font color="#ffffff">Forum Questions</td> <td><input type="text" name='forum_question' onClick="this.value=''" value="questions"></td></tr> <tr><td><font color='#ffffff'>Forum Answers</td> <td><input type='text' name='forum_answers' onClick="this.value=''" value="answers"><br></td></tr> <tr><td></td><td><input type='submit' value='Continue' name='table_names'></td></tr> </font> </form> </table> <?php } else { echo 'Error connecting to database:' . mysql_error() . '\n'; // Database creation failed } mysql_close(); exit(); } ?> <!-------------------------------------------------------------------------------------------------------> <table align='center' bgcolor="#999999" width='300px' border='0'><form method='post' action="<?php $_SERVER['PHP_SELF']; ?>?stage1"> <tr><td> Database Host:</td><td> <input type='text' name='dbhost' onClick="this.value=''" value="Database Host"><br></td></tr> <tr><td> Database Username:</td><td> <input type='text' name='dbuser' onClick="this.value=''" value="Database Username"><br></td></tr> <tr><td> Database Password: </td><td> <input type='text' name='dbpass' onClick="this.value=''" value="Database Password"><br></td></tr> <tr><td> Database Name: </td><td> <input type='text' name='dbname' onClick="this.value=''" value="Database Name"><br></td></tr> <tr><td></td><td><input type='submit' value='Continue' name='check'> </td></tr></form> </table> <!-------------------------------------------------------------------------------------------------------> if anyone wants to point out errors or anything, please do
  23. DeanWhitehouse
    ok, i have another related problem(related to this script) it's hard to explain, but i will try, the first table in the script should only appear once, and then not again (so only if you run the page, and then when you press next(or what ever) you don't see it) but it appears on every part of the installation. here is my script <?php // Random Game Design: PHP Website Template // Version 1 // Copyright Dean Whitehouse, 2008 session_start(); ?> <!-------------------------------------------------------------------------------------------------------> <table align='center' bgcolor="#999999" width='300px' border='0'><form method='post' action="<?php $_SERVER['PHP_SELF']; ?>"> <tr><td> Database Host:</td><td> <input type='text' name='dbhost' onClick="this.value=''" value="Database Host"><br></td></tr> <tr><td> Database Username:</td><td> <input type='text' name='dbuser' onClick="this.value=''" value="Database Username"><br></td></tr> <tr><td> Database Password: </td><td> <input type='text' name='dbpass' onClick="this.value=''" value="Database Password"><br></td></tr> <tr><td> Database Name: </td><td> <input type='text' name='dbname' onClick="this.value=''" value="Database Name"><br></td></tr> <tr><td></td><td><input type='submit' value='Continue' name='check'> </td></tr></form> </table> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['check'])) { // Database Connection Information $dbhost = $_POST["dbhost"]; // Database Host $dbuser = $_POST["dbuser"]; // Database Username $dbpass = $_POST["dbpass"]; // Database Password $dbname = $_POST["dbname"]; // Database Name // Attempt to connect to the database using the user submitted form. $con = mysql_connect($dbhost, $dbuser, $dbpass); if ($con) { require_once 'config_write.php'; echo "You have successfully connected with these details to '$dbname'. <br>Username - '$dbuser'<br> Password - '$dbpass'<br> Database Host - '$dbhost'<br>Please enter the table names you want, or if you want to use the preset names click continue. NOTE: Each table must be a different name. Please do not leave any blank spaces. "; ?> <table align="center" bgcolor="#333333" width="300px" border="0"> <form method="post" action="<?php $_SERVER['PHP_SELF']; ?>"> <tr><td><font color="#FFFFFF">User Details:</td><td><input type='text' name='user' onClick="this.value=''" value="Users"></td></tr> <tr><td><font color="#ffffff">Forum Questions</td> <td><input type="text" name='forum_question' onClick="this.value=''" value="questions"></td></tr> <tr><td><font color='#ffffff'>Forum Answers</td> <td><input type='text' name='forum_answers' onClick="this.value=''" value="answers"><br></td></tr> <tr><td></td><td><input type='submit' value='Continue' name='table_names'></td></tr> </font> </form> </table> <?php } else { echo 'Error connecting to database:' . mysql_error() . '\n'; // Database creation failed } // Close connection to the database mysql_close(); } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['table_names'])) { require_once '../includes/db_connect.php'; $dbhost = $_POST["dbhost"]; $user = $_POST["user"]; $forum_quest = $_POST["forum_question"]; $forum_answ = $_POST ["forum_answers"]; if ($user.$forum_quest.$forum_answ) { require_once "config_writetable.php"; echo "Table details saved:<br>User details saved: $user<br>Forum Questions saved: $forum_quest<br>Forum Answers saved: $forum_answ"; ?> <p>Table name's saved, press continue to create the table.<form action="<?php $_SERVER['PHP_SELF'] ?>" method="post"> <input type='submit' value='Continue' name='table_saved'> </form> </p> <?php } else { echo ("Please go back and fill in the required fields"); } } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['table_saved'])) { require_once '../includes/db_connect.php'; mysql_connect($dbhost,$dbuser,$dbpass) or die('Could not connect: ' . mysql_error()); // Select database mysql_select_db($dbname) or die('Could not find the database: ' . mysql_error()); $sql_user = "CREATE TABLE $user( user_id int(11) AUTO_INCREMENT NOT NULL PRIMARY KEY, user_name varchar(100) NOT NULL, user_password varchar(100) NOT NULL, user_email varchar(100) NOT NULL, user_ip varchar(20) NOT NULL, user_ban varchar(3) NOT NULL, ban_reason varchar(100) NOT NULL, ban_length varchar(25) NOT NULL, userlevel tinyint(1) unsigned NOT NULL, random_key varchar(32) NOT NULL, user_activated varchar(25) NOT NULL, show_email int(1) NOT NULL )"; $sql_forum1 = "CREATE TABLE $forum_quest( id int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, topic varchar(255) NOT NULL default '', detail longtext NOT NULL, name varchar(65) NOT NULL default '', email varchar(65) NOT NULL default '', datetime varchar(25) NOT NULL default '', view int(4) NOT NULL default '0', reply int(4) NOT NULL default '0' )"; $sql_forum2 = "CREATE TABLE $forum_answ( question_id int(4) NOT NULL default '0' PRIMARY KEY, a_id int(4) NOT NULL default '0', a_name varchar(65) NOT NULL default '', a_email varchar(65) NOT NULL default '', a_answer longtext NOT NULL, a_datetime varchar(25) NOT NULL default '', )"; $make_user= mysql_query($sql_user); $make_forum = mysql_query($sql_forum1); $make_forum1 = mysql_query($sql_forum2); $checkifexist_user = mysql_query ("SELECT * FROM '$user' LIMIT 0,1"); $checkifexist_quest = mysql_query ("SELECT * FROM '$forum_quest' LIMIT 0,1"); $checkifexist_answ = mysql_query ("SELECT * FROM '$forum_answ' LIMIT 0,1"); if (!$make_user) { echo("'$user' Table already exists.<br>'$user' table could not be created.<br>"); } else { echo("'$user' Table Created.<br>"); } if (!make_forum) { echo("'$forum_quest' Table already exists.<br>'$forum_quest' table could not be created.<br>"); } else { echo("'$forum_quest' Table Created.<br>"); } if (!make_forum1) { echo("'$forum_quest' Table already exists.<br>'$forum_quest' table could not be created.<br>"); } else { echo("'$forum_answ' Table Created.<br>"); } ?><form action="<?php $_SERVER['PHP_SELF'] ?>" method="post"> <input type="submit" value="Continue" name="continue_saved"/> <? mysql_close(); exit(); } ?> <!-------------------------------------------------------------------------------------------------------> <?php if(isset($_POST['continue_saved'])) { require_once '../includes/db_connect.php'; ?> <html> <table bgcolor='#999999' align='center' width="400px"> <form action='<?php $_SERVER['PHP_SELF']; ?>' method='POST'> <tr><td width="10px">Username: </td><td><input type='text' name='user_name' maxlength="20" width="400px" /><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">E-mail Address:</td> <td><input type='text' name='user_email' /><br /></td></tr> <tr><td width="10px">Confirm E-mail Address: </td><td><input type='text' name='user_email2'/><br /></td></tr> <tr><td width="10px">Password:</td><td> <input type='password' name='user_password' maxlength="30"/><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">Confirm Password:</td><td> <input type='password' name='user_password2' maxlength="30" /><br /></td></tr> <tr><td><input type='submit' value='Complete Registration' name='admin_signup' /></td><td><input type="reset" value="Reset Fields" name="reset" /></td></tr> </form> </table> </html> <?php } ?> <!-------------------------------------------------------------------------------------------------------> <?php //admin form ?> <?php if(isset($_POST['admin_signup'])){ require_once '../includes/db_connect.php'; $user_name = mysql_real_escape_string($_POST["user_name"]); $user_password =mysql_real_escape_string($_POST["user_password"]); $user_password2 =mysql_real_escape_string ($_POST["user_password2"]); $user_email =mysql_real_escape_string ($_POST["user_email"]); $user_email2 =mysql_real_escape_string ($_POST["user_email2"]); $ip = $_SERVER['REMOTE_ADDR']; $checkpw = $user_password == $user_password2; $checkem = $user_email == $user_email2; if ($user_name && $user_password && $user_password2 && $user_email && $user_email2) { $user_check = mysql_num_rows(mysql_query("SELECT * FROM `$user` WHERE userlevel=1 ")); $length = strlen($user_password); $length1 = strlen($user_name); if ($length >= 6) { if ($length1 >= 4) { if ($user_check >= 1) { echo "Sorry, but the head admin account is already created. Please delete the table in your mysql database and run the install.php file."; } elseif ($checkpw.$checkem) { $userPswd = md5($user_password); $userpwsd = sha1($userPswd); mysql_query("INSERT INTO `$user` (user_id, user_name, user_password, user_email, user_ip, userlevel) VALUES ('','$user_name','$userpwsd','$user_email','$ip','1')") or die('Error ' . mysql_error()); require_once 'main_write.php'; require_once 'redirect_install.php'; } } } if($length <= 5) { echo "Password Too Short<br>"; } if($length1 <= 3) { echo "Username Too Short.<br>"; } if(!$checkpw) { echo "The passwords you entered do not match. Please check these details and try again.<br>"; } if(!$checkem) { echo "The emails you entered do not match. Please check these details and try again.<br>"; } } else { echo "Please fill in all of the required fields."; } mysql_close(); } ?> <!-------------------------------------------------------------------------------------------------------> each part of the installation is seperated by html comment tags
  24. DeanWhitehouse
    ok, thanks for the reply, i didn't think of trying that. Here is an update of my code, does anyone know how to echo the error on next to the form without inlcuding the file? <?php // Random Game Design: PHP Website Template // Version 1 // Copyright Dean Whitehouse, 2008 if(isset($_POST['admin_signup'])){ require_once '../includes/db_connect.php'; $user_name = mysql_real_escape_string($_POST["user_name"]); $user_password =mysql_real_escape_string($_POST["user_password"]); $user_password2 =mysql_real_escape_string ($_POST["user_password2"]); $user_email =mysql_real_escape_string ($_POST["user_email"]); $user_email2 =mysql_real_escape_string ($_POST["user_email2"]); $ip = $_SERVER['REMOTE_ADDR']; $checkpw = $user_password == $user_password2; $checkem = $user_email == $user_email2; if ($user_name && $user_password && $user_password2 && $user_email && $user_email2) { $user_check = mysql_num_rows(mysql_query("SELECT * FROM $user WHERE user_email='$user_email' OR user_name='$user_name'")); $length = strlen($user_password); $length1 = strlen($user_name); if ($length >= 6) { if ($length1 >= 4) { if ($user_check >= 1) { require_once 'register.php'; echo "Sorry, but the username or email you requested is already in use. Please enter a different username."; } elseif ($user_password == $user_password2 && $user_email == $user_email2) { $userPswd = md5($user_password); $userpwsd = sha1($userPswd); mysql_query("INSERT INTO `$user` (user_id, user_name, user_password, user_email, user_ip, userlevel ) VALUES ('','$user_name','$userpwsd','$user_email','$ip','1')") or die('Error ' . mysql_error()); echo "Succesfully Registered."; header ("http://".$_SERVER[HTTP_HOST]); } } } if($length <= 5) { echo "Password Too Short<br>"; } if($length1 <= 3) { echo "Username Too Short.<br>"; } if(!$checkpw) { echo "The passwords you entered do not match. Please check these details and try again.<br>"; } if(!$checkem) { echo "The emails you entered do not match. Please check these details and try again.<br>"; } } else { echo "Please fill in all of the required fields."; } mysql_close(); } exit(); if(isset($_POST['continue_saved'])) { require_once '../includes/db_connect.php'; ?> <html> <table bgcolor='#999999' align='center' width="400px"> <form action='<?php $_SERVER['PHP_SELF']; ?>' method='POST'> <tr><td width="10px">Username: </td><td><input type='text' name='user_name' maxlength="20" width="400px" value="<?php echo $user_name ?>" /><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">E-mail Address:</td> <td><input type='text' name='user_email' value="<?php echo $user_email ?>"/><br /></td></tr> <tr><td width="10px">Confirm E-mail Address: </td><td><input type='text' name='user_email2' value="<?php echo $user_email2 ?>"/><br /></td></tr> <tr><td width="10px">Password:</td><td> <input type='password' name='user_password' maxlength="30"/><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">Confirm Password:</td><td> <input type='password' name='user_password2' maxlength="30" /><br /></td></tr> <tr><td><input type='submit' value='Complete Registration' name='admin_signup' /></td><td><input type="reset" value="Reset Fields" name="reset" /></td></tr> </form> </table> </html> <?php exit(); }
  25. DeanWhitehouse
    on my registration form, i have a few things that are required , how can i have it so that it shows the error on next to the form and keeps what the user entered in the form(except password). My form is embebed into a page, so i cannont include the page, as it will shows the begging on the page and not the registration form. this is my part of code if(isset($_POST['admin_signup'])){ require_once '../includes/db_connect.php'; $user_name = mysql_real_escape_string($_POST["user_name"]); $user_password =mysql_real_escape_string($_POST["user_password"]); $user_password2 =mysql_real_escape_string ($_POST["user_password2"]); $user_email =mysql_real_escape_string ($_POST["user_email"]); $user_email2 =mysql_real_escape_string ($_POST["user_email2"]); $ip = $_SERVER['REMOTE_ADDR']; if ($user_name && $user_password && $user_password2 && $user_email && $user_email2) { $user_check = mysql_num_rows(mysql_query("SELECT * FROM `$user` WHERE userlevel=1 ")); $length = strlen($user_password); if ($length >= 6) { if ($user_check >= 1) { echo "Sorry, but the head admin account is already created. Please delete the table in your mysql database and run the install.php file."; } elseif ($user_password == $user_password2 && $user_email == $user_email2) { $userPswd = md5($user_password); $userpwsd = sha1($userPswd); mysql_query("INSERT INTO `$user` (user_id, user_name, user_password, user_email, user_ip, userlevel) VALUES ('','$user_name','$userpwsd','$user_email','$ip','1')") or die('Error ' . mysql_error()); require_once 'main_write.php'; require_once 'redirect_install.php'; } } else { echo "Either the passwords or emails you entered do not match. Please check these details and try again"; } } else { echo "Please fill in all of the required fields."; mysql_close(); } } exit(); ?> <?php if(isset($_POST['continue_saved'])) { require_once '../includes/db_connect.php'; ?> <html> <table bgcolor='#999999' align='center' width="400px"> <form action='<?php $_SERVER['PHP_SELF']; ?>' method='POST'> <tr><td width="10px">Username: </td><td><input type='text' name='user_name' maxlength="20" width="400px" /><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">E-mail Address:</td> <td><input type='text' name='user_email' /><br /></td></tr> <tr><td width="10px">Confirm E-mail Address: </td><td><input type='text' name='user_email2'/><br /></td></tr> <tr><td width="10px">Password:</td><td> <input type='password' name='user_password' maxlength="30"/><br /></td></tr> <tr><td width="10px">Maximum Length<br /> 20 characters.</td></tr> <tr><td width="10px">Confirm Password:</td><td> <input type='password' name='user_password2' maxlength="30" /><br /></td></tr> <tr><td><input type='submit' value='Complete Registration' name='admin_signup' /></td><td><input type="reset" value="Reset Fields" name="reset" /></td></tr> </form> </table> </html> <?php exit(); }
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.