Addis

need to create a webapp using a control to display each event, have difficulty with path to get the position and column attribute. any help and how do i bind a control to this data to make it an app where a use can browse through each event with there corresponding characteristics? below is the sample xml..... thanks <?php $keywords = simplexml_load_file('http://wx.toronto.ca/festevents.nsf/tpaview?readviewentries'); echo ' '; foreach ($keywords->xpath('viewentry[@position]') as $kw) { echo ' ' .$kw->entrydata->text . ' '; } //echo ' '; //foreach ($keywords->viewentry->entrydata as $kw) { //echo ' '.$kw->text.''; //echo ' '.$kw->textlist->text.''; //} ?> <?xml version="1.0" encoding="UTF-8"?> <viewentries timestamp="20140420T142611,65Z" toplevelentries="1209"> <viewentry position="1" unid="9FBAD6EEF554FC2185257CBB0063FDD0" noteid="4E072" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text> ‘Antiques Roadshow’-inspired Open Call for Canadian Art </text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Downtown</text> </entrydata> <entrydata columnnumber="2" name="CategoryList"> <textlist> <text>Arts/Exhibits</text> <text>Seminars/Workshops</text> </textlist> </entrydata> <entrydata columnnumber="3" name="PresentedByOrgName"> <text>Consignor Canadian Fine Art</text> </entrydata> <entrydata columnnumber="4" name="Image"> <text> http://wx.toronto.ca/festevents.nsf/all/9FBAD6EEF554FC2185257CBB0063FDD0/$File/logo_banner.png </text> </entrydata> <entrydata columnnumber="5" name="DateBeginShow"> <text>May 9, 2014</text> </entrydata> <entrydata columnnumber="6" name="TimeBegin"> <text>9:00 AM</text> </entrydata> <entrydata columnnumber="7" name="DateEndShow"> <text>May 9, 2014</text> </entrydata> <entrydata columnnumber="8" name="TimeEnd"> <text>5:00 PM</text> </entrydata> <entrydata columnnumber="9" name="Admission"> <text>Free</text> </entrydata> <entrydata columnnumber="10" name="LongDesc"> <textlist> <text> Have you ever wondered how much that inherited painting tucked away in the attic is worth? Consignor Canadian Fine Art’s (consignor.ca) certified art specialists are looking for hidden treasures for their upcoming auctions. Anyone interested in selling a Canadian painting, print or sculpture on consignment, receiving a preliminary auction valuation and/or curious to learn more about a piece of artwork they own, is invited to attend an art appraisal open house on Friday, May 9th. </text> <text> Consignor’s art specialists will be on-hand for mini-consultations and verbal auction valuations of works by Canadian artists, as well as preview works of art available for sale through its upcoming Spring Auction of Important Canadian Art (May 21-29). </text> </textlist> </entrydata> <entrydata columnnumber="11" name="OrgContactPhone"> <text>416-628-5609</text> </entrydata> <entrydata columnnumber="12" name="OrgContactExt"> <text/> </entrydata> <entrydata columnnumber="13" name="Location"> <text>Consignor Canadian Fine Art</text> </entrydata> <entrydata columnnumber="14" name="Intersection"> <text>Dundas St. W and McCaul St.</text> </entrydata> <entrydata columnnumber="15" name="MapAddress"> <text> [<a href=http://map.toronto.ca/imapit/iMapIt.jsp?app=TOMaps&geoid=796553 target=_new>Map to this event</a>] </text> </entrydata> <entrydata columnnumber="16" name="TTC"> <text/> </entrydata> <entrydata columnnumber="17" name="EventURL"> <text>www.consignor.ca</text> </entrydata> <entrydata columnnumber="18" name="ImageAltText"> <text/> </entrydata> <entrydata columnnumber="19" name="OrgContactEMail"> <text>amcloughlin@holmespr.com</text> </entrydata> <entrydata columnnumber="20" name="AccessibleFully"> <text/> </entrydata> <entrydata columnnumber="21" name="ParkingFree"> <text/> </entrydata> <entrydata columnnumber="22" name="PublicWashrooms"> <text>Public washrooms</text> </entrydata> <entrydata columnnumber="23" name="AccessiblePartially"> <text/> </entrydata> <entrydata columnnumber="24" name="ParkingPaid"> <text>Parking (paid)</text> </entrydata> <entrydata columnnumber="25" name="FoodBeverage"> <text/> </entrydata> <entrydata columnnumber="26" name="Shopping"> <text/> </entrydata> <entrydata columnnumber="27" name="Exhibit"> <text/> </entrydata> <entrydata columnnumber="28" name="Performance"> <text/> </entrydata> <entrydata columnnumber="29" name="KidFriendly"> <text>Kid-friendly</text> </entrydata> <entrydata columnnumber="30" name="History"> <text/> </entrydata> <entrydata columnnumber="31" name="Green"> <text/> </entrydata> <entrydata columnnumber="32" name="NewThisYear"> <text/> </entrydata> <entrydata columnnumber="33" name="Reservations"> <text/> </entrydata> <entrydata columnnumber="34" name="OfficialGreenSite"> <text/> </entrydata> <entrydata columnnumber="35" name="BikeRacks"> <text/> </entrydata> <entrydata columnnumber="36" name="RoadClose"> <text/> </entrydata> <entrydata columnnumber="37" name="OrganicFood"> <text/> </entrydata> </viewentry> <viewentry position="2" unid="05618376115EB38B85257CB00063C61E" noteid="4D5AE" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text>Tour the PS Trillium Side Wheeler Paddle Steamer</text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Downtown</text> </entrydata> <entrydata columnnumber="2" name="CategoryList"> <text>History</text> </entrydata> <entrydata columnnumber="3" name="PresentedByOrgName"> <text>The Waterfont BIA</text> </entrydata> <entrydata columnnumber="4" name="Image"> <text> http://wx.toronto.ca/festevents.nsf/all/05618376115EB38B85257CB00063C61E/$File/Trillium Ferry.JPG </text> </entrydata> <entrydata columnnumber="5" name="DateBeginShow"> <text>May 24, 2014</text> </entrydata> <entrydata columnnumber="6" name="TimeBegin"> <text>10:00 AM</text> </entrydata> <entrydata columnnumber="7" name="DateEndShow"> <text>May 25, 2014</text> </entrydata> <entrydata columnnumber="8" name="TimeEnd"> <text>3:00 PM</text> </entrydata> <entrydata columnnumber="9" name="Admission"> <text>Free</text> </entrydata> <entrydata columnnumber="10" name="LongDesc"> <textlist> <text> Take a tour of the PS Trillium Side Wheleer Paddle Steamer at Gangways Open on Toronto’s Waterfront presented by The Waterfront BIA, as part of the 15th annual Doors Open Toronto. </text> <text>Visit www.waterfrontbia.com for more information.</text> <text> The PS Trillium was constructed in 1910 at Polson Iron Works in Toronto, was re-constructed in Port Colborne in 1975 and continues to operate in the rebuilt condition today. The Trillium is the last remaining side wheeler paddle steamer operating in North America and is located at the foot of Harbour Square Park at the base of Bay Street. Author/Journalist Mike Filey will be on board to answer questions when he is not speaking in the Brigantine Room. </text> </textlist> </entrydata> <entrydata columnnumber="11" name="OrgContactPhone"> <text>416-603-6005</text> </entrydata> <entrydata columnnumber="12" name="OrgContactExt"> <text/> </entrydata> <entrydata columnnumber="13" name="Location"> <text>Harbour Square Park</text> </entrydata> <entrydata columnnumber="14" name="Intersection"> <text>Queens Quay West and Rees Street</text> </entrydata> <entrydata columnnumber="15" name="MapAddress"> <text> No matching map link is available for the current address input. </text> </entrydata> <entrydata columnnumber="16" name="TTC"> <text/> </entrydata> <entrydata columnnumber="17" name="EventURL"> <text>www.waterfrontbia.com</text> </entrydata> <entrydata columnnumber="18" name="ImageAltText"> <text/> </entrydata> <entrydata columnnumber="19" name="OrgContactEMail"> <text>peter@ashworthassociates.com</text> </entrydata> <entrydata columnnumber="20" name="AccessibleFully"> <text>Fully accessible</text> </entrydata> <entrydata columnnumber="21" name="ParkingFree"> <text/> </entrydata> <entrydata columnnumber="22" name="PublicWashrooms"> <text>Public washrooms</text> </entrydata> <entrydata columnnumber="23" name="AccessiblePartially"> <text/> </entrydata> <entrydata columnnumber="24" name="ParkingPaid"> <text>Parking (paid)</text> </entrydata> <entrydata columnnumber="25" name="FoodBeverage"> <text/> </entrydata> <entrydata columnnumber="26" name="Shopping"> <text/> </entrydata> <entrydata columnnumber="27" name="Exhibit"> <text/> </entrydata> <entrydata columnnumber="28" name="Performance"> <text/> </entrydata> <entrydata columnnumber="29" name="KidFriendly"> <text>Kid-friendly</text> </entrydata> <entrydata columnnumber="30" name="History"> <text/> </entrydata> <entrydata columnnumber="31" name="Green"> <text/> </entrydata> <entrydata columnnumber="32" name="NewThisYear"> <text>New this year</text> </entrydata> <entrydata columnnumber="33" name="Reservations"> <text/> </entrydata> <entrydata columnnumber="34" name="OfficialGreenSite"> <text/> </entrydata> <entrydata columnnumber="35" name="BikeRacks"> <text/> </entrydata> <entrydata columnnumber="36" name="RoadClose"> <text/> </entrydata> <entrydata columnnumber="37" name="OrganicFood"> <text/> </entrydata> </viewentry> <viewentry position="3" unid="58B01EF4B58CFE1D85257C97007303D5" noteid="4B76E" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text>10th Annual Toronto Tango Festival</text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Southwest</text><?xml version="1.0" encoding="UTF-8"?> <viewentries timestamp="20140420T142611,65Z" toplevelentries="1209"> <viewentry position="1" unid="9FBAD6EEF554FC2185257CBB0063FDD0" noteid="4E072" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text> ‘Antiques Roadshow’-inspired Open Call for Canadian Art </text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Downtown</text> </entrydata> <entrydata columnnumber="2" name="CategoryList"> <textlist> <text>Arts/Exhibits</text> <text>Seminars/Workshops</text> </textlist> </entrydata> <entrydata columnnumber="3" name="PresentedByOrgName"> <text>Consignor Canadian Fine Art</text> </entrydata> <entrydata columnnumber="4" name="Image"> <text> http://wx.toronto.ca/festevents.nsf/all/9FBAD6EEF554FC2185257CBB0063FDD0/$File/logo_banner.png </text> </entrydata> <entrydata columnnumber="5" name="DateBeginShow"> <text>May 9, 2014</text> </entrydata> <entrydata columnnumber="6" name="TimeBegin"> <text>9:00 AM</text> </entrydata> <entrydata columnnumber="7" name="DateEndShow"> <text>May 9, 2014</text> </entrydata> <entrydata columnnumber="8" name="TimeEnd"> <text>5:00 PM</text> </entrydata> <entrydata columnnumber="9" name="Admission"> <text>Free</text> </entrydata> <entrydata columnnumber="10" name="LongDesc"> <textlist> <text> Have you ever wondered how much that inherited painting tucked away in the attic is worth? Consignor Canadian Fine Art’s (consignor.ca) certified art specialists are looking for hidden treasures for their upcoming auctions. Anyone interested in selling a Canadian painting, print or sculpture on consignment, receiving a preliminary auction valuation and/or curious to learn more about a piece of artwork they own, is invited to attend an art appraisal open house on Friday, May 9th. </text> <text> Consignor’s art specialists will be on-hand for mini-consultations and verbal auction valuations of works by Canadian artists, as well as preview works of art available for sale through its upcoming Spring Auction of Important Canadian Art (May 21-29). </text> </textlist> </entrydata> <entrydata columnnumber="11" name="OrgContactPhone"> <text>416-628-5609</text> </entrydata> <entrydata columnnumber="12" name="OrgContactExt"> <text/> </entrydata> <entrydata columnnumber="13" name="Location"> <text>Consignor Canadian Fine Art</text> </entrydata> <entrydata columnnumber="14" name="Intersection"> <text>Dundas St. W and McCaul St.</text> </entrydata> <entrydata columnnumber="15" name="MapAddress"> <text> [<a href=http://map.toronto.ca/imapit/iMapIt.jsp?app=TOMaps&geoid=796553 target=_new>Map to this event</a>] </text> </entrydata> <entrydata columnnumber="16" name="TTC"> <text/> </entrydata> <entrydata columnnumber="17" name="EventURL"> <text>www.consignor.ca</text> </entrydata> <entrydata columnnumber="18" name="ImageAltText"> <text/> </entrydata> <entrydata columnnumber="19" name="OrgContactEMail"> <text>amcloughlin@holmespr.com</text> </entrydata> <entrydata columnnumber="20" name="AccessibleFully"> <text/> </entrydata> <entrydata columnnumber="21" name="ParkingFree"> <text/> </entrydata> <entrydata columnnumber="22" name="PublicWashrooms"> <text>Public washrooms</text> </entrydata> <entrydata columnnumber="23" name="AccessiblePartially"> <text/> </entrydata> <entrydata columnnumber="24" name="ParkingPaid"> <text>Parking (paid)</text> </entrydata> <entrydata columnnumber="25" name="FoodBeverage"> <text/> </entrydata> <entrydata columnnumber="26" name="Shopping"> <text/> </entrydata> <entrydata columnnumber="27" name="Exhibit"> <text/> </entrydata> <entrydata columnnumber="28" name="Performance"> <text/> </entrydata> <entrydata columnnumber="29" name="KidFriendly"> <text>Kid-friendly</text> </entrydata> <entrydata columnnumber="30" name="History"> <text/> </entrydata> <entrydata columnnumber="31" name="Green"> <text/> </entrydata> <entrydata columnnumber="32" name="NewThisYear"> <text/> </entrydata> <entrydata columnnumber="33" name="Reservations"> <text/> </entrydata> <entrydata columnnumber="34" name="OfficialGreenSite"> <text/> </entrydata> <entrydata columnnumber="35" name="BikeRacks"> <text/> </entrydata> <entrydata columnnumber="36" name="RoadClose"> <text/> </entrydata> <entrydata columnnumber="37" name="OrganicFood"> <text/> </entrydata> </viewentry> <viewentry position="2" unid="05618376115EB38B85257CB00063C61E" noteid="4D5AE" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text>Tour the PS Trillium Side Wheeler Paddle Steamer</text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Downtown</text> </entrydata> <entrydata columnnumber="2" name="CategoryList"> <text>History</text> </entrydata> <entrydata columnnumber="3" name="PresentedByOrgName"> <text>The Waterfont BIA</text> </entrydata> <entrydata columnnumber="4" name="Image"> <text> http://wx.toronto.ca/festevents.nsf/all/05618376115EB38B85257CB00063C61E/$File/Trillium Ferry.JPG </text> </entrydata> <entrydata columnnumber="5" name="DateBeginShow"> <text>May 24, 2014</text> </entrydata> <entrydata columnnumber="6" name="TimeBegin"> <text>10:00 AM</text> </entrydata> <entrydata columnnumber="7" name="DateEndShow"> <text>May 25, 2014</text> </entrydata> <entrydata columnnumber="8" name="TimeEnd"> <text>3:00 PM</text> </entrydata> <entrydata columnnumber="9" name="Admission"> <text>Free</text> </entrydata> <entrydata columnnumber="10" name="LongDesc"> <textlist> <text> Take a tour of the PS Trillium Side Wheleer Paddle Steamer at Gangways Open on Toronto’s Waterfront presented by The Waterfront BIA, as part of the 15th annual Doors Open Toronto. </text> <text>Visit www.waterfrontbia.com for more information.</text> <text> The PS Trillium was constructed in 1910 at Polson Iron Works in Toronto, was re-constructed in Port Colborne in 1975 and continues to operate in the rebuilt condition today. The Trillium is the last remaining side wheeler paddle steamer operating in North America and is located at the foot of Harbour Square Park at the base of Bay Street. Author/Journalist Mike Filey will be on board to answer questions when he is not speaking in the Brigantine Room. </text> </textlist> </entrydata> <entrydata columnnumber="11" name="OrgContactPhone"> <text>416-603-6005</text> </entrydata> <entrydata columnnumber="12" name="OrgContactExt"> <text/> </entrydata> <entrydata columnnumber="13" name="Location"> <text>Harbour Square Park</text> </entrydata> <entrydata columnnumber="14" name="Intersection"> <text>Queens Quay West and Rees Street</text> </entrydata> <entrydata columnnumber="15" name="MapAddress"> <text> No matching map link is available for the current address input. </text> </entrydata> <entrydata columnnumber="16" name="TTC"> <text/> </entrydata> <entrydata columnnumber="17" name="EventURL"> <text>www.waterfrontbia.com</text> </entrydata> <entrydata columnnumber="18" name="ImageAltText"> <text/> </entrydata> <entrydata columnnumber="19" name="OrgContactEMail"> <text>peter@ashworthassociates.com</text> </entrydata> <entrydata columnnumber="20" name="AccessibleFully"> <text>Fully accessible</text> </entrydata> <entrydata columnnumber="21" name="ParkingFree"> <text/> </entrydata> <entrydata columnnumber="22" name="PublicWashrooms"> <text>Public washrooms</text> </entrydata> <entrydata columnnumber="23" name="AccessiblePartially"> <text/> </entrydata> <entrydata columnnumber="24" name="ParkingPaid"> <text>Parking (paid)</text> </entrydata> <entrydata columnnumber="25" name="FoodBeverage"> <text/> </entrydata> <entrydata columnnumber="26" name="Shopping"> <text/> </entrydata> <entrydata columnnumber="27" name="Exhibit"> <text/> </entrydata> <entrydata columnnumber="28" name="Performance"> <text/> </entrydata> <entrydata columnnumber="29" name="KidFriendly"> <text>Kid-friendly</text> </entrydata> <entrydata columnnumber="30" name="History"> <text/> </entrydata> <entrydata columnnumber="31" name="Green"> <text/> </entrydata> <entrydata columnnumber="32" name="NewThisYear"> <text>New this year</text> </entrydata> <entrydata columnnumber="33" name="Reservations"> <text/> </entrydata> <entrydata columnnumber="34" name="OfficialGreenSite"> <text/> </entrydata> <entrydata columnnumber="35" name="BikeRacks"> <text/> </entrydata> <entrydata columnnumber="36" name="RoadClose"> <text/> </entrydata> <entrydata columnnumber="37" name="OrganicFood"> <text/> </entrydata> </viewentry> <viewentry position="3" unid="58B01EF4B58CFE1D85257C97007303D5" noteid="4B76E" siblings="1209"> <entrydata columnnumber="0" name="EventName"> <text>10th Annual Toronto Tango Festival</text> </entrydata> <entrydata columnnumber="1" name="Area"> <text>Southwest</text>

