Install.php_PHP tutorial used by phpfans message board
php
code
copy
message board
of
Copy code The code is as follows:
/*******************************************
*
* Program name: php fans message board
* Demonstration: http://www.phpfans.net/guestbook/
*
* Author: I am not a fish
* Email: deng5765@ 163.com
* Website: http://www.phpfans.net
* Blog: http://www.phpfans.net/space/?2
* Version: v1 .0
* Help: http://www.phpfans.net/guestbook/
**************************** ********************/
if(isset($_POST['Submit'])){
$mydbuser = $_POST['m_root'];
$mydbpw = $_POST['m_pw'];
$mydbname = $_POST['m_db'];
if(!@mysql_connect("localhost",$mydbuser,$mydbpw)) {
echo "mysql username or password is incorrect. Return to modify.
Return";
exit;
}
mysql_query("set names 'gbk'");
$dbsql = "CREATE DATABASE IF NOT EXISTS ".$mydbname;
if(!@mysql_query($dbsql) ){echo "Please check whether you have permission to create a database";exit;}
echo "Create database {$mydbname} successfully>>
";
mysql_select_db($mydbname);
$char = '';
if(mysql_get_server_info()> '4.1') $char = 'DEFAULT CHARSET=gbk';
$sql = "CREATE TABLE `post` (
`p_id` int(255) unsigned NOT NULL auto_increment,
`p_name` varchar(20) NOT NULL,
`p_email` varchar(20) NOT NULL,
`p_qq` varchar(20 ) NOT NULL,
`p_homepage` varchar(100) NOT NULL,
`p_image` varchar(8) NOT NULL,
`p_title` varchar(160) NOT NULL,
`p_content` mediumtext NOT NULL,
`p_ip` varchar(15) NOT NULL,
`p_date` datetime NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=MyISAM {$char};";
if(!@mysql_query($sql)){echo "Please check whether the data table post exists. If it exists, please delete it first.";exit;}
echo "Create data table post successfully>>< br>";
$sql = "INSERT INTO `post` VALUES (1, 'I am not a fish', 'deng5765@163.com', '245821218', 'http://www.phpfans. net', '01', 'Thank you for using the php enthusiasts message board', '
if(@mysql_query($sql)){echo "Initialization of data table successful
";}
$sql = "CREATE TABLE `reply` (
`r_id` int(255) unsigned NOT NULL auto_increment,
`p_id` int(255) NOT NULL,
`r_content` varchar(255) NOT NULL,
`r_rname` varchar(20) NOT NULL,
`r_time` date NOT NULL,
PRIMARY KEY (`r_id`),
UNIQUE KEY `p_id` ( `p_id`)
) ENGINE=MyISAM {$char};";
if(!@mysql_query($sql)){echo "Please check whether the data table reply exists. If it exists, please delete it first.";exit ;}
echo "Create data table reply successfully>>
";
$str = '$str .= '$mydbhost = 'localhost''.";//Database server n";
$str .= '$mydbuser = ''.$mydbuser."';//Database user name n";
$str .= '$mydbpw = ''.$mydbpw."';//Database password n";
$str .= '$mydbname = ''.$mydbname."';//Database name n";
$str .= '$mydbcharset = 'gbk''.";//Database encoding, modification is not recommended.n";
$str .= '$admin = ''.$_POST['m_admin'].' ';//Administrator name'."n";
$str .= '$adminpw = ''.$_POST['m_adminpw'].'';//Administrator password'."n";
$str .= '$eachpage = 5;//Display the number of messages per page'."n";
$str .= '?>';
$fp = fopen('include/ config.php','w');
if(!$fp){echo"This space does not support the file function, please manually configure the content on config.php
";}
else{
fwrite($fp,$str);
fclose($fp);
echo "Configuration document config.php updated successfully>>
";
echo "The installation was successfully completed. For security reasons, please delete insall.php
";
}
echo '
Enter the message board homepage';
exit;
}
?>
php lovers message board_installation
*
* Program name: php fans message board
* Demonstration: http://www.phpfans.net/guestbook/
*
* Author: I am not a fish
* Email: deng5765@ 163.com
* Website: http://www.phpfans.net
* Blog: http://www.phpfans.net/space/?2
* Version: v1 .0
* Help: http://www.phpfans.net/guestbook/
**************************** ********************/
if(isset($_POST['Submit'])){
$mydbuser = $_POST['m_root'];
$mydbpw = $_POST['m_pw'];
$mydbname = $_POST['m_db'];
if(!@mysql_connect("localhost",$mydbuser,$mydbpw)) {
echo "mysql username or password is incorrect. Return to modify.
Return";
exit;
}
mysql_query("set names 'gbk'");
$dbsql = "CREATE DATABASE IF NOT EXISTS ".$mydbname;
if(!@mysql_query($dbsql) ){echo "Please check whether you have permission to create a database";exit;}
echo "Create database {$mydbname} successfully>>
";
mysql_select_db($mydbname);
$char = '';
if(mysql_get_server_info()> '4.1') $char = 'DEFAULT CHARSET=gbk';
$sql = "CREATE TABLE `post` (
`p_id` int(255) unsigned NOT NULL auto_increment,
`p_name` varchar(20) NOT NULL,
`p_email` varchar(20) NOT NULL,
`p_qq` varchar(20 ) NOT NULL,
`p_homepage` varchar(100) NOT NULL,
`p_image` varchar(8) NOT NULL,
`p_title` varchar(160) NOT NULL,
`p_content` mediumtext NOT NULL,
`p_ip` varchar(15) NOT NULL,
`p_date` datetime NOT NULL,
PRIMARY KEY (`p_id`)
) ENGINE=MyISAM {$char};";
if(!@mysql_query($sql)){echo "Please check whether the data table post exists. If it exists, please delete it first.";exit;}
echo "Create data table post successfully>>< br>";
$sql = "INSERT INTO `post` VALUES (1, 'I am not a fish', 'deng5765@163.com', '245821218', 'http://www.phpfans. net', '01', 'Thank you for using the php enthusiasts message board', '
Thank you very much for your support of the php enthusiasts message board
If you encounter any problems during use, please go to
http://www.phpfans. net/guestbook/ Get help
or make your suggestions. At the same time, everyone is welcome to visit the php enthusiast site
< ;A href="http://www.phpfans.net/">http://www.phpfans.net
if(@mysql_query($sql)){echo "Initialization of data table successful
";}
$sql = "CREATE TABLE `reply` (
`r_id` int(255) unsigned NOT NULL auto_increment,
`p_id` int(255) NOT NULL,
`r_content` varchar(255) NOT NULL,
`r_rname` varchar(20) NOT NULL,
`r_time` date NOT NULL,
PRIMARY KEY (`r_id`),
UNIQUE KEY `p_id` ( `p_id`)
) ENGINE=MyISAM {$char};";
if(!@mysql_query($sql)){echo "Please check whether the data table reply exists. If it exists, please delete it first.";exit ;}
echo "Create data table reply successfully>>
";
$str = '$str .= '$mydbhost = 'localhost''.";//Database server n";
$str .= '$mydbuser = ''.$mydbuser."';//Database user name n";
$str .= '$mydbpw = ''.$mydbpw."';//Database password n";
$str .= '$mydbname = ''.$mydbname."';//Database name n";
$str .= '$mydbcharset = 'gbk''.";//Database encoding, modification is not recommended.n";
$str .= '$admin = ''.$_POST['m_admin'].' ';//Administrator name'."n";
$str .= '$adminpw = ''.$_POST['m_adminpw'].'';//Administrator password'."n";
$str .= '$eachpage = 5;//Display the number of messages per page'."n";
$str .= '?>';
$fp = fopen('include/ config.php','w');
if(!$fp){echo"This space does not support the file function, please manually configure the content on config.php
";}
else{
fwrite($fp,$str);
fclose($fp);
echo "Configuration document config.php updated successfully>>
";
echo "The installation was successfully completed. For security reasons, please delete insall.php
";
}
echo '
Enter the message board homepage';
exit;
}
?>