Código PHP:
<?php
class medico{
public function mostrarMedico(){
try {
require_once('../php/conexion.php');
$conn = Conexion::conectar();
$sql="SELECT * FROM medico ORDER BY RAND() LIMIT 0,1";
$resultado=$conn->prepare($sql);
$resultado->execute(array($sql));
while ($registro=$resultado->fetch(PDO::FETCH_ASSOC)) {
echo "<input type='text' name='id_medico' id='id_medico' value='".$registro['id_medico']."'</input>";
echo "<div class='container-fluid'>
<label for='datos_medico'>Datos Médico:
<div class='container-fluid' style='border: 1px solid #6F96DF; border-radius: 8px;padding:10px;' id='datos_medico'>
<div class='row'>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Apellido Paterno</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['apellido_paterno']."'</input>
</div>
</div>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Apellido Materno</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['apellido_materno']."'</input>
</div>
</div>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Primer Nombre.</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['nombre_1']."'</input>
</div>
</div>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' style='font-size:15px;' id='inputGroup-sizing-sm'>Segundo Nombre</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['nombre_2']."'</input>
</div>
</div>
</div>
<div class='row'>";
echo"<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Especialidad</span>";
echo"<select class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm'>";
echo"<option value='".$registro['especialidad']."'>".$registro['especialidad']."</option>";
#función que recupera los valores desde la db hacia el select
$sql_esp="SELECT * FROM especialidades ORDER BY especialidad ASC";
$res=$conn->prepare($sql_esp);
$res->execute(array($sql_esp));
while ($esp=$res->fetch(PDO::FETCH_ASSOC)) {
echo" <option value='".$esp['especialidad']."'>".$esp['especialidad']."</option>";
}
echo"</select>
</div>
</div>";
echo"<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Sub especialidad</span>";
echo"<select class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm'>";
echo"<option value='".$registro['subespecialidad']."'>".$registro['subespecialidad']."</option>";
#función que recupera los valores desde la db hacia el select
$sql_subesp="SELECT * FROM especialidades ORDER BY especialidad ASC";
$result=$conn->prepare($sql_subesp);
$result->execute(array($sql_subesp));
while ($subesp=$result->fetch(PDO::FETCH_ASSOC)) {
echo" <option value='".$subesp['especialidad']."'>".$subesp['especialidad']."</option>";
}
echo"</select>
</div>
</div>";
echo "
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' id='inputGroup-sizing-sm'>Cédula Profesional</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['cedula_profesional']."'</input>
</div>
</div>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' style='font-size:15px;' id='inputGroup-sizing-sm'>Cédula Especialista</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['cedula_especialista']."'</input>
</div>
</div>
</div>
<div class='row'>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' style='font-size:15px;' id='inputGroup-sizing-sm'>Teléfono Móvil</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['telefono_movil']."'</input>
</div>
</div>
<div class='col-md-3'>
<div class='input-group input-group-sm mb-3'>
<span class='input-group-text' style='font-size:15px;' id='inputGroup-sizing-sm'>Fecha de Nacimiento</span>
<input type='text' class='form-control' aria-label='Sizing example input' aria-describedby='inputGroup-sizing-sm' value='".$registro['fecha_nacimiento']."'</input>
</div>
</div>
</div>
</div>
</div>
</div>";
}
} catch (Exception $e) {
die('Error: ' . $e->GetMessage());
}finally{
$conn = null;
}
}
}
?>
Código PHP:
<?php
class Domicilio{
public $idMedico;
public function mostrarDomicilio(){
try {
require_once '../php/conexion.php';
$conn = Conexion::conectar();
$sqlDomicilio = "SELECT medico.id_medico as id_medico, domicilio.id_domicilio as id_domicilio, domicilio.id_medico as id_medicod FROM medico medico, domicilio domicilio WHERE medico.id_medico = domicilio.id_medico ORDER BY RAND() LIMIT 0,1";
$final=$conn->prepare($sqlDomicilio);
$final->execute(array($sqlDomicilio));
$i = 1;
foreach($final as $fila){
echo $idMedico;
echo "".$fila['id_domicilio'];
echo " - ".$fila['id_medico'];
echo " - ".$fila['id_medicod'];
$i++;
}
} catch (Exception $e) {
}
}
}
?>
Código PHP:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<!-- Popper JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<script src="htts://kit.fontawesome.com/e632f1f723.js" crossorigin="anonimus" ></script>
</head>
<body>
<?php
require_once('../php/conexion.php');
require '../logica/class.medico.php';
require '../logica/tiempo.hora.php';
require '../logica/class.domicilio.php';
$tiempoHora = new tiempoHora();
$tiempoHora-> fecha();
$clsMedico = new medico();
$clsMedico -> mostrarMedico();
$domicilio = new domicilio();
$domicilio-> mostrarDomicilio();
?>
</body>
</html>