・・・省略・・・

・・・省略・・・

// データ
$data = array(
    'username' => 'Bertie',
    'email' => 'bertie@example.com',
);
 
// 上記のデータを元に抽出
$sql = 'SELECT user_password
    FROM ' . USERS_TABLE . '
    WHERE ' . $db->sql_build_array('SELECT', $data);
$result = $db->sql_query($sql);
 
// 上記のデータに更新
$sql = 'UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $data);
$db->sql_query($sql);
 
// 上記のデータを挿入
$sql = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $data);
$db->sql_query($sql);

dbal::sql_build_query 参照

$sql_in = array(2, 58, 62);
 
$sql = 'SELECT *
    FROM ' . USERS_TABLE . '
    WHERE ' . $db->sql_in_set('user_id', $sql_in);

$sql = 'SELECT *
    FROM ' . POSTS_TABLE . '
    WHERE post_id = ' . (int) $integer . "
      AND post_text = '" . $db->sql_escape($data) . "'";

$sql = 'SELECT COUNT(post_id) AS num_posts
    FROM ' . POSTS_TABLE . "
    WHERE topic_id = $topic_id
        AND post_time >= $min_post_time
    " . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND post_approved = 1');
$result = $db->sql_query($sql);
 
$total_posts = (int) $db->sql_fetchfield('num_posts');

$sql = 'SELECT *
    FROM ' . TOPICS_TABLE . '
    WHERE topic_id = 1045';
$result = $db->sql_query($sql);
 
$topic_data = $db->sql_fetchrow($result);

$sql = 'SELECT config_name, config_value
    FROM ' . CONFIG_TABLE;
$result = $db->sql_query($sql);
 
while ($row = $db->sql_fetchrow($result))
{
    $config[$row['config_name']] = $row['config_value'];
}

$sql = 'SELECT *
    FROM ' . POSTS_TABLE . '
    WHERE post_id = ' . (int) $integer . "
        AND post_text = '" . $db->sql_escape($data) . "'";
$result = $db->sql_query($sql);
 
//
$post_data = $db->sql_fetchrow($result);
 
//
$db->sql_freeresult($result);

http://wiki.phpbb.com/Database_Abstraction_Layer