[RESOLVED] Error on MYSQL

[thamizhinpan]

I have newly installed mysql saver on computer yesterday.

<?php
$con = mysql_connect("localhost","home","iagree");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

?>

But when I run a PHP file with this code I have been getting this error message

Fatal error: Call to undefined function mysql_connect() in I:\Inetpub\wwwroot\PHPTest\SQLTest.php on line 2

What is wrong on my code?

[kfcSmitty]

I have no idea what MySQL Saver is, but here is a whole list of solutions to your issue:

http://www.google.ca/search?q=%22Fat...ient=firefox-a

It seems mysql support has not been installed properly. You can verify by creating a simple php page with

<?php
phpinfo();
?>

And search for MySQL. If it fails to find it, then the support has not been added.

[thamizhinpan]

Ok, I'll try to install it correctly.
Thanks

[thamizhinpan]

Ok, I have solved that error.
But Now I couldn't got any message unless "Start" for this code.

<?php
  echo ("Start");
$con = mysql_connect("localhost","home","iagree");
  echo ("Test2");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  echo ("End");

// some code

?>

What is problem now?

[kfcSmitty]

try

<?php
  echo ("Start");
$con = mysql_connect('localhost','home','iagree') or Die("Error: " . mysql_error());
?>

You sure you have the MySQL server running on your PC with a user called "home" and a password "iagree"?

The password will be case sensitive FYI.

[I_Love_My_Vans]

@kfvSmitty

<?php
  echo ("Start");
$con = mysql_connect('localhost','home','iagree') or Die("Error: " . mysql_error());
?>

You need one more ) at the end of your connect code.

[thamizhinpan]

Oh No!...
I have tired on installing PHP & MySQL 5.
On last post I have wrote that I have Solved
"Call to undefined function mysql_connect()"
Error. But now I found that I din't solve that error until yet.
I didn't see that error on that time, because unfortunatly
I changed display_errors veriable as OFF on php.ini.

Now I changed it back to On mode.

I have saw your Google search results. Thanks for it.
But I cannot be able to solve my problum by guidlines those web pages.

I know you can't identify error of installation methord with out more details.
So I'm giving details on short form. and I'm attaching the phpinfo page,
php.ini, my.ini
with this reply.

Version = php-5.2.5-Win32
PHP base folder = C:\PHP5

php5ts.dll at C:\php5
php.ini at I:\windows
php.ini-dist Changed as PHP.ini

I have edited on PHP.ini
=====================================
doc_root =I:\inetpub\wwwroot
extension_dir = c:\php5\ext

removed ; mark on ;extension=php_mysql.dll.

-----------------------------------------------
sql version = mysql-5.0.0a-alpha-win
SQL base folder= c:\mysql\

If I couldn't install MYSQL, I can't learn it myself on my PC.
So please help me.

[visualAd]

1. Check that C:\php5\ext\php_mysql.dll exists.
2. Check that you have the file libmysql.dll in your mysql installation folder.
3. If it does either copy it to your PHP directory or add its path to the PATH environment variable. My Computer (right click) --> Properties --> Advanced --> Environment Variables.

[kfcSmitty]

You could also scrap the installation you have and use an all-in-one installer such as WAMP, which will install Apache, MySQL, and PHP in an easy to use step-by-step installer on a Windows system.

Link: http://www.wampserver.com/en/

[penagate]

Check that the IIS user account that you're using for that website has appropriate permissions to access the c:\php5\ext directory.

[thamizhinpan]

Hi, I'm very happy to say that mysql saver is working on my pc.
But I have set a different setting on sql saver
(I haven't read this method on any book until yet. So I don't know

about the side effects of this method. If any one know about it

please inform me)
That I changed WinMySQLadmin server as "mysqld-max-nt.exe" from "

mysqld-nt.exe".
But all books suggest mysqld-nt.exe for Windows XP.
But I haven't see any errors on it until yet.

Any way Thanks for all, Who take efforts to solve my problem.
I'm learning PHP happily with MYSQL Support with out others help.