Php+mysql make a simple message this _php tutorial

Message Display page: More than the previous example added paging and message reply function

Main code:
install/index.php: Program Installation page
Copy CodeThe code is as follows:
if ($_get["action"]!=1)
{
?>

}else{
@set_time_limit (1000);
$lockfile = "Install.lock";
$host = "localhost";
$user = "root";
$password = "";
$database = "Ruizhi_messageboard";
$pagenum = 10;
$admin _name= "admin";
$admin _password= "123456";
$boardname = "ruizhinet message book";
if ($_post["host"]!= "") {
$host =$_post["host"];
}
if ($_post["user"]!= "") {
$user =$_post["User"];
}
if ($_post["password"]!= "") {
$password =$_post["Password"];
}
if ($_post["database"]!= "") {
$database =$_post["Database"];
}
if ($_post["Pagenum"]!= "") {
$pagenum =$_post["Pagenum"];
}
if ($_post["Admin_name"]!= "") {
$admin _name=$_post["Admin_name"];
}
if ($_post["Admin_password"]!= "") {
$admin _password=$_post["Admin_password"];
}
if ($_post["Boardname"]!= "") {
$boardname =$_post["Boardname"];
}
if (file_exists ($lockfile)) {
Exit ("Already installed, if you want to reinstall please remove Install/install.lock first");
}
$conn =mysql_connect ($host, $user, $password);
if ($conn) {
$sql _drop_database= "drop database IF EXISTS '". $database. " `";
$sql _create_database= "CREATE DATABASE". $database. " `";
$sql _create_table_messageboard= "CREATE table ' messageboard ' (
' id ' int (one) not NULL auto_increment,
' Author ' varchar (not NULL),
' title ' varchar (+) not NULL,
' Smiles ' varchar (+) not NULL,
' Content ' Mediumtext,
' Photo ' varchar (+) not NULL,
' Addtime ' int (one) default NULL,
PRIMARY KEY (' id ')
) Engine=myisam DEFAULT charset=gbk auto_increment=1 ";
$sql _create_table_reply= "CREATE table ' reply ' (
' id ' int (one) not NULL auto_increment,
' MsgId ' int (one) is not NULL,
' Content ' Mediumtext,
' Addtime ' int (one) default NULL,
PRIMARY KEY (' id ')
) Engine=myisam DEFAULT charset=gbk auto_increment=1 ";
if (mysql_query ($sql _drop_database, $conn)) {
if (mysql_query ($sql _create_database, $conn)) {
mysql_select_db ($database, $conn);
if (mysql_query ($sql _create_table_messageboard, $conn) && mysql_query ($sql _create_table_reply, $conn)) {
$config _file= ". /config.php ";
$config _strings= " $config _strings.= "\ $boardname =\" ". $boardname." \ "; \ n";
$config _strings.= "\ $host =\" ". $host." \ "; \ n";
$config _strings.= "\ $user =\" ". $user." \ "; \ n";
$config _strings.= "\ $password =\" ". $password." \ "; \ n";
$config _strings.= "\ $database =\" ". $database." \ "; \ n";
$config _strings.= "\ $pagenum =\" ". $pagenum." \ "; \ n";
$config _strings.= "\ $admin _name=\" ". $admin _name." \ "; \ n";
$config _strings.= "\ $admin _password=\" ". $admin _password." \ "; \ n";
$config _strings.= "\ $conn =mysql_connect (\ $host, \ $user, \ $password); \ n";
$config _strings.= "mysql_select_db (\ $database, \ $conn); \ n";
$config _strings.= "?>";
if ($fp =fopen ($config _file, "WB")) {
if (fwrite ($fp, $config _strings)) {
if ($fp 2 = fopen ($lockfile, ' W '))
{
Fwrite ($fp 2, ' 1212 ');
Fclose ($fp 2);
}
echo "Installation is successful! The configuration file is: config.php, you can manually modify the file ";
echo "\ n Enter the system homepage";
}else{
Exit ("File write Failed");
}
Fclose ($FP);
}
}else{
Exit ("Cannot execute CREATE TABLE statement:". $sql _create_table);
}
}else{
Exit ("Cannot execute CREATE DATABASE statement:". $sql _create_database);
}
}else{
Exit ("Cannot execute DROP DATABASE statement:". $sql _drop_database);
}
}else{
Exit ("Connection database failed, check MySQL hostname, username and password");
}
}

Generated config.php files:
Copy CodeThe code is as follows:
$boardname = "ruizhinet message book";
$host = "localhost";
$user = "root";
$password = "";
$database = "Ruizhi_messageboard";
$pagenum = "10";
$admin _name= "admin";
$admin _password= "admin";
$conn =mysql_connect ($host, $user, $password);
mysql_select_db ($database, $conn);
?>

index.php: Program Display page
Copy CodeThe code is as follows:
if (!$_get["page"]) {
$page = 1;
}else{
$page =$_get["page"];
}
$sql = "SELECT id from messageboard";
$result =mysql_query ($sql, $conn);
$row _num=mysql_num_rows ($result);
$page _count=ceil ($row _num/$pagenum);
echo "Currently in common". $row _num. " Message ";
echo "Total divide". $page _count. " page displays ";
echo "Current is". $page. " Page ";
?>

