Cannot connect to mySQL ???

plomon · 02-08-2005, 06:29 PM

hi there,
I installed phpv5.0.3 and mySQLv4.1 in my system. There is an already configures IIS Server too. I made a php file with the name "test.php" and copied it into the "www" root folder of Inetpub. The following is a php code I wrote :

PHP Code:


			
<html>

<body>

<?php

$db = mysql_connect("$localhost", "$root","$sqlserver") or die("Invalid server or user.");

mysql_select_db("student",$db);

$sql = "INSERT INTO info VALUES ('dilip',20);";

$result = mysql_query($sql);

?>

<body>

<html>

In the iexplore address bar, I typed http://localhost/test.php

The file is rightly recognized as a php file and is executing too. But, I get the following error message :

Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\test.php on line 4

mySQL is installed and confiured to localhost with username : root and password : sqlserver.

Please help me !!!

sde · 02-08-2005, 09:25 PM

it doesn't look like it was compiled with the mysql functions. you have 2 options.

option #1: ( the easiest ) un-install php 5, and install php 4.3.10

option #2: ( not sure if this is it ) find your php.ini file , probably c:\windows\php.ini, and make sure the mysql libraries are un-commented. if that line was commented, then un-comment and re-start your web server.

i'd go with #1 if i were you.