Volver al Programación / Codificación foro

Tener un problema...

  • kej0283
  • Novice
  • Novice
  • No Avatar
  • Registrado: Sep 30, 2009
  • Mensajes: 18
  • Status: Offline

Nota Octubre 3rd, 2009, 10:34 am

Tengo el siguiente formulario: Heres el código: Mi problema es que cuando entro a la información en la forma: su no ir a mi página de resultados: Abajo está el código de los resultados .. Errores Im no ponerse en forma. ¿Puede alguien ayudarme por favor?? Gracias!
Código: [ 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
  • Registrado: 25 Feb 2008
  • Mensajes: ?
  • Loc: Ozzuland
  • Status: Online

Nota Octubre 3rd, 2009, 10:34 am

  • PolishHurricane
  • Mastermind
  • Mastermind
  • Avatar de Usuario
  • Registrado: Feb 17, 2005
  • Mensajes: 1585
  • Status: Offline

Nota Octubre 4th, 2009, 11:55 am

¿Ha revisado las formas de "acción" atributo para asegurarse de que está apuntando al script que procesa los datos del formulario?

Honestamente youd tener mejor suerte comprimir todos los archivos de su PHP como un todo y ponerlos en un servidor web en alguna parte. Este basurero código es ridículo.
There's no place like 127.0.0.1, badass part is now it's ::1
  • alex89
  • Bronze Member
  • Bronze Member
  • Avatar de Usuario
  • Registrado: Jul 18, 2008
  • Mensajes: 239
  • Loc: Western Australia
  • Status: Offline

Nota Octubre 4th, 2009, 6:10 pm

En la página de resultados que están tratando de encontrar $ _GET ( "NP"). Ninguno de los elementos de su formulario se denominan esto, no sé cómo se espera que esto funcione.

Añadir print_r $ _GET; a la página de resultados, y podrás ver toda la información que se envió a ella.

Puesto que usted está utilizando method = "post", usted debe utilizar $ _POST ( "varname"). Ver aquí

Página 1 de 1

Publicar Información

  • Total de mensajes en este tema: 3 mensajes
  • Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 274 invitados
  • No puede abrir nuevos temas en este Foro
  • No puede responder a temas en este Foro
  • No puede editar sus mensajes en este Foro
  • No puede borrar sus mensajes en este Foro
  • No puede enviar adjuntos en este Foro
 
 

© 2011 Unmelted, LLC. Ozzu® es una marca registrada de Unmelted, LLC