SQL not connecting via php

Question

I have activated iis7 on my Windows 7 PC.
I have installed php and MySQL too

I am running following php code via localhost to create a D'base namely 'my_files.'

<?php
error_reporting(E_ALL);
ini_set('display_errors', true);

$con=mysqli_connect("127.0.0.1", "root", "pass");
// Check connection
    if (mysqli_connect_errno())
  {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }

// Create database
$sql="CREATE DATABASE my_files";
if (mysqli_query($con,$sql))
{
 echo "Database my_db created successfully";
  }
else
  {
  echo "Error creating database: " . mysqli_error($con);
  }   ?>

This Error: "Fatal error: Call to undefined function mysqli_connect() in C:\inetpub\wwwroot\db.php on line 4".

(Other php codes are running fine.) What may be the problem and solution?

add on top: `error_reporting(E_ALL);` and `ini_set('display_errors', true);` — Daniel W., Jul 25 '13 at 12:16
This Error: "Fatal error: Call to undefined function mysqli_connect() in C:\inetpub\wwwroot\db.php on line 4". — BioDeveloper, Jul 25 '13 at 12:43
possible duplicate of [Call to undefined function mysql\_connect()](http://stackoverflow.com/questions/4817944/call-to-undefined-function-mysql-connect) — Álvaro González, Jul 25 '13 at 12:46

score 2 · Answer 1 · answered Jul 25 '13 at 12:49

2

Given your error (undefined function) the mysqli interface is either not enabled in the php.ini file or it can't be loaded for some ready.

Look in your php.ini file for this line:

extension=php_mysqli.dll

make sure it is not commented out. if it was, then un-comment it and restart the web server.

If it is turned on in the php ini then try to figure out why it can't load (check the logs and google, etc).

you can create a trival page:

<?php echo phpinfo(); ?>

and it will show you all of the enabled extensions. after you enable mysqli, open that page and search it for mysqli to find out if it loaded ok.

answered Jul 25 '13 at 12:49

Don Dickinson

6,140
3
37
30

extension=php_mysqli.dll , extension=php_mssqli.dll are activated now. Other php programs running fine. Warning still the same. – BioDeveloper Jul 26 '13 at 11:10
yes, but what does phpinfo say? does it tell you the extension is loaded? – Don Dickinson Jul 26 '13 at 14:02
1

one more thing .. if you just changed those, you MUST restart your web server. the extensions are loaded into memory when the web server starts. – Don Dickinson Jul 26 '13 at 19:08

Gautam3164 · Answer 2 · 2013-07-25T12:10:35.587

0

Try with localhost like

$con=mysqli_connect("localhost", "root", "pass");

Otherthan that ..try like to display any error messages while connecting the DB through mysqli

$con = mysqli_connect("myhost","root","pass","database") or die("Error " . mysqli_error($link));

And as @Rens Groenveld said you can go through with the server side configuration error messages from :

error_reporting(E_ALL);

edited Jul 25 '13 at 12:10

answered Jul 25 '13 at 11:55

Gautam3164

28,027
10
58
83

1

Also: Is your server configured to show errors? If you can't find how to do this you can add this at top of your script: error_reporting(E_ALL); It will show PHP errors :) – Rens Groenveld Jul 25 '13 at 12:00

score 0 · Answer 3 · answered Jul 25 '13 at 12:53

0

Run a phpinfo() to see if the php_mysqli extension module is loaded. If it is not, you should activate mysql extension. For example in php.ini: extension=php_mysqli.dll

answered Jul 25 '13 at 12:53

Vijay

129
10

SQL not connecting via php

3 Answers3