MPhp / mysql gallery issues
I have made a gallery in php. It receives from an index page an "inname" parameter. The gallery every time it passes from page does not manage to send 2 parameters at the same time and in all inombre. Unparameter of the database "idtext"
Please tell me the mistakes

enter code here

index.php

Lista de Acontecimientos<Br />  <?php $conexion = mysqli_connect("localhost", "root", "") or trigger_error(mysql_error(),E_USER_ERROR); mysqli_select_db($conexion,"db674013292"); $consulta="Select * from textos where clase=1 "; $result=mysqli_query($conexion,$consulta); ?>  <?php  while($fila=mysqli_fetch_row($result)){ echo "<a href=\"H.php?inombre='".$fila['0']."'\">".$fila['1']."</a><br>";    }  ?>

Gallery.php

<?php
$inombre=$_GET['inombre'];

	$objConnect =  mysql_connect("localhost","root","") or die(mysql_error());
	$objDB =  mysql_select_db("db674013292");

	$strSQL = "SELECT * FROM galeriadecidiendo where idtexto =$inombre ";

	$objQuery = mysql_query($strSQL);
	$Num_Rows = mysql_num_rows($objQuery);

	$Per_Page = 8;   // Per Page

	@$Page = $_GET["Page"];
	if(!@$_GET["Page"])
	{
		$Page=1;
	}

	$Prev_Page = $Page-1;
	$Next_Page = $Page+1;

	$Page_Start = (($Per_Page*$Page)-$Per_Page);
	if($Num_Rows<=$Per_Page)
	{
		$Num_Pages =1;
	}
	else if(($Num_Rows % $Per_Page)==0)
	{
		$Num_Pages =($Num_Rows/$Per_Page) ;
	}

	else
	{
		$Num_Pages =($Num_Rows/$Per_Page)+1;
		$Num_Pages = (int)$Num_Pages;
	}

	$strSQL .=" order  by idgaleriatexto ASC LIMIT $Page_Start , $Per_Page";
	$objQuery  = mysql_query($strSQL);


	echo"<table border=\"0\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
	$intRows = 0;
	while($objResult = mysql_fetch_array($objQuery))
	{
		echo "<td>"; 
		$intRows++;
?>

<img with="150" height="150" src="<?=$objResult["url"]; ?>"><br>

<?PHP
echo"</td>";
if(($intRows)%4==0)
{
echo"</tr>";
}
}
echo"</tr></table>";
?>
<br>
<span class="paguinas">Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :</span>

			<?PHP
	if($Prev_Page)
	{
		echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&$inombre=idtexto'><< Back</a> ";
	}

	for($i=1; $i<=$Num_Pages; $i++){
		if($i != $Page)
		{
			echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&$inombre=idtexto'>$i</a> ]";
		}
		else
		{
			echo "<b> $i </b>";
		}
	}
	if($Page!=$Num_Pages)
	{
		echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page$Prev_Page&$inombre=idtexto'>Next>></a> ";
	}
	?>


<?PHP

mysql_close($objConnect);
?>

</body>
</html>

    Hi a few things, you seem to be mixing mysql with mysqli , mysql_ is deprecated now always use either

    PDO
    http://php.net/manual/en/pdo.connections.php

    or

    mysqli_
    http://php.net/manual/en/function.mysqli-connect.php

    Your query's were a little wrong too you can find out more at
    http://php.net/manual/en/mysqli.query.php

    You can learn more about mysqli_num_rows here
    http://php.net/manual/en/mysqli-result.num-rows.php

    As an aside, indentation is important you can read more about it here
    http://mrbool.com/importance-of-code-indentation/29079

    There were a few other things but I guess that's enough for now, it's a good start don't give up 🙂

      Here's the code within this forum's [noparse]

      ...

      [/noparse] tags. It was, in fact, indented, but the OP did not use the forum tags to display nicely. 🙂

       
          Lista de Acontecimientos<Br />  <?php $conexion = mysqli_connect("localhost", "root", "") or trigger_error(mysql_error(),E_USER_ERROR); mysqli_select_db($conexion,"db674013292"); $consulta="Select * from textos where clase=1 "; $result=mysqli_query($conexion,$consulta); ?>  <?php  while($fila=mysqli_fetch_row($result)){ echo "<a href=\"H.php?inombre='".$fila['0']."'\">".$fila['1']."</a><br>";    }  ?>
      
      Gallery.php
      
      
      
      
      <?php
      $inombre=$_GET['inombre'];
      
      	$objConnect =  mysql_connect("localhost","root","") or die(mysql_error());
      	$objDB =  mysql_select_db("db674013292");
      
      	$strSQL = "SELECT * FROM galeriadecidiendo where idtexto =$inombre ";
      
      	$objQuery = mysql_query($strSQL);
      	$Num_Rows = mysql_num_rows($objQuery);
      
      	$Per_Page = 8;   // Per Page
      
      	@$Page = $_GET["Page"];
      	if(!@$_GET["Page"])
      	{
      		$Page=1;
      	}
      
      	$Prev_Page = $Page-1;
      	$Next_Page = $Page+1;
      
      	$Page_Start = (($Per_Page*$Page)-$Per_Page);
      	if($Num_Rows<=$Per_Page)
      	{
      		$Num_Pages =1;
      	}
      	else if(($Num_Rows % $Per_Page)==0)
      	{
      		$Num_Pages =($Num_Rows/$Per_Page) ;
      	}
      
      	else
      	{
      		$Num_Pages =($Num_Rows/$Per_Page)+1;
      		$Num_Pages = (int)$Num_Pages;
      	}
      
      	$strSQL .=" order  by idgaleriatexto ASC LIMIT $Page_Start , $Per_Page";
      	$objQuery  = mysql_query($strSQL);
      
      
      	echo"<table border=\"0\" align=\"center\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
      	$intRows = 0;
      	while($objResult = mysql_fetch_array($objQuery))
      	{
      		echo "<td>"; 
      		$intRows++;
      ?>
      <img with="150" height="150" src="<?=$objResult["url"]; ?>"><br>                 
      <?PHP echo"</td>"; if(($intRows)%4==0) { echo"</tr>"; } } echo"</tr></table>"; ?> <br> <span class="paguinas">Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :</span> <?PHP if($Prev_Page) { echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&$inombre=idtexto'><< Back</a> "; } for($i=1; $i<=$Num_Pages; $i++){ if($i != $Page) { echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&$inombre=idtexto'>$i</a> ]"; } else { echo "<b> $i </b>"; } } if($Page!=$Num_Pages) { echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page$Prev_Page&$inombre=idtexto'>Next>></a> "; } ?> <?PHP mysql_close($objConnect); ?> </body> </html>
        Write a Reply...