This is the warning:
Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, boolean given in D: \ xampp \ htdocs \ php \ Proyectus1 \ editProfile.php on line 105
and this code:
<?php
session_start();
?>
<form action="" method ="post">
</br></br>
<div class="content">
<div class="wrap">
<!---start-contact---->
<div class="section group">
<div class="col span_2_of_3">
<div class="contact-form">
<?php
include'conexion.php';
$conexionbd = $contenido;
$consulfila="SELECT * FROM epicFilms.usuarios where nick like '".$_SESSION["nick"]."'";
$resulconsul=mysqli_query($conexionbd,$consulfila);
while($fila = mysqli_fetch_array($resulconsul))
{
echo "<form method='POST'>
<div>
<span><label>Nick: </label></span>
<span><input name='nick' value= '".$fila["nick"]."' type='text' class='textbox'></span>
</div>
<div>
<span><label>Nombre: </label></span>
<span><input name='nombre' value= '".$fila["nombre"]."' type='text' class='textbox'></span>
</div>
<div>
<span><label>Apellidos: </label></span>
<span><input name='apellido' value= '".$fila["apellidos"]."' type='text' class='textbox'></span>
</div>
<div>
<span><label>Telefono: </label></span>
<span><input name='tfno' value= '".$fila["telefono"]."' type='text' class='textbox'></span>
</div>
<div>
<span><label>Mail: </label></span>
<span><input name='correo' value= '".$fila["email"]."' type='text' class='textbox'></span>
</div>
<div>
<span><label>Contraseña: </label></span>
<span><input name='pass' value= '".$fila["contrasegna"]."' type='text' class='textbox'></span>
</div>
<br>
<input type='submit' name='enviar' value='Enviar'/>
<input type='submit' name='borrar' value='Eliminar'>
</form> ";
}
?>
</div>
</div>
</div>
</div>
</div>
<?php
if(isset($_POST["enviar"]))
{
$insertfila="UPDATE epicFilms.usuarios SET nick = '".($_POST["nick"])."' where nick='".$_POST["nick"]."'";
$resultado=$contenido->query($insertfila);
echo$resultado;
while($fila = mysqli_fetch_array($resultado))
{
echo"pene";
}
}
if(isset($_POST["borrar"]))
{
$insertfila="DELETE FROM usuarios where nick = '".$_POST["nick"]."'";
$resultado=mysqli_query($contenido,$insertfila);
}
mysqli_close($contenido);
?>
I want to update the values of the form above in the database and display them updated