chrisj1963
asked on
php sort when scraping data
Hi,
I have source data here:
http://prontopage.net/a_parse/p_datasource.htm
(note that the Monthly Volume column is unsorted)
I have a data scraper here:
http://prontopage.net/a_parse/p_scrape.php
I have a javascript that automatically sorts the Monthly Volume column after the data is displayed on the page, but that is delayed/slow after the page is loaded.
Is there a way to change the scrape.php code to sort the Monthly Volume data when it prints it to the page rather than using javacript to do the sorting?
Help is appreciated.
I have source data here:
http://prontopage.net/a_parse/p_datasource.htm
(note that the Monthly Volume column is unsorted)
I have a data scraper here:
http://prontopage.net/a_parse/p_scrape.php
I have a javascript that automatically sorts the Monthly Volume column after the data is displayed on the page, but that is delayed/slow after the page is loaded.
Is there a way to change the scrape.php code to sort the Monthly Volume data when it prints it to the page rather than using javacript to do the sorting?
Help is appreciated.
<!--<style>
table { text-align: left; border-collapse: collapse; }
tr:hover { background: blue; color: white }
th, td { padding: 7px }
</style>-->
<table>
<thead>
<tr><th>Keyword</th><th>Monthly Molume</th></tr>
</thead>
<tbody><tr><td class=1>mid pines north carolina</td><td class=2>12</td></tr>
<tr><td class=1>southern pines resort</td><td class=2>16</td></tr>
<tr><td class=1>pine needles golf course nc</td><td class=2>28</td></tr>
<tr><td class=1>north carolina golf club</td><td class=2>58</td></tr>
<tr><td class=1>golf southern</td><td class=2>12</td></tr>
<tr><td class=1>and pines inn</td><td class=2>0</td></tr>
<tr><td class=1>north carolina pine trees</td><td class=2>58</td></tr>
<tr><td class=1>nc golf course</td><td class=2>73</td></tr>
<tr><td class=1>and mid to</td><td class=2>0</td></tr>
<tr><td class=1>restaurants in southern pines nc</td><td class=2>58</td></tr>
<tr><td class=1>best golf courses north carolina</td><td class=2>22</td></tr>
<tr><td class=1>needles pine</td><td class=2>58</td></tr>
<tr><td class=1>best golf in north carolina</td><td class=2>12</td></tr>
<tr><td class=1>southern pine north carolina</td><td class=2>16</td></tr>
<tr><td class=1>north carolina golf</td><td class=2>1900</td></tr>
<tr><td class=1>southern pines golf nc</td><td class=2>12</td></tr>
<tr><td class=1>long needle pines</td><td class=2>16</td></tr>
<tr><td class=1>southern pine nc</td><td class=2>58</td></tr>
<tr><td class=1>and golf club southern pines</td><td class=2>0</td></tr>
<tr><td class=1>club lodge</td><td class=2>12</td></tr>
<tr><td class=1>carolina course golf north</td><td class=2>12</td></tr>
<tr><td class=1>pinehurst golf nc</td><td class=2>73</td></tr>
<tr><td class=1>golf courses pinehurst nc</td><td class=2>28</td></tr>
<tr><td class=1>pine needles golf club nc</td><td class=2>12</td></tr>
<tr><td class=1>needles</td><td class=2>33100</td></tr>
<tr><td class=1>golf course north carolina</td><td class=2>58</td></tr>
<tr><td class=1>seagrove resorts</td><td class=2>110</td></tr>
<tr><td class=1>pine's</td><td class=2>58</td></tr>
<tr><td class=1>golf pines</td><td class=2>12</td></tr>
<tr><td class=1>and golf club southern</td><td class=2>0</td></tr>
<tr><td class=1>pine needle golf</td><td class=2>46</td></tr>
<tr><td class=1>mid pines golf resort</td><td class=2>28</td></tr>
<tr><td class=1>lodge country club</td><td class=2>36</td></tr>
<tr><td class=1>and southern pines north</td><td class=2>0</td></tr>
<tr><td class=1>golf nc</td><td class=2>390</td></tr>
<tr><td class=1>and resort in southern</td><td class=2>0</td></tr>
<tr><td class=1>pine needles golf resort</td><td class=2>73</td></tr>
<tr><td class=1>carolina in the pine</td><td class=2>16</td></tr>
<tr><td class=1>north carolina golfing</td><td class=2>36</td></tr>
<tr><td class=1>nc golf courses</td><td class=2>590</td></tr>
<tr><td class=1>golf lessons nc</td><td class=2>28</td></tr>
<tr><td class=1>golf courses in north carolina</td><td class=2>320</td></tr>
<tr><td class=1>southern pines restaurant</td><td class=2>22</td></tr>
<tr><td class=1>carolina golf club</td><td class=2>480</td></tr>
<tr><td class=1>north carolina southern pines</td><td class=2>28</td></tr>
<tr><td class=1>mid pine</td><td class=2>12</td></tr>
<tr><td class=1>pine needles golf</td><td class=2>720</td></tr>
<tr><td class=1>mid carolina country club</td><td class=2>58</td></tr>
<tr><td class=1>at southern pines</td><td class=2>0</td></tr>
<tr><td class=1>golf resorts in north carolina</td><td class=2>110</td></tr>
<tr><td class=1>golf resort nc</td><td class=2>16</td></tr>
<tr><td class=1>golf packages in pinehurst nc</td><td class=2>12</td></tr>
<tr><td class=1>pines nc</td><td class=2>16</td></tr>
<tr><td class=1>pine needles golf club</td><td class=2>170</td></tr>
<tr><td class=1>and mid and</td><td class=2>0</td></tr>
<tr><td class=1>north carolina golf vacations</td><td class=2>320</td></tr>
<tr><td class=1>golf courses in pinehurst nc</td><td class=2>46</td></tr>
<tr><td class=1>pine needles nc</td><td class=2>110</td></tr>
<tr><td class=1>souther pines nc</td><td class=2>28</td></tr>
<tr><td class=1>pine needles golf course</td><td class=2>480</td></tr>
<tr><td class=1>pine resorts</td><td class=2>140</td></tr>
<tr><td class=1>top nc golf courses</td><td class=2>16</td></tr>
<tr><td class=1>& golf club southern pines</td><td class=2>0</td></tr>
<tr><td class=1>mid golf</td><td class=2>16</td></tr>
<tr><td class=1>southern pines country club</td><td class=2>110</td></tr>
<tr><td class=1>courses in nc</td><td class=2>22</td></tr>
<tr><td class=1>nc golf vacations</td><td class=2>91</td></tr>
<tr><td class=1>pineneedle com</td><td class=2>22</td></tr>
<tr><td class=1>pine needles golf course north carolina</td><td class=2>16</td></tr>
<tr><td class=1>the carolina golf club</td><td class=2>73</td></tr>
<tr><td class=1>1005 midland road southern</td><td class=2>0</td></tr>
<tr><td class=1>pine north carolina</td><td class=2>16</td></tr>
<tr><td class=1>carolina pines inn</td><td class=2>22</td></tr>
<tr><td class=1>best golf courses in nc</td><td class=2>28</td></tr>
<tr><td class=1>lodge pine</td><td class=2>22</td></tr>
<tr><td class=1>pines of carolina</td><td class=2>320</td></tr>
<tr><td class=1>a pine needle</td><td class=2>0</td></tr>
<tr><td class=1>north carolina golf clubs</td><td class=2>28</td></tr>
<tr><td class=1>the pine needles</td><td class=2>22</td></tr>
<tr><td class=1>mid pines golf course</td><td class=2>91</td></tr>
<tr><td class=1>golf resorts in nc</td><td class=2>28</td></tr>
<tr><td class=1>north carolina golf courses</td><td class=2>1300</td></tr>
<tr><td class=1>golf course nc</td><td class=2>58</td></tr>
<tr><td class=1>southern pine needles</td><td class=2>12</td></tr>
<tr><td class=1>mid southern com</td><td class=2>22</td></tr>
<tr><td class=1>southern pines</td><td class=2>1900</td></tr>
<tr><td class=1>mid pines country club</td><td class=2>16</td></tr>
<tr><td class=1>carolina golf club nc</td><td class=2>12</td></tr>
<tr><td class=1>north carolina golf packages</td><td class=2>480</td></tr>
<tr><td class=1>golf packages in north carolina</td><td class=2>73</td></tr>
<tr><td class=1>mid pines</td><td class=2>320</td></tr>
<tr><td class=1>south pines north carolina</td><td class=2>12</td></tr>
<tr><td class=1>north carolina pine</td><td class=2>28</td></tr>
<tr><td class=1>golf courses nc</td><td class=2>170</td></tr>
<tr><td class=1>golf resort north carolina</td><td class=2>36</td></tr>
<tr><td class=1>southern pines hotels</td><td class=2>9900</td></tr>
<tr><td class=1>southern pines nc 28387</td><td class=2>36</td></tr>
<tr><td class=1>golf courses north carolina</td><td class=2>210</td></tr>
<tr><td class=1>pine golf clubs</td><td class=2>36</td></tr>
<tr><td class=1>club mid</td><td class=2>73</td></tr>
</tbody>
</table>
I think the best way to do this would be to rearrange the way the $arr array gets built - you might want to change the $arr so that the key of each element is the string, and the value of each element is the count. Then you can sort the array preserving the key=>value pairs.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help. I have struggled for quite a while trying to integrate this code with the code I posted as a reference, so I will be posting a follow-up. You are welcome to comment there if you would like to provide a solution. Thanks again.
Thanks for the points! Best, ~Ray
ASKER
Open in new window