newac_add.php (working perfectly)
Code: Select all
<?php
include ('connect.php');
$dbconnect = mysql_select_db('aircraftsales');
$actypelist = mysql_query('SELECT ID, type FROM ac_type');
?>
<form name="addaircraft" method="post" action="<?=$_SERVER['PHP_SELF']?>"
enctype="multipart/form-data">
Add aircraft to which aircraft type?:
<select name="typeID">
<option value="">Aircraft Type</option>
<option value="">- - - - - - - -</option>
<?php
while($actype = mysql_fetch_array($actypelist)) {
$typeID = $actype['ID'];
$type = $actype['type'];
echo('<option value="' . $typeID . '">' . $type . "</option>\n" );
}
?>
</select>
Aircraft order: <input type="text" size="5" maxlength="10" name="description_order">
<br><br>
Aircraft Name: <input type="text" size="50" maxlength="100" name="ac_name">
<br>
Serial Number: <input type="text" size="50" maxlength="100" name="serial_num"><BR>
Registration Number: <input type="text" size="50" maxlength="100" name="registration_num"><BR>
Engines<BR>
Left:<input type="text" size="50" maxlength="100" name="L_engine"><BR>
Right:<input type="text" size="50" maxlength="100" name="R_engine"><BR>
Propellers<br>
Left:<input type="text" size="50" maxlength="100" name="L_propeller"><BR>
Right:<input type="text" size="50" maxlength="100" name="R_propeller"><BR>
Center:<input type="text" size="50" maxlength="100" name="C_propeller"><BR>
Interior:
<br>
<textarea cols="80" rows="10" name="interior"></textarea>
<script language="JavaScript1.2" defer>
editor_generate('topic_text');
</script>
<br><br>
Exterior<br>
<textarea cols="80" rows="10" name="exterior"></textarea><br>
Optional Equipment:<br>
<textarea cols="80" rows="10" name="optional_equip"></textarea><br>
Avionics:<br>
<textarea cols="80" rows="10" name="avionics"></textarea>
<br>
Exterior Image: <input type="file" name="img_exterior"> <br>
Cockpit Image: <input type="file" name="img_cockpit"> <br>
Interior Image: <input type="file" name="img_interior"> <br>
<input type="submit" value="submit" name="submit">
</form>
<?php
if(isset($_POST['submit'])) {
$description_order = (int) $_POST['description_order'];
$typeID = (int) $_POST['typeID'];
$ac_name = addslashes($_POST['ac_name']);
$serial_num = addslashes($_POST['serial_num']);
$registration_num = addslashes($_POST['registration_num']);
$L_engine = addslashes($_POST['L_engine']);
$R_engine = addslashes($_POST['R_engine']);
$L_propeller = addslashes($_POST['L_propeller']);
$R_propeller = addslashes($_POST['R_propeller']);
$C_propeller = addslashes($_POST['registration_num']);
$interior = addslashes($_POST['interior']);
$exterior = addslashes($_POST['exterior']);
$optional_equip = addslashes($_POST['optional_equip']);
$avionics = addslashes($_POST['avionics']);
//confused somewhere here.
if ($_FILES['img_exterior']['type'] == "image/gif" or $_FILES['img_exterior']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_exterior']['tmp_name'], "images/".$_FILES['img_exterior']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_exterior']['name'].")";
}
//}
//interior upload
if ($_FILES['img_interior']['type'] == "image/gif" or $_FILES['img_interior']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_interior']['tmp_name'], "images/".$_FILES['img_interior']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_interior']['name'].")";
}
//}
if ($_FILES['img_cockpit']['type'] == "image/gif" or $_FILES['img_cockpit']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_cockpit']['tmp_name'], "images/".$_FILES['img_cockpit']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_cockpit']['name'].")";
}
//}
echo($actype_ID);
$sql = 'INSERT INTO ac_description SET
description_order = '''. $description_order . ''',
actype_ID = ''' . $typeID . ''',
ac_name = ''' . $ac_name . ''',
serial_num = ''' . $serial_num . ''',
registration_num = ''' . $registration_num . ''',
L_engine = ''' . $L_engine . ''',
R_engine = ''' . $R_engine . ''',
L_propeller = ''' . $L_propeller . ''',
R_propeller = ''' . $R_propeller . ''',
C_propeller = ''' . $C_propeller . ''',
interior = ''' . $interior . ''',
exterior = ''' . $exterior . ''',
optional_equip = ''' . $optional_equip . ''',
avionics = ''' . $avionics . ''',
img_exterior = ''' . $_FILES['img_exterior']['name'] . ''',
img_interior = ''' . $_FILES['img_interior']['name'] . ''',
img_cockpit = ''' . $_FILES['img_cockpit']['name'] . '''';
if (@mysql_query($sql)) {
echo('The new aircraft has been added ');
} else {
echo('could not add new aircraft:' . mysql_error());
}
}
?>newac_edit.php (page I'm having problems with)
Code: Select all
<?php
$type = $_GET['type'];
$ac_desc_ID = $_GET['ac_desc_ID'];
//echo($type);
//echo($ac_desc_ID);
include ("connect.php");
echo("Edit from the <b> $type </b>aircraft type ");
$aircraftlist = mysql_query("SELECT * FROM ac_description WHERE ID='$ac_desc_ID'");
$aircraft = mysql_fetch_array($aircraftlist);
$description_order = $aircraft['description_order'];
$ac_desc_ID = $aircraft['ac_desc_ID'];
$ac_name = $aircraft['ac_name'];
//$serial_num = $aircraft['serial_num'];
$registration_num = $aircraft['registration_num'];
$L_engine = $aircraft['L_engine'];
$R_engine = $aircraft['R_engine'];
$L_propeller = $aircraft['L_propeller'];
$R_propeller = $aircraft['R_propeller'];
$C_propeller = $aircraft['registration_num'];
$interior = $aircraft['interior'];
$exterior = $aircraft['exterior'];
$optional_equip = $aircraft['optional_equip'];
$avionics = $aircraft['avionics'];
?>
<form name="editaircraft" method="post" action="<?=$_SERVER['PHP_SELF']?>" enctype="multipart/form-data">
Add aircraft to which aircraft type?:
<select name="typeID">
<option value="">Aircraft Type</option>
<option value="">- - - - - - - -</option>
<?php
//problems here....
$actypelist = mysql_query("Select * from ac_type where ID='$ac_desc_ID' AND type='$type'");
while($actype = mysql_fetch_array($actypelist)) {
$typeID = $actype['ID'];
$type = $actype['type'];
echo
'
<option value="'.$typeID.'">'.$type.'</option>
';
}
?>
</select>
Aircraft order: <input type="text" size="5" maxlength="10" name="description_order" value="<?=$description_order?>">
<br><br>
Aircraft Name: <input type="text" size="50" maxlength="100" name="ac_name" value="<?=$ac_name?>">
<br>
Serial Number: <input type="text" size="50" maxlength="100" name="serial_num" value="<?=$serial_num?>"><BR>
Registration Number: <input type="text" size="50" maxlength="100" name="registration_num" value="<?=$registration_num?>"><BR>
Engines<BR>
Left:<input type="text" size="50" maxlength="100" name="L_engine" value="<?=$L_engine?>"><BR>
Right:<input type="text" size="50" maxlength="100" name="R_engine" value="<?=$R_engine?>"><BR>
Propellers<br>
Left:<input type="text" size="50" maxlength="100" name="L_propeller" value="<?=$L_propeller?>"><BR>
Right:<input type="text" size="50" maxlength="100" name="R_propeller" value="<?=$R_propeller?>"><BR>
Center:<input type="text" size="50" maxlength="100" name="C_propeller" value="<?=$C_propeller?>"><BR>
Interior:
<br>
<textarea cols="80" rows="10" name="interior"><?=$interior?></textarea>
<script language="JavaScript1.2" defer>
editor_generate('topic_text');
</script>
<br><br>
Exterior<br>
<textarea cols="80" rows="10" name="exterior"><?=$exterior?></textarea><br>
Optional Equipment:<br>
<textarea cols="80" rows="10" name="optional_equip"><?=$optional_equip?></textarea><br>
Avionics:<br>
<textarea cols="80" rows="10" name="avionics"><?=$avionics?></textarea>
<br>
Exterior Image: <input type="file" name="img_exterior" > <br>
Cockpit Image: <input type="file" name="img_cockpit"> <br>
Interior Image: <input type="file" name="img_interior"> <br>
<input type="hidden" name="ac_desc_ID" value="<?=$ac_desc_ID?>">
<input type="submit" value="submit" name="edit_aircraft">
</form>
<?php
if(isset($_POST['edit_aircraft'])) {
$description_order = (int) $_POST['description_order'];
$typeID = (int) $_POST['typeID'];
$ac_name = addslashes($_POST['ac_name']);
$serial_num = addslashes($_POST['serial_num']);
$registration_num = addslashes($_POST['registration_num']);
$L_engine = addslashes($_POST['L_engine']);
$R_engine = addslashes($_POST['R_engine']);
$L_propeller = addslashes($_POST['L_propeller']);
$R_propeller = addslashes($_POST['R_propeller']);
$C_propeller = addslashes($_POST['registration_num']);
$interior = addslashes($_POST['interior']);
$exterior = addslashes($_POST['exterior']);
$optional_equip = addslashes($_POST['optional_equip']);
$avionics = addslashes($_POST['avionics']);
//Update photos if any.
if ($_FILES['img_exterior']['type'] == "image/gif" or $_FILES['img_exterior']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_exterior']['tmp_name'], "images/".$_FILES['img_exterior']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_exterior']['name'].")";
}
//}
//interior upload
if ($_FILES['img_interior']['type'] == "image/gif" or $_FILES['img_interior']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_interior']['tmp_name'], "images/".$_FILES['img_interior']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_interior']['name'].")";
}
//}
if ($_FILES['img_cockpit']['type'] == "image/gif" or $_FILES['img_cockpit']['type'] == "image/pjpeg"){
move_uploaded_file($_FILES['img_cockpit']['tmp_name'], "images/".$_FILES['img_cockpit']['name'])
or die ("Could not copy"); }
else {
echo "Could Not Copy, Wrong Filetype (".$_FILES['img_cockpit']['name'].")";
}
$sql = 'UPDATE ac_description SET
description_order = '''. $description_order . ''',
actype_ID = ''' . $typeID . ''',
ac_name = ''' . $ac_name . ''',
serial_num = ''' . $serial_num . ''',
registration_num = ''' . $registration_num . ''',
L_engine = ''' . $L_engine . ''',
R_engine = ''' . $R_engine . ''',
L_propeller = ''' . $L_propeller . ''',
R_propeller = ''' . $R_propeller . ''',
C_propeller = ''' . $C_propeller . ''',
interior = ''' . $interior . ''',
exterior = ''' . $exterior . ''',
optional_equip = ''' . $optional_equip . ''',
avionics = ''' . $avionics . ''',
img_exterior = ''' . $_FILES['img_exterior']['name'] . ''',
img_interior = ''' . $_FILES['img_interior']['name'] . ''',
img_cockpit = ''' . $_FILES['img_cockpit']['name'] . ''',
WHERE ID = "$ac_desc_ID"';
if(mysql_query($sql)) {
echo('The chapter has been edited');
}
else {
echo('error editing chapter:' . mysql_error());
}
}
?>