renanhangai / libweb-db
Database classes
0.0.1
2017-12-04 16:02 UTC
Requires
Requires (Dev)
- phpunit/phpunit: ^6.0
This package is auto-updated.
Last update: 2025-03-10 21:16:56 UTC
README
Example
A simple example using the API
use LibWeb\Validator as v; use LibWeb\DB; class TestAPI { public function GET_multiply( $req ) { $data = $req->params(array( "a" => v::f(), "b" => v::f(), )); return $data->a * $data->b; } public function POST_create( $req ) { $data = $req->params(array( "name" => v::s(), "age" => v::i(), )); $id = DB::insertInto( "person", $data ); // "INSERT INTO person (name, age) VALUES (:name, :age)" return $id; } public function POST_update( $req ) { $data = $req->params(array( "id" => v::i(), "age" => v::i(), )); $query = "UPDATE person SET age=:age WHERE id=:id" $result = DB::execute( $query, $data ); } };