PHP pexecute Examples

Example #1

File: getmessages.php Project: kertkulp/php-ruhmatoo-projekt

function set_message_read($to_id, $from_id, $owner_id)
{
    $query = "UPDATE codopm_messages SET recd = 1\n                WHERE owner=:owner_id AND\n                 ( (msg_from = :fromA AND msg_to = :toA)\n                  OR (msg_from = :toB AND msg_to = :fromB) )";
    pexecute($query, array(":fromA" => $from_id, ":toA" => $to_id, ":fromB" => $from_id, ":toB" => $to_id, ":owner_id" => $owner_id));
}

Example #2

File: codopm.php Project: kertkulp/php-ruhmatoo-projekt

function save_my_details($id)
{
    if (!isset($_SESSION[codopm::$secret . "from_id"]) || isset($_SESSION[codopm::$secret . "from_id"]) && $_SESSION[codopm::$secret . "from_id"] != $id) {
        $query = "SELECT username,name FROM " . codopm::$db_prefix . "users WHERE id = :id";
        $obj = pexecute($query, array(":id" => $id));
        $res = $obj->fetch();
        $name = $res['name'];
        if (empty($name)) {
            $name = $res['username'];
        }
        $_SESSION[codopm::$secret . "from_name"] = $name;
    }
    return $_SESSION[codopm::$secret . "from_name"];
}