How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Brandon M. Your Own Question

Brandon M.
Brandon M., Web Designer
Category: Programming
Satisfied Customers: 6976
Experience:  Web Design for 10 years, HTML, XML, PHP/MySQL, Perl, JavaScript, CSS
12024030
Type Your Programming Question Here...
Brandon M. is online now
A new question is answered every 9 seconds

I have a database that is hosted on a remote server than the

Resolved Question:

I have a database that is hosted on a remote server than the rest of my site. The search form is located at: http://65.74.148.68:7777/pls/golf/golf.extsearch.

I want to be able to retrieve results from a search and place them on a different remote page. Here is a query URL string:
http://65.74.148.68:7777/pls/golf/extresults?lcompany=&lcity=Sacramento&lstate=&lzip=&BR=&GC=&GS=&TY=&INV=&RE=&PA=&WK=&i_info=0&search=++Search++&scompany=on&saddress=on&sphone=on&uname=&pword=

I have tried PHP and cURL, file_get_contents, etc. But my code writing ability isn't mastered so I am not getting a good result.
Submitted: 1 year ago.
Category: Programming
Expert:  Brandon M. replied 1 year ago.

BeBoo :

Hello and thank you for contacting JustAnswer, a paid expert support site. My name is XXXXX XXXXX I'd be glad to assist you with your issue.

BeBoo :

Are you attempting to place this into a specific part of a page?

Customer:

I want to be able to take the search results and show them on a different page yes. I have reviewed scraping techniques, but I am having some issues in getting the result I want. For example, my primary website is located on a different server that the search engine and database. So, without the use of an iframe I want to use a form to hit the search engine with a query and then the results are scraped and copied to a spot on my primary site.

BeBoo :

I understand. I was able to use this last night:

BeBoo :

<?php
echo file_get_contents('http://65.74.148.68:7777/pls/golf/extresults?lcompany=&lcity=Sacramento&lstate=& amp;lzip=&BR=&GC=&GS=&TY=&INV=&RE=&PA=&WK=&i_info=0&search=++Search++&scompany=on&saddress=on&sphone=on&uname=&pword=);
?>

BeBoo :

I know you said that you tried file_get_contents but that is working.

Customer:

One sec

Customer:

Let me upload

Customer:

I received an error message unloading that

Customer:

Should there be more code with it?

BeBoo :

Nope, that is it. What is the error?

Customer:

One sec

Customer:

Here, see for yourself. This is the code you just game me put in a blank php file. http://powersportshub.co/scrape4.php

Customer:

game=gave

BeBoo :

Do you have access to the server error logs?

Customer:

I think so

BeBoo :

If so, can you please provide the last few lines?

Customer:

I have regular logs..like hits and such, but not error logs. Don't see them

BeBoo :

Ohh, I made a typo. Try this:

BeBoo :

<?php
echo file_get_contents('http://6 5.74.148.68:7777/pls/golf/extresults?lcompany=&lcity=Sacramento&lstate=&lzip=&BR=&GC=&GS=&TY=&INV=&RE=&PA=&WK=&i_info=0&search=++Search++&scompany=on&saddress=on&sphone=on&uname=&pword=');
?>

Customer:

Here is the new code. Check it out.

Customer:

No error now..just blank page.

BeBoo :

If you click Run in the top right, it should work.

BeBoo :

There might be restrictions on your PHP install to prevent remote files

Customer:

Okay, I see how that is working and I thank you for showing it to me working elsewhere.

BeBoo :

phpfiddle is pretty nice for testing code and sharing.

Customer:

What do I add to the remote "form" to have those results get scraped and display?

BeBoo :

You mean the form that submits to this script?

Customer:

Yes, I need to me able to have the form query and then send back results like that. Here is the form for example.

Customer:

Right now we have to iframe this form. Once this gets figured out it will give us more choices and power. Our search engine is old school :/

BeBoo :

Its ok. Just looking at it now

Customer:

Cool

BeBoo :

Form looks ok. Just change the action to the new script.

Customer:

So how would I write that?

Customer:

I understand what you are saying.

Customer:

But not sure the coding

BeBoo :

See on the form code where it says this: <FORM NAME="find" ACTION="http://65.74.148.68:7777/pls/golf/golf.extresults">

Customer:

Yes sir

BeBoo :

You just need to change the ACTION value to the php script

BeBoo :

So, if the script is located at http://65.74.148.68:7777/pls/golf/extresults

BeBoo :

that is what you would use for ACTION

BeBoo :

So it would read: <FORM NAME="find" ACTION="http://65.74.148.68:7777/pls/golf/extresults">

Customer:

So how are variables of the search passed then? Sorry part is beyond my skill level. I had that first part done, just the server sucked :(.

BeBoo :

No worries at all. Each field has a name option. Those fields, with their values are sent to the php script.

BeBoo :

In the PHP script, you then get these variables with $_REQUEST['name']

Customer:

Okay, so the way it goes now. 1) The form I showed you 2) The new action goes to the php script that querys the search engine and scrapes the results?

