PHP-код для перенаправления, если поле mysql завершено

Попробуй это.

include('connect.inc'); if (( $rows['food'] == "yes" ) || ( $rows['food'] == "no" )) { header('location: mypagelocation.html'); exit; } 

или вы можете написать это так же.

 include('connect.inc'); if (in_array($rows['food'], array("yes","no"))) { header('location: mypagelocation.html'); exit; } в include('connect.inc'); if (in_array($rows['food'], array("yes","no"))) { header('location: mypagelocation.html'); exit; } 

 include('connect.inc'); if (isset($rows['food'])) { header(location: mypagelocation.html'); exit; } else{ // $rows['food'] is not set } в include('connect.inc'); if (isset($rows['food'])) { header(location: mypagelocation.html'); exit; } else{ // $rows['food'] is not set } 

 include('connect.inc'); if ( $rows['food'] == "yes" OR $rows['food'] == "no" ) { header('location: mypagelocation.html'); } в include('connect.inc'); if ( $rows['food'] == "yes" OR $rows['food'] == "no" ) { header('location: mypagelocation.html'); } 

Перед этим убедитесь, что нет выхода.

Полный код:

 <?php session_start(); require_once("connect.inc"); if(!isset($_SESSION['username'])){ header('Location: connect.php'); exit; }else{ $sql = "SELECT attendance1 FROM user WHERE username = '".mysql_real_escape_string($_SESSION['username'])."'"; $res = mysql_query($sql); $row = mysql_fetch_array($res); if(($row[0] == "Yes") || ($row[0] == "No")){ header("Location: redirect_page.html"); exit; } } if(isset($_POST['submit'])){ $sql = "UPDATE user SET attendance1= '" . mysql_real_escape_string($_POST['attendance1']) . "' WHERE username = '" . mysql_real_escape_string($_SESSION['username']) . "'"; mysql_query($sql) or die("Error in SQL: " . mysql_error()); $sql = "UPDATE user SET gender= '" . mysql_real_escape_string($_POST['gender']) . "' WHERE username = '" . mysql_real_escape_string($_SESSION['username']) . "'"; mysql_query($sql) or die("Error in SQL: " . mysql_error()); header("Location: index.html", true, 303); // Look up "303: See Other" exit; } ?>