PHPackages                             ottimis/phplibs - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. ottimis/phplibs

ActiveLibrary

ottimis/phplibs
===============

Php Library

5.1.3(1mo ago)16.1k↓50%1PHPPHP ^8.4CI passing

Since Aug 1Pushed 1mo ago2 watchersCompare

[ Source](https://github.com/ottimis/phplibs)[ Packagist](https://packagist.org/packages/ottimis/phplibs)[ RSS](/packages/ottimis-phplibs/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (18)Versions (215)Used By (0)

ottimis/phplibs
===============

[](#ottimisphplibs)

A comprehensive PHP library of tools for developing modern and robust applications, designed to simplify the creation of RESTful APIs with a modular architecture.

Table of Contents
-----------------

[](#table-of-contents)

- [Installation](#installation)
- [Main Components](#main-components)
    - [Database](#database)
    - [Utils](#utils)
    - [Logger](#logger)
    - [UUID](#uuid)
    - [Notify](#notify)
    - [OGMail](#ogmail)
    - [OGSmarty](#ogsmarty)
    - [OGHttp](#oghttp)
    - [RouteController](#routecontroller)
    - [Validator](#validator)
- [Enumerations](#enumerations)
- [Middleware](#middleware)
- [Usage Examples](#usage-examples)
- [Contributing](#contributing)
- [License](#license)

Installation
------------

[](#installation)

```
composer require ottimis/phplibs
```

Main Components
---------------

[](#main-components)

### Database

[](#database)

The `dataBase` class provides a simplified interface for MySQL database operations.

#### Features:

[](#features)

- Singleton pattern for connection management
- Methods for queries and transactions
- Support for value escaping

#### Available Methods:

[](#available-methods)

```
getInstance(string $dbname = ""): self           // Get singleton instance
createNew(string $dbname = ""): self             // Create new instance
close(): bool                                   // Close the connection
error(): string                                 // Get last error message
startTransaction(): void                        // Start a transaction
commitTransaction(): void                       // Commit current transaction
rollbackTransaction(): void                     // Rollback current transaction
query(string $sql): mysqli_result|bool         // Execute SQL query
multi_query(string $sql): mysqli_result|bool   // Execute multiple SQL queries
affectedRows(): int|string                      // Get number of affected rows
numrows(): int|string                           // Get number of rows in result
fetchobject(): object|false|null                // Fetch result as object
fetcharray(): false|array|null                  // Fetch result as array
fetchassoc(): array|false|null                  // Fetch result as associative array
freeresult(): void                              // Free result memory
real_escape_string($param): string              // Escape string for SQL
insert_id(): int|string                         // Get last insert ID
```

#### Usage Example:

[](#usage-example)

```