Fenhopi Posted December 6, 2010 Share Posted December 6, 2010 Hi, I have this code: <?php /* note: this is just a static test version using a hard-coded countries array. normally you would be populating the array out of a database the returned xml has the following structure <results> <rs>foo</rs> <rs>bar</rs> </results> */ $aUsers = array( "Ädams, Egbert", "Altman, Alisha", "Archibald, Janna", "Auman, Cody", "Bagley, Sheree", "Ballou, Wilmot", "Bard, Cassian", "Bash, Latanya", "Beail, May", "Black, Lux", "Bloise, India", "Blyant, Nora", "Bollinger, Carter", "Burns, Jaycob", "Carden, Preston", "Carter, Merrilyn", "Christner, Addie", "Churchill, Mirabelle", "Conkle, Erin", "Countryman, Abner", "Courtney, Edgar", "Cowher, Antony", "Craig, Charlie", "Cram, Zacharias", "Cressman, Ted", "Crissman, Annie", "Davis, Palmer", "Downing, Casimir", "Earl, Missie", "Eckert, Janele", "Eisenman, Briar", "Fitzgerald, Love", "Fleming, Sidney", "Fuchs, Bridger", "Fulton, Rosalynne", "Fye, Webster", "Geyer, Rylan", "Greene, Charis", "Greif, Jem", "Guest, Sarahjeanne", "Harper, Phyllida", "Hildyard, Erskine", "Hoenshell, Eulalia", "Isaman, Lalo", "James, Diamond", "Jenkins, Merrill", "Jube, Bennett", "Kava, Marianne", "Kern, Linda", "Klockman, Jenifer", "Lacon, Quincy", "Laurenzi, Leland", "Leichter, Jeane", "Leslie, Kerrie", "Lester, Noah", "Llora, Roxana", "Lombardi, Polly", "Lowstetter, Louisa", "Mays, Emery", "Mccullough, Bernadine", "Mckinnon, Kristie", "Meyers, Hector", "Monahan, Penelope", "Mull, Kaelea", "Newbiggin, Osmond", "Nickolson, Alfreda", "Pawle, Jacki", "Paynter, Nerissa", "Pinney, Wilkie", "Pratt, Ricky", "Putnam, Stephanie", "Ream, Terrence", "Rumbaugh, Noelle", "Ryals, Titania", "Saylor, Lenora", "Schofield, Denice", "Schuck, John", "Scott, Clover", "Smith, Estella", "Smothers, Matthew", "Stainforth, Maurene", "Stephenson, Phillipa", "Stewart, Hyram", "Stough, Gussie", "Strickland, Temple", "Sullivan, Gertie", "Swink, Stefanie", "Tavoularis, Terance", "Taylor, Kizzy", "Thigpen, Alwyn", "Treeby, Jim", "Trevithick, Jayme", "Waldron, Ashley", "Wheeler, Bysshe", "Whishaw, Dodie", "Whitehead, Jericho", "Wilks, Debby", "Wire, Tallulah", "Woodworth, Alexandria", "Zaun, Jillie" ); $aInfo = array( "Bedfordshire", "Buckinghamshire", "Cambridgeshire", "Cheshire", "Cornwall", "Cumbria", "Derbyshire", "Devon", "Dorset", "Durham", "East Sussex", "Essex", "Gloucestershire", "Hampshire", "Hertfordshire", "Kent", "Lancashire", "Leicestershire", "Lincolnshire", "Norfolk", "Northamptonshire", "Northumberland", "North Yorkshire", "Nottinghamshire", "Oxfordshire", "Shropshire", "Somerset", "Staffordshire", "Suffolk", "Surrey", "Warwickshire", "West Sussex", "Wiltshire", "Worcestershire", "Durham", "East Sussex", "Essex", "Gloucestershire", "Hampshire", "Hertfordshire", "Kent", "Lancashire", "Leicestershire", "Lincolnshire", "Norfolk", "Northamptonshire", "Northumberland", "North Yorkshire", "Nottinghamshire", "Oxfordshire", "Shropshire", "Somerset", "Staffordshire", "Suffolk", "Surrey", "Warwickshire", "West Sussex", "Wiltshire", "Worcestershire", "Durham", "East Sussex", "Essex", "Gloucestershire", "Hampshire", "Hertfordshire", "Kent", "Lancashire", "Leicestershire", "Lincolnshire", "Norfolk", "Northamptonshire", "Northumberland", "North Yorkshire", "Nottinghamshire", "Oxfordshire", "Shropshire", "Somerset", "Staffordshire", "Suffolk", "Surrey", "Warwickshire", "West Sussex", "Wiltshire", "Worcestershire", "Durham", "East Sussex", "Essex", "Gloucestershire", "Hampshire", "Hertfordshire", "Kent", "Lancashire", "Leicestershire", "Lincolnshire", "Norfolk", "Northamptonshire", "Northumberland", "North Yorkshire", "Nottinghamshire" ); $input = strtolower( $_GET['input'] ); $len = strlen($input); $aResults = array(); if ($len) { for ($i=0;$i<count($aUsers);$i++) { // had to use utf_decode, here // not necessary if the results are coming from mysql // if (strtolower(substr(utf8_decode($aUsers[$i]),0,$len)) == $input) $aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($aUsers[$i]), "info"=>htmlspecialchars($aInfo[$i]) ); //if (stripos(utf8_decode($aUsers[$i]), $input) !== false) // $aResults[] = array( "id"=>($i+1) ,"value"=>htmlspecialchars($aUsers[$i]), "info"=>htmlspecialchars($aInfo[$i]) ); } } header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header ("Pragma: no-cache"); // HTTP/1.0 if (isset($_REQUEST['json'])) { header("Content-Type: application/json"); echo "{\"results\": ["; $arr = array(); for ($i=0;$i<count($aResults);$i++) { $arr[] = "{\"id\": \"".$aResults[$i]['id']."\", \"value\": \"".$aResults[$i]['value']."\", \"info\": \"\"}"; } echo implode(", ", $arr); echo "]}"; } else { header("Content-Type: text/xml"); echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>"; for ($i=0;$i<count($aResults);$i++) { echo "<rs id=\"".$aResults[$i]['id']."\" info=\"".$aResults[$i]['info']."\">".$aResults[$i]['value']."</rs>"; } echo "</results>"; } ?> The $aUsers array, I want to fill with names taken from: $GetNames = "SELECT firstname, lastname, username, country FROM users"; $GetNamesConnect = $database->query($GetNames); $row = mysql_fetch_array($GetNamesConnect) echo $row['firstname'] . " " . $row['lastname']; Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted December 6, 2010 Share Posted December 6, 2010 while($row = mysql_fetch_array($GetNamesConnect)) { $aUsers[] = $row['lastname'] . ', ' . $row['firstname']; } Quote Link to comment Share on other sites More sharing options...
Fenhopi Posted December 6, 2010 Author Share Posted December 6, 2010 I tried that, but for some reason it doesn't show any result.. Any ideas? Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted December 6, 2010 Share Posted December 6, 2010 I tried that, but for some reason it doesn't show any result.. Any ideas? You didn't ask to show them, you already have that code. You asked to put them in the $aUsers array. print_r($aUsers); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.