crud-mvc-oop-pdo

KO | EN

gitlite — search

#javascript #hacktoberfest #ai #typescript #android #deep-learning #linux #docker #nodejs #java #awesome #vue #pytorch #mcp

crud-mvc-oop-pdo

(★ 25)

A simple and intuitive CRUD system using the MVC pattern in OOP paradigm. To connect to the database using PDO.

crud-mvc-oop-pdo Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# CRUD MVC OOP PDO

A simple and intuitive CRUD system using the MVC pattern in OOP paradigm. To connect to the database using PDO.

![crud mvc oop pdo](https://raw.githubusercontent.com/utoyvo/crud-mvc-oop-pdo/master/screenshot.png)

## STRUCTURE

## REQUIREMENTS

### System requirements

- Apache.
- PHP 7.2.0 or higher.

### PHP extensions

- PHP [Data Objects (PDO)](https://www.php.net/manual/en/book.pdo.php) module for accessing databases.
- PHP [mbstring](http://php.net/manual/en/book.mbstring.php) module for full UTF-8 support.
- PHP [gd](http://php.net/manual/en/book.image.php) or [ImageMagick](http://php.net/manual/en/book.imagick.php) module for image processing.
- PHP [JSON](https://php.net/manual/en/book.json.php) module for JSON manipulation.
- PHP [Fileinfo](https://www.php.net/manual/en/book.fileinfo.php).
- PHP [SPL](https://www.php.net/manual/en/book.spl.php).
- PHP [DOM](https://www.php.net/manual/ru/class.domdocument.php).

### Database

- [MySQL](https://www.mysql.com/) or [MariaDB](https://mariadb.com/).

## CONFIG

### Database

```php
$this->config['db'] = array(
	'driver'   => 'mysql',
	'host'     => 'localhost',
	'username' => 'root',
	'password' => '',
	'name'     => 'crud-mvc-oop-pdo'
);
```

### Session

```php
$this->config['session-name'] = 'SID';
```

## DATABASE

### Posts

| Field        | Type         | Null | Key | Default           | Extra                       |
|:-------------|:-------------|:-----|:----|:------------------|:----------------------------|
| post_id      | INT(11)      | NO   | PRI | NULL              | AUTO_INCREMENT              |
| post_created | DATETIME     | NO   |     | CURRENT_TIMESTAMP |                             |
| post_updated | DATETIME     | NO   |     | CURRENT_TIMESTAMP | ON UPDATE CURRENT_TIMESTAMP |
| post_title   | VARCHAR(255) | NO   |     | NULL              |                             |
| post_author  | INT(11)      | NO   |     | NULL              |                             |
| post_content | TEXT         | NO   |     | NULL              |                             |
| post_cover   | VARCHAR(255) | NO   |     | NULL              |                             |

### Users

| Field         | Type         | Null | Key | Default           | Extra                       |
|:--------------|:-------------|:-----|:----|:------------------|:----------------------------|
| user_id       | INT(11)      | NO   | PRI | NULL              | AUTO_INCREMENT              |
| user_created  | DATETIME     | NO   |     | CURRENT_TIMESTAMP |                             |
| user_updated  | DATETIME     | NO   |     | CURRENT_TIMESTAMP | ON UPDATE CURRENT_TIMESTAMP |
| user_name     | VARCHAR(255) | NO   |     | NULL              |                             |
| user_email    | VARCHAR(255) | NO   |     | NULL              |                             |
| user_password | VARCHAR(255) | NO   |     | NULL              |                             |
| user_role     | VARCHAR(20)  | NO   |     | NULL              |                             |

## CONTRIBUTOR

Oleksandr Klochko [@utoyvo](https://github.com/utoyvo)

## LICENSE

Code released under the [MIT License](LICENSE).

crud-mvc-oop-pdo

crud-mvc-oop-pdo Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

crud-mvc-oop-pdo

crud-mvc-oop-pdo Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README