<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);
?> |
|
/ 
/
| 
/ 최적화 1152*864 이상, IE10 이상 / All rights reserved copyright ⓒ Lalena.net / E-mail lalena@lalena.net / go top