Weer een foutmelding:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, object given in C:\USB WebServer\root\CRUD\display.php on line 44
display.php
<html>
<head>
<title>CRUD Operation</title>
<script src = https://code.jquery.com/jquer-2.1.3.min.js></script>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
</head>
<body>
<div class = "containerr">
<button class = "btn btn-primary my-5" ><a href="user.php" class="text-light">Add User</a>
</button>
<table class="table">
<thead>
<tr>
<th scope="col">ID</th>
<th scope="col">Voornaam</th>
<th scope="col">Achternaam</th>
<th scope="col">email</th>
<th scope="col">telefoonnummer</th>
<th scope="col">adres</th>
<th scope="col">postcode</th>
<th scope="col">woonplaats</th>
<th scope="col">username</th>
<th scope="col">password1</th>
<th scope="col">password2</th>
<th scope="col">geslacht</th>
<th scope="col">geboortedatum</th>
</tr>
</thead>
<tbody>
<?php
include 'connect.php';
$sql = "SELECT * FROM crudoperation ";
$result = mysqli_query($con, $sql);
if($result)
{
$row = mysqli_fetch_assoc($con, $result);
}
?>
</tbody>
</table>
</div>
</form>
</div>
</body>
</html>
user.php
<?php
include 'connect.php';
if(isset($_POST ['submit']))
{
// $name =$_POST['name'];
$voornaam = isset($_POST['voornaam']) && trim($_POST['voornaam'])!='' ? $_POST['voornaam'] : '';
$achternaam = isset($_POST['achternaam']) && trim($_POST['achternaam'])!='' ? $_POST['achternaam'] : '';
$email = isset($_POST['email']) && trim($_POST['email'])!='' ? $_POST['email'] : '';
$telefoonnummer = isset($_POST['telefoonnummer']) && trim($_POST['telefoonnummer'])!='' ? $_POST['telefoonnummer'] : '';
$adres = isset($_POST['adres']) && trim($_POST['adres'])!='' ? $_POST['adres'] : '';
$postcode = isset($_POST['postcode']) && trim($_POST['postcode'])!='' ? $_POST['postcode'] : '';
$woonplaats = isset($_POST['woonplaats']) && trim($_POST['woonplaats'])!='' ? $_POST['woonplaats'] : '';
$username = isset($_POST['username']) && trim($_POST['username'])!='' ? $_POST['username'] : '';
$password1 = isset($_POST['password1']) && trim($_POST['password1'])!='' ? $_POST['password1'] : '';
$password2 = isset($_POST['password2']) && trim($_POST['password2'])!='' ? $_POST['password2'] : '';
$geslacht = isset($_POST['geslacht']) && trim($_POST['geslacht'])!='' ? $_POST['geslacht'] : '';
$geboortedatum = isset($_POST['geboortedatum']) && trim($_POST['geboortedatum'])!='' ? $_POST['geboortedatum'] : '';
$sql = "INSERT INTO crudoperation (voornaam, achternaam, email, telefoonnummer, adres, postcode, woonplaats, password1, password2, geslacht, geboortedatum) VALUES (' $voornaam', '$achternaam', '$email', '$telefoonnummer', '$adres','$postcode', '$woonplaats', '$username', '$password1', '$password2', '$geslacht', '$geboortedatum')";
$result = mysqli_query($con,$sql);
if($result)
{
echo "Data inserted succelfully";
}
else
{
die(mysqli_error($con));
}
}
?>
user.php
[code]
<!doctype html>
<html lang="en">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<title>CRUD Operation</title>
</head>
<body>
<div class="container my -5"></div>
<form method = post>
<div class="form-group">
<label>Voornaam</label>
<input type="text" class="form-control" placeholder ="Enter your name" name= "voornaam" autocomplete="off" required>
</div>
<div class="form-group">
<label>Achternaam</label>
<input type="text" class="form-control" placeholder ="Enter your email" name= "achternaam" autocomplete="off" required>
</div>
<div class="form-group">
<label>email</label>
<input type="email" class="form-control" placeholder ="Enter your mobile" name= "email" autocomplete="off" required>
</div>
<div class="form-group">
<label>telefoonnummer</label>
<input type="text" class="form-control" placeholder ="Enter your password" name= "telefoonnummer" autocomplete="off" required>
</div>
<div class="form-group">
<label>adres</label>
<input type="text" class="form-control" placeholder ="Enter your name" name= "adres" autocomplete="off" required>
</div>
<div class="form-group">
<label>postcode</label>
<input type="text" class="form-control" placeholder ="Enter your postcode" name= "postcode" autocomplete="off" required>
</div>
<div class="form-group">
<label>woonplaats</label>
<input type="text" class="form-control" placeholder ="Enter your woonplaats" name= "woonplaats" autocomplete="off" required>
</div>
<div class="form-group">
<label>username</label>
<input type="text" class="form-control" placeholder ="Enter your username" name= "username" autocomplete="off" required>
</div>
<div class="form-group">
<label>password</label>
<input type="password" class="form-control" placeholder ="Enter your password" name= "password1" autocomplete="off" required>
</div>
<div class="form-group">
<label>password</label>
<input type="password" class="form-control" placeholder ="Enter your password again" name= "password2" autocomplete="off" required>
</div>
<div class="form-group">
<label>geslacht</label>
<input type="text" class="form-control" placeholder ="Enter your geslacht" name= "geslacht" autocomplete="off" required>
</div>
<div class="form-group">
<label>geboortedatum</label>
<input type="text" class="form-control" placeholder ="Enter your geboortedatum" name= "geboortedatum" autocomplete="off" required>
</div>
<button type="submit" class="btn btn-primary" name= "submit" >Submit</button>
</form>
</div>
</body>
</html>
[//code]
In user.php zitten geen fouten!!
Alleen in display. Wat doe ik hier fout?
