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 “

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