How to aquatize PHP MYSQLI data?

0

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

    
asked by Gorbendo 15.11.2018 в 18:41
source

0 answers