PHP : Undefined function mysql_connect() [duplicate]

Question

I just downloaded the new xampp and try to run my old projects and I got this error

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in F:\xampp\htdocs\try\index.php:17 Stack trace: #0 {main} thrown in F:\xampp\htdocs\try\index.php on line 17

Does it mean that the mysql_connect that I used is not already supported in new xampp ?

The MySQL extension has been deprecated for some years now, and was removed in PHP7.... you really should be using MySQLi or PDO — Mark Baker
– Mark Baker, Commented Jan 1, 2016 at 15:03
It has been removed in PHP 7, you should use PDO or Mysqli to interact with mysql databases. Mysql_* functions have been deprecated for quite some time. — JimL
– JimL, Commented Jan 1, 2016 at 15:03
@RajdeepPaul That doesn't seem to be the right duplicate, it doesn't say anything about PHP 7. — Barmar
– Barmar, Commented Jan 1, 2016 at 15:12

Evochrome · Accepted Answer · 2016-01-01 15:10:52Z

12

mysql_connect()

has been removed from PHP7, which is used by the newest xampp version.

Instead, use mysqli_connect() like in this example.

Another method, PDO is also possible (but is coded in a very different way as mysql_connect.)

answered Jan 1, 2016 at 15:10

Evochrome

1,2151 gold badge8 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jay Blanchard Over a year ago

Using PDO is really pretty easy..

Evochrome Over a year ago

I didn't say it is difficult ;) I only said it was different from mysqli_connect in terms of coding :p

Barmar · Accepted Answer · 2016-01-01 15:10:13Z

1

The MySQL module is depreciated in PHP5 and removed in PHP7, you can use these:

MySQLi http://php.net/manual/en/book.mysqli.php
PHP::PDO http://php.net/manual/en/book.pdo.php

Check your version by using phpinfo().

edited Jan 1, 2016 at 15:10

Barmar

789k57 gold badges554 silver badges669 bronze badges

answered Jan 1, 2016 at 15:08

devpro

16.1k3 gold badges29 silver badges39 bronze badges

4 Comments

JimL Over a year ago

While correct the problem here is that mysql_* has been removed from PHP 7, not that it's deprecated from PHP 5

devpro Over a year ago

there are so many question available like that on SO...

devpro Over a year ago

@Barmar: you are genius in modification.... thumbs up

JimL Over a year ago

I know, quite depressing to see how many still haven't jumped on PDO/mysqli. They were introduced when, more than 10 years ago? At least the next couple of years will clean up some of the old mess - with PHP 7 being rolled out

Atilla Arda Açıkgöz · Accepted Answer · 2016-01-01 15:03:59Z

0

Not particularly by xamppp but php itself deprecated mysql Here a quote from them:

The original MySQL extension is now deprecated, and will generate E_DEPRECATED errors when connecting to a database. Instead, use the MySQLi or PDO_MySQL extensions

if you can provide us php version i can help more

answered Jan 1, 2016 at 15:03

Atilla Arda Açıkgöz

8303 gold badges15 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP : Undefined function mysql_connect() [duplicate]

3 Answers 3

2 Comments

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Linked

Related