PHP项目开发
PHP项目开发
===================================
member：(用户表)
userid username password name mobile emai address qq add_time edit_time status
category：(栏目表)
catid moduleid catname linkurl parentid
===================================
if($result){
$stu = new Classcourse_Model();
$cnt = $stu->allowField(true)->save($data);
if($cnt){
$arr = ['success'=>true,'msg'=>'添加成功'];
}else{
$arr = ['success'=>false,'msg'=>'添加失败'];
}
}else{
$arr = ['success'=>false,'msg'=>$result];
}
return json_encode($arr);
===================== 两个数组
$data = array('status' =>'0',"msg"=>'输入错误');
$data = ['status'=>0,'msg'=>'输入错误'];
return json($data);
// return json_encode($data);
{status: 0, msg: "输入错误"}
=====================
$data = array('status' =>'0',"msg"=>'验证码输入错误');
echo json_encode($data);
return;
三元表达式
$totime = $todate ? strtotime($todate.' 23:59:59') : 0;
-----------------------------------------------------
<input type="text" name="info['username']"><br><br>
$data = input('post.')['info'];
$_REQUEST['username'];
==========================================
function myfun()
{
// alert("this window.onload");
document.getElementById("company").value = '';
}
/*用window.onload调用myfun()*/
window.onload = myfun;//不要括号
---------
三元表达式
val = $('#captcha').val(); //获取div内容
switch($action) {
case 'detail':
echo ‘111’;
break;
case 'agreement':
break;
case 'success':
break;
default:
break;
}
---------------------------------------------
<form method="post" enctype="multipart/form-data" onsubmit="return check()">
<input type="submit" class="submit" value="立即注00册" onclick="sub()">
</form>
-------
function check(){
$username = $('#username').val();
if ($username=='') {
webToast("恭喜您，修改成功恭喜您，修改成功恭喜您修改成功恭喜您","middle",2000);
return false;
}
}
=======================================
function Dregister() {
var val,len;
val = $('#username').val();
len = val.length;
if(len < 5 || len > 16) {
Dtoast('会员名长度限制为5-16');
return false;
}
if(val.indexOf('__') != -1 || val.indexOf('--') != -1) {
Dtoast('会员名中划线和下划线不能连续出现');
return false;
}
if(!val.match(/^[a-z0-9]{1}[a-z0-9_\-]{0,}[a-z0-9]{1}$/)) {
Dtoast('会员名限制为小写字母、数字组合');
return false;
}
val = $('#password').val();
len = val.length;
if(len < {$MOD[minpassword]} || len > {$MOD[maxpassword]}) {
Dtoast('密码长度限制为{$MOD[minpassword]}-{$MOD[maxpassword]}');
return false;
}
val = $('#email').val();
len = val.length;
if(len < 7 || !val.match(/^[\w\-\.]+@[\w\-\.]+(\.\w+)+$/)) {
Dtoast('请填写正确的电子邮箱');
return false;
}
{if $itemid > 5}
val = $('#company').val();
len = val.length;
if(len < 4) {
Dtoast('请填写公司全称');
return false;
}
{/if}
val = $('#truename').val();
len = val.length;
if(len < 2) {
Dtoast('请填写真实姓名');
return false;
}
{if $verify_type=='mobile'}
val = $('#mobile').val();
if(!val.match(/^1[3|4|5|7|8]{1}[0-9]{9}$/)) {
Dtoast('请填写正确的手机号码');
return false;
}
{/if}
{if $MOD[captcha_register]}
val = $('#captcha').val();
if(!is_captcha(val)) {
Dtoast('请填写验证码');
return false;
}
{/if}
$.post('register.php', $('#dform').serialize(), function(data) {
if(data == 'ok') {
Go('register.php?action=success');
} else if(data == 'group') {
Dtoast('请选择会员组');
setTimeout(function() {
Go('register.php?reload={$DT_TIME}');
}, 1000);
} else if(data == 'passport') {
Dtoast('会员名已经被注册');
$('#username').val('');
} else if(data == 'captcha') {
Dtoast('验证码错误');
reloadcaptcha();
} else {
data = data.replace('昵称', '会员');
//alert(data);
Dtoast(data);
}
});
return;
}
===========================
-- 生活服务分类表
CREATE TABLE `o2o_category`(
`id` int(11) unsigned NOT NULL auto_increment,
`name` VARCHAR(50) NOT NULL DEFAULT '',
`parent_id` int(10) unsigned NOT NULL default 0,
`listorder` int(8) unsigned NOT NULL default 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY(`id`),
KEY parent_id(`parent_id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8;
-- 城市表
CREATE TABLE `o2o_city`(
`id` int(11) unsigned NOT NULL auto_increment,
`name` VARCHAR(50) NOT NULL DEFAULT '',
`uname` VARCHAR (50) NOT NULL DEFAULT '',
`parent_id` int(10) unsigned NOT NULL default 0,
`listorder` int(8) unsigned NOT NULL default 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY(`id`),
KEY parent_id(`parent_id`),
UNIQUE KEY uname(`uname`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
-- 商户表
CREATE TABLE `o2o_bis`(
`id` int(11) unsigned NOT NULL auto_increment,
`name` VARCHAR(50) NOT NULL DEFAULT '',
`email` VARCHAR(50) NOT NULL DEFAULT '',
`logo` VARCHAR(255) NOT NULL DEFAULT '',
`licence_logo` VARCHAR(255) NOT NULL DEFAULT '',
`description` text NOT NULL,
`city_id` int(11) unsigned NOT NULL DEFAULT 0,
`city_path` VARCHAR(50) NOT NULL DEFAULT '',
`bank_info` varchar(50) NOT NULL DEFAULT '',
`money` DECIMAL (20,2) NOT NULL DEFAULT '0.00',
`bank_name` varchar(50) NOT NULL DEFAULT '',
`bank_user` VARCHAR (50) NOT NULL DEFAULT '',
`faren` VARCHAR (20) NOT NULL DEFAULT '',
`faren_tel` varchar(20) NOT NULL DEFAULT '',
`listorder` int(8) unsigned NOT NULL default 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY(`id`),
KEY city_id(`city_id`),
KEY name(`name`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8;
-- 商户账号表
CREATE TABLE `o2o_bis_account`(
`id` int(11) unsigned NOT NULL auto_increment,
`username` VARCHAR(50) NOT NULL DEFAULT '',
`password` char(32) NOT NULL default '',
`code` varchar(10) NOT NULL default 0,
`bis_id` int(11) unsigned NOT NULL DEFAULT 0,
`last_login_ip` VARCHAR(20) NOT NULL default '',
`last_login_time` int(11) unsigned NOT NULL default 0,
`is_main` tinyint(1) unsigned NOT NULL DEFAULT 0,
`listorder` int(8) unsigned NOT NULL default 0,
`status` tinyint(1) NOT NULL DEFAULT 0,
`create_time` int(11) unsigned NOT NULL DEFAULT 0,
`update_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY(`id`),
KEY bis_id(`bis_id`),
KEY username(`usearname`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8;
