In Progress

Build A Twitter Marketing Site In PHP/MySQL


The mission in mind is to build a site, which is similar to another website ([url removed, login to view]). Essentially, I would like to build a site in which user’s login into my site to use their twitter account, through the Twitter API, to post affiliate-marketing links. Only accounts with 25 followers or more can participate. This information will be drawn through a script. Through the usage of PHP script redirection and MySql databases, I would keep statistics for each member to be used in a PayPal payout scheme.

My Vision *Please note: I am not a master of PHP/MySql/etc.*


I envision a backend system that comprises of three MySql databases.

(1) User Database – the user database stores the following:

- Username

- Full Name

- PayPal account info

- Twitter Account Name

- Twitter Account PW

- Referrals (count of referrals)

- Successful CTC (click through count)

- Payout (based on the payout algorithm)

(2) Affiliate – the database when an advertiser signs up, their information is stored here:

- Affiliate

- Affiliate PPC (price per click)

- Affiliate Marketing Message

(3) Referral Database – stores referral information, not sure if necessary

- Referby (the original user who referred)

- ReferUsername (the new user)

- Referral Payout

The front end will be completely PHP based:

(1) Index Page – [url removed, login to view]

(2) Signup For Users – [url removed, login to view] (with email verification)

(3) Signup For Advertisers – [url removed, login to view] (with email verification and payment verification)

(4) Ads –[url removed, login to view] (please see attached doc)

(5) Referals -- [url removed, login to view] (unique referral code generated per user)

(6) Edit – [url removed, login to view] (user can edit email – with verification, change pw, edit paypal email)

(7) Stats – [url removed, login to view] (displays total posts for the day, yesterday, successful clicks, and payout)

(8) Twiter-Profiles – [url removed, login to view] (user can add additional twitter accounts)

(9) Withdraw – [url removed, login to view] (user can request a withdraw when account hits $20)

(10) FAQ – a basic FAQ, no scripting

(11) Logout – [url removed, login to view] (secure logout)

(12) Twitter – [url removed, login to view] (used to access the Twitter API and post the marketing information)

The Service Provider


I am looking for a web designer/programmer that has a mastery of PHP and MySql. While I do not expect you to be available 24/7, I will be requesting daily updates and expect you to meet project timelines. The PHP scripts need to be very well commented and the system needs to be designed with growth in mind.



I am a workaholic that always has access to email, ICQ, yahoo, skype, phone, etc. I am always available to provide direction and make sure things progress as planned. I won’t waste your time. I will be prompt with payment and will rate your services accordingly.

Please bid respectively and good luck to the winners. I ask that you be honest about your abilities.

Thank you,

Skills: PHP, Software Architecture

See more: workaholic web, website api request programmer, web designer referrals, web designer new things, web designer mysql, web designer marketing, web designer daily rate, web and marketing programmer, web affiliate marketing, twitter com web, things to post as web designer, the marketing, statistics architecture, statistics algorithm, software programmer service, skype api for php, service-master, referral code, price of a web designer, price for a php programmer, php web designer software, php web designer price, php code register, paypal architecture, need programmer full day

About the Employer:
( 6 reviews ) guang dong, China

Project ID: #1326589

Awarded to:


Hi, I can finish the job for you. please ping me if you would like to award me this project. thank you.

$30 USD in 4 days
(6 Reviews)

2 freelancers are bidding on average $1015 for this job


Greetings.. ********************************.. YOUR SEARCH ENDS HERE .. ******************** we have proven again and again our ability to develop quality products on-time and on-budget without sacrificing quality. More

$2000 USD in 25 days
(12 Reviews)