Solved

Search form/filter for a database

Posted on 2013-11-12
6
339 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
Comment Utility
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
Comment Utility
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
Comment Utility
great, good luck!
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:Daniele Brunengo
Comment Utility
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
Comment Utility
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
Comment Utility
Great, thanks.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Creating and Managing Databases with phpMyAdmin in cPanel.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

772 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