Web lists-archives.com

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




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