Need help on PHP script
Posted: Mon Jan 28, 2008 8:55 pm
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
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