Viewing file:  conexion.php (946 B) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/*if ($c=OCILogon("EMAIL", "EMAIL2003", "SIA")) {
echo "Successfully connected to Oracle.\n";
OCILogoff($c);
} else {
$err = OCIError();
echo "Oracle Connect Error " . $err[text];
}
*/
?>
<select name="barrio" id="barrio">
<?php
$loc = $_GET['loc'];
$dbh = OCILogon( "EMAIL", "EMAIL2003", "SIA" );
if ($dbh == NULL) {
print "DB Connection Error!!";
} else {
$sql = "SELECT BARRIO_ID, DESCRIPCION FROM SIA_BARRIO WHERE COD_LOC=$loc";
$stmt = OCIParse($dbh, $sql);
if (!$stmt) {
print "DB Search Error!!";
} else {
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt, $results);
if ($rows > 0) {
for ($i = 0; $i < $rows; $i++) {
print "<option value=". $results["BARRIO_ID"][$i].">".$results["DESCRIPCION"][$i]."</OPTION>";
}
}
}
OCIFreeStatement($stmt);
OCILogoff($dbh);
}
?>
</SELECT>
|