Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class DBBase {
- private $server = "localhost";
- private $database = "fivezone3";
- private $username = "fivezone";
- private $password = "JuT5ehUn";
- private $sql;
- private $result;
- function __construct() {
- $sql = new $mysqli($this->$server, $this->$username, $this->$password, $this->$database);
- if (mysqli_connect_errno()) {
- printf("Connect failed: %s\n", mysqli_connect_error());
- exit();
- }
- }
- function __destruct() {
- $sql->close();
- }
- function query($query) {
- $result = $sql->query($query);
- return $result;
- }
- function select($what, $from, $where, $sort, $limit) {
- $what = mysql_real_escape_string($what);
- $from = mysql_real_escape_string($from);
- $where = mysql_real_escape_string($where);
- $sort = mysql_real_escape_string($sort);
- $limit = mysql_real_escape_string($limit);
- $tmp = "SELECT " . $what . " FROM " . $from;
- if($where != "") {
- $tmp .= " WHERE " . $where;
- }
- if($sort != "") {
- $tmp .= " ORDER BY " . $sort;
- }
- if($limit != "" {
- $tmp .= " LIMIT " . $limit;
- }
- return $sql->query($tmp);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement