Dato - Vis indlæg fra denne uge

<?php
// test data
/*
 CREATE TABLE IF NOT EXISTS `kalender` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dato` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci AUTO_INCREMENT=3 ;

--
-- Data dump for tabellen `kalender`
--

INSERT INTO `kalender` (`id`, `dato`) VALUES
(1, '2014-11-17'),
(2, '2014-11-18'); 
 */

// av det gør ondt at anvende det gamle API
mysql_connect ("localhost", "root", "", true);
mysql_select_db("test") or die('Could not select database ');

$sql = "select * from kalender where dato >= '2014-11-17' and dato <= '2014-11-23' order by dato";

echo "med mysql_fetch_array, her er det både assoc og array <br>";
$query = mysql_query($sql);
echo '<pre>';
while($getter = mysql_fetch_array($query))
{print_r($getter);}
echo '</pre>';

echo "med mysql_fetch_assoc <br>";
$query = mysql_query($sql);
echo '<pre>';
while($getter = mysql_fetch_assoc($query))
{print_r($getter);}
echo '</pre>';
?>

$query = mysqli_query($conn, $sql);
while($getter = mysqli_fetch_assoc($query))

$query = $conn->query($sql);
while($getter = $query->fetch_assoc())

     
<?php
// test data
/*
 CREATE TABLE IF NOT EXISTS `kalender` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dato` date NOT NULL,
  `text` text COLLATE utf8_danish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci AUTO_INCREMENT=3 ;

--
-- Data dump for tabellen `kalender`
--

INSERT INTO `kalender` (`id`, `dato`, `text`) VALUES
(1, '2014-11-17', 'sjfslfjslk'),
(2, '2014-11-18', 'fnseowwau slsjfweiou sdfjwiodurw'); 
 */
$conn = mysqli_connect("localhost", "root", "", "test");
if (!$conn) {
    echo 'Der opstod en fejl.';
    exit();
}
mysqli_set_charset($conn, "utf8");


// http://dev.mysql.com/doc/refman/5.0/en/locale-support.html 

// sætter navne til dansk
$sql = "SET lc_time_names = 'da_DK'";
$query = $conn->query($sql);
    
$sql = "select *, DAYNAME(dato) AS dayname, DATE_FORMAT(dato, '%d-%m-%Y') dansk_dato from kalender where dato >= '2014-11-17' and dato <= '2014-11-23' order by dato";
$query = $conn->query($sql);

$str="<table>";
while($row = $query->fetch_assoc()){
  $str .= "<tr>";
    $str .= "<td>". $row['dayname'] ."</td>";    
    $str .= "<td>". $row['dansk_dato'] ."</td>";
    $str .= "<td>". $row['text'] ."</td>";    
  $str .= "</tr>";    
    // $str .= $row['dayname']." ". $row['dansk_dato']. " ". $row['text']."<br>";    
}
$str .="</table>";
echo $str;
?>

select *, DAYNAME(dato) AS dayname, DATE_FORMAT(dato, '%d-%m-%Y') dansk_dato from kalender where WEEK(dato,3) = 47 order by dato

$conn = mysqli_connect("localhost", "root", "", "test");
if (!$conn) {
    echo 'Der opstod en fejl.';
    exit();
}
mysqli_set_charset($conn, "utf8");
     
// sætter navne til dansk
$sql = "SET lc_time_names = 'da_DK'";
$query = $conn->query($sql);     
     
     
$sql = "select *, DAYNAME(dato) AS dayname, DATE_FORMAT(dato, '%d-%m-%Y') dansk_dato, YEAR(dato) AS year, WEEK(dato,3) AS week from kalender order by YEAR(dato), WEEK(dato,3)";
$query = $conn->query($sql);
$str="<table>";
$week=0;
while($row = $query->fetch_assoc()){
  if ($week != $row['week']){
  $week=$row['week'];
      $str .= "<tr>";
  $str .= '<td  colspan="3">'. $row['week'] ."</td>";
  $str .= "</tr>";
  }
  
    $str .= "<tr>";  
    $str .= "<td>". $row['dayname'] ."</td>";    
    $str .= "<td>". $row['dansk_dato'] ."</td>";
    $str .= "<td>". $row['text'] ."</td>";    
  $str .= "</tr>";    
    // $str .= $row['dayname']." ". $row['dansk_dato']. " ". $row['text']."<br>";    
}
$str .="</table>";
echo $str;

select *, DAYNAME(dato) AS dayname, DATE_FORMAT(dato, '%d-%m-%Y') dansk_dato, YEAR(dato) AS year, WEEK(dato,3) AS week from kalender WHERE dato > NOW() order by YEAR(dato), WEEK(dato,3)

select *, DAYNAME(dato) AS dayname, DATE_FORMAT(dato, '%d-%m-%Y') dansk_dato, YEAR(dato) AS year, WEEK(dato,3) AS week from kalender WHERE dato >= NOW() AND dato <= ( ADDDATE( NOW(), INTERVAL 6 MONTH) ) order by YEAR(dato), WEEK(dato,3)