1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 

<?php

namespace CJPGDK\PhpHttpAuth\Database;

/**
 * Provides generic database methods
 *
 * @package CJPGDK
 * @subpackage PhpHttpAuth
 * @author Christian M. Jensen <cmj@cjpg.dk>
 * @version 1.0.0
 * @since 1.0.0
 */
abstract class DB
{
    protected $dbConnectionSettings = array(
        'host'        => null,
        'user'        => null,
        'passwd'      => null,
        'databsename' => null,
        'port'        => null,
        'socket'      => null,
    );

    /**
     * Name of the table that holds the users
     * @var string
     */
    public $usersTableName = "users";

    /**
     * An array that indicates the names of the columns
     * in the table that contains the users
     * @var array
     */
    public $tableColumns = array(
        'id'       => 'id_users',
        'username' => 'username',
        'password' => 'password'
    );

    /**
     * Delete a user from database
     * @param string $name
     * @return boolean
     */
    abstract function deleteUser($name);

    /**
     * Get users from database
     * @return object[]
     */
    abstract function getUsers();

    /**
     * Get user from database
     * @param string $name
     * @return object
     */
    abstract function getUser($name);

    /**
     * Save or update a user in the database
     * @param string $name
     * @param string $passwd
     * @return boolean
     */
    abstract function saveUser($name, $passwd);

    /**
     * Get database connection
     * @return \mysqli|\PDO
     */
    abstract function getDb();

    /**
     * Set the database connection socket
     * @param mixed $socket
     * @param mixed $default
     */
    protected function setConnectionSocket($socket, $default = null)
    {
        if (is_null($socket) && !is_null($default)) {
            $this->dbConnectionSettings['socket'] = $default;
        } else {
            $this->dbConnectionSettings['socket'] = $socket;
        }
    }

    /**
     * Get the database connection socket
     * @return mixed
     */
    protected function getConnectionSocket()
    {
        return $this->dbConnectionSettings['socket'];
    }

    /**
     * Set the database connection port
     * @param mixed $port
     * @param mixed $default
     */
    protected function setConnectionPort($port, $default = null)
    {
        if (is_null($port) && !is_null($default)) {
            $this->dbConnectionSettings['port'] = $default;
        } else {
            $this->dbConnectionSettings['port'] = $port;
        }
    }

    /**
     * Get the database connection port
     * @return mixed
     */
    protected function getConnectionPort()
    {
        return $this->dbConnectionSettings['port'];
    }

    /**
     * Set the databsename to use when connecting to the database
     * @param mixed $dbName
     * @param mixed $default
     */
    protected function setConnectionDatabseName($dbName, $default = null)
    {
        if (is_null($dbName) && !is_null($default)) {
            $this->dbConnectionSettings['databsename'] = $default;
        } else {
            $this->dbConnectionSettings['databsename'] = $dbName;
        }
    }

    /**
     * Get the databsename to use when connecting to the database
     * @return mixed
     */
    protected function getConnectionDatabseName()
    {
        return $this->dbConnectionSettings['databsename'];
    }

    /**
     * Set the password to use when connecting to the database
     * @param mixed $passwd
     * @param mixed $default
     */
    protected function setConnectionPassword($passwd, $default = null)
    {
        if (is_null($passwd) && !is_null($default)) {
            $this->dbConnectionSettings['passwd'] = $default;
        } else {
            $this->dbConnectionSettings['passwd'] = $passwd;
        }
    }

    /**
     * Get the password to use when connecting to the database
     * @return mixed
     */
    protected function getConnectionPassword()
    {
        return $this->dbConnectionSettings['passwd'];
    }

    /**
     * Set the username to use when connecting to the database
     * @param mixed $user
     * @param mixed $default
     */
    protected function setConnectionUser($user, $default = null)
    {
        if (is_null($user) && !is_null($default)) {
            $this->dbConnectionSettings['user'] = $default;
        } else {
            $this->dbConnectionSettings['user'] = $user;
        }
    }

    /**
     * Get the username to use when connecting to the database
     * @return mixed
     */
    protected function getConnectionUser()
    {
        return $this->dbConnectionSettings['user'];
    }

    /**
     * Set the host or path to the database
     * @param mixed $host
     * @param mixed $default
     */
    protected function setConnectionHost($host, $default = null)
    {
        if (is_null($host) && !is_null($default)) {
            $this->dbConnectionSettings['host'] = $default;
        } else {
            $this->dbConnectionSettings['host'] = $host;
        }
    }

    /**
     * Get the host or path to the database
     * @return mixed
     */
    protected function getConnectionHost()
    {
        return $this->dbConnectionSettings['host'];
    }
}