[MySQL][PHP][PHP/SQL] Use mysqli or PDO Opcje

[123KOMORNIK321]

Cześć, z góry muszę wam powiedzieć że jeszcze nie potrafię pisać w php
Mam taki kod od znaj i spytał się czy mogę mu go przepisać aby nie wyświetlał się błąd

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO

To jest kod

[PHP] pobierz, plaintext 
$root = (empty($_SERVER['DOCUMENT_ROOT']) ? getenv("DOCUMENT_ROOT") : $_SERVER['DOCUMENT_ROOT']);
require_once $root.'/config.inc.php';
class Database {
 
    var $server = "localhost"; //database server
    var $user = "root"; //database login name
    var $pass = ""; //database login password
    var $database = ""; //database name
    var $pre = ""; //table prefix
    var $showerror = false;
#######################
//internal info
    var $error = "";
    var $errno = 0;
//number of rows affected by SQL query
    var $affected_rows = 0;
    var $link_id = 0;
    var $query_id = 0;
 
#-#############################################
# desc: constructor
 
    function Database($database) {
        $root = (empty($_SERVER['DOCUMENT_ROOT']) ? getenv("DOCUMENT_ROOT") : $_SERVER['DOCUMENT_ROOT']);
        require_once $root.'/config.inc.php';
        if (isset($database) && ($database == "FORUMS")) {
            $this->server = DB_FORUMS_SERVER;
            $this->user = DB_FORUMS_USER;
            $this->pass = DB_FORUMS_PASS;
            $this->database = DB_FORUMS_DATABASE;
            $this->pre = DB_FORUMS_PREFIX;
        } elseif (isset($database) && $database == "LOGS") {
            $this->server = DB_LOGS_SERVER;
            $this->user = DB_LOGS_USER;
            $this->pass = DB_LOGS_PASS;
            $this->database = DB_LOGS_DATABASE;
            $this->pre = DB_LOGS_PREFIX;
        } elseif (isset($database) && $database == "MTA") {
            $this->server = DB_SERVER;
            $this->user = DB_USER;
            $this->pass = DB_PASS;
            $this->database = DB_DATABASE;
            $this->pre = DB_PREFIX;
        }
        $this->showerror = DB_SHOW_ERROR;
    }
 
#-#constructor()
#-#############################################
# desc: connect and select database using vars above
# Param: $new_link can force connect() to open a new link, even if mysql_connect() was called before with the same parameters
 
    function affected_rows() {
        return $this->affected_rows;
    }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 function connect($new_link = false) {
        // var_dump($this->server);die;
        $this->link_id = mysql_connect($this->server, $this->user, $this->pass, $new_link);
 
        if (!$this->link_id) {//open failed
            $this->oops("Could not connect to server: <b>$this->server</b>.");
        }
 
        if (!@mysql_select_db($this->database, $this->link_id)) {//no database
            $this->oops("Could not open database: <b>$this->database</b>.");
        }
 
        // Deprecated but will get us rolling with mysql 5.7 for now.
 
        $this->query("SET SESSION sql_mode = ''");
 
        // unset the data so it can't be dumped
        $this->server = 'localhost - host name';
        $this->user = 'root - user name';
        $this->pass = 'pass';
        $this->database = 'db - name';
    }
[PHP] pobierz, plaintext 

Czytałem trochę o mysqli i PDO ale nie jestem w stanie mu tego zrobić i mam prośbę do was
Czy ktoś z was może mi to przepisać ?

PS: Jeśli chodzi o przepisywanie takiego kodu na przyszłość stosować PDO czy mysqli

Ten post edytował 123KOMORNIK321 1.03.2021, 18:43:42

[viking]

Dział zleceń jest niżej.

[vokiel]

PDO to wrapper na wiele różnych baz, mysqli to tylko do MySQL/MariaDB.

[LowiczakPL]

http://www.w3big.com/pl/php/php-mysql-connect.html