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

Closed

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]

[url removed, login to view]

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

[url removed, login to view] = 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: Javascript, MySQL, PHP, Software Architecture, Software Testing

See more: purl php script, webdesignerforum, uk email database, remote full time php, php send email script, mysql city state database, import csv into mysql php script, how to create php contact form, how to create a contact form in php, email database uk, db import export, country state and city database mysql, protect database, modrewrite, load information from mysql, database script, database building 2, cross domain, auto form submit, auto form submitter, send email php mysql, simple php email read, form submit php, city state country php, php upload file csv

Project ID: #5224781

Awarded to:

froiden07

A proposal has not yet been provided

$144 USD in 3 days
(149 Reviews)
6.3

8 freelancers are bidding on average $160 for this job

mohanchauhan

Hi Sir, I am a lead programmer as i have 10 years of working experience in php,mysql,ajax, jquery, javascript, css, html, Graphics Design. I am a lead developer with a team of developers and designers. I have expe More

$206 USD in 10 days
(15 Reviews)
5.7
Champian

Hi, I am working as a freelancer website designer and developer, I have 5+ years of experience in design and programming joomla, PHP, Wordpress. Here is my profile on Joomlancers.com http://www.joomlancers.com/p More

$157 USD in 8 days
(32 Reviews)
5.5
eComOS

Hello iambobydigital, I have gone through your outsourced requirement "PHP MySQL pURL script and database, Easy work for the right person!" and have analyzed that I have right credentials (Javascript, MySQL, PHP, S More

$166 USD in 2 days
(54 Reviews)
5.3
silsoftstudio

Hi, If i understand the project correctly all you need is to have a website which you can target like : http://mysite.com/username.htm showing some details page and you can manage thouse username.htm (URLs) from More

$155 USD in 5 days
(1 Review)
1.8
TVSolution

Hi, your task clear, i can start immediately. We have very big experience with scripts. About us: my name Vera, im co-CEO of VIA technologies. We are professional team from Ukraine, our experience more then 5 years More

$155 USD in 1 day
(1 Review)
1.2
vaishnavi04

Hello Sir We are 10 employee company started in the year 2011 to provide support for companies of different verticals. We offer best quality at affordable pricing.We have done many projects on wordpess,PHP.We are pe More

$155 USD in 3 days
(1 Review)
0.6
alltechinfohub

A proposal has not yet been provided

$155 USD in 15 days
(0 Reviews)
0.0
CybernateS

Hello Sir, How are you? Hope your doing well... I saw your project requirements and I would like to offer our services. * I am working on this technologies for 5 years. * I am new at this market but we are worki More

$155 USD in 4 days
(0 Reviews)
0.0