Capilla 1

$chapel_id = 1; $background_image = '"fondo-pergamino.jpg"'; $chapel = $name = $time = $service_type = $cemetery = $crematorium = $temple = $img1 = $img2 = $img3 = $video = ""; $query = "select chapels.chapel, chapels.name, chapels.time, service_type.name, cemeteries.name, crematoria.name, chapels.temple, chapels.image1, chapels.image2, chapels.image3, chapels.video from chapels inner join service_type on chapels.service_type=service_type.id inner join cemeteries on chapels.cemetery=cemeteries.id inner join crematoria on chapels.crematorium=crematoria.id where chapels.id = ?"; if($stmt = mysqli_prepare($link, $query)){ // Bind variables to the prepared statement as parameters mysqli_stmt_bind_param($stmt, "i", $param_id); // Set parameters $param_id = $chapel_id; // Attempt to execute the prepared statement if(mysqli_stmt_execute($stmt)){ /* store result */ mysqli_stmt_store_result($stmt); mysqli_stmt_bind_result($stmt, $chapel, $name, $time, $service_type, $cemetery, $crematorium, $temple, $img1, $img2, $img3, $video); mysqli_stmt_fetch($stmt); } else{ echo "Al parecer algo salió mal."; } } function transformToUppercase($inputString) { // Convert the string to uppercase using mb_strtoupper $uppercaseString = mb_strtoupper($inputString, 'UTF-8'); return $uppercaseString; } // Close statement mysqli_stmt_close($stmt); $slideinfo=$slideimg1=$slideimg2=$slideimg3=$slidevideo=$slidescontent=""; $time = date('H:i',strtotime($time)); if ($time=="00:00") { $time="N/A"; } if(!empty($name)){ $slideinfo = "

" .($time != "N/A" ? "" : "") .(!empty($temple) ? "" : "") .($cemetery != "No seleccionado" ? "" : "") .($crematorium != "No seleccionado" ? "" : "") ."

".transformToUppercase($name)."

".($service_type == "Misa" ? "MISA A LAS" : "SALIDA A LAS")." ".$time." HORAS

TEMPLO ".transformToUppercase($temple)."

CEMENTERIO ".transformToUppercase($cemetery)."

CREMATORIO ".transformToUppercase($crematorium)."

"; } /*else{ $img = '"portada-funerales.jpg"'; $slideinfo="

"; }*/ if(!empty($img1)){ $slideimg1=$slideinfo."

"; } if(!empty($img2)){ $slideimg2=$slideinfo."

"; } if(!empty($img3)){ $slideimg3=$slideinfo."

"; } if(!empty($video)){ $slidevideo=$slideinfo."

"; } $slidescontent = $slideimg1.$slideimg2.$slideimg3.$slidevideo; $query = "select name, type from media"; $consulta=mysqli_query($link, $query) or die("Hubo un fallo en la consulta"); $nfilas=mysqli_num_rows($consulta); if(empty($name)){ for($i=0;$i<$nfilas;$i++): $fila=mysqli_fetch_array($consulta); if($fila["type"]==="video/mp4"){ $slidescontent=$slidescontent.$slideinfo."

"; } else{ $slidescontent=$slidescontent.$slideinfo."

"; } endfor; } if($slidescontent==""){ $slidescontent = $slideinfo; } mysqli_close($link); ?> Capilla 1