I need a simple php & MySQL script to get a search results from google
I want to offer a search box ( text box , search button ) to the users to use google search from my site
But before i redirect the user to google , i need to save the results in a mysql database
I need 2 tables
Table1 : will contains the Search text entered by the user with unique id
Table2 : will contains the first 2 pages from google search results and attach to each record the Search text id
so lets make Table1 name : 'search_texts' with 2 columns ( text_id , search_text )
And make Table2 name : 'search_results' with 5 columns ( result_id , title , url , text , text_id )
text_id here will be from 'search_texts' table
So i can get all the search results from table2 related to the search text from table1
Please check the attached image to see what is the content required to get from google search
After the database insertion process done redirect the user to goole to give him the results as normal
Important note : you need to consider the languages in your code , the script will be used by different languages
So if a user from any country uses his language to be saved in the database correctly
And to be able for later use by programming languages
Please make your code clear and easy to modify later
And make a text file contains instructions how to use the script
Hi! I am interested in your project. I have much experience in web scrapping, database development. I will do this job as you want. If you wish to hire me, please send me a message. Thank you.
hi we could do it perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by replying..
I just worked on this and was able to extract the headings the url and the text below each of the search results. I can provide you a demo later if you're interested.
I'm highly experienced in SQL, mySQL, and PHP-based applications. I can deliver this project with all bases covered and code-commented, so it can be easily expanded upon.