Akses Data yang bersumber pada Database Server Orcale melalui PHP :
$conn = oci_connect([username], [userpassword], [servicename]);
$sql = "select distinct STATUSKAPAL from itkkt_call_kapal";
$header = false;
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS+OCI_ASSOC)) {
if ($header == false) {
print '<thead><tr>';
foreach (array_keys($row) as $key) {
print '<th>'.($key !== null ? htmlentities($key, ENT_QUOTES) : '').'</th>';
}
print '</tr></thead>';
$header = true;
}
print '<tr>';
foreach ($row as $item) {
print '<td>'.($item !== null ? htmlentities($item, ENT_QUOTES) :'').'</td>';
}
print '</tr>';
}
*) user name, password, dan service, silakan disesuaikan.
No comments:
Post a Comment