[RESOLVED] Calendar with events

[Rodrigo_Z]

Hello.

I recently created a script that create a calendar, a simple script:

$dia = date("d");
$mes = isset($_GET["mes"]) ? intval($_GET["mes"]) : date("m");
$ano = isset($_GET["ano"]) ? intval($_GET["ano"]) : date("Y");


//Select com os messes do ano
for($i = 1; $i <= 12; $i++){

$nome_mes = ucfirst(strftime("%B", mktime(0, 0, 0, $i, 1, 2006)));

if($i == $mes)
{
    echo "\t<option value=\"?mes=$i&ano=$ano\" selected=\"selected\">$nome_mes</option>\n";
}
else
{
    echo "\t<option value=\"?mes=$i&ano=$ano\">$nome_mes</option>\n";
}    
}    

?>
</select><br />
<fieldset>
<div id="top">
<?php

//Pega o total de dias 31 ou 30 ou 28
$total_dias = date("t", mktime(0, 0, 0, $mes, 1, $ano));
for($i = 1; $i <= 7; $i++) {
    echo "<span>".ucfirst(strftime("%a", mktime(0, 0, 0, 5, $i, 2006)))."</span>\n";
}    

?>
</div>
<?php

$k = 1;
for ($i = 1; $i <= 6; $i++) {
    echo "<div>";
   for ($j = 0; $j < 7; $j++) {
        $dias = date("w", mktime(0, 0, 0, $mes, $k, $ano));
        if($dias == $j and $k <= $total_dias) {
				if($k == $dia) {
            	    echo "<span class=\"destaque\">". sprintf("%02d", $k)."</span> ";
            	} else {    

                	echo "<span class=\"linhas\">". sprintf("%02d", $k)."</span> ";
            	}    

           	 $k++;
        		} else {
            echo "<span class=\"linhas\">".str_repeat("&nbsp;", 4)."</span> ";
        }
    }
    echo "</div>\n";    

}

?>
</fieldset>
</form>

I would like to know, how can i set in bold the dates that i have at my database?

I created a system that register vacation days, and it register at the database, then i would like that each vacation day should be in bold at the calendar.

Can anyone helpme??

Thanks and sorry about my english!

[stolzyboy]

it's pretty simple, easiest way probably for you to understand would be to do a query each time a "day" is made

something like "select whatever from table where day = $dayvariable" and month = $monthvariable and year = $yearvariable

of course if this was a date field in the db, u could just check that way, differnet sql statement, similar result

then if there is a result (can be counted by mysql_num_rows()), if there is a result, just bold the number with typical bold tags

u could also check for results before the calendar is drawn, get the days, put them into an array, then check in the array for results, just another approach with the same results

stolzyboy

[Rodrigo_Z]

Sorry, but i didn't understand.

Thanks!

[stolzyboy]

you know how to do a query in sql??

each iteration thru each day would be like

select * from table where date = '11/01/2006'

next would be

select * from table where date = '11/02/2006'

and so on...

do that in each repeating <div> or however you have the dates setup

[Rodrigo_Z]

Yes, i know how to do a sql query, but i don't know how to display the saved dates at the database in the calendar with bold.

See this image:

The 22 day is today, so it's bold, but if i have the 20 day at the database as an event, i would like that the 20 day appears at bold too.

Thanks!

[stolzyboy]

just do something like this

$query = mysql_query("select whatever where date = 'whatever date is'");
$count = mysql_num_rows($query) or die(mysql_error());

if ($count > 0)
{
echo "<span class=\"destaque\"><b>". sprintf("%02d", $k)."</b></span> ";
}
else
{
echo "<span class=\"destaque\">". sprintf("%02d", $k)."</span> ";
}

[Rodrigo_Z]

Humm, but i have the date saved as unix_timestamp in the database.

Let's recapitulate:

