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 31 32 33 34 35 36 37 38 39
|
<?php
session_start();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Demande d'intervention</title>
</head>
<body>
<input type="button" value="Accueil" onClick="document.location='index.php';" />
<?php
$user=ucfirst($_SESSION['user']);
$password=$_SESSION['password'];
$db_conn = ocilogon( "$user", "$password" ,"//127.0.0.1/XE");
echo "<strong>INTERVENTION EN COURS</strong>";
$db_conn = ocilogon("pti","rugbys","127.0.0.1/XE");
$sql1 = "SELECT idintervention, nom, materiel, commentaire, datedemande FROM Planning order by idintervention desc";
$ordre = OCIParse ($db_conn, $sql1);
OCIExecute ($ordre);
$ncols = OCINumCols($ordre);
print "<TABLE BORDER=1 >";
while (OCIFetchInto ($ordre, $ligne, OCI_NUM)) {
print "<TR > ";
for ( $i=0;$i < $ncols; $i++) {
print "<TD width='10'>$ligne[$i]</TD>" ;
}
print "</TR> ";
}
OCIFreeCursor ($ordre);
OCILogoff($db_conn);
?>
</body>
</html> |
Partager