Jump to content

How do I make a mobile menu from my database?

VinceGledhill

By VinceGledhill
in PHP Coding Help

 Share

Recommended Posts

VinceGledhill Member

VinceGledhill

Posted
Posted

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
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.