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"]; ?>