"Dé grootste en gratis computerhelpdesk van Nederland"
$aantal_pers_in_week_Query = "SELECT SUM(aantal_personen) FROM reserv_zaterdagavond WHERE week_nummer = $week_num";
$aantal_pers_in_week_Result = mysql_query($aantal_pers_in_week_Query) or die(mysql_error());$aantal_pers_in_week_Query= mysqli_query($conn,"SELECT SUM(aantal_personen) FROM reserv_zaterdagavond WHERE week_nummer = $week_num");
$aantal_pers_in_week_Result = mysqli_query($aantal_pers_in_week_Query) or die(mysqli_error());$aantal_pers_in_week_Result = mysqli_query($aantal_pers_in_week_Query) or die(mysqli_error());$aantal_pers_in_week_Result = ( $aantal_pers_in_week_Query ) or die ( 'Query failed: ' . mysql_error() );$aantal_pers_in_week_Result = $aantal_pers_in_week_Query ;
$mysqli = new mysqli("example.com", "user", "password", "database");
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
if (!$mysqli->query("DROP TABLE IF EXISTS test") ||
!$mysqli->query("CREATE TABLE test(id INT, label CHAR(1))") ||
!$mysqli->query("INSERT INTO test(id, label) VALUES (1, 'a')")) {
echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
$res = $mysqli->query("SELECT id, label FROM test WHERE id = 1");
$row = $res->fetch_assoc();
) future-prooi is.$query_pers = mysqli_query($mysqli,"SELECT SUM(aantal_personen) FROM reserv_zaterdagavond ");
$sql = mysqli_query($query_pers); // 5
$aantal_pers_in_week_Result = mysqli_fetch_assoc($sql ); //6
echo $$aantal_pers_in_week_Result['SUM(aantal_personen)'];$query_pers = "SELECT SUM(aantal_personen) FROM reserv_zaterdagavond ";
$result = $mysqli->query($query_pers);
//$sql = mysqli_query($query_pers);
$aantal_pers_in_week_Result = mysqli_fetch_assoc($result);
echo $aantal_pers_in_week_Result['SUM(aantal_personen)'];$query_pers = mysqli_query($mysqli, "SELECT SUM(aantal_personen) AS totaal FROM reserv_zaterdagavond ");
$aantal_pers_in_week_Result = mysqli_fetch_assoc($query_pers );
echo $aantal_pers_in_week_Result['totaal'];$query_pers = "SELECT SUM(aantal_personen) AS totaal FROM reserv_zaterdagavond ";
$result = $mysqli->query($query_pers);
$aantal_pers_in_week_Result = $mysqli->fetch_assoc();
echo $aantal_pers_in_week_Result['totaal'];<a href="update/index.php?id=' . $rows['id'] . '"></a><!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Update</title>
</head>
<body>
<form action="update.php" method="GET">
<input type="hidden" value="<?= $_GET['id'] ?>" name="id"/>
Name: <input type="text" name="name" value="<?= $_GET['name'] ?>">
Geslacht: <input type="text" name="geslacht" value="<?= $_GET['geslacht'] ?>">
<input type="submit" name="submit">
</form>
</body>
</htmlName: <input type="text" name="name" value="<?= $_GET['name'] ?>">
geslacht: <input type="text" name="geslacht" value="<?= $_GET['geslacht'] ?>"><?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);
?>
<?php
if ($_POST['submit']) {
$name = $_POST['name'];
$age = $_POST['geslacht'];
$id = $_POST['id'];
if (!empty($name) && !empty($geslacht) && !empty($id)) {
$db = new mysqli(HOST, USER, PASS, DBNAME);
if ($db->connect_errno) {
echo "Failed to connect to MySQL: (" . $db->connect_errno . ") "
. $db->connect_error;
}
$query = "UPDATE reserveren SET name=?,geslacht=?, WHERE id=?";
$conn = $db->prepare($query);
$conn->bind_param("isi", $name, $geslacht, $id);
if ($conn->execute()) {
header('location: http://xxxxxxxx/index.php');
}
$db->close();
}
}
?>if ($_POST['submit']) {if ($_SERVER['REQUEST_METHOD'] == "POST") {
