從截圖來看,主要是編寫生成 SQL 語句,如果對 SQL 不太熟,建議方法如下:
創(chuàng)新互聯(lián)專注于企業(yè)成都全網(wǎng)營銷推廣、網(wǎng)站重做改版、克拉瑪依網(wǎng)站定制設(shè)計、自適應(yīng)品牌網(wǎng)站建設(shè)、HTML5建站、電子商務(wù)商城網(wǎng)站建設(shè)、集團公司官網(wǎng)建設(shè)、成都外貿(mào)網(wǎng)站建設(shè)公司、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁設(shè)計等建站業(yè)務(wù),價格優(yōu)惠性價比高,為克拉瑪依等各大城市提供網(wǎng)站開發(fā)制作服務(wù)。
1、先使用 mysql 等的數(shù)據(jù)庫管理工具,比如:PhpMyAdmin 、MySQL-Front 等,根據(jù)表格建立好數(shù)據(jù)表、再輸入3條以上的記錄。
2、導(dǎo)出數(shù)據(jù)表、記錄到 SQL 文件。
生成 sql 腳本文件后,就可以在 php 里讀取 sql 文件命令,并執(zhí)行(或者直接硬編碼寫)。
創(chuàng)建數(shù)據(jù)庫:create database 數(shù)據(jù)庫名
創(chuàng)建數(shù)據(jù)表:
CREATE TABLE `users` (
`id` tinyint(10) auto_increment primary key NOT NULL,
`username` varchar(30) NOT NULL,
`age` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
執(zhí)行這兩個sql語句就行
建立數(shù)據(jù)表,得是你在cmd窗口或者phpmyadmin、navicat for mysql這類終端軟件里進行操作。建立數(shù)據(jù)表的指令是create table xxx ();
連接數(shù)據(jù)庫使用php封裝好的一個函數(shù)mysql_connect();
例如:
mysql_connect('127.0.0.1','root','root');
這樣的語句來連接,因為連接數(shù)據(jù)庫會生成連接標識資源,你把這個資源賦給一個新變量
$active_connection_sort = mysql_connect('127.0.0.1','root','root');
這樣你拿著新變量去玩別的也好下手。
括號中間都是參數(shù),第一個是連接地址,比如localhost,但我個人建議還是127.0.0.1省得還得來一步解析,第二個參數(shù)是用戶名,第三個參數(shù)是密碼,都用英文單括號括上。參數(shù)和參數(shù)之間用英文逗號間隔起來。
用框架做久了這個東西都容易忘,我也是憑記憶寫的,你試試看這個能不能過關(guān)。
$sql = "
create table table_name (
id int(11) not null auto_increment primary key,
user varchar(255) ,
name varchar(255)
)
";
mysql_query($sql);
-------------------------------------
其實也是執(zhí)行一個sql語句~
--------------------------------------
我剛寫的。。測試成功的哈
?php
$link = mysql_connect("127.0.0.1","root","123456");
mysql_select_db("test");
$sql = "
create table table_name (
id int(11) not null auto_increment primary key,
user varchar(255) ,
name varchar(255) charset gbk
)
";
mysql_query($sql) or die(mysql_error());
?
if(!is_writable('config.php')){
emMsg('配置文件(config.php)不可寫。如果您使用的是Unix/Linux主機,請修改該文件的權(quán)限為777。如果您使用的是Windows主機,請聯(lián)系管理員,將此文件設(shè)為可寫');
}
if(!is_writable(EMLOG_ROOT.'/content/cache')){
emMsg('緩存文件不可寫。如果您使用的是Unix/Linux主機,請修改緩存目錄?(content/cache)?下所有文件的權(quán)限為777。如果您使用的是Windows主機,請聯(lián)系管理員,將該目錄下所有文件設(shè)為可寫');
}
$config?=?"?php\n"
."http://mysql?database?address\n"
."define('DB_HOST','$db_host');"
."\n//mysql?database?user\n"
."define('DB_USER','$db_user');"
."\n//database?password\n"
."define('DB_PASSWD','$db_pw');"
."\n//database?name\n"
."define('DB_NAME','$db_name');"
."\n//database?prefix\n"
."define('DB_PREFIX','$db_prefix');"
."\n//auth?key\n"
."define('AUTH_KEY','".getRandStr(32).md5($_SERVER['HTTP_USER_AGENT'])."');"
."\n//cookie?name\n"
."define('AUTH_COOKIE_NAME','EM_AUTHCOOKIE_".getRandStr(32,false)."');"
."\n";
$fp?=?@fopen('config.php',?'w');
$fw?=?@fwrite($fp,?$config);
if?(!$fw){
emMsg('配置文件(config.php)不可寫。如果您使用的是Unix/Linux主機,請修改該文件的權(quán)限為777。如果您使用的是Windows主機,請聯(lián)系管理員,將此文件設(shè)為可寫');
}
fclose($fp);
//密碼加密存儲
$PHPASS?=?new?PasswordHash(8,?true);
$adminpw?=?$PHPASS-HashPassword($adminpw);
$dbcharset?=?'utf8';
$type?=?'MYISAM';
$table_charset_sql?=?$DB-getMysqlVersion()??'4.1'???'ENGINE='.$type.'?DEFAULT?CHARSET='.$dbcharset.';'?:?'ENGINE='.$type.';';
if?($DB-getMysqlVersion()??'4.1'?){
$DB-query("ALTER?DATABASE?`{$db_name}`?DEFAULT?CHARACTER?SET?utf8?COLLATE?utf8_general_ci;",?true);
}
$widgets?=?Option::getWidgetTitle();
$sider_wg?=?Option::getDefWidget();
$widget_title?=?serialize($widgets);
$widgets?=?serialize($sider_wg);
define('BLOG_URL',?getBlogUrl());
$sql?=?"
DROP?TABLE?IF?EXISTS?{$db_prefix}blog;
CREATE?TABLE?{$db_prefix}blog?(
gid?int(10)?unsigned?NOT?NULL?auto_increment,
title?varchar(255)?NOT?NULL?default?'',
date?bigint(20)?NOT?NULL,
content?longtext?NOT?NULL,
excerpt?longtext?NOT?NULL,
alias?VARCHAR(200)?NOT?NULL?DEFAULT?'',
author?int(10)?NOT?NULL?default?'1',
sortid?int(10)?NOT?NULL?default?'-1',
type?varchar(20)?NOT?NULL?default?'blog',
views?int(10)?unsigned?NOT?NULL?default?'0',
comnum?int(10)?unsigned?NOT?NULL?default?'0',
attnum?int(10)?unsigned?NOT?NULL?default?'0',
top?enum('n','y')?NOT?NULL?default?'n',
sortop?enum('n','y')?NOT?NULL?default?'n',
hide?enum('n','y')?NOT?NULL?default?'n',
checked?enum('n','y')?NOT?NULL?default?'y',
allow_remark?enum('n','y')?NOT?NULL?default?'y',
password?varchar(255)?NOT?NULL?default?'',
template?varchar(255)?NOT?NULL?default?'',
PRIMARY?KEY??(gid),
KEY?date?(date),
KEY?author?(author),
KEY?sortid?(sortid),
KEY?type?(type),
KEY?views?(views),
KEY?comnum?(comnum),
KEY?hide?(hide)
)".$table_charset_sql."
INSERT?INTO?{$db_prefix}blog?(gid,title,date,content,excerpt,author,views,comnum,attnum,top,sortop,hide,allow_remark,password)?VALUES?(1,?'歡迎使用emlog',?'".time()."',?'恭喜您成功安裝了emlog,這是系統(tǒng)自動生成的演示文章。編輯或者刪除它,然后開始您的創(chuàng)作吧!',?'',?1,?0,?0,?0,?'n',?'n',?'n',?'y',?'');
DROP?TABLE?IF?EXISTS?{$db_prefix}attachment;
CREATE?TABLE?{$db_prefix}attachment?(
aid?int(10)?unsigned?NOT?NULL?auto_increment,
blogid?int(10)?unsigned?NOT?NULL?default?'0',
filename?varchar(255)?NOT?NULL?default?'',
filesize?int(10)?NOT?NULL?default?'0',
filepath?varchar(255)?NOT?NULL?default?'',
addtime?bigint(20)?NOT?NULL?default?'0',
width?int(10)?NOT?NULL?default?'0',
height?int(10)?NOT?NULL?default?'0',
mimetype?varchar(40)?NOT?NULL?default?'',
thumfor?int(10)?NOT?NULL?default?0,
PRIMARY?KEY??(aid),
KEY?blogid?(blogid)
)".$table_charset_sql."
DROP?TABLE?IF?EXISTS?{$db_prefix}comment;
CREATE?TABLE?{$db_prefix}comment?(
cid?int(10)?unsigned?NOT?NULL?auto_increment,
gid?int(10)?unsigned?NOT?NULL?default?'0',
pid?int(10)?unsigned?NOT?NULL?default?'0',
date?bigint(20)?NOT?NULL,
poster?varchar(20)?NOT?NULL?default?'',
comment?text?NOT?NULL,
mail?varchar(60)?NOT?NULL?default?'',
url?varchar(75)?NOT?NULL?default?'',
ip?varchar(128)?NOT?NULL?default?'',
hide?enum('n','y')?NOT?NULL?default?'n',
PRIMARY?KEY??(cid),
KEY?gid?(gid),
KEY?date?(date),
KEY?hide?(hide)
)".$table_charset_sql."
DROP?TABLE?IF?EXISTS?{$db_prefix}options;
CREATE?TABLE?{$db_prefix}options?(
option_id?INT(?11?)?UNSIGNED?NOT?NULL?auto_increment,
option_name?VARCHAR(?255?)?NOT?NULL?,
option_value?LONGTEXT?NOT?NULL?,
PRIMARY?KEY?(option_id),
KEY?option_name?(option_name)
)".$table_charset_sql."
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('blogname','點滴記憶');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('bloginfo','使用emlog搭建的站點');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_title','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_description','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('site_key','emlog');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('log_title_style','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('blogurl','".BLOG_URL."');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('icp','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('footer_info','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('admin_perpage_num','15');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('rss_output_num','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('rss_output_fulltext','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_lognum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_comnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_twnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_newtwnum','5');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_newlognum','5');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_randlognum','5');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('index_hotlognum','5');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_subnum','20');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('nonce_templet','default');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('admin_style','default');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('tpl_sidenum','1');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_needchinese','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_interval',60);
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isgravatar','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isthumbnail','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('att_maxsize','20480');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('att_type','rar,zip,gif,jpg,jpeg,png,txt,pdf,docx,doc,xls,xlsx');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('att_imgmaxw','420');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('att_imgmaxh','460');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_paging','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_pnum','10');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('comment_order','newer');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('login_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('reply_code','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('iscomment','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ischkcomment','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ischkreply','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isurlrewrite','0');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isalias','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isalias_html','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isgzipenable','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isxmlrpcenable','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('ismobile','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('isexcerpt','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('excerpt_subnum','300');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('istwitter','y');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('istreply','n');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('topimg','content/templates/default/images/top/default.jpg');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('custom_topimgs','a:0:{}');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('timezone','8');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('active_plugins','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widget_title','$widget_title');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('custom_widget','a:0:{}');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widgets1','$widgets');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widgets2','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widgets3','');
INSERT?INTO?{$db_prefix}options?(option_name,?option_value)?VALUES?('widgets4','');
網(wǎng)站題目:php中建立數(shù)據(jù)表 php創(chuàng)建數(shù)據(jù)庫和表
本文路徑:http://www.chinadenli.net/article26/doogjjg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供響應(yīng)式網(wǎng)站、域名注冊、定制開發(fā)、云服務(wù)器、App設(shè)計、軟件開發(fā)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)