-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDb test.php
More file actions
30 lines (29 loc) · 928 Bytes
/
Db test.php
File metadata and controls
30 lines (29 loc) · 928 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<?php
$connection = oci_connect($username = 'anrivera', $password = '$MarkusS4301!', $connection_string = '//oracle.cise.ufl.edu/orcl');
if (!$connection) {
$m = oci_error();
echo $m['message'], "\n";
exit;
}
else {
}
$quer = "SELECT * FROM Contract";
$test = oci_parse($connection, $quer);
oci_execute($test);
while(oci_fetch($test)){
print 'wew lad';
print '<tr><td>'.$test['Provider'].'</td></tr>';
// In a loop, freeing the large variable before the 2nd fetch reduces PHP's peak memory usage
unset($row);
}
/* while(oci_fetch($test)){
//List Contract Name
echo "<br>";
//echo "$_POST[provider]";
echo oci_result($test, 'CONTRACT_NAME');
echo oci_result($test, 'DATA_TYPE');
echo oci_result($test, 'PRICE');
}
oci_free_statement($test);
oci_close($connection);*/
?>