Need help on PHP script

Looking to hire a PHP developer for a paid position? Looking for a paid PHP job? Want to post your resume? Let the job hunt begin...

Moderator: General Moderators

Post Reply
crimmelcp
Forum Newbie
Posts: 16
Joined: Mon Jan 28, 2008 8:48 pm

Need help on PHP script

Post by crimmelcp »

I need someone who can show me how to write a PHP script to do the following.
My users will not have access to the phpmyadmin panel.
I have a Vendors table.
It has the following fields

IDVendor
Vendor_Number
Vendor_Name
Address1
Address2
Vendor_City
Vendor_State
Vendor_Zip
Vendor_Country
Vendor_Phone
Vendor_Fax
Vendor_Contact
Vendor_Email

I want to put a button or a link on a form to import new vendor information.
(users with admin rights only would see this form)
The user would click the button.
The PHP script would check to see if a file exists called vendupld.csv(or txt or what ever is the correct file type)
If no file, a message would show that there is no file to import.
If there is a file called vendupld.csv, then the script would read the records in the csv file
And append(import) this data (unique vendor_Numbers only) to the Vendor table.

Can someone do this or know someone who can.
Estimate of cost to write the script.
Then I can use the script as a learning tool to try other imports.

Charlie Crimmel
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Need help on PHP script

Post by califdon »

You're sending somewhat mixed signals there. Are you going to use a MySQL database to store the data (you mentioned phpmyadmin)? If so, there will be no .csv files, nor any other files that you would be checking for, it would all be part of the database. Your description sounds like you just want a simple web data entry script for use with a MySQL database. If that's the case, you might benefit from: http://www.roscripts.com/PHP_MySQL_by_examples-193.html and http://php.about.com/od/learnphp/ss/php_forms.htm
crimmelcp
Forum Newbie
Posts: 16
Joined: Mon Jan 28, 2008 8:48 pm

Re: Need help on PHP script

Post by crimmelcp »

This is what my goal is.
Each evening I would get a download from an Unix Accounting system for any new vendors, new job numbers and new costcodes.
I do not want the users to have to input these manually.
I have a my SQL database called PO.
It has several tables. (ex:Vendor,Jobmaster,Costcode...and others)
I want to have a button or a link on a form so when the use clicks it
the script can check to see if there is a updated vendor file on the server.
If it is there then import(append) unique records to the SQL table.

I am using MYSQL, PHP

Thanks
Charlie Crimmel
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Need help on PHP script

Post by John Cartwright »

Is this a job posting?
Post Reply