Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\USB WebServer\root\Youtube9\toon.php on line 77
Die hadden we al een keer. Iemand die me deze functie kan uitleggen? (En mogelijke oplossingen heeft)
Code
<?php
include ('./connect.php');
if(isset($_POST['submit']))
{
$username = $_POST['username'];
$mobile = $_POST['mobile'];
$image = $_FILES['file'];
//echo $username;
//echo "<br>";
//echo $mobile;
//echo "<br>";
//print_r($image);
$imagefilename=$image['name'];
//print_r($imagefilename);
//echo "<br>";
$imagefileerror=$image['error'];
//print_r($imagefileerror);
//echo "<br>";
$imagefiletemp=$image['tmp_name'];
//print_r($imagefiletemp);
//echo "<br>";
$filaname_seperate=explode('.', $imagefilename);
//print_r($filaname_seperate);
$file_extension=strtolower(end($filaname_seperate));
//print_r($file_extension);
$extension=array('jpeg', 'jpg', 'png');
if(in_array($file_extension,$extension))
{
$upload_image='images/'.$imagefilename;
move_uploaded_file($imagefiletemp, $upload_image);
$sql = "INSERT INTO `registration` (name, mobile, image) VALUES ('$username','$mobile', '$upload_image')";
// $sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', '[email protected]')";
$result=mysqli_query($con, $sql);
if($result)
{
echo '<div class="alert alert-success" role="alert"><strong>Succesfully </strong>Data inserted succesfully</div>';
}
else
{
die(mysqli_error($con));
}
}
}
?>
<?php
$sql = "SELECT * FROM 'registration'";
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_assoc($result))
{
echo '
<tr>
<td>'.$id.'</td>
<td>'.$name.'</td>
<td>'.$image.'</td>
</tr>';
}
?>