<form name="form1" method="post" action="">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<?php
setlocale(LC_TIME, "portuguese");
$sql_query_data = mysql_query("SELECT idferiados, nome, data_feriado FROM feriados", $connection)or die("Morreu a seleção");
$row=mysql_fetch_array($sql_query_data);
$dia_feriado = date("d", $row['data_feriado']);
$mes_feriado = date("m", $row['data_feriado']);
$ano_feriado = date("Y", $row['data_feriado']);
$dia = date("d");
$mes = isset($_GET["mes"]) ? intval($_GET["mes"]) : date("m");
$ano = isset($_GET["ano"]) ? intval($_GET["ano"]) : date("Y");


//Select com os messes do ano
for($i = 1; $i <= 12; $i++){

$nome_mes = ucfirst(strftime("%B", mktime(0, 0, 0, $i, 1, 2006)));

if($i == $mes)
{
    echo "\t<option value=\"?mes=$i&ano=$ano\" selected=\"selected\">$nome_mes</option>\n";
}
else
{
    echo "\t<option value=\"?mes=$i&ano=$ano\">$nome_mes</option>\n";
}    
}    

?>
</select><br />
<fieldset>
<div id="top">
<?php

//Pega o total de dias 31 ou 30 ou 28
$total_dias = date("t", mktime(0, 0, 0, $mes, 1, $ano));
for($i = 1; $i <= 7; $i++) {
    echo "<span>".ucfirst(strftime("%a", mktime(0, 0, 0, 5, $i, 2006)))."</span>\n";
}    

?>
</div>
<?php

$k = 1;
for ($i = 1; $i <= 6; $i++) {
    echo "<div>";
   for ($j = 0; $j < 7; $j++) {
        $dias = date("w", mktime(0, 0, 0, $mes, $k, $ano));
        if($dias == $j and $k <= $total_dias) {


/// HERE I WILL ADD YOUR IDEA???

$query = mysql_query("select * from feriados where day = 'whatever date is'");
				$count = mysql_num_rows($query) or die(mysql_error());

			if ($count > 0)
				{
				echo "<span class=\"destaque\"><b>". sprintf("%02d", $k)."</b></span> ";
				}
				else
				{
		echo "<span class=\"destaque\">". sprintf("%02d", $k)."</span> ";
				}  


       		 $k++;
    		} else {
        echo "<span class=\"linhas\">".str_repeat("&nbsp;", 4)."</span> ";
    }
}
echo "</div>\n";    
}

?>
</fieldset>
</form>

Thanks!

[stolzyboy]

timestamp is fine, just run date functions on it and compare it to the date you are getting above

[Rodrigo_Z]

Well, i will try here something, but i didn't undesrtand, how can i select more than one date at the database.

Because this calendar is simple, i have the calendar, and at bold there are vacantions that i seted at the database.

In this script i used for, and i have no idea how to select more than one day from the database.

Thanks!

[stolzyboy]

you are obviously looping through to display each day one "cell" at a time, in each "cell", do a query to see if that DATE is in your database as a record for an "event", if it is in there, simply bold the date

[Rodrigo_Z]

Ok, it worked, but now, it just bold one of the dates, all the oder dates nothing happen.

The new script:

<form name="form1" method="post" action="">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<?php
setlocale(LC_TIME, "portuguese");
$dia = date("d");
$mes = isset($_GET["mes"]) ? intval($_GET["mes"]) : date("m");
$ano = isset($_GET["ano"]) ? intval($_GET["ano"]) : date("Y");


//Select com os messes do ano
for($i = 1; $i <= 12; $i++){

$nome_mes = ucfirst(strftime("%B", mktime(0, 0, 0, $i, 1, 2006)));

if($i == $mes)
{
    echo "\t<option value=\"?mes=$i&ano=$ano\" selected=\"selected\">$nome_mes</option>\n";
}
else
{
    echo "\t<option value=\"?mes=$i&ano=$ano\">$nome_mes</option>\n";
}    
}    

?>
</select><br />
<fieldset>
<div id="top">
<?php

//Pega o total de dias 31 ou 30 ou 28
$total_dias = date("t", mktime(0, 0, 0, $mes, 1, $ano));
for($i = 1; $i <= 7; $i++) {
    echo "<span>".ucfirst(strftime("%a", mktime(0, 0, 0, 5, $i, 2006)))."</span>\n";
}    

?>
</div>
<?php

