<!-- formulario de registro-->
<div class="row">
<br>
<form class="" action="registrar_historiaclinica_antecedentes_personales.php" name="frmContacto" method="POST">
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>Motivo de Consulta:</b></h6>
<textarea id="motivo_consulta" name="motivo_consulta" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>Enfermedad Actual:</b></h6>
<textarea id="enfermedad_actual" name="enfermedad_actual" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>HTA:</b></h6>
<textarea id="hta" name="hta" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>DIABETES:</b></h6>
<textarea id="diabetes" name="diabetes" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>ALERGIA A FARMACOS:</b></h6>
<textarea id="alergias_farmacos" name="alergias_farmacos" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>QUIRURGICOS:</b></h6>
<textarea id="quirurgicos" name="quirurgicos" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>OTROS:</b></h6>
<textarea id="otros" name="otros" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>ANTECEDENTES FAMILIARES:</b></h6>
<textarea id="antecedentes_familiares" name="antecedentes_familiares" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="input-field col s12 m12">
<h6 class="left-align white-text thin"><b>PSICOBIOLOGICOS:</b></h6>
<textarea id="psicobiologicos" name="psicobiologicos" class="materialize-textarea" title="Describe tu Mensaje" autocomplete="off" required/></textarea>
</div>
<div class="center-align">
<button class="btn waves-effect blue-grey darken-4 btn-medium" type="submit" name="guardar">
Crear Historia Clinica
</button>
<button class="btn waves-effect blue-grey darken-4 btn-medium" type="reset" >
Cancelar
</button>
<a href='historiaclinica.php'
button class='btn waves-effect blue-grey darken-4 btn-medium' type='submit'>
Volver Atrás
</button></a>
</div>
<input type='hidden' name='fk_cedula' value='<?php echo $cedula;?>' id='cedula'>
</form>
<!-- proceso para registrar-->
<?php
if(isset($_POST['guardar'])){ $cedula_check = $DB_con->prepare('SELECT fk_cedula FROM antecedentes_personales WHERE fk_cedula = :fk_cedula LIMIT 1');
$cedula_check->bindParam(':fk_cedula', $_POST['fk_cedula']);
$cedula_check->execute();
if($cedula_check->rowCount() > 0){
$cedula_check->closeCursor();
echo "<div class='col s12 card-panel blue lighten-2 center'>
<h5 class='black-text text-darken-2 center CONDENSED LIGHT5'>
¡ Ups Aviso: El Registro ya se Encuentra Insertado !
</h5>
</div>";
header("refresh:5;consultar_historiaclinica.php");
}else{
$sql=$DB_con->prepare("INSERT INTO antecedentes_personales(
fk_cedula,motivo_consulta,enfermedad_actual,hta,diabetes,alergias_farmacos,
quirurgicos,otros,antecedentes_familiares,psicobiologicos)
VALUES
(:fk_cedula, :motivo_consulta, :enfermedad_actual, :hta, :diabetes, :alergias_farmacos,
:quirurgicos, :otros, :antecedentes_familiares, :psicobiologicos)");
$sql->bindParam(':fk_cedula',$_POST['fk_cedula']);
$sql->bindParam(':motivo_consulta',$_POST['motivo_consulta']);
$sql->bindParam(':enfermedad_actual',$_POST['enfermedad_actual']);
$sql->bindParam(':hta',$_POST['hta']);
$sql->bindParam(':diabetes',$_POST['diabetes']);
$sql->bindParam(':alergias_farmacos',$_POST['alergias_farmacos']);
$sql->bindParam(':quirurgicos',$_POST['quirurgicos']);
$sql->bindParam(':otros',$_POST['otros']);
$sql->bindParam(':antecedentes_familiares',$_POST['antecedentes_familiares']);
$sql->bindParam(':psicobiologicos',$_POST['psicobiologicos']);
$sql->execute();
}
if($sql)
{
echo "<div class='col s12 card-panel teal lighten-2 center'>
<h5 class='black-text text-darken-2 center CONDENSED LIGHT5'>
¡ Bien Hecho: Registro Insertado Correctamente !
</h5>
</div>";
header("refresh:5;consultar_historiaclinica.php"); }
}
?>
<!-- fin proceso para registrar-->
</div>
<!-- fin formulario de registro-->