Ik ben bezig met een simpele website voor een project van ons.
Hier moeten we statusupdates met foto's enzo kunnen plaatsen.
Probleem is: ik krijg geen nieuwsberichten uit de database.
Als ik login krijg ik geen max(messageID) (die ik echo na de query), en een select statement op de homepage wil niet. Maar ik krijg ook geen error dat de DB connectie niet klopt.
Code:
Index.php
<?php
$page="Home";
include_once("login.php"); //method to check if logged in.
include_once("database.php"); //configs for querying to database
include_once("newsitem.php"); //makeup for a news message
?>
<!doctype html>
<html>
<head>
<meta charset='utf-8'>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="menubar.css">
<link rel="shortcut icon" type="image/png" href="images/favico.png" />
<title>HOME</title>
</head>
<body>
<?php include_once("menu.php"); ?>
<center>
<?php
//here come the news messages
if(TRUE) {
$query = "SELECT messageID, uploaded, message FROM Messages ORDER BY uploaded DESC LIMIT 10";
$result = query($query);
echo $result[0];
forEach($result as $news) {
$photoQuery = "SELECT name FROM Photos WHERE messageID = '" . $news['messageID'] . "'";
$photos = query($photoQuery);
//$videoQuery = "SELECT name FROM Videos WHERE messageID = '" . $news['messageID'] . "' ";
//$videos = query($videoQuery);
news($news['uploaded'], $news['message'], $photos, $videos);
}
} else {
news("2016-4-19 10:48:13", "Dreamteam!", array("images/logo.png"), array());
}
?>
<?php include_once("foot.php"); ?>
</center>
</body>
</html>Login.php (test setup)
<?php
session_start();
if(isset($_GET['username']) && isset($_GET['password'])) {
if($_GET['username'] == "HankyPanky" && $_GET['password'] == "HocusPocusPilatusPats") {
$_SESSION['username'] = "HankyPanky";
include_once("database.php");
$maxID = "SELECT MAX(messageID) FROM Messages";
$num = query($maxID);
echo $num; //dit echo't niks
$query = "INSERT INTO Messages (messageID, uploaded, message) VALUES (". $num + 1.", '". date("Y-m-d H:i:s") ."', 'Logged in!')";
echo query($query); //echo't niks, zet ook niks in de DB
}
}
?><?php
function query($query) {
if($query == "") {
echo("Error: query is empty.");
return FALSE;
}
$mysqli = connect();
if($mysqli == FALSE) {
echo("Error: could not connect.");
return FALSE;
}
$result = mysqli_query($query);
if($result === FALSE) {
echo("Error: query is empty");
return FALSE;
}
mysqli_close($mysqli);
return $result;
}
function connect() {
$hostname = "localhost";
$username = "****";
$password = "****";
$database = "****";
$mysqli = mysqli_connect($hostname, $username, $password, $database);
if (mysqli_connect_errno($mysqli)) {
echo "Could not login to database: " . mysqli_connect_error();
return FALSE;
} else {
return $mysqli;
}
}
?>Newsitem.php
<?php
function news($uploaded, $news, $photos, $videos) {
echo "<hr><h3>" . $uploaded . "</h3>";
echo "<p>" . $news . "</p>";
forEach($photos as $photo) {
echo "<p><img src='" . $photo . "' width=''></p> ";
} unset($photo);
//forEach($videos as $video) { //need video player or youtube link
// echo "<p><img src='" . $video . "' width=''></p> ";
//} unset($video);
//we hebben nog geen video player dus voor nu is het uitgecomment
}
?>
