function mostrar()
{
$select = "SELECT * FROM area_de_identificacion";
$stmt = $GLOBALS['conn']->prepare($select);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
// Establecer fetch mode (arreglo asociativo con nombres de columnas de la base)
// Check if id is in database (for develop purpose only)
if ($stmt->rowCount() == 0) {
} else {
$data = $stmt->fetchAll();
// Obtener el único resultado de la base de datos
foreach ($data as &$registro) {
// In order to be able to directly modify array elements within the loop precede $value with &. In that case the value will be assigned by reference.
$registro['duracion'] = getDuracion($registro['duracion']);
}
print_r(json_encode($data));
return json_encode($data);
}
}
<span>Imagen</span>
<input type="file" name="image" onchange="PreviewImage();" id="uploadImage" >
</div>
</div>
</div>
<div class="input-field col s12 m12">
<div class="input-field col s4 m5">
<input id="idOp" type="number" class="validate" name="idOp" value="<?php
echo getIDOp($id)["cp_codigo"];
?>
">
<label for="idOp" class="active">ID OP</label>
</div>
<div class="input-field col s4 m5">
<input id="duration" type="number" class="validate" name="duracion" value="<?php
echo getDuracion($id)["CP_duracion"];
?>
" >
<label for="duration" class="active">Duración</label>
</div>
<div class="input-field col s4 m5">
<input id="spots" type="number" class="validate" name="cupos" value="<?php
echo getCupos($id)["cp_cupos"];
?>
" >
<label for="spots" class="active">Cupos</label>
</div>
<div class="input-field col s4 m5">
<input id="fee" type="number" class="validate" name="fee" value="<?php
echo getFee($id)["BEN_fee"];
?>
