Hjälp med en php och mysql kalender
Hej!
Jag har hittat ett youtube klipp på hur man gör en kalender men den funkar inte riktig som den ska.
Varför?
här är koden:
<?php
$hotname = "localhost";
$username = "";
$password = "";
$dbnamne = "";
mysql_connect($hotname,$username,$password) or die ("kan inte koppla upp mot databasen...") ;
mysql_select_db($dbnamne) or die ("kan inte koppla upp mot databasen...");
?>
<html>
<head>
<script>
function goLastMonth(month, year){
if (month == 1) {
--year;
month = 13;
}
--month
var monthstring = ""+month+"";
var monthlength = monthstring.length;
if (monthlength <= 1){
monthstring = "0"+monthstring;
}
document.location.htef = "<?php$_SERVER['PHP_SELF'];?>?month="+monthstring+"&year="+year;
}
function goNextMonth(month, year){
if (month == 12){
++year
month = 0;
}
document.location.htef = "<?php$_SERVER['PHP_SELF'];?>?month="+monthstring+"&year="+year;
++month
var monthstring = ""+month+"";
var monthlength = monthstring.length;
if (monthlength <= 1){
monthstring = "0"+monthstring;
}
}
</script>
<style>
.today {
background-color : #00ff00;
}
.event {
background-color : #0000ff;
}
</style>
</head>
<body>
<?php
if (isset($_GET['day'])){
$day = $_GET['day'];
}
else {
$day = date("j");
}
if (isset($_GET['month'])){
$month = $_GET['month'];
}
else {
$month = date("n");
}
if (isset($_GET['year'])){
$year = $_GET['year'];
}
else {
$year = date("Y");
}
$currentTimeStamp = strtotime("$year-$month-$day");
$monthName = date("F", $currentTimeStamp);
$numDays = date("t", $currentTimeStamp);
$counter = 0;
?>
<table border='1'>
<tr>
<td><input style='width:50px;' type='button'name='previousbutton' onclick='goLastMonth(<?php echo $month.",".$year?>)' value="<" ></td>
<td colspan='5'><?php echo "$monthName - $year"; ?></td>
<td><input style='width:50px;' type='button' value='>' name='nextbutton' onclick='goNextMonth(<?php echo $month.",".$year?>)'></td>
</tr>
<tr>
<td width='50px'>Mån</td>
<td width='50px'>Tis</td>
<td width='50px'>Ons</td>
<td width='50px'>Tor</td>
<td width='50px'>Fre</td>
<td width='50px'>Lör</td>
<td width='50px'>Sön</td>
</tr>
<?php
echo "<tr>";
for($i = 1; $i < $numDays+1; $i++, $counter++){
$timeStamp = strtotime ("$year-$month-$i");
if($i == 1){
$firstDay = date("w", $timeStamp);
for ($j = 0; $j < $firstDay; $j++, $counter++){
echo "<td> </td>";
}
}
if ($counter % 7 == 0){
echo "</tr><tr>";
}
$monthstring = $month;
$monthlength = strlen ($monthstring);
$daystring = $i;
$daylength = strlen ($daystring);
if ($monthlength <= 1){
$monthstring = "0" .$monthstring;
}
if ($daylength <= 1){
$daystring = "0". $daystring;
}
$todaysDate = date("m/d/Y");
$dateToCompare = $monthstring . '/' . $daystring . '/' . $year;
echo "<td align='center' ";
if ($todaysDate == $dateToCompare){
echo "class='today'";
}else {
$sqlCount = "select * from eventcalender where eventDate='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlCount));
if ($noOfEvent >= 1){
echo "class='event'";
}
}
echo "><a href='".$_SERVER['PHP_SELF']."?month=".$monthstring."&day=".$daystring.".$year=".$year."&v=true'>".$i."</a></td>";
}
echo "</tr>";
?>
</table>
<?php
if (isset($_GET['v'])){
$sqlEvent = "select * from eventcalender where eventDate='".$month."/".$day."/".$year."'";
$resultEvents = mysql_query($sqlEvent);
echo "<hr>";
while($events= mysql_fetch_array($resultEvents)){
echo "Title : ".$events['Title']."<br />";
echo "Detail : ".$events['Detail']."<br />";
}
}
?>
</body>
</html>
Hälsningar/
Granskog1
