{"id":148,"date":"2014-07-24T06:43:39","date_gmt":"2014-07-24T06:43:39","guid":{"rendered":"http:\/\/servicios.unileon.es\/radio-universitaria\/?page_id=148"},"modified":"2014-07-24T06:44:44","modified_gmt":"2014-07-24T06:44:44","slug":"historico-de-programas-en-radio-universitaria","status":"publish","type":"page","link":"https:\/\/servicios.unileon.es\/radio-universitaria\/historico-de-programas-en-radio-universitaria\/","title":{"rendered":"Hist\u00f3rico de programas en Radio Universitaria"},"content":{"rendered":"<?php\r\n\r\ndate_default_timezone_set('Europe\/Madrid');\r\n\r\n\t$host = \"193.146.101.121\";\r\n\t$database = \"airtime\";\r\n\t$usuario = \"postgres\";\r\n\t$contrasena = \"2013pEtErbishop2013\";\r\n\r\n\t$pdo = new PDO(\"pgsql:host=$host;port=5432;dbname=$database;user=$usuario;password=$contrasena\");\r\n\r\n\t$stmt = $pdo->prepare(\u00abSELECT DISTINCT \\\u00bbpublic\\\u00bb.cc_show.\\\u00bbname\\\u00bb, \\\u00bbpublic\\\u00bb.cc_show.url FROM \\\u00bbpublic\\\u00bb.cc_show ORDER BY \\\u00bbpublic\\\u00bb.cc_show.\\\u00bbname\\\u00bb ASC\u00bb);\r\n\r\n\t$stmt->execute();\r\n\r\n\t$count = $stmt->rowCount();\r\n\t$index = 0;\r\n\r\n\techo \u00ab<div class=\\\"aligncenter\\\">\\n\u00bb;\r\n\techo \u00ab<table class='extendida'>\\n<thead><tr><td>Programa<\/td><\/tr><\/thead>\\n<tbody>\\n\u00bb;\r\n\twhile($datos = $stmt->fetch()) {\r\n\t\tif (trim($datos[&#8216;url&#8217;]) == \u00ab\u00bb) {\r\n\t\t} else {\r\n\t\t\techo \u00ab<tr>\u00ab;\r\n\t\t\techo \u00ab<td><a href=\\\"\".$datos['url'].\"\\\">\u00ab.$datos[&#8216;name&#8217;].\u00bb<\/a><\/td>\u00ab;\r\n\t\t\techo \u00ab<\/tr>\\n\u00bb;\r\n\t\t}\r\n\t}\r\n\r\n\techo \u00ab<\/tbody>\\n<\/table>\\n<\/div>\\n\u00bb;\r\n\r\n?>","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-148","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/pages\/148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":6,"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/pages\/148\/revisions"}],"predecessor-version":[{"id":155,"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/pages\/148\/revisions\/155"}],"wp:attachment":[{"href":"https:\/\/servicios.unileon.es\/radio-universitaria\/wp-json\/wp\/v2\/media?parent=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}