//conexion a la base de datos
$host="localhost";
$user="u926433555_peliculatorcom";
$pass="Internett120";
$db="u926433555_peliculatorcom";
//conectamos con la base de datos
$con=mysqli_connect($host,$user,$pass);
$db_select = mysqli_select_db($con, $db);
mysqli_query($con,"SET NAMES utf8");//me faltaba esta linea!!!! :) eSTA MODIFICA EL character_set_system (comprobar: SHOW VARIABLES LIKE 'char%'; EN SQL)
?>
if(isset($_SESSION['usuario_nombre'])) {
?>
$nota = $_GET['nota'];
$cid = $_GET['cid'];
include('docs/connect.php');
$result = "SELECT * FROM pppeliculator_categorias where id='$cid'";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
echo "
Películas Recomendadas de ($array[cid]) ";
echo "
Películas Recomendadas de $array[cid]
";
}
$result = "SELECT COUNT(*) FROM pppeliculator where cid='$cid'";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
echo "
$array[0] Películas en esta Categoria
";
}
echo "
";
//PAGINADOR
include('docs/connect.php');
$result = mysqli_query($con, "select * FROM pppeliculator where cid='$cid' order by nota desc");
$num_registros = mysqli_num_rows($result);
//Limito la busqueda
$TAMANO_PAGINA = 70;
//examino la p�gina a mostrar y el inicio del registro a mostrar
$pagina = $_GET["pag"];
if (!$pagina) {
$inicio = 0;
$pagina=1;
}
else {
$inicio = ($pagina - 1) * $TAMANO_PAGINA;
}
$result2=mysqli_query($con, "select * FROM pppeliculator where cid='$cid' order by nota desc LIMIT $inicio,$TAMANO_PAGINA;");
$paginas = ceil($num_registros / $TAMANO_PAGINA);
?>
echo "
";
}else{
$nota = $_GET['nota'];
$cid = $_GET['cid'];
include('docs/connect.php');
$result = "SELECT * FROM pppeliculator_categorias where id='$cid'";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
echo "Películas de ($array[cid]) ";
echo "
Películas de $array[cid]
";
}
$result = "SELECT COUNT(*) FROM pppeliculator where cid='$cid'";
$cad = mysqli_query($con,$result) or die (mysqli_error());
while ($array = mysqli_fetch_array($cad))
{
echo "
$array[0] Películas en esta Categoria
";
}
echo "
";
//PAGINADOR
include('docs/connect.php');
$result = mysqli_query($con, "select * FROM pppeliculator where cid='$cid' order by nota desc");
$num_registros = mysqli_num_rows($result);
//Limito la busqueda
$TAMANO_PAGINA =70;
//examino la p�gina a mostrar y el inicio del registro a mostrar
$pagina = $_GET["pag"];
if (!$pagina) {
$inicio = 0;
$pagina=1;
}
else {
$inicio = ($pagina - 1) * $TAMANO_PAGINA;
}
$result2=mysqli_query($con, "select * FROM pppeliculator where cid='$cid' order by nota desc LIMIT $inicio,$TAMANO_PAGINA;");
$paginas = ceil($num_registros / $TAMANO_PAGINA);
?>
echo "