BeBoo :

replacing the 'name' with the name from the form

BeBoo :

So, the PHP script will need to be modified clightly

BeBoo :

slightly*

BeBoo :

To allow for the form values to be used.

Customer:

Can you assist with that?

BeBoo :

Sure. Let me see what I can do.

Customer:

Just what the form action should be and then what changes to the new php file.

BeBoo :

Yes

BeBoo :

The new PHP file might be a little hard to understand if you are trying to learn it

Customer:

Well that is okay.

Customer:

But if I can do a search from a form, hit that script and it scrapes and returns the correct results I will be happy. I would like to get your direct contact on here to so that if I have any other issues I can pay you to assist me.

BeBoo :

No problem at all. You can bookmark my profile page and ask from there if you need anything else. My profile page is my name in the lower left.

BeBoo :

If you run that, it will give you errors because you aren't submitting a form to it.

Customer:

So what action do I had to the form?

Customer:

lets say the php file is called searchresults

Customer:

Would it just be the url of the php file?

BeBoo :

Correct

Customer:

okay let me set it up and see if that works, brb

Customer:

by the way, I found a different server that allowed for the script to work

BeBoo :

Awesome

Customer:

Okay, this part of the coding is working. Can the results be placed into a page that has CSS, images and stuff or will it just be a copy of the results page?

BeBoo :

You would need to put that html code around the <?php and ?> tags

BeBoo :

You can just put html code in that php file but outside the <? ?> tags

Customer:

That is what I thought :)

Customer:

Okay, I will hit you up if I need any more help (which I am sure I will).

Customer:

Thank you.

Brandon M., Web Designer
Category: Programming
Satisfied Customers: 6976
Experience: Web Design for 10 years, HTML, XML, PHP/MySQL, Perl, JavaScript, CSS
Brandon M. and other Programming Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >
  • http://ww2.justanswer.com/uploads/SP/spatlanta2010/2011-6-23_12450_photo.64x64.gif ATLPROG's Avatar

    ATLPROG

    Computer Software Engineer

    Satisfied Customers:

    7463
    MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Computer Software Engineer

    Satisfied Customers:

    5603
    Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.
  • http://ww2.justanswer.com/uploads/unvadim/2010-11-15_210218_avatar.jpg unvadim's Avatar

    unvadim

    Computer Software Engineer

    Satisfied Customers:

    1158
    Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    950
    Several years of intensive programming and application development experience in various platforms.
  • http://ww2.justanswer.com/uploads/EH/ehabtutor/2012-8-2_202016_1.64x64.jpg ehabtutor's Avatar

    ehabtutor

    Computer Software Engineer

    Satisfied Customers:

    864
    Bachelor of computer science, 5+ years experience in software development, software company owner
  • http://ww2.justanswer.com/uploads/RA/rajivsharma086/2012-6-6_17128_displaypic.64x64.jpg Raj's Avatar

    Raj

    Computer Engg.

    Satisfied Customers:

    860
    BE CS, 4+ Experience in Programming and Database (ERP)
  • http://ww2.justanswer.com/uploads/eljonis/2010-01-06_130406_eljon2.jpg Eljon's Avatar

    Eljon

    Consultant

    Satisfied Customers:

    590
    11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)