无法将post和images值添加到数据库中

Question

i'm trying to add text and images using

Image is successfully added into folder path. but the value of text and images did not add into database

<?php

    function insertpost(){
        global $connect;
        if(isset($_POST['sendpost']))
        {
            $title                 = mysqli_real_escape_string($connect,$_POST["title"]);
            $target_image          = "images/".basename($_FILES['post_image']['name']);
            $post_image            = $_FILES['post_image']['name'];

            $insert_post_and_image = "INSERT INTO table(title, image) VALUES ('$title','$post_image')";
            mysqli_query($connect, $insert_post_and_image);

                if(move_uploaded_file($_FILES['post_image']['tmp_name'], $target_image))
                {
                        echo "<h3>Posted to timeline!</h3>";
                }
        }   
    }
?>

html code

<form action="" method="post" id="form" enctype="multipart/form-data">
                        <input type="text" name="title"/>
                        <input type="file" name="post_image"/>
                        <input type="submit" name="sendpost" value="POST"/> 
</form>

any solution? thanks

Answer 1

I think you have mistake in table name in your query .Just replace table with your actual table name.For example if you have defined table name as user then your query must be

$insert_post_and_image = "INSERT INTO user(title, image) VALUES ('$title','$post_image')";

Also you can check error using

if (mysqli_query($connect, $insert_post_and_image)) {
    echo "success";
} else {
    echo "Error: " . mysqli_error($connect);
}