Cannot connect to mySQL ???

**plomon** · Feb 8, 2005 21:30

hi there,
I installed phpv5.0.3 and mySQLv4.1 in my system. There is an already configured 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 !!!

**St.** · Feb 8, 2005 21:48

There is no mysql default support into php5

**plomon** · Feb 8, 2005 23:03

So, what should I do now ??? Please help !!

**ujjwal** · Feb 8, 2005 23:26

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

die("cannot inser into Database"); 

?> 

<body> 

<html>

tried it out

**St.** · Feb 8, 2005 23:58

2 Ujjwal

yeap, he'll not see error, but will it work?

2 plomon
I dont know what you should do in win, but I heard you should put any .dll... Ask google it is frequent error

**ujjwal** · Feb 9, 2005 00:11

Originally Posted by St.

2 Ujjwal

yeap, he'll not see error, but will it work?

yes Sir, it works in apache server as well as iis.
He has also wrong in sql query .He has given 2 ";" instead of right one.
I think it works lets see what the guy's answer.

**ujjwal** · Feb 9, 2005 00:17

you can check it out.
also u can check u'r sql query there is 2 ;.

PHP Code:


<?php 

$dbhost = "localhost"; 

$dbusername = "root"; 

$dbpassword = "sqlserver"; 

$dbname = "student"; 





$connect = @mysql_connect ( $dbhost,$dbusername,$dbpassword ) or

die ("Could not connect ".mysql_error());

mysql_select_db($dbname,$connect) or

die("Could not select database".mysql_error());



?>

**St.** · Feb 9, 2005 00:46

and what is it?
Fatal error: Call to undefined function mysql_connect()

User Tag List

Thread: Cannot connect to mySQL ???

Thread Tools

Display

Cannot connect to mySQL ???

Bookmarks

Bookmarks

Posting Permissions