Find Jobs
Hire Freelancers

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

$30-250 USD

Pågår
Lagt ut over 10 år siden

$30-250 USD

Betalt ved levering
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] [login to view URL] 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 [login to view URL] = 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
Prosjekt-ID: 5224781

Om prosjektet

7 forslag
Eksternt prosjekt
Aktiv 10 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
7 frilansere byr i gjennomsnitt $163 USD for denne jobben
Brukeravatar
A proposal has not yet been provided
$155 USD om 15 dager
4,0 (24 omtaler)
4,4
4,4
Brukeravatar
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. Our team is also has certified Microsoft professionals (MVP, MCP). We guarantee the timeliness of performance, quality and promise to always be in touch with you :) Hope to cooperate!
$155 USD om 1 dag
5,0 (2 omtaler)
1,2
1,2

Om klienten

UNITED STATESs flagg
San Francisco, United States
4,9
44
Betalingsmetode bekreftet
Medlem siden des. 19, 2007

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.