include "init.php"; $id = trim( $_POST["id"] ); if( $id != "" ) { // Is postback $name = trim( $_POST["name"] ); $address = trim( $_POST["address"] ); $email = trim( $_POST["email"] ); $phone = trim( $_POST["phone"] ); $name = utf8_encode($name); $address = utf8_encode($address); $email = utf8_encode($email); $phone = utf8_encode($phone); $name = $conn->real_escape_string($name); $address = $conn->real_escape_string($address); $email = $conn->real_escape_string($email); $phone = $conn->real_escape_string($phone); $sql = "UPDATE sct_schools SET name='".$name."', address='".$address."', email='".$email."', phone='".$phone."' WHERE id=".$id.";"; //echo $sql; if( $conn->query($sql) === TRUE ) { header('Location: showschool.php?id='.$id); die(); } else { die("Error in update school information query: ".$sql); } } include "header.php"; ?>