I have a mysql database.
In this database are several fields (columns).
It is automatically updated (new rows) when people fill in a form on our website. It has a couple of blank fields.
I would like for:
1. a php script which allows information to be passed in the url, like this:
[login to view URL]
the php script will then
1. check the database to look for that email address
2. If the email address does not exist then return some error.
3. If it does exist, then check if the id field is blank/null
4. if it is blank/null then update the id to whatever is in the url. and return a verified message.
5. if it is not blank/null then return error that it has already been claimed (or verified).
This will continuously check the database (i can setup a cron for once every minute or 2) for all records that do not have a specific value in one of the columns. for example sent=null
so like this when script is run:
1. lookup all records which have sent=null (or not yes/1) and have id is not null
2. execute json-rpc call to our server with a command based on information in the records it found.
e.g. create account bob send 100 credits sdfjsdfdslfsdlfsdlf
the account is in the record and the id is in the record.
3. Check what is returned:
4. if successful a long string of letters and numbers will be returned. Update the record with this string, and update sent=1
5. if an error returns that is = this account already exist, then append a "x" to the account name and repeat for that record, until it is accepted. Then update the record with the string and update sent=1 and also update "givenname" field to the name that was used, example bobxx
6. If any other error returns then end the script.
all actions need to be properly synchronised/atomic.
23 Freelancer bieten im Durchschnitt £141 für diesen Job
Hi, I have read your project description and willing to do this for you in your required time spam with 100% Satisfaction. Kindly message me so we can discuss in detail over chat......
Hi, I can write a php and python script as per your requirement within a day or two. Let's have chat to discuss further on this project. Thanks, Sayan
Hello sir, I can make you both scripts in python . The php script can be done in python . the script is for 30£ you can hire me for the python script only for cheap price if you need the php script in php.
SELECT FROM user_account INNER JOIN ((task_table INNER JOIN (officer INNER JOIN (activity INNER JOIN assigned ON [login to view URL] = assigned.activity_id) ON [login to view URL] = assigned.officier_id) ON [login to view URL] = [login to view URL] Mehr