Issue with updating mysql to mysqli

Question

I’m trying to install a script from a site, but my knowledge in Php is fine, I installed the database and the files on FTP, but keeps appearing the following error:

Deprecated: mysql_connect(): The mysql Extension is deprecated and will be Removed in the Future: use mysqli or PDO Instead in /home/u242371073/public_html/includes/Bancodedados.php on line 6

Someone can guide me how to set up and solve this problem?

Below is a sample of the code of Bancodedados.php:

<?php

function db_conectar($servidor = DB_SERVIDOR, $usuario = DB_USUARIO, $senha = DB_SENHA, $banco = DB_BANCO) {
    global $db_link;

    $db_link = mysql_connect($servidor, $usuario, $senha);
    if ($db_link) mysql_select_db($banco);

    return $db_link;
  }



  function db_desconectar() {
    global $db_link;
    return mysql_close($db_link);
  }



  function db_erro($consulta, $erronum, $erro) { 
    die('<table cellpadding=30 cellspacing=0 style="border:1px solid #dddddd;"><tr><td><font color=red><b>Erro!</b></font><BR><BR><b># '.$erronum.'</b> - '.$erro.'<BR><BR>'.$consulta.'</td></tr></table>');
  }




  function db_consulta($consulta) {
    global $db_link;
    $result = mysql_query($consulta, $db_link) or db_erro($consulta, mysql_errno(), mysql_error());
    return $result;
  }


  function db_executa($tabela, $dados, $acao = 'insert', $parametros = '') {
    reset($dados);
    if (strtolower($acao) == 'insert') {
      $consulta = 'insert into ' . $tabela . ' (';
      while (list($coluna, ) = each($dados)) $consulta .= $coluna . ', ';
      $consulta = substr($consulta, 0, -2) . ') values (';

      reset($dados);
      while (list(, $valor) = each($dados)) {
        switch ((string)$valor) {
          case 'now()':
            $consulta .= 'now(), ';
            break;
          case 'null':
            $consulta .= 'null, ';
            break;
          default:
            $consulta .= '\'' . db_entrada($valor) . '\', ';
            break;
        }
      }
      $consulta = substr($consulta, 0, -2) . ')';

    } elseif (strtolower($acao) == 'update') {
      $consulta = 'update ' . $tabela . ' set ';

      reset($dados);
      while (list($coluna, $valor) = each($dados)) {
        switch ((string)$valor) {
          case 'now()':
            $consulta .= $coluna . ' = now(), ';
            break;
          case 'null':
            $consulta .= $coluna .= ' = null, ';
            break;
          default:
            $consulta .= $coluna . ' = \'' . db_entrada($valor) . '\', ';
            break;
        }
      }
      $consulta = substr($consulta, 0, -2) . ' where ' . $parametros;
    }
    return db_consulta($consulta);
  }



  function db_lista($db_consulta) {
    return mysql_fetch_array($db_consulta);
  }



  function db_linhas($db_consulta) {
    return mysql_num_rows($db_consulta);
  }



  function db_insert_id() {
    return mysql_insert_id();
  }



  function db_free_result($db_consulta) {
    return mysql_free_result($db_consulta);
  }



  function db_saida($string) {
    return htmlspecialchars($string);
  }



  function db_entrada($string) {
    return addslashes($string);
  }


  function db_dados($string) {
    return db_lista(db_consulta($string));
  }

?>

Answer 1

The problem is because you are using obsolete functions (mysql_connet, mysql_query...). Instead use mysqli functions such as: mysqli_query and mysqli_connect.

Check out more in the documentation: https://secure.php.net/manual/en/book.mysqli.php

Answer 2

In fact the "solution" (cover hole) was much simpler... I simply changed the version of Php to 5.3.

Of course it’s not ideal, but give me time to study more about PDO and Mysqli without leaving the site out of the field.