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.
– Daniel W., Commented Jul 25, 2013 at 12:16
This Error: "Fatal error: Call to undefined function mysqli_connect() in C:\inetpub\wwwroot\db.php on line 4". — BioDeveloper
– BioDeveloper, Commented Jul 25, 2013 at 12:43
possible duplicate of Call to undefined function mysql_connect() — Álvaro González
– Álvaro González, Commented Jul 25, 2013 at 12:46

Don Dickinson · Accepted Answer · 2013-07-25 12:49:35Z

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, 2013 at 12:49

Don Dickinson

6,2683 gold badges37 silver badges30 bronze badges

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

3 Comments

BioDeveloper Over a year ago

extension=php_mysqli.dll , extension=php_mssqli.dll are activated now. Other php programs running fine. Warning still the same.

Don Dickinson Over a year ago

yes, but what does phpinfo say? does it tell you the extension is loaded?

Don Dickinson Over a year ago

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.

GautamD31 · Accepted Answer · 2013-07-25 12:10:35Z

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, 2013 at 12:10

answered Jul 25, 2013 at 11:55

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

1 Comment

Rens Groenveld Over a year ago

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 :)

Vijay · Accepted Answer · 2013-07-25 12:53:59Z

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, 2013 at 12:53

Vijay

1291 silver badge11 bronze badges

Collectives™ on Stack Overflow

SQL not connecting via php

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related