Exemple #1
0
 function save(Entity $entity)
 {
     $vars = get_object_vars($entity);
     //print_r($vars);
     if ($vars['id'] == 0) {
         $vars['id'] == 'NULL';
     }
     $cols = array();
     $values = array();
     $updates = array();
     foreach ($vars as $key => $value) {
         $cols[] = "`{$key}`";
         $values[] = ' :' . $key . ' ';
         $updates[] = " `{$key}` = VALUES(`{$key}`) ";
     }
     $col = implode(",", $cols);
     $value = implode(",", $values);
     $update = implode(",", $updates);
     $sql = "INSERT INTO {$this->tableName()} ({$col}) VALUES ({$value}) ON DUPLICATE KEY UPDATE {$update}";
     $res = $this->db->query($sql, $vars);
     if ($res === FALSE) {
         return FALSE;
     }
     if ($entity->id == 0) {
         $entity->id = $this->db->lastInsertId();
     }
     return $entity;
 }
 public function insert_comment($sid, $msg, $parent, $author_name, $author_email)
 {
     // Connect to database
     try {
         $handler = new Database();
         // Insert comment to database
         if ($parent !== 'NULL') {
             $handler->beginTransaction();
             // If comment has a parent begin transaction
         }
         $res = $handler->prepare('INSERT INTO `comment`(`sid`, `author_name`, `author_email`, `message`, `parent`) VALUES (:sid, :author_name, :author_email, :message, :parent)');
         $res->execute(array(':sid' => $sid, ':author_name' => $author_name, ':author_email' => $author_email, ':message' => $msg, ':parent' => $parent));
         if ($res->rowCount() !== 1) {
             return false;
         }
         // Get cid of last comment
         $cid = $handler->lastInsertId();
         if ($parent !== 'NULL') {
             $res = $handler->prepare('UPDATE `comment` SET `children` = 1 WHERE `cid` = :parent');
             $res->execute(array(':parent' => $parent));
             $handler->commit();
             // Commit only if both queries succeed
         }
     } catch (PDOException $e) {
         if ($parent !== 'NULL') {
             $handler->rollback();
         }
         return false;
     }
     return $cid;
 }
	function sendMessage($id_author, $to_users, $subject, $body, $time, $thread_id = false) {
		if (!is_array($to_users))
			throw new Exception('$to_users must be an array');
		Database::query('START TRANSACTION');
		$query = 'INSERT INTO `users_messages` SET
			`id_author`=' . $id_author . ',
			`time`=' . $time . ',
			`subject`=' . Database::escape($subject) . ',
			`html`=' .  Database::escape($body);
		Database::query($query);
		// если есть тред - пишем в тот же тред
		$lastId = Database::lastInsertId();
		$thread_id = $thread_id ? $thread_id : $lastId;
		if ($thread_id) {
			$q = array();
			foreach ($to_users as $receiver_id) {
				$is_new = ($receiver_id == $id_author) ? 0 : 1;
				$q[] = '(' . $lastId . ',' . $thread_id . ',' . $receiver_id . ',' . $is_new . ',0)';
			}
			if (count($q)) {
				$query = 'INSERT INTO `users_messages_index`(message_id,thread_id,id_recipient,is_new,is_deleted) VALUES ' . implode(',', $q);
				Database::query($query);
			}
		}
		Database::query('COMMIT');
	}
