php查询车位系统代码,PHP基于MVC模式下的停车场车位管理系统、448源码下载

最新推荐文章于 2022-08-21 13:33:44 发布

聂小远

最新推荐文章于 2022-08-21 13:33:44 发布

阅读量474

点赞数

文章标签： php查询车位系统代码

此内容涉及两个数据库表的创建与数据插入，包括`allusers`表的用户信息，如用户名、权限和创建时间；以及`cheliangchurujilu`和`cheweixiaoshoujilu`表的车辆出入记录和车位销售记录，包含车牌号、车型、车位状态等详细信息。此外，还有`cheweixinxi`表的车位信息更新和`danjia`表的单价设置。

摘要由CSDN通过智能技术生成

/*Navicat MySQL Data Transfer

Source Server : localhost_3306

Source Server Version : 50160

Source Host : localhost:3306

Source Database : phptcccwglxt

Target Server Type : MYSQL

Target Server Version : 50160

File Encoding : 65001

Date: 2018-04-05 23:09:43*/

SET FOREIGN_KEY_CHECKS=0;--------------------------------Table structure for `allusers`------------------------------

DROP TABLE IF EXISTS`allusers`;CREATE TABLE`allusers` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`username`VARCHAR(50) DEFAULT NULL,

`pwd`VARCHAR(50) DEFAULT NULL,

`cx`VARCHAR(50) DEFAULT ‘普通管理员‘,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;--------------------------------Records of allusers------------------------------

INSERT INTO `allusers` VALUES (‘2‘, ‘hsg‘, ‘hsg‘, ‘超级管理员‘, ‘2018-04-04 07:46:56‘);INSERT INTO `allusers` VALUES (‘4‘, ‘aa‘, ‘aa‘, ‘普通管理员‘, ‘2018-04-04 07:46:56‘);INSERT INTO `allusers` VALUES (‘5‘, ‘bb‘, ‘bb‘, ‘普通管理员‘, ‘2018-04-04 07:46:56‘);INSERT INTO `allusers` VALUES (‘6‘, ‘1‘, ‘1‘, ‘普通管理员‘, ‘2018-04-05 01:16:29‘);INSERT INTO `allusers` VALUES (‘7‘, ‘2‘, ‘2‘, ‘普通管理员‘, ‘2018-04-05 01:25:20‘);--------------------------------Table structure for `cheliangchurujilu`------------------------------

DROP TABLE IF EXISTS`cheliangchurujilu`;CREATE TABLE`cheliangchurujilu` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`chepai`VARCHAR(50) DEFAULT NULL,

`chexing`VARCHAR(50) DEFAULT NULL,

`tingkaochewei`VARCHAR(50) DEFAULT NULL,

`chezhudianhua`VARCHAR(50) DEFAULT NULL,

`shenfenzheng`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(50) DEFAULT NULL,

`tingcheshichang`VARCHAR(50) DEFAULT NULL,

`tingchefeiyong`VARCHAR(50) DEFAULT NULL,

`issh`VARCHAR(10) DEFAULT ‘否‘,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

`shichushijian`VARCHAR(50) DEFAULT NULL,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;--------------------------------Records of cheliangchurujilu------------------------------

