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.
11 freelancers are bidding on average $183 for this job
HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!