Example #1
0
    static function update($tab, $old)
    {
        $sql = "UPDATE " . static::$table . " SET";
        foreach ($tab as $cle => $valeur) {
            $sql .= " " . $cle . "=:new" . $cle . ",";
        }
        $sql = rtrim($sql, ",");
        $sql .= " WHERE " . static::$primary . "=:oldid;";
        //print_r( $sql );
        try {
            $req_prep = Model::$pdo->prepare($sql);
            $values = array();
            foreach ($tab as $cle => $valeur) {
                $values[":new" . $cle] = $valeur;
            }
            $values[":oldid"] = $old;
            $req_prep->execute($values);
            //$obj = Model::select($tab[0]);
            // return $obj;
        } catch (PDOException $e) {
            if (Conf::getDebug()) {
                echo "PROBLEME";
                // affiche un message d'erreur
            }
            return -1;
            die;
        }
    }
}
Model::Init();