|
|
Posted by richard on 09/24/06 15:01
"Johnny" <removethis.huuanito@hotmail.com> wrote in message
news:EInRg.176$UJ2.173@fed1read07...
>
> "richard" <don@john.son> wrote in message
> news:ef40gn02qjn@news2.newsguy.com...
>>
>> "Johnny" <removethis.huuanito@hotmail.com> wrote in message
>> news:GufRg.167$UJ2.61@fed1read07...
>> >
>> > "richard" <don@john.son> wrote in message
>> > news:ef3taq02mp4@news2.newsguy.com...
>> >> I am attempting to acquire certain information from a database.
>> >> At this time they only have a simple search method.
>> >> What I want to do is, at least eliminate the boring manual search
> entries
>> >> one at a time.
>> >>
>> >> Currently, I enter a number into the search box, press enter.
>> >> I may go through dozens of numbers just to get one that has more
>> >> information.
>> >>
>> >> So I was wondering if there was a way php could automate this process?
>> >> Even if all it did was to tell me which numbers had more information.
>> >> All those responding with the "no results found" page would be
>> >> eliminated.
>> >> I could then store the assigned numbers to an array and work from
>> >> that.
>> >>
>> >> http://safer.fmcsa.dot.gov/CompanySnapshot.aspx
>> >>
>> >> Enter any number in the box. If no company is assigned that number,
>> >> you
>> > get
>> >> the error page.
>> >>
>> >
>> > hmmmm.... .apsx aren't you in the wrong group?
>>
>> Just covering all the bases.
>>
> well then, yes, there are ways that PHP can automate that process.
>
> Here's kind of how I would approach it, off the top of my head:
> Look at the source of the page and see the form that calls the
> server with action "query.asp" and make a php page locally on your pc
> (that
> has a web server running PHP, you got one o dem right?) that has all the
> form vars and make it so you can set the
> ones you want (get post or however).
> Fer(sic) instance use curl
> http://us3.php.net/manual/en/function.curl-setopt.php ) to do it like so:
>
> <?php
> for ($index=3; $index<10; ++$index) {
> $sessions = curl_init();
>
> curl_setopt($sessions,CURLOPT_URL,'http://safer.fmcsa.dot.gov/query.asp');
> curl_setopt($sessions, CURLOPT_POST, 1);
> $post_fields =
> "searchtype=ANY&query_type=queryCarrierSnapshot&query_param=USDOT&query_stri
> ng=";
> $post_fields .= $index;
> curl_setopt($sessions,CURLOPT_POSTFIELDS,$post_fields);
> curl_setopt($sessions,CURLOPT_COOKIEJAR,'/home/usir/cookie.txt');
> curl_setopt($sessions,CURLOPT_FOLLOWLOCATION,0);
> curl_setopt($sessions, CURLOPT_HEADER , 1);
> curl_setopt($sessions, CURLOPT_RETURNTRANSFER,1);
> $my_load_page .= curl_exec($sessions);
> }
> echo $my_load_page;
> ?>
>
> I'll leave you to figure out how to extract the data you need from what's
> returned and how to make it do more than a few without choking, but you
> get
> the gyst I'm sure.
>
> PHP rules!
>
>
>
Ok since php can do the trick, then would you be willing to write the entire
thing?
I'd be willing to even pay you for your time.
For my purposes I would need only like 6 or 8 fields.
The output could just go to a text file for the time being.
email me richardb @ newsguy.com
Navigation:
[Reply to this message]
|