In Progress

create a basic php toggle filter for a mysql statement

I have an event calendar on a wordpress site. You can see it in action here: [url removed, login to view]

I would like a checkbox toggle to be applied to the calendar so a user can hide or view items pulled from different categories. I want users to be able to select/unselect any items and then click on a link to update query and show a new calendar containing only the categories they select. Attached is a screenshot of what i am looking for visually.

my name is alex, please address me directly in your pmb so I know you actually read this message.

also note that the information stored on the events is held in two places, the default wp_posts db and a second one that holds event details. this is the sql statement that you would need to modify for the toggle

$queryPost = "select * from wp_post_events AS post_detail JOIN $wpdb->posts AS post ON post_detail.post_id=[url removed, login to view] where post.post_status='publish' AND post.post_type='post' AND event_date='".$date."' order by timestamp ASC";

i basically want you to add to that a condition 'where classifieds_category_slug= (any of the actively toggled items)'

id like this done ASAP, please do not bid if you are too busy to handle this in the near future.

Skills: MySQL, PHP, WordPress

See more: toggle filter php, php toggle calendar, php toggle filter, mysql php toggle order, calendar toggle mysql php, toggle mysql php, asc it, php toggle, timestamp, modify calendar, modify update wordpress, basic php, mysql select filter, mysql select statement, wordpress create, sql statement stored, toggle show hide, mysql update checkbox, mysql view update, create event, create add note, toggle show, sql calendar view, wordpress create calendar events, wordpress mysql query

About the Employer:
( 6 reviews ) Ithaca, United States

Project ID: #1099000

Awarded to:

richb38

Hi Alex- I can take care of this for you.

$50 USD in 2 days
(4 Reviews)
4.3

4 freelancers are bidding on average $70 for this job

AtlanticSoft

Hi Alex please check pmb for details

$100 USD in 3 days
(184 Reviews)
7.9
bsoist

Alex, I can get this done today. Please see PMB.

$85 USD in 1 day
(33 Reviews)
6.2
dracco

see your pmb Mr Alex

$50 USD in 0 days
(144 Reviews)
5.9
tinkue

Hi Please read PMB

$45 USD in 1 day
(3 Reviews)
3.7