PHPI做電子商務系統,那個購物車怎么建表啊?

在數據庫里面用表（ShopingCart）

10年積累的成都網站制作、做網站經驗，可以快速應對客戶對網站的新想法和需求。提供各種問題對應的解決方案。讓選擇我們的客戶得到更好、更有力的網絡服務。我雖然不認識你，你也不認識我。但先網站設計后付款的網站建設流程，更有閻良免費網站建設讓你可以放心的選擇與我們合作。

表有幾個基本字段

CartId 購物車ID（唯一）

Id 商品的ID（唯一）

Qty 用戶購買商品的數量

CreateDate 購物車創(chuàng)建時間

此表的字段CartId是區(qū)分不同用戶的購物車的ID，要是登陸用戶，你可以在表中存放此登陸用戶的登陸名的ID，要是未登陸用戶使用購物車，

如果是非登陸用戶

php mysql 創(chuàng)建數據表

$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());

?

通過ThinkPHP文件建立數據庫數據表

if(!is_writable('config.php')){

emMsg('配置文件(config.php)不可寫。如果您使用的是Unix/Linux主機，請修改該文件的權限為777。如果您使用的是Windows主機，請聯系管理員，將此文件設為可寫');

}

if(!is_writable(EMLOG_ROOT.'/content/cache')){

emMsg('緩存文件不可寫。如果您使用的是Unix/Linux主機，請修改緩存目錄?(content/cache)?下所有文件的權限為777。如果您使用的是Windows主機，請聯系管理員，將該目錄下所有文件設為可寫');

}

$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主機，請修改該文件的權限為777。如果您使用的是Windows主機，請聯系管理員，將此文件設為可寫');

}

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，這是系統自動生成的演示文章。編輯或者刪除它，然后開始您的創(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','');

如何通過php來創(chuàng)建數據庫和添加數據表

內閣密詔，千里獨行朝延上，曹操作威作福，許田打圍之時對獻帝無禮招致忠臣憤怒。皇帝密召國舅董承入宮，授以衣帶詔，教圖曹操。西涼馬騰與劉備最終亦參與此謀。劉備參與后為避曹操嫌疑，在園中種菜卻為曹操叫去賞梅。曹操煮酒論英雄令劉備吃驚，以畏雷之說巧妙掩飾。不久劉備即借剿滅袁術之機脫身，袁術與劉備交戰(zhàn)，大敗。于是袁術前往投降袁紹，于路中被劫，最終渴死。其部將割其首并玉璽一同交與曹操。[1]