Ver Mensaje Individual
  #1 (permalink)  
Antiguo 28/12/2012, 06:34
carlosuc99
 
Fecha de Ingreso: junio-2011
Mensajes: 342
Antigüedad: 12 años, 9 meses
Puntos: 5
Exclamación Errores Formulario

Buenas,

Tengo este formuario:

Código PHP:
Ver original
  1. <form action="new_aircraft_process.php" method="post" enctype="application/x-www-form-urlencoded">
  2.     <table>
  3.  
  4.     <tr><td class=Forms>ICAO:</td><td><input maxlength="4" type="text" name="ICAO" size="30"/></td></tr>
  5.    
  6.     <tr><td class=Forms>Name:</td><td><input type="text" name="Name" size="30"/></td></tr>
  7.        
  8.     <tr><td class=Forms>Weight Empty: </td><td><input type="text" name="WeightEmpty" size="30"/></td></tr>
  9.        
  10.     <tr><td class=Forms>Weight Full: </td><td><input type="text" name="WeightFull" size="30"/></td></tr>
  11.        
  12.     <tr><td class=Forms>Cargo Full: </td><td><input type="text" name="CargoFull" size="30"/></td></tr>
  13.    
  14.     <tr><td class=Forms>Cruise Speed: </td><td><input type="text" name="CruiseSpeed" size="30"/></td></tr>
  15.    
  16.     <tr><td class=Forms>Range: </td><td><input type="text" name="Range" size="30"/></td></tr>
  17.        
  18.     <tr><td class=Forms>Price: </td><td><input type="text" name="Price" size="30"/></td></tr>
  19.  
  20.     <tr><td class=Forms>Number Classes:</td><td><select name="numberclasses" id="numberclasses" onchange="callAjax()">
  21.         <option value="0">Select Number of Classes</option>
  22.         <?php
  23.         echo'<option value="1">One Classes (Economy)</option>';
  24.         echo'<option value="2">Two Classes (Business & Economy)</option>';
  25.         echo'<option value="3">Three Classes (First, Business & Economy)</option>';
  26.         ?>
  27.     </select></td></tr>
  28.  
  29.  
  30.  
  31.     <tr><td class=Forms>First Class:</td><td><input disabled="disabled" type="text" id="FirstClass" name="FirstClass" size="30"/></td></tr>
  32.     <tr><td class=Forms>Business Class:</td><td><input type="text" id="BusinessClass" name="BusinessClass" size="30"/></td></tr>
  33.     <tr><td class=Forms>Economy Class:</td><td><input type="text" id="EconomyClass" name="EconomyClass" size="30"/></td></tr>
  34.  
  35.         <tr><td></td><td><input type="submit" name="Submit" value="Submit"/></td></tr>
  36.          </table>
  37.     </form>

Este es el proceso:

Código PHP:
Ver original
  1. <?php
  2.  
  3. include('./db.inc.php');
  4.  
  5. $ICAO = $_POST['ICAO'];
  6. $Name = $_POST['Name'];
  7. $WeightEmpty = $_POST['WeightEmpty'];
  8. $WeightFull = $_POST['WeightFull'];
  9. $CargoFull = $_POST['CargoFull'];
  10. $CruiseSpeed = $_POST['CruiseSpeed'];
  11. $Range = $_POST['Range'];
  12. $Price = $_POST['Price'];
  13. $FirstClass = $_POST['FirstClass'];
  14. $BusinessClass = $_POST['BusinessClass'];
  15. $EconomyClass = $_POST['EconomyClass'];
  16.  
  17.  
  18.  
  19.        
  20.     mysql_query("INSERT INTO aircrafts (ICAO, Name, WeightEmpty, WeightFull, CargoFull, CruiseSpeed, Range, Price, FirstClass, BusinessClass, EconomyClass) VALUES ('$ICAO', '$Name', '$WeightEmpty', '$WeightFull', '$CargoFull', '$CruiseSpeed', '$Range', '$Price', '$FirstClass', '$BusinessClass', '$EconomyClass')") or die(mysql_error());
  21.    
  22.  
  23.    
  24.     echo '<h3 style="color: green;">Aeronave adquirida correctamente.<h3/>';
  25.    
  26. ?>

Me da estos errores:

Cita:
Notice: Undefined index: FirstClass in C:\xampp\htdocs\new_aircraft_process.php on line 13
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range, Price, FirstClass, BusinessClass, EconomyClass) VALUES ('a320', 'A320', '' at line 1
Por que?