PHP can't display database records. about gpstracker HOT 14 CLOSED

Ok, thanks for bringing this up. Let me take a look into this. Please login to your database and tell me how many records you have in the gpslocations table.

thanks
Nick

from gpstracker.

I am currently running wamp server php version 5.5.12 and mysql version 5.6.17 phpmyadmin with version 4.1.14. The records are successfully import into database and updatelocations.php are work.

i am stuck in displaymap.php page whereby can't fetch the records from database w/o any error

i really appreciate u reply me because it is my part of my final year project
Thanks

from gpstracker.

Shawhern

Can you please look in dbconnect.php and make sure everything is correct there. What is the name of your database in phpMySql. Make sure it is the same as in dbconnect.php.

Also, please read this tutorial I wrote and also carefully read the comments.

https://www.websmithing.com/2014/04/21/how-to-set-up-the-gps-tracker-mysql-database-using-phpmyadmin/

n

from gpstracker.

I checked my dbconnect.php it is exactly the same i foloow the step inside the tutorial.

$dbhost = 'localhost';
$dbuser = 'gpstracker_user';
$dbpass = 'gpstracker';
$dbname = 'gpstracker';

but when i directly access to updatelocations.php it will have a '0' which mean i successfully execute the code and i check back to my database the record is added inside but something fishy is the time i open displaymap.php i cant have my record in the dropdown list. Does something need to configure like php extension or what

Thanks

from gpstracker.

u need to install this application into the phone and run the process in
order to track down the device

On Mon, Jun 23, 2014 at 2:15 PM, rebecca1986 [email protected]
wrote:

Can I use this to track someone else's phone. Without me physically having
to touch it.
On Jun 22, 2014 11:12 PM, "shawhern" [email protected] wrote:

I checked my dbconnect.php it is exactly the same i foloow the step
inside
the tutorial.

[image: php]
<
https://cloud.githubusercontent.com/assets/7955586/3354260/25827420-fa9d-11e3-80cc-535c373c9120.png>

$dbhost = 'localhost';
$dbuser = 'gpstracker_user';
$dbpass = 'gpstracker';
$dbname = 'gpstracker';

[image: php]
<
https://cloud.githubusercontent.com/assets/7955586/3353982/3c6e441a-fa94-11e3-9318-1931ecde073c.png>

but when i directly access to updatelocations.php it will have a '0'
which
mean i successfully execute the code and i check back to my database the
record is added inside but something fishy is the time i open
displaymap.php i cant have my record in the dropdown list. Does
something
need to configure like php extension or what

Thanks

—
Reply to this email directly or view it on GitHub
#11 (comment).

—
Reply to this email directly or view it on GitHub
#11 (comment).

from gpstracker.

shawherm. Instead of testing with displaymap.php directly. Try getroutes.php instead. That is used by displaymap. If getroutes.php fails to load routes, then you need to look in your web servers error logs. That is the next step.

n

from gpstracker.

i forget to attached in actually the record are there just the displaymap.php something fishy anywhere thanks for assist me alot

from gpstracker.

shawhern, look at the last image you posted. when you call getroutes.php, you should have ONLY json. For some reason you have a bunch of html garbage displaying. the br tag in the first line to the font tag about 10 lines down. the file SHOULD start with:

{ "routes"....

it looks like some html got into one of your rows in the database. carefully go look at the database and check ALL 27 of the rows carefully and see if one has html in it. then delete it. try that first.

n

from gpstracker.

I checked and found out still the same after that i actually delete most of the records and left 5 for testing still the result is the same and i also re-download the whole php source code and replace the old one

from gpstracker.

ok, i think i know what is is. go into getroutes.php and change

} while ($mysqli->next_result());

to this

} while ($mysqli->more_results() && $mysqli->next_result());

from gpstracker.

Thank you it is working fine now you are saving my life <3

from gpstracker.

good, thanks for bringing this to my attention.

Nick

from gpstracker.

Hi Nick,

Below is the link i put over the net yet the problem com find me again but this time in getroutes,php already got the result is it something wrong with this server?

http://rdykido.5gbfree.com/gpstracker/displaymap.php

from gpstracker.

You need to always be checking getroutes.php. Look at it now. Did you add a div to it?

<div style="text-align:center;">Fibernet Corp is a <a href="http://fiber.net" title="Utah hosting" rel="nofollow">Utah hosting</a> company.</div>

That page can only output json, you can not add any html to it. It's ok to style displaymap.php but not getroutes.php

from gpstracker.