hello guys i have an excel sheet like this item name, made in, designed in, code, price, usage, picture, related items... all of them are in one row of this excel sheet now my request is what to use exactly in php mysql to make like this: simple search field for item name, once clicked, gives me details of that row in a page i know its simple, but i am not able to find the easiest way to do this, i am good in wordpress and its plugins, but i really look for simpler solution if you can help in this i would really appreciate it guys thanks in advanced, Mike
First convert your excel sheet into a CSV and save using the standard settings Create a table in your mysql database that equates to your csv file. Than import your csv file. If you have done this you can use http://www.tizag.com/mysqlTutorial/ to find out how to go about retrieving your data.
I assume you mean you have a search box where if you start typing a field name , it shows up and when you click the button , that field is displayed below ? You need not use MySQL. For the client side , use : http://harvesthq.github.io/chosen/ Make a JS to ajax request the field to a PHP script on your server. Use PHPExcel (http://phpexcel.codeplex.com/) on the server side php script. It's an excellent Excel parsing library and you can come into some sort of preagreement (like ID) for the excel fields which the JS sends for PHP to identify what field to fetch , and display the field data from PHP on the page via Ajax Response. That's just an idea from my side assuming you can write the code for it.