[Resolvido] mysql_num_rows

PF2G · June 12, 2012 at 11:10 AM

Boas,

estou a fazer um galeria de imagens usando .htaccess

gallery.php:

 // we get the current page from $_GET
 if (isset($_GET['page'])){
  $page_number = (int) $_GET['page'];
 }

 list($tax_name, $tax_id) = explode("-", $page);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 ORDER BY id ASC");
 $total_records = mysql_num_rows($result_content);

 // create the pagination class
 $pagination = new Pagination();
 $pagination->setLink($current_lang."/product/all?page=%s");
 $pagination->setPage($page_number);
 $pagination->setSize($size);
 $pagination->setTotalRecords($total_records);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 " . $pagination->getLimitSql());
 $row_content=mysql_fetch_assoc($result_content);

 $res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");
 $navigation = $pagination->create_links();

}
}
$num_rows_content = mysql_num_rows($res_cont);
$conta_rows_content = 1;
$content = "";

e este pedaço de código dá-me erro no mysql_num_row:

Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:\wamp\www\www.iberveda.com\pages\gallery.php on line 67

Alguém me pode ajudar?

Obrigado,

PF2G

Edited June 12, 2012 at 05:30 PM by scorch
Adicionado Geshi.

pikax · June 12, 2012 at 11:19 AM

alguma destas chavetas fazem parte de algum if?

}
}
$num_rows_content = mysql_num_rows($res_cont);

PF2G · June 12, 2012 at 11:33 AM

Sim:

if($page == "all"){
$page_number = 1;

// how many records per page
$size = 8;

// we get the current page from $_GET
if (isset($_GET['page'])){
 $page_number = (int) $_GET['page'];
}
$result_content=mysql_query("SELECT * FROM album_images WHERE visivel=1 ORDER BY posicao ASC");
$total_records = mysql_num_rows($result_content);

$res_imagem=mysql_query("SELECT * FROM album_images_lang WHERE lang='".$current_lang."' AND id_image='".$total_records['id']."'");
$imagem=mysql_fetch_assoc($res_imagem);

// create the pagination class
$pagination = new Pagination();
$pagination->setLink($current_lang."/product/all?page=%s");
$pagination->setPage($page_number);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);

$result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='estúdio' AND lang='$current_lang' AND visivel=1 ORDER BY posicao ASC " . $pagination->getLimitSql());

$navigation = $pagination->create_links();
}else{
if($clean_url[2]!="all"){
 $result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='".$clean_url[2]."' AND lang='$current_lang' AND visivel=1 ORDER BY id ASSC");
}else{

 $page_number = 1;

 // how many records per page
 $size = 8;

 // we get the current page from $_GET
 if (isset($_GET['page'])){
  $page_number = (int) $_GET['page'];
 }

 list($tax_name, $tax_id) = explode("-", $page);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 ORDER BY id ASC");
 $total_records = mysql_num_rows($result_content);

 // create the pagination class
 $pagination = new Pagination();
 $pagination->setLink($current_lang."/product/all?page=%s");
 $pagination->setPage($page_number);
 $pagination->setSize($size);
 $pagination->setTotalRecords($total_records);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 " . $pagination->getLimitSql());

 $res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");
 $navigation = $pagination->create_links();

}
}
$num_rows_content = mysql_num_rows($res_cont);
$conta_rows_content = 1;
$content = "";

pikax · June 12, 2012 at 11:36 AM

se a pagina for igual a "all", entao o $res_cont nao ira' ser resultado da query, que significa que vai te dar aquele warning, passa isso para

$res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");

$navigation = $pagination->create_links();

$num_rows_content = mysql_num_rows($res_cont);

}

PF2G · June 12, 2012 at 11:45 AM

se a pagina for igual a "all", entao o $res_cont nao ira' ser resultado da query, que significa que vai te dar aquele warning, passa isso para

$res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");

$navigation = $pagination->create_links();

$num_rows_content = mysql_num_rows($res_cont);

}

}

Mas depois não o $num_row_content:

