Unable to insert data in a table using php

Question

I have this following code->

html5 code block:

<div class="col-md-8 blogger-right-container">
                <form action="blogger_account.php" method="post" role="form" enctype="multipart/form-data">
                    <div class="form-group">
                        <h2>Blog Title</h2>
                        <input type="text" class="form-control" name="blog_title" placeholder="Enter title for your blog.">
                    </div>
                    <div class="form-group">
                        <h2>Blog Content</h2>
                        <textarea name="blog_content" class="form-control" cols="30" rows="10" placeholder="Enter the content here."></textarea>
                    </div>
                    <div class="form-group" style="text-align: center;">
                        <input type="submit" class="btn btn-success btn-lg" name="add" value="Insert">
                    </div>
                </form>

            </div> <!-- blogger right container -->

php code block: `

if(isset($_POST['add'])){

    $blogger = $_SESSION['blogger_email'];
    $blog_title = $_POST['blog_title'];
    $blog_content = $_POST['blog_content'];

    $insert_blog = "insert into blogs (blogger_email,blog_title,blog_content) values ('$blogger',$blog_title','$blog_content')";

    $run_blog = mysqli_query($con,$insert_blog);

    if($run_blog){
    echo "<script>alert('Blog inserted.')</script>";
    echo "<script>window.open('blogger_account.php','_self')</script>";
    }

}`

The php code block is not inserting the data in blogs table. The columns are in proper order, but still i tried to change the sequence and it didn't worked. Can anyone tell me whats wrong with my code.

session_start is given in the starting of html document. Still it isn't working — Arpit Nagpal
– Arpit Nagpal, Commented May 18, 2017 at 10:08

Community · Accepted Answer · 2017-05-23 12:10:33Z

0

Please mention Error you are receiving.

In order to show detailed php errors, navigate to " How to get useful error messages in PHP? "

MySQL errors in php can be thrown this way --> PHP MySQL error handling

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered May 18, 2017 at 10:12

khalidmehmoodawan

6791 gold badge8 silver badges22 bronze badges

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

1 Comment

khalidmehmoodawan Over a year ago

In order to show detailed php errors, navigate to " How to get useful error messages in PHP? " MySQL errors in php can be thrown this way --> PHP MySQL error handling

Collectives™ on Stack Overflow

Unable to insert data in a table using php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related