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