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; }