209128 PHP MySQL Database Extraction
N/A
Dibayar semasa penghantaran
PHP/MySQL Data Extraction Script
I need someone to make a quick script for me that I can run from the shell or in some kind of queue process. I have attached the original script that someone knocked up that does what I need but still needs modifications.
The script I attached times out because the databases are so huge and it doesn't output/organize to a csv/mysql file like I need so I can analyze it. Or possibly have it output to another sql database for web based analysis. That would be better and easier to keep deduped and updated. There are a ton of stats to go through so this script won't work.
Essentially what this script will do is connect to the database(s) specified in $configfiles and go through all of the data and pick out the text that matches the criteria specified. I'll also need it to save the redirect URL that they got redirected to. This is easily found in the sql database.
There also might be an easier way to do this with the database. The script attached is only an example and finds the results by referrer. The script database I use actively tracks all of the traffic generated from which specific page it came from.
Features I'd need implemented.
Dedupe Keywords Found Generating Traffic
Ability To Have the Script Update Nightly Via a Cron.
Output to a MySQL database.
Save the redirect URL used for keyword specified.
Web Based Control Panel For Viewing the results.
Some way to organize and write the results in to a specified csv format I have ready for you.
I know I am missing some features so please let me know if there is something else you can do.
Please ask any questions in the PMB and I will need you to post in there that you understand before I consider your bid.
ID Projek: #1955353
