PHP MySQL pURL script and database, Easy work for the right person!

IN PROGRESS
Bids
9
Avg Bid (USD)
$161
Project Budget (USD)
$30 - $250

Project Description:
I need the following script built with an installer for both the database script and the client script:

pURL script

Follow the intructions for building a MySQL + PHP + modrewrite pURL script included below.
Make sure to protect against mySQL injection attacks.

[READ binarymonkey’s comments for instructions]
http://www.webdesignerforum.co.uk/topic/17141-how-to-best-do-purls-personal-urls/



Create an admin panel to upload CSVs of contact information into the mySQL Database
fields to include:
userID
firstname
lastname
adress1
adress2
city
state
zip
zip4
country
phone - this field may be sent back to the DB server from the client script
email - this field may be sent back to the DB server from the client script
listID
creativeID - this field will be sent back to the DB server from the client script
importdate (populated at date of import)
dupindex
pURL where:
if_Unique(FirstName+LastName)
pURL = FirstName+LastName
else_if_duplicate
this.dupindex = last dupindex + 1
pURL = FirstName+Lastname+dupindex

If there are 3 “tom jones”
their dupindexes would be 1, 2, and 3
their pURLs would be TomJones1, TomJones2, TomJones3

The duplicate check should happen once when the CSV file is imported to the database.
At that time all dupindex should be set, and all pURLs should be defined and stored in the database

The admin panel shoudl also allow the user to export a CSV of all fields for any given list ID and import date range (no range specified = all).

client script and central db server

The main difference to the setup described above will be that you will need to build it to work cross domain.

So there will be a central DB server with all of the user info.

The client script and .htaccess file will be installed on remote domains.
THe script needs to call back to the DB server with the name portion of the pURL (with dupindex# if there) in the pURL to retrieve the info

Then the DB server needs to respond back with all of the info on the user in an easily readable format. the client side script should load the full response as php variables in the page so the page can be programmed to insert those variables into differnt places using simple PHP.

Example of the insertion code for each variable should be provided.

Special user supplied fields - CreativeID, email, phone:
These fields may be blank by default after CSV import
the DB server will need to be able to recieve a userID and (creativeID, and/or email, and/or phone) post from the client script
this call will happen after the inital call requesting the user data
the user will input this data into an auto responder form on the client page and upon form submit the client script will need to have a routine to send this data to the DB server then submit the form
(example form code will be provided, along with multi submitter code examples)

the DB server should then overwrite these fields for the given userID with the info provided by the client script

example call: updateUser( userID, phone, email, creativeID )

Mixpanel integration
Each time the DB server returns a user’s information set a new “person” should be created in mixpanel for tracking purposes.
mix panel code will be provided
this should be optional on the client side

Skills required:
Javascript, MySQL, PHP, Software Architecture, Software Testing
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 144
in 3 days
$ 206
in 10 days
$ 157
in 8 days
$ 166
in 2 days
Hire silsoftstudio
$ 155
in 5 days
$ 155
in 1 days
$ 155
in 3 days
$ 155
in 15 days
$ 155
in 4 days