我一直试图让这个代码工作很长一段时间了，但我一直得到这个错误:注意:未定义的索引:id在C:'xampp'htdocs'Project'modify.php第4行下面是代码:
<?php
include 'includes/phpConnection.php';
if(!isset($_POST["submit"])) {
$q = "SELECT * FROM members WHERE ID =".$_GET['id'];
$result = mysql_query($q);
$person = mysql_fetch_array($result);
}
?>
<h1>Edit A Member</h1>
<form method='post' action= '<?php echo $_SERVER['PHP_SELF']; ?>'>
First Name<input type = 'text' name= 'inputFName' value = '<?php echo $person['FIRST_NAME']?>'/>
First Last Name<input type = 'text' name= 'inputLname' value = '<?php echo $person['LAST_NAME']?>'/>
Second Last Name<input type = 'text' name= 'inputLname2' value = '<?php echo $person['LAST_NAME2']?>'/>
Date of Birth<input type = 'date' name= 'inputDoB' value = '<?php echo $person['DATE_OF_BIRTH']?>'/>
relation<input type = 'text' name= 'inputRelation' value = '<?php echo $person['relation_to_me']?>'/>
age<input type = 'text' name = 'age' />
<input type="hidden" name = "id" value="<?php echo $_GET['id'];?>"/>
<br />
<input type="submit" name="submit"/>
</form>
<?php
if(isset($_POST['submit'])){
$u = "UPDATE members SET `FIRST_NAME`='$_POST[inputFName]',`LAST_NAME`='$_POST[inputLname]',`LAST_NAME2`='$_POST[inputLname2]',`DATE_OF_BIRTH`='$_POST[inputDoB]',`AGE`= '$_POST[age]',`relation_to_me`='$_POST[inputRelation]' WHERE ID =".$_POST['id'];
mysql_query($u) or die(mysql_error());
}
?>
请帮
看起来你是在发布id，而不是将其作为查询参数发送。
if($_POST["id"] === "") echo "id is an empty string'n";
if($_POST["id"] === null) echo "id is null'n";
if(isset($_POST["id"])) echo "id is set'n";
if(!empty($_POST["id"])) echo "id is not empty";
在你的代码中更正:
<?php
include 'includes/phpConnection.php';
if(!isset($_POST["submit"]) && isset($_GET["id"])) { // <--- declare id here
$id = intval($_GET["id"]); // <--- declare id here and admit only integer values
$q = "SELECT * FROM members WHERE ID =".$id;
$result = mysql_query($q);
$person = mysql_fetch_array($result);
}
?>
<?php for ($i=0; $i <$num_results; $i++){?>
<tr height="25px">
<td align="center "><?php $row = $result->fetch_assoc();
echo "<strong>". ($i+1)?><td >
<td align="center "><?php echo stripslashes($row['I'd]); ?><td>