we

<?php

require_once 'config.php';

// signgletone pattern
class Connection {

    private static $con = null;
    private static $mysqlobj = null;

    private function __construct() {
        self::$mysqlobj = new mysqli(Config::server, config::user, config::pass, config::database, config::port);
    }

    public static function sql() {
        if (self::$con == null) {
            self::$con = new Connection();
        }
        return self::$con;
    }

    public function getConnection() {
        $conclass = self::sql();
        $con = $conclass::$mysqlobj;
        return $con;
    }

    function getResult($sql) {
        $conclass = self::sql();
        $con = $conclass::$mysqlobj;
        $result = $con->query($sql);
        return $result;
    }

    function setResult($sql) {
        $conclass = self::sql();
        $con = $conclass::$mysqlobj;
        $result = $con->query($sql);
        $insertid=$con->insert_id;
        return array("result"=>$result, "insertid"=>$insertid);
    }

}