Install.php_PHP tutorial used by phpfans message board
WBOYOriginal
2016-07-21 15:58:161340browse
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);
$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