# php-mysqli-helper

**Repository Path**: marjune/php-mysqli-helper

## Basic Information

- **Project Name**: php-mysqli-helper
- **Description**: A set of wrapper classes using mysqli to operate mysql/mariadb single table much easier
- **Primary Language**: PHP
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2015-02-07
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Quick Start
## Configure
edit following constants in database.php or include them from another file:
```php
define('DB_HOST', 'db_host');
define('DB_PORT', '');
define('DB_USERNAME', 'db_user');
define('DB_PASSWORD', 'db_pass');
define('DB_NAME', 'db_name');
define('DB_CHARSET', 'utf8');
```

## Insert
```php
$helper = new DataInsertHelper('table_name');
$helper->addInteger('field_1', 1);
$helper->addString('field_2', 'string value');
$result = $helper->execute();
// this operation is same as executing SQL:
// INSERT INTO table_name(field_1,field_2) VALUES(1,'string value');
```

## Delete
```php
$helper = new DataDeleteHelper('table_name');
$helper->addConditionEqualString('username', 'foo');
$result = $helper->execute();
// this operation is same as executing SQL:
// DELETE FROM table_name WHERE username='foo';
```

## Update
```php
$helper = new DataUpdateHelper('table_name');
$helper->addConditionEqual('user_id', 15);
$helper->setString('username', 'bar');
$result = $helper->execute();
// this operation is same as executing SQL:
// UPDATE table_name SET username='bar' WHERE user_id=15;
```

## Query
```php
$helper = new DataQueryHelper('table_name');
$helper->addConditionInKeywords('user_id',4);
$helper->addOrderDesc('user_id');
$result = $helper->query();
// the $result is an associated array which it's key is database field name and value is the queried value from database.
// this operation is same as executing SQL:
// SELECT * FROM table_name WHERE user_id=4 ORDER BY user_id DESC
```