$res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");
$navigation = $pagination->create_links();
$num_rows_content = mysql_num_rows($res_cont);
}
}
$conta_rows_content = 1;
$content = "";
if($num_rows_content > 0 || $page == "all"){

pikax · June 12, 2012 at 11:48 AM

em vez de $num_rows_content > 0 mete:

if(isset($num_rows_content) || $page=="all")

EDIT: ou inicias o $num_rows_content a 0 antes do primeiro if!

Edited June 12, 2012 at 11:48 AM by pikax

PF2G · June 12, 2012 at 11:57 AM

em vez de $num_rows_content > 0 mete:
if(isset($num_rows_content) || $page=="all")
EDIT: ou inicias o $num_rows_content a 0 antes do primeiro if!

Ja não aparece o erro 🙂

Obrigado.

Ja agora podes-me explicar pq usaste o isset? Eu decorei a utilização do isset apenas no submit de forms, mas nunca percebi para que serve. :S

Cumprimentos,

PF2G

pikax · June 12, 2012 at 11:59 AM

o isset serve para ver se a variavel existe

PF2G · June 12, 2012 at 12:01 PM

Ahhh ok, obrigado. 😉

Edited June 12, 2012 at 01:39 PM by PF2G

PF2G · June 12, 2012 at 01:39 PM

Agora tenho o mesmo erro neste código, ja andei as voltas ver nomes errados e não vejo nada de mal:

$conta_rows_content = 1;
$content = "";
$num_rows_content=0;
if($num_rows_content || $page=="all"){
echo '<div class="content" id="page">
<div class="container">
<div class="interior_page" style="border-bottom:0px;">';
if($page == "all"){
$pageTitle="GALERIA";
}else{
if(isset($clean_url[3]) && $clean_url != ""){
$pageTitle = $row_content->titulo;
}else{
$result_tax_titulo = mysql_query("SELECT * FROM album_images WHERE id='". $tax_id."' LIMIT 0,1");
$row_tax_titulo = mysql_fetch_object($result_tax_titulo);

$pageTitle = $row_tax_titulo->title;
}
}
}

if ($num_rows_content > 1 || $page == "all" || !isset($clean_url[3])){

//Se existir mais que um produto apresenta a listagem de todos os existentes

echo '<div id="products">';
echo "<h1 class='title'>".$pageTitle."</h1>";

echo '<div class="produts_list">';

$count_products = 1;

while($row_products = mysql_fetch_assoc($result_content)){
$extra = unserialize(base64_decode($row_products->extra));

$clean_descricao = strip_tags($row_products->descricao);

$result_tax = mysql_query("SELECT * FROM album_images WHERE id='".$row_products->taxonomy_id."' LIMIT 0,1");
$row_tax = mysql_fetch_object($result_tax);

if($count_products == 2)
echo '<div class="product last">';
else
echo '<div class="product">';
if($extra['capa'] != "")
echo '<a href="'.$current_lang.'/product/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->$clean_url.'">'.image_preset($extra['capa'], 'thumb_products', 'align="left"')."</a>";
echo '<label class="titulo"><a href="'.$current_lang.'/product/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->url.'">'.$row_products->titulo.'</a></label>';
echo '<label class="tax"><a href="'.$current_lang.'/product/'.$row_tax->link."-".$row_tax->id.'">'.$row_tax->title.'</a></label>';

echo '<label class="descricao">'.substr($clean_descricao, 0 ,120);
if(strlen($clean_descricao) > 120)
echo "(...)";
echo '</label>';
echo '</div>';

if($count_products == 2)
$count_products = 1;
else
$count_products++;
}

O erro é no while:

while($row_products = mysql_fetch_assoc($result_content)){

Edited June 12, 2012 at 01:44 PM by PF2G

HappyHippyHippo · June 12, 2012 at 01:46 PM

com essa indentação, sem identificar a linha do erro, eu não encontrei nenhum chamada à função mysql_num_rows() ...

PF2G · June 12, 2012 at 01:50 PM

Desculpa estava na parte de cima:

if($page == "all"){
$page_number = 1;

// how many records per page
$size = 8;

// we get the current page from $_GET
if (isset($_GET['page'])){
 $page_number = (int) $_GET['page'];
}
$result_content=mysql_query("SELECT * FROM album_images WHERE visivel=1 ORDER BY posicao ASC");
$total_records = mysql_num_rows($result_content);

$res_imagem=mysql_query("SELECT * FROM album_images_lang WHERE lang='".$current_lang."' AND id_image='".$total_records['id']."'");
$imagem=mysql_fetch_assoc($res_imagem);

// create the pagination class
$pagination = new Pagination();
$pagination->setLink($current_lang."/gallery/all?page=%s");
$pagination->setPage($page_number);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);

$result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='estúdio' AND lang='$current_lang' AND visivel=1 ORDER BY posicao ASC " . $pagination->getLimitSql());

$navigation = $pagination->create_links();
}else{
if($clean_url[2]!="all"){
 $result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='".$clean_url[2]."' AND lang='$current_lang' AND visivel=1 ORDER BY id ASSC");
}else{

 $page_number = 1;

 // how many records per page
 $size = 8;

 // we get the current page from $_GET
 if (isset($_GET['page'])){
  $page_number = (int) $_GET['page'];
 }

 list($tax_name, $tax_id) = explode("-", $page);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 ORDER BY id ASC");
 $total_records = mysql_num_rows($result_content);

 // create the pagination class
 $pagination = new Pagination();
 $pagination->setLink($current_lang."/gallery/all?page=%s");
 $pagination->setPage($page_number);
 $pagination->setSize($size);
 $pagination->setTotalRecords($total_records);

 $res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");
 $navigation = $pagination->create_links();
 $num_rows_content = mysql_num_rows($res_cont);
}
}
$conta_rows_content = 1;
$content = "";
$num_rows_content=0;
if($num_rows_content || $page=="all"){
echo '<div class="content" id="page">
 <div class="container">
  <div class="interior_page" style="border-bottom:0px;">';
   if($page == "all"){
    $pageTitle="GALERIA";
   }else{
    if(isset($clean_url[3]) && $clean_url != ""){
	 $pageTitle = $row_content->titulo;
    }else{
	 $result_tax_titulo = mysql_query("SELECT * FROM album_images WHERE id='". $tax_id."' LIMIT 0,1");
	 $row_tax_titulo = mysql_fetch_object($result_tax_titulo);

	 $pageTitle = $row_tax_titulo->title;
    }
   }
   }

   if ($num_rows_content > 1 || $page == "all" || !isset($clean_url[3])){

    //Se existir mais que um produto apresenta a listagem de todos os existentes

    echo '<div id="products">';
	 echo "<h1 class='title'>".$pageTitle."</h1>";

	 echo '<div class="produts_list">';

	 $count_products = 1;

	 while($row_products = mysql_fetch_assoc($result_content)){
	  $extra = unserialize(base64_decode($row_products->extra));

	  $clean_descricao = strip_tags($row_products->descricao);

	  $result_tax = mysql_query("SELECT * FROM album_images WHERE id='".$row_products->taxonomy_id."' LIMIT 0,1");
	  $row_tax = mysql_fetch_object($result_tax);

	  if($count_products == 2)
	   echo '<div class="product last">';
	  else
	   echo '<div class="product">';
	   if($extra['capa'] != "")
	    echo '<a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->$clean_url.'">'.image_preset($extra['capa'], 'thumb_products', 'align="left"')."</a>";
	   echo '<label class="titulo"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->url.'">'.$row_products->titulo.'</a></label>';
	   echo '<label class="tax"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'">'.$row_tax->title.'</a></label>';

	   echo '<label class="descricao">'.substr($clean_descricao, 0 ,120);
	    if(strlen($clean_descricao) > 120)
		 echo "(...)";
	   echo '</label>';
	  echo '</div>';

	  if($count_products == 2)
	   $count_products = 1;
	  else
	   $count_products++;
	 }

HappyHippyHippo · June 12, 2012 at 01:59 PM

com este código

$result_content=mysql_query("SELECT * FROM album_images WHERE visivel=1 ORDER BY posicao ASC");
$total_records = mysql_num_rows($result_content);

só posso concluir uma coisa ... tens erro de SQL.

adiciona a linha seguinte entre as duas linhas

echo mysql_error();

PF2G · June 12, 2012 at 02:04 PM

com este código
$result_content=mysql_query("SELECT * FROM album_images WHERE visivel=1 ORDER BY posicao ASC");
$total_records = mysql_num_rows($result_content);
só posso concluir uma coisa ... tens erro de SQL.

adiciona a linha seguinte entre as duas linhas
echo mysql_error();

Ei que estupidez. No inicio fartei-me de mudar 'posicao' para 'id' e escapou-me esse :S

Obrigado. Em principio ja deve estar 100%.

PF2G · June 12, 2012 at 02:22 PM

Será que alguém me pode ajudar? É a primeira vez que mexo com codigo deste género (.htaccess) e está-me a confundir um pouco.

Eu quero criar uma galeria de imagens se o $clean_url[2]='all' aparecem as imagens todas se não aparecem as imagens cujo titulo = $clean_url[2].

Já não me está a dar erro nenhum, o unico problema é que nao aparecem as imagens:

<?php
if($page == "all"){
$page_number = 1;

// how many records per page
$size = 8;

// we get the current page from $_GET
if (isset($_GET['page'])){
 $page_number = (int) $_GET['page'];
}
$result_content=mysql_query("SELECT * FROM album_lang WHERE visivel=1 AND lang='".$current_lang."'");
$total_records = mysql_num_rows($result_content);

$result_image=mysql_query("SELECT * FROM album_images WHERE id_projecto='".$total_records['id_projecto']."'");
$total_images=mysql_num_rows($result_image);

$res_imagem=mysql_query("SELECT * FROM album_images_lang WHERE lang='".$current_lang."' AND id_image='".$total_images['id']."'");
$imagem=mysql_fetch_assoc($res_imagem);

// create the pagination class
$pagination = new Pagination();
$pagination->setLink($current_lang."/gallery/all?page=%s");
$pagination->setPage($page_number);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);

$result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='estúdio' AND lang='$current_lang' AND visivel=1 ORDER BY id ASC " . $pagination->getLimitSql());
echo mysql_error();
$navigation = $pagination->create_links();
}else{
if($clean_url[2]!="all"){
 $result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='".$clean_url[2]."' AND lang='$current_lang' AND visivel=1 ORDER BY id ASSC");
}else{

 $page_number = 1;

 // how many records per page
 $size = 8;

 // we get the current page from $_GET
 if (isset($_GET['page'])){
  $page_number = (int) $_GET['page'];
 }

 list($tax_name, $tax_id) = explode("-", $page);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 ORDER BY id ASC");

 $total_records = mysql_num_rows($result_content);

 // create the pagination class
 $pagination = new Pagination();
 $pagination->setLink($current_lang."/gallery/all?page=%s");
 $pagination->setPage($page_number);
 $pagination->setSize($size);
 $pagination->setTotalRecords($total_records);

 $res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");

 $navigation = $pagination->create_links();
 $num_rows_content = mysql_num_rows($res_cont);
}
}
$conta_rows_content = 1;
$content = "";
$num_rows_content=0;
if($num_rows_content || $page=="all"){
echo '<div class="content" id="page">
 <div class="container">
  <div class="interior_page" style="border-bottom:0px;">';
   if($page == "all"){
    $pageTitle="GALERIA";
   }else{
    if(isset($clean_url[3]) && $clean_url != ""){
	 $pageTitle = $row_content->titulo;
    }else{
	 $result_tax_titulo = mysql_query("SELECT * FROM album_images WHERE id='". $tax_id."' LIMIT 0,1");
	 $row_tax_titulo = mysql_fetch_object($result_tax_titulo);

	 $pageTitle = $row_tax_titulo->title;
    }
   }

   if ($num_rows_content > 1 || $page == "all" || !isset($clean_url[3])){

    //Se existir mais que um produto apresenta a listagem de todos os existentes

    echo '<div id="products">';
	 echo "<h1 class='title'>".$pageTitle."</h1>";

	 echo '<div class="produts_list">';

	 $count_products = 1;

	 while($row_products = mysql_fetch_assoc($result_content)){
	  $extra = unserialize(base64_decode($row_products->extra));

	  $clean_descricao = strip_tags($row_products->descricao);

	  $result_tax = mysql_query("SELECT * FROM album_images WHERE id='".$row_products->taxonomy_id."' LIMIT 0,1");
	  $row_tax = mysql_fetch_object($result_tax);

	  if($count_products == 2)
	   echo '<div class="product last">';
	  else
	   echo '<div class="product">';
	   if($extra['imagem'] != "")
	    echo '<a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->$clean_url.'">'.image_preset($extra['imagem'], 'thumb_products', 'align="left"')."</a>";
	   echo '<label class="titulo"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->url.'">'.$row_products->titulo.'</a></label>';
	   echo '<label class="tax"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'">'.$row_tax->title.'</a></label>';

	   echo '<label class="descricao">'.substr($clean_descricao, 0 ,120);
	    if(strlen($clean_descricao) > 120)
		 echo "(...)";
	   echo '</label>';
	  echo '</div>';

	  if($count_products == 2)
	   $count_products = 1;
	  else
	   $count_products++;

	 }

	 echo '<div class="clearfloat"></div>';
	 echo $navigation; // will draw our page navigation
	 echo '<div class="clearfloat"></div>';
	 echo '</div>';

    echo '</div>';

   }else{
    //Se apenas existir um produto mostra logo a página do mesmo e não a listagem

    $row_products = mysql_fetch_assoc($result_content);
    $extra = unserialize(base64_decode($row_products->extra));

    $pageTitle = $row_products->titulo;

    echo '<div id="products">';


	 echo '<div class="product_details">';
	  echo '<div class="extras">';
	   echo '<div class="images">';
	    if($extra['imagem'] != "")
	    echo '<a href="'.$extra['imagem'].'" rel="group" title="'.$pageTitle.'">'.image_preset($extra['imagem'], 'thumb_image', 'align="left" alt="'.$pageTitle.'"').'</a>';
	   echo '</div>';

	   $result_moresimages = mysql_query("SELECT ni.id, ni.imagem, ni.visivel, nil.titulo FROM `album_images` as ni, `album_images_lang` as nil
	   WHERE ni.id = nil.id_image AND nil.lang='$current_lang' AND ni.visivel=1 AND nil.visivel=1
	   AND ni.nid = ".$row_products->id." ORDER BY ni.posicao ASC");
	   if(mysql_num_rows($result_moresimages) > 0){
	    echo '<div class="more_images">';
		 echo '<ul>';
		 while($row_moreimages = mysql_fetch_object($result_moresimages)){
		  echo '<li><a href="'.$row_moreimages->imagem.'" rel="group" title="'.$row_moreimages->titulo.'">'.image_preset($row_moreimages->imagem, 'thumb_miniimage', 'align="left" alt="'.$row_moreimages->titulo.'"').'</a></li>';
		 }
		 echo '</ul>';
		 echo '<div class="clearfloat"></div>';
	    echo '</div>';
	   }

	   if($extra['anexo'] != "")
	    echo '<a href="'.$extra['anexo'].'" class="bt_maisinformacoes" target="_blank">DESCARREGUE O CATÁLOGO EM PDF</a>';


	  echo '</div>';

	  echo '<div class="descricao">';
	   echo "<h1 class='title'>".$pageTitle."</h1>";
	   echo $row_products->descricao;
	  echo '</div>';
	  echo '<div class="clearfloat"></div>';
	 echo '</div>';

    echo '</div>';

   }
   echo '<div class="clearfloat"></div>';
  echo  '</div>
   <div class="clearfloat"></div>';
echo  '</div>
 </div>';

}else{
header("Status: 404 Not Found");
header( "Location: ".$url."/".$current_lang."/pages/error/404" );
die();
}
?>

HappyHippyHippo · June 12, 2012 at 02:35 PM

só tens de "limpar" o valor quando for "all"

if ($clean_url[2] == "all") $clean_url[2] = "";
$result_content=mysql_query("SELECT * FROM album_lang WHERE titulo like '%".$clean_url[2]."%' AND lang='$current_lang' AND visivel=1 ORDER BY id ASSC");

nota : que alterei o modo de comparação do título, desta forma encontra registos do género >>

pesquisa : "abc"

registo válido : qweasdzxc

PF2G · June 12, 2012 at 02:54 PM

Damn it.

Continua sem me aparecer as imagens e a paginação por isso deve haver alguma query que nao esteja a passar...

<?php
if($clean_url[2] == "all"){
$clean_url[2]=="";
$page_number = 1;

// how many records per page
$size = 8;

// we get the current page from $_GET
if (isset($_GET['page'])){
 $page_number = (int) $_GET['page'];
}
$result_content=mysql_query("SELECT * FROM album_lang WHERE visivel=1 ORDER BY id_projecto ASC");
$total_records = mysql_num_rows($result_content);

$result_cont=mysql_query("SELECT * FROM album_images WHERE id_projecto='".$total_records['id_projecto']."'");
$records_cont=mysql_fetch_assoc($result_cont);

$res_imagem=mysql_query("SELECT * FROM album_images_lang WHERE titulo LIKE '% ".$clean_url[2]." %' AND lang='".$current_lang."' AND id='".$result_cont['id']."'");
$imagem=mysql_fetch_assoc($res_imagem);

// create the pagination class
$pagination = new Pagination();
$pagination->setLink($current_lang."/gallery/all?page=%s");
$pagination->setPage($page_number);
$pagination->setSize($size);
$pagination->setTotalRecords($imagem);

$result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='estúdio' AND lang='$current_lang' AND visivel=1 ORDER BY id ASC " . $pagination->getLimitSql());
echo mysql_error();
$navigation = $pagination->create_links();
}else{
if($clean_url[2]!="all"){
 $result_content=mysql_query("SELECT * FROM album_lang WHERE titulo='".$clean_url[2]."' AND lang='$current_lang' AND visivel=1 ORDER BY id ASSC");
}else{

 $page_number = 1;

 // how many records per page
 $size = 8;

 // we get the current page from $_GET
 if (isset($_GET['page'])){
  $page_number = (int) $_GET['page'];
 }

 list($tax_name, $tax_id) = explode("-", $page);

 $result_content=mysql_query("SELECT * FROM album_images_lang WHERE id_image='".$tax_id."' lang='$current_lang' AND visivel=1 ORDER BY id ASC");

 $total_records = mysql_num_rows($result_content);

 // create the pagination class
 $pagination = new Pagination();
 $pagination->setLink($current_lang."/gallery/all?page=%s");
 $pagination->setPage($page_number);
 $pagination->setSize($size);
 $pagination->setTotalRecords($total_records);

 $res_cont=mysql_query("SELECT * FROM album_images WHERE id='".$row_content['id_image']."' ORDER BY id ASC");

 $navigation = $pagination->create_links();
 $num_rows_content = mysql_num_rows($res_cont);
}
}
$conta_rows_content = 1;
$content = "";
$num_rows_content=0;
if($num_rows_content || $page=="all"){
echo '<div class="content" id="page">
 <div class="container">
  <div class="interior_page" style="border-bottom:0px;">';
   if($page == "all"){
    $pageTitle="GALERIA";
   }else{
    if(isset($clean_url[3]) && $clean_url != ""){
	 $pageTitle = $row_content->titulo;
    }else{
	 $result_tax_titulo = mysql_query("SELECT * FROM album_images WHERE id='". $tax_id."' LIMIT 0,1");
	 $row_tax_titulo = mysql_fetch_object($result_tax_titulo);

	 $pageTitle = $row_tax_titulo->title;
    }
   }

   if ($num_rows_content > 1 || $page == "all" || !isset($clean_url[3])){

    //Se existir mais que um produto apresenta a listagem de todos os existentes

    echo '<div id="products">';
	 echo "<h1 class='title'>".$pageTitle."</h1>";

	 echo '<div class="produts_list">';

	 $count_products = 1;

	 while($row_products = mysql_fetch_assoc($result_content)){
	  $extra = unserialize(base64_decode($row_products->extra));

	  $clean_descricao = strip_tags($row_products->descricao);

	  $result_tax = mysql_query("SELECT * FROM album_images WHERE id='".$row_products->taxonomy_id."' LIMIT 0,1");
	  $row_tax = mysql_fetch_object($result_tax);

	  if($count_products == 2)
	   echo '<div class="product last">';
	  else
	   echo '<div class="product">';
	   if($extra['imagem'] != "")
	    echo '<a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->$clean_url.'">'.image_preset($extra['imagem'], 'thumb_products', 'align="left"')."</a>";
	   echo '<label class="titulo"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'/'.$row_products->url.'">'.$row_products->titulo.'</a></label>';
	   echo '<label class="tax"><a href="'.$current_lang.'/gallery/'.$row_tax->link."-".$row_tax->id.'">'.$row_tax->title.'</a></label>';

	   echo '<label class="descricao">'.substr($clean_descricao, 0 ,120);
	    if(strlen($clean_descricao) > 120)
		 echo "(...)";
	   echo '</label>';
	  echo '</div>';

	  if($count_products == 2)
	   $count_products = 1;
	  else
	   $count_products++;

	 }

	 echo '<div class="clearfloat"></div>';
	 echo $navigation; // will draw our page navigation
	 echo '<div class="clearfloat"></div>';
	 echo '</div>';

    echo '</div>';

   }else{
    //Se apenas existir um produto mostra logo a página do mesmo e não a listagem

    $row_products = mysql_fetch_assoc($result_content);
    $extra = unserialize(base64_decode($row_products->extra));

    $pageTitle = $row_products->titulo;

    echo '<div id="products">';


	 echo '<div class="product_details">';
	  echo '<div class="extras">';
	   echo '<div class="images">';
	    if($extra['imagem'] != "")
	    echo '<a href="'.$extra['imagem'].'" rel="group" title="'.$pageTitle.'">'.image_preset($extra['imagem'], 'thumb_image', 'align="left" alt="'.$pageTitle.'"').'</a>';
	   echo '</div>';

	   $result_moresimages = mysql_query("SELECT ni.id, ni.imagem, ni.visivel, nil.titulo FROM `album_images` as ni, `album_images_lang` as nil
	   WHERE ni.id = nil.id_image AND nil.lang='$current_lang' AND ni.visivel=1 AND nil.visivel=1
	   AND ni.nid = ".$row_products->id." ORDER BY ni.posicao ASC");
	   if(mysql_num_rows($result_moresimages) > 0){
	    echo '<div class="more_images">';
		 echo '<ul>';
		 while($row_moreimages = mysql_fetch_object($result_moresimages)){
		  echo '<li><a href="'.$row_moreimages->imagem.'" rel="group" title="'.$row_moreimages->titulo.'">'.image_preset($row_moreimages->imagem, 'thumb_miniimage', 'align="left" alt="'.$row_moreimages->titulo.'"').'</a></li>';
		 }
		 echo '</ul>';
		 echo '<div class="clearfloat"></div>';
	    echo '</div>';
	   }

	   if($extra['anexo'] != "")
	    echo '<a href="'.$extra['anexo'].'" class="bt_maisinformacoes" target="_blank">DESCARREGUE O CATÁLOGO EM PDF</a>';


	  echo '</div>';

	  echo '<div class="descricao">';
	   echo "<h1 class='title'>".$pageTitle."</h1>";
	   echo $row_products->descricao;
	  echo '</div>';
	  echo '<div class="clearfloat"></div>';
	 echo '</div>';

    echo '</div>';

   }
   echo '<div class="clearfloat"></div>';
  echo  '</div>
   <div class="clearfloat"></div>';
echo  '</div>
 </div>';

}else{
header("Status: 404 Not Found");
header( "Location: ".$url."/".$current_lang."/pages/error/404" );
die();
}
?>

HappyHippyHippo · June 12, 2012 at 03:07 PM

eu ja vi algo que não me agrada muito aqui

$total_records = mysql_num_rows($result_content);
$result_cont=mysql_query("SELECT * FROM album_images WHERE id_projecto='".$total_records['id_projecto']."'");

mas como é melhor ensinar a pescar que dar o peixinho ... adiciona estas linhas de código ao início do teu script

   error_reporting(E_ALL);
   ini_set('display_errors', '1');

depois le as linhas de erro/warning que aparece

corrige até que não apareça nenhuma

PF2G · June 12, 2012 at 03:17 PM

eu ja vi algo que não me agrada muito aqui
$total_records = mysql_num_rows($result_content);
$result_cont=mysql_query("SELECT * FROM album_images WHERE id_projecto='".$total_records['id_projecto']."'");
mas como é melhor ensinar a pescar que dar o peixinho ... adiciona estas linhas de código ao início do teu script
error_reporting(E_ALL);
ini_set('display_errors', '1');
depois le as linhas de erro/warning que aparece

corrige até que não apareça nenhuma

lamento desapontar-te mas não me esta a dar erro nenhum :S

HappyHippyHippo · June 12, 2012 at 03:20 PM

como é possível ???

a primeira função retorna um inteiro (o número de registos do recordset) e depois estás a usar a variável como um array ?!?!

tem que dar algo !!!!

[Resolvido] mysql_num_rows

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Important Information