ok as I said before this is what i wrote to see record from table
On red Is personal settings
This site is made for Polish user so if You want to change it and have a problem write to me
😉
<html>
<head>
<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=iso-8859-2">
<meta name="Author" content="Qbik"/>
<title>WIKARO Przegląd rezerwacji</title>
<script type="text/javascript">
function goBlue(currentid){
document.getElementById(currentid).bgColor="#E7E7FC";
}
function goWhite(currentid){
document.getElementById(currentid).bgColor="WHITE";
}
</script>
</head>
<body>
<?php
if($_REQUEST['passwd'] == "PASSWORD"«»){
?>
<TABLE CELLSPACING=0 CELLPADDING=6 RULES=GROUPS FRAME=BOX>
<THEAD>
<TR>
<TH>ID</TH>
<TH>Nazwisko</TH>
<TH>Ilość osób</TH>
<TH>Telefon</TH>
<TH>E-Mail</TH>
<TH>Skipass</TH>
<TH>Info o osobach</TH>
<TH>Jak trafił</TH>
<TH>Komentarz</TH>
<TH>Akcja</TH>
</TR>
</THEAD>
<FONT SIZE=6>
<TBODY>
<?php
$db=mysql_connect ("some_db_user"«») or die ('Błąd podłączenia do bazy danych: ' . mysql_error());
mysql_select_db ("Joomla_MySQL_db", $db);
if ($_REQUEST['deleterow'] > 0){
$sql = "DELETE FROM form_table_made_by_chronoform WHERE cf_id = ".$_REQUEST['deleterow'].";";
$result = mysql_query($sql);
if(!$result) {
$err=mysql_error();
print $err;
ob_clean();
exit();
}
}
$sql = "SELECT cf_id, nazwisko, liczba_osob, email, telefon, skipass, dane_rodziny, jak, opinia FROM form_table_made_by_chronoform ORDER BY cf_id ASC;";
$result = mysql_query($sql);
if(!$result) {
$err=mysql_error();
print $err;
ob_clean();
exit();
}
/*
<TH>ID</TH>
<TH>Nazwisko</TH>
<TH>Ilość osób</TH>
<TH>Telefon</TH>
<TH>E-Mail</TH>
<th>skipass</TH></th>
<TH>Info o osobach</TH>
<TH>Jak trafił</TH>
<TH>Komentarz</TH>
<TH>Akcja</TH>
*/
$num=mysql_numrows($result);
$i=0;
while ($i < $num){
echo("<TR ID=\"".mysql_result($result,$i,"cf_id"«»)."\" onMouseOver=\"goBlue('".mysql_result($result,$i,"cf_id"«»)."')\" onMouseOut=\"goWhite('".mysql_result($result,$i,"cf_id"«»)."')\"> "«»);
echo("<TD>".mysql_result($result,$i,"cf_id"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"nazwisko"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"liczba_osob"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"email"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"telefon"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"skipass"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"dane_rodziny"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"jak"«»)."</TD>"«»);
echo("<TD>".mysql_result($result,$i,"opinia"«»)."</TD>"«»);
?>
<TD>
<form action="adress_of_this_view_site" method="post" enctype="multipart/form-data" name="form5">
<input name="passwd" type="hidden" value="<?php echo($_REQUEST['passwd']);?>">
<input name="deleterow" type="hidden" value="<?php echo(mysql_result($result,$i,"cf_id"«»));?>">
<input name="Submit" type="submit" value="Usuń">
</form>
</TD>
<?php
echo("</TR>"«»);
$i++;
}
// echo("<P>Ilość osób: " . $num . "</P>"«»);
$sql = "SELECT COUNT(cf_id) FROM form_table_made_by_chronoform;";
$result = mysql_query($sql);
if(!$result) {
$err=mysql_error();
print $err;
ob_clean();
exit();
}
echo("<P>Ilość rezerwacji: " . mysql_result($result, 0) . "</P>"«»);
$sql = "SELECT SUM(liczba_osob) FROM form_table_made_by_chronoform;";
$result = mysql_query($sql);
if(!$result) {
$err=mysql_error();
print $err;
ob_clean();
exit();
}
echo("<P>Łączna ilość osób: " . mysql_result($result, 0) . "</P>"«»);
mysql_close($db);
?>
</TBODY>
</FONT>
<TFOOT>
<TR> <TH align=right COLSPAN=8><?php echo("Razem rezerwacji:"«»); echo($num); ?></th>
<th align=left colspan=5>
<?php
if(!$result) {
$err=mysql_error();
print $err;
ob_clean();
exit();
}
echo(" Łączna ilość osób: "«»);
echo( mysql_result($result, 0));
?>
</th></TR>
</TABLE>
<TABLE>
<TR>
<TD>
<form action="adress_of_this_view_site" method="post" enctype="multipart/form-data" name="form2">
<input name="passwd" type="hidden" value="<?php echo($_REQUEST['passwd']);?>">
<input name="deleterow" type="hidden" value="-1">
<input name="Submit" type="submit" value="Odśwież">
</form>
</TD>
<TD>
<form action="adress_of_this_view_site" method="post" enctype="multipart/form-data" name="form3">
<input name="passwd" type="hidden" value="">
<input name="deleterow" type="hidden" value="-1">
<input name="Submit" type="submit" value="Wyjdź">
</form>
</TD>
</TR>
<TABLE>
<?php
}
else{
if (strlen($_REQUEST['passwd']) > 0){
echo("Nieprawidłowe hasło<BR>"«»);
}
echo("<form action=\"adress_of_this_view_site\" method=\"post\" enctype=\"multipart/form-data\" name=\"form1\">"«»);
echo("<table><tr><td class=\"left\"><strong>Hasło: </strong></td><td><input name=\"deleterow\" type=\"hidden\" value=\"-1\"><input name=\"passwd\" type=\"password\" size=\"30\"></td><td><input name=\"Submit\" type=\"submit\" value=\"Wejdź\"></td></tr></table>"«»);
echo("</form>"«»);
ob_clean();
exit();
}
?>
</body>
</html><br><br>Post edited by: Qbik, at: 2008/02/14 15:59
