Deprecated: mysql_connect() mysqli now

Question

Hi please give me support in this:

deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in...

$this->conn = mysql_connect ( $this->host, $this->user, $this->pass ) or die ( 'ERR_DB_CONNECT' );

$result = mysql_query ( $query, $this->conn ) or die ( mysql_error () );

what is new version?

[Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) — Phil, Mar 31 '14 at 00:17
For new version of PHP deprecated the `mysql_*` functions. It throws a error like this. so use `mysqli_*` or `PDO` functions — Tamil Selvan C, Mar 31 '14 at 00:56

score -1 · Answer 1 · answered Mar 31 '14 at 00:16

-1

See http://us1.php.net/mysqli_connect and http://us1.php.net/manual/en/mysqli.query.php. You should be able to do something like...

$this->conn = mysqli_connect ( $this->host, $this->user, $this->pass ) or die ( 'ERR_DB_CONNECT' );

$result = mysqli_query ( $query, $this->conn ) or die ( mysqli_error () );

Be sure to read the docs for proper return vals, exceptions, and errors.

answered Mar 31 '14 at 00:16

chaseisabelle

162
2
18

change php 5.5 to 5.3, tnks – Felipe Urrego Mar 31 '14 at 01:20
@FelipeUrrego I didn't reference any PHP version. What is your comment referring to? – chaseisabelle May 24 '20 at 09:32

score -3 · Answer 2 · answered Jun 16 '19 at 11:46

-3

Try adding '@' before msqli_connect to both statements Try this

$this->conn = @mysqli_connect ( $this->host, $this->user, $this->pass ) or die ( 'ERR_DB_CONNECT' );

answered Jun 16 '19 at 11:46

Stevooh

15
5

2

Was it really necessary to necro a five year old thread with information which was already in here? :/ – maio290 Jun 16 '19 at 11:48

Deprecated: mysql_connect() mysqli now

2 Answers2