Junk after document element

jemz · September 27, 2013, 6:07pm

fretburner:

Hey jemz,

As far as I know, you can’t use %s as a placeholder in a PDO prepared statement… you need to use either named placeholders (i.e. :value) or a ?, so you would need to alter your query like this:
$cmmand = $cnn->prepare("SELECT address, name, lat, lng, 
    ( 3959 * acos( cos( radians( ? ) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians( ? ) ) + sin( radians( ? ) ) * sin( radians( lat ) ) ) ) AS distance 
    FROM tblstore HAVING distance < ? ORDER BY distance LIMIT 0 , 20");
http://www.php.net/manual/en/pdo.prepared-statements.php

Hi fretburner, I tried already but still having this ouput

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<markers/>

fretburner · September 27, 2013, 6:35pm

It sounds like your query might not be returning any results… have you tried entering the query into phpMyAdmin or something similar to check that it actually returns something for the given input?

jemz · September 27, 2013, 7:06pm

Nope, I don’t know how to test this in phpmyadmin if this really works.

fretburner · September 27, 2013, 7:17pm

Copy and paste the SQL of your query into phpmyadmin, but replace the ? placeholders with the actual values that you’ve been testing your script with. That way, you’ll find out if the query is actually returning any data.