我的config.php,多增加一个DBNAME常量作为库名
<?php
header("Content-type: text/html; charset=utf-8");
define('HOST', '127.0.0.1');
define('USERNAME', 'your_mysql_admin');
define('PASSWORD', 'you_mysql_admin_password');
define('DBNAME','your mysql DB name');
?>
<?php
header("Content-type: text/html; charset=utf-8");
define('HOST', '127.0.0.1');
define('USERNAME', 'your_mysql_admin');
define('PASSWORD', 'you_mysql_admin_password');
define('DBNAME','your mysql DB name');
?>
2016-05-07
我的connect.php,因为mysql_function()已经expired,所以我的做法是:
<?php
require_once('config.php');
//数据库连接字符串
if(!($mysqli = new mysqli(HOST, USERNAME, PASSWORD,DBNAME))){
echo $mysqli->error;
}
if(!$mysqli->query('set names utf8')){
echo $mysqli->error;
}
<?php
require_once('config.php');
//数据库连接字符串
if(!($mysqli = new mysqli(HOST, USERNAME, PASSWORD,DBNAME))){
echo $mysqli->error;
}
if(!$mysqli->query('set names utf8')){
echo $mysqli->error;
}
2016-05-07
CREATE TABLE article( id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, title CHAR(100) NOT NULL, author CHAR(50) NOT NULL, description VARCHAR(255) NOT NULL, content text NOT NULL, dateline INT(11) NOT NULL DEFAULT 0 );
2016-05-07
mysql这个函数过时了,改用mysqli
$link=mysqli_connect($host,$user,$pass) or die(mysql_error());
mysqli_select_db($link,'test');
mysqli_query($link,"set names 'utf8'");
$link=mysqli_connect($host,$user,$pass) or die(mysql_error());
mysqli_select_db($link,'test');
mysqli_query($link,"set names 'utf8'");
2016-05-07