Using php pdo to insert records in database

Question

Am using bellow php pdo to insert user blog post into my database but am getting error like this Fatal error: Call to a member function prepare() on a non-object in /public_html/postaction.php on line 34 i have tried to fix but keep giving me different errors. is there any other way to do this or fix this one am using?

<?php
if($_POST) {

$sql = "INSERT INTO blog_post(BID,
            blog_title,
            blog_body,
            comments,
            UserName,
            Time,
            Date,
            likes,
            ip) VALUES (
            :BID, 
            :blog_title, 
            :blog_body, 
            :comments, 
            :UserName,
            :Time,
            :Date,
            :likes,
            :ip)";

$stmt = $pdo->prepare($sql);

$stmt->bindParam(':BID', $newId, PDO::PARAM_STR);       
$stmt->bindParam(':blog_title', $_POST['blog_title'], PDO::PARAM_STR); 
$stmt->bindParam(':blog_body', $_POST['blog_body'], PDO::PARAM_STR);
$stmt->bindParam(':comments', $_POST['comments'], PDO::PARAM_STR); 
$stmt->bindParam(':UserName', $_POST['UserName'], PDO::PARAM_STR); 
$stmt->bindParam(':Time', $_POST['Time'], PDO::PARAM_STR); 
$stmt->bindParam(':Date', $_POST['Date'], PDO::PARAM_STR); 
$stmt->bindParam(':likes', $_POST['likes'], PDO::PARAM_STR); 
$stmt->bindParam(':ip', $_POST['ips'], PDO::PARAM_STR);   

$stmt->execute(); 
$newId = $pdo->lastInsertId();
header('location: postblog.php?d=1');
}
else if(!isset($_POST)){
header('location: postblog.php?err=1');     
echo "Sorry!";
}
else{
    header('location: postblog.php?else=1'); 
}
?>

form failing, connection is other than PDO, wrong db/table, who knows. Oh wait, you do. — Funk Forty Niner, Jan 12 '16 at 16:20
Is there any other way to get it done? i don't really understand what you mean @ Fred — Codesoft, Jan 12 '16 at 16:23
and if your `BID` is an AI column, that could be it too, or part of the problem. Not much I can do or anyone else until we know what the whole picture looks like. check for error with PDO and error reporting. — Funk Forty Niner, Jan 12 '16 at 16:24

score 4 · Accepted Answer · edited Aug 09 '23 at 08:38

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// prepare sql and bind parameters
$stmt = $conn->prepare("INSERT INTO table(firstname, lastname, email)
VALUES (:firstname, :lastname, :email)");
$stmt->bindParam(':firstname', $firstname);
$stmt->bindParam(':lastname', $lastname);
$stmt->bindParam(':email', $email);

// insert a row
$firstname = "sample";
$lastname = "lastsamp";
$email = "sample@example.com";
$stmt->execute();

header("Location: ."); // a redirect is a must after successful POST request

but you did not vote me up. But all the best happy coding – Michael Jan 13 '16 at 08:46 — Michael, Jan 13 '16 at 08:46

Using php pdo to insert records in database

1 Answers1

Linked