PHP script for adding data to database not working

Question

I have a php script to input data to a database list in table listdata.

Here is the code for my view.

<form action="../add.php" method="post">

            <label for="title">Title:</label>
            <br>
            <input id="title" type="text" name="title"/>

            <br>

            <label for="body">Body:</label>
            <br>
            <textarea name="body" cols="30" rows="10"></textarea>

            <br>

            <input id="sb" type="submit" values="Add">
</form>

and here is my controller (no framework)

<?php
include 'config.php';
include 'views/add.view.php';

    if ($_SERVER['REQUEST_METHOD'] === 'post') {
            $conn = new PDO('mysql:host=localhost;dbname=list', $config['username'], $config['password']);
            $title = $_POST['title'];
            $body = $_POST['body'];
    if (empty($title) or empty($body)) {
        $status = "<h3>Enter Values</h3>";
        echo $status;
    } else {
        $stmt = $conn->prepare('INSERT INTO listdata(title,body) VALUES(:title,:body)');
        $stmt->bindParam(':title',$title);
        $stmt->bindParam(':body',$body);
        $stmt->execute();
        $status =  "<h3 message='id'>Added<h3>";
        echo $status;
    }



}



?>

When I run it in the browser , before or after posting the values , there is no error , but the

$status

variable is not being echoed and the database is not being updated.

Are you sure it is getting into the first if statement? echo something to make sure you are even getting that far because I suspect you are not — Chitowns24
– Chitowns24, Commented Mar 17, 2014 at 4:54
@Chitowns24 Thank you for finding me another error : IT ' doesen't echo , what do I do? — Nihal Sahu
– Nihal Sahu, Commented Mar 17, 2014 at 4:56
Let's echo $_SERVER['REQUEST_METHOD'] because === means exactly equal and it may not just be 'post' — Chitowns24
– Chitowns24, Commented Mar 17, 2014 at 4:57

Roshna · Accepted Answer · 2014-03-17 04:58:31Z

2

try change your controller to:

<?php
include 'config.php';
include 'views/add.view.php';

    if ($_POST) {
        $conn = new PDO('mysql:host=localhost;dbname=list', $config['username'], $config['password']);
        $title = $_POST['title'];
        $body = $_POST['body'];
       if (empty($title) || empty($body))
       {
           $status = "<h3>Enter Values</h3>";
       }
       else
       {
           $stmt = $conn->prepare('INSERT INTO listdata(title, body) VALUES(:title, :body)');
           $stmt->execute(array(':title'=>$title, ':body'=>$body));
           $status =  "<h3 message='id'>Added<h3>";
       }
       echo $status;
}

?>

answered Mar 17, 2014 at 4:58

Roshna

2062 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Chitowns24 Over a year ago

Instead of checking the request method, he checked to see if there were any POST variables

Roshna Over a year ago

thats why i used simple $_POST check,

Nihal Sahu Over a year ago

<pre><code>if ($_POST)</code></pre> , this is why is still code

Collectives™ on Stack Overflow

PHP script for adding data to database not working

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related