CREATE TABLE `customers` (
`CustomerID` varchar(5) NOT NULL,
`CompanyName` varchar(40) NOT NULL,
`ContactName` varchar(30) DEFAULT NULL,
`ContactTitle` varchar(30) DEFAULT NULL,
`Address` varchar(60) DEFAULT NULL,
`City` varchar(15) DEFAULT NULL,
`Region` varchar(15) DEFAULT NULL,
`PostalCode` varchar(10) DEFAULT NULL,
`Country` varchar(15) DEFAULT NULL,
`Phone` varchar(24) DEFAULT NULL,
`Fax` varchar(24) DEFAULT NULL,
PRIMARY KEY (`CustomerID`),
KEY `City` (`City`),
KEY `CompanyName` (`CompanyName`),
KEY `PostalCode` (`PostalCode`),
KEY `Region` (`Region`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
<?php $link = mysql_connect('localhost', 'your_user', 'your_pw'); mysql_set_charset('utf8',$link); if (!$link) { die('Verbindung schlug fehl: ' . mysql_error()); } else { // echo "connection is super!". $link; } $selectdb = mysql_selectdb('your_db', $link); $sql = "select * from customers limit 0,10"; // you may want to limit the results for big tables to the firs 10 by adding LIMIT 0,10 at the end of the query. $result = mysql_query($sql); ?> <!DOCTYPE html> <html> <head> <title>Customers</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="http://code.jquery.com/mobile/1.2.0/jquery.mobile-1.2.0.min.css" /> <script src="http://code.jquery.com/jquery-1.8.2.min.js"></script> <script src="http://code.jquery.com/mobile/1.2.0/jquery.mobile-1.2.0.min.js"></script> </head> <body> <div data-role="page" id="one"> <div data-role="header"> <h1>Select Customer</h1> </div><!-- /header --> <div data-role="content"> <h2>Get Customer Profile:</h2> <ul data-role="listview" data-inset="true"> <?php $html; while ($r = mysql_fetch_object($result)) { echo '<li><a href="#customer'.$r->id.'">Customer '.$r->id.' Profile</a></li>'; $html .= '<div data-role="page" id="customer'.$r->id.'" data-theme="a"> <div data-role="header"> <h1>Customer '.$r->name.'</h1> </div><!-- /header --> <div data-role="content" data-theme="a"> <h2>Customer '.$r->name.'</h2> <p>display here the customer information.</p> <p><a href="#one" data-direction="reverse" data-role="button" data-theme="b">Back to page "one"</a></p> </div><!-- /content --> <div data-role="footer"> <h4>Page Footer</h4> </div><!-- /footer --> </div>'; } ?> </ul> </div><!-- /content --> <div data-role="footer"> <h4>Page Footer</h4> </div><!-- /footer --> </div><!-- /page --> <?php echo $html; ?> </body> </html>