Buenas,
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: 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?