Gracias :cool:
Código
<html> <head> <title>ShotDev.Com Tutorial</title> </head> <body> <?php $db_username = ""; $db_password = ""; $db = "oci:dbname="; //$conn = new PDO($db,$db_username,$db_password); try{ $conn = new PDO($db,$db_username,$db_password); echo "conectado correctamente"; }catch(PDOException $e){ echo ($e->getMessage()); echo "<br>Error Conection"; } $st=$conn->prepare("SELECT PD_ID, PD_CANTIDAD, PRODUCTOS_PRO_ID, DEVOLUCION_MM_DMM_ID FROM PRODUCTO_DEVOLUCION ORDER BY PD_ID ASC"); $st->execute( ); $Result=$st->fetchAll($Result); foreach ($Result as $Result1) : $a=$Result1['PD_ID']; endforeach; $Num_Rows=$Result; $Per_Page = 2; // 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; } $Page_End = $Per_Page * $Page; if ($Page_End > $Num_Rows) { $Page_End = $Num_Rows; } ?> <table width="600" border="1"> <tr> <th width="91"> <div align="center">CustomerID </div></th> <th width="98"> <div align="center">Name </div></th> <th width="198"> <div align="center">Email </div></th> <th width="97"> <div align="center">CountryCode </div></th> </tr> <?php for($i=$Page_Start;$i<$Page_End;$i++) { ?> <tr> <td><div align="center"><?php echo $Result["PD_ID"][$i];?></div></td> <td><?php echo $Result["PD_CANTIDAD"][$i];?></td> <td><?php echo $Result["PRODUCTOS_PRO_ID"][$i];?></td> <td><div align="center"><?php echo $Result["DEVOLUCION_MM_DMM_ID"][$i];?></div></td> </tr> <?php } ?> </table> <br> Total <?php $Num_Rows;?> Record : <?php $Num_Pages;?> Page : <?php if($Prev_Page) { echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> "; } for($i=1; $i<=$Num_Pages; $i++){ if($i != $Page) { echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]"; } else { echo "<b> $i </b>"; } } if($Page!=$Num_Pages) { echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> "; } //oci_close($objConnect); ?> </body> </html>
De esta forma si me funciona pero como dije quisiera hacerlo en PDO
Código
$dbhost = "localhost:1521/xe"; // static public $mvc_bd_nombre = "prueba_ccl"; $dbuser = "HR"; $dbpass = "1234"; $objConnect = oci_connect($dbuser,$dbpass,$dbhost); $strSQL = "SELECT PD_ID, PD_CANTIDAD, PRODUCTOS_PRO_ID, DEVOLUCION_MM_DMM_ID FROM PRODUCTO_DEVOLUCION ORDER BY PD_ID ASC"; $objParse = oci_parse ($objConnect, $strSQL); oci_execute ($objParse,OCI_DEFAULT); $Num_Rows = oci_fetch_all($objParse, $Result);