Simple PDO connection/prepare statement query

Question

I'm having trouble getting this to work w/out getting "Call to undefined method PDO::execute() in C:\xampp\htdocs\bookmarks\index.php on line 5"

<?php

    function addBookmark($url, $conn){
        $conn->prepare('INSERT INTO entries (url) VALUES (:url)');
        $conn->execute(array(':url' => $url));
    }

    try {
        $conn = new PDO('mysql:dbname=bookmarks;host=localhost', 'username', 'password');
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        if(isset($_POST['bookmark'])) {
            addBookmark($_POST['bookmark'], $conn);
        }

        $results = $conn->query('select * from bookmarks.entries');

    } catch (exception $e) {
        die($e->getMessage());
    }

?>

I just started fooling around with PDO today so I don't have the best grasp on the concept. Any help would be greatly appreciated.

Instead of setting exception mode *after* connecting, [set it at the time of connect](http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo#15990858). Also, do not use try/catch to die error message. it's pointless and insecure — Your Common Sense, May 12 '13 at 17:28
HTTP Error 500 is not an error itself but just a stub. You need to read the error log for the actual error. Most likely it wold be irrelevant to PDO — Your Common Sense, May 12 '13 at 17:35
Thank you, checking the log, I'm getting " Call to undefined method PDO::execute() in C:\xampp\htdocs\bookmarks\index.php on line 5" — Tim Aych, May 12 '13 at 17:54

hjpotter92 · Answer 1 · 2013-05-12T17:57:02.700

2

The connection string seems a bit wrong.

'mysql:bookmarks'

should also have a host; and bookmarks is what I think the database name!

'mysql:dbname=bookmarks;host=localhost'

$conn->prepare('INSERT INTO entries (url) VALUES (:url)');
$conn->execute(array(':url' => $url));

needs to be rewritten as follows:

$stmt = $conn->prepare('INSERT INTO entries (url) VALUES (:url)');
$stmt->execute(array(':url' => $url));

edited May 12 '13 at 17:57

answered May 12 '13 at 17:23

hjpotter92

78,589
36
144
183

Thanks, I changed the connection parameters accordingly. I'm still, however, getting the error. – Tim Aych May 12 '13 at 17:27
@TimAych As commented by *Pekka 웃* in your question; please show what errors you are receiving! – hjpotter92 May 12 '13 at 17:28
Yeah, edited the error into original post.. "HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request." – Tim Aych May 12 '13 at 17:32

Your Common Sense · Accepted Answer · 2013-05-12T17:59:15.770

2

function addBookmark($url, $conn){
    $stmt = $conn->prepare('INSERT INTO entries (url) VALUES (?)');
    $stmt->execute(array($url));
}

edited May 12 '13 at 17:59

answered May 12 '13 at 17:57

Your Common Sense

156,878
40
214
345

Thanks a bunch, completely forgot that the connection var doesn't handle the execute function. – Tim Aych May 12 '13 at 18:01

score 1 · Answer 3 · answered May 12 '13 at 17:23

1

I dont know exactly, but the way i create connection string is

mysql:host=localhost;database=database
mysql:host=localhost;dbname=database

I dont know if there is any other workaround. I forgot whether its database or dbname

answered May 12 '13 at 17:23

Aditya Heartly

873
1
6
8

Simple PDO connection/prepare statement query

3 Answers3