PHPackages                             devnull-ir/db-php - 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. [Database & ORM](/categories/database)
4. /
5. devnull-ir/db-php

AbandonedArchivedLibrary[Database & ORM](/categories/database)

devnull-ir/db-php
=================

description

v5.0(2y ago)321MITPHPPHP >=8.0

Since Jun 3Pushed 2y ago1 watchersCompare

[ Source](https://github.com/DevNull-IR/DB-php)[ Packagist](https://packagist.org/packages/devnull-ir/db-php)[ RSS](/packages/devnull-ir-db-php/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (1)DependenciesVersions (2)Used By (0)

DB-php
======

[](#db-php)

Free Functions To Connect To The Database ( Mysql ) For Php Programmers

**This Version : 5.0**

connect to database
===================

[](#connect-to-database)

`connect(string $dbname,string $username_db,string $password_db,string $host = 'localhost');`

This Function :

```
$cn = connect('dbName','myuser','passworduser');
```

**class**

```
$db = new db(string $dbname,string $username_db,string $password_db,string $host = 'localhost');
```

- Php :

```
        $Option = [
        PDO::ATTR_PERSISTENT => TRUE,
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::MYSQL_ATTR_INIT_COMMAND =>'SET NAMES utf8',
        PDO::ATTR_EMULATE_PREPARES => false
    ];
        $pdo = new PDO("mysql:host=localhost;dbname=dmn_nm;charset=utf8", "myAdmin" , 'abcdefgh1234' , $Option );
```

SQL Select Examples
===================

[](#sql-select-examples)

- SQL

```
select *
from db
where id = 10
limit 3
```

- PHP :

```
$select = select($cn, '*','db',['id'=>10],'limit 3');
```

**OR**

```
select *
from db
where id = 10 coin >= 15
```

- PHP :

```
select($cn, '*','db',['id'=>10,['coin','>=',15]]);
```

- execute :

[![](https://raw.githubusercontent.com/DevNull-IR/DB-php/main/src-document/Capture.PNG)](https://raw.githubusercontent.com/DevNull-IR/DB-php/main/src-document/Capture.PNG)

```
array (size=2)
  'count' => int 3
  'fetchAll' =>
    array (size=3)
      0 =>
        array (size=7)
          'id' => int 17
          'step' => string 'support' (length=7)
          'chat_id' => int 1212
          'Cash' => null
          'vip' => int 0
          'grade' => int 0
          'Download' => int 0
      1 =>
        array (size=7)
          'id' => int 18
          'step' => string 'NewUser' (length=7)
          'chat_id' => int 1016239559
          'Cash' => null
          'vip' => int 0
          'grade' => int 0
          'Download' => int 0
      2 =>
        array (size=7)
          'id' => int 19
          'step' => string 'NewUser' (length=7)
          'chat_id' => int -663757927
          'Cash' => null
          'vip' => int 0
          'grade' => int 0
          'Download' => int 0

```

- SQL

```
select * from db
```

- PHP

```
select($cn, '*','db');
```

SQL LIKE Examples
=================

[](#sql-like-examples)

- SQL

```
SELECT *
FROM Customers
WHERE CustomerName LIKE 'a%';
```

- PHP

This Update : 2.0

```
like($cn, '*','Customers',[
    'CustomerName'=>'a%'
]);
```

OR

- SQL:

```
select * from db where column LIKE 'a%' and id "a%"
    ],
    [
        [
            'id','