Exemple #4
0
 function edit_event()
 {
     $id = $_POST['id'] ? $_POST['id'] : 'NULL';
     $_POST['template_id'] = max(1, (int) $_POST['template_id']);
     Database::query('INSERT INTO `lib_events` SET
         `id` = ' . $id . ',
         `title`=' . Database::escape($_POST['title']) . ',
         `male`=' . Database::escape($_POST['male']) . ',
         `age_start_days`=' . Database::escape($_POST['age_start_days']) . ',
         `age_end_days`=' . Database::escape($_POST['age_end_days']) . ',
         `description`=' . Database::escape($_POST['description']) . ',
         
         `template_id`=' . Database::escape($_POST['template_id']) . '
             ON DUPLICATE KEY UPDATE
         `title`=' . Database::escape($_POST['title']) . ',
         `male`=' . Database::escape($_POST['male']) . ',
         `age_start_days`=' . Database::escape($_POST['age_start_days']) . ',
         `age_end_days`=' . Database::escape($_POST['age_end_days']) . ',
         `description`=' . Database::escape($_POST['description']) . ',
         
         `template_id`=' . Database::escape($_POST['template_id']) . '
             ');
     $id = $id == 'NULL' ? Database::lastInsertId() : $id;
     header('Location: /admin/event/' . $id . '/edit');
 }
 public function CreateBankProcess($param)
 {
     parent::query('INSERT INTO dd_bank(bk_code,bk_account_branch,bk_account_name,bk_account_number) VALUE(:code,:branch,:name,:number)');
     parent::bind(':code', $param['code']);
     parent::bind(':branch', $param['branch']);
     parent::bind(':name', $param['name']);
     parent::bind(':number', $param['number']);
     parent::execute();
     return parent::lastInsertId();
 }
Exemple #6
0
 public function CreateMatchingProcess($param)
 {
     parent::query('INSERT INTO dy_place_to_tag(pt_place_id,pt_tag_id,pt_create_time,pt_update_time) VALUE(:place_id,:tag_id,:create_time,:update_time)');
     parent::bind(':place_id', $param['place_id']);
     parent::bind(':tag_id', $param['tag_id']);
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::execute();
     return parent::lastInsertId();
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $db->execute('INSERT INTO followers (user, follower) VALUES (?, ?)', array($this->user, $this->follower));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE followers SET user = ?, follower = ? WHERE id = ?';
         $db->execute($req, array($this->user, $this->follower, $this->id));
     }
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $req = 'INSERT INTO stream_email (server, account, password, port, firstUpdate) VALUES (?, ?, ?, ?, ?)';
         $db->execute($req, array($this->server, $this->account, $this->password, $this->port, $this->firstUpdate));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE stream_email SET server = ?, account = ?, password = ?, port = ?, firstUpdate = ? WHERE id = ?';
         $db->execute($req, array($this->server, $this->account, $this->password, $this->port, $this->firstUpdate, $this->id));
     }
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $req = 'INSERT INTO stream_category (stream, category, streamType) VALUES (?, ?, ?)';
         $db->execute($req, array($this->stream, $this->category, $this->streamType));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE stream_category SET stream = ?, category = ?, streamType = ? WHERE id = ?';
         $db->execute($req, array($this->stream, $this->category, $this->streamType, $this->id));
     }
 }
 function _new()
 {
     $title = trim(Request::post('title'));
     if (!$title) {
         throw new Exception('title missed');
     }
     $query = 'INSERT INTO `rightholders` SET `title`=' . Database::escape($title);
     Database::query($query);
     @ob_end_clean();
     header('Location: /admin/rightholders/' . Database::lastInsertId());
     exit;
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $req = 'INSERT INTO article (title, content, articleDate, streamType, url, stream_id) VALUES (?, ?, ?, ?, ?, ?)';
         $db->execute($req, array($this->title, $this->content, $this->articleDate, $this->streamType, $this->url, $this->stream_id));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE article SET title = ?, content = ?, articleDate = ?, streamType = ?, url = ?, stream_id = ? WHERE id = ?';
         $db->execute($req, array($this->title, $this->content, $this->articleDate, $this->streamType, $this->url, $this->stream_id, $this->id));
     }
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $req = 'INSERT INTO blog (account, article) VALUES (?, ?)';
         $db->execute($req, array($this->account, $this->article));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE blog SET account = ?, article = ? WHERE id = ?';
         $db->execute($req, array($this->account, $this->article, $this->id));
     }
 }
 public function persist()
 {
     $db = new Database();
     if ($this->id == null) {
         $req = 'INSERT INTO accounts (authentification, username, email, userKey, active, accountLevel, picture) VALUES (?, ?, ?, ?, ?, ?, ?)';
         $db->execute($req, array($this->authentification, $this->username, $this->email, $this->userKey, $this->active, $this->accountLevel, $this->picture));
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE accounts SET authentification = ?, username = ?, email = ?, userKey = ?, active = ?, accountLevel = ?, picture = ? WHERE id = ?';
         $db->execute($req, array($this->authentification, $this->username, $this->email, $this->userKey, $this->active, $this->accountLevel, $this->picture, $this->id));
     }
 }
