Home > Article > Backend Development > installer tome 2.mpq installphp used by phpfans message board
installer tome 2.mpq installphp used by phpfans message board
- WBOYOriginal
- 2016-07-29 08:36:041175browse
Copy the code The code is as follows:
/******************************************* Thank you very much for your support of the php fans message board
*
* Program name: php enthusiasts message board
* Demo: 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 for modification.< br>";
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>>
";
$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 fans message board', '
< ;P>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 fan site
', '127.0.0.1', now())";
if(@mysql_query($sql)){echo "Initialization of data table successfully
";}
$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 reply data table 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, it is not recommended to modify.n";
$str .= '$admin = ''.$_POST['m_admin'].'';//Administrator name'."n";
$str .= ' $adminpw = ''.$_POST['m_adminpw'].'';//Administrator password'."n";
$str .= '$eachpage = 5;//Number of messages displayed on each 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 a message Board homepage';
exit;
}
?>
< ;/head>