Descarga PDO - Descarga del código fuente PDO

PDO

Otras categorias

v2.2.1

Descargar

PDO

Sólo otra biblioteca de bases de datos PDO

Instalación

Usar compositor

$ composer require faapz/ PDO

Uso

Ejemplos de selección, inserción, actualización y eliminación de datos de o en la tabla users .

PDODatabase($dsn, $usr, $pwd); // SELECT * FROM users WHERE id = ? $select = $database->select() ->from('users') ->where(new FaaPz PDO ClauseConditional('id', '=', 1234)); if ($insert->execute()) { $data = $stmt->fetch(); } // INSERT INTO users (id , username , password) VALUES (? , ? , ?) $insert = $database->insert( 'id', 'username', 'password' ) ->into('users') ->values( 1234, 'user', 'passwd' ); if ($insert->execute()) { $insertId = $database->lastInsertId(); } // UPDATE users SET pwd = ? WHERE id = ? $update = $database->update(["pwd" => "your_new_password"]) ->table("users") ->where(new FaaPz PDO ClauseConditional("id", "=", 1234)); if (($result = $insert->execute()) !== false) { $affectedRows = $result->rowCount(); } // DELETE FROM users WHERE id = ? $delete = $database->delete() ->from("users") ->where(new FaaPz PDO ClauseConditional("id", "=", 1234)); if (($result = $delete->execute()) !== false) { $affectedRows = $result->rowCount(); }">

 require_once ' vendor/autoload.php ' ;

$ dsn = ' mysql:host=your_db_host;dbname=your_db_name;charset=utf8 ' ;
$ usr = ' your_db_username ' ;
$ pwd = ' your_db_password ' ;

$ database = new FaaPz  PDO  Database ( $ dsn , $ usr , $ pwd );

// SELECT * FROM users WHERE id = ?
$ select = $ database -> select ()
                   -> from ( ' users ' )
                   -> where ( new FaaPz  PDO  Clause  Conditional ( ' id ' , ' = ' , 1234 ));

if ( $ insert -> execute ()) {
    $ data = $ stmt -> fetch ();
}

// INSERT INTO users (id , username , password) VALUES (? , ? , ?)
$ insert = $ database -> insert (
                       ' id ' ,
                       ' username ' ,
                       ' password '
                   )
                   -> into ( ' users ' )
                   -> values (
                       1234 ,
                       ' user ' ,
                       ' passwd '
                   );

if ( $ insert -> execute ()) {
    $ insertId = $ database -> lastInsertId ();
}

// UPDATE users SET pwd = ? WHERE id = ?
$ update = $ database -> update ([ " pwd " => " your_new_password " ])
                   -> table ( " users " )
                   -> where ( new FaaPz  PDO  Clause  Conditional ( " id " , " = " , 1234 ));

if (( $ result = $ insert -> execute ()) !== false ) {
    $ affectedRows = $ result -> rowCount ();
}

// DELETE FROM users WHERE id = ?
$ delete = $ database -> delete ()
                   -> from ( " users " )
                   -> where ( new FaaPz  PDO  Clause  Conditional ( " id " , " = " , 1234 ));

if (( $ result = $ delete -> execute ()) !== false ) {
    $ affectedRows = $ result -> rowCount ();
}

La extensión sqlsrv no podrá conectarse cuando se utilice el modo de error PDO ::ERRMODE_EXCEPTION (predeterminado). Para conectarse, necesitará pasar explícitamente array( PDO ::ATTR_ERRMODE => PDO ::ERRMODE_WARNING) (o PDO ::ERRMODE_SILENT ) al constructor, o anular el método getDefaultOptions() cuando use sqlsrv .