INSERT INTO `cheliangchurujilu` VALUES (‘2‘, ‘浙B35263‘, ‘小轿‘, ‘005‘, ‘2552323‘, ‘23626232372‘, ‘gewgewhewh‘, ‘7‘, ‘21‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘3‘, ‘京B23445‘, ‘小轿‘, ‘005‘, ‘437437347‘, ‘74584585484‘, ‘egewhewhw‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘4‘, ‘浙B35263‘, ‘小轿‘, ‘005‘, ‘3262362‘, ‘63473733‘, ‘hrehre‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘5‘, ‘浙B35263‘, ‘小轿‘, ‘005‘, ‘2552323‘, ‘23626232372‘, ‘gewwe‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘6‘, ‘浙B35263‘, ‘小轿‘, ‘005‘, ‘2552323‘, ‘23626232372‘, ‘‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘7‘, ‘浙B35261‘, ‘小轿‘, ‘002‘, ‘4373734‘, ‘745845754‘, ‘hrhrehe‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘8‘, ‘浙C45879‘, ‘小轿‘, ‘002‘, ‘63262323‘, ‘210212548210212548‘, ‘ewggwe‘, ‘25‘, ‘75‘, ‘是‘, ‘2018-04-04 07:46:56‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheliangchurujilu` VALUES (‘9‘, ‘1233232‘, ‘越野‘, ‘006‘, ‘323213123‘, ‘3233232323‘, ‘12312312‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-05 01:15:15‘, ‘2018-04-05 1:15:21‘);INSERT INTO `cheliangchurujilu` VALUES (‘10‘, ‘32313123‘, ‘小轿‘, ‘008‘, ‘123123‘, ‘3321321321321‘, ‘3123123123123‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-05 01:16:08‘, ‘2018-04-05 1:16:13‘);INSERT INTO `cheliangchurujilu` VALUES (‘11‘, ‘22222‘, ‘小轿‘, ‘008‘, ‘231312‘, ‘3123123‘, ‘123123123‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-05 01:24:28‘, ‘2018-04-05 1:24:33‘);INSERT INTO `cheliangchurujilu` VALUES (‘12‘, ‘23231323‘, ‘小轿‘, ‘23232‘, ‘123123123123‘, ‘123123123123‘, ‘1231231232‘, ‘1‘, ‘3‘, ‘是‘, ‘2018-04-05 01:25:03‘, ‘2018-04-05 1:25:10‘);--------------------------------Table structure for `cheweixiaoshoujilu`------------------------------

DROP TABLE IF EXISTS`cheweixiaoshoujilu`;CREATE TABLE`cheweixiaoshoujilu` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`cheweihao`VARCHAR(50) DEFAULT NULL,

`weizhi`VARCHAR(50) DEFAULT NULL,

`chezhuxingming`VARCHAR(50) DEFAULT NULL,

`chezhudianhua`VARCHAR(50) DEFAULT NULL,

`chepaihao`VARCHAR(50) DEFAULT NULL,

`shenfenzheng`VARCHAR(50) DEFAULT NULL,

`dianhua`VARCHAR(50) DEFAULT NULL,

`shoujia`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(50) DEFAULT NULL,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;--------------------------------Records of cheweixiaoshoujilu------------------------------

INSERT INTO `cheweixiaoshoujilu` VALUES (‘2‘, ‘002‘, ‘后巷‘, ‘张三‘, ‘2552323‘, ‘浙C46342‘, ‘23626232372‘, ‘53262362‘, ‘120000‘, ‘gwgiowgow‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixiaoshoujilu` VALUES (‘3‘, ‘003‘, ‘草坪‘, ‘李四‘, ‘62236326‘, ‘京A44888‘, ‘6232722632‘, ‘34623623‘, ‘120000‘, ‘挺gwhwehh‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixiaoshoujilu` VALUES (‘4‘, ‘006‘, ‘地下室‘, ‘htrjtr‘, ‘437734743‘, ‘浙C46345‘, ‘773473436‘, ‘437457574‘, ‘120000‘, ‘gewgewhw‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixiaoshoujilu` VALUES (‘5‘, ‘005‘, ‘地下室‘, ‘wgwewe‘, ‘63262323‘, ‘浙C23526‘, ‘433473733463‘, ‘25235223‘, ‘25000‘, ‘gewg‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixiaoshoujilu` VALUES (‘6‘, ‘004‘, ‘地下室‘, ‘12313‘, ‘3123123‘, ‘32321‘, ‘3232333333333333‘, ‘333212331‘, ‘20000‘, ‘123213‘, ‘2018-04-05 01:14:40‘);INSERT INTO `cheweixiaoshoujilu` VALUES (‘7‘, ‘008‘, ‘008‘, ‘12313‘, ‘123123‘, ‘312312‘, ‘12312312312323‘, ‘123123‘, ‘123123‘, ‘213213123213213‘, ‘2018-04-05 01:24:12‘);--------------------------------Table structure for `cheweixinxi`------------------------------

DROP TABLE IF EXISTS`cheweixinxi`;CREATE TABLE`cheweixinxi` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`cheweihao`VARCHAR(50) DEFAULT NULL,

`weizhi`VARCHAR(300) DEFAULT NULL,

`daxiao`VARCHAR(50) DEFAULT NULL,

`zhuangtai`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(50) DEFAULT NULL,

`issh`VARCHAR(10) DEFAULT ‘否‘,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;--------------------------------Records of cheweixinxi------------------------------

INSERT INTO `cheweixinxi` VALUES (‘2‘, ‘001‘, ‘地下室‘, ‘小轿车‘, ‘空闲‘, ‘gewgew‘, ‘否‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘3‘, ‘002‘, ‘后巷‘, ‘面包车‘, ‘空闲‘, ‘ewgwgew‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘4‘, ‘003‘, ‘草坪‘, ‘小轿车‘, ‘空闲‘, ‘rehwhw‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘5‘, ‘004‘, ‘地下室‘, ‘大巴车‘, ‘空闲‘, ‘heherhr‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘6‘, ‘005‘, ‘地下室‘, ‘小轿车‘, ‘空闲‘, ‘gwehehw‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘7‘, ‘006‘, ‘地下室‘, ‘面包车‘, ‘空闲‘, ‘gewgewh‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘8‘, ‘007‘, ‘gweeh‘, ‘面包车‘, ‘占用‘, ‘wgwewe‘, ‘是‘, ‘2018-04-04 07:46:56‘);INSERT INTO `cheweixinxi` VALUES (‘9‘, ‘008‘, ‘008‘, ‘小轿车‘, ‘空闲‘, ‘2313123‘, ‘是‘, ‘2018-04-05 01:15:50‘);INSERT INTO `cheweixinxi` VALUES (‘10‘, ‘23232‘, ‘32323232323‘, ‘小轿车‘, ‘空闲‘, ‘23232323232323‘, ‘否‘, ‘2018-04-05 01:24:46‘);--------------------------------Table structure for `danjia`------------------------------

DROP TABLE IF EXISTS`danjia`;CREATE TABLE`danjia` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`dj`DOUBLE DEFAULT NULL,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;--------------------------------Records of danjia------------------------------

INSERT INTO `danjia` VALUES (‘1‘, ‘3‘);