[PHP] Has anyone this script ??
Dear All I have been trying for ages to write a PHP calendar with a mySQL backend but cannot seem to get it working correctly. I have visited many sites and downloaded various free scripts but they all seem to do more than I need although they are all excellent. What I want to be able to do is enter a start_date and end_date from a form with a event. Once this is in the databse then the calender can be viewed and all those days that have an event, the days cell is coloured, say red. If there are no events for that day then it stays white. There is no need to see the event in the general user calendar. This way they can see which days are booked and which days are not. Has anyone such a script that I could use or at lesat get an idea how to do it. I have alreday tried all the script archives and tutorials. Any advice would be appreciated. Thanks Ray
Re: [PHP] Display cell if dates are between 2 dates - help
Dear Jason The startdate and endate columns are "date" format - have any ideas what i can do Thanks for yout help Ray - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 17, 2002 6:22 AM Subject: Re: [PHP] Display cell if dates are between 2 dates - help > On Sunday 17 November 2002 04:10, Ray Healy \(Data Net Services\) wrote: > > Dear all > > > > I'm trying to create a search function that can check the current day in a > > calendar against a mysql database where there is a startdate and enddate > > and if the date is there then colour code the cell in the calendar. > > > > I have tried to use the following command > > > > $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' > > BETWEEN startdate AND enddate;"; > > > > The database has an ID - title - startdate - enddate > > What types are the columns 'startdate' and 'enddate'? > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > You're ugly and your mother dresses you funny. > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Display cell if dates are between 2 dates - help
Dear all I'm trying to create a search function that can check the current day in a calendar against a mysql database where there is a startdate and enddate and if the date is there then colour code the cell in the calendar. I have tried to use the following command $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN startdate AND enddate;"; The database has an ID - title - startdate - enddate This seems to work BUT if the date in the database is a single number i.e. 0 to 9 it cannot dispaly it and also if the startdate or endate is a 10, 20 or 30 it also thinks that it is a 1, 2or 3 Just in case it helps the full codede for this section is as follows : /snip $sql_currentday = "$year-$month-$zz"; $eventQuery = "SELECT title FROM prestigecal WHERE '$sql_currentday' BETWEEN startdate AND enddate;"; $eventExec = mysql_query($eventQuery); while($row = mysql_fetch_array($eventExec)) { if (strlen($row["title"]) > 0) { echo "$zz\n"; $result_found = 1; /snip Thanks for any advice. Ray
[PHP] Calendar script - help
Dear All I spent days and days on this little project but still cannot get it to work (new to PHP as you might guess). I have a script which is a combination of tutorial scripts and free code to display a calendar with colour coded cells for the events on each day. The only way to enter events is to enter them one at a time. What I want to do is to be able to enter either a start date and end date or start date and the number of days. This will then enter a new line in the mySQL database for each day. There would only ever be one vent per day. I have the following fields at present in the database and would probably need another field (say number of days) id int (auto_increment) - eventdate date ('-00-00') - title (varchar) - event (blob) Can anyone help me as I have searched them web and mail lists to no avail. Everything that is available is excellent but does too much for what I need. Summary:- a calendar that can colour code the background cells if there is an event title in the mySQL database and to be able to enter the event for multiple days. Any help would be very much appreciated. Thanks for your time Ray
[PHP] PHP/mySQL help or advice
Hi All I have been trying to write a database and scripts for a calendar that shows which days are booked and have failed at each point. What i would like it to do is to show a calendar which have the dates that are booked in a cell which are colour coded (say red) when it is unavailable and say white when available. The admiministartor should be able to enter multiple dates at a time (say a holiday is booked for 5 days). perhaps a section for nortes that is only available for admin use only would be handy. An option to view 2 months at a time or perhaps the whole year would also be nice. I have downloaded various scripts and tried to write my own but I cannot seem to be able to enter multiple dates or colour code the output. Can anyone help me or perhaps someone already has a script & database that does this and would be willing to share. Otherwise it there a script already out there that will do this - all the one that I can find seem to do too much by allowing multiple users and storing a lot more data which is something I do nort need. Any help would be appreciated as I am tearing my hair out at the moment. Thanks for your time Ray Healy
[PHP] Enhancement of script
Dear All The calendar will be used to see when something is booked and you can assign messages to it as well which the general user cannot see. In this respects I have created 2 pages - welcome .php for the general viewer and admin_welcome for the updating of the calendar. What I would like to do is to be able to enter multiple dates in at the same time - either saying from a start date for so many days or from a start date to an end date. After spending hours looking at the code and in this forum I cannot seem to get it right - basically I cannot do it. I was wondering if someone could have a look and tell me where I am going wrong. (scripts at bottom of page) ng at www.matrix-hosting.co.uk/prestige/welcome.php for the general view and www.matrix-hosting.co.uk/prestige/admin_welcome.php for the admin side. Any help would be appreciated Ray P.S. if any one also knows how to get it to display a 2 or 3 months at a time or even a year this would also be a bonus as I have tried to do this as well. The Scipts: mySQL Database File CREATE TABLE tablename ( id int(11) DEFAULT '0' NOT NULL auto_increment, username varchar(255), stamp datetime, subject varchar(255), description blob, PRIMARY KEY (id) ); welcome.php (this is what the end user sees) "; echo date('F', mktime(0,0,0,$month,1,$year)); echo " $year"; $firstday = date( 'w', mktime(0,0,0,$month,1,$year)); while (checkdate($month,$lastday,$year)) { $lastday++; } $nextmonth = $month+1; $nextyear = $year; if ($nextmonth == 13) { $nextmonth = 1; $nextyear = $year + 1; } $lastmonth = $month-1; $lastyear = $year; if ($lastmonth == 0) { $lastmonth = 12; $lastyear = $year-1; } echo ""; echo " "; echo " "; echo ""; echo "SunMon TueWed ThuFri Sat"; for ($i=0; $i<7; $i++) { if ($i < $firstday) { echo ""; } else { $thisday = ($i+1)-$firstday; if ($currentyear > $year) { echo ""; } else if ($currentmonth > $month && $currentyear == $year) { echo ""; } else if ($currentmonth == $month && $currentday > $thisday && $currentyear == $year) { echo ""; } else { echo ""; } echo "$thisday "; $query2 = mysql_query("SELECT subject FROM $mysql_tablename WHERE stamp >= \"$year-$month-$thisday 00:00:00\" and stamp <= \"$year-$month-$thisday 23:59:59\" ORDER BY stamp"); for ($j = 0; $j$results[subject]"; } } if (mysql_num_rows($query2) < 4) { for ($j=0; $j<(4-mysql_num_rows($query2)); $j++) echo ""; } echo ""; } } echo "\n"; $nextday = ($i+1)-$firstday; for ($j = 0; $j<5; $j++) { echo ""; for ($k = 0; $k<7; $k++) { if ($nextday < $lastday) { if ($currentyear > $year) { echo ""; } else if ($currentmonth > $month && $currentyear == $year) { echo ""; } else if ($currentmonth == $month && $currentday > $nextday && $currentyear == $year) { echo ""; } else { echo ""; } echo "$nextday "; $query3 = mysql_query("SELECT subject FROM $mysql_tablename WHERE stamp >= \"$year-$month-$nextday 00:00:00\" AND stamp <= \"$year-$month-$nextday 23:59:59\" ORDER BY stamp"); for ($i = 0; $i$results2[subject]"; } else if ($i < 4) { echo ""; } } echo ""; $nextday++; } } echo "\n"; } echo ""; ?> admin_welcome.php (this is what the admin uses) "; echo date('F', mktime(0,0,0,$month,1,$year)); echo " $year"; $firstday = date( 'w', mktime(0,0,0,$month,1,$year)); while (checkdate($month,$lastday,$year)) { $lastday++; } $nextmonth = $month+1; $nextyear = $year; if ($nextmonth == 13) { $nextmonth = 1; $nextyear = $year + 1; } $lastmonth = $month-1; $lastyear = $year; if ($lastmonth == 0) { $lastmonth = 12; $lastyear = $year-1; } echo ""; echo " "; echo " "; echo ""; echo "SunMon TueWed ThuFri Sat"; for ($i=0; $i<7; $i++) { if ($i < $firstday) { echo ""; } else { $thisday = ($i+1)-$firstday; if ($currentyear > $year) { echo ""; } else if ($currentmonth > $month && $currentyear == $year) { echo ""; } else if ($currentmonth == $month && $currentday > $thisday && $currentyear == $year) { echo ""; } else { echo ""; } echo "$thisday "; $query2 = mysql_query("SELECT subject FROM $mysql_tablename WHERE stamp >= \"$year-$month-$thisday 00:00:00\" and stamp <= \"$year-$month-$thisday 23:59:59\" ORDER BY stamp"); for ($j = 0; $j$results[subject]"; } } if (mysql_num_rows($query2) < 4) { for ($j=0; $j<(4-mysql_num_rows($query2)); $j++) echo ""; } echo ""; } } echo "\n"; $nextday = ($i+1)-$firstday; for ($j = 0; $j<5; $j++) { echo ""; for ($k = 0; $k<7; $k++) { if ($nextday < $lastday) { if ($currentyear > $year) { echo ""; } else if ($currentmonth > $month && $currentyear == $year) { echo ""; } else if ($currentmonth == $month && $currentday > $nextday && $currentyear == $year) { echo ""; } else { echo ""; } echo "$nextday "; $query3 = mysql_query("SELECT subject FROM $mysql_tablename WHERE stamp >= \"$year-$month-$nextday 00:00:00\" AND stamp <= \"$year-$month-$nextday 23:59:59\" ORDER BY stamp"); for ($i = 0; $i$results2[subject]"; } else if ($i < 4) { echo ""; } } echo ""; $nextday++; } } echo "\n"; } echo ""; echo ""; echo " "; ?> operate.php (this is the page to add / delete etc) You can't de
[PHP] Enhancement of script
Dear All I have recently downloaded a calendar from CST (which is no longer supported ) and I have made a few changes to the script. The calendar will be used to see when something is booked and you can assign messages to it as well which the general user cannot see. In this respects I have created 2 pages - welcome .php for the general viewer and admin_welcome for the updating of the calendar. What I would like to do is to be able to enter multiple dates in at the same time - either saying from a start date for so many days or from a start date to an end date. After spending hours looking at the code and in this forum I cannot seem to get it right - basically I cannot do it. I was wondering if someone could have a look and tell me where I am going wrong. I have attached the files to this email along with the mySQL table file in case another column needs to be added. You can see the script running at www.matrix-hosting.co.uk/prestige/welcome.php for the general view and www.matrix-hosting.co.uk/prestige/admin_welcome.php for the admin side. Any help would be appreciated Ray P.S. if any one also knows how to get it to display a 2 or 3 months at a time or even a year this would also be a bonus as I have tried to do this as well. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help with script - if possible
Hi All Thanks for everyones help in trying to get my script to work - I'm learning fast. But have the following problem: I am using the following select command for searching a table with regards to booked villas according to id number: $sql = "SELECT COUNT(*) as count FROM bookings WHERE '$book_start_date' BETWEEN booking_start AND booking_end OR '$book_end_date' BETWEEN booking_start AND booking_end AND villa_id = '$place'"; This counts as far as I believe an displays a "0" if available and "number of times it occurs" if unavailable. The problem I have is that still counts the number of entries regardless of the villa_id number it is given. In other words if I have a villa that is booked between 2002-04-10 and 2002-004-20 for villa_id 1 and I search using the same dates (via a FORM) but on villa_id 3 it still comes back and says that the villas is unavailable. Which of course it is wrong for villa_id 3 (it is villa_id 1 that is booked). I have tried to find a command (something like IF villa_id =3 THEN count) but to no avail that would only count if the villa_id matches as well. Can anyone help Thanks for your time. Ray -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] New to PHP/mySQL - Help on script
Thanks for everyones help yesterday but nI have come up against a problem (as I am new). I have created my document as detailed below with notes. I can see from the form that I have connected to the server, accessed the correct database, created the statment and executed it. The problem is how to display the information - as far as I can understand from yesterday if the result is 0 then the villa is available. So what I need to do is if the result = 0 display villa available and if the result is greater than 0 then display villa not available . I know that the variables are getting to the query as if I change the echo $result; to $sql; and key in 3 as the id and 2 dates in the form I get the following: SELECT COUNT(*) FROM bookings WHERE ('2002-04-04') BETWEEN booking_start AND booking_end OR ('2002-04-10')BETWEEN booking_start AND booking_end AND villa_id = ('3') So, corrcet me if I am wrong but the query is working its just i cannot see anything. I have spent hours on this today, reading books and looking at the list. I hope that once I have done one good script I can then start to understand it and create more :-) Thanks for all your help Ray Villa id number: Start date: End date: -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php