importing data to a sql base trough xls, and adding an image scroll to php page

Closed

Description

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.-

Skills: PHP, Software Architecture

See more: what software needed to create a website, php software download, one key data, data host, xls, data importing, belive, base one, implement image, tab display php, column already exists, link sql, database scroll, php search page, upload image link, image table, simple php user system, php connection phpmyadmin database, simple php image upload, add base, access linked table, update image database, php page search, access 2013 buttons, can php read access

Project ID: #4514292

11 freelancers are bidding on average $183 for this job

hits

We are a team of developers with expertise and experience in PHP, MySql. We have coded many PHP scripts to import data to database from xls files. We have also developed many product sites. Please see PMB. I have re More

$263 USD in 5 days
(843 Reviews)
8.7
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$155 USD in 3 days
(227 Reviews)
7.8
coolguyinus2004

Can be done for you. PHP/MYSQL expert here.

$216 USD in 3 days
(272 Reviews)
7.4
srinichal

I Can deliver the project and look forward to discuss further

$263 USD in 6 days
(92 Reviews)
7.0
Dunkoh

ready to start now

$210 USD in 3 days
(86 Reviews)
6.6
mauryacravings

Hello Sir, I have 8 years of extensive experience in Web Application Development. Recently, I have added mobile development expertise in my portfolio which allows me to play dynamic role as per requirement. Following More

$198 USD in 4 days
(25 Reviews)
6.2
acer2004sl

Hello, Please check PM, thank you

$155 USD in 3 days
(116 Reviews)
5.4
farhaoui

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 !!

$164 USD in 3 days
(45 Reviews)
4.8
Voyageinfo

Dear Sir, Expert for the same. Thanks Voyage Team

$309 USD in 15 days
(14 Reviews)
4.8
raziel27

ready to work

$103 USD in 2 days
(4 Reviews)
4.5
ChMeier

Buenas tardes señor, Con gusto puedo hacer el formulario que requiere para actualizar su base de datos y arreglar la consulta de imágenes. Si lo desea, para un futuro proyecto puedo mejorar su sistema proveyéndol More

$150 USD in 3 days
(4 Reviews)
3.3
d0tnet12

I have good hand with this project. I already did that kinda project. check pm

$144 USD in 3 days
(7 Reviews)
2.9
RDSCoder

Hi! Ready to Start. I sent you a private message!

$155 USD in 3 days
(0 Reviews)
0.0
ILamp

I have experience in PHP and database, let I help you in this project

$100 USD in 2 days
(0 Reviews)
0.0