Re: Deprecated features in PHP 5.5.x
| From: | Torsten Rosenberger | Date: | Mon, 07 Dec 2015 13:15:31 +0000 |
| Subject: | Re: Deprecated features in PHP 5.5.x | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-325273@lists.php.net to get a copy of this message | ||
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