Mysql - Database connect - xxamp - using PHP

Question

Im trying to connect a PHP-Script with an Database. But im Always getting the same Error.

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\Datenbank\login.php:12 Stack trace: #0 {main} thrown in C:\xampp\htdocs\Datenbank\login.php on line 12

This Error happens cuz of line 12.

$connect = mysql_connect("localhost","root","");

But what I made wrong?

Thank you for your help.

use PDO or mysqli. mysql is expired and it's not supported in php's newer versions. — Salim Ibrohimi, May 18 '18 at 10:50

Ricard Espinàs Llovet · Answer 1 · 2018-05-18T12:42:29.660

0

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

Possibly is this the error. Check the PHP version you are using.

This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

mysqli_connect()
PDO::__construct()

http://php.net/manual/en/function.mysql-connect.php

edited May 18 '18 at 12:42

answered May 18 '18 at 10:41

Ricard Espinàs Llovet

665
1
5
24

Im using PHP Version 7.1.7 – Venjox May 18 '18 at 11:00
You can't use this function... You will need to change to mysqli o pdo... or otherwise but less recommended... change to a previous php version. – Ricard Espinàs Llovet May 18 '18 at 12:44

score 0 · Answer 2 · answered May 18 '18 at 10:41

0

This is related to the Php.ini configuration

open the c:\xampp\php\php.ini in a text editor, that locate the line ;extension=php_mysql.dll

Remove the ; at the start, then save the php.ini and restart the xampp server (Apache and MySQL)

answered May 18 '18 at 10:41

rtang92340801

1

Can't find the ;extension=php_mysql.dll , should i add it? – Venjox May 18 '18 at 10:54
added it but doesnt changed anything :( – Venjox May 18 '18 at 11:09

score 0 · Answer 3 · answered May 18 '18 at 10:43

First of all check your PHP version as in PHP 7 mysql_* functions have been removed.

You can use mysqli_connect instead :

    <?php
        try{
        $host="localhost";
        $user="user";
        $password="pass";
        $databaseName = "myDB";
        $connect=mysqli_connect($host,$user,$password, $databaseName);
        if (mysqli_connect_errno())
          {
          echo "Failed to connect to MySQL: " . mysqli_connect_error();
          }
        echo "connected succesfully";
        }catch(Exception $e){
        echo $e->getMessage();
        }
    ?>

Tryd it with your code but im getting now a permissions error, Warning: mysqli_connect(): (HY000/1045): Access denied for user 'Admin'@'localhost' (using password: YES) in C:\xampp\htdocs\Datenbank\login.php on line 46 Failed to connect to MySQL: Access denied for user 'Admin'@'localhost' (using password: YES)connected succesfully — Venjox, May 20 '18 at 09:08

score 0 · Answer 4 · answered May 18 '18 at 11:01

0

please try below to see if the PHP MySQL extension module is being loaded::

<?php
    phpinfo();
 ?>
 If it's not there, add the following to the php.ini file:

 extension=php_mysql.dll

answered May 18 '18 at 11:01

Therichpost

1,711
2
14
18

Im added the extension but it doesnt solved the problem. – Venjox May 18 '18 at 11:04
@Venjox then try with MySQL or pdo – Therichpost May 18 '18 at 11:07

Mysql - Database connect - xxamp - using PHP

4 Answers4