Php Mysql Work 21.03.08
PHP/MySQL Project
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.
There is a second part to this script I’d like implemented and added to a web based control panel.
I need a script to control all of my outgoing traffic that is being generated via search engine. I need the ability to separate the traffic by niche/group. So what I could do is copy and paste my affiliate url and it would automatically generate a meta referesh link like “domain.com/recommends/redirect.html”. I also need the ability for it to generate mass links with unique identifiers and be able to group them as well. For example, I have a csv file that looks like this “keyword;domainlink” I need to be able to upload that whole csv file and have it auto generate links I can control from the backend web panel. I need certain records to be saved as well like, daily hits, weekly hits, unique hits, total hits. The redirects need to be a meta refresh and needs to wait 2 seconds before redirecting.
This should all be integrated with the first part of the script.
Basically, what I am trying to accomplish is to find out what keywords are generating traffic and find a way to redirect them to the right page.
I know I am missing some features so please let me know if there is something else you see.
Please ask any questions in the PMB and I will need you to post in there that you understand before I consider your bid and I do work full time on the web so there will be loads more php/mysql work if you want it.