$k = 1;
for ($i = 1; $i <= 6; $i++) {
    echo "<div>";
   for ($j = 0; $j < 7; $j++) {
        $dias = date("w", mktime(0, 0, 0, $mes, $k, $ano));
        if($dias == $j and $k <= $total_dias) {
			$sql_buscar = mysql_query("SELECT * FROM feriados", $connection)or die("Morreu");
			$buscar = mysql_fetch_array($sql_buscar);
			$data = date("d", $buscar['data_feriado']);


	if($k == $data) {
			echo "<span class=\"destaque\"><b>". sprintf("%02d", $k)."</b></span> ";
			}
			else
				{
				echo "<span class=\"linhas\">". sprintf("%02d", $k)."</span> ";
				}  
       	 $k++;
    		} else {
        echo "<span class=\"linhas\">".str_repeat("&nbsp;", 4)."</span> ";
    }
}
echo "</div>\n";    
}

?>
</fieldset>
</form>

Thanks!

[Rodrigo_Z]

Ok, now it's working, but how can i do the loop to call more than one result from database?

Thanks!

[stolzyboy]

you ARE looping already when you are creating your calendar days...

if you have a query in there, it'll fire each time thru the loop

[Rodrigo_Z]

Yes, but It need to show different days each loop and it's showing the same every time.

Thanks!

[Rodrigo_Z]

Ok, now it's working, thanks for everything, you clean up my mind and i could resolve.

<form name="form1" method="post" action="">
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<?php
setlocale(LC_TIME, "portuguese");
$dia = date("d");
$mes = isset($_GET["mes"]) ? intval($_GET["mes"]) : date("m");
$ano = isset($_GET["ano"]) ? intval($_GET["ano"]) : date("Y");


//Select com os messes do ano
for($i = 1; $i <= 12; $i++){

$nome_mes = ucfirst(strftime("%B", mktime(0, 0, 0, $i, 1, 2006)));

if($i == $mes)
{
    echo "\t<option value=\"?mes=$i&ano=$ano\" selected=\"selected\">$nome_mes</option>\n";
}
else
{
    echo "\t<option value=\"?mes=$i&ano=$ano\">$nome_mes</option>\n";
}    
}    

?>
</select><br />
<fieldset>
<div id="top">
<?php

//Pega o total de dias 31 ou 30 ou 28
$total_dias = date("t", mktime(0, 0, 0, $mes, 1, $ano));
for($i = 1; $i <= 7; $i++) {
    echo "<span>".ucfirst(strftime("%a", mktime(0, 0, 0, 5, $i, 2006)))."</span>\n";
}    

?>
</div>
<?php

/* if($count){
		while ($row=mysql_fetch_array($query)){
			$data = date("d", $row['data_feriado']);
			echo "$data\n";
		}
 }*/
$k = 1;
//Loop no sentido vertical
for ($i = 1; $i <= 6; $i++) {
    echo "<div>";

//Loop que preeche as datas na linha
for ($j = 0; $j < 7; $j++) {


	$thisdate = mktime(0, 0, 0, $mes, $k, $ano);
	$query = mysql_query("SELECT data_feriado, idferiados, nome FROM feriados WHERE data_feriado = '$thisdate'", $connection)or die("Morreu");
	$count = mysql_num_rows($query);
    $dias = date("w", mktime(0, 0, 0, $mes, $k, $ano));
		$row=mysql_fetch_array($query);
		$data = date("d", $row['data_feriado']);
		$mes_data = date("m", $row['data_feriado']);
		$ano_data = date("Y", $row['data_feriado']);

if($dias == $j and $k <= $total_dias) {
		if($k == $data && $mes == $mes_data && $ano == $ano_data) {
				echo "<span class=\"destaque\"><a href=\"#\"><b>". sprintf("%02d", $k)."</b></a></span> ";
				}
				else
					{
					echo "<span class=\"linhas\">". sprintf("%02d", $k)."</span> ";
					}  

           	 $k++;
        		} else {
            echo "<span class=\"linhas\">".str_repeat("&nbsp;", 4)."</span> ";
        }
    }
    echo "</div>\n";    

}
?>

</fieldset>
</form>