Agenda

[insert_php]
$servername = «mysql.johnnybranchizio.com»;
$username = «branchizio»;
$password = «FullNelson1986»;
$dbname = «branchizio_wp»;
$conn = new mysqli($servername, $username, $password, $dbname);
$conn->set_charset(«utf8»);
if ($conn->connect_error) {
die(«Connection failed: » . $conn->connect_error);
}
$sql = «SELECT * FROM agenda WHERE data >= CURDATE() ORDER BY data»;

$result = $conn->query($sql);
if ($result->num_rows > 0) {
$month = -1;
while($row = $result->fetch_assoc()) {

$date = new DateTime($row[‘data’]);
$day = $date->format(‘d’);
$nEv = $row[‘nombre_evento’];
$nLoc = $row[‘nombre_local’];
$hora = $date->format(‘H:i’);
$direccion = $row[‘direccion’];
$link = $row[‘enlace_web’];
if($month != $date->format(‘m’)){
$month = $date->format(‘M, Y’);
echo «

$month

«;
$month = $date->format(‘m’);
}
echo «

$day
\»$nEv\»

$nLoc – $hora
$direccion
$nLoc

«;
}
} else {
echo «No hay eventos.»;
}
$conn->close();
[/insert_php]