Hi,

i use ajax events calendar to let users store events.I use my own database table including user_id field. When i call event page i can see all events.i would like users can see only his own events.

I already create a recordset to show event by filtering on user_id session but seems it's not take by script.

What's wrong ?


Thanks for help

Hello Alvarez,

That can be done but you need to alter the calendar_get_events#.asp/php file to be filtered by the user id you have set as well as the other filtering.
If this is hard for you to do I can help you on achieving this. My e-mail is

Regards,

OK this is how to for people who needs to filter events shown by user_id.

It's suppose you have a listing page and you paste parameter in url to ajax_calendar_event page.

First you need to customize your page where ajax calendar is setup.
Find "ajax_feeds:[{url:"calendar_ajax/calendar_get_events1.php " and replace by
Example for "user_id" Url become: "calendar_ajax/calendar_get_events1.php?user_id=<?php echo $_GET['user_id']?>


Now you need to customize calendar_get_events.php
1. Before "$query_start = intval($_GET['start']);"
add your filter like this:
$query_filter = intval($_GET['user_id']);

2. Add filter in query_events:
after WHERE add "`filter` = %3$s" and at the end before last "" add ",$query_filter".
=>you must change 'filter' by your database field you want to compare parameter.

Test it, must show only user event.

Thanks to Miro

I'm trying to filter events shown by user_id.
This is the code of calendar_get_events.php, but does not work.
What's wrong ?

.......
{
$query_filter = intval($_GET['user_id']);
$query_start = intval($_GET['start']);
$query_stop = intval($_GET['stop']);
mysql_select_db($database_tvg_conn, $tvg_conn);
$query_events = sprintf("SELECT `event_title` AS title, `start` AS start, `stop` AS stop , `description` AS description, `type` AS type, `link` AS link, `user` AS user, `event_id` AS event_id FROM `eventi` WHERE `user` = %3$s AND UNIX_TIMESTAMP(`start`) <= %d AND UNIX_TIMESTAMP(`stop`) >= %d",$query_stop, $query_start, $query_filter);
$events_set = mysql_query($query_events, $tvg_conn) or die(mysql_error());
$result_array = array();
while ($row = mysql_fetch_assoc($events_set))
{
$result_array[] = $row;
}
header("Cache-Control: no-cache";
if(isset($_GET['callback']))
{
echo $_GET['callback']."(".json_encode($result_array).";";
}
.......
.......

Hello Tuteri Marco,

do you get any errors executing the Calendar page?

Regards,