CODEWITHSUNDEEP
phphtmlmysql
ZozV
ZozV

Reputation: 80

Updating Post not working

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 } ?>

Upvotes: 1

Views: 98

Answers (1)

Devang Rathod
Devang Rathod

Reputation: 6736

In update query replace your table name with small letter.

replace Project with project

Upvotes: 5

Related Questions