php表单处理代码,PHP表单不处理

//1.Create a database connection

$connection = mysql_connect("98.130.0.87", "username", "password");

if (!$connection) {

die("Database connection failed: " . mysql_error());

}

$db_select = mysql_select_db("C263430_testorwallo" ,$connection);

if (!$db_select) {

die("Database selection failed: " . mysql_error());

}

?>

if (intval($_GET['subj']) == 0) {

redirect_to("content.php");

}

if (isset($_POST['submit'])) {

$errors = array();

$required_fields = array('menu_name', 'position', 'visible');

foreach($required_fields as $fieldname) {

if (!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] !=0)) {

$errors[] = $fieldname;

}

}

$fields_with_lengths = array('menu_name' => 30);

foreach($fields_with_lengths as $fieldname => $maxlength ) {

if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength) {

$errors[] = $fieldname; }

}

if (empty($errors)){

//Perform Update

$id = mysql_prep($_GET['subj']);

$menu_name = mysql_prep($_POST['menu_name']);

$position = mysql_prep($_POST['position']);

$visible = mysql_prep($_POST['visible']);

$query = "UPDATE subjects SET

menu_name = '{$menu_name}',

position = {$position},

visible = {$visible}

WHERE id = {$id}";

$result = mysql_query($query, $connection);

if (mysql_affected_rows() == 1) {

//Success

} else {

//Failed

}

} else {

// Errors occurred

}

} //end: (isset($_POST['submit']))

?>

Edit Subject <?php echo $sel_subject ['menu_name'];?> Subject name: Position: $subject_set = get_all_subjects(); $subject_count = mysql_num_rows($subject_set); //$subject_count +1 because we are adding a subject for($count=1; $count <= $subject_count+1; $count++) { echo " if ($sel_subject['position'] == $count) { echo " selected"; } echo ">{$count} "; } ?> Visible: if ($sel_subject['visible'] == 0) { echo " checked";} ?>/>No if ($sel_subject['visible'] == 1) { echo " checked"; } ?>/> Yes Cancel

//5. Close connection

mysql_close($connection);

?>