Jump to content
Forums are read-only ×
Larry Ullman's Book Forums

Lee

Members
 View Profile  See their activity

  • Posts

    9

  • Joined

  • Last visited

Lee's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Lee
    Thank you Thank you Thank you. Your code snippits do EXACTLY what I was trying to achieve. I really appreciate your help as I think I know have a form that works just the way I wanted and a great point of reference for the rest of my rather simple site.
  2. Lee
    The test_add_bird.php will become the add_bird.php once I have it working as intended. As I say I am very new to this so I have probably made many mistakes and I am probably not explaining myself very well due to my lack of understanding. I had copied the code from examples in the book and tried to modify it to my needs but I keep hitting brick walls because my understand is insufficient and I make many changes trying to fix things, so there is code that is not required. I would like to use the cleaned variables but I cant figure out how to get it to work and I am finding my lack of progress frustrating. If your happy to take the time to help me then I would be grateful because I clearly need a eurika moment. Here is my code that seems to do what I need but not using the cleaned variables. <!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>Bird Registration - Page 1</title> <style type="text/css"> <!-- --> </style> <link href="styles/mystyles.css" rel="stylesheet" type="text/css" /> </head> <body> <div class="container"> <div class="header"><a href="#"><img src="Images/logo.jpg" width="961" height="100" alt="Logo" /></a> </div> <div class="sidebar1"> <?php // ob_start(); session_start(); if($_SESSION['user_id'] > '1'){ include('includes/navbar1.inc.php'); } else { include('includes/navbar.inc.php'); } ?> </div> <div class="content"> <?php require ('includes/config.inc.php'); require (MYSQL); $page_title = 'add_bird'; // Form Data Script if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form. // Validate the Bird Name if (!empty($_POST['bird_name'])) { $bn = mysqli_real_escape_string ($dbc, $_POST['bird_name']); } else { $bn = FALSE; echo '<p class="error">You forgot to enter a birdname!</p>'; } // Validate the Sex if (!empty($_POST['sex'])) { $sex = mysqli_real_escape_string ($dbc, $_POST['sex']); } else { $sex = FALSE; echo 'p class="error">Please enter the birds sex!</p>'; } // Validate the birds species if (!empty($_POST['species_id'])) { $sp = mysqli_real_escape_string ($dbc, $_POST['species_id']); } else { $sp = FALSE; echo '<p class="error">You forgot to specify the species!</p>'; } // Validate the day if (!empty($_POST['day'])) { $dt = mysqli_real_escape_string ($dbc, $_POST['day']); } else { $dt = FALSE; echo '<p class="error"> You forgot to enter the day!</p>'; } // Validate the Month if (!empty($_POST['month'])) { $mn = mysqli_real_escape_string ($dbc, $_POST['month']); } else { $mn = FALSE; echo '<p class="error"> You forgot to enter the month!</p>'; } // Validate the Year if (!empty($_POST['year'])) { $yr = mysqli_real_escape_string ($dbc, $_POST['year']); } else { $yr = FALSE; echo '<p class="error">You forgot to enter the year!</p>'; } // Setup Date $_POST['dob'] = date("Ymd", mktime(0, 0, 0, $mn, $dt, $yr)); // Validate Date if (!empty($_POST['dob'])) { $md = mysqli_real_escape_string ($dbc, $_POST['dob']); } else { $md = FALSE; echo '<p class="error">Date didnt work!!</p>'; } // Validate the Ring Number if (!empty($_POST['ringno'])) { $rn = mysqli_real_escape_string ($dbc, $_POST['ringno']); } else { $rn = FALSE; echo '<p class="error">You forgot to enter the Ring Number!</p>'; } // Check everything is okay if ($bn && $sex && $sp && $md) { // Add the bird to the database: $q = "INSERT INTO bird (user_id, bird_name, sex, species_id, ringno, dob) VALUES ($_SESSION[user_id], '$_POST[bird_name]', '$_POST[sex]', $_POST[species_id], '$_POST[ringno]', '$_POST[dob]')"; $r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc)); if (mysqli_affected_rows($dbc) == 1) { // If it ran OK. // Finish the page header('Location: test_add_bird_2.php'); exit(); } else { // If it did not run OK. echo '<p class="error">Its gone horribly wrong!!.</p>'; } } else { // If one of the data tests failed. echo '<p class="error">Please try again.</p>'; } // mysqli_close($dbc); } // End of the main Submit conditional. ?> <h3 align="left" class="style2">Add your bird(s) to the database</h3> <form action="test_add_bird.php" method="post"> <p><b>Bird Name:</b> <input type="text" name="bird_name" size="30" maxlength="30" /></p> <p><b>Sex:</b> <select name="sex"> <option value="Female">Female</option> <option value="Male">Male</option> </select> <p><b>Species:</b> <?php $q1 = ("SELECT common_name, species_id FROM species"); $r1 = mysqli_query($dbc, $q1); ?> <select id="species_id" name="species_id"> <option value=''></option> <?php while ($row = mysqli_fetch_array($r1)) { echo "<option value=\"".$row['species_id']."\">".$row['common_name']."</option>\n "; } ?> </select> <p><b>Date of birth / Ownership:<br /> Day:</b><select name="day" > <option value='01'>01</option> <option value='02'>02</option> <option value='03'>03</option> <option value='04'>04</option> <option value='05'>05</option> <option value='06'>06</option> <option value='07'>07</option> <option value='08'>08</option> <option value='09'>09</option> <option value='10'>10</option> <option value='11'>11</option> <option value='12'>12</option> <option value='13'>13</option> <option value='14'>14</option> <option value='15'>15</option> <option value='16'>16</option> <option value='17'>17</option> <option value='18'>18</option> <option value='19'>19</option> <option value='20'>20</option> <option value='21'>21</option> <option value='22'>22</option> <option value='23'>23</option> <option value='24'>24</option> <option value='25'>25</option> <option value='26'>26</option> <option value='27'>27</option> <option value='28'>28</option> <option value='29'>29</option> <option value='30'>30</option> <option value='31'>31</option> </select> <b>Month:</b><select name="month" > <option value='01'>January</option> <option value='02'>February</option> <option value='03'>March</option> <option value='04'>April</option> <option value='05'>May</option> <option value='06'>June</option> <option value='07'>July</option> <option value='08'>August</option> <option value='09'>September</option> <option value='10'>October</option> <option value='11'>November</option> <option value='12'>December</option> </select> <b>Year:</b><input type="text" name="year" size=4 value=2011> </select> <p><b>Ring Number:</b> <input type="text" name="ringno" size="30" maxlength="30" /></p> <p><b>Breeder</b> (Optional): <input type="text" name="breeder" size="30" maxlength="30" /></p> <p><b>Mentor</b> (Optional):<input type="text" name="mentor" size="30" maxlength="30" /></p> </p> <div align="center"><input type="submit" name="submit" value="Add bird to database" /></div> </form> </div> <div class="footer"> <p> <?php include('./includes/footer.inc.php'); ?> </p> </div> </div> </body> </html>
  3. Lee
    I dont know if this is okay but I hav got it to work but changing the $_SESSION[dob] = ...... to $_POST[dob] =..... and the page now works. Is there any problem in doing this?
  4. Lee
    Again thank you for your reply and for the way you have written it. As a newbie its good when it gets written in a way that is understood. However, the formatting of my INSERT command is the only way I can get it to work. Setting the INSERT command as you have suggested produces an error like this. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING. Perhaps it would useful to show the code for the whole page. <!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>Falconry Logs</title> <style type="text/css"> <!-- --> </style> <link href="styles/mystyles.css" rel="stylesheet" type="text/css" /> </head> <body> <div class="container"> <div class="header"><a href="#"><img src="Images/logo.jpg" width="961" height="100" alt="Logo" /></a> </div> <div class="sidebar1"> <?php // ob_start(); session_start(); if($_SESSION['user_id'] > '1'){ include('includes/navbar1.inc.php'); } else { include('includes/navbar.inc.php'); } ?> </div> <div class="content"> <?php require ('includes/config.inc.php'); require (MYSQL); $page_title = 'add_bird'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form. // Validate the Bird Name if (!empty($_POST['bird_name'])) { $bn = mysqli_real_escape_string ($dbc, $_POST['bird_name']); } else { $bn = FALSE; echo '<p class="error">You forgot to enter a birdname!</p>'; } // Validate the Sex if (!empty($_POST['sex'])) { $sex = mysqli_real_escape_string ($dbc, $_POST['sex']); } else { $sex = FALSE; echo 'p class="error">Please enter the birds sex!</p>'; } // Validate the birds species if (!empty($_POST['species_id'])) { $sp = mysqli_real_escape_string ($dbc, $_POST['species_id']); } else { $sp = FALSE; echo '<p class="error">You forgot to specify the species!</p>'; } // Validate the day if (!empty($_POST['day'])) { $dt = mysqli_real_escape_string ($dbc, $_POST['day']); } else { $dt = FALSE; echo '<p class="error"> You forgot to enter the day!</p>'; } // Validate the Month if (!empty($_POST['month'])) { $mn = mysqli_real_escape_string ($dbc, $_POST['month']); } else { $mn = FALSE; echo '<p class="error"> You forgot to enter the month!</p>'; } // Validate the Year if (!empty($_POST['year'])) { $yr = mysqli_real_escape_string ($dbc, $_POST['year']); } else { $yr = FALSE; echo '<p class="error">You forgot to enter the year!</p>'; } // Setup Date $_SESSION['dob'] = date("Ymd", mktime(0, 0, 0, $mn, $dt, $yr)); //if (($_POST['day'] > 0) and ($_POST['month'] > 0) and ($_POST['year'] > 0)) { //$mdate = "$_POST[$yr]-$_POST[$mn]-$_POST[$dt]"; //} else { // die("Invalid date values supplied."); //} // Validate Date if (!empty($_POST['$mdate'])) { $md = mysqli_real_escape_string ($dbc, $_POST['$mdate']); } else { $md = FALSE; echo '<p class="error">Date didnt work!!</p>'; } // Validate the Ring Number if (!empty($_POST['ringno'])) { $rn = mysqli_real_escape_string ($dbc, $_POST['ringno']); } else { $rn = FALSE; echo '<p class="error">You forgot to enter the Ring Number!</p>'; } // Check everything is okay if ($bn && $sex && $sp) { // Add the bird to the database: $mdate = date("Ymd", mktime(0, 0, 0, $mn, $dt, $yr)); //$q = "INSERT INTO bird (user_id, bird_name, sex, species_id, ringno, dob) VALUES ($_SESSION[user_id], '$_POST[bird_name]', '$_POST[sex]', $_POST[species_id], '$_POST[ringno]', '$_POST[dob]')"; $q = "INSERT INTO bird (user_id, bird_name, sex, species_id, ringno, dob) VALUES ($_SESSION['user_id], $_POST['bird_name'], $_POST['sex'], $_POST['species_id'], $_POST['ringno'], $_SESSION['dob'])"; $r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc)); if (mysqli_affected_rows($dbc) == 1) { // If it ran OK. // Finish the page echo '<h3>Bird Added</h3>'; exit(); } else { // If it did not run OK. echo '<p class="error">Its gone horribly wrong!!.</p>'; } } else { // If one of the data tests failed. echo '<p class="error">Please try again.</p>'; } // mysqli_close($dbc); } // End of the main Submit conditional. ?> <h3 align="left" class="style2">Add your bird(s) to the database</h3> <form action="test_add_bird.php" method="post"> <p><b>Bird Name:</b> <input type="text" name="bird_name" size="30" maxlength="30" /></p> <p><b>Sex:</b> <select name="sex"> <option value="Female">Female</option> <option value="Male">Male</option> </select> <p><b>Species:</b> <?php $q1 = ("SELECT common_name, species_id FROM species"); $r1 = mysqli_query($dbc, $q1); ?> <select id="species_id" name="species_id"> <option value=''></option> <?php while ($row = mysqli_fetch_array($r1)) { echo "<option value=\"".$row['species_id']."\">".$row['common_name']."</option>\n "; } ?> </select> <p><b>Date of birth / Ownership:<br /> Day:</b><select name="day" > <option value='01'>01</option> <option value='02'>02</option> <option value='03'>03</option> <option value='04'>04</option> <option value='05'>05</option> <option value='06'>06</option> <option value='07'>07</option> <option value='08'>08</option> <option value='09'>09</option> <option value='10'>10</option> <option value='11'>11</option> <option value='12'>12</option> <option value='13'>13</option> <option value='14'>14</option> <option value='15'>15</option> <option value='16'>16</option> <option value='17'>17</option> <option value='18'>18</option> <option value='19'>19</option> <option value='20'>20</option> <option value='21'>21</option> <option value='22'>22</option> <option value='23'>23</option> <option value='24'>24</option> <option value='25'>25</option> <option value='26'>26</option> <option value='27'>27</option> <option value='28'>28</option> <option value='29'>29</option> <option value='30'>30</option> <option value='31'>31</option> </select> <b>Month:</b><select name="month" > <option value='01'>January</option> <option value='02'>February</option> <option value='03'>March</option> <option value='04'>April</option> <option value='05'>May</option> <option value='06'>June</option> <option value='07'>July</option> <option value='08'>August</option> <option value='09'>September</option> <option value='10'>October</option> <option value='11'>November</option> <option value='12'>December</option> </select> <b>Year:</b><input type="text" name="year" size=4 value=2011> </select> <p><b>Ring Number:</b> <input type="text" name="ringno" size="30" maxlength="30" /></p> <p><b>Breeder</b> (Optional): <input type="text" name="breeder" size="30" maxlength="30" /></p> <p><b>Mentor</b> (Optional):<input type="text" name="mentor" size="30" maxlength="30" /></p> </p> <div align="center"><input type="submit" name="submit" value="Add bird to database" /></div> </form> </div> <div class="footer"> <p> <?php include('./includes/footer.inc.php'); ?> </p> </div> </div> </body> </html>
  5. Lee
    Thanks Margaux, your post helped me alot. I still seem to have a problem with dates getting inserted using the INSERT. I know I should start a new thread but seeing as I have started it here maybe I should continue. I have three drop down boxes using a select form. My array gets populated correctly, I then use the following code to make just a number $mdate = date("Ymd", mktime(0, 0, 0, $mn, $dt, $yr)); Looking in the array the above seems to work. Here is the insert command that I use, forget everything else other than mdate bit. $q = "INSERT INTO bird (user_id, bird_name, sex, species_id, ringno, dob) VALUES ($_SESSION[user_id], '$_POST[bird_name]', '$_POST[sex]', $_POST[species_id], '$_POST[ringno]', '$_POST[mdate]')"; The error I get is as below [page_title] => add_bird [bn] => Dorris [sex] => Female [sp] => 4 [dt] => 31 [mn] => 10 [yr] => 2011 [mdate] => 20111031 [md] => [rn] => THC3547 ) #0 my_error_handler(8, Undefined index: mdate, /home/sites/falconrylogs.co.uk/public_html/test_add_bird.php, 110, Array ([GLOBALS] => Array ( *RECURSION*,[_POST] => Array ([bird_name] => Dorris,[sex] => Female,[species_id] => 4,[day] => 31,[month] => 10,[year] => 2011,[ringno] => THC3547,[breeder] => ,[mentor] => ,[submit] => Add bird to database),[_GET] => Array (),[_COOKIE] => Array ([phpSESSID] => tnfk6q3pbn19fvhine0pgs8ho4),[_FILES] => Array (),[_SERVER] => Array ([PATH] => /usr/local/bin:/usr/bin:/bin,[HTTP_HOST] => www.falconrylogs.co.uk,[HTTP_USER_AGENT] => Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2,[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,[HTTP_ACCEPT_LANGUAGE] => en-gb,en;q=0.5,[HTTP_ACCEPT_ENCODING] => gzip, deflate,[HTTP_CONNECTION] => keep-alive,[HTTP_REFERER] => http://www.falconrylogs.co.uk/test_add_bird.php?,[HTTP_COOKIE] => PHPSESSID=tnfk6q3pbn19fvhine0pgs8ho4,[CONTENT_TYPE] => application/x-www-form-urlencoded,[CONTENT_LENGTH] => 126,[sERVER_SIGNATURE] => Apache/2 Server at www.falconrylogs.co.uk Port 80 Thank you for your help in this frustrating matter.
  6. Lee
    Hello me again!! I have come across something that I dont think is mentioned in your book, but I havent quite finished it yet. I would like to write a SQL insert line in my code that contains data from several select sources and a date from from three values and I am not sure how to do it. So i have the following the user_is pulled from $_SESSION from the login A couple of text fields filled in by the user A date field made from a three drop down select fields, like date of birth. I am nure sure how to write that into the single date SQL field. Another field with pulls information from another database and the user picks from the list in a select field. I hope the above makes sense.
  7. Lee
    Your most welcome Larry. How you guys ever become programmers I dont know. This is the most frustrating activity every!!
  8. Lee
    No I didnt, I had it remarked out. I knew it was something stupid. Thanks for your help.
  9. Lee
    Hi Larry, First let me thank you for a great book, out of the four I have I think I understand yours the most. I am trying to use your examples in my own work but I have stummbled across a problem that I cant figure out. I am sure the problem is a simple one but I have been banging my head against a brick wall for days and I cant see the answer, though I know what the problem is. The problem I have is with session information not being passed from the login page back to my index page. If I get the login page to display the session variables there all displayed. Once the page is redirected to the index page they are lost. I hope that all makes sense, it doesnt really to me Lee
×
×
  • Create New...