note 43316 modified in function.ociexecute by sixd
| From: | sixd@php.net | Date: | Mon, 05 Oct 2009 02:03:14 +0000 |
| Subject: | note 43316 modified in function.ociexecute by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-161326@lists.php.net to get a copy of this message | ||
Termin.php
<?php
session_start();
if(!session_is_registered("db"))
{
$_SESSION["user"] = $_POST["user"];
$_SESSION["pass"] = $_POST["pass"];
$_SESSION["db"] = $_POST["db"];
}
$logdata[0] = $_SESSION["user"];
$logdata[1] = $_SESSION["pass"];
$logdata[2] = $_SESSION["db"];
$conn = OCILogon($logdata[0],$logdata[1],$logdata[2]);
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, KLID as GRID, KLBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TKLASSE K Where T.TEID=G.TEID AND
GRID=K.KLID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$keys = array_keys($results);
$table = "<table>\n <TR>\n";
foreach($keys as $key)
{
$table .= " <TH>$key</TH>\n";
}
$table .= " </TR>\n";
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, BIID as GRID, BIBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TBILDUNGSGANG B Where T.TEID=G.TEID AND
GRID=B.BIID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, BEID as GRID, BEBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TBERUFSFELD B Where T.TEID=G.TEID AND
GRID=B.BEID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$table .="</TABLE>";
/***************************/
//echo "$table";
/***************************/
$sql = "Select BIID From TBILDUNGSGANG";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$biid = $results[BIID];
$select = "<SELECT NAME=\"biid\">\n";
foreach($biid as $data)
{
$select .= " <OPTION VALUE=\"$data\">$data</OPTION>\n";
}
$select .= "</select>";
//echo $select;
echo <<< HTML
<HTML>
<HEAD>
<TITLE>TERMIN.PHP</TITLE>
</HEAD>
<BODY>
<H1>Willkommen bei Termin.PHP</H1>
Hier sind alle termine<br>
$table
<p>Sie können sich Termine von Klassen bestimmter Bildungsgaänge
ansehen. Einfach auswählen.</p>
<form action="$PHP_SELF" method="post">
$select<br>
<input type="submit">
</form>
HTML;
$biid = $_POST["biid"];
if(isset($biid))
{
$sql = "Select klid, KlBezeichnung, T.TEID, TEDATUM, TEUHRZEIT, TEORT, TEBeschreibung
from Tklasse K, TGruppetermin G, TTermine T where Grid=BIID AND T.TEID=G.TEID AND
BIID='$biid'";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$keys = array_keys($results);
$table = "<table>\n <TR>\n";
foreach($keys as $key)
{
$table .= " <TH>$key</TH>\n";
}
$table .= " </TR>\n";
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
if($rows>0)
{
echo $table;
}
}
echo "</BODY>\n</HTML>";
?>
--was--
Termin.php
<?php
session_start();
if(!session_is_registered("db"))
{
$_SESSION["user"] = $_POST["user"];
$_SESSION["pass"] = $_POST["pass"];
$_SESSION["db"] = $_POST["db"];
}
$logdata[0] = $_SESSION["user"];
$logdata[1] = $_SESSION["pass"];
$logdata[2] = $_SESSION["db"];
$conn = OCILogon($logdata[0],$logdata[1],$logdata[2]);
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, KLID as GRID, KLBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TKLASSE K Where T.TEID=G.TEID AND
GRID=K.KLID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$keys = array_keys($results);
$table = "<table>\n <TR>\n";
foreach($keys as $key)
{
$table .= " <TH>$key</TH>\n";
}
$table .= " </TR>\n";
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, BIID as GRID, BIBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TBILDUNGSGANG B Where T.TEID=G.TEID AND
GRID=B.BIID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$sql = "Select T.TEID, TEDATUM, TEUhrzeit, TEORT, TEBeschreibung, BEID as GRID, BEBezeichnung
as Bezeichnung From TTermine T, TGruppetermin G, TBERUFSFELD B Where T.TEID=G.TEID AND
GRID=B.BEID";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
$table .="</TABLE>";
/***************************/
//echo "$table";
/***************************/
$sql = "Select BIID From TBILDUNGSGANG";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$biid = $results[BIID];
$select = "<SELECT NAME=\"biid\">\n";
foreach($biid as $data)
{
$select .= " <OPTION VALUE=\"$data\">$data</OPTION>\n";
}
$select .= "</select>";
//echo $select;
echo <<< HTML
<HTML>
<HEAD>
<TITLE>TERMIN.PHP</TITLE>
</HEAD>
<BODY>
<H1>Willkommen bei Termin.PHP</H1>
Hier sind alle termine<br>
$table
<p>Sie können sich Termine von Klassen bestimmter Bildungsgaänge
ansehen. Einfach auswählen.</p>
<form action="$PHP_SELF" method="post">
$select<br>
<input type="submit">
</form>
HTML;
$biid = $_POST["biid"];
if(isset($biid))
{
$sql = "Select klid, KlBezeichnung, T.TEID, TEDATUM, TEUHRZEIT, TEORT, TEBeschreibung
from Tklasse K, TGruppetermin G, TTermine T where Grid=BIID AND T.TEID=G.TEID AND
BIID='$biid'";
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$keys = array_keys($results);
$table = "<table>\n <TR>\n";
foreach($keys as $key)
{
$table .= " <TH>$key</TH>\n";
}
$table .= " </TR>\n";
for($i=0;$i<$rows;$i++)
{
$table .= " <TR>";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " <TD>$data</TD>";
}
$table .=" </TR>";
}
if($rows>0)
{
echo $table;
}
}
echo "</BODY>\n</HTML>";
?>
http://php.net/manual/en/function.ociexecute.php