PHP PDO Call to a member function execute() on a non object

Question

So I'm using prepared statements to handle my JSON call from my cordova app to a database.

Right now, I'm trying to get nearby locations based on POSTed latitude and longitude, but the prepared statement isn't working.

When I set the variables to just test, I'm getting a Call to a member function execute() on a non object error.

I don't know what I'm doing wrong!

    error_reporting(E_ALL);

    $lat = 42.35674265310388;
    $lon = -71.13770473755070;
    $miles = 5;
    //$lat = $_POST["lat"];
    //$lon = $_POST["lon"];
    $data = array();

    $sth = $mysqli->prepare('SELECT *, (3959 * acos(cos(radians(?)) * cos(radians(lat)) * cos(radians(lon) - radians(?)) + sin(radians(?)) * sin(radians(lat)))) AS distance FROM members WHERE (3959 * acos(cos(radians(?)) * cos(radians(lat)) * cos(radians(lon) - radians(?)) + sin(radians(?)) * sin(radians(lat)))) < ? ORDER BY distance 5');
    $sth->execute(array($lat, $lon, $lat, $lat, $lon, $lat, $miles));
    $row = $sth->fetch();

    $data["markers"][] = array
    (
        "lat" => $row['lat'],
        "lon" => $row['lon']
    );

    print_r($data);

    echo json_encode($data);

Also, I var_dump()ed the $lat $lon and $miles variables, shown below.

lat - float(42.356742653104)
lon - float(-71.137704737551)
miles - int(5)

you've tagged this PDO yet you've called your database variable $mysqli? What do your database connection lines look like? — Novocaine
– Novocaine, Commented Nov 25, 2013 at 17:23
Quite funny to see this one after stackoverflow.com/questions/18321504/… — Your Common Sense
– Your Common Sense, Commented Nov 25, 2013 at 17:38
@YourCommonSense I changed everything. Also, novocaine88, I didn't change the variable name, but it is being called via PDO. Idk. Didn't change it. — copilot0910
– copilot0910, Commented Nov 27, 2013 at 16:50

Thalaivar · Accepted Answer · 2013-11-27 20:34:08Z

3

$sth = $mysqli->prepare('SELECT *, (3959 * acos(cos(radians(?)) * cos(radians(lat)) * cos(radians(lon) - radians(?)) + sin(radians(?)) * sin(radians(lat)))) AS distance FROM members WHERE (3959 * acos(cos(radians(?)) * cos(radians(lat)) * cos(radians(lon) - radians(?)) + sin(radians(?)) * sin(radians(lat)))) < ? ORDER BY distance 5');

There seems to be an error in the query, it fails on preparation before it is even executed due to syntax validation failure ORDER BY distance 5 which is wrong.

It should be either

ORDER BY distance ASC

OR

ORDER BY distance DESC

edited Nov 27, 2013 at 20:34

answered Nov 25, 2013 at 17:33

Thalaivar

23.7k5 gold badges63 silver badges71 bronze badges

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

4 Comments

Thalaivar Over a year ago

@Downvoter: Can someone add a comment so that i can correct myself.

copilot0910 Over a year ago

Also, when I var_dump the query, the response is string(308) followed by the query itself. Also, when I add the bind_param before executing, I get the same error, but the execute() becomes bind_param() I've seen it with the array in the execute() before, and has worked elsewhere in examples that weren't mine. Also, I have seen the bind_param() way you're saying.

JC. Over a year ago

Looks like he wants an order, and a limit...So ORDER ASC or ORDER DESC are fine, and add limit 5 after.

copilot0910 Over a year ago

Fixing the ORDER BY has fixed it. Thanks!

Collectives™ on Stack Overflow

PHP PDO Call to a member function execute() on a non object

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related