Doubt when Showing Logeado User Records

1

Good morning, I have a problem showing the information of each user, in this there are some forms which they store in a database, the code is as follows:

User Login:

<?php
session_start();
require 'funcs/conexion.php';
include 'funcs/funcs.php';

if(!isset($_SESSION["id_usuario"])){ //Si no ha iniciado sesión redirecciona a index.php
    header("Location: index.php");
}

$idUsuario = $_SESSION['id_usuario'];

$sql = "SELECT id, nombre FROM usuarios WHERE id = '$idUsuario'";
$result = $mysqli->query($sql);

$row = $result->fetch_assoc();

? >

List of Records:

            <div class="table-responsive">
        <table class="table table-striped table-hover">
            <tr>
                <th>No. Cotización</th>
                <th>Nombre o Razón Social</th>
                <th>Nombre del Representante de las Instalaciones</th>
                <th>Email</th>
                <th>Capacidad en KW</th>
            </tr>
            <?php
            if($filter){
                $sql = mysqli_query($con, "SELECT * FROM cotizacion WHERE estado='$filter' ORDER BY codigo desc");
            }else{
                //$sql = mysqli_query($con, "SELECT * FROM cotizacion ORDER BY codigo desc");
                $sql = mysqli_query($con, "SELECT * FROM cotizacion WERE id = '$idUsuario' ORDER BY codigo desc");
            }
            if(mysqli_num_rows($sql) == 0){
                echo '<tr><td colspan="8">No hay datos.</td></tr>';
            }else{

                while($row = mysqli_fetch_assoc($sql)){
                    echo '
                    <tr>
                        <td>C-UIIE-04-18-04-'.$row['codigo'].'</td>
                        <td><a href="profile_coti.php?nik='.$row['cotiz1'].'"><span class="glyphicon glyphicon-user" aria-hidden="true"></span> '.$row['cotiz1'].'</a></td>
                        <td>'.$row['cotiz2'].'</td>
                        <td>'.$row['cotiz3'].'</td>
                        <td>'.$row['cotiz4'].'</td>
                    </tr>
                    ';

                }
            }
            ?>

With this code I save the form's records to a database:

    <?php
        if(isset($_POST['add'])){
            $codigo          = mysqli_real_escape_string($con,(strip_tags($_POST["codigo"],ENT_QUOTES)));//Escanpando caracteres
            $cotiz1          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz1"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz2          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz2"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz3          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz3"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz4          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz4"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz5          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz5"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz6          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz6"],ENT_QUOTES)));//Escanpando caracteres 
            $cotiz7          = mysqli_real_escape_string($con,(strip_tags($_POST["cotiz7"],ENT_QUOTES)));//Escanpando caracteres 
            $id          = mysqli_real_escape_string($con,(strip_tags($_POST["id"],ENT_QUOTES)));//Escanpando caracteres 

            $cek = mysqli_query($con, "SELECT * FROM cotizacion WHERE codigo='$codigo'");
            if(mysqli_num_rows($cek) == 0){
                    $insert = mysqli_query($con, "INSERT INTO cotizacion(codigo, cotiz1, cotiz2, cotiz3, cotiz4, cotiz5, cotiz6, cotiz7, id)
                                                        VALUES('$codigo', '$cotiz1', '$cotiz2', '$cotiz3', '$cotiz4', '$cotiz5', '$cotiz6', '$cotiz7', '$id')") or die(mysqli_error());
                    if($insert){
                        echo '<div class="alert alert-success alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Bien hecho! Tu solicitud fue enviada con éxito, te contactaremos en breve.</div>';
                    }else{
                        echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Error. No se pudo guardar los datos !</div>';
                    }

            }else{
                echo '<div class="alert alert-danger alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>Error. código exite!</div>';
            }
        }
        ?>

Database

The idea is to show the records that each user makes in their session, but I really do not know how to achieve this goal since I'm just starting in this, I hope someone can support me.

Thanks and regards!

    
asked by Hinojosa Aguilar Oscar 13.11.2018 в 16:10
source

0 answers