php - 找不到错误:/

Question

有客户数据表。试图合并一个编辑功能。当前，该表的“编辑”链接具有<a href>。

        <tr>

            <th><strong>Extras</strong></th>

        </tr>
        <?php while($r = mysqli_fetch_assoc($res)){
        ?>
        <tr> 
            <td><a href="crud/update.php?id='.$r['id'].'">Edit</a></td>
            <td><input type="button" onClick="deleteme(<?php echo $r['u_uid']; ?>)" name="Delete" value="Delete"></td>
             </tr>

   function deleteme(delid)
  { if(confirm("Are you sure you want to Delete?")){
    window.location.href='crud/delete.php';
   }
 } 
 </script>
        <?php } ?>

注意:

$ReadSql = "SELECT * FROM `contact` WHERE users_id=$uid ORDER BY Name";
$res = mysqli_query($connection, $ReadSql);

我希望将用户带到以以下内容开头的crud/update.php:

<?php
 error_reporting();
   require_once('connect.php');
   $id = $_GET['id'];
   $SelSql = "SELECT * FROM `contact` WHERE id=$id";
   $res = mysqli_query($connection, $SelSql);
   $r = mysqli_fetch_assoc($res);

if(isset($_POST) & !empty($_POST)){
 $name =  mysqli_real_escape_string($connection,$_POST['name']);
  //and other credentials 

  $UpdateSql = "UPDATE `contact` SET Name='$name', Company='$comp', 
 Title='$title', Phone='$phone', Email='$email', Address='$location' WHERE id=$id"; 

拔掉头发是因为我找不到每次按下“编辑”链接时都会出错的原因。

干杯们。

Answer 1

您收到404的原因是您没有正确的链接。

您已经在线混合了HTML和PHP

<a href="crud/update.php?id='.$r['id'].'">Edit</a>

它应该是:

<a href="crud/update.php?id=<?php echo $r['id'] ?>">Edit</a>