Help my php calendar

marko11

Hi all,

I'm sorry my bad english. I have a problem with my calendar. How I can mark in a date cell half day booked? Which is better image from mysql or do in php code. Have anybody there any example or could you show me how to do? I can get full day mark in my calendar, that is all right, but how I can get half day booked? Now I get full day booked, why my code mark red also empty cells? Here is the code there is not all:

calendar.php

<?php
setlocale(LC_TIME, "fin");

$dbuser="root";
$dbpass="";
$host="localhost";

$yhteys=mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
if (!$yhteys)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("lincal", $yhteys);
//$action
$tapahtumat = mysql_query("SELECT * FROM tapahtuma" , $yhteys) or die("Kysely ei onnistunut:". mysql_error());
// loop every happens throught and save into array
//happenslist
$tapahtumalista = array();
while ($row = mysql_fetch_array($tapahtumat)) {
    $alku = strtotime($row['alko1']);
    $loppu = strtotime($row['loppu1']);
    $tapahtumalista[] = array($alku, $loppu);

}

$month = date('n');
$year = date('Y');
$day = date('j');

echo '<table width="90%" border="0px #009 solid; cellspacing="10" cellpadding="0" style="text-align: center">';
echo "<tr>";
echo "<th></th>";
for ($i=1;$i<=5;$i++)
          /*these are weekdays*/
   echo '<th style="width: 25px;">Ma</th><th style="width: 25px;">Ti</th><th>Ke</th><th style="width: 25px;">To</th><th>Pe</th><th>La</th><th style="width: 30px;">Su</th>';
echo '<th>Ma</th><th>Ti</th>';
//echo "</tr>";
echo '<tr>';

for ($i=0; $i<12; $i++) {

//timestamp
$aikaleima = mktime(0,0,0,$month+$i,1,$year);
$dayofweek = date('w', $aikaleima);
$amountofdays = date('t', $aikaleima);


//$empties
$tyhjia = $dayofweek-1;


echo '<td style=\"width: 20px; text-align: center;\"">'.strftime("%B %Y", $aikaleima).'</td>';   


                      //$empties
if ($dayofweek == 0) $tyhjia = 6;
$tyhjia--;
for ($j=-1*$tyhjia; $j<=$amountofdays; $j++) {
//this day
$tamaPV = mktime(0,0,0,$kk+$i,$j,$vuosi);

    if($j == date('j') && $i == 0) {
      echo '<td bgcolor= "yellow" span style="color: red;">';

    } else {
      $tapahtumat = false;
                  //list
      foreach ($tapahtumalista as $tl) {
          if ($tl[0] <= $tamaPV && $tl[1] >= $tamaPV) $tapahtumat = true; 
         } 
      if($tapahtumat == true) echo '<td bgcolor="red">';

      else echo '<td bgcolor="#91CD92">';
      }

    if ($j>0 && ($i>0 || $j>=date('j'))) echo $j;
    else echo '&nbsp';                
     echo '</td>';      

}       
    echo '</tr>';

}
echo '</table>';
mysql_close($yhteys);
?>

insert.php

<?php
$dbuser="root";
$dbpass="";
$host="localhost";

$yhteys=mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
if (!$yhteys)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("lincal", $yhteys);

if (isset($_POST['submit'])) {
$tunnus = $_POST["tunnus"];
$alko1 = $_POST["alko1"]; 
$loppu1 = $_POST["loppu1"];


$paiva = explode('.', $alko1);
$dd = $paiva[0];
$mm = $paiva[1];
$yyyy = $paiva[2];

$alko1 = $yyyy.'-'.$mm.'-'.$dd;

$paiva = explode('.', $loppu1);
$dd = $paiva[0];
$mm = $paiva[1];
$yyyy = $paiva[2];

$loppu1 = $yyyy.'-'.$mm.'-'.$dd;

$insert = "INSERT INTO tapahtuma (tunnus, alko1, loppu1) VALUES ('$tunnus', '$alko1', '$loppu1')";
if (!mysql_query($insert,$yhteys))
  {
  die('Error: ' . mysql_error());
  }

}
mysql_close($yhteys);

?>

Thank's for advance. Help me 🙂

marko11

Hi,

Is this real, nobody can help me???? Where is all php guru's? Please help me!!!! 🙂

-Make

sneakyimp

I'm not really sure what you are asking. If you need to break up a day, you will probably need to break each day's table cell into halves. Rather than nesting another table in each <TD>, I would think about using a <div> tag.

marko11

Hi sneakyimp,

