Fertiggestellt

Python script + php + mysql + json-rpc

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).

Python script:

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.

Fähigkeiten: Python, PHP, MySQL, JSON

Mehr darüber invoice system cms script php mysql, create secure sign login script php mysql, secure login script php mysql pear, forgot password script php mysql, adult website script php mysql, flash image rotator script php mysql, sudoku script php mysql, php mysql json respnse jquery forms, script php show online players count server warcraft, blogging script php mysql, build lead generating script php mysql, create login script php mysql ajax, categories subcategories script php mysql, user profile script php mysql, script php mysql rating, free poker script php mysql flash, ovguide comment script php mysql, script php mysql client server

Über den Arbeitgeber:
( 36 Bewertungen ) PRESTON, United Kingdom

Projekt-ID: #20761064

Vergeben an:

xiqian88

Hello. I know you are cool client. I hope work with you. Best regards. ..................................

£250 GBP in 7 Tagen
(50 Bewertungen)
7.3

23 Freelancer bieten im Durchschnitt £141 für diesen Job

rajdeepa555

Hello Sir, I am an experience web api developer. I checked your requirements, I understand that we need to create a get api which contains all the information needed, then we need to perform multiple checks over this Mehr

£150 GBP in 2 Tagen
(84 Bewertungen)
7.0
techwelfare

Hello, After analysing your requirements,we would like to inform you that our skills match your criteria . We are a fast- growing company, and have well- trained resources available to initiate your project immediately Mehr

£160 GBP in 7 Tagen
(181 Bewertungen)
7.2
valor312

VERY EASY FOR ME As you can see in my review, I've done similar with yours Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time Mehr

£135 GBP in 1 Tag
(117 Bewertungen)
6.7
naravila

Hi, Sir I've read your requirement carefully. I'm sure I can finish your task perfectly in a short time. As you can see my profile, I'm a senior Web developer. I've plenty of experiences and finished lots of projects b Mehr

£200 GBP in 7 Tagen
(51 Bewertungen)
6.4
marioada

Hello, Hope you're doing well, let me get right into it. Based on the URL you pasted, you want the script to receive GET Requests which we can easily implement by using $_GET in PHP. That being said, the verification Mehr

£134 GBP in 3 Tagen
(26 Bewertungen)
6.5
crtvecode

Hello, Why do you need the Cron Job to be in Python? you can also run the PHP script in Cron Job. I am experienced in both PHP and Python and I understood your requirment very well. Please check my LinkedIn recommend Mehr

£199 GBP in 3 Tagen
(91 Bewertungen)
6.6
Grisha97924

⭐⭐⭐⭐⭐ Hi, Dear I understood all what you need. I have rich experience and can complete this project. I am finding way to solve project main features. Please contact me and let us discuss more about project. Best regard Mehr

£150 GBP in 2 Tagen
(37 Bewertungen)
6.2
grigorywazin

Dear man I read your project description very carefully and I hope to work in this project. While doing this project, we must do top skills to do this project… For doing that , you can face some issues like Yours. But Mehr

£135 GBP in 7 Tagen
(31 Bewertungen)
6.6
vladzolotukhin

Hello sir. I read your requirement in care. It is no problem for me. As you can see in my profile, I am fully experienced and lots of skills about your project. Chat by pressing a button and discuss me about it, we'd Mehr

£140 GBP in 7 Tagen
(53 Bewertungen)
6.1
coolmob0816

Dear client. I am a senior web developer and a serious bidder. I have rich experiences in web development with PHP, Python. I have read your requirement and I am confident that I can bring you the best result. Look Mehr

£200 GBP in 15 Tagen
(25 Bewertungen)
5.6
hassanmustafa01

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......

£150 GBP in 1 Tag
(67 Bewertungen)
5.7
albertpopov46

Hi Dear I read your requirements carefully. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software architecture and so on. You can see my good reviews for python projects. Please touch me. I w Mehr

£135 GBP in 7 Tagen
(36 Bewertungen)
5.4
phantom1222

Hello I read your job post and very interesting. I think I am a good candidate for this job because I have been working as PHP & Python developer for about 10 years and have tons of skills in the area. My working sched Mehr

£240 GBP in 4 Tagen
(24 Bewertungen)
5.3
sayansaha986

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

£80 GBP in 1 Tag
(45 Bewertungen)
5.0
pandaios

Hi Nice to meet you. With 6+ years of experience in Web development, I developed a lot of big and small websites using HTML & PHP(Laravel, Codeigniter, Yii) & Python(Django, Flask) & JS(Angular, Node, React, Vue) & C Mehr

£135 GBP in 7 Tagen
(12 Bewertungen)
4.3
GlobalSolution3

Hello, this looks like everything we could help you with. I specialize in: PHP & PHP frameworks such as Laravel, CI, Yii and CakePHP, API development, HTML5, CSS, JavaScript, Bootstrap, MySQL, etc. http Mehr

£135 GBP in 7 Tagen
(12 Bewertungen)
3.9
BrokeProgrammer

Hey, Would love to discuss this in detail. I have been working since last 4 years and have a team of 8 people, started as an intern in a startup that ended up being one of the biggest content companies in the world. Th Mehr

£120 GBP in 7 Tagen
(4 Bewertungen)
3.6
mahmoudhoss

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.

£60 GBP in 2 Tagen
(12 Bewertungen)
3.3
uelionobre

Hi, I am full stack developer. I have read all your requirement and I wish to work for your project. I'm very interested in your job post.I believe my skills would be ideal for your project. I am ready to start with y Mehr

£135 GBP in 7 Tagen
(10 Bewertungen)
3.3
babyphilo

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

£50 GBP in 2 Tagen
(2 Bewertungen)
1.3