$busqueda = $_GET["busqueda"]; $tipo = $_GET["tipo"]; $tema = $_GET["tema"]; $order = $_GET["order"]; $hot = $_GET["hot"]; $formato = $_GET["fallo"]; $urlactual = $_SERVER["REQUEST_URI"]; $urlactual = str_replace("calendar_ult.php","calendar_ult_bb.php",$urlactual); include ("bloques/cabecera.php"); include("my_pagina_class.php"); include ("calendario.php"); $test = new MyPagina; $orden = $order; switch ($order) { case "imdb": $order="IMDB"; break; case "imdbd": $order="IMDB DESC"; break; case "valid": $order="ficha"; break; case "validd": $order="ficha DESC"; break; case "rev": $order="corregir"; break; case "revd": $order="corregir DESC"; break; case "ulti": $order="id"; break; case "ultid": $order="id DESC"; break; case "mod": $order="fechamod, id"; break; case "modd": $order="fechamod DESC, id DESC"; break; case "fecha": $order="fecha"; break; case "fechad": $order="fecha DESC"; break; case "dist": $order="distribuidora"; break; case "distd": $order="distribuidora DESC"; break; case "tit": $order="titulo"; break; case "titd": $order="titulo DESC"; break; case NULL: $order="id DESC"; break; default: $order="id DESC"; } switch ($tema) { case "dvd": $muestra="SELECT * FROM prueba WHERE (formato='DVD Video' AND titulo LIKE '%$busqueda%') or (formato='DVD Video' AND distribuidora LIKE '%$busqueda%') or (formato='DVD Video' AND director LIKE '%$busqueda%') or (formato='DVD Video' AND original LIKE '%$busqueda%') or (formato='DVD Video' AND interpretes LIKE '%$busqueda%') or (formato='DVD Video' AND fecha LIKE '%$busqueda%')"; break; case "alquiler": $muestra="SELECT * FROM prueba WHERE (formato='Alquiler' AND titulo LIKE '%$busqueda%') or (formato='Alquiler' AND distribuidora LIKE '%$busqueda%') or (formato='Alquiler' AND director LIKE '%$busqueda%') or (formato='Alquiler' AND original LIKE '%$busqueda%') or (formato='Alquiler' AND interpretes LIKE '%$busqueda%') or (formato='Alquiler' AND fecha LIKE '%$busqueda%')"; break; case "hd": $muestra="SELECT * FROM prueba WHERE (formato='HD-DVD' AND titulo LIKE '%$busqueda%') or (formato='HD-DVD' AND distribuidora LIKE '%$busqueda%') or (formato='HD-DVD' AND director LIKE '%$busqueda%') or (formato='HD-DVD' AND original LIKE '%$busqueda%') or (formato='HD-DVD' AND interpretes LIKE '%$busqueda%') or (formato='HD-DVD' AND fecha LIKE '%$busqueda%')"; break; case "bd": $muestra="SELECT * FROM prueba WHERE (formato='Blu-Ray' AND titulo LIKE '%$busqueda%') or (formato='Blu-Ray' AND distribuidora LIKE '%$busqueda%') or (formato='Blu-Ray' AND director LIKE '%$busqueda%') or (formato='Blu-Ray' AND original LIKE '%$busqueda%') or (formato='Blu-Ray' AND interpretes LIKE '%$busqueda%') or (formato='Blu-Ray' AND fecha LIKE '%$busqueda%')"; break; case "cine": $muestra="SELECT * FROM prueba WHERE (formato='Cine' AND titulo LIKE '%$busqueda%') or (formato='Cine' AND distribuidora LIKE '%$busqueda%') or (formato='Cine' AND director LIKE '%$busqueda%') or (formato='Cine' AND original LIKE '%$busqueda%') or (formato='Cine' AND interpretes LIKE '%$busqueda%') or (formato='Cine' AND fecha LIKE '%$busqueda%')"; break; default: $muestra="SELECT * FROM prueba WHERE (titulo LIKE '%$busqueda%') or (distribuidora LIKE '%$busqueda%') or (director LIKE '%$busqueda%') or (original LIKE '%$busqueda%') or (interpretes LIKE '%$busqueda%') or (fecha LIKE '%$busqueda%')"; } switch ($tema) { case NULL: $tema2 = "!='Cine'"; $sufijo = "todo"; break; case "bd": $tema2 = "='Blu-Ray'"; $tema3 = "Blu-Ray"; $sufijo = "bd"; break; case "hd": $tema2 = "='HD-DVD'"; $tema3 = "HD-DVD"; $sufijo = "hd"; break; case "dvd": $tema2 = "='DVD Video'"; $tema3 = "DVD"; $sufijo = "dvd"; break; case "alquiler": $tema2 = "='Alquiler'"; $tema3 = "DVD alquiler"; $sufijo = "alquiler"; break; case "cine": $tema2 = "='Cine'"; $tema3 = "Cine"; $sufijo = "cine"; break; default: $tema2 = "!='Cine'"; $sufijo = "todo"; } if ($hot) { $test->sql = "SELECT * FROM prueba WHERE formato$tema2 AND hot='$hot' ORDER BY $order"; } if ($animacion) { $test->sql = "SELECT * FROM prueba WHERE formato$tema2 AND animacion='$animacion' ORDER BY $order"; } if ($fallo) { $test->sql = "SELECT * FROM prueba WHERE formato$tema2 AND fallo='$fallo' ORDER BY $order"; } if ($tipo) { $test->sql = "SELECT * FROM prueba WHERE formato$tema2 AND tipo='$tipo' ORDER BY $order"; } if ($hot==NULL and $fallo==NULL and $tipo==NULL) { if ($tema=="dvd" or $tema=="todo") { $test->sql = "$muestra ORDER BY $order"; } else { $test->sql = "$muestra ORDER BY $order"; } } $result = $test->get_page_result(); // result set $num_rows = $test->get_page_num_rows(); // number of records in result set $nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $test->page_info("to"); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images $total_recs = $test->get_total_rows(); // the total number of records print "
Compras: |
Audio / Video | Tiendas españolas: | Envío internacional: | Merchandising: | Otros: |
Libros de cine Bandas sonoras Hardware en PC-CITY Cine en eBay |
Redcoon PriceMinister |
DVDGO FNAC Carrefour Iberlibro |
Amazon CDWOW! DeepDiscountDVD DVDBoxOffice YesAsia |
Posters Point AllPosters |
Videojuegos en Play-Asia Reserva de entradas Consumibles grabables Vuelos baratos |
index-dvd.com es un proyecto desarrollado y mantenido por HDBits.es - todos los derechos reservados. |