Solved

Search form/filter for a database

Posted on 2013-11-12
6
361 Views
Last Modified: 2013-11-12
Hello, I know this is quite a generic question but I need advice on the best way to undertake a task.

I have a big Excel file with a list of known exposition and fairs all around the world. Each column contains data concerning the expo, like country, product category and so on.

I need to "transform" this into an archive for a wordpress website I'm developing and create a search form which allows you to choose zone, country, start date, end date, categories with subcategories and so on.
Then the results are listed in an order you can also choose, and if you click on an expo you get full details.

So I was wondering, which would be the best way to do this?

For instance, I can convert the Excel file into a Mysql table, then I can add the table to the wordpress database OR I can create a new database altogether. Which would be best?

Or is there a way which avoids Mysql and php?

Don't worry about my knowledge in your suggestions because what I don't know I'll try to learn (or get help about :)), but I'd like to know the fastest way to accomplish this.

Also, if you know of any software/plugin/whatever which can help me in the task, feel free to suggest it.

Thanks in advance.
0
Comment
Question by:Daniele Brunengo
  • 3
  • 3
6 Comments
 
LVL 32

Accepted Solution

by:
Big Monty earned 500 total points
ID: 39641692
You're def on the right track. One thing to ask yourself is will this application grow? If you envision that it will, then I would suggest building your own DB to keep things organized. But if you think it will only be 1-2 tables, then I don't see any reason not to keep it directly in the WP database.

From there, it's as simple as looking for some online examples on "how to build a form in php" (say, that looks like a good google search to start with!) and coming here to ask specific questions on issues you're stuck on.
0
 

Author Comment

by:Daniele Brunengo
ID: 39641722
Ok, thanks. I was actually watching some videos on those topics.

I am positive there won't be more than 1 table, it may become 2 but that's it.

So I guess I'm gonna keep it inside the WP database.

I think this would make things easier, in that I wouldn't have to access a different database while connected to the WP one.

The search form itself will probably be a little complex though, so I guess I will open a new topic about that if I encounter any problems (which I will).
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39641739
great, good luck!
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:Daniele Brunengo
ID: 39642264
One doubt, though. Can't it be "dangerous" to add a table to the WP database? I mean, for instance when upgrading to a new WP version, isn't there a risk of some damaged data?
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39642353
no. when upgrading wordpress, it only looks at its own tables, it will not touch any user created tables

http://wordpress.org/support/topic/add-tables-to-wp-database
0
 

Author Comment

by:Daniele Brunengo
ID: 39642427
Great, thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
would like the bottom of this page to be smaller 3 27
Remove lines by logo 2 29
Easy responsive table out of existing table 28 55
Question about DB Schema 27 50
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now