Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $connstr = " host='127.0.0.1' port = '5432' dbname='lcrodril_sistema' user='lcrodril_sql' password='godatabase' " ;
- $dbh = pg_connect($connstr);
- if ($dbh)
- {
- }
- $sqlvista= "SELECT * from casos where id='$idc'AND key='$clave'";
- $stat2 = pg_exec($sqlvista);
- if ($stat2) {
- $vistaso = pg_numrows($stat2);
- for ($i = 0; $i < $vistaso; $i++) {
- $data = pg_fetch_row($stat2, $i);
- ?>
- <?echo "<h3>ID del caso:</h3><p>$data[0]</p>";?>
- <?echo "<h3>Nombre del caso:</h3><p>$data[1]</p>";?>
- <?echo "<h3>Observaciones:</h3><p>$data[2]</p>";?>
- <?echo "<h3>Tipo de caso:</h3><p>$data[3]</p>";?>
- <?echo "<h3>Estatus del caso:</h3><p>$data[4]</p>";?>
- <?echo "<h3>Demandante:</h3><p>$data[6]</p>";?>
- <?echo "<h3>Demandado:</h3><p>$data[7]</p>";?>
- <?echo "<h3>Tribunal:</h3><p>$data[8]</p>";?>
- <?echo "<h3>Numero de Expediente:</h3><p>$data[9]</p>";?>
- <?echo "<h3>Motivo:</h3><p>$data[10]</p>";?>
- <?echo "<h3>Fecha de Ultima Revisión:</h3><p>$data[11]</p>";?>
- <?echo "<h3>Expediente:</h3>";
- pg_exec($dbh, "BEGIN");
- Header( "Content-type: application/pdf");
- $loid = pg_lo_open($dbh,$data[14], "r");
- $go= pg_lo_read_all($loid);
- pg_exec($dbh, "COMMIT");
- pg_close($dbh);
- ?>
- //<embed src=<?$go.pdf?> width=”500″ height=”375″>
- <?
- }
- ?>
Add Comment
Please, Sign In to add comment