if ($row _num==0) {
echo "No message at the moment";
}else{
?>

$offset = ($page-1) * $PAGENUM;$sql 2= "SELECT * from Messageboard the ORDER by ID DESC LIMIT $offset, $pagenum";$result 2=mysql_query ($sql 2, $conn);while ($row =mysql_fetch_array ($result 2)) {$offset + +;echo " "; echo " ";echo " ";if ($row ["Photo"]!= "NONE"){echo " ";}$sql 3= "SELECT * from reply WHERE msgid= $row [id] ORDER by ID DESC";$result 3=mysql_query ($sql 3, $conn);while ($row 3=mysql_fetch_array ($result 3)) {echo " ";echo " ";}}?> if ($page _count>1) {$prev _page= $page-1;$next _page= $page +1;if ($page <=1) {echo "First page |";}else{echo "First page |";}if ($prev _page<1) {echo "prev |";}else{echo "prev |";}if ($next _page> $page _count) {echo "Next page |";}else{echo "Next page |";}if ($page >= $page _count) {echo "last Page";}else{echo "last Page";}}?>

"; echo $offset. "."; Echo Base64_decode ($row [title]). "-". Base64_decode ($row [author]). " [". Date (" Y year M month D Day ", $row [Addtime])."] "; if (Isset ($_session["Admin_name") && $_session["Admin_name"]!= "") { echo "Delete |"; echo "Reply"; } echo "

". Base64_decode ($row [" content "])."

Reply: ". Date (" Y year M D Day ", $row 3[addtime]); if (Isset ($_session["Admin_name") && $_session["Admin_name"]!= "") { echo "Delete"; } echo "

". Base64_decode ($row 3[content])."

}
?>
if (Isset ($_session["Admin_name") && $_session["Admin_name"]!= "") {
?>

Exit management

}else{
?>

Login Management

}
?>

saveadd.php: Save Message
Copy CodeThe code is as follows:
if (!$_post["author"] | |!$_post["CONTENT"])
{
echo " \ n ";
echo "You did not fill in the message name or content, 2 seconds to return home";
Exit ();
}else{
$imgflag = 0;
function Random ($length)
{
$hash = ' img-';
$chars = ' abcdefghijklmnopqrstuvwxyz0123456789abcdefghijklmnopqrstuvwxyz ';
$max = strlen ($chars)-1;
Echo (double) microtime () * 1000000;
for ($i = 0; $i < $length; $i + +)
{
$hash. = $chars [Mt_rand (0, $max)];
}
return $hash;
}
function Fileext ($filename)
{
Return substr (STRRCHR ($filename, '. '), 1);
}
if ($_files["Upfile" ["Name"]!= "") {
$uploaddir = "upfile/";
$type =array ("JPG", "gif", "BMP", "JPEG", "PNG");
if (!in_array (Strtolower (Fileext ($_files[' upfile ' [' name '])), $type))
{
echo " \ n ";
$text =implode (",", $type);
echo "You can only upload the following types of files:", $text, "
";
Exit ();
}
Else
{
$filename =explode (".", $_files[' upfile ' [' name ']);
Do
{
$filename [0]=random (10);
$randname =implode (".", $filename);
$uploadfile = $uploaddir. $randname;
} while (File_exists ($uploadfile));
if (Move_uploaded_file ($_files[' upfile ' [' tmp_name '], $uploadfile)) {
echo "Upload image success";
$imgflag = 1;
}
else{
echo "failed to upload image! ";
$imgflag = 0;
}
}
}
$author =base64_encode ($_post["author"]);
$content =base64_encode (ereg_replace ("\ r \ n", "
", Htmlspecialchars ($_post[" content "]));
$smiles =base64_encode ($_post["smiles"]);
if ($_post["title"]) {
$title =base64_encode ($_post["title"]);
}else{
$title =base64_encode ("Untitled");
}
$addtime =time ();
if ($imgflag ==1) {
$photo =base64_encode ($randname);
}else{
$photo = "NONE";
}
Save data
$sql = "INSERT into messageboard (author,title,smiles,content,photo,addtime) VALUES (' $author ', ' $title ', ' $smiles ', ' $ Content ', ' $photo ', $addtime) ";
mysql_query ($sql, $conn);
echo " \ n ";
echo "Thank you for your message, 2 seconds to return home";
}
?>
Savereply.php: Save reply
if (Isset ($_session["Admin_name") && $_session["Admin_name"]!= "")
{
if (!$_post["content"])
{
echo " \ n ";
echo "You did not fill in the reply content, 2 seconds back to the homepage";
Exit ();
}else{
$msgid =$_post["MsgId"];
$content =base64_encode (ereg_replace ("\ r \ n", "
", Htmlspecialchars ($_post[" content "]));
$addtime =time ();
Save data
$sql = "INSERT into reply (msgid,content,addtime) VALUES ($msgid, ' $content ', $addtime)";
mysql_query ($sql, $conn);
echo " \ n ";
echo "Thank you for your message, 2 seconds to return home";
}
}
?>

http://www.bkjia.com/PHPjc/320898.html www.bkjia.com true http://www.bkjia.com/PHPjc/320898.html techarticle Message Display page: More than the previous example added paging and message reply function main code: install/index.php: Program Installation page copy code code as follows:? php if ($_get["Acti ...

