Find Jobs
Hire Freelancers

PHP/MySQL Script

$30-250 USD

In Progress
Posted over 11 years ago

$30-250 USD

Paid on delivery
I need some PHP OR PERL files that i can put in crontab that will do the following: ## File number 1. ## 1. Take 'input' from a DB Table Field, a Name, checking if it was 'already processed' before 2. Solve that name into an uniqueid, using another table. If there's no unique_id, send a customized mail to the user mail (available in the input table) IF he didnt receive such a mail before. Create a flag for it. 3. Insert a record in another table, the unique_id and the number. 4. Upon successful insert, update the input table to flag the name as already processed. ## File number 2 (this one will be called by the user) ## 1. As before, use name to unique_id resolution to get the unique_id of a name. 2. Use the unique_id to get info on that particoular unique_id 3. Check if that name or unique_id is allowed to make a change, by form of 'credits'. You can modify whatever table you want to create and manage 'credits'. 4. Modify certain fields of the resulting row, namely, one row contains [[ITEM1],[ITEM2],[ITEM3]]. Have to parse it and modify it according to rules, IE, only modify if number of items already present are under a certain number. 5. Make it work on user call. Meaning, i'll create a webpage with a list of items and i'll use a form to send the php file the name and the item requested. 6. Send me (not the user) a mail with: Name, UID, Item and a copy of the modified row. ## File number 3, another form handling page. I've got a form for users requesting stuff, i need a php page that will check that the user has enough 'credits' in their account to request a particoular item. If it dosnt, show 'em the error and a link on how to get more credits, if he does, send him a request acceptance email, update his credits, and send me an email with what he wants. ## PayPal Update credits of users based on amount paid/donated, NAME and EMAIL must match. Paypal IPN. ## Control Page Give me a page in which i can enter the name and credits that i want to add, and it will add them, also showing current user credits (all of them), sortable by username and credits. Also, i need to be able to have a form in which to input the name and a number, and it will do exactly like file 1 except, this will be a manual update. In case of a manual update, an eventual previous entry to the destination table must be first removed (its a constraint on the database). PHP / Perl / Apache server working on remote MySQL DB.
Project ID: 4104115

About the project

10 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $171 USD for this job
User Avatar
Dear Sir, We would love to get this opportunity of working with you. We can guarantee complete satisfaction if you select us to execute this project. Regards NetzPro
$250 USD in 3 days
5.0 (362 reviews)
8.5
8.5
User Avatar
pls chk pmb
$250 USD in 4 days
4.9 (545 reviews)
7.9
7.9
User Avatar
ready to start Thanks
$120 USD in 7 days
4.9 (136 reviews)
6.7
6.7
User Avatar
Full time freelance web developer with over 8 years of commercial experience.
$200 USD in 3 days
5.0 (89 reviews)
6.4
6.4
User Avatar
Hello, I can make such a work. We need discuss more detailed paypal part. Regards. Dima
$150 USD in 4 days
5.0 (65 reviews)
5.7
5.7
User Avatar
Hi, I have read all of your requirements, I can write php script for it. Please see PMB for more details on my proposal. Thanks
$150 USD in 7 days
5.0 (7 reviews)
3.9
3.9
User Avatar
Hello, I've readed the description and I can write this files for you. Regards, Andy.
$113 USD in 2 days
5.0 (7 reviews)
3.2
3.2
User Avatar
Hello Sir, We feel quite confident that we can pull off this project very well. Looking forward to hear from you. Warm Regards, IGen Technolabs
$125 USD in 5 days
5.0 (6 reviews)
2.7
2.7
User Avatar
Hi I am ready to implement these scripts as i have worked with each of it.
$150 USD in 7 days
4.7 (2 reviews)
2.7
2.7
User Avatar
Hi, i have knowledge in PHP and MySQL. I am ready to work. pls send more detail if you interested. thank you
$100 USD in 7 days
5.0 (1 review)
1.8
1.8
User Avatar
Dear Hiring Manager, I have read your requirements and can quickly develop all the pages and scripts you need. I can bring the file 1 into life tonight(in the next few hours as you requested)
$200 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Anzola Emilia, Italy
5.0
10
Payment method verified
Member since Jun 18, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.