Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = '127.0.0.1';
- $dbName='dinschema';
- $user ='root';
- $pass='';
- $charset = 'utf8mb4';
- $enlace = "mysql:host=$host;dbname=$dbName;charset=$charset";
- $options = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- try{
- $pdo= new PDO($enlace,$user,$pass,$options);
- }catch (PDOException $e){
- throw new PDOException($e->getMessage(), (int)$e->getCode());
- die();
- }
- ?>
- <?php
- include_once 'conexion.php';
- echo ' el index';
- $sql_leer = 'SELECT * FROM personas p, direccion d WHERE p.idPersonas = d.idDireccion';
- $gsent=$pdo -> prepare($sql_leer);
- $gsent->execute();
- $resultado = $gsent->fetchAll();
- var_dump($resultado);
- ?>
- <?php if(!empty($resultado)):?>
- <?php foreach ($resultado as $dato):?>
- <tr>
- <td> <?php echo $dato['idPersonas'] ?></td>
- <td> <?php echo $dato['foto'] ?></td>
- <td> <?php echo $dato['nombre']." " .$dato['apellidoP']." " .$dato['apellidoM'] ?></td>
- <td> <?php echo $dato['fechaCaptura'] ?></td>
- <td> <?php echo $dato['carrera'] ?></td>
- <td> <?php echo $dato['escolaridad'] ?></td>
- <td> <?php echo $dato['telefono'] ?></td>
- <td> <?php echo $dato['correo'] ?></td>
- <td> <?php echo $dato['genero'] ?></td>
- <td> <?php echo $dato['rfc'] ?></td>
- <td> <?php echo $dato['curp'] ?></td>
- <td> <?php echo $dato['direccion'].",".$dato['cp'].". ".$dato['ciudad'].",".$dato['estado'].",".$dato['pais'] ?></td>
- <td> <?php echo $dato['observaciones'] ?></td>
- </tr>
- <?php endforeach; ?>
- <?php else: ?>
- <?php echo "<div class='alert alert-warning text-center'> No se encontraron Registros</div>" ?>
- <?php endif; ?>
Add Comment
Please, Sign In to add comment