PHP qa_db_last_insert_id函数代码示例

function qa_db_user_create_by_id($FbId, $email, $password, $handle, $level, $ip)
{
    require_once QA_INCLUDE_DIR . 'qa-util-string.php';
    $salt = isset($password) ? qa_random_alphanum(16) : null;
    qa_db_query_sub('INSERT INTO ^users (userid,created, createip, email, passsalt, passcheck, level, handle, loggedin, loginip) ' . 'VALUES ($,NOW(), COALESCE(INET_ATON($), 0), $, $, UNHEX($), #, $, NOW(), COALESCE(INET_ATON($), 0))', $FbId, $ip, $email, $salt, isset($password) ? qa_db_calc_passcheck($password, $salt) : null, (int) $level, $handle, $ip);
    return qa_db_last_insert_id();
}

function widget_opt_update($name, $position, $order, $param, $id = false)
{
    if ($id) {
        qa_db_query_sub('UPDATE ^cs_widgets SET position = $, widget_order = #, param = $ WHERE id=#', $position, $order, $param, $id);
        return $id;
    } else {
        qa_db_query_sub('INSERT ^cs_widgets (name, position, widget_order, param) VALUES ($, $, #, $)', $name, $position, $order, $param);
        return qa_db_last_insert_id();
    }
}

function qa_db_post_create($type, $parentid, $userid, $cookieid, $ip, $title, $content, $format, $tagstring, $notify, $categoryid = null, $name = null)
{
    qa_db_query_sub('INSERT INTO ^posts (categoryid, type, parentid, userid, cookieid, createip, title, content, format, tags, notify, name, created) ' . 'VALUES (#, $, #, $, #, INET_ATON($), $, $, $, $, $, $, NOW())', $categoryid, $type, $parentid, $userid, $cookieid, $ip, $title, $content, $format, $tagstring, $notify, $name);
    return qa_db_last_insert_id();
}

function qa_db_message_create($fromuserid, $touserid, $content, $format)
{
    qa_db_query_sub('INSERT INTO ^messages (fromuserid, touserid, content, format, created) VALUES (#, #, $, $, NOW())', $fromuserid, $touserid, $content, $format);
    return qa_db_last_insert_id();
}

function qa_db_usernotice_create($userid, $content, $format = '', $tags = null)
{
    qa_db_query_sub('INSERT INTO ^usernotices (userid, content, format, tags, created) VALUES ($, $, $, $, NOW())', $userid, $content, $format, $tags);
    return qa_db_last_insert_id();
}

function qa_db_widget_create($title, $tags)
{
    $position = qa_db_read_one_value(qa_db_query_sub('SELECT 1+COALESCE(MAX(position), 0) FROM ^widgets'));
    qa_db_query_sub('INSERT INTO ^widgets (place, position, tags, title) VALUES (\'\', #, $, $)', $position, $tags, $title);
    return qa_db_last_insert_id();
}

 private function save_widget()
 {
     $widget = array();
     $widget['id'] = qa_post_text('wid');
     $widget['title'] = qa_post_text('wtitle');
     $widget['position'] = qa_post_text('wposition');
     $widget['ordering'] = qa_post_text('wordering');
     $widget['content'] = qa_post_text('wcontent');
     $pages = array();
     if (qa_post_text('wpages_all')) {
         $pages[] = 'all';
     } else {
         foreach ($this->templatelangkeys as $key => $lang) {
             if (qa_post_text('wpages_' . $key)) {
                 $pages[] = $key;
             }
         }
         if (qa_post_text('cb_custom_pages')) {
             $wpages_custom = explode(',', qa_post_text('wpages_custom'));
             foreach ($wpages_custom as $cp) {
                 $pages[] = 'custom:' . $cp;
             }
         }
     }
     $widget['pages'] = implode(',', $pages);
     if ($widget['id'] === '0') {
         $sql = 'INSERT INTO ^' . $this->pluginkey . ' (id, title, pages, position, ordering, content) VALUES (0, $, $, $, #, $)';
         $success = qa_db_query_sub($sql, $widget['title'], $widget['pages'], $widget['position'], $widget['ordering'], $widget['content']);
         $widget['id'] = qa_db_last_insert_id();
     } else {
         $sql = 'UPDATE ^' . $this->pluginkey . ' SET title=$, pages=$, position=$, ordering=#, content=$ WHERE id=#';
         $success = qa_db_query_sub($sql, $widget['title'], $widget['pages'], $widget['position'], $widget['ordering'], $widget['content'], $widget['id']);
     }
     return $widget;
 }

function qa_db_message_create($fromuserid, $touserid, $content, $format, $public = false)
{
    qa_db_query_sub('INSERT INTO ^messages (type, fromuserid, touserid, content, format, created) VALUES ($, #, #, $, $, NOW())', $public ? 'PUBLIC' : 'PRIVATE', $fromuserid, $touserid, $content, $format);
    return qa_db_last_insert_id();
}

function qw_dump_email_to_db($notifying_user, $queue_id)
{
    qa_db_query_sub('INSERT INTO ^ra_email_queue_receiver (userid, handle, email , name , queue_id ) ' . 'VALUES (#, $, $ , $ , # )', $notifying_user['userid'], $notifying_user['handle'], $notifying_user['email'], $notifying_user['name'], $queue_id);
    return qa_db_last_insert_id();
}

function updateQues($postid, $title = null, $content = null, $areaclass = null, $conclass = null, $tags = null, $istop = -1, $ishot = -1)
{
    $post = qa_post_get_full($postid);
    if ($istop == 1) {
        //如果设置了置顶，则将同类其它的帖子取消置顶
        setTopQuestion($postid);
    } elseif ($istop == 0) {
        unsetTopQuestion($postid);
    }
    if ($ishot == 1) {
        setHotQA($postid);
    } elseif ($ishot == 0) {
        unsetHotQA($postid);
    }
    if (!isset($title)) {
        $title = $post['title'];
    }
    if (!isset($content)) {
        $content = $post['content'];
    }
    if (!isset($areaclass)) {
        $title = @$post['areaclass'];
    }
    if (!isset($conclass)) {
        $content = @$post['conclass'];
    }
    $query = 'UPDATE ^posts set title=$, content=$, areaclass=$, conclass=$,tags=$';
    $query .= ' where postid= $';
    // echo $query.'<br />';
    // for ($i=0; $i < func_num_args(); $i++) {
    // 	$arg = func_get_arg($i);
    // 	echo $arg.'<br />';
    // }
    $arr = qa_db_query_sub($query, $title, $content, $areaclass, $conclass, $tags, $postid);
    return qa_db_last_insert_id();
}

 private function post_message($data)
 {
     $sql = 'INSERT INTO ^chat_posts (postid, userid, posted, message) VALUES (0, #, $, $)';
     qa_db_query_sub($sql, $data['userid'], $data['posted'], $data['message']);
     return qa_db_last_insert_id();
 }