Ajax技术在购物车中的应用（PHP篇）_技术笔记

定格_尘缘 2018-05-12

desc table 查看表的中有哪些字段，表结构

截图
0赞 · 0采集
定格_尘缘 2018-05-12

select * from table\G格式化输出查询结果，在命令行中

截图
0赞 · 0采集
堕落之罪 2016-11-13

CREATE TABLE shop_cart( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, productid bigint(20) UNSIGNED NOT NULL DEFAULT 0, userid bigint(20) UNSIGNED NOT NULL DEFAULT 0, num int(10) UNSIGNED NOT NULL DEFAULT 1, price float(8,2) UNSIGNED NOT NULL DEFAULT 0.00, createtime int(10) UNSIGNED NOT NULL DEFAULT 0 )ENGINE=Innodb DEFAULT CHARSET=utf8;

2赞 · 8采集
小安Andrew 2016-10-22

shopcart数据表

截图
0赞 · 1采集
_莫忘初衷_ 2016-06-11

商品数据库

截图
0赞 · 0采集
光荣交白卷哥 2016-05-24

shop_cartj结构

截图
2赞 · 1采集
面瘫兔子 2016-04-05

insert into `shop_product`(`id`,`title`,`describe`,`price`,`originalprice`,`inventory`,`categoryid`,`brandid`,`adminid`,`ishot`,`isputaway`,`isonsale`,`onsaleprice`,`cover`,`updatetime`,`createtime`) values (1,'Apple/苹果银色铝金属表壳搭配白色运动型表带',NULL,2588,2588,100,1,1,1,1,1,0,0,'根据自己本地环境填图片地址','2015-12-20 11:47:16',1417013251),(2,'苹果 Apple Watch Sport 玫瑰金色铝金属表壳薰衣草紫色运动表带',NULL,2436,2588,100,1,1,1,1,1,0,0,'根据自己本地环境填图片地址','2015-12-20 11:47:16',1417013251); 楼下的建表语句少一行数据呀，补上了

4赞 · 14采集
嗨_可爱的小菇凉 2016-04-01

/*Data for the table `shop_product` */ insert into `shop_product`(`id`,`title`,`describe`,`price`,`originalprice`,`inventory`,`categoryid`,`brandid`,`adminid`,`ishot`,`isputaway`,`isonsale`,`onsaleprice`,`cover`,`updatetime`,`createtime`) values (1,'Apple/苹果银色铝金属表壳搭配白色运动型表带',NULL,2588,2588,100,1,1,1,1,1,0,0,'根据自己本地环境填图片地址','2015-12-20 11:47:16',1417013251),(2,'苹果 Apple Watch Sport 玫瑰金色铝金属表壳薰衣草紫色运动表带',NULL,2436,2588,100,1,1,1,1,1,0,0,'根据自己本地环境填图片地址',1417013251); 图片地址根据自己环境填写

3赞 · 2采集
嗨_可爱的小菇凉 2016-04-01

CREATE TABLE `shop_product` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) default NULL, `describe` varchar(255) default NULL, `price` float unsigned NOT NULL, `originalprice` float unsigned NOT NULL, `inventory` int(5) unsigned default NULL, `categoryid` int(5) unsigned default NULL, `brandid` int(5) unsigned default NULL, `adminid` int(5) unsigned default NULL, `ishot` int(5) unsigned default NULL, `isputaway` int(5) unsigned default NULL, `isonsale` int(5) unsigned default NULL, `onsaleprice` float unsigned default NULL, `cover` varchar(255) default NULL, `updatetime` datetime default NULL, `createtime` int(10) unsigned default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

11赞 · 18采集
angle‘天使 2016-03-29

CREATE TABLE shop_cart( id bigint(20) UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT PRIMARY KEY, productid bigint(20) UNSIGNED NOT NULL DEFAULT 0, userid bigint(20) UNSIGNED NOT NULL DEFAULT 0, num int(10) UNSIGNED NOT NULL DEFAULT 1, price float(8,2) UNSIGNED NOT NULL DEFAULT 0.00, createtime int(10) UNSIGNED NOT NULL DEFAULT 0 )ENGINE=Innodb DEFAULT CHARSET=utf8;

7赞 · 7采集
张的高 2016-03-26

CREATE TABLE shop_cart( id bigint(20) UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT PRIMARY KEY, productid bigint(20) UNSIGNED NOT NULL DEFAULT 0, userid bigint(20) UNSIGNED NOT NULL DEFAULT 0, num int(10) UNSIGNED NOT NULL DEFAULT 1, price float(8,2) UNSIGNED NOT NULL DEFAULT 0.00, createtime int(10) UNSIGNED NOT NULL DEFAULT 0 )ENGINE=Innodb DEFAULT CHARSET=utf8;

2赞 · 1采集

数据加载中...