Co jest lepiej ?
1. usuwac listy z bazy ?
2. czy moze lepiej wpisac stan: skasowany, a list nadal pozostawałby w bazie tylko
bylby niewidoczny dla uzytkownika
3. czy moze przenosic usuniete do drugiej tabeli ..
- Grzes
<?php
//********************************************************************************
**********
//** ProStY SYSTEM MAILOWY **
//********************************************************************************
**********
/*
CREATE TABLE `maile2` (
`mail_id` int(10) unsigned NOT NULL auto_increment,
`mail_id_odpowiedz` int(10),
`tytul` varchar(100) NOT NULL default '',
`tresc` text NOT NULL,
`nadawca` int(10) NOT NULL,
`odbiorca` int(10) NOT NULL,
`stan` varchar(14) NOT NULL default 'NOWY',
`data_odebrania` datetime NOT NULL default '0000-00-00 00:00:00',
`data_nadania` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`mail_id`)
);
*/
$user_id =2;
$db_server = "127.0.0.1";
$db_uname = "root";
$db_pass = "yyy";
$db_name = "mail";
$title = "phpNewsManager $newman_ver";
// if (is_user($user)) {
// dla wszytkich danych przekazanych metoda POST formularz jest POST
foreach($_POST as $key =>$value){
$$key=$value;
}
// link edit jest typu: GET: <a href=pnews.php?action=edit&id_maila=
foreach($_GET as $key =>$value){
$$key=$value;
}
if ($action == "edit") edit_mail(0,$id_maila);
else if ($action == "delete") DeleteNews(0,$id_maila);
else if ($action == "multidel") MultiDelete($db_pnews,"id","pnews_del");
else if ($action == "zapisz") write_mail();
else formularz();
function ShowMain() {
// pobierz ilosc rekordow:
$myopt = ShowPages($num,$GLOBALS['page'],$GLOBALS['hits'],$GLOBALS['show']);
$sql="SELECT * from maile2 order by data_nadania desc limit $myopt[0],$myopt[1]";
//echo $sql;
echo "<BR><CENTER><TABLE border=1>";
echo "<TR><TD>Numer listu</TD><TD>NADAWACA </TD><TD>ODBIORCA </TD><TD>TYTUL</TD><TD>TRESC</TD></TR>";
{
echo "<TR><TD>". $ar['mail_id']." </TD><TD>". $ar['nadawca']." </TD><TD>". $ar['odbiorca']." </TD><TD>". $ar['tytul'] ."</TD><TD>". $ar['tresc'] ."</TD></TR>";
}
echo "</TABLE></CENTER>";
}
function edit_mail($user,$id_mail) {
$sql = "SELECT * from maile2 WHERE mail_id=$id_mail";
// echo $sql;
echo "<CENTER><TABLE border=1 width=400>";
{
echo "<TR><TD>Nadawca: </TD><TD>". $ar['nadawca']." </TD><TD> Odbiorca: ". $ar['odbiorca']." </TD></TR>"; echo "<TR><TD>Nr. listu: </TD><TD>". $ar['mail_id']." </TD></TR>"; echo "<TR><TD>Tytul: </TD><TD>". $ar['tytul'] ."</TD></TR>"; echo "<TR><TD>Tresc: </TD><TD>". $ar['tresc'] ."</TD></TR>";
}
// zaznacz ze przeczytany:
$sql = "UPDATE `maile2` SET `stan` = 'przeczytany' WHERE `maile2`.`mail_id` =$id_mail LIMIT 1" ;
//echo $sql;
echo "</TABLE></CENTER>";
}
function formularz() {
print '<CENTER><form action="pnews.php" method="POST"> <INPUT type="hidden" value="zapisz" name="action"><p>Temat: <input type="text" name="temat" size="40" maxsize="100" ></p> <p>Treść: <textarea name="tresc" columns="80" rows="5" ></textarea></p> <p>Adresat: <input type="text" name="odbiorca" maxsize="50" value='.$user_id.'> Nadawca <input type="text" name="nadawca" value='.$user_id.' maxsize="50" ><BR> <input type="submit" name="wyslij" value="Wyślij wiadomość"> </form></CENTER>';
}
function wyswietl($nadawca_id) {
// Ile listow wyslanych i odebranych ma dany user....
echo "<CENTER><HR width=400></CENTER>"; echo "<CENTER> NADAWCA: $nadawca_id ma $num listow</CENTER>";
$myopt = ShowPages1($num,$GLOBALS['page'],$GLOBALS['hits'],$GLOBALS['show']);
////////////////////////////////////////
$sql = "SELECT * from maile2 WHERE nadawca=$nadawca_id order by data_nadania desc l
imit $myopt[0],$myopt[1]";
//echo $sql;
echo "<CENTER><TABLE border=1>"; echo "<TR><TD>Numer listu </TD><TD>NADAWCA</TD><TD>TYTUŁ</TD><TD>TREŚĆ</TD><TD>OTWÓRZ</TD><TD>USUŃ</TD><TD>PRZECZYTANY</TD></TR>"; {
echo ' <tr><td width="100">';
echo "<TR><TD>". $ar['mail_id']." </TD><TD>". $ar['nadawca']." </TD><TD>". $ar['tytul'] ."</TD><TD>". $ar['tresc'] ."</TD>";
echo "<TD><a href=pnews.php?action=edit&id_maila=".$ar['mail_id']."> open </A></TD>"; echo "<TD><a href=pnews.php?action=delete&id_maila=".$ar['mail_id']."> delete </A></TD>"; echo "<TD>".$ar['stan']."</TD>";
}
echo "</TABLE></CENTER>";
/////////////////////////////////////////////
}
function DeleteNews($user,$id_mail) {
$sql = "DELETE FROM maile2 WHERE mail_id='".$id_mail."'";
//echo $sql;
}
function write_mail() {
//$GLOBALS['db_pnews'] = "mail";
$temat = $_GET['temat'];
$tresc = $_GET['tresc'];
$nadawca = $_GET['nadawca'];
$odbiorca = $_GET['odbiorca'];
global $temat,$tresc,$nadawca,$odbiorca;
// $sql = "INSERT INTO maile2 ( mail_id_odpowiedz, tytul, tresc, nadawca, odbiorca, stan, data_odebrania,
data_nadania) VALUES (0,'$temat', '$tresc', '$nadawca', '$odbiorca', 'nadana',Now(), Now())";
$sql = "INSERT INTO `maile2` ( `mail_id` , `mail_id_odpowiedz` , `tytul` , `tresc` , `nadawca` , `odbiorc
a` , `stan` , `data_odebrania` , `data_nadania` ) VALUES (NULL , '3', '$temat', '$tresc', '$nadawca', '$odbiorca', 'nowy', '0000-00-00 00:00:00', Now());";
}
// dla wszystkich listow
function ShowPages($xnum)
{
global $sort,$order,$id,$page,$hits,$show;
if ($page == 0) {$page=1;}
if (empty($page)) {$page=1;} if (empty($hits)) {$hits=10;} if (empty($show)) {$show = 7;}
$start = $hits*($page-1);
$stw2 = ($xnum/$hits);
$stw2 = (int) $stw2;
if ($xnum%$hits > 0) {$stw2++;}
$np = $page+1;
$pp = $page-1;
if ($page == 1) { $pp=1; }
$l1 = $page - $show;
$d1 = $page + $show;
$n1 = $page - $show;
if($n1<1) {$n1=1;}
$n2 = $page + $show;
if($n2>$stw2) {$n2=$stw2;}
$d1 = 2 * $show + $l1;
if($d1>$stw2) {$d1=$stw2;$l1=$stw2-$show*2;}
if($l1<1) {$l1 = 1;}
if ($np>$stw2) { $np=$stw2; }
echo "<a href="".$GLOBALS['PHP_SELF']."?page
=$pp&sort
=$sort&id
=$id">«</a> "; echo "<a href="".$GLOBALS['PHP_SELF']."?page
=$n1&sort
=$sort&id
=$id"><</a> "; for($i=$l1;$i<=$d1;$i++)
{
if($page==$i) {echo "<b>$i</b>";} else{echo " <a href="".$GLOBALS['PHP_SELF']."?page
=$i&sort
=$sort&id
=$id">$i</a> ";} }
echo " <a href="".$GLOBALS['PHP_SELF']."?page
=$np&sort
=$sort&id
=$id">></a> "; echo " <a href="".$GLOBALS['PHP_SELF']."?page
=$n2&sort
=$sort&id
=$id">»</a>"; return array($start,$hits); }
// pokaz dla danego usera
function ShowPages1($xnum)
{
global $sort1,$order1,$id1,$page1,$hits1,$show1;
if ($page1 == 0) {$page1=1;}
if (empty($page1)) {$page1=1;} if (empty($hits1)) {$hits1=10;} if (empty($show1)) {$show1 = 7;}
$start = $hits1*($page1-1);
$stw2 = ($xnum/$hits1);
$stw2 = (int) $stw2;
if ($xnum%$hits1 > 0) {$stw2++;}
$np = $page1+1;
$pp = $page1-1;
if ($page1 == 1) { $pp=1; }
$l1 = $page1 - $show1;
$d1 = $page1 + $show1;
$n1 = $page1 - $show1;
if($n1<1) {$n1=1;}
$n2 = $page1 + $show1;
if($n2>$stw2) {$n2=$stw2;}
$d1 = 2 * $show1 + $l1;
if($d1>$stw2) {$d1=$stw2;$l1=$stw2-$show1*2;}
if($l1<1) {$l1 = 1;}
if ($np>$stw2) { $np=$stw2; }
echo "<a href="".$GLOBALS['PHP_SELF']."?page1
=$pp&sort1
=$sort1&id1
=$id1">«</a> "; echo "<a href="".$GLOBALS['PHP_SELF']."?page1
=$n1&sort1
=$sort1&id1
=$id1"><</a> "; for($i=$l1;$i<=$d1;$i++)
{
if($page1==$i) {echo "<b>$i</b>";} else{echo " <a href="".$GLOBALS['PHP_SELF']."?page1
=$i&sort1
=$sort1&id1
=$id1">$i</a> ";} }
echo " <a href="".$GLOBALS['PHP_SELF']."?page1
=$np&sort1
=$sort1&id1
=$id1">></a> "; echo " <a href="".$GLOBALS['PHP_SELF']."?page1
=$n2&sort1
=$sort1&id1
=$id1">»</a>"; return array($start,$hits1); }
ShowMain();
wyswietl($user_id);
?>