Exemple #14
0
 function add_album_relation_link()
 {
     $album_id = $_POST['album_id'];
     $role = $_POST['role'];
     Database::query('INSERT INTO  `album_invites` SET
         `album_id`=' . $album_id . ',
         `inviter_user_id 	`=' . CurrentUser::$id . ',
         `family_role`=' . $role);
     $uniqid = Database::lastInsertId();
     $data = array();
     $data['link'] = 'http://' . Config::need('www_domain') . '/invite/' . $album_id . '/' . $role . '/' . md5($uniqid);
     return $data;
 }
Exemple #15
0
 /**
  * Create a new DVD to the database
  * 
  * @return mixed	False if failed, admin url otherwise
  */
 public function create()
 {
     $this->publicUrl = strtolower(urlencode($this->title));
     $this->adminHash = substr(md5($this->title . time() . rand()), 0, 8);
     $dbh = new Database();
     $sth = $dbh->prepare("INSERT INTO " . DB_PREFIX . "dvds (title, author, email, publish_date, deadline_date, status, show_frontpage, description, public_url, admin_hash) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
     if (!$sth->execute(array($this->title, $this->author, $this->email, $this->publishDate, $this->deadlineDate, $this->status, $this->showFrontpage, $this->description, $this->publicUrl, $this->adminHash))) {
         return false;
     }
     $this->id = (int) $dbh->lastInsertId();
     $adminUrl = SITE_URL . '/' . $this->id . '/' . $this->publicUrl . '/' . $this->adminHash;
     return $adminUrl;
 }
Exemple #16
0
	function _update($data, $tableName) {
		$q = array();
		$this->dropCache();
		foreach ($data as $field => $value) {
			if (isset($this->fieldsMap[$field])) {
				$q[] = '`' . $field . '`=' . Database::escape($value);
			}else
				throw new Exception('_create failed: illegal field #' . $field);
		}
		if (count($q)) {
			Database::query('UPDATE `' . $tableName . '` SET ' . implode(',', $q) . ' WHERE `id`=' . $this->id);
			return $lid = Database::lastInsertId();
		}
	}
Exemple #17
0
 public function setSettings($store_id, $array)
 {
     if (!is_numeric($store_id)) {
         Database::query("INSERT INTO PREFIX_stores SET name = :name", array('name' => crc32(microtime(true))));
         $store_id = Database::lastInsertId();
         return $this->setSettings($store_id, $array);
     }
     if (!is_array($array)) {
         return;
     }
     foreach ($array as $key => $value) {
         $this->setSetting($store_id, $key, $value);
     }
 }
 public function CreateMoneyTransferProcess($param)
 {
     parent::query('INSERT INTO dd_money_transfer(mf_order_id,mf_to_bank,mf_member_id,mf_total,mf_description,mf_create_time,mf_update_time,mf_type) VALUE(:order_id,:to_bank,:member_id,:total,:description,:create_time,:update_time,:type)');
     parent::bind(':order_id', $param['order_id']);
     parent::bind(':to_bank', $param['to_bank']);
     parent::bind(':member_id', $param['member_id']);
     parent::bind(':total', $param['total']);
     parent::bind(':description', $param['description']);
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::bind(':type', $param['type']);
     parent::execute();
     return parent::lastInsertId();
 }
Exemple #19
0
    public function registerUser($name, $role_id, $email, $password, $phone, $lang_id, $birthday, $company = false)
    {
        // Accepts 5 arguments in the array: name, email, password, phone, lang_id, birthday (optional)
        // $settings = array(string $name, string $email, string $phone, int $lang_id [, date(YYYY-MM-DD) $birthday ] );
        // setting values from settings array
        $date_registered = date("Y-m-d");
        // checking if email exists
        if ($this->userEmailExist($email)) {
            throw new Exception(Translate::string("user.email_already_exists"), 1);
        } else {
            $db = new Database();
            $db->beginTransaction();
            // setting the user properties and validating
            $this->setName($name);
            $this->setRole($role_id);
            $this->setEmail($email);
            $this->setPassword($password);
            $this->setPhone($phone);
            $this->setDateRegistred($date_registered);
            $this->setLangID($lang_id);
            $this->setBirthday($birthday);
            $db->query('INSERT INTO users ( name, role_id, email, password, phone, date_registered, lang_id, birthday) 
								   VALUES (:name,:role_id,:email,:password,:phone,:date_registered,:lang_id,:birthday) ');
            $db->bind(':name', $this->name());
            $db->bind(':role_id', $this->role());
            $db->bind(':email', $this->email());
            $db->bind(':password', $this->password());
            $db->bind(':phone', $this->phone());
            $db->bind(':date_registered', $this->dateRegistred());
            $db->bind(':lang_id', $this->langID());
            $db->bind(':birthday', $this->birthday());
            $db->execute();
            $newUserID = $db->lastInsertId();
            if ($company) {
                $db->query('INSERT INTO companies ( user_id, company_name, company_number, company_address, company_zip, phone_2) 
										   VALUES (:user_id, :company_name,:company_number,:company_address,:company_zip,:phone_2) ');
                $db->bind(':user_id', $newUserID);
                $db->bind(':company_name', $this->company_name);
                $db->bind(':company_number', $this->company_number);
                $db->bind(':company_address', $this->company_address);
                $db->bind(':company_zip', $this->company_zip);
                $db->bind(':phone_2', $this->phone_2);
                $db->execute();
            }
            $db->endTransaction();
            $this->setID($newUserID);
            $this->checkCredentials($this->email(), $password, 1, $_SERVER["HTTP_USER_AGENT"], $_SERVER["REMOTE_ADDR"], session_id());
        }
    }
Exemple #20
0
    public static function addCity($id_country, $name)
    {
        if (!$id_country) {
            return false;
        }
        $query = 'INSERT INTO `lib_city` SET `verified`=0, `name`=' . Database::escape($name) . ',`country_id`=' . (int) $id_country . '
			ON DUPLICATE KEY UPDATE `country_id`=' . (int) $id_country;
        Database::query($query);
        $id = Database::lastInsertId();
        if (!$id) {
            $id = Database::sql2single('SELECT id FROM `lib_city` WHERE `country_id`=' . (int) $id_country . '
				AND  `name`=' . Database::escape($name));
        }
        return $id;
    }
 public function CreateCommentProcess($param)
 {
     parent::query('INSERT INTO dy_comment(cm_parent_id,cm_token,cm_member_id,cm_post_id,cm_message,cm_create_time,cm_update_time,cm_ip,cm_type) VALUE(:parent_id,:token,:member_id,:post_id,:message,:create_time,:update_time,:ip,:type)');
     parent::bind(':parent_id', $param['parent_id']);
     parent::bind(':token', $param['token']);
     parent::bind(':member_id', $param['member_id']);
     parent::bind(':post_id', $param['post_id']);
     parent::bind(':message', $param['message']);
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::bind(':ip', parent::GetIpAddress());
     parent::bind(':type', $param['type']);
     parent::execute();
     return parent::lastInsertId();
 }
 public function CreateImageProcess($param)
 {
     parent::query('INSERT INTO dd_image(im_product_id,im_member_id,im_caption,im_filename,im_format,im_create_time,im_update_time,im_type,im_status) VALUE(:product_id,:member_id,:caption,:filename,:format,:create_time,:update_time,:type,:status)');
     parent::bind(':product_id', $param['product_id']);
     parent::bind(':member_id', $param['member_id']);
     parent::bind(':caption', $param['caption']);
     parent::bind(':filename', $param['filename']);
     parent::bind(':format', $param['format']);
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::bind(':type', $param['type']);
     parent::bind(':status', $param['status']);
     parent::execute();
     return parent::lastInsertId();
 }
 /**
  * @covers Database::insert
  * @covers Database::selectOne
  */
 public function testInsert()
 {
     $this->assertEquals(1, $this->db->insert('test', array('name' => 'Other test')));
     $this->assertEquals(4, $this->db->lastInsertId('test', 'id'));
     $r1 = $this->db->selectOne('*', 'test', array('id' => 4));
     $this->assertEquals('Other test', $r1['name']);
     $this->assertEquals(array('id', 'name'), array_keys($r1));
     //Errors test
     $this->assertFalse(LoggerApp::hasError(), LoggerApp::getLastError());
     $this->assertEquals(0, $this->db->insert('test', array('name' => 'Other test', 'id' => 1)));
     $this->assertTrue(LoggerApp::hasError(), 'Não gerou o erro esperado');
     LoggerApp::clear();
     $this->assertEquals(0, $this->db->insert('testinvalid', array('name' => 'Other test', 'xyz' => 1)));
     $this->assertTrue(LoggerApp::hasError(), 'Não gerou o erro esperado');
 }
    function write()
    {
        $id = Request::post('entry_id');
        $title = Request::post('title');
        $body = Request::post('body');
        $id_parent = Request::post('answer_to');
        global $current_user;
        $query = 'SELECT * FROM `blog_entries` WHERE `id`=' . $id;
        $data = Database::sql2row($query);
        $entry = new Entrie($data);
        if (!$current_user->authorized) {
            throw new Exception('must be autorized');
        }
        if (!$body) {
            throw new Exception('body missed');
        }
        if (!$title) {
            throw new Exception('title missed');
        }
        if ($id_parent) {
            // answer
            $query = 'SELECT * FROM `blog_entries_comments` WHERE `id`=' . $id_parent;
            $parent_comment = Database::sql2row($query);
            if ($parent_comment['id_parent'] > 0) {
                $answer_to = $id_parent;
                $id_parent = $parent_comment['id_parent'];
            } else {
                $answer_to = $id_parent;
                $id_parent = $parent_comment['id'];
            }
        } else {
            $answer_to = 0;
            $id_parent = 0;
        }
        $query = 'INSERT INTO `blog_entries_comments` SET
			`id_entry`=' . $id . ',
			`id_user`=' . $current_user->id . ',
			`id_parent`=' . $id_parent . ',
			`time`=' . time() . ',
			`title`=' . Database::escape($title) . ',
			`comment`=' . Database::escape($body) . ',
			`answer_to`=' . $answer_to;
        Database::query($query);
        $comment_id = Database::lastInsertId();
        $entry->updateCommentsCount();
        header('Location: ' . '/blog/' . $entry->user->getNickName() . '/' . $entry->id . '#comment-' . $comment_id);
        exit(0);
    }
Exemple #25
0
    function register($nickname, $email, $password)
    {
        $hash = md5($email . $nickname . $password . time());
        $query = 'INSERT INTO `users` SET
			`email`=\'' . $email . '\',
			`password`=\'' . md5($password) . '\',
			`nickname`=\'' . $nickname . '\',
			`hash` = \'' . $hash . '\'';
        if (Database::query($query)) {
            $this->id = Database::lastInsertId();
            if ($this->id) {
                return $hash;
            }
        }
        return false;
    }
 public function persist()
 {
     $db = new Database();
     $firstUpdate = date(Database::DATE_FORMAT, strtotime($this->firstUpdate));
     $lastUpdate = date(Database::DATE_FORMAT, strtotime($this->lastUpdate));
     if ($this->id == null) {
         $req = 'INSERT INTO stream_twitter (channel, firstUpdate, lastUpdate) VALUES (?, ?, ?)';
         $data = array($this->channel, $firstUpdate, $lastUpdate);
         $db->execute($req, $data);
         $this->id = $db->lastInsertId();
     } else {
         $req = 'UPDATE stream_twitter SET channel = ?, firstUpdate = ?, lastUpdate = ? WHERE id = ?';
         $data = array($this->channel, $firstUpdate, $lastUpdate, $this->id);
         $db->execute($req, $data);
     }
 }
 public function CreateProcess($param)
 {
     parent::query('INSERT INTO base_image(im_page_id,im_people_id,im_caption,im_filename,im_format,im_create_time,im_update_time,im_ip,im_type,im_status) VALUE(:page_id,:people_id,:caption,:filename,:format,:create_time,:update_time,:ip,:type,:status)');
     parent::bind(':page_id', $param['page_id']);
     parent::bind(':people_id', $param['people_id']);
     parent::bind(':caption', $param['caption']);
     parent::bind(':filename', $param['filename']);
     parent::bind(':format', $param['format']);
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::bind(':ip', parent::GetIpAddress());
     parent::bind(':type', $param['type']);
     parent::bind(':status', $param['status']);
     parent::execute();
     return parent::lastInsertId();
 }
Exemple #28
0
 public function CreateTokenProcess($param)
 {
     parent::query('INSERT INTO base_token(tk_people_id,tk_token,tk_device,tk_model,tk_os,tk_browser,tk_user_agent,tk_ip,tk_create_time,tk_update_time,tk_expired) VALUE(:people_id,:token,:device,:model,:os,:browser,:user_agent,:ip,:create_time,:update_time,:expired)');
     parent::bind(':people_id', $param['facebook_id']);
     parent::bind(':token', $param['new_token']);
     parent::bind(':device', $param['device']);
     parent::bind(':model', $param['model']);
     parent::bind(':os', $param['os']);
     parent::bind(':browser', $param['browser']);
     parent::bind(':user_agent', $param['user_agent']);
     parent::bind(':ip', parent::GetIpAddress());
     parent::bind(':create_time', date('Y-m-d H:i:s'));
     parent::bind(':update_time', date('Y-m-d H:i:s'));
     parent::bind(':expired', $param['expired']);
     parent::execute();
     return parent::lastInsertId();
 }
 function _new()
 {
     global $current_user;
     Request::$post['lang_code'] = Config::$langs[Request::$post['lang_code']];
     $fields = array('title' => 'title', 'isbn' => 'ISBN', 'lang_code' => 'id_lang', 'annotation' => 'annotation');
     $to_update = array();
     foreach ($fields as $field => $magazinefield) {
         if (!isset(Request::$post[$field])) {
             throw new Exception('field missed #' . $field);
         }
         $to_update[$magazinefield] = Request::$post[$field];
     }
     $q = array();
     foreach ($to_update as $field => &$value) {
         if (in_array($field, array('ISBN', 'year'))) {
             $value = is_numeric($value) ? $value : 0;
         }
         $q[] = '`' . $field . '`=' . Database::escape($value) . '';
     }
     if (count($q)) {
         $query = 'INSERT INTO `magazines` SET ' . implode(',', $q);
         Database::query($query);
         $lid = Database::lastInsertId();
         MagazineLog::addLog($to_update, array(), $lid);
         MagazineLog::saveLog($lid, BookLog::TargetType_magazine, $current_user->id, BiberLog::BiberLogType_magazineNew);
         $search = Search::getInstance();
         /* @var $search Search */
         $search->setMagazineToFullUpdate($lid);
     }
     if (isset($_FILES['cover']) && $_FILES['cover']['tmp_name']) {
         $folder = Config::need('static_path') . '/upload/mcovers/' . ceil($lid / 5000);
         @mkdir($folder);
         chmod($folder, 755);
         $filename = $folder . '/' . $lid . '.jpg';
         $upload = new UploadAvatar($_FILES['cover']['tmp_name'], 100, 100, "simple", $filename);
         if ($upload->out) {
             $to_update['is_cover'] = 1;
         } else {
             throw new Exception('cant copy file to ' . $filename, 100);
         }
     }
     ob_end_clean();
     header('Location:' . Config::need('www_path') . '/m/' . $lid);
     exit;
 }
Exemple #30
0
    public function CreatePlaceProcess($param)
    {
        parent::query('INSERT INTO dy_place(pl_token,pl_member_id,pl_name,pl_description,pl_province_id,pl_city_id,pl_district_id,pl_register_time,pl_update_time,pl_visit_time,pl_ip) 
			VALUE(:token_id,:member_id,:name,:description,:province_id,:city_id,:district_id,:register_time,:update_time,:visit_time,:ip)');
        parent::bind(':token_id', $param['token_id']);
        parent::bind(':member_id', $param['member_id']);
        parent::bind(':name', $param['name']);
        parent::bind(':description', $param['description']);
        parent::bind(':province_id', $param['province_id']);
        parent::bind(':city_id', $param['city_id']);
        parent::bind(':district_id', $param['district_id']);
        parent::bind(':register_time', date('Y-m-d H:i:s'));
        parent::bind(':update_time', date('Y-m-d H:i:s'));
        parent::bind(':visit_time', date('Y-m-d H:i:s'));
        parent::bind(':ip', parent::GetIpAddress());
        parent::execute();
        return parent::lastInsertId();
    }