php mysqli create class
<?php
/**
* Simple Database class for PHP7+
* The class contains main functions for your database. For a detailed documentation, see: https://webdeasy.com/
* created 08.11.2017
*
* @author LH
*/
class Database {
private $host, $database, $username, $password, $connection;
private $port = 3306;
/** *
Sets the connection credentials to connection to your database
@param string $host - the host of your database
@param string $username - the username of your database
@param string $password - the password of your database
@param string $database - your database name
@param integer $port - the port of your database
@param boolean $autoconnect - to auto connect to the database after settings connection credentials
/function __construct($host, $username, $password, $database, $port = 3306, $autoconnect = true) { $this->host = $host; $this->database = $database; $this->username = $username; $this->password = $password; $this->port = $port; if($autoconnect) { $this->open(); }}/**
Open the connection to your database
/function open() { $this->connection = new mysqli($this->host, $this->username, $this->password, $this->database, $this->port);}/**
Close the connection to your database
/function close() { $this->connection->close();}/**
Execute your query
@param string $query - your sql query
@return the result of the executed query
/function query($query) { return $this->connection->query($query);}/**
Escape your parameter
@param string $string - your parameter to escape
@return the escaped string
/function escape($string) { return $this->connection->escape_string($query);}}?>