 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | ||||||||
// Phone List Search version 1 // // Peter Garner (peterg@mildewhall.fsnet.co.uk) // Uses PHP and MySQL. // This works fine on my Mitsubishi Trium. YMMV. // // I developed this on the Linux version of the // deckit emulator from www.pyweb.com. // // This is the first deck that prompts you for // a last name (or part of a name) - d2a.wml. // You can call it anything you like, but a short // URL is easy on a phone keypad.. <?php header("Content-type: text/vnd.wap.wml"); echo "<?xml version=\"1.0\" ?>"; ?> <!DOCTYPE wml PUBLIC "-//PHONE.COM//DTD WML 1.1//EN" "http://www.phone.com/dtd/wml11.dtd" > <wml> <template> <do type="prev" label="Previous"> <prev/> </do> </template> <card id="card0" ontimer="#card1"> <timer name="key" value="20"/> <p align="center"> <strong><big>Phone List</big></strong> <br/> </p> </card> <card id="card1" title="Search"> <p> <do type="accept" label="Search"> <go href="d2b.wml" method="post"> <postfield name="Lname" value="$Lname"/> </go> </do> Enter Last Name:<br/> <input title="Last Name" name="Lname" maxlength="40"/> </p> </card> </wml> // Once you have entered your search string, this deck is // then accessed (d2b.wml). It uses a simple MySQL database // called "Phonelist" and the table is called "mysite". If // your phone supports it, you can use the WTAI to place a // call to your "result" once you have hung up. Please note // that this script doesn't do any checking for length of // output. If it's over the limit you will get a 'malformed // http' message or somthing similar. <?php header("Content-type: text/vnd.wap.wml"); echo "<?xml version=\"1.0\" ?>"; ?> <!DOCTYPE wml PUBLIC "-//PHONE.COM//DTD WML 1.1//EN" "http://www.phone.com/dtd/wml11.dtd" > <wml> <template> <do type="prev" label="Previous"> <prev/> </do> </template> <card id="card1" title="Result"> <p> <?php if ( $DBcon = mysql_connect("localhost", "","") ) { mysql_select_db("Phonelist"); $query = "select Fname, Lname, Ext, Email, "; $query .= "Dept, JobDesc from mysite "; $query .= "where Lname like '%$Lname%'"; $result = mysql_query($query); $nr = mysql_num_rows($result); if ( !empty($Lname) ) { if ( $nr > 0 ) { for ($count = 1; $row = mysql_fetch_row ($result); ++$count) { $Fname = $row[0]; // first name $Lname = $row[1]; // last name (search key) $Ext = $row[2]; // phone extension $Email = $row[3]; // email address $Dept = $row[4]; // Department $Job = $row[5]; // job description echo "<i>$Fname $Lname</i><br/>"; echo "<strong><small> T.</small></strong>01xxx-xxx$Ext<br/>"; echo "<small><strong> E.</strong>$Email</small> "; echo "<strong><small> Dept.</small></strong>$Dept "; echo "<strong><small> Job.</small></strong>$Job<br/>"; echo "<anchor>Call $Fname"; echo "<go href=\"wtai://wp/mc;01xxxxxx$Ext\"/>"; echo "</anchor>"; } } else { echo "Sorry - no match for $Lname"; } } else { echo "Please select a name (or part thereof)"; } @mysql_close($DBcon); } ?> <br/> </p> </card> </wml> // End of source. Enjoy ! | ||||||||
| Related Code Examples | ||||||||
| User Comments | ||||||||
|
||||||||
