VinceGledhill Posted October 8, 2011 Share Posted October 8, 2011 Hi people. I'm very new to PHP and am building the www.airfieldcards.com website for pilots to use free of charge. I have made a subdomain "m" which I am going to use for the "mobile version" of the site. I have made the "information" showing card but need to make a menu as the first thing that the user sees when he logs onto the site via a mobile device (iPhone / android etc) It needs to take "username" from the database (this is the airfield name) Then list them in order (alphabetically) Then make a link out of the word to the ?"id" from the DB and display the relevant card. In other words. When the user visits http://m.airfieldcards.com the are greeted with the following Abbots Bromley Alderney Andrewsfield Here is the php that shows the actual "phone" version of the card. <?php $host = 'localhost'; $usr = "username"; $password = 'thepassword'; $db_name = 'TheNameOfTheDB'; function cr($string){ $clean_string = str_replace("rn","<BR>",$string); return $clean_string; } if (!isset($id)) $id = $_GET['id']; mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error()); mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error()); $read_query = "select * from users where user_id = '$id'"; $results = mysql_query($read_query); $rs = mysql_fetch_array($results); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- body table { } body,td,th { font-size: x-large; } --> </style> <body> Airfield Name: <? echo $rs["username"]; ?> <table width="480" border="1" cellspacing="0" cellpadding="2"> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Height Above</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["height_above"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Mb Difference</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["mb_diff"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Alternative</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["alternative"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">General Location</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["general_location"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Grid Reference</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["location_grid"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Runway Num</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["runway_numbers"]; ?></strong></span></div></td> </tr> <tr> <td width="240" bgcolor = #E6F8EB><span class="xx_large_font">Circuit Dir</span></td> <td width="240" bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["circuit_direction"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Cirtuit Height</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["circuit_height"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Runway m</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["runway_length"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">OHJ Height</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["ohj_height"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Surface</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["surface"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Radio Freq</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["radio_frequency"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Callsign</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["radio_callsign"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Type</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["radio_type"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Other Radio</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["other_radio"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Fuel</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["fuel"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Landing Fee</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["landing_fee"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Opp Hrs</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["operating_hours"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Maintenance</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["maintenance"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Hangarage</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["hangarage"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Parking</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["parking"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #dbeff8><span class="xx_large_font">Food</span></td> <td bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["food"]; ?></strong></span></div></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">School</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["school"]; ?></strong></span></div></td> </tr> <tr> <td colspan="2"><span class="xx_large_font">Remarks:<? echo $rs["remarks"]; ?></span></td> </tr> <tr> <td colspan="2"><span class="xx_large_font">Warnings:<? echo $rs["warnings"]; ?></span></td> </tr> <tr> <td bgcolor = #E6F8EB><span class="xx_large_font">Website</span></td> <td bgcolor = #E6F8EB><div align="right"><span class="xx_large_font"><strong><? echo $rs["weblinks"]; ?></strong></span></div></td> </tr> <tr> <td width="240" bgcolor = #dbeff8><span class="xx_large_font">Operator</span></td> <td width="240" bgcolor = #dbeff8><div align="right"><span class="xx_large_font"><strong><? echo $rs["operator"]; ?></strong></span></div></td> </tr> </table> <p class="xx_large_font"> </p> <p> </p> </body> </html> </html> Any help would be really appreciated. Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/248700-how-do-i-make-a-mobile-menu-from-my-database/ Share on other sites More sharing options...
trq Posted October 8, 2011 Share Posted October 8, 2011 You should really look into using a framework such as http://jquerymobile.com Link to comment https://forums.phpfreaks.com/topic/248700-how-do-i-make-a-mobile-menu-from-my-database/#findComment-1277310 Share on other sites More sharing options...
VinceGledhill Posted October 9, 2011 Author Share Posted October 9, 2011 Thanks for that Thorpe, I wouldn't know where to start. Link to comment https://forums.phpfreaks.com/topic/248700-how-do-i-make-a-mobile-menu-from-my-database/#findComment-1277567 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.