Back To Programming / Scripting / Coding Forum

Having a problem...

  • kej0283
  • Novice
  • Novice
  • No Avatar
  • Joined: Sep 30, 2009
  • Posts: 18
  • Status: Offline

Post October 3rd, 2009, 10:34 am

I have this form: Here's the code: My problem is that when I enter information into the form: its not going in to my results page: Down below is the results code.. I'm not getting errors in form. Can somebody help me please?? Thank you!
Code: [ Select ]
<head><style type="text/css" media="all"> @import "./includes/A4-kreiderCSS.css";</style></head>
<?php include ("header3.php") ?>
</div>
<?PHP
///////////////////////////////////// Start Dade and Time /////////////////////////////////
function eventscalendar(){
// Monts array
$months = array(1 => 'January', 'February', 'March', 'April', 'May',
  'June', 'July', 'August', 'September', 'October', 'November',
  'December');
        $times = array( '00:00:00'=> 'Midnight', '01:00:00' => '1am', '01:30:00' => '1:30am', '02:00:00' => '2am', '02:30:00' => '2:30am', '03:00:00' => '3am', '04:00:00' => '4am', '04:30:00' => '4:30am', '05:00:00' => '5am','053000' => '5:30am','060000' => '6am', '063000' => '6:30am', '070000' => '7am', '073000' => '7:30am', '080000' => '8am','083000' => '8:30am', '090000' => '9am','09:30:00' => '9:30am', '10:00:00' => '10am','10:30:00' => '10:30am', '11:00:00' => '11am','11:30:00' => '11:30am','12:00:00' => 'Noon', '12:30:00' => '12:30pm', '13:00:00' => '1pm', '13:30:00'=> '1:30pm', '14:00:00' => '2pm','14:30:00' => '2:30pm', '15:00:00' => '3pm','15:30:00' => '3:30pm', '16:00:00' => '4pm','16:30:00' => '4:30pm', '17:00:00' => '5pm','17:30:00' => '5:30pm', '18:00:00' => '6pm','18:30:00' => '6:30pm','19:00:00' => '7pm','19:30:00' => '7:30pm', '20:00:00' => '8pm','20:30:00' => '8:30pm','21:00:00' => '9pm','21:30:00' => '9:30pm', '22:00:00' => '10pm', '22:30:00' => '10:30pm','23:00:00' => '11pm','23:30:00' => '11:30pm');
  // pull doun menu
  echo '<select name="month">';
  echo '<option value="select month">Month</option>\n';
  foreach($months as $key => $value){
   echo "<option value=\"$key\"";
   if($_POST['month'] == $key && !isset($_POST['reset'])){
     echo ' selected="selected"';
   }
   echo ">$value</option>\n";
  }
  echo '</select>';

  echo '<select name="day">';
  echo '<option value="day">Day</option>\n';
  for($day = 1; $day <= 31; $day++){
   echo "<option value=\"$day\"";
   if($_POST['day'] == $day && !isset($_POST['reset'])){
     echo ' selected="selected"';
   }
   echo ">$day</option>\n";
  }
  echo '</select>';

  echo '<select name="year">';
  echo '<option value="year">Year</option>\n';
  $year = 2007;
  while($year <= 2015){
   echo "<option value=\"$year\"";
   if($_POST['year'] == $year && !isset($_POST['reset'])){
     echo ' selected="selected"';
   }
   echo ">$year</option>\n";
   $year++;
  }
  echo '</select>';

 echo '<select name="time">';
  echo '<option value="select t">Time</option>\n';
  foreach($times as $key => $value){
   echo "<option value=\"$key\"";
   if($_POST['time'] == $key && !isset($_POST['reset'])){
     echo ' selected="selected"';
   }
   echo ">$value</option>\n";
  }
  echo '</select>';
    }
    
?>
<?PHP

