File: Readme

Recommend this page to a friend!
  Classes of Chetankumar Digambarrao Akarte  >  Simple MySQLi database access wrapper  >  Readme  >  Download  
File: Readme
Role: Documentation
Content type: text/plain
Description: Documentation - How to used this Class
Class: Simple MySQLi database access wrapper
Connect and query a MySQL database using MySQLi
Author: By
Last change:
Date: 2 months ago
Size: 2,201 bytes
 

Contents

Class file image Download
# Simple MySQLi database access wrapper
In this document you can find proper usage of this library.
By - Chetankumar Akarte
for help email me - chetan.akarte@gmail.com
get connect @ https://www.linkedin.com/in/chetanakarte

### About
This class is used to Connect and query a MySQL database using the MySQLi.extension.

### Requirements
- PHP: >=7.3.0

### Overview
This class library can read and parse a configuration file in the INI format and establishes a connection to a MySQL database server using connection parameters obtained from that configuration file.


### Usage
First you need to update config.ini with your database details and keep it in the same folder where your have db.php
```php
localhost = localhost 	//MySQL Host 
username = root			//MySQL User
password = ''			//MySQL Password
dbname = classic_news	//MySQL Database
```

Include db.php where you want to used MySQL data and initializa class.

```php
require_once('db.php');
$DB = new DB;
```

### Execute Query

```php
$query = "SELECT * tbl_category";
$DB->query($query);

```

### Process Query Result - 1st Row

```php
$query = "SELECT * tbl_category";
$get_cat = $DB->select($query);
	if(count($get_cat) > 0){
		$_cid= $get_cat[0]['cid'];
		$_catName = $get_cat[0]['category_name'];
		$_catStatus = $get_cat[0]['category_status'];
		$_imgDefault = $get_cat[0]['category_image'];
		$_catSequence = $get_cat[0]['category_sequence'];
		
	}
```

### Process Query Result - All Row

```php
$query = "SELECT * tbl_category";
$get_cat = $DB->select($query);
	if(count($get_cat) > 0){
	foreach ($category_check as $get_cat) {
		$_cid= $get_cat['cid'];
		$_catName = $get_cat['category_name'];
		$_catStatus = $get_cat['category_status'];
		$_imgDefault = $get_cat['category_image'];
		$_catSequence = $get_cat['category_sequence'];
		}
	}
```


### Fetch the last Insert Id from the database

```php
$query = "INSERT INTO tbl_news (featured, news_title, news_cat, news_description, news_cover_img,published_on) VALUES('".trim($_POST['isFeatured'])."','".trim($_POST['txtTitle'])."','".$_cid."','".$strDummy."','".$file_name."', now())";
	//echo $query;
	$DB->query($query);
	$_insetId=$DB->insert_id();
	//print_r($_insetId);
```

For more information send a message to info at phpclasses dot org.