Unable to connect to mysql database

[cyberking]

Hi.
I have just started learning PHP along with MySQL.

I am trying to connect to the MySQL DB server but unable to. I have been tryin. Please help. Its urgent cos I shall soon have to work on PHP .

My testing program is as follows :

 <?php 
 
$si = function_exists('mysqli_connect');
if($si == 1)
{
echo 'MySQL is installed <br />';
}
else
{
echo 'Not able to connect';
}
?>
 

Please help. I am unable to connect to the MySQL server

[ak1dnar]

[PHP]function_exists('mysqli_connect');
[/PHP]
mysqli_connect is not the correct function
mysql_connect is the function

remove "i" from the function name

[ak1dnar]

When you post next time please read the posting guidelines.
Please give a proper title to your thread and wrap the coding using tags. because then from this page itself we can read the codings without going for a IDE.

[cyberking]

Yes. Ok I ll Follow the rules from the next time.

But For now, I still am not able to connect. Please see the following statement.

$dbcnx = mysql_connect("localhost","root","my_pass");

This is in the browser gives me a Fatal Error.

Wats the prob. Please help.

[ak1dnar]

Yes. Ok I ll Follow the rules from the next time.

But For now, I still am not able to connect. Please see the following statement.

$dbcnx = mysql_connect("localhost","root","my_pass");

This is in the browser gives me a Fatal Error.

Wats the prob. Please help.

[PHP]$dbcnx = mysql_connect("localhost","root","my_pass");[/PHP]
this line is not in your original post.
I just made the correction of your script.here its checking weather [PHP]mysql_connect[/PHP] is defined or not.

what do you really wanted. post the complete script here.

[cyberking]

[PHP]$dbcnx = mysql_connect("localhost","root","my_pass");[/PHP]
this line is not in your original post.
I just made the correction of your script.here its checking weather [PHP]mysql_connect[/PHP] is defined or not.

what do you really wanted. post the complete script here.

Hi.
Thanks for takin time to help me.

This is my first program where I am tryin to connect to MySQL server. The complete code is as follows:

<?php

$dbcnx = mysql_connect("localhost","root","my_pass");
if ($dbcnx)
{
echo 'Success';
}
else
{
echo ' Unable' ;
}

But I still get the same error.
Fatal Error: Call to undefined function mysql_connect

Thanks in advance

[ak1dnar]

Did you install mysql in your machine. this script is working fine with correct username and password to mysql server witch runs in the same machine.

[PHP]<?php
$dbcnx = mysql_connect("localhost","root","dba");
if ($dbcnx)
{
echo 'Success';
}
else
{
echo ' Unable' ;
}
?>[/PHP]

use [PHP] tags arround your php lines ;)

[cyberking]

Is that So??

Yes I have MySQL, Apache and PHP all installed on my system. But then, why is it not working for me?

Thanks again for tryin to help me

[ak1dnar]

Is that So??

Yes I have MySQL, Apache and PHP all installed on my system. But then, why is it not working for me?

Thanks again for tryin to help me

Do you have phpMyAdmin installed in your system. and what is the O/S.

[cyberking]

I have XP and I don have PhpMyadmin.

[ak1dnar]

I have XP and I don have PhpMyadmin.

download appserv and install it.
remove all your PHP,MySQL,Apache from the system.

give a fresh copy. Appserv is consist of PHP,APACHE,MySQL,phpMyAdmin in a single pack.

once you done try the coding again.

[cyberking]

But do i need phpmyadmin? Is it not possible without it?

Sorry. but the reason why I am asking is because I just installed all the three, mysql, PHP5 and apache. Is there anything that I have to do in the php.ini file. i even added the php_mysql.dll extension in the php.ini

[ak1dnar]

But do i need phpmyadmin? Is it not possible without it?

Sorry. but the reason why I am asking is because I just installed all the three, mysql, PHP5 and apache. Is there anything that I have to do in the php.ini file. i even added the php_mysql.dll extension in the php.ini

You have to put libmysql.dll to Windows dir.

[cyberking]

You have to put libmysql.dll to Windows dir.

I tried doin it. But still without any results, I still get the same error.. please help.

[ak1dnar]

Problem is with your system not in the coding. so it is up to you. here we can help if there is a error in the coding. again we can give the suggestions for up your system.thats it.

[cyberking]

Thanks again for replyin.

Well let me tell you everythin. I have altered my php.ini file.

Uncommented the extension=php_mysql.dll statement
I have the dll files in the system32 directory.
Php works with apache.
The phpinfo() function shows me all the configuration of php.
I am even able to create tables in MySQL, but the prob is when I try to connect to MySQL thru PHP. I have been tryin for nearl 24 hrs now and no success. Thanks for helpin me all the while. Can you suggest somethin..

[ak1dnar]

what are the dlls are available under system32.

[cyberking]

what are the dlls are available under system32.

php_mysql.dll
php_mysqli.dll
libmysql.dll

[ak1dnar]

under Apache httpd file try to find out this line.

LoadModule php5_module D:/AppServ/php5/php5apache2_2.dll

here in my machine php5 and apache2.2 so in your one version number might be changed.

if it not available add it.first do a search in your php directory.

*php*apache*.dll

if it available check the loadmodule line in httpd.

[cyberking]

Thanks again.

But then, as I said I have no problems in viewing php files in my browser. PHP works fie with Apache. I had also modified the LoadModule statement in the httpd.conf file.

[ak1dnar]

Thanks again.

But then, as I said I have no problems in viewing php files in my browser. PHP works fie with Apache. I had also modified the LoadModule statement in the httpd.conf file.

oops I missed that. ok in php.ini check this line.
mysqli.default_port = 3306

[cyberking]

Yes thats the same as what u have mentioned. its 3306. But still cant get it connected

[ak1dnar]

Add the extention line for msqli to ini file and always restart the node other wise changes never work.
extension=php_mysqli.dll

[cyberking]

Yes. I ll do that. Also BTW, if I rollback to php4 will there be chances that I can get it working? Right now I am using PHP5. I have heard that there is no embedded support for MySQL in PHP5. Thanks again