Esempi in PHP per Oedipus_DramaHelper::get_next_act_name_for_drama_id

Esempio n. 1

File: Oedipus_DramaDBHelper.inc.php Progetto: saulhoward/oedipus-decision-maker

    public static function add_act(Oedipus_Drama $drama, $name = NULL)
    {
        if ($name == NULL) {
            $name = Oedipus_DramaHelper::get_next_act_name_for_drama_id($drama->get_id());
        }
        // Add Act to database
        $dbh = DB::m();
        $drama_id = mysql_real_escape_string($drama->get_id(), $dbh);
        $name = mysql_real_escape_string($name, $dbh);
        $sql = <<<SQL
INSERT INTO
\toedipus_acts
SET
\tname = '{$name}',
\tadded = NOW(),
\tdrama_id = '{$drama_id}'
SQL;
        //                                print_r($sql);exit;
        $result = mysql_query($sql, $dbh);
        $act_id = mysql_insert_id($dbh);
        $added = date();
        $act = new Oedipus_Act($act_id, $act_name, $added, $drama_id);
        //                print_r($act);exit;
        return $act;
    }