Hex - database request
Tariq Nisar Ahmed
As salamu alaykum wa Rahmat Allah wa Barakatuhu,
Hex,
Is it possible to submit a query to your database that would return a text file with an array of data formatted as follows:
[$LATITUDE, $LONGITUDE, '<b>$JAMAT_NAME</b> (Updated $DATE)<br>$ADDRESS. $PHONE<br>We need volunteers to verify the marker is placed<br>correctly and to update the iqamah schedule, please!<br><font size="-2">Jamat ID $(DATABASE RECORD NUMBER + 200)</font>'],
If each jamat were returned in the above format, that text could be added directly to the existing code of prayinjamat.com -- since the code relies on an array in which data appears in that order. I have inserted $STRING wherever the database would supply information. The third item in the array is the code that drives each infowindow. Since your database record numbers would not correspond to the current jamat id numbers, adding 200 to the number returned by the database should yield a "safe" ID number.
I hope you take no offense at this request -- it is a sincere attempt to build on the work you have done by adding that data to this project. Also, I do not know much about querying databases or formatting the output. Moreover, your database would return several thousand records, right? So, would that much data be too much for the site in its current form -- would the site take forever to load or would the code become too large and unwieldy? If this request would be too difficult for any reason, please excuse it.
Jazak Allah khair and as salamu alaykum wa Rahmat Allah wa Barakatuhu,
Tariq Ahmed
prayinj...@gmail.com
chakir kandil
Salam,
For your request I think it’s better to do the query directly inside the code of the page instead of getting the results than copy them to the page code. I wanted to try this but I don’t havr access to a server supporting PHP, and since I don’t know PHP, I cannot just make some trials and send it to you for testing.
My idea about an access database is that all information are stored in that database. The database will have also information about people responsible for updating iqamah times for massajids with logins and passwords. So for admins, they will have their own web page, that when they log on, they will get the list of massajids they are responsible for. The modification will be directly persisted in the database. The normal user doesn’t know about that, all he sees is the map with the massajids added. The page of the map query the database.
salam