doushui3061
2015-10-27 10:57
浏览 19
已采纳

更新和删除时不显示错误

I have those codes that help to update and delete a row from a table:

html:

<table class="imagetable" cellpadding="3" cellspacing="1" width="400px" border="1">
    <th>ID</th>
    <th>Name</th>
    <th>Informations</th>
    <th>Actions</th>
    <tr>
        <td><input type="text" name="id" value="<?php echo $rows['id'] ?>"/></td>
        <td><input type="text" name="med_name" value="<?php echo $rows['med_name'] ?>"/></td>
        <td><input type="text" name="info" value="<?php echo $rows['info']?>"/></td>
        <td>
            <form action="update_del.php" method="post">
                <input class="imgClass_update" type="submit" name="submit1" value="" />
                <input class="imgClass_dell" type="submit" name="submit2" value=""/>
            </form>
        </td>
    </tr>
    <tr>

PHP:

<?php
require_once('../include/global.php');
$id=$_POST['id'];
if(isset($_POST['submit1']))
{
    $name=$_POST['med_name'];
    $info=$_POST['info'];

    $sql = "UPDATE med SET med_name='$name', 
                            info='$info' 
                            WHERE id='$id'";
    $result=mysqli_query($con,$sql) or die('Unable to execute query. '. mysqli_error($con)); 

    if($result){
        header("location:med.php"); 
    }
    else
    {
        header("location:update_false.php"); 

    }
}
if(isset($_POST['submit2']))
{
    $sql = "DELETE FROM med WHERE id='$id'";
    $result=mysqli_query($con,$sql) or die('Unable to execute query. '. mysqli_error($con));
    if(mysqli_affected_rows($con) == 1)
    {
        header("location:med.php"); 
    }
    else
    {
        header("location:update_false.php"); 

    }
}
?>

Nothing is updated nor deleted. And no errors are shown. If someone could help me, I think the problem is too easy but can't see it where.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dozr162106 2015-10-27 10:59
    已采纳

    You are placing <form> tag at wrong place.

    Therefore, your other elements: id, med_name and info are not children of form.

    And they are not getting posted.

    You should start <form> before table and end after table.

    Corrected Code:

    <form action="update_del.php" method="post">
    <table class="imagetable" cellpadding="3" cellspacing="1" width="400px" border="1">
    <tr>
    <th>ID</th>
    <th>Name</th>
    <th>Informations</th>
    <th>Actions</th>
    </tr>
    <tr>
    <td><input type="text" name="id" value="<?php echo $rows['id'] ?>"/></td>
    <td><input type="text" name="med_name" value="<?php echo $rows['med_name'] ?>"/></td>
    <td><input type="text" name="info" value="<?php echo $rows['info']?>"/></td>
    <td>
    <input class="imgClass_update" type="submit" name="submit1" value="Update" />
    <input class="imgClass_dell" type="submit" name="submit2" value="Delete"/>        
    </td>
    </tr>
    </table>
    </form>
    
    点赞 评论
  • duanchao1002 2015-10-27 11:03

    just do this -

    <table class="imagetable" cellpadding="3" cellspacing="1" width="400px" border="1">
    <form action="update_del.php" method="post">
    <th>ID</th>
    <th>Name</th>
    <th>Informations</th>
    <th>Actions</th>
    <tr>
    <td><input type="text" name="id" value="<?php echo $rows['id'] ?>"/></td>
    <td><input type="text" name="med_name" value="<?php echo $rows['med_name'] ?>"/></td>
    <td><input type="text" name="info" value="<?php echo $rows['info']?>"/></td>
    <td>
    
    <input class="imgClass_update" type="submit" name="submit1" value="" />
    <input class="imgClass_dell" type="submit" name="submit2" value=""/>
    
    </td>
    </tr> 
    </form>
    
    点赞 评论

相关推荐 更多相似问题