donglanche9257 2013-02-04 12:14
浏览 6
已采纳

更新帖子不工作

I recently made a code that updates my posts on my blog. It worked perfectly on localhost. But when i uploaded it online it did not work any more. The weird thing is it doesn't even display a error so i have no idea where to look. Can someone please help me ?

require('config.php');
$query = "SELECT * FROM project ORDER BY idproject DESC";
$result = mysqli_query($verbinding, $query ) or die (mysqli_error('kan geen verbinding maken met de database'));
if(isset($_POST['editBut'])){
    $editTitle = $_POST['editName'];
    $editThis = mysqli_query($verbinding, "SELECT * FROM project WHERE title = '".$editTitle."'");
    $values = mysqli_fetch_assoc($editThis);
}
if(isset($_POST['update'])){
    $editedTitle = $_POST['newTitle'];
    $editedText = $_POST['newTekst'];
    $oldTitle = $_POST['oldTitle'];
    $date = $_POST['datum'];
    $updater = mysqli_query($verbinding, "UPDATE Project SET title='".$editedTitle."', content='".$editedText."' WHERE title='".$oldTitle."' AND datum='".$date."'");
    echo $updater;
    header('location:editPost.php?id=1');
}
if(isset($_GET['id'])){
    echo 'post has been succesfully updated';
}

<?php if(isset($_POST['editBut'])){ ?>
            <form action="" method="post">
                Title: <input type="text" name="newTitle" value="<?php echo $values['title'] ?>"><br>
                Text: <textarea type="text" name="newTekst" id="newTekst"><?php echo $values['content'] ?></textarea><br>
                <input type="hidden" value="<?php echo $values['title'] ?>" name="oldTitle">
                <input type="hidden" value="<?php echo $values['datum'] ?>" name="datum">
                <input type="submit" name="update" value="Edit post">
            </form>
        <?php } else { ?>
            <p>Find the post you want to edit:</p>
            <form action="" method="post">
                <select name="editName">
                    <?php
                    while ($row = mysqli_fetch_assoc($result)) {
                       ?> <option value="<?php echo $row['title'] ?>"><?php echo $row['title'] ?></option>
                    <?php } ?>
                </select>
                <input type="submit" name="editBut" value="Choose">
            </form>
        <?php } ?>
  • 写回答

1条回答 默认 最新

  • duandong7980 2013-02-04 12:21
    关注

    In update query replace your table name with small letter.

    replace Project with project

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图
  • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
  • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
  • ¥15 一直显示正在等待HID—ISP
  • ¥15 Python turtle 画图