WordPress.org

Ready to get started?Download WordPress

Forums

Mysql Database Key_2 Multiple Select (4 posts)

  1. jaden90008
    Member
    Posted 1 year ago #

    I am trying to figure out how to add the function "Multiple Select" to this code in my database. It's a listbox dropdown menu. I'd like users to be able to choose multiple Genres either by checkbox within a listbox or have them hold down the "Ctrl" key or "Shift" key. If anyone can help with this it would be most appreciated.

    "Key_2";s:4:"show";s:1:"0";s:5:"order";s:1:"3";s:10:"fieldtitle";i:0;s:4:"type";s:4:"list";s:5:"value";s:316:"Select All That Apply:,A Cappella,Acoustic Contemporary Christian,Christmas/Caroler,Classical Singer,Contemporary,Country Gospel,Folk Singer,Gospel,Jazz/Blues-Christian,Metal/Hard Rock-Christian,Musical Theater,Opera,Pop,Praise & Worship,R&B,Rock-Christian,Singing Telegram,Southern Gospel,Urban Gospe,Wedding Singer";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:3;a:18:{s:2:"ID";i:8;s:4

  2. Barry
    Member
    Posted 1 year ago #

    Hi jaden90008 - you'd need to add a lot more detail than you've provided.

    Is this for users on the front end or the back end? The serialized data you provided is incomplete, does that mean you already know how to drill into that and extract the part you need or do you need help with that too? (In which case, you would need to post the whole thing.)

    Is the "multiple select" being dropped into an existing form and do you already have code in place to deal with it, or is help with that part of your question, too?

  3. jaden90008
    Member
    Posted 1 year ago #

    Barry thanks so much. I have no idea what I'm doing or what you need to help me.

    I created a custom field in my premiumpress theme. I need to make one of the registration fields multiple select. the field is a listbox dropdown. I tried to do it from within the style.php file and in the core files but nothing is working to make the field multiple select. another blogger suggested I try to do it from my database. Any help or advice would be most appreciated.

    This is what is in my database:

    a:29:{i:13;a:18:{s:2:"ID";i:18;s:4:"name";s:11:"At-A-Glance";s:3:"key";s:5:"Key_0";s:4:"show";s:1:"0";s:5:"order";s:1:"1";s:10:"fieldtitle";i:1;s:4:"type";s:4:"list";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:14;a:18:{s:2:"ID";i:19;s:4:"name";s:6:"Gender";s:3:"key";s:10:"Key_gender";s:4:"show";s:1:"0";s:5:"order";s:1:"2";s:10:"fieldtitle";i:0;s:4:"type";s:4:"list";s:5:"value";s:25:"Select One:, Male, Female";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:15;a:18:{s:2:"ID";i:20;s:4:"name";s:16:"Experience Level";s:3:"key";s:14:"Key_experience";s:4:"show";s:1:"0";s:5:"order";s:1:"3";s:10:"fieldtitle";i:0;s:4:"type";s:4:"list";s:5:"value";s:139:"Select One:,Full Time (Over 24 events Year),Experienced (Over 25 Events),Some Experience (10-25 Events),Just Starting (less than 10 events)";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:16;a:18:{s:2:"ID";i:21;s:4:"name";s:12:"Travel Terms";s:3:"key";s:10:"Key_travel";s:4:"show";s:1:"0";s:5:"order";s:1:"4";s:10:"fieldtitle";i:0;s:4:"type";s:4:"list";s:5:"value";s:121:"Select One:,Perfers Local Events,Travel Anywhere In U.S. With Expenses Paid,Travel Internationally With All Expenses Paid";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:17;a:18:{s:2:"ID";i:22;s:4:"name";s:15:"Fee Requirement";s:3:"key";s:19:"Key_feerequirements";s:4:"show";s:1:"0";s:5:"order";s:1:"5";s:10:"fieldtitle";i:0;s:4:"type";s:4:"list";s:5:"value";s:135:"Select Fee Requirements:,As God Leads You,Love Offering,Contact For Details,Negotiable,$500-$1000,$1000-$2500,$2500-$5000,$5000.00-plus";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:18;a:18:{s:2:"ID";i:23;s:4:"name";s:14:"Media And More";s:3:"key";s:16:"Key_mediaandmore";s:4:"show";s:1:"0";s:5:"order";s:1:"7";s:10:"fieldtitle";i:1;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:19;a:18:{s:2:"ID";i:24;s:4:"name";s:7:"youtube";s:3:"key";s:10:"Key_video1";s:4:"show";s:1:"0";s:5:"order";s:1:"8";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:24:"Member Performance Video";s:5:"desc2";s:52:"Your Performance Video(mp4, vimeo, youtube, godtube)";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:20;a:18:{s:2:"ID";i:25;s:4:"name";s:7:"youtube";s:3:"key";s:10:"Key_video2";s:4:"show";s:1:"0";s:5:"order";s:1:"9";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:24:"Member Performance Video";s:5:"desc2";s:52:"Your Performance Video(mp4, vimeo, youtube, godtube)";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:21;a:18:{s:2:"ID";i:26;s:4:"name";s:7:"youtube";s:3:"key";s:10:"Key_video3";s:4:"show";s:1:"0";s:5:"order";s:2:"10";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:24:"Member Performance Video";s:5:"desc2";s:52:"Your Performance Video(mp4, vimeo, youtube, godtube)";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:22;a:18:{s:2:"ID";i:27;s:4:"name";s:8:"Listen 1";s:3:"key";s:11:"Key_listen1";s:4:"show";s:1:"0";s:5:"order";s:2:"11";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:10:"Audio Link";s:5:"desc2";s:10:"Audio Link";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:23;a:18:{s:2:"ID";i:28;s:4:"name";s:8:"Listen 2";s:3:"key";s:11:"Key_listen5";s:4:"show";s:1:"0";s:5:"order";s:2:"12";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:10:"Audio Link";s:5:"desc2";s:10:"Audio Link";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:24;a:18:{s:2:"ID";i:29;s:4:"name";s:8:"Listen 3";s:3:"key";s:11:"Key_listen6";s:4:"show";s:1:"0";s:5:"order";s:2:"13";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:10:"Audio Link";s:5:"desc2";s:10:"Audio Link";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:25;a:18:{s:2:"ID";i:30;s:4:"name";s:9:"Product 1";s:3:"key";s:12:"Key_product1";s:4:"show";s:1:"0";s:5:"order";s:2:"14";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:17:"Member CD or Book";s:5:"desc2";s:10:"CD or Book";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:26;a:18:{s:2:"ID";i:31;s:4:"name";s:9:"Product 2";s:3:"key";s:12:"Key_product2";s:4:"show";s:1:"0";s:5:"order";s:2:"15";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:17:"Member CD or Book";s:5:"desc2";s:10:"CD or Book";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:27;a:18:{s:2:"ID";i:32;s:4:"name";s:9:"Product 3";s:3:"key";s:12:"Key_product4";s:4:"show";s:1:"0";s:5:"order";s:2:"16";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:17:"Member CD or Book";s:5:"desc2";s:10:"CD or Book";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:28;a:18:{s:2:"ID";i:33;s:4:"name";s:9:"Product 4";s:3:"key";s:12:"Key_product4";s:4:"show";s:1:"0";s:5:"order";s:2:"17";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:17:"Member CD or Book";s:5:"desc2";s:10:"CD or Book";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:29;a:18:{s:2:"ID";i:34;s:4:"name";s:12:"The Vocalist";s:3:"key";s:6:"Key_11";s:4:"show";s:1:"0";s:5:"order";s:2:"18";s:10:"fieldtitle";i:1;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:30;a:18:{s:2:"ID";i:35;s:4:"name";s:12:"Vocalist Bio";s:3:"key";s:16:"Key_vocalist_bio";s:4:"show";s:1:"0";s:5:"order";s:2:"19";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:12:"Vocalist Bio";s:5:"desc2";s:12:"Vocalist Bio";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:31;a:18:{s:2:"ID";i:36;s:4:"name";s:19:"Noteworthy Comments";s:3:"key";s:22:"Key_noteworthycomments";s:4:"show";s:1:"0";s:5:"order";s:2:"21";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:22:"Testimonials/Referrals";s:5:"desc2";s:22:"Testimonials/Referrals";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:32;a:18:{s:2:"ID";i:37;s:4:"name";s:15:"Upcoming Events";s:3:"key";s:18:"Key_upcomingevents";s:4:"show";s:1:"0";s:5:"order";s:2:"22";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:36:"Listing of your upcoming appearances";s:5:"desc2";s:36:"Listing of your upcoming appearances";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:33;a:18:{s:2:"ID";i:38;s:4:"name";s:7:"Connect";s:3:"key";s:21:"Key_connectTovocalist";s:4:"show";s:1:"0";s:5:"order";s:2:"23";s:10:"fieldtitle";i:1;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:34;a:18:{s:2:"ID";i:39;s:4:"name";s:13:"Contact Phone";s:3:"key";s:17:"Key_vocalistPhone";s:4:"show";s:1:"0";s:5:"order";s:2:"24";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"1";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:35;a:18:{s:2:"ID";i:40;s:4:"name";s:8:"Facebook";s:3:"key";s:16:"Key_facebooklink";s:4:"show";s:1:"0";s:5:"order";s:2:"24";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:36;a:18:{s:2:"ID";i:41;s:4:"name";s:20:"Noteable Appearences";s:3:"key";s:23:"Key_noteableappearences";s:4:"show";s:1:"0";s:5:"order";s:2:"25";s:10:"fieldtitle";i:0;s:4:"type";s:8:"textarea";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:33:"List Your Most Recent Appearances";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:37;a:18:{s:2:"ID";i:42;s:4:"name";s:7:"Twitter";s:3:"key";s:15:"Key_twitterlink";s:4:"show";s:1:"0";s:5:"order";s:2:"25";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:38;a:18:{s:2:"ID";i:43;s:4:"name";s:7:"Myspace";s:3:"key";s:15:"Key_myspacelink";s:4:"show";s:1:"0";s:5:"order";s:2:"26";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:39;a:18:{s:2:"ID";i:44;s:4:"name";s:8:"LinkedIn";s:3:"key";s:16:"Key_linkedinlink";s:4:"show";s:1:"0";s:5:"order";s:2:"27";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:40;a:18:{s:2:"ID";i:45;s:4:"name";s:7:"Website";s:3:"key";s:19:"Key_vocalistwebsite";s:4:"show";s:1:"0";s:5:"order";s:2:"28";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}i:41;a:18:{s:2:"ID";i:46;s:4:"name";s:4:"Blog";s:3:"key";s:12:"Key_bloglink";s:4:"show";s:1:"0";s:5:"order";s:2:"29";s:10:"fieldtitle";i:0;s:4:"type";s:4:"text";s:5:"value";s:0:"";s:5:"desc1";s:0:"";s:5:"desc2";s:0:"";s:5:"pack1";s:1:"0";s:5:"pack2";s:1:"1";s:5:"pack3";s:1:"1";s:5:"pack4";s:1:"1";s:5:"pack5";s:1:"1";s:5:"pack6";N;s:5:"pack7";N;s:5:"pack8";N;}}

  4. Barry
    Member
    Posted 1 year ago #

    Wow! OK, sometimes it's better to use a service like Pastebin for posting stuff like this.

    (I made a copy of the above code here http://pastebin.com/6npnwLSR ... and a human readable version here http://pastebin.com/22KQe68U ... just in case a moderator comes along and edits your post.)

    I'm not quite sure how much help you are asking for here. What parts of the problem are already solved (if any)? Do you already have code in place to create form elements somewhere on your site and is all you need a bit of help to enable end-users to select more than one choice ... if so can you link to the existing site?

Topic Closed

This topic has been closed to new replies.

About this Topic