{"id":8052,"date":"2015-04-10T13:33:14","date_gmt":"2015-04-10T13:33:14","guid":{"rendered":"http:\/\/www.giff.mx\/?page_id=8052"},"modified":"2022-03-15T12:42:11","modified_gmt":"2022-03-15T18:42:11","slug":"programacion-2011-2","status":"publish","type":"page","link":"https:\/\/giff.mx\/en\/programacion-2011-2\/","title":{"rendered":"Programaci\u00f3n 2011"},"content":{"rendered":"<div align=\"center\">\n<? \n\/\/include(\"films\/db.php\");\n$link = mysqli_connect('localhost', 'eddiered_Pelis', 'expresion2010A', 'eddiered_peliculas');\n$page=\"catalog\";\n?><\/p>\n<h1>\n<?\nif(isset($_GET[\"cat\"]) and ($_GET[\"cat\"]==27 OR $_GET[\"cat\"]==22 OR $_GET[\"cat\"]==28 OR $_GET[\"cat\"]==32 OR $_GET[\"cat\"]==21){ ?><? $ev=1; Eventos ?><? }\nif(isset($_GET[\"films\"]) and $_GET[\"films\"]==1){ ?>Pel&iacute;culas<? }\nif(!isset($_GET[\"cat\"]) AND !isset($_GET[\"films\"])){ ?>Todos los Eventos<? } ?><br \/>\n <? if(isset($_GET[\"cat\"])){ \n    $sql=\"SELECT * FROM categorias WHERE id='\".$_GET[\"cat\"].\"'\"; \n    $result=$link->query($sql);<br \/>\n    $row=mysqli_fetch_assoc($result);<br \/>\n?><? if($ev!=1){ ?><? } ?><?=$row[\"espanol\"]?><? if($ev!=1){ ?><? } ?><? } ?><\/h1>\n<p><br \/><\/p>\n<p><? if(!isset($_GET[\"cat\"])){ ?><br \/>\nPor favor selecciona una categor&iacute;a para ver las pel&iacute;culas en ella.<\/p>\n<p><center><\/p>\n<table cellspacing=\"10\" border=\"0\">\n<?\n$sql=\"SELECT * FROM categorias ORDER BY espanol\";\nif(isset($_GET[\"films\"]) and $_GET[\"films\"]==1){ \n    $sql=\"SELECT * FROM categorias WHERE id!=27 AND id!=22 AND id!=28 AND id!=32 AND id!=21 ORDER BY ingles\"; $page=\"films\"; }\n$result=$link->query($sql);<\/p>\n<p>while($row=mysqli_fetch_assoc($result)){<br \/>\n$sq=&#8221;SELECT count(*) from peliculas WHERE categoria='&#8221;.$row[&#8220;id&#8221;].&#8221;&#8216;&#8221;;<br \/>\n$re=$link->query($sq);<br \/>\n$ro=mysqli_fetch_assoc($re);<br \/>\n?><\/p>\n<tr>\n<td><a href=\"?page_id=63&#038;cat=<?=$row[\"id\"]?>&#8220;><strong><?=$row[\"espanol\"]?> (<?=$ro[\"count(*)\"]?> pel&iacute;culas\/eventos)<\/strong><\/a><\/td><\/tr><p><? }  ?><br \/><\/table><p><? }else{ if($_GET[\"cat\"]==\"27\"){ $page=\"conferences\"; }if($_GET[\"cat\"]==\"22\"){ $page=\"events\"; }if($_GET[\"cat\"]==\"28\"){ $page=\"workshops\"; }if($_GET[\"cat\"]==\"32\"){ $page=\"kids\"; }if($_GET[\"cat\"]==\"21\"){ $page=\"action\"; }?><\/p><p align=\"right\">\nMostrar por sede\/ciudad: <select name=\"orderbyvenue\" onchange=\"document.location='?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=<?=$_GET[\"order\"]?>&#038;venue=&#8217;+this.options[selectedIndex].value;&#8221;><option value=\"\">Selecciona una sede&#8230;<\/option><? $sql=\"SELECT DISTINCT sala1 FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"'\";\n$result=$link->query(($sql);<br \/>\n$v=0;<br \/>\nwhile($row=mysqli_fetch_assoc($result)){<br \/>\n$salas[$v]=$row[&#8220;sala1&#8243;];<br \/>\n$v++;<br \/>\n}<br \/>\n$sql=&#8221;SELECT DISTINCT sala2 FROM peliculas WHERE categoria='&#8221;.$_GET[&#8220;cat&#8221;].&#8221;&#8216;&#8221;;<br \/>\n$result=$link->query($sql);<br \/>\nwhile($row=mysqli_fetch_assoc($result)){<br \/>\n$salas[$v]=$row[&#8220;sala2&#8221;];<br \/>\n$v++;<br \/>\n}<br \/>\n$sql=&#8221;SELECT * FROM salas WHERE &#8220;;<br \/>\nforeach($salas as $sala){<br \/>\n$sql.=&#8221;id='&#8221;.$sala.&#8221;&#8216; OR &#8220;;<br \/>\n}<br \/>\n$sql.=&#8221;id=&#8217;0&#8217; ORDER BY ciudad,sala&#8221;;<br \/>\n$result=$link->query($sql);<br \/>\nwhile($row=mysqli_fetch_assoc($result)){<br \/>\n?><option value=\"NO NUMERIC NOISE KEY\" 1039 no numeric noise key 1038selected=\"&#8221;selected&#8221;NO NUMERIC NOISE KEY\" 1037><?=$row[\"sala\"]?> (<?=$row[\"ciudad\"]?>)<\/option><? } ?><br \/>\n<\/select>\n<\/p>\n<table cellspacing=\"0\" border=\"0\" cellpadding=\"0\">\n<tr>\n<td align=\"center\"><a href=\"?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=prog&#038;venue=<?=$_GET[\"venue\"]?>&#8220;><strong>PROGRAMA<\/strong><\/a><\/td><td width=\"10\"><\/td>\n<td><a href=\"?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=film&#038;venue=<?=$_GET[\"venue\"]?>&#8220;><strong>PEL&Iacute;CULA<\/strong><\/a><\/td><td width=\"10\"><\/td>\n<td><a href=\"?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=rating&#038;venue=<?=$_GET[\"venue\"]?>&#8220;><strong>CALIFICACI&Oacute;N<\/strong><\/a><\/td><td width=\"10\"><\/td>\n<td><a href=\"?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=comments&#038;venue=<?=$_GET[\"venue\"]?>&#8220;><strong>COMENTARIOS<\/strong><\/a><\/td><td width=\"10\"><\/td>\n<td><a href=\"?page_id=63&#038;cat=<?=$_GET[\"cat\"]?>&#038;order=date&#038;venue=<?=$_GET[\"venue\"]?>&#8220;><strong>PROYECCI&Oacute;N<\/strong><\/a><\/td><\/tr><p><?if(!isset($_GET[\"order\"]) OR $_GET[\"order\"]==\"\"){ $_GET[\"order\"]=\"film\"; }if($_GET[\"order\"]==\"prog\"){ $sql=\"SELECT * FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"' ORDER BY programa\"; }if($_GET[\"order\"]==\"film\"){ $sql=\"SELECT * FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"' ORDER BY titulo_en\"; }if($_GET[\"order\"]==\"rating\"){ $sql=\"SELECT * FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"' ORDER BY rating DESC\"; }if($_GET[\"order\"]==\"comments\"){ $sql=\"SELECT * FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"' ORDER BY numcomentarios DESC\"; }if($_GET[\"order\"]==\"date\"){ $sql=\"SELECT * FROM peliculas WHERE categoria='\".$_GET[\"cat\"].\"' ORDER BY fecha1\"; }if(isset($_GET[\"venue\"]) AND $_GET[\"venue\"]!=\"\"){ $sql=str_replace(\"ORDER BY\",\" AND (sala1='\".$_GET[\"venue\"].\"' OR sala2='\".$_GET[\"venue\"].\"') ORDER BY\",$sql); }$result=$link->query($sql);<br \/>$bgor=1;<br \/>while($row=mysqli_fetch_assoc($result)){<br \/>$sq=&#8221;SELECT * FROM programas WHERE id='&#8221;.$row[&#8220;programa&#8221;].&#8221;&#8216;&#8221;;<br \/>$re=$link->query($sq);<br \/>$ro=mysqli_fetch_assoc($re);<br \/>$mes1=$row[&#8220;fecha1&#8221;][0];<br \/>$mes2=$row[&#8220;fecha2&#8221;][0];<br \/>$dia1=$row[&#8220;fecha1&#8221;][1].$row[&#8220;fecha1&#8221;][2];<br \/>$dia2=$row[&#8220;fecha2&#8221;][1].$row[&#8220;fecha2&#8221;][2];<br \/>$hora1=$row[&#8220;fecha1&#8221;][3].$row[&#8220;fecha1&#8221;][4];<br \/>$hora2=$row[&#8220;fecha2&#8221;][3].$row[&#8220;fecha2&#8221;][4];<br \/>$minuto1=$row[&#8220;fecha1&#8221;][5].$row[&#8220;fecha1&#8221;][6];<br \/>$minuto2=$row[&#8220;fecha2&#8221;][5].$row[&#8220;fecha2&#8243;][6];<br \/>$sala1=&#8221;SELECT * FROM salas WHERE id='&#8221;.$row[&#8220;sala1&#8243;].&#8221;&#8216;&#8221;;<br \/>$sala1=$link->query($sala1);<br \/>$sala1=mysqli_fetch_assoc($sala1);<br \/>$sala1=$sala1[&#8220;sala&#8221;];<br \/>$sala2=&#8221;SELECT * FROM salas WHERE id='&#8221;.$row[&#8220;sala2&#8243;].&#8221;&#8216;&#8221;;<br \/>$sala2=$link->query($sala2);<br \/>$sala2=mysqli_fetch_assoc($sala2);<br \/>$sala2=$sala2[&#8220;sala&#8221;];<br \/>if($bgor==1){ $bg=&#8221;FFFFFF&#8221;; }<br \/>if($bgor==2){ $bg=&#8221;EEEEEE&#8221;; $bgor=0;}<br \/>?><\/p><tr bgcolor=\"#no numeric noise key 1022&#8220;><\/p>\n<td><?=$ro[\"programa\"]?><\/td>\n<td><\/td>\n<td><a href=\"?page_id=353&#038;film=<?=$row[\"id\"]?>&#8220;><strong><?=strtoupper($row[\"titulo_es\"])?><\/strong><\/a><Br \/><?=substr($row[\"sinopsis_es\"],0,150)?>&#8230;<\/td><td><\/td><td><img decoding=\"async\" src=\"films\/avg-<?=round($row[\"rating\"])?>.png&#8221;><br \/>(<?=$row[\"numrates\"]?> votos)<\/td><td><\/td><td><?=$row[\"numcomentarios\"]?> comentarios<\/td><td><\/td><td><? if($row[\"fecha1\"]!=\"7230000\"){ ?><img decoding=\"> <?=$dia1?>\/<?=$mes1?> <?=$hora1?>:<?=$minuto1?><br \/><?=$sala1?><br \/><? } if($row[\"fecha2\"]!=\"7230000\"){ ?><img decoding=\"async\" src=\"films\/calendar_icon.gif\"> <?=$dia2?>\/<?=$mes2?> <?=$hora2?>:<?=$minuto2?><br \/><?=$sala2?><? } ?><\/td>\n<\/tr>\n<p><? \n$bgor++;\n} ?><br \/>\n<\/table>\n<p><? } ?>\n<\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-8052","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/pages\/8052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/comments?post=8052"}],"version-history":[{"count":19,"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/pages\/8052\/revisions"}],"predecessor-version":[{"id":27671,"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/pages\/8052\/revisions\/27671"}],"wp:attachment":[{"href":"https:\/\/giff.mx\/en\/wp-json\/wp\/v2\/media?parent=8052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}