Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Jul 2007
    Posts
    61
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Need some idea for web pages for Location based content

    Hi,

    I am trying to develop a location based content delivery of webpages.

    In a nutshell, I have 6 locations around my city. I have their specific coordinates. When a Pocket PC equipped with a GPS enters in a proximity of one of the points, my webserver should load the page appropriate to one of these locations. This is a primitive model meant for delivery of location based content for elderly people who want information relevant to that location.

    All these pages will be designed for each specific location, and they will have similar content on each of them. For e.g. weather feed, bus time tables, shops nearby, banks and ATMs nearby and so on.


    Some of the information related to a point would remain static - for e.g. bus time tables, shops nearby, ATMs nearby.

    However some content would change dynamically - e.g. weather feed.




    My primary question is - this information on each page - for e.g. the bus timetable, I have that sourced for the local travel company, should I use SQL database to display that on my webpage ? Or should I just use a JPEG image ? How do I use databases to display this information on a webpage ? I have experience with only with a little bit of PHP, Javascript and MySQL, however I have never used a database to display information on a webpage.


    Thanks..

  • #2
    Senior Coder whizard's Avatar
    Join Date
    Jan 2005
    Location
    Philadelphia, PA, USA
    Posts
    1,662
    Thanks
    14
    Thanked 76 Times in 76 Posts
    I would advise using PHP/MySQL to display the info. If you need help with a specific part of that, feel free to post in the PHP forum. Generally, it works like this:

    PHP Code:
    $query ""//Put your query here
    $result mysql_query($query) or die(mysql_error()); //This will run the query OR show return the error if it fails.
    while($row mysql_fetch_array($result))
    {
    //The code inside these brackets will loop for each row returned by the query.
    //The info from the database can be accessed in this case through the $row array.
    //For instance, to print out the value of a field inthe current row, you would put
    //echo $row['field_name'];

    HTH
    Dan
    PHP Tip: If you want to use short tags (<? or <?=$var) then make sure short_open_tag is set to "1". It really helps.

    Don't forget to save everyone time and mark your thread as Resolved :)

    "Also note that it is your responsibility to die() if necessary."

    DON'T USE THE MYSQL_ EXTENSION

  • #3
    New Coder
    Join Date
    Jul 2007
    Posts
    61
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Thanks for the reply..


    Any specific tutorial on how to populate HTML tables with existing MySQL databases ?

    Any help regarding this would be fine..I am an absolute newbie at this.

    Regards.

  • #4
    Regular Coder saeed's Avatar
    Join Date
    Oct 2002
    Location
    West Yorkshire
    Posts
    343
    Thanks
    32
    Thanked 0 Times in 0 Posts
    try this website ... very usefull... Tizag

    ATB!


    Saeed,
    Don't click on this!

    #!/usr/bin/saeed


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •