if (!$res['error']) {
echo location_js("文件上传失败，原因:{$res['info']}", 'add.php');
die;
}
//ok,文件上传成功，这里可以执行缩放了
imageResize($res['info'], $path, 64, 64, '64_');
//缩放图片为64宽高的尺寸，文件名以64_开头
imageResize($res['info'], $path, 218, 218, '218_');
imageResize($res['info'], $path, 428, 428, '428_');
//ok,图片上传成功
//获取数据
$typeid = $_POST['typeid'];
$goods = $_POST['goods'];
$company = $_POST['company'];
$descr = $_POST['descr'];
$price = $_POST['price'];
$picname = $file;
$store = $_POST['store'];
$addtime = time();
$tag = $_POST['tag'];
//组合sql语句
$sql = "insert into " . PREFIX . "goods(typeid,goods,company,descr,price,picname,store,addtime,tag) values('{$typeid}','{$goods}','{$company}','{$descr}','{$price}','{$res['info']}','{$store}','{$addtime}','{$tag}')";
//echo $sql;
//die();
$result = mysql_query($sql);
//echo mysql_insert_id($conn);
if ($result && mysql_insert_id($conn) > 0) {
echo location_js('商品添加成功', './index.php');
}
break;
}
} else {
echo location_js('您的用户名或密码错误', './login.php');
}
break;
case 'doreg':
if (strtolower($_POST['yzm']) != strtolower($_SESSION['yzm'])) {
echo location_js('验证码不正确！', './reg.php');
die;
}
$username = $_POST['username'];
$pass = $_POST['pass'];
$repass = $_POST['repass'];
if ($pass != $repass) {
echo location_js('两次密码不一致！', './reg.php');
die;
}
$pass = md5($pass);
//准备sql语句
$sql = "insert into " . PREFIX . "users(username,pass) values('{$username}','{$pass}')";
$result = mysql_query($sql);
if ($result && mysql_insert_id($conn) > 0) {
//将信息存放到session
$user = array('id' => mysql_insert_id($conn), 'username' => $username);
$_SESSION['user'] = $user;
echo location_js('您已注册成功,即将跳转至首页', './index.php');
} else {
echo location_js('注册失败', './reg.php');
}
break;
}
mysql_close($conn);
$sql = "update " . PREFIX . "links set url='{$url}',picname='{$picname}',explaina='{$explain}' where id={$id}";
//echo $sql;
//die();
$result = mysql_query($sql);
if ($result && mysql_affected_rows()) {
echo location_js('修改链接成功', './index.php');
} else {
echo location_js('修改链接失败', './index.php');
}
break;
case 'add':
//获取信息
$name = $_POST['name'];
$url = $_POST['url'];
$picname = $_POST['picname'];
$explain = $_POST['explain'];
//组合sql
$sql = "insert into " . PREFIX . "links values(null,'{$name}','{$url}','{$picname}','{$explain}')";
//echo $sql;
//die();
$result = mysql_query($sql);
$m = mysql_insert_id();
//取得上一步insert产生的id
if ($result && $m > 0) {
echo location_js('链接添加成功', './index.php');
} else {
echo location_js('链接插入失败', './add.php');
}
break;
}
mysql_close($conn);
break;
case 'add':
//var_dump($_POST);
//获取数据条数；
$num = count($_POST) / 6;
//遍历拼接，组合sql
for ($i = 0; $i < $num; $i++) {
//拼接变量名
$orderid = 'orderid' . $i;
$goodsid = 'goodsid' . $i;
$name = 'name' . $i;
$price = 'price' . $i;
$score = 'score' . $i;
$content = 'content' . $i;
$addtime = time();
$str .= "(null,'{$_SESSION['user']['id']}','{$_POST[$orderid]}','{$_POST[$goodsid]}','{$_POST[$name]}','{$_POST[$price]}','{$_POST[$content]}','{$_POST[$score]}','{$addtime}'),";
}
//清除右边的逗号
$str = rtrim($str, ',');
//sql插入多条数据
$sql = "insert into " . PREFIX . "comment values" . $str;
//echo $sql; die;
$result = myQueryInsert($sql);
//var_dump($result);
if ($result) {
echo location_js('评论成功', './showcomment.php');
} else {
echo '失败';
}
break;
}
$sqlb = "update " . PREFIX . "type set path=replace(path,{$_GET['pid']},{$_POST['pid']}) where path like '{$likePath}%'";
//echo $sqlb;
$resb = mysql_query($sqlb);
if ($resa) {
echo '分类修改成功';
} else {
echo '分类修改失败';
}
if ($resb) {
echo '子分类跟随成功';
} else {
echo '子分类跟随失败';
}
break;
case 'add':
//接收数据
$name = $_POST['name'];
$pid = $_POST['pid'];
$path = $_POST['path'];
//组合sql
$sql = "insert into " . PREFIX . "type values(null,'{$name}','{$pid}','{$path}')";
//echo $sql;die();
$result = mysql_query($sql);
if ($result && mysql_insert_id()) {
echo location_js('添加成功', './index.php');
} else {
echo location_js('添加失败', './index.php');
}
break;
}
mysql_close($conn);
<input type="submit" class="box-ok box-button-style-1" value="提交"/>
</div>
<div id="arrival-error" class="box-form-tips hide">
<span class="icon-error">输入有误</span>
</div>
</textarea>
<!-- 20140726-频道-列表-start -->
<div class="channel-list">
<!-- 20140727-商品列表-start -->
<div class="pro-list clearfix">
<ul>
<?php
if (empty($_GET['word'])) {
echo location_js('请输入搜索词', './index.php');
die;
}
$word = $_GET['word'];
$where = "where goods like '%{$word}%' and state=2";
//遍历数据
$sqldd = "select * from " . PREFIX . "goods {$where}";
//echo $sqldd;die;
$resultdd = myQuery($sqldd);
//图片路径
$path = "../public/uploads/";
if ($resultdd) {
foreach ($resultdd as $a => $value) {
?>
<!--隐藏表单传数据-->
<input type="hidden" id="goods_id<?php
$sqlb = "update " . PREFIX . "type set path=replace(path,{$_GET['pid']},{$_POST['pid']}) where path like '{$likePath}%'";
//echo $sqlb;
$resb = mysql_query($sqlb);
if ($resa) {
echo '分类修改成功';
} else {
echo '分类修改失败';
}
if ($resb) {
echo '子分类跟随成功';
} else {
echo '子分类跟谁失败';
}
break;
case 'add':
//接收数据
$name = $_POST['name'];
$pid = $_POST['pid'];
$path = $_POST['path'];
//组合sql
$sql = "insert into " . PREFIX . "type values(null,'{$name}','{$pid}','{$path}')";
//echo $sql;die();
$result = mysql_query($sql);
if ($result && mysql_insert_id()) {
echo location_js('添加成功', './index.php');
} else {
echo location_js('添加失败', './add.php');
}
break;
}
mysql_close($conn);
if ($result) {
echo location_js('收货完成', './home.php');
} else {
echo location_js('失败', './home.php');
}
break;
case 'qx':
//取消订单
$id = $_GET['id'];
$sql = "update " . PREFIX . "orders set status=3 where id={$id}";
//echo $sql;die;
$result = myQueryUpdate($sql);
if ($result) {
echo location_js('取消订单成功', './home.php');
} else {
echo location_js('失败', './home.php');
}
break;
case 'submit':
//var_dump($_POST);die;
//获取收货地址id,遍历数据
$Addressid = $_POST['myAddress'];
$sqldz = "select * from " . PREFIX . "address where id={$Addressid}";
$resdz = myQuery($sqldz);
//收货人
$linkman = $resdz['0']['linkman'];
$address = $resdz['0']['address'];
$code = $resdz['0']['code'];
$phone = $resdz['0']['phone'];
//foreach遍历购物车
if (!empty($_SESSION['shoplist'])) {
//echo $sql;die;
$result = myQueryUpdate($sql);
if ($result) {
echo location_js('修改为无效订单成功！', './index.php');
} else {
echo '删除失败';
}
break;
case 'add':
//获取数据
$uid = $_POST['uid'];
$linkman = $_POST['linkman'];
$address = $_POST['address'];
$code = $_POST['code'];
$phone = $_POST['phone'];
$addtime = time();
$total = $_POST['total'];
$status = $_POST['status'];
//组合sql
$sql = "insert into " . PREFIX . "orders(uid,linkman,address,code,phone,addtime,total,status) values('{$uid}','{$linkman}','{$address}','{$code}','{$phone}','{$addtime}','{$total}','{$status}')";
//echo $sql;
//die();
$result = mysql_query($sql);
if ($result && mysql_insert_id() > 0) {
echo location_js('数据插入成功', './index.php');
} else {
echo location_js('数据插入失败!', './add.php');
die;
}
break;
}
