public function getMusic() { $infomusicModel = new Model_InfoMusic(); $filter['where'] = " id='{$this->info_id}' and customer_id='{$this->customer_id}' and state='1' "; $sql = $infomusicModel->select($filter); $inforesult = $infomusicModel->fetchRow($sql); $sql = "update info_music set push_num=push_num+1 where id='{$this->info_id}' and customer_id='{$this->customer_id}' limit 1"; $infomusicModel->query($sql); $data['msgtype'] = 'music'; $data['title'] = $inforesult['music_name']; $data['description'] = $inforesult['music_desc']; $data['url'] = $inforesult['url']; return $data; }
$act = isset($_REQUEST['act']) ? $_REQUEST['act'] : ''; $customer_id = (int) $_SESSION['customer_id']; $info_type = 'music'; $data = array(); //delete if ($act == 'del' && $id) { Model_Table::get('InfoMusic')->delete("id='{$id}' and customer_id='{$customer_id}'"); Model_Table::get('KeywordList')->delete("info_id='{$id}' and customer_id='{$customer_id}' and info_type='{$info_type}'"); // js_alter('','/home/info/test.php'); header("location:/home/info/index.php?type=music"); die; } //method:add||modify if ($id) { $music_table = new Model_InfoMusic(); $data = $music_table->fetchRow("select * from info_music where id='{$id}' and customer_id='{$customer_id}'"); $smarty->assign('infoRow', $data); } //submit if (method_is('post')) { $data['customer_id'] = $customer_id; $data['keyword'] = isset($_POST['keyword']) ? str_inmysql(str_replace(array(';', ','), ',', $_POST['keyword'])) : ''; $data['cate_id'] = isset($_POST['cate_id']) ? (int) $_POST['cate_id'] : ''; $data['music_name'] = isset($_POST['music_name']) ? str_inmysql($_POST['music_name']) : ''; $data['music_url'] = isset($_POST['music_url']) ? str_inmysql($_POST['music_url']) : ''; $data['music_desc'] = isset($_POST['music_desc']) ? str_inmysql($_POST['music_desc']) : ''; $data['state'] = isset($_POST['state']) ? str_inmysql($_POST['state']) : ''; $data['create_date'] = date('Y-m-d H:i:s', $_WGT['TIME']); if (!$data['keyword']) { ajax_feedback(0, '1201'); }