/** * Created by PhpStorm. * User: administrator * Date: 2015/7/17 * Time: 15:47 */ function issue() { $arr = $_POST; $arr['username'] = $_SESSION['username']; $arr['is_send'] = 0; $arr['hot'] = 0; $arr['reg_time'] = time(); $arr['status'] = 0; $path = "./uploads"; $uploadFiles = uploadFile($path); $result = insert("tuhao_pro", $arr); $pid = getInsertId(); if ($result && $pid) { if ($uploadFiles) { foreach ($uploadFiles as $uploadFile) { $arr1['pid'] = $pid; $arr1['album_path'] = $uploadFile['name']; insert("tuhao_album", $arr1); } } $message = array('success' => true, 'mes' => "发布成功", 'pro_id' => $pid); } else { $message = array('success' => false, 'mes' => "发布失败"); } return json_encode($message); }
/** *添加评论 */ function addComm() { $mes = array(); $parent_id = addslashes($_POST['parent_id']); $pro_id = addslashes($_POST['pro_id']); $sender_id = $_SESSION['id']; $receiver_id = addslashes($_POST['receiver_id']); if ($receiver_id == '') { $receiver_id = 0; } $content = addslashes($_POST['text']); $comm = array('parent_id' => $parent_id, 'pro_id' => $pro_id, 'sender_id' => $sender_id, 'receiver_id' => $receiver_id, 'content' => $content, 'status' => 0, 'reg_time' => time()); if (insert("tuhao_comm", $comm)) { $id = getInsertId(); $sql = "select * from tuhao_comm where id={$id}"; $row = fetchOne($sql); $sql1 = "select pro_name from tuhao_pro where id={$row['pro_id']}"; $sql2 = "select head_photo from tuhao_info where user_id={$row['sender_id']}"; $sql3 = "select username from tuhao_user where id={$row['sender_id']}"; $sql4 = "select username from tuhao_user where id={$row['receiver_id']}"; $sender = fetchOne($sql3); $receiver = fetchOne($sql4); $proName = fetchOne($sql1); $src = fetchOne($sql2); $row['sender_author'] = $sender['username']; $row['receiver_author'] = $receiver['username']; $row['goods_name'] = $proName['pro_name']; $row['src'] = "uploads/" . $src['head_photo']; $row['comments'] = array(); $mes = array('mes' => '评论成功', 'code' => 1, 'data' => $row); } else { $mes = array('mes' => '评论失败', 'code' => 0); } echo json_encode($mes); }
function addUser() { $arr = $_POST; $arr['pubTime'] = time(); $path = "../uploads"; $uploadFiles = uploadFile($path); $totalCap = $arr['capacity'] + getCityCapById($arr['cId']); $sql = "update biogas_city set totalCap=" . $totalCap . " where id=" . $arr['cId']; mysql_query($sql); //更新城市的总池容 $res = insert("biogas_user", $arr); $uid = getInsertId(); if ($res && $uid) { if ($uploadFiles && is_array($uploadFiles)) { foreach ($uploadFiles as $uploadFile) { $arr1['uid'] = $uid; $arr1['albumPath'] = $uploadFile['name']; addAlbum($arr1); } } $mes = "<p>添加成功!</p><a href='addUser.php' target='mainFrame'>继续添加</a>|<a href='listUser.php' target='mainFrame'>查看用户列表</a>"; } else { $mes = "<p>添加失败!</p><a href='addUser.php' target='mainFrame'>重新添加</a>"; } return $mes; }
/** * 添加商品 * @return string */ function addPro() { //POST来信息存储在$arr数组中 $arr = $_POST; //发布时间,定义为当前时间 $arr['pubTime'] = time(); //存储路径为uploads $path = "./uploads"; //调用上传文件函数 $uploadFiles = uploadFile($path); //判断是否有值 if (is_array($uploadFiles) && $uploadFiles) { //遍历数组产生缩略图并存储进各目录中,这里../image_50代表根目录下的image_50文件夹 foreach ($uploadFiles as $key => $uploadFile) { thumb($path . "/" . $uploadFile['name'], "../image_50/" . $uploadFile['name'], 50, 50); thumb($path . "/" . $uploadFile['name'], "../image_220/" . $uploadFile['name'], 220, 220); thumb($path . "/" . $uploadFile['name'], "../image_350/" . $uploadFile['name'], 350, 350); thumb($path . "/" . $uploadFile['name'], "../image_800/" . $uploadFile['name'], 800, 800); } } //调用插入函数 $res = insert("imooc_pro", $arr); //得到刚刚执行的insert操作产生的ID $pid = getInsertId(); //判断是否insert成功 if ($res && $pid) { //循环uploadFiles里的值,获得id、albumPath并插入数据库中 foreach ($uploadFiles as $uploadFile) { $arr1['pid'] = $pid; $arr1['albumPath'] = $uploadFile['name']; //调用album.inc.php里的addAlbum函数 addAlbum($arr1); } $mes = "<p>添加成功!</p><a href='addPro.php' target='mainFrame'>继续添加</a>|<a href='listPro.php' target='mainFrame'>查看商品列表</a>"; } else { //若不成功,删除对应文件 foreach ($uploadFiles as $uploadFile) { if (file_exists("../image_800/" . $uploadFile['name'])) { //若不成功,删除对应文件 unlink("../image_800/" . $uploadFile['name']); } if (file_exists("../image_50/" . $uploadFile['name'])) { unlink("../image_50/" . $uploadFile['name']); } if (file_exists("../image_220/" . $uploadFile['name'])) { unlink("../image_220/" . $uploadFile['name']); } if (file_exists("../image_350/" . $uploadFile['name'])) { unlink("../image_350/" . $uploadFile['name']); } } $mes = "<p>添加失败!</p><a href='addPro.php' target='mainFrame'>重新添加</a>"; } return $mes; }
function add_member() { $arr = $_POST; // return print_r($arr); if (empty($arr['name'])) { $msg = "成员姓名是必填项哦!<meta http-equiv='refresh' content='1;url=" . $_SERVER['HTTP_REFERER'] . "'/>"; return $msg; exit; } //头像不是必填项,检测是否上传成员头像,若没有(error=4)则不处理头像 if ($_FILES['avatar']['error'] != 4) { // 上传头像,并生成80*80和150*150的两张缩略图 $uploadFile = uploadFile('images/uploads/avatar/'); if ($uploadFile && is_array($uploadFile)) { $arr['avatar'] = $uploadFile[0]['name']; } else { return "添加成员失败<meta http-equiv='refresh' content='1;url=" . $_SERVER['HTTP_REFERER'] . "'/>"; } thumb("images/uploads/avatar/" . $uploadFile[0]['name'], "images/uploads/avatar_150/" . $uploadFile[0]['name'], 150, 150); thumb("images/uploads/avatar/" . $uploadFile[0]['name'], "images/uploads/avatar_80/" . $uploadFile[0]['name'], 80, 80); } //电话号不是必填项,检测是否输入,若没有则不创建$arr_phone数组 if (!empty($arr['phone'])) { $arr_phone['phone'] = $arr['phone']; $arr_phone['owner'] = $arr['owner']; } //推荐人不是必填项,检测是否有值,若不为false则创建$arr_father数组 if ($arr['father_mid'] !== 'false') { $arr_father['mid'] = $arr['father_mid']; } unset($arr['father_mid']); unset($arr['phone']); unset($arr['owner']); // print_r($arr); // print_r($arr_phone); // 向数据库插入数据 insert('hh_member', $arr); $mid = getInsertId(); //若$arr_phone数组不存在(用户没有输入电话号),则不进行写入hh_phone数据库的操作 if (isset($arr_phone)) { $arr_phone['mid'] = $mid; insert('hh_phone', $arr_phone); } //若$arr_father数组不存在(用户没有推荐人),则不进行写入hh_son数据库的操作 if (isset($arr_father)) { $arr_father['child'] = $mid; insert('hh_son', $arr_father); } $msg = "成功添加 " . $arr['name'] . " 为快乐学习营成员!<br/>2秒钟后跳转到成员信息页面!<meta http-equiv='refresh' content='2;url=member.php?mid=" . $mid . "'/>"; return $msg; }
/** * ��������Ա�˺�ͨ��user_id�����Ϣ * @return string */ function addHouse() { $arr = $_POST; $arr['pub_time'] = date('Y-m-d H:i:s'); //$path="../uploads"; //��������һ��user_id����Ϊ�ù���Աװ�Ź������û��� $user_id = $arr['user_id']; print_r($user_id); exit; $path = "uploads/house_images/user_id_" . $user_id; $uploadFiles = uploadFile($path); if (is_array($uploadFiles) && $uploadFiles) { foreach ($uploadFiles as $key => $uploadFile) { thumb($path . "/" . $uploadFile['name'], "../image_50/" . $uploadFile['name'], 50, 50); // thumb($path."/".$uploadFile['name'],"../image_220/".$uploadFile['name'],220,220); // thumb($path."/".$uploadFile['name'],"../image_350/".$uploadFile['name'],350,350); // thumb($path."/".$uploadFile['name'],"../image_800/".$uploadFile['name'],800,800); } } $res = insert("tigris_house_info", $arr); //print_r($res);exit; //����õ�����tigris_user_profile���primary key(house_id), �Դ������������?��ÿһ��house����Ψһalbum $album_id = getInsertId(); //print_r($album_id);exit; if ($res && $album_id) { foreach ($uploadFiles as $uploadFile) { $arr1['album_id'] = $album_id; $arr1['img_path'] = $uploadFile['name']; addAlbum($arr1); } $mes = "<p>Add success!</p><a href='addHouse.php' target='mainFrame'>Add more</a>|<a href='listHouse.php' target='mainFrame'>View house list</a>"; } else { foreach ($uploadFiles as $uploadFile) { // if(file_exists("../image_800/".$uploadFile['name'])){ // unlink("../image_800/".$uploadFile['name']); // } if (file_exists("../image_50/" . $uploadFile['name'])) { unlink("../image_50/" . $uploadFile['name']); } // if(file_exists("../image_220/".$uploadFile['name'])){ // unlink("../image_220/".$uploadFile['name']); // } // if(file_exists("../image_350/".$uploadFile['name'])){ // unlink("../image_350/".$uploadFile['name']); // } } $mes = "<p>Failed!</p><a href='addHouse.php' target='mainFrame'>Add</a>"; } return $mes; }
function insertNote($noteContent) { // Make connection to the database. $dbInfo = initialize_db_info(); $dbLink = db_connect($dbInfo); db_select($dbLink, $dbInfo); $insertNoteSql = generateInsertNoteSql($noteContent); $result = mysql_query($insertNoteSql, $dbLink); if (!$result) { echo $insertNoteSql; throw new Exception('Insert Note Failed: ' . $insertNoteSql); } $noteId = getInsertId(); return $noteId; }
/** * 添加商品 * @return string */ function addPro() { $arr = $_POST; $arr['pubTime'] = time(); $path = "./uploads"; $uploadFiles = uploadFile($path); if (is_array($uploadFiles) && $uploadFiles) { foreach ($uploadFiles as $key => $uploadFile) { thumb($path . "/" . $uploadFile['name'], "../image_50/" . $uploadFile['name'], 50, 50); thumb($path . "/" . $uploadFile['name'], "../image_220/" . $uploadFile['name'], 220, 220); thumb($path . "/" . $uploadFile['name'], "../image_350/" . $uploadFile['name'], 350, 350); thumb($path . "/" . $uploadFile['name'], "../image_800/" . $uploadFile['name'], 800, 800); } } $res = insert("imooc_pro", $arr); $pid = getInsertId(); if ($res && $pid) { foreach ($uploadFiles as $uploadFile) { $arr1['pid'] = $pid; $arr1['albumPath'] = $uploadFile['name']; addAlbum($arr1); } $mes = "<p>添加成功!</p><a href='addPro.php' target='mainFrame'>继续添加</a>|<a href='listPro.php' target='mainFrame'>查看商品列表</a>"; } else { foreach ($uploadFiles as $uploadFile) { if (file_exists("../image_800/" . $uploadFile['name'])) { unlink("../image_800/" . $uploadFile['name']); } if (file_exists("../image_50/" . $uploadFile['name'])) { unlink("../image_50/" . $uploadFile['name']); } if (file_exists("../image_220/" . $uploadFile['name'])) { unlink("../image_220/" . $uploadFile['name']); } if (file_exists("../image_350/" . $uploadFile['name'])) { unlink("../image_350/" . $uploadFile['name']); } } $mes = "<p>添加失败!</p><a href='addPro.php' target='mainFrame'>重新添加</a>"; } return $mes; }
/** * 添加记录 * @return string */ function post() { if (getPostNumByUid($_SESSION['uid']) >= maxPost) { $msg = "你的记录总数达到上限 (" . maxPost . "条),已不能继续发布记录. <br>若有疑问请联系管理员:huang_hao521@163.com"; return $msg; } $arr = $_POST; array_splice($arr, 1, 1); //删除数组中注册不需要用到的submit和verify元素 $arr['date'] = date("Y-m-j" . " " . "H:i:s"); //匹配数据库中的datetime时间格式 $arr['uid'] = $_SESSION['uid']; // 判断是否有记录图片都没有 if (empty($arr['post']) && empty($_FILES['postImage']['name'])) { $msg = "填写内容或添加图片后再添加!<meta http-equiv='refresh' content='1;url=user.php'/>"; return $msg; exit; } $res = insert("zhx_post", $arr); if ($res) { $pmsg = "记录发布成功!"; } $pid = getInsertId(); //获取记录pid用来插入图片 // return print_r($arr); //若有图片添加,则上传图片 if (!empty($_FILES['postImage']['name'])) { // print_r($uploadFile);exit; $uploadFile = uploadFile("images/uploads/postImage/"); if ($uploadFile && is_array($uploadFile)) { $album['image'] = $uploadFile[0]['name']; thumb("images/uploads/postImage/" . $album['image'], "images/uploads/postImage_500/" . $album['image'], 500); $album['pid'] = $pid; insert("zhx_album", $album); $imsg = "添加图片成功!"; } else { $imsg = "添加图片失败!"; } } $msg = $pmsg . " " . @$imsg . "<meta http-equiv='refresh' content='1;url=user.php'/>"; return $msg; }
function register() { $username = addslashes($_POST['nickname']); $email = addslashes($_POST['email']); $password = addslashes($_POST['password']); $reg_time = time(); $token = md5($username . $password . $reg_time); //创建用于激活识别码 $token_exptime = time() + 7 * 60 * 60 * 24; //过期时间为7天 $sex = addslashes($_POST['sex']); $college = addslashes($_POST['college']); $enroll_year = addslashes($_POST['enroll_year']); $address = addslashes($_POST['address']); $user = array('username' => $username, 'password' => md5($password), 'email' => $email, 'token' => $token, 'token_exptime' => $token_exptime, 'reg_time' => $reg_time); insert('tuhao_user', $user); $id = getInsertId(); $sql = "select * from tuhao_user where id={$id}"; $user = fetchOne($sql); $toMail = $user['email']; $subject = '账户激活'; $username = $user['username']; $token = $user['token']; $head = array('header1.jpg', 'header2.jpg', 'header3.jpg'); $rand = rand(0, 2); $src = $head[$rand]; $body = "亲爱的" . $username . ":<br/>感谢您在我站注册了新帐号。<br/>请点击链接激活您的帐号。<br/>\n <a href='http://tuhao.hustonline.net/doAction.php?action=active&verify=" . $token . "' target=\n'_blank'>http://tuhao.hustonline.net/doAction.php?action=active&verify=" . $token . "</a><br/>\n 如果以上链接无法点击,请将它复制到你的当前浏览器地址栏中进入访问,该链接24小时内有效。"; $info = array('user_id' => $id, 'sex' => $sex, 'college' => $college, 'enroll_year' => $enroll_year, 'address' => $address, 'head_photo' => $src, 'levell' => 1, 'score' => 0, 'week_score' => 0, 'inc_score' => 0); if (insert('tuhao_info', $info)) { $res = sendMail($toMail, $subject, $body); if ($res == 1) { $message = array('success' => true, 'mes' => '邮件发送成功'); } } else { $message = array('success' => false); } return json_encode($message); }
function gigs_saveGig($request) { $gig_id = dbEscape(isset($request['gig_id']) ? $request['gig_id'] : ''); $fields = array(); $gig = $request['data']; foreach (array('title', 'description', 'date', 'start_time', 'end_time', 'meet_time', 'band_start', 'band_end', 'location', 'who', 'contact', 'details', 'tactical', 'musical', 'approved', 'public_description', 'notes', 'colors', 'type', 'url') as $key) { if (isset($gig[$key])) { if (in_array($key, array('start_time', 'end_time', 'meet_time', 'band_start', 'band_end'))) { $gig[$key] = date('H:i', strtotime($gig[$key])); } elseif ($key == 'date') { $date = str_replace('/', '-', $gig[$key]); $date = date_create_from_format('m-d-Y', $date) ?: date_create_from_format('Y-m-d', $date); //$date = date_create_from_format('Y-m-d', $gig[$key]); $gig[$key] = date_format($date, 'Y-m-d'); } array_push($fields, "{$key}='" . dbEscape($gig[$key]) . "'"); } } if (!isset($gig['details'])) { $details = ""; foreach (array('cause', 'event_history', 'arrestable', 'has_permit', 'cops', 'people_of_color', 'relevant_communities', 'blo_role', 'other_groups', 'sound', 'other') as $key) { $details .= strtoupper($key) . ": " . (isset($gig[$key]) ? $gig[$key] : '') . "\n\n"; } array_push($fields, "details='" . dbEscape($details) . "'"); } if (isset($gig['setlist'])) { array_push($fields, "setlist='" . dbEscape(implode(",", $gig['setlist'])) . "'"); } //$title = dbEscape($gig['title']); $new_gig = 0; if ($gig_id) { $res = dbWrite("update gigs set " . implode(",", $fields) . " where gig_id={$gig_id}"); } else { $res = dbwrite("insert into gigs set " . implode(",", $fields)); $new_gig = 1; $gig_id = getInsertId(); $gig['gig_id'] = $gig_id; } $gig = gigs_fetchGig($gig); saveToCalendar($gig); if ($gig['approved'] == 1) { saveToCalendar($gig, 'public'); } elseif ($gig['approved'] == -1) { deleteFromCalendar($gig, 'public'); } if ($new_gig && $gig['type'] == 'gig') { sendEmails($gig); } return $gig; }
function bagCheckSaveHarvestInformation($oneBirdGroup) { // Make connection to the database. $dbInfo = initialize_db_info(); $dbLink = db_connect($dbInfo); db_select($dbLink, $dbInfo); $speciesList = $oneBirdGroup->getSpeciesList(); $birdGroupId = $oneBirdGroup->getId(); $speciesSeq = 0; foreach ($speciesList as $oneSpecies) { $speciesId = $oneSpecies->getId(); if ($speciesId == -1) { // Insert new $insertSql = generateBCSpeciesInsertSql($oneSpecies, $birdGroupId, $speciesSeq); $result = mysql_query($insertSql, $dbLink); if (!$result) { echo $insertSql; throw new Exception('Save Insert Species Info Failed: ' . $insertSql); } $speciesId = getInsertId(); $oneSpecies->setId($speciesId); } else { // Update existing $updateSql = generateBCSpeciesUpdateSql($oneSpecies, $birdGroupId, $speciesSeq); $result = mysql_query($updateSql, $dbLink); if (!$result) { echo $updateSql; throw new Exception('Save Update Species Info Failed: ' . $updateSql); } } $speciesSeq++; } }