PHPackages                             dinodev/my-sql - 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. dinodev/my-sql

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

dinodev/my-sql
==============

Classes you can modify your MySql database even if you don't know sql

v1.4.0(4y ago)024MITPHP

Since Oct 30Pushed 4y ago1 watchersCompare

[ Source](https://github.com/TheDevick/MySql)[ Packagist](https://packagist.org/packages/dinodev/my-sql)[ RSS](/packages/dinodev-my-sql/feed)WikiDiscussions master Synced 1w ago

READMEChangelog (7)Dependencies (1)Versions (9)Used By (0)

MySql
=====

[](#mysql)

Classes you can modify your MySql database even if you don't know SQL.

[View on Packagist](https://packagist.org/packages/dinodev/my-sql)

How to Use
----------

[](#how-to-use)

- Install PHP
- Install MySql.
- Run the Command `composer require dinodev/my-sql`

### Connecting With Database

[](#connecting-with-database)

```
use DinoDev\MySql\Classes\MySql;

//Creating MySql
$MySql = new MySql(
    "localhost" /* Hostname */,
    "root"      /* Username */,
    "MySql"     /* Password */,
    "world"     /* Database */,
    $state      /* State of MySql Connect (Success or Error) */
);
```

### Features

[](#features)

With MySql Library, you can run the following SQL commands:

- Create
- Drop
- Select
- Delete
- Insert

All theses Features are Classes, with namespace `DinoDev\MySql\Classes\`

#### Create

[](#create)

How to Use:

```
$Create = new Create(
    $MySql /* Here, you pass the MySql Object */
);

//Create Table
$Create->Table(
    "TableName"                    /* The Table Name*/,
    ["Value 1", "Value2"]          /* The Name Of Values */,
    ["varchar(20)", "varchar(50)"] /* The Type Of Values*/
);
```

#### Drop

[](#drop)

How to Use:

```
$Drop = new Drop(
    $MySql /* Here, you pass the MySql Object */
);

//Drop Table
$Drop->Table(
    "TableName" /* The Table Name */
);
```

#### Select

[](#select)

How to Use:

```
$Select = new Select(
    $MySql /* Here, you pass the MySql Object*/
);

//Select All
$Select->All(
    "TableName" /* The Table Name */,
    "Order By"   /* Order By (Optional) */,
    5           /* The Limit of Rows (Optional) */
);

//Select Where
$Select->Where(
    "TableName" /* The Table Name */,
    "Field",    /* The Field Name */
    "Value",    /* Value */
    "Order By"   /* Order By (Optional) */,
    5           /* The Limit of Rows (Optional) */
);

//Select Like
$Select->Like(
    "TableName" /* The Table Name */,
    "Field",    /* The Field Name */
    "Value",    /* Value */
    "Order By"   /* Order By (Optional) */,
    5           /* The Limit of Rows (Optional) */
);
```

#### Insert

[](#insert)

How to Use:

```
$Insert = new Insert(
    $MySql /* Here, you pass the MySql Object*/
);

//Insert
$Insert->Insert(
    "TableName"                  /* The Table Name */,
    [ "Field One", "Field Two" ] /* The Fields Name */ ,
    [ "Value One", "Value Two" ] /* Values */
);
```

#### Delete

[](#delete)

How to Use:

```
//Delete Where
$Delete->Where(
    "TableName" /* The Table Name */,
    "Field"     /* The Field Name */,
    "Value",    /* Value */
);

//Delete Like
$Delete->Like(
    "TableName" /* The Table Name */,
    "Field",    /* The Field Name */
    "Value",    /* Value */
);
```

Example
-------

[](#example)

```