///////////////////////////////////// Start Dade and Time /////////////////////////////////
function endtime(){
// Monts array
    $timevalues = array( '00:00:00'=> 'Midnight', '01:00:00' => '1am', '01:30:00' => '1:30am', '02:00:00' => '2am', '02:30:00' => '2:30am', '03:00:00' => '3am', '04:00:00' => '4am', '04:30:00' => '4:30am', '05:00:00' => '5am','053000' => '5:30am','060000' => '6am', '063000' => '6:30am', '070000' => '7am', '073000' => '7:30am', '080000' => '8am','083000' => '8:30am', '090000' => '9am','09:30:00' => '9:30am', '10:00:00' => '10am','10:30:00' => '10:30am', '11:00:00' => '11am','11:30:00' => '11:30am','12:00:00' => 'Noon', '12:30:00' => '12:30pm', '13:00:00' => '1pm', '13:30:00'=> '1:30pm', '14:00:00' => '2pm','14:30:00' => '2:30pm', '15:00:00' => '3pm','15:30:00' => '3:30pm', '16:00:00' => '4pm','16:30:00' => '4:30pm', '17:00:00' => '5pm','17:30:00' => '5:30pm', '18:00:00' => '6pm','18:30:00' => '6:30pm','19:00:00' => '7pm','19:30:00' => '7:30pm', '20:00:00' => '8pm','20:30:00' => '8:30pm','21:00:00' => '9pm','21:30:00' => '9:30pm', '22:00:00' => '10pm', '22:30:00' => '10:30pm','23:00:00' => '11pm','23:30:00' => '11:30pm');
  

  // pull doun menu
 echo '<select name="t">';
  echo '<option value="t">Time</option>\n';
  foreach($timevalues as $key => $value){
   echo "<option value=\"$key\" ";
   if($_POST['t'] == $key && !isset($_POST['reset'])){
     echo ' selected="selected"';
   }
   echo ">$value</option>\n";
  }
  echo '</select>';
    }
?>
<?php
require_once("configproject.php");



if (!isset($_POST['reset']))
{
    if (isset($_POST['submitted']))
    {
        $errormsg = "";
        
        
        //check event is blank
        if (empty($_POST['event']))
        {
            $event = NULL;
                        $errormsg .="<p class = 'error'> Please fill in the event</p></span>";
        }
    
        else{
                $event = trim($_POST['event']);
        }
        
        //Checks the event_description shows error
        
                if (empty($_POST['event_description']))
        {
            $event_description = NULL;
            $errormsg .="<p class = 'error'> Please fill the description</p></span>";
        }
    
        else{
                $event_description = trim($_POST['event_description']);
        }
        
            //check for place to show its error
        if (empty($_POST['place']))
        {
            $place = NULL;
            $errormsg .="<p class = 'error'> Please fill The place you want to go</p></span>";
        }
    
        else{
                $place = trim($_POST['place']);
        }
        
        
                    //checks to see if the catergoy shows the error
        if (empty($_POST['price']))
        {
            $price = NULL;
            $errormsg .="<p class = 'error'> Please fill in the price</p></span>";
            
        }
    
        else{
                $price = trim($_POST['price']);
        }
        
        
    ///////////////////////////////////// Satart Date and Time ////////////////////
// Month
if ($_POST['m'] == "select m" ) {
        $errormsg .="<p class = 'error'> You need select a month </p></span>";
    }
    else {
    $m = $_POST ['m'];
    }
    
// Day
if (($_POST['d'])== "d" ) {
        $errormsg .="<p class = 'error'> You need select a Day </p></span>";
    }
    else {
    $d = $_POST ['d'];
    }
    
// y
if (($_POST['y'])== "y" ) {
    $errormsg .="<p class = 'error'> You need select a year </p></span>";
    
    }
    else {
    $y = $_POST ['y'];
    }
    
// Hour
if (($_POST ['t']=="t")){
        $errormsg .="<p class = 'error'> You need to select the time </p></span>";
    }
    else{
    $t = $_POST ['t'];
    }
    

    
///////////////////////////////////// Satart Date and Time ////////////////////
// Month
if ($_POST['month'] == "select month" ) {
        $errormsg .="<p class = 'error'> You need select a month </p></span>";
    }
    else {
    $month = $_POST ['month'];
    }
    
// Day
if (($_POST['day'])== "day" ) {
        $errormsg .="<p class = 'error'> You need select a Day </p></span>";
    }
    else {
    $day = $_POST ['day'];
    }
    
// y
if (($_POST['year'])== "year" ) {
    $errormsg .="<p class = 'error'> You need select a year </p></span>";
    
    }
    else {
    $year = $_POST ['year'];
    }
    
if (($_POST ['time']=="time")){
        $errormsg .="<p class = 'error'> You need to select the time </p></span>";
    }
    else{
    $time = $_POST ['time'];
    }

    




// Calculations for the days
if ($_POST['month'] == 2 && ($_POST['day']) > 28 ) {
    $errormsg =$errormsg ."This month has only 28 days.<br>";
    }
if ($_POST['month'] == 4 && ($_POST['day']) > 30 ) {
    $errormsg =$errormsg . "This month has only 30 days.<br>";
    }
if ($_POST['month'] == 6 && ($_POST['day']) > 30 ) {
    $errormsg =$errormsg . "This month has only 30 days.<br>";
    }
if ($_POST['month'] == 9 && ($_POST['day']) > 30 ) {
    $errormsg =$errormsg . "This month has only 30 days.<br>";
    }
if ($_POST['month'] == 11 && ($_POST['day']) > 30 ) {
    $errormsg =$errormsg . "This month has only 30 days.<br>";
    }
    
            
                 //checks to see if the email shows the error
        if (empty($_POST['email']))
        {
            $email = NULL;
            $errormsg .="<p class = 'error'> Please fill your email</p></span>";
        }
    
        else{
                $email = trim($_POST['email']);
        }
        
            
    }
    
    
    if ($errormsg!="") {
            echo $errormsg."<br>";
            
            

} // end of errors display
    

}    
?>



