importing data to a sql base trough xls, and adding an image scroll to php page
- Status Closed
- Budget N/A
- Total Bids 15
hello, i have a simple php search page under phpmyadmin and sql server, [url removed, login to view], you can check it out.
Now i need to fill the data on the database, so what i need is:
1- a way to fill all the data, i belive that an xls for every table is ok, the xls needs to have a colum for every column on the table, so what i need is a php page to make the connection to the database and fill an specific selected table (from a list of all the possible tables, 9 to the moment) , download the xls for the table, upload the xls, and then update the data of the selected table on the database with the uploaded xls.
2- on the already made product detail page, make a "scroll" for all the images of the product, for the moment only displays 1 image, we need to read the number of images to display for the product and ubication of the images a table on the database (is not like this for the moment), and show them, 1 by one with an previous, next image buttons; it is also needed to update the product table and add the image foregin key (the image and product table already exists, tough).
so what i need of you is:
first, you need to start the php myadmin services on the host to access the database.
the product table on the database needs a new key, to link various images to a product, call id_product_image
also we need a table linked to this new key, called product_image, with columns id_product (PK)-bigint, image_number (PK)-bigint, and rute(not null) varchar.
OK, now for each table we need to create a method so the system user can update the db tables using an xls, so each xls is simply for every row on the datatable, a row on the xls, for example the table website, has 4 rows: id, id_labotory, url_address and a website_pkey, so the xls need to have 4 the same colums: id, id_labotory, url_address and a website_pkey.
This method has to be accesed from the website.
After this, you need to implement an image scroller for the product tab, so you can see the product images, using the new image table added, at this moment just shows 1 image.
Hope to hear from you soon.
Antonio.-Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online