I have a two question, first, how I can add image to my date cell. I want add half day image when day start and half day when day end. I can add occupied day as you can see in my code in red and avail is green.
Second question is, when I add occupied days into my calendar and occupied days are end of the month, 30, 31. My code calculates empty cells in the beginnig, when I add into database new occupied days and end of the month it also mark empty cells too in red. I want mark just days not empty cells. Why my code do like that? Do you have any ideas or example how can I add half day image into my calendar?

-Marko

sneakyimp

You can add an image to your date cell with an <IMG> tag.

As to why your code is doing something, I'm not really sure what the problem is. Perhaps you could describe it differently? I can't really tell what's going on with your code because you've chosen variable names I don't understand and you're using numeric indices in your query results rather than useful associative keys.

marko11

Hi All,

I put my code here again in english, it may so easier to understand what I mean. I also put adress where you can go and see my problem what I ask before. Code:

kalenteri6.php

<?php
setlocale(LC_TIME, "fin");

$dbuser="root";
$dbpass="";
$host="localhost";

$conn=mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("lincal", $conn);

$today = date('Y-n-j');

$action = mysql_query("SELECT * FROM actions WHERE start1>='$today'", $conn) or die("Query did not succeed:". mysql_error());
$actionlist = array();
while ($row = mysql_fetch_array($action)) {
$start = strtotime($row['start1']);
$end = strtotime($row['end1']);
$actionlist[] = array($start, $end);
}

$month = date('n');
$year = date('Y');
$day = date('j');

echo '<table width="90%" border="0px #009 solid; cellspacing="10" cellpadding="0" style="text-align: center">';
echo "<tr>";
echo "<th></th>";
for ($i=1;$i<=5;$i++)
/these are weekdays/
echo '<th style="width: 25px;">Ma</th><th style="width: 25px;">Ti</th><th>Ke</th><th style="width: 25px;">To</th><th>Pe</th><th>La</th><th style="width: 30px;">Su</th>';
echo '<th>Ma</th><th>Ti</th>';

echo '<tr>';

for ($i=0; $i<12; $i++) {

$timestamp = mktime(0,0,0,$month+$i,$j,$year);
$dayofweek = date('w', $timestamp);
$amountofdays = date('t', $timestamp);

$empties = $dayofweek-1;

echo '<td style=\"width: 20px; text-align: center;\">'.strftime("%B %Y", $timestamp).'</td>';

if($dayofweek == 0) $empties = 6;
$empties--;
for ($j=-1*$empties; $j<=$amountofdays; $j++) {
$thisDay = mktime(0,0,0,$month+$i,$j,$year);

if ($j == date('j') && $i == 0) {
    echo '<td bgcolor = "yellow" span style="color: red;">';
}else{
    $action = false;

    foreach ($actionlist as $tl) {
      if ($tl[0] <= $thisDay && $tl[1] >= $thisDay) $action = true;        
    }
    if ($action == true) echo '<td bgcolor="red">';
    else echo '<td bgcolor="#91CD92">';

    if ($action == $start){
                            echo '<img style="width: 5px; height: 5px;" alt="start" src="start.gif"'.$row['start1'].' />';


                        } else { ($action == $end);
			echo '<img style="width: 5px; height: 5px;" alt="end" src="end.gif"'.$row['end1'].' />';

                        }
}

if ($j>0 && ($i>0 || $j>=date('j'))) echo $j;
else echo '&nbsp';
echo '</td>';

}
echo '</tr>';
}
echo '</table>';
mysql_close($conn);
?>

insert.php

<?php
$dbuser="root";
$dbpass="";
$host="localhost";

$conn=mysql_connect($host, $dbuser, $dbpass) or die(mysql_error());
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("lincal", $conn);

if (isset($POST['submit'])) {
$id = $POST["id"];
$start1 = $POST["start1"];
$end1 = $POST["end1"];

$day = explode('.', $start1);
$dd = $day[0];
$mm = $day[1];
$yyyy = $day[2];

$start1 = $yyyy.'-'.$mm.'-'.$dd;

$day = explode('.', $end1);
$dd = $day[0];
$mm = $day[1];
$yyyy = $day[2];

$end1 = $yyyy.'-'.$mm.'-'.$dd;

$insert = "INSERT INTO actions (id, start1, end1) VALUES ('$id', '$start1', '$end1')";
if (!mysql_query($insert,$conn))
{
die('Error: ' . mysql_error());
}
header("Location: kalenteri6.php");
}
mysql_close($conn);

In here you see the calendar: http://www.laaksontt.net/kalenteri6.php

Is there someone who can help with my calendar, please? I need help very badly 🙁

-Marko

sneakyimp

Posting unformatted code is probably not the best way to get your problem answered. If you want to put other tags in your code, you need to understand what it's doing. I'm not even sure what problem you're having so I can't just edit your code.