Tagged: serialized data search table DB
- This topic has 2 replies, 2 voices, and was last updated 8 years, 5 months ago by
cosmocanuck.
-
AuthorPosts
-
-
September 8, 2013 at 12:27 am #1062
cosmocanuckMemberHi! I made a first attempt to customize the backend of my client’s site using another approach I discovered, the “WPAlchemy PHP Class”. I’d set up my metabox and all of the required fields, checkboxes and dropdowns and was feeling pretty good… when I learned that search plugins would not work with my data!
Why? Because the way the custom fields were being written to the DB were as “serialized” data, i.e. all my custom keys/values were written into just two WP DB fields. (Specifically, in the wp_postmeta table, in “_custom_meta” and “_custom_checkbox_meta”.) And although it’s doable, WP apparently isn’t really optimized to work with or search this kind of data.
I’ve since discovered Piklist, and I’m hoping it will allow the use of a “more powerful WP search” plugin like Relevanssi.
I’m not a newbie (wrangling a little PHP and JavaScript doesn’t deter me) but am still very much on the coder learning curve (heck, I just learned what serialized data was two days ago!), so I’m hopeful that Piklist will allow me to do what I need… but before I start wrapping my head around it too deeply, I wanted to check on this point as it’s pretty important if the site is going to function as my client (and I) would like it to.
Piklist looks pretty awesome and I’m really excited to add it to my arsenal… so looking forward to your reply. Thanks!
Adam
-
September 8, 2013 at 6:56 pm #1064
SteveKeymaster@cosmocanuck– We like advanced search as well! The only fields that get seralized are Select, Checkbox and Group fields. The quickiest way to check this out is to install Piklist and activate the built-in Demo. Enter some data and Save… then check out the DB. You should be happy.
-
September 8, 2013 at 11:56 pm #1065
cosmocanuckMemberThanks Steve! I’ll check it out. Unfortunately many if not most of the options I want are “yes or no” selections which I’m implementing with a single checkbox each. Worried that none of these could be searched on… but as you say, I’ll give it a try and see how it goes. Fingers crossed!
-
-
AuthorPosts
- You must be logged in to reply to this topic.