Recommended by Users
... range of result set rows, execute INSERT and UPDATE queries, retrieve the last inserted record identifier or the next record sequence value, begin, commit and rollback transactions. Kakhaber Kashmadze package author package author I just added MicrosoftSQL support to my dbutils class if not jet updated ...
... with Git repositories. Currently it can: - Create a repository - Set the repository name and author - Check if repository files are staged - Commit changed files - Remove files from the repository - Clone repository from given URL - Check if a repository is empty - Check if a branch name exists - Push ...
PHP 5, Databases This package can access to database with PDO and run common queries. It can connect to a given database supported by PDO and executes several types of common operations to process SQL queries. Currently it can: - Run an unprepared queries - Run a prepared query with parameters - ...
Design Patterns, PHP 7 This package can be used to setup microservices apps using configuration arrays. It can read configuration PHP scripts that contain values that will be used to set up details of operation of an application based on microservices. Currently it allows to configure: - SQL query ...
HTTP, Libraries, Design Patterns, Per... This package can be used to implement microservices using Open Swoole. It provides a framework of classes that developers can use to implement Web applications based on service classes. The framework uses the Open Swoole PHP extension to implement single thread ...
... +00:00 Log position: 0 Event size: 116 Memory usage 2.4 MB === Event gtid === Date: 2017-07-06T15:23:44+00:00 Log position: 57803092 Event size: 48 Commit: true GTID NEXT: 3403c535-624f-11e7-9940-0800275713ee:13675 Memory usage 2.42 MB === Event query === Date: 2017-07-06T15:23:44+00:00 Log position ...
... ' => 11, 'active' => 1]); if ($result) { $user = $result->fetchArray(); print_r($user); } else { echo "user not found"; } Transactions Use begin(), commit(), and rollback() to manage transactions: $db->beginTransaction(); $db->query( 'UPDATE `users` SET `foo` = :foo WHERE id = :id', ['foo' => 100, 'id ...
... de uma forma mais prática. Methods - Drop - Create - Insert - Update - Delete - Select - ExecuteSQL (generic query) - Transaction (Begin, Rollback, Commit) CONNECTION $host = 'localhost'; $user = 'root'; $pass = ''; $base = 'test'; $con = new ConnectionMSi($host,$user,$pass,$base); DROP $con->Drop ...
Algorithms, Graphics, Tools, PHP 8 This package can generate QR code images in several formats. It can take a string of data to encode and output an image of the QR code or save to a file in one of several formats supported by the package. Currently, it can: - Output in formats like PNG, SVG, PDF ...
... the file on end // $app->jsdb = new JsonDB('secure.file', 'secret-key-to-be-used'); // it extends Horus_Container Object // so it is very easy, just commit after ending . // set a key $app->jsdb->set('k1', 'v1'); $app->jsdb->k2 = 'v2'; $app->jsdb->set(array( 'k3' => 'v3', 'k4' => 'v4' )); // set a key ...
... '], $item['itemSysModelId'], $item['itemId']); $action->addRef(Yii::$app->user); $action->addRefSys($invoiceSysModelId, $invoiceId); } $transaction->commit(); } catch (\Exception $e) { $transaction->rollBack(); FlashHelper::addDanger($e->getMessage()); Yii::error($e->getMessage() . PHP_EOL . $e->getTraceAsString ...
