Web lists-archives.com

Re: [PHP] Deprecated features in PHP 5.5.x




Hi there,

Torsten gave a good help. Now I'm having a trouble with php 7.1. The script works properly in php 5.6:

<?php

include("_restrito/conexao.php");

$conexao = mysqli_connect($host,$user,$pass,$db);

   if(!$conexao)

die("Nao foi possivel conectar no servidor MySQL. Erro: " . mysqli_error());

mysqli_select_db($conexao,$db) or die("Nao foi possivel usar o banco de dados. Erro: " . mysqli_error());

   $pagina = $_GET['pagina'];

   $banco = mysqli_select_db("mensagem");

$busca = "SELECT * FROM portfolio ORDER BY id DESC";

$total_reg = "5";
if (!$pagina) {
   $pc = "1";
} else {
   $pc = $pagina;
}

$inicio = $pc - 1;
$inicio = $inicio * $total_reg;

$limite = mysqli_query("$busca LIMIT $inicio,$total_reg");
$todos = mysqli_query("$busca");

$tr = mysqli_num_rows($todos);
$tp = $tr / $total_reg;

while ($dados = mysqli_fetch_array($limite)) {

?>

Could you help?

"Torsten Rosenberger" <rosenberger@xxxxxxxxx> escreveu na mensagem news:1449494131.8731.20.camel@linux-j8s5...
Hello

Am Montag, den 07.12.2015, 11:07 -0200 schrieb Release Edl:
Hi people,

How can I use the mysqli function to substitute of mysql ?

I need to change an old script that uses mysql.

The script::

<?php

include(conexao.php");
 $id = $_GET['id'];
 $conexao = mysql_connect('host', 'user', 'pass');

    if(!$conexao)

         die("Error: " . mysql_error());

    mysql_select_db($db) or die("Error: " . mysql_error());

$SQL = "SELECT * FROM portfolio WHERE id='$id' ORDER BY id DESC LIMIT 1";

$query = mysql_query($SQL);

while($x = mysql_fetch_array($query)) {

?>

http://de.php.net/manual/en/book.mysqli.php

take a look in the manual.

most functions are the same but with mysqli in front.

$link = mysqli_connect("127.0.0.1", "my_user", "my_password", "my_db");

mysqli_select_db ( $link , $db );
mysqli_query ( $link ,.....)

so you have to rewrite the mysql with mysqli and add the connection to
all other functions


BR/Torsten





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php