Tengo este formuario:
Código PHP:
Ver original
<form action="new_aircraft_process.php" method="post" enctype="application/x-www-form-urlencoded"> <table> <tr><td class=Forms>ICAO:</td><td><input maxlength="4" type="text" name="ICAO" size="30"/></td></tr> <tr><td class=Forms>Name:</td><td><input type="text" name="Name" size="30"/></td></tr> <tr><td class=Forms>Weight Empty: </td><td><input type="text" name="WeightEmpty" size="30"/></td></tr> <tr><td class=Forms>Weight Full: </td><td><input type="text" name="WeightFull" size="30"/></td></tr> <tr><td class=Forms>Cargo Full: </td><td><input type="text" name="CargoFull" size="30"/></td></tr> <tr><td class=Forms>Cruise Speed: </td><td><input type="text" name="CruiseSpeed" size="30"/></td></tr> <tr><td class=Forms>Range: </td><td><input type="text" name="Range" size="30"/></td></tr> <tr><td class=Forms>Price: </td><td><input type="text" name="Price" size="30"/></td></tr> <tr><td class=Forms>Number Classes:</td><td><select name="numberclasses" id="numberclasses" onchange="callAjax()"> <option value="0">Select Number of Classes</option> <?php echo'<option value="1">One Classes (Economy)</option>'; echo'<option value="2">Two Classes (Business & Economy)</option>'; echo'<option value="3">Three Classes (First, Business & Economy)</option>'; ?> </select></td></tr> <tr><td class=Forms>First Class:</td><td><input disabled="disabled" type="text" id="FirstClass" name="FirstClass" size="30"/></td></tr> <tr><td class=Forms>Business Class:</td><td><input type="text" id="BusinessClass" name="BusinessClass" size="30"/></td></tr> <tr><td class=Forms>Economy Class:</td><td><input type="text" id="EconomyClass" name="EconomyClass" size="30"/></td></tr> <tr><td></td><td><input type="submit" name="Submit" value="Submit"/></td></tr> </table> </form>
Este es el proceso:
Código PHP:
Ver original
<?php include('./db.inc.php'); $ICAO = $_POST['ICAO']; $Name = $_POST['Name']; $WeightEmpty = $_POST['WeightEmpty']; $WeightFull = $_POST['WeightFull']; $CargoFull = $_POST['CargoFull']; $CruiseSpeed = $_POST['CruiseSpeed']; $Range = $_POST['Range']; $Price = $_POST['Price']; $FirstClass = $_POST['FirstClass']; $BusinessClass = $_POST['BusinessClass']; $EconomyClass = $_POST['EconomyClass']; 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()); echo '<h3 style="color: green;">Aeronave adquirida correctamente.<h3/>'; ?>
Me da estos errores:
Cita:
Por que? 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
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