Solved

Search form/filter for a database

Posted on 2013-11-12
6
387 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 33

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 33

Expert Comment

by:Big Monty
ID: 39641739
great, good luck!
0
Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

 

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 33

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

Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

691 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