It worked using the simple search and i had to edit the sql statement a bit as for the pagination and full text will modify it at a later date.Thanks

I have this function for a search engine using pdo public function GetPageurlByPagecontent() { $db = Database::getDB(); $query = "SELECT * FROM searchengine where pageurl Like Pagecontent"; $searchengine =$db->query($query); return $searchengine; } in the data base pagecontent = keyword pageurl is the url to match that keyword this is my form , I want the pagecontent to match the pageurl only when i do a search by the pagecontent dont even think this query work any ideas? <form action="searchhome.php" method="post" id="search"> <b>Enter Search Term:</b> <input type="text" name="term" size="50"> <b>Results:</b> <select name="results"> <option>10</option> <option>20</option> <option>50</option> </select><br> <input type="submit" value="Search"> </form> <br /> <br /> <?php if(isset($_POST['pageurl'])){ $c_name = $_POST['pageurl']; $pdb2 = new SearchDB(); $search= $pdb2->GetPageurlByPagecontent($c_name); ?> <h1> Results <?php echo $c_name ?> </h1> <?php foreach($search as $list): ?> <br /> <br /> <table> <tr> <td> <p><em> url </em>: <?php echo $list['pageurl'] ?> </p> </td> </tr> </table> <?php endforeach; ?> <?php }?>

this code works but i need to insert isset so that when i select a country the dropdown list remains selected for that particuar country i tries this if(isset($_POST['country']) but it doesnt work???? <form action="index.php" method="post" id="selected_country"> <p for="country_list">Please Select A Country:</p> <select name="country" id="country_list" onchange="this.form.submit();" > <?php foreach($countries as $name): ?> <option value="<?php echo $name['country'] ?>"><?php echo $name['country'] ?></option> <?php endforeach; ?> </select> <!-- <input </div>type="submit" value="View Culture" />--> </form> <br /> <br /> <?php $c_name = $_POST['country']; $pdb2 = new CountryDB(); $countries1 = $pdb2->GetCountryByCountry($c_name); ?> <h1> Culture of <?php echo $c_name ?> </h1> <?php foreach($countries1 as $list): ?> <table> <td> <img src="<?php echo $list['image'] ?>"> </img> </td> </table>