<?php

    
        // create the Insert query
                    $dtime= $year."-".$month."-".$day." ".$time;
                $ntime= $y."-".$m."-".$d."-".$t ;
                 $query ="INSERT INTO events(event,event_descrption,place,price,etime,stime,email)";


                $result = @mysql_query ($query);

?>



<form name="form1" enctype="multipart/form-data" id="form1" method="post" action="<?PHP echo $_SERVER['PHP_SELF'];?>">
<table width="20">
  <td width="20"><span class = 'names'> Event: </strong></span> </td>
  <td width="20"><input name="event" type="text" id="event" value="<?php if(isset($_POST['reset'])) echo '';    elseif (isset($_POST['event']))
    echo $_POST['event'];    else echo ''; ?>" size="50" maxlength="45" /> </td>
 </tr>
  <td><p><span class = 'names'>Description:</strong></span> </td>
   <td><input name="event_description" type="text" id="event_description" value="<?php if(isset($_POST['reset'])) echo '';    elseif (isset($_POST['event_description']))
    echo $_POST['event_description'];    else echo ''; ?>" size="50" maxlength="45" /> </td>
 </tr>

   <td><p><span class = 'names'>Place: </strong></span> </td>
    <td><input name="place" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['place']) ) echo $_POST['place']; ?>" id="place" size="50" maxlength="50" /></td>
    <br />
   </tr>
    <td><span class = 'names'>Price: </strong></span> </td>
     <td><input name="price" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['price']) ) echo $_POST['price']; ?>" id="price" size="50" maxlength="70" /> </td>
     <br />
         </tr>
         <td><span class = 'names'>Start Time and Date: </strong></span> </td>
         <td><?PHP eventscalendar(); ?> </td>
         <br />
        </tr>
         <td><span class = 'names'>End Time and Date: </strong></span> </td>
         <td><?PHP endtime(); ?> </td>
         <br />
         </tr>
 </p> <td><p><span class = 'names'>Email: </strong></span> </td>
        <td><input name="email" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['email']) ) echo $_POST['email']; ?>" id="sdate" size="50" maxlength="70" /> </td>
        <br />
              </tr>
       
 </table>
       <!--buttons-->
       <input type="submit" name="Submit" value="Submit">
     
       <input name="reset" type="submit" id="Reset" value="Reset">
     
       <input type="hidden" name="submitted" />
       </p>
       </p>
         </p>
</form>




<div class="footer">
 <?php include ("footer.php") ?>
</div>


------------------------------------------------results page-----------------------




<div class="header">
<?php include ("header2.php") ?>
</div>
<?php


require_once("configproject.php");



// Number of records to show per page:
$display = 8;

// Determine how many pages there are.
if (isset($_GET['np'])) { // Already been determined.

    $num_pages = $_GET['np'];

} else { // Need to determine.

    // Count the number of records
    $query = "SELECT COUNT(*) FROM events";
    $result = mysql_query ($query)or die("first query");
    $row = mysql_fetch_array ($result, MYSQL_NUM);
    $num_records = $row[0];

    // Calculate the number of pages.
    if ($num_records > $display) { // More than 1 page.
        $num_pages = ceil ($num_records/$display);
    } else {
        $num_pages = 1;
    }
    
} // End of np IF.

// Determine where in the database to start returning results.
if (isset($_GET['s'])) {
    $start = $_GET['s'];
} else {
    $start = 0;
}



    
// Make the query.
$query = "SELECT id, event, event_descrption,place, thumbdata,DATE_FORMAT(stime, '%e %d, %Y') AS st, TIME_FORMAT(stime, '%l:%i, %p') AS stime, TIME_FORMAT(etime, '%l:%i, %p')AS etime, email, price FROM events LIMIT $start, $display";

