login  Naam:   Wachtwoord: 
Registreer je!
 Scripts:
Scripts > PHP > Kalenders > Weekkalender

Weekkalender

Auteur: vinTage - 01 januari 2012 - 21:39 - Gekeurd door: Stijn - Hits: 6126 - Aantal punten: 5.00 (1 stem)



Een 'makkelijke' weekkalender.
De database:
mysql code - Bekijk de code zonder highlighting - Klap code in 
  1. CREATE TABLE `planning` (
  2.   `datum` VARCHAR(10) NOT NULL,
  3.   `adres` VARCHAR(250) NOT NULL,
  4.   `msg` VARCHAR(750) NOT NULL
  5. )


Het script is gewoon copy/pasten en de database gegevenns aanpassen en gaan met die banaan kalender

Code:
php code - Bekijk de code zonder highlighting - Klap code in 
  1. <?php
  2.   //onderstaande 2 regels aanpassen
  3.   mysql_connect('host', 'usernaam', 'password');
  4.   mysql_select_db('database');
  5.  
  6.   //af! :P
  7.   $jaar = isset($_GET['jaar']) ? $_GET['jaar'] : date('Y');
  8.   $week = isset($_GET['week']) ? $_GET['week'] : date('W');
  9.   if ($week < 1)
  10.   {
  11.       $jaar -= 1;
  12.       $week = date("W", mktime(0, 0, 0, 12, 28, $jaar));
  13.   }
  14.   elseif ($week > date("W", mktime(0, 0, 0, 12, 28, $jaar)))
  15.   {
  16.       $week = 1;
  17.       $jaar += 1;
  18.   }
  19.   if (isset($_POST['opslaan']))
  20.   {
  21.       $qry = mysql_query("select datum from planning where datum = '" . mysql_real_escape_string($_GET['edit']) . "'") or die(mysql_error());
  22.       if (mysql_num_rows($qry) > 0)
  23.       {
  24.           mysql_query("update planning set adres = '" . mysql_real_escape_string($_POST['adres']) . "', 
  25.                             msg = '" . mysql_real_escape_string($_POST['msg']) . "' where datum ='" . mysql_real_escape_string($_POST['datum']) . "'") or die(mysql_error());
  26.           header("location: ?jaar=" . $jaar . "&week=" . $week);
  28.       }
  29.       else
  30.       {
  31.           mysql_query("insert into planning (datum, adres, msg)
  32.                       values('" . mysql_real_escape_string($_GET['edit']) . "',
  33.                             '" . mysql_real_escape_string($_POST['adres']) . "',
  34.                             '" . mysql_real_escape_string($_POST['msg']) . "')") or die(mysql_error());
  35.           header("location: ?jaar=" . $jaar . "&week=" . $week);
  37.       }
  38.   }
  39.   //de html en css hieronder mag je editen, van de php afblijven als je niet weet waar het over gaat :p
  40. ?>
  41. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
  42. <html xmlns="http://www.w3.org/1999/xhtml">
  43. <head>
  44. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  45. <title>planning</title>
  46. <style type="text/css">
  47. *{ margin:0; padding:0;}
  48. body{font-family:Verdana, Geneva, sans-serif; font-size:small;}
  49. .border{border:solid 2px #000;}
  50. .br{border-right:solid 1px #000;}
  51. .bl{border-left:solid 1px #000;}
  52. .bb{border-bottom:solid 1px #000;}
  53. .bbd{border-bottom:solid 2px #000;}
  54. td{padding-left:2px; padding-right:2px;}
  55. .active{background-color:#f5f5f5;}
  56. #wrap{
  57.   width:1004px;
  58.   margin:0 auto;
  59.   margin-top: 10px;
  60. }
  61. a:link {
  62. 	color: #EA960B;;
  63. 	text-decoration: none;
  64. }
  65. a:visited {
  66. 	color: #EA960B;;
  67. 	text-decoration: none;
  68. }
  69. a:hover {
  70. 	text-decoration: underline;
  71. 	color: #EA960B;
  72. }
  73. a:active {
  74. 	text-decoration: underline;
  75. 	color: #EA960B;
  76. }
  77. b{color: #39f;}
  78. </style>
  79.  
  80. <style type="text/css" media="print">
  81. .noprint{display:none;}
  82. input[type=text]{display:none}
  83. b{color:#000}
  84. </style>
  85. </head>
  86.  
  87. <body>
  88.     <div id="wrap">
  89.         <div class="noprint">
  90.             Week nr: <a href="?jaar=<?php echo $jaar?>&amp;week=<?php echo $week-1?>">&laquo; </a><?php echo $week?><a href="?jaar=<?php echo $jaar?>&amp;week=<?php echo $week+1?>"> &raquo;</a>
  91.             <br />
  92.             Jaar: <a href="?jaar=<?php echo $jaar-1?>&amp;week=<?php echo $week?>">&laquo; </a><?php echo $jaar?><a href="?jaar=<?php echo $jaar+1?>&amp;week=<?php echo $week?>"> &raquo;</a>
  93. <?php
  94. if($jaar != date("Y") || $week != date("W"))
  95. {
  96. ?>
  97.             <br />
  98.             <a href="<?php echo $_SERVER['SCRIPT_NAME']?>">Terug naar huidige week</a>
  99. <?php
  100. }
  101. ?>
  102.             <br />
  103.             <br />
  104.         </div>
  105. <?php
  106.   function maak_datums($year, $weeknr, $dag, $dagnaam = false)
  107.   {
  108.       $dagen = array("maandag", "dinsdag", "woensdag", "donderdag", "vrijdag");
  109.       $w = $weeknr - 1;
  110.       return $dagnaam != false ? $dagen[$dag] . '<br />' . date("d-m-Y", strtotime("first monday  January $year + $w weeks + $dag days")) : date("d-m-Y", strtotime("first monday  January $year + $w weeks + $dag days"));
  111.   }
  112.  
  113.   if (isset($_GET['edit']))
  114.   {
  115. ?>
  116.     <form method="post" action="<?php echo htmlentities($_SERVER['REQUEST_URI'])?>">
  117. <?php
  118.   }
  119. ?>
  120.         <table width="1000" border="0" cellspacing="0" cellpadding="0" class="border">
  121.             <tr>
  122.                 <td class="br bbd" width="80" valign="top"><b>Datum</b></td>
  123.                 <td class="br bbd" width="300"><b>Wie &amp; waar</b></td>
  124.                 <td class="bbd"><b>Werkzaamheden</b></td>
  125.             </tr>
  126. <?php
  127.   for ($i = 0; $i < 5; $i++)
  128.   {
  129.       $adres = '';
  130.       $msg = '';
  131.       $link_datum = maak_datums($jaar, $week, $i);
  132.  
  133.       $q = mysql_query("select * from planning where datum = '" . $link_datum . "'") or die(mysql_error());
  134.       while ($row = mysql_fetch_array($q))
  135.       {
  136.           $adres = isset($_GET['edit']) ? $row['adres'] : nl2br(htmlentities($row['adres']));
  137.           $msg = isset($_GET['edit']) ? $row['msg'] : nl2br(htmlentities($row['msg']));
  138.       }
  139. ?>
  140.             <tr<?php if(isset($_GET['edit']) && $_GET['edit'] == $link_datum){?> class="active"<?php } ?> style="height:130px">
  141.                 <td class="br <?php if($i <4){echo 'bbd';}?>" valign="top">
  142.                 <?php echo maak_datums($jaar, $week, $i) == date("d-m-Y") ? "<b class='noprint'>vandaag<br /><br /></b>".maak_datums($jaar, $week, $i, true)."<br />" : maak_datums($jaar, $week, $i, true)."<br />";
  143.                 if(isset($_GET['week']) && isset($_GET['jaar']))
  144.                {
  145. ?>
  146.                      <a href="?jaar=<?php echo $_GET['jaar']?>&amp;week=<?php echo $_GET['week']?>&amp;edit=<?php echo $link_datum?>" class="noprint">edit</a>
  147. <?php
  148.                }
  149.                else
  150.                {
  151. ?>
  152.                     <a href="?edit=<?php echo $link_datum?>" class="noprint">edit</a>
  153. <?php
  154.                }
  155.                if(isset($_GET['edit']) && $_GET['edit'] == $link_datum)
  156. 			   {
  157. ?>
  158.                  <input name="opslaan" type="submit" value="bijwerken" /><input type="hidden" name="datum" value="<?php echo $link_datum?>" />
  159. <?php 
  160.                }
  161. ?>  
  162.                 </td>
  163.                 <td class="br <?php if($i <4){echo 'bbd';}?>" valign="top"><?php if(isset($_GET['edit']) && $_GET['edit'] == $link_datum){?><textarea name="adres" rows="4" cols="25"><?php echo stripslashes($adres);?></textarea><?php } else { echo stripslashes($adres);}?></td>
  164.                 <td class="<?php if($i <4){echo 'bbd';}?>" valign="top"><?php if(isset($_GET['edit']) && $_GET['edit'] == $link_datum){?><textarea name="msg" rows="4" cols="25"><?php echo stripslashes($msg);?></textarea><?php } else { echo stripslashes($msg);}?></td>
  165.             </tr>
  166. <?php
  167.     }
  168. ?>
  169.         </table>
  170. <?php
  171. if(isset($_GET['edit']))
  172. {
  173. ?>
  174.     </form>
  175. <?php
  176. }
  177. ?>
  178.     </div>
  179. </body>
  180. </html>
Download code! Download code (.txt)

 Bekijk een voorbeeld van dit script!
 Stemmen
Niet ingelogd.

 Reacties
Post een reactie
Lees de reacties (3)
© 2002-2024 Sitemasters.be - Regels - Laadtijd: 0.055s