
<b>* List.PHP </b>=============================================================================================================
<?
include "DBconnect.php";
$result = mysql_query("select * from guest",$DBconnect);
$total_num = 0;
while($row=mysql_fetch_row($result)){
$total_num++;
}
$rest = $total_num%10;
$total_num = $total_num/10;
$total_num = (int)$total_num;
if($rest==0){
$total_page = $total_num;
}else{
$total_page = $total_num + 1;
}
$page = trim($page);
$limit = $page*10-10;
$result = mysql_query("SELECT * FROM guest ORDER BY no DESC LIMIT $limit,10",$DBconnect);
$num=0;
while($row=mysql_fetch_array($result)){
$num++;
$no[$num]=trim($row[no]);
$date[$num]=trim($row[date]);
$name[$num]=trim($row[name]);
$comment[$num]=stripslashes($row[comment]);
$comment[$num]=str_replace("%","%25",$comment[$num]);
$comment[$num]=str_replace("&","%26",$comment[$num]);
$comment[$num]=str_replace("+","%2B",$comment[$num]);
$passwd[$num]=trim($row[password]);
$ip[$num]=trim($row[ip]);
}
for ($i=1;$i<=$num ;$i++) {
echo "&no$i=$no[$i]&name$i=$name[$i]&date$i=$date[$i]&email$i=$email[$i]&home$i=$home[$i]&comment$i=$comment[$i]&passwd$i=$passwd[$i]&ip$i=$ip[$i]";
}
echo "&total_page=$total_page&loading=ok";
mysql_close($DBconnect);
exit;
?>
<b>* Write.PHP </b>=============================================================================================================
<?
include "DBconnect.php";
$name=trim($write_name);
$comment=trim($write_comment);
$passwd=trim($write_passwd);
$date=strftime("%x");
$comment=str_replace('<','<',$comment);
$comment=str_replace('>','>',$comment);
$comment=str_replace('"','"',$comment);
$comment=str_replace('&','&',$comment);
$comment=addslashes($comment);
$result = mysql_query("INSERT INTO guest(name,comment, password,date,ip) VALUES('$name','$comment','$passwd','$date','$REMOTE_ADDR')",$DBconnect);
if($result){
echo "info=±ÛÀÌ µî·ÏµÇ¾ú½À´Ï´Ù.&write_result=success&loading=ok";
}else{
echo "info=±Ûµî·Ï¿¡ ½ÇÆÐÇÏ¿´½À´Ï´Ù.&write_result=fail&loading=ok";
}
mysql_close($DBconnect);
exit;
?>
<b>* Delete.PHP </b>=============================================================================================================
<?
include "DBconnect.php";
$delete_no=trim($delete_no);
$result=mysql_query("DELETE FROM guest WHERE no=$delete_no",$DBconnect);
if($result){
echo "delete_msg=±ÛÀÌ ¼º°øÀûÀ¸·Î »èÁ¦µÇ¾ú½À´Ï´Ù.&delete_result=success&loading=ok";
}else{
echo "delete_msg=±Û »èÁ¦¿¡ ½ÇÆÐÇß½À´Ï´Ù.&delete_result=fail&loading=ok";
}
mysql_close($DBconnect);
exit;
?>
<b>* DBconnect.PHP</b>=============================================================================================================
<?
$DBconnect = mysql_connect("localhost","¾ÆÀ̵ð","ºñ¹ø");
mysql_select_db("µðºñ¸í", $DBconnect);
?> | |