$query2 = "SELECT CONCAT( stime, ' ', etime )
FROM `events";
$result = mysql_query ($query) or die("second query"); // Run the query.
$num = mysql_num_rows($result);
                
            // Display the results
if ($num > 0) {
            
            echo "<p class = 'names'>Currently showing $num Results</p></span>";
    }
    

// Table header.



echo '<table align="center" cellspacing="0" cellpadding="5">
<tr>
<th scope="col" class = "names">Date </span></th>
<th scope="col" class = "names">Time </span></th>
      <th scope="col" class = "names">Event </span></th>
    <th scope="col" class = "names">Descrption </span></th>
  <th scope="col" class = "names">Location </span></th>
    <th scope="col" class = "names">Contact</span></th>
<th scope="col" class = "names">Price</span></th>
  <th scope="col" class = "names">RSVP</span></th>
  

</tr>
';

// Fetch and print all the records.
$bg = '#eeeeee'; // Set the background color.
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $bg = ($bg=='#7b1d1d' ? '#ffffff' : '#7b1d1d'); // Switch the background color.
    echo '<tr bgcolor="' . $bg . '">
<td align="left">'.$row['st'].$row['stime'].'</td>
<td align="left">'.$row['et'].$row['etime'].'</td>
<td align="left">'.$row['event'].'</td>
<td align="left" >'.$row['event_descrption'].'</td>
<td align="left">'.$row['place'].'</td>
<td align="left"><a href="mailto?id=' . $row['id'] . '">Contact</a></td>
<td align="left" >'.$row['price'].'</td>
<td align="left"><a href="edit_user.php?id=' . $row['id'] . '">RSVP</a></td>

    </tr>
    ';
}



mysql_free_result ($result); // Free up the resources.    

mysql_close(); // Close the database connection.

// Make the links to other pages, if necessary.
if ($num_pages > 1) {
    
    echo '<br /><p>';
    // Determine what page the script is on.    
    $current_page = ($start/$display) + 1;
    
    // If it's not the first page, make a Previous button.
    if ($current_page != 1) {
        echo '<a href="results2.php?s=' . ($start - $display) . '&np=' . $num_pages . '">Previous</a> ';
    }
    
    // Make all the numbered pages.
    for ($i = 1; $i <= $num_pages; $i++) {
        if ($i != $current_page) {
            echo '<a href="results2.php?s=' . (($display * ($i - 1))) . '&np=' . $num_pages . '">' . $i . '</a> ';
        } else {
            echo $i . ' ';
        }
    }
    
    // If it's not the last page, make a Next button.
    if ($current_page != $num_pages) {
        echo '<a href="results2.php?s=' . ($start + $display) . '&np=' . $num_pages . '">Next</a>';
    }
    
    echo '</p>';
    
} // End of links section.
    

?>
  1. <head><style type="text/css" media="all"> @import "./includes/A4-kreiderCSS.css";</style></head>
  2. <?php include ("header3.php") ?>
  3. </div>
  4. <?PHP
  5. ///////////////////////////////////// Start Dade and Time /////////////////////////////////
  6. function eventscalendar(){
  7. // Monts array
  8. $months = array(1 => 'January', 'February', 'March', 'April', 'May',
  9.   'June', 'July', 'August', 'September', 'October', 'November',
  10.   'December');
  11.         $times = array( '00:00:00'=> 'Midnight', '01:00:00' => '1am', '01:30:00' => '1:30am', '02:00:00' => '2am', '02:30:00' => '2:30am', '03:00:00' => '3am', '04:00:00' => '4am', '04:30:00' => '4:30am', '05:00:00' => '5am','053000' => '5:30am','060000' => '6am', '063000' => '6:30am', '070000' => '7am', '073000' => '7:30am', '080000' => '8am','083000' => '8:30am', '090000' => '9am','09:30:00' => '9:30am', '10:00:00' => '10am','10:30:00' => '10:30am', '11:00:00' => '11am','11:30:00' => '11:30am','12:00:00' => 'Noon', '12:30:00' => '12:30pm', '13:00:00' => '1pm', '13:30:00'=> '1:30pm', '14:00:00' => '2pm','14:30:00' => '2:30pm', '15:00:00' => '3pm','15:30:00' => '3:30pm', '16:00:00' => '4pm','16:30:00' => '4:30pm', '17:00:00' => '5pm','17:30:00' => '5:30pm', '18:00:00' => '6pm','18:30:00' => '6:30pm','19:00:00' => '7pm','19:30:00' => '7:30pm', '20:00:00' => '8pm','20:30:00' => '8:30pm','21:00:00' => '9pm','21:30:00' => '9:30pm', '22:00:00' => '10pm', '22:30:00' => '10:30pm','23:00:00' => '11pm','23:30:00' => '11:30pm');
  12.   // pull doun menu
  13.   echo '<select name="month">';
  14.   echo '<option value="select month">Month</option>\n';
  15.   foreach($months as $key => $value){
  16.    echo "<option value=\"$key\"";
  17.    if($_POST['month'] == $key && !isset($_POST['reset'])){
  18.      echo ' selected="selected"';
  19.    }
  20.    echo ">$value</option>\n";
  21.   }
  22.   echo '</select>';
  24.   echo '<select name="day">';
  25.   echo '<option value="day">Day</option>\n';
  26.   for($day = 1; $day <= 31; $day++){
  27.    echo "<option value=\"$day\"";
  28.    if($_POST['day'] == $day && !isset($_POST['reset'])){
  29.      echo ' selected="selected"';
  30.    }
  31.    echo ">$day</option>\n";
  32.   }
  33.   echo '</select>';
  35.   echo '<select name="year">';
  36.   echo '<option value="year">Year</option>\n';
  37.   $year = 2007;
  38.   while($year <= 2015){
  39.    echo "<option value=\"$year\"";
  40.    if($_POST['year'] == $year && !isset($_POST['reset'])){
  41.      echo ' selected="selected"';
  42.    }
  43.    echo ">$year</option>\n";
  44.    $year++;
  45.   }
  46.   echo '</select>';
  48.  echo '<select name="time">';
  49.   echo '<option value="select t">Time</option>\n';
  50.   foreach($times as $key => $value){
  51.    echo "<option value=\"$key\"";
  52.    if($_POST['time'] == $key && !isset($_POST['reset'])){
  53.      echo ' selected="selected"';
  54.    }
  55.    echo ">$value</option>\n";
  56.   }
  57.   echo '</select>';
  58.     }
  59.     
  60. ?>
  61. <?PHP
  63. ///////////////////////////////////// Start Dade and Time /////////////////////////////////
  64. function endtime(){
  65. // Monts array
  66.     $timevalues = array( '00:00:00'=> 'Midnight', '01:00:00' => '1am', '01:30:00' => '1:30am', '02:00:00' => '2am', '02:30:00' => '2:30am', '03:00:00' => '3am', '04:00:00' => '4am', '04:30:00' => '4:30am', '05:00:00' => '5am','053000' => '5:30am','060000' => '6am', '063000' => '6:30am', '070000' => '7am', '073000' => '7:30am', '080000' => '8am','083000' => '8:30am', '090000' => '9am','09:30:00' => '9:30am', '10:00:00' => '10am','10:30:00' => '10:30am', '11:00:00' => '11am','11:30:00' => '11:30am','12:00:00' => 'Noon', '12:30:00' => '12:30pm', '13:00:00' => '1pm', '13:30:00'=> '1:30pm', '14:00:00' => '2pm','14:30:00' => '2:30pm', '15:00:00' => '3pm','15:30:00' => '3:30pm', '16:00:00' => '4pm','16:30:00' => '4:30pm', '17:00:00' => '5pm','17:30:00' => '5:30pm', '18:00:00' => '6pm','18:30:00' => '6:30pm','19:00:00' => '7pm','19:30:00' => '7:30pm', '20:00:00' => '8pm','20:30:00' => '8:30pm','21:00:00' => '9pm','21:30:00' => '9:30pm', '22:00:00' => '10pm', '22:30:00' => '10:30pm','23:00:00' => '11pm','23:30:00' => '11:30pm');
  67.   
  69.   // pull doun menu
  70.  echo '<select name="t">';
  71.   echo '<option value="t">Time</option>\n';
  72.   foreach($timevalues as $key => $value){
  73.    echo "<option value=\"$key\" ";
  74.    if($_POST['t'] == $key && !isset($_POST['reset'])){
  75.      echo ' selected="selected"';
  76.    }
  77.    echo ">$value</option>\n";
  78.   }
  79.   echo '</select>';
  80.     }
  81. ?>
  82. <?php
  83. require_once("configproject.php");
  87. if (!isset($_POST['reset']))
  88. {
  89.     if (isset($_POST['submitted']))
  90.     {
  91.         $errormsg = "";
  92.         
  93.         
  94.         //check event is blank
  95.         if (empty($_POST['event']))
  96.         {
  97.             $event = NULL;
  98.                         $errormsg .="<p class = 'error'> Please fill in the event</p></span>";
  99.         }
  100.     
  101.         else{
  102.                 $event = trim($_POST['event']);
  103.         }
  104.         
  105.         //Checks the event_description shows error
  106.         
  107.                 if (empty($_POST['event_description']))
  108.         {
  109.             $event_description = NULL;
  110.             $errormsg .="<p class = 'error'> Please fill the description</p></span>";
  111.         }
  112.     
  113.         else{
  114.                 $event_description = trim($_POST['event_description']);
  115.         }
  116.         
  117.             //check for place to show its error
  118.         if (empty($_POST['place']))
  119.         {
  120.             $place = NULL;
  121.             $errormsg .="<p class = 'error'> Please fill The place you want to go</p></span>";
  122.         }
  123.     
  124.         else{
  125.                 $place = trim($_POST['place']);
  126.         }
  127.         
  128.         
  129.                     //checks to see if the catergoy shows the error
  130.         if (empty($_POST['price']))
  131.         {
  132.             $price = NULL;
  133.             $errormsg .="<p class = 'error'> Please fill in the price</p></span>";
  134.             
  135.         }
  136.     
  137.         else{
  138.                 $price = trim($_POST['price']);
  139.         }
  140.         
  141.         
  142.     ///////////////////////////////////// Satart Date and Time ////////////////////
  143. // Month
  144. if ($_POST['m'] == "select m" ) {
  145.         $errormsg .="<p class = 'error'> You need select a month </p></span>";
  146.     }
  147.     else {
  148.     $m = $_POST ['m'];
  149.     }
  150.     
  151. // Day
  152. if (($_POST['d'])== "d" ) {
  153.         $errormsg .="<p class = 'error'> You need select a Day </p></span>";
  154.     }
  155.     else {
  156.     $d = $_POST ['d'];
  157.     }
  158.     
  159. // y
  160. if (($_POST['y'])== "y" ) {
  161.     $errormsg .="<p class = 'error'> You need select a year </p></span>";
  162.     
  163.     }
  164.     else {
  165.     $y = $_POST ['y'];
  166.     }
  167.     
  168. // Hour
  169. if (($_POST ['t']=="t")){
  170.         $errormsg .="<p class = 'error'> You need to select the time </p></span>";
  171.     }
  172.     else{
  173.     $t = $_POST ['t'];
  174.     }
  175.     
  177.     
  178. ///////////////////////////////////// Satart Date and Time ////////////////////
  179. // Month
  180. if ($_POST['month'] == "select month" ) {
  181.         $errormsg .="<p class = 'error'> You need select a month </p></span>";
  182.     }
  183.     else {
  184.     $month = $_POST ['month'];
  185.     }
  186.     
  187. // Day
  188. if (($_POST['day'])== "day" ) {
  189.         $errormsg .="<p class = 'error'> You need select a Day </p></span>";
  190.     }
  191.     else {
  192.     $day = $_POST ['day'];
  193.     }
  194.     
  195. // y
  196. if (($_POST['year'])== "year" ) {
  197.     $errormsg .="<p class = 'error'> You need select a year </p></span>";
  198.     
  199.     }
  200.     else {
  201.     $year = $_POST ['year'];
  202.     }
  203.     
  204. if (($_POST ['time']=="time")){
  205.         $errormsg .="<p class = 'error'> You need to select the time </p></span>";
  206.     }
  207.     else{
  208.     $time = $_POST ['time'];
  209.     }
  211.     
  216. // Calculations for the days
  217. if ($_POST['month'] == 2 && ($_POST['day']) > 28 ) {
  218.     $errormsg =$errormsg ."This month has only 28 days.<br>";
  219.     }
  220. if ($_POST['month'] == 4 && ($_POST['day']) > 30 ) {
  221.     $errormsg =$errormsg . "This month has only 30 days.<br>";
  222.     }
  223. if ($_POST['month'] == 6 && ($_POST['day']) > 30 ) {
  224.     $errormsg =$errormsg . "This month has only 30 days.<br>";
  225.     }
  226. if ($_POST['month'] == 9 && ($_POST['day']) > 30 ) {
  227.     $errormsg =$errormsg . "This month has only 30 days.<br>";
  228.     }
  229. if ($_POST['month'] == 11 && ($_POST['day']) > 30 ) {
  230.     $errormsg =$errormsg . "This month has only 30 days.<br>";
  231.     }
  232.     
  233.             
  234.                  //checks to see if the email shows the error
  235.         if (empty($_POST['email']))
  236.         {
  237.             $email = NULL;
  238.             $errormsg .="<p class = 'error'> Please fill your email</p></span>";
  239.         }
  240.     
  241.         else{
  242.                 $email = trim($_POST['email']);
  243.         }
  244.         
  245.             
  246.     }
  247.     
  248.     
  249.     if ($errormsg!="") {
  250.             echo $errormsg."<br>";
  251.             
  252.             
  254. } // end of errors display
  255.     
  257. }    
  258. ?>
  262. <?php
  264.     
  265.         // create the Insert query
  266.                     $dtime= $year."-".$month."-".$day." ".$time;
  267.                 $ntime= $y."-".$m."-".$d."-".$t ;
  268.                  $query ="INSERT INTO events(event,event_descrption,place,price,etime,stime,email)";
  271.                 $result = @mysql_query ($query);
  273. ?>
  277. <form name="form1" enctype="multipart/form-data" id="form1" method="post" action="<?PHP echo $_SERVER['PHP_SELF'];?>">
  278. <table width="20">
  279.   <td width="20"><span class = 'names'> Event: </strong></span> </td>
  280.   <td width="20"><input name="event" type="text" id="event" value="<?php if(isset($_POST['reset'])) echo '';    elseif (isset($_POST['event']))
  281.     echo $_POST['event'];    else echo ''; ?>" size="50" maxlength="45" /> </td>
  282.  </tr>
  283.   <td><p><span class = 'names'>Description:</strong></span> </td>
  284.    <td><input name="event_description" type="text" id="event_description" value="<?php if(isset($_POST['reset'])) echo '';    elseif (isset($_POST['event_description']))
  285.     echo $_POST['event_description'];    else echo ''; ?>" size="50" maxlength="45" /> </td>
  286.  </tr>
  288.    <td><p><span class = 'names'>Place: </strong></span> </td>
  289.     <td><input name="place" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['place']) ) echo $_POST['place']; ?>" id="place" size="50" maxlength="50" /></td>
  290.     <br />
  291.    </tr>
  292.     <td><span class = 'names'>Price: </strong></span> </td>
  293.      <td><input name="price" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['price']) ) echo $_POST['price']; ?>" id="price" size="50" maxlength="70" /> </td>
  294.      <br />
  295.          </tr>
  296.          <td><span class = 'names'>Start Time and Date: </strong></span> </td>
  297.          <td><?PHP eventscalendar(); ?> </td>
  298.          <br />
  299.         </tr>
  300.          <td><span class = 'names'>End Time and Date: </strong></span> </td>
  301.          <td><?PHP endtime(); ?> </td>
  302.          <br />
  303.          </tr>
  304.  </p> <td><p><span class = 'names'>Email: </strong></span> </td>
  305.         <td><input name="email" type="text" value="<?php if(isset($_POST['reset'])) echo '';    elseif(isset($_POST['email']) ) echo $_POST['email']; ?>" id="sdate" size="50" maxlength="70" /> </td>
  306.         <br />
  307.               </tr>
  308.        
  309.  </table>
  310.        <!--buttons-->
  311.        <input type="submit" name="Submit" value="Submit">
  312.      
  313.        <input name="reset" type="submit" id="Reset" value="Reset">
  314.      
  315.        <input type="hidden" name="submitted" />
  316.        </p>
  317.        </p>
  318.          </p>
  319. </form>
  324. <div class="footer">
  325.  <?php include ("footer.php") ?>
  326. </div>
  329. ------------------------------------------------results page-----------------------
  334. <div class="header">
  335. <?php include ("header2.php") ?>
  336. </div>
  337. <?php
  340. require_once("configproject.php");
  344. // Number of records to show per page:
  345. $display = 8;
  347. // Determine how many pages there are.
  348. if (isset($_GET['np'])) { // Already been determined.
  350.     $num_pages = $_GET['np'];
  352. } else { // Need to determine.
  354.     // Count the number of records
  355.     $query = "SELECT COUNT(*) FROM events";
  356.     $result = mysql_query ($query)or die("first query");
  357.     $row = mysql_fetch_array ($result, MYSQL_NUM);
  358.     $num_records = $row[0];
  360.     // Calculate the number of pages.
  361.     if ($num_records > $display) { // More than 1 page.
  362.         $num_pages = ceil ($num_records/$display);
  363.     } else {
  364.         $num_pages = 1;
  365.     }
  366.     
  367. } // End of np IF.
  369. // Determine where in the database to start returning results.
  370. if (isset($_GET['s'])) {
  371.     $start = $_GET['s'];
  372. } else {
  373.     $start = 0;
  374. }
  378.     
  379. // Make the query.
  380. $query = "SELECT id, event, event_descrption,place, thumbdata,DATE_FORMAT(stime, '%e %d, %Y') AS st, TIME_FORMAT(stime, '%l:%i, %p') AS stime, TIME_FORMAT(etime, '%l:%i, %p')AS etime, email, price FROM events LIMIT $start, $display";
  382. $query2 = "SELECT CONCAT( stime, ' ', etime )
  383. FROM `events";
  384. $result = mysql_query ($query) or die("second query"); // Run the query.
  385. $num = mysql_num_rows($result);
  386.                 
  387.             // Display the results
  388. if ($num > 0) {
  389.             
  390.             echo "<p class = 'names'>Currently showing $num Results</p></span>";
  391.     }
  392.     
  394. // Table header.
  398. echo '<table align="center" cellspacing="0" cellpadding="5">
  399. <tr>
  400. <th scope="col" class = "names">Date </span></th>
  401. <th scope="col" class = "names">Time </span></th>
  402.       <th scope="col" class = "names">Event </span></th>
  403.     <th scope="col" class = "names">Descrption </span></th>
  404.   <th scope="col" class = "names">Location </span></th>
  405.     <th scope="col" class = "names">Contact</span></th>
  406. <th scope="col" class = "names">Price</span></th>
  407.   <th scope="col" class = "names">RSVP</span></th>
  408.   
  410. </tr>
  411. ';
  413. // Fetch and print all the records.
  414. $bg = '#eeeeee'; // Set the background color.
  415. while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  416.     $bg = ($bg=='#7b1d1d' ? '#ffffff' : '#7b1d1d'); // Switch the background color.
  417.     echo '<tr bgcolor="' . $bg . '">
  418. <td align="left">'.$row['st'].$row['stime'].'</td>
  419. <td align="left">'.$row['et'].$row['etime'].'</td>
  420. <td align="left">'.$row['event'].'</td>
  421. <td align="left" >'.$row['event_descrption'].'</td>
  422. <td align="left">'.$row['place'].'</td>
  423. <td align="left"><a href="mailto?id=' . $row['id'] . '">Contact</a></td>
  424. <td align="left" >'.$row['price'].'</td>
  425. <td align="left"><a href="edit_user.php?id=' . $row['id'] . '">RSVP</a></td>
  427.     </tr>
  428.     ';
  429. }
  433. mysql_free_result ($result); // Free up the resources.    
  435. mysql_close(); // Close the database connection.
  437. // Make the links to other pages, if necessary.
  438. if ($num_pages > 1) {
  439.     
  440.     echo '<br /><p>';
  441.     // Determine what page the script is on.    
  442.     $current_page = ($start/$display) + 1;
  443.     
  444.     // If it's not the first page, make a Previous button.
  445.     if ($current_page != 1) {
  446.         echo '<a href="results2.php?s=' . ($start - $display) . '&np=' . $num_pages . '">Previous</a> ';
  447.     }
  448.     
  449.     // Make all the numbered pages.
  450.     for ($i = 1; $i <= $num_pages; $i++) {
  451.         if ($i != $current_page) {
  452.             echo '<a href="results2.php?s=' . (($display * ($i - 1))) . '&np=' . $num_pages . '">' . $i . '</a> ';
  453.         } else {
  454.             echo $i . ' ';
  455.         }
  456.     }
  457.     
  458.     // If it's not the last page, make a Next button.
  459.     if ($current_page != $num_pages) {
  460.         echo '<a href="results2.php?s=' . ($start + $display) . '&np=' . $num_pages . '">Next</a>';
  461.     }
  462.     
  463.     echo '</p>';
  464.     
  465. } // End of links section.
  466.     
  468. ?>
Moderator Remark: Use [code][/code] to encapsulate code snippets
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post October 3rd, 2009, 10:34 am

  • PolishHurricane
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: Feb 17, 2005
  • Posts: 1585
  • Status: Offline

Post October 4th, 2009, 11:55 am

Have you checked the forms "action" attribute to make sure it is pointing to the script that processes the form data?

Honestly you'd have better luck zipping up all your PHP files as a whole and putting them on a web server somewhere. This code dump is ridiculous.
There's no place like 127.0.0.1, badass part is now it's ::1
  • alex89
  • Bronze Member
  • Bronze Member
  • User avatar
  • Joined: Jul 18, 2008
  • Posts: 239
  • Loc: Western Australia
  • Status: Offline

Post October 4th, 2009, 6:10 pm

In the results page you're trying to find $_GET('np'). None of your form elements are called this, I don't know how you expect this to work.

Add print_r $_GET; to your results page, and you'll see all the information being posted to it.

Since you're using method="post", you should use $_POST('varname'). See here

Page 1 of 1

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 155 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.