Example #1
0
<?php

final class Conn
{
    public static $host;
    public static $username;
    public static $password;
    public static $database;
    public static function get_connection()
    {
        static $conn;
        if ($conn === NULL) {
            $conn = mysqli_connect(self::$host, self::$username, self::$password) or die("Could not connect. " . mysqli_error());
            if (!mysqli_select_db($conn, self::$database)) {
                $baza = Conn::$database;
                mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS {$baza}") or die("Could not create database. " . mysqli_error());
                mysqli_select_db($conn, self::$database);
            }
        }
        return $conn;
    }
    private function __construct()
    {
    }
}
Conn::$host = "localhost";
Conn::$username = "******";
Conn::$password = "";
Conn::$database = "rotarydb";