How to fix call to undefined function mysqli_connect()

Question

I am trying to deploy a php based application online and getting following error:

Call to undefined function mysqli_connect() in home/spurdes/public_html/testsites/crimebusters/Repository/SQL_Connection.php on line 27.

Here is line 27:

$this->connection=  mysqli_connect($this->connectionHost,$this->userName,$this->password,$this->dbName);

Here is my phpinfo

I dont have access to php.init

possible duplicate http://stackoverflow.com/questions/8551398/call-to-undefined-function-mysql-connect — Praveen kalal, May 06 '13 at 05:54

score 2 · Answer 1 · edited Jan 07 '14 at 15:17

I was required to move a website from a commercial web host to a virtual server. I am using php and mysql in IIS on Windows Server 2008. I solved the mysqli_connect problem by doing the following.

I uncommented extension=php_mysql.dll, extension=php_mysqli.dll, and extension=php_pdo_mysql.dll in the php.ini file.

In my php file I had a class with a _construct function that included the mysqli_connect function. This works well in Apache and on the Unix server but not in IIS and Windows Server 2008. Here is the code:

<?php

class MyClass
{
    var $tablename="t_table";       
    var $connection;
    public function __construct() { 
        $this->connection = new MySQLi("host", "user", "password", "dbname", "port")or  die("Error connecting " . mysqli_error($connection));
    }
//functions that use $this->connection and $tablename are here.......
}
?>

Note: No other way of assigning a value to $connection worked for me. This is the result of at least 12 hours of internet searching and trial and error coding. I am a novice coder. It may not be pretty but it works. I hope this helps.

score 1 · Accepted Answer · answered May 06 '13 at 05:55

1

You need a mysqli php extension. Contact to hoster or change hosting service.

answered May 06 '13 at 05:55

zoonman

1,066
1
12
29

score 0 · Answer 3 · edited May 06 '13 at 06:15

0

You need to add this code in your PHP script

 dl("mysqli.so");

edited May 06 '13 at 06:15

Lance Roberts

21,757
30
108
129

answered May 06 '13 at 05:58

Praveen kalal

2,088
4
19
33

score -1 · Answer 4 · edited Jul 06 '15 at 18:32

-1

It is a php vesrion problem

you replace mysqli_connect() to mysql_connect()
or

contact to server guys to upgrade your version

edited Jul 06 '15 at 18:32

MZaragoza

9,803
9
62
105

answered Jul 06 '15 at 11:45

Sumit Thakur

1
2

How to fix call to undefined function mysqli_connect()

4 Answers4