This mysql_connect Attribute seems to old how can I replace them?

Question

I cannot connect to my Data Base using this way:

mysql_connect("localhost","root","") or die("1");
mysql_select_db("database") or die("2");

After the connection to the data base I would like to create a while loop with the elements of the data base, this is my code:

$carlistreq = mysql_query("SELECT * FROM cars WHERE brand="'.$_GET['marq'].'"") or die("3");
$count = mysql_num_rows($carlistreq);

if($count==0)
{
   echo "No elements";
}
else
{
    while($row= mysql_fetch_array($query))
    {
        //my code
    }
}

The issue comes from my SQL attributes like:

mysql_connect
mysql_fetch_array
mysql_select_db

For example.

Here is the error:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:[....] on line 2

[Your question was already been answered.](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) Please, read the question and answer of this link carefully. You'll gonna find every answer you're looking for. — al'ein, Oct 20 '15 at 10:08
Here is the [`PDO`](http://php.net/manual/en/book.pdo.php) class manual, and here's the [`mysqli_`](http://php.net/manual/en/book.mysqli.php) one. Both replace your needs. They are quite simple to use, and `mysqli_` states for "MySQL Improved", which is why you're gonna find much similarity between them. If you find any trouble implementing it, please open a question concerning your issue so we can help you properly. :) — al'ein, Oct 20 '15 at 10:13
Possible duplicate of [Why shouldn't I use mysql\_\* functions in PHP?](https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) — Cœur, Mar 17 '18 at 16:05

score 0 · Answer 1 · answered Oct 20 '15 at 10:09

0

Use PDO

$db = new PDO('mysql:host=localhost;dbname=databaseName', 'User' , 'password');
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

answered Oct 20 '15 at 10:09

Shridhar Patil

362
1
17

score 0 · Accepted Answer · edited Mar 17 '18 at 16:04

0

use the mysqli-extension like this:

$mysqli = new mysqli("localhost","user","password","database") or die("1");
$sql = "SELECT * FROM cars WHERE brand='".$_GET['marq']."'";
$result = $mysqli->query($sql);
if($result){
    while($row = $result->fetch_assoc()){
        //do something with your $row here
    }
}

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

edited Mar 17 '18 at 16:04

Cœur

37,241
25
195
267

answered Oct 20 '15 at 10:10

Tanuel Mategi

1,253
6
13

score 0 · Answer 3 · answered Oct 20 '15 at 10:10

Yes now servers are going to handel mysqli and PDO. Try implementing this code:

<?php
$con = mysqli_connect("localhost","root","");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?> 

// Change database to "test"
mysqli_select_db($con,"test");

// ...some PHP code for database "test"...

mysqli_close($con);
?>

You can user http://php.net/manual/en/book.mysqli.php as reference to understand better how mysqli works.

This mysql_connect Attribute seems to old how can I replace them?

3 Answers3