Using PHP to connect to MySQL: ERROR?

Question

I tried running the following code: (http://localhost/read.php)

<html>
<body>

<?php
$link = mysql_connect('localhost', 'root', 'password');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

if (mysql_query("CREATE DATABASE testphp",$link))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
?>

</body>
</html>

and got the following error:

Fatal error: Call to undefined function mysql_connect() in                                    
C:\Program Files (x86)\ApacheSoftware Foundation\Apache2.2\htdocs\read.php 
on line 5

tereško · Accepted Answer · 2011-04-29 21:47:02Z

0

Look at you phpinfo(). Most likely mysql extensions is not there.

And while you are at it, you could just drop the ancient mysql_* way ow doing thing and learn how to use PDO and prepared statements. It's an abstraction API for database connection and interaction.

answered Apr 29, 2011 at 21:47

tereško

58.5k26 gold badges100 silver badges151 bronze badges

Yes, I think I understand now. Investigating how to add the MySQL extension. Do not see anything in the phpinfo() that MySQL is active.
– Mr_CryptoPrime
Commented Apr 29, 2011 at 21:57

Add a comment |

thedanielhanke · Accepted Answer · 2011-04-29 21:42:22Z

0

your mysql-extension for php is not loaded! check that in your php.ini.

answered Apr 29, 2011 at 21:42

thedanielhanke

7381 gold badge6 silver badges22 bronze badges

ah, yes...I think I know what the problem is now!? Will let you know if I fix it. Thanks.
– Mr_CryptoPrime
Commented Apr 29, 2011 at 21:46

Add a comment |

Collectives™ on Stack Overflow

Using PHP to connect to MySQL: ERROR?

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related