Kod: Tümünü seç
<?
include("../include/session.php");
?>
<?
if($session->logged_in)
{
function listele()
{
global $database;
// $q = "SELECT * FROM faultyreporter";
$q = "SELECT faultyreporter.id, tailname.tailname as ucakad ,faultyreporter.ekipno, faultyreporter.reportdate, faultyreporter.recorddate, faultyreporter.report, faultyreporter.time, faultyreporter.process, faultyreporter.partnumber, faultyreporter.serialnumberoff, faultyreporter.serialnumberon, faultyreporter.recorderuserid FROM faultyreporter INNER JOIN tailname ON tailname.id = faultyreporter.tailid";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0))
{
echo "Error displaying info";
return;
}
if($num_rows == 0)
{
echo "Database table empty";
return;
}
echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<tr><td><b>id</b></td><td><b>tailid</b></td><td><b>ekipno</b></td><td><b>reportdate</b></td><td><b>recorddate</b></td><td><b>report</b></td><td><b>time</b></td><td><b>process</b></td><td><b>partnumber</b></td><td><b>serialnumberoff</b></td><td><b>serialnumberon</b></td><td><b>recorderuserid</b></td></tr>\n";
for($i=0; $i<$num_rows; $i++)
{
$id = mysql_result($result,$i,"id");
$tailid = mysql_result($result,$i,"ucakad");
$ekipno = mysql_result($result,$i,"ekipno");
$reportdate = mysql_result($result,$i,"reportdate");
$recorddate = mysql_result($result,$i,"recorddate");
$report = mysql_result($result,$i,"report");
$time = mysql_result($result,$i,"time");
$process = mysql_result($result,$i,"process");
$partnumber = mysql_result($result,$i,"partnumber");
$serialnumberoff = mysql_result($result,$i,"serialnumberoff");
$serialnumberon = mysql_result($result,$i,"serialnumberon");
$recorderuserid = mysql_result($result,$i,"recorderuserid");
echo "<tr><td>$id</td><td>$tailid</td><td>$ekipno</td><td>$reportdate</td><td>$recorddate</td><td>$report</td><td>$time</td><td>$process</td><td>$partnumber</td><td>$serialnumberoff</td><td>$serialnumberon</td><td>$recorderuserid</td></tr>\n";
}
echo "</table><br>\n";
}
?>
<form name="form1">
<p>
<select style=";" name="menu">
<option value="../faultyreporter/faultyreporter.php">New Faulty Report</option>
<option value=<? listele();?> >Read Faulty Report</option>
<option value="../faultyreporter/faultyreportedit.php">Edit Faulty Report</option>
</select>
<input style=";" type="button" onClick="location=document.form1.menu.options[document.form1.menu.selectedIndex].value;" value="UYGULA">
</p>
</form>
<?
}
?>