Programming Forums > Web Development and Design > PHP

HelloWorldProgram · Jul 8th, 2005, 3:40 PM

I am trying to check for access to my database(mysql), therefore I type the following code, and I save it as a php file and I try to run it from my local server in Apache, but an error displays "Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\helloworld.php on line 3. My OS is XP
".

(Toggle Plain Text)

<?php
$conn=mysql_connect("localhost","name","password");
echo $conn;
mysql_close($conn);
?>

Ooble · Jul 9th, 2005, 7:10 AM

You have to enable php_mysql.dll and php_mysqli.dll in php.ini. You do this by removing the semicolon from these two lines:

(Toggle Plain Text)

;extension=php_mysql.dll
;extension=php_mysqli.dll

Then restart the Apache server.

HelloWorldProgram · Jul 9th, 2005, 3:07 PM

Ok, but what directory do i have to go to make those changes? I couldn't fine any php_ini. The only directory I found with the files php_mysql.dll and php_mysqli.dll was c/php5/ext and these files didnt have any ; . Where do I have to go to type the while loop an stuff...Please can you explain in more details, I really appretiate your help.

Overmind · Jul 9th, 2005, 3:18 PM

If you don't know where the file is, then just do a search for it. Open it with notepad, then go Edit->Find, then type in: ;extension=php_mysql.dll and press ok. Take away the semi colon, do the same for ';extension=php_mysqli.dll'

HelloWorldProgram · Jul 9th, 2005, 9:38 PM

This is what i get when i open the file with notepad:

(Toggle Plain Text)

MZ?       ��  �       @                                   �   � �	�!�L�!This rogram annot be run in DOS mode.
$       5��q�p�q�p�q�p�
�|�s�p��z�t�p��t�s�p���-�s�p�q�q�

tempest · Jul 9th, 2005, 11:17 PM

You are looking for a file named "php.ini" most likely, not a .dll file.

Ooble · Jul 10th, 2005, 6:40 PM

You see those files called php.ini-dist and php.ini-recommended? Append "C:\PHP" or whatever your PHP location is to your PATH environment variable. You do this by going to Control Panel -> System -> Advanced -> Environment Variables, double-clicking on "Path" and adding ";C:\PHP" to it, then clicking OK a few times. Then make a copy of php.ini-recommended and call it php.ini. Then make the changes.

Jul 8th, 2005, 3:40 PM	#1
HelloWorldProgram Newbie Join Date: Jul 2005 Posts: 6 Rep Power: 0	another simple question about PHP and mySQL I am trying to check for access to my database(mysql), therefore I type the following code, and I save it as a php file and I try to run it from my local server in Apache, but an error displays "Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\helloworld.php on line 3. My OS is XP ". (Toggle Plain Text) <?php $conn=mysql_connect("localhost","name","password"); echo $conn; mysql_close($conn); ?> <?php $conn=mysql_connect("localhost","name","password"); echo $conn; mysql_close($conn); ?>

Jul 9th, 2005, 7:10 AM	#2
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	You have to enable php_mysql.dll and php_mysqli.dll in php.ini. You do this by removing the semicolon from these two lines: (Toggle Plain Text) ;extension=php_mysql.dll ;extension=php_mysqli.dll ;extension=php_mysql.dll ;extension=php_mysqli.dll Then restart the Apache server. __________________ Me :: You :: Them

Jul 9th, 2005, 3:18 PM	#4
Overmind Professional Programmer Join Date: Jun 2004 Location: South Africa, Johannesburg Posts: 301 Rep Power: 5	If you don't know where the file is, then just do a search for it. Open it with notepad, then go Edit->Find, then type in: ;extension=php_mysql.dll and press ok. Take away the semi colon, do the same for ';extension=php_mysqli.dll' __________________ [SIGPIC][/SIGPIC]

Jul 9th, 2005, 9:38 PM	#5
HelloWorldProgram Newbie Join Date: Jul 2005 Posts: 6 Rep Power: 0	This is what i get when i open the file with notepad: (Toggle Plain Text) MZ? �� @ � � � �!�L�!This rogram annot be run in DOS mode. $ 5��q�p�q�p�q�p� �\|�s�p��z�t�p��t�s�p��-�s�p�q�q� MZ? �� @ � � � �!�L�!This rogram annot be run in DOS mode. $ 5��q�p�q�p�q�p� �\|�s�p��z�t�p��t�s�p��-�s�p�q�q�

Jul 9th, 2005, 11:17 PM	#6
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	You are looking for a file named "php.ini" most likely, not a .dll file. __________________

Jul 9th, 2005, 3:07 PM	#3
HelloWorldProgram Newbie Join Date: Jul 2005 Posts: 6 Rep Power: 0	Ok, but what directory do i have to go to make those changes? I couldn't fine any php_ini. The only directory I found with the files php_mysql.dll and php_mysqli.dll was c/php5/ext and these files didnt have any ; . Where do I have to go to type the while loop an stuff...Please can you explain in more details, I really appretiate your help.

Jul 10th, 2005, 6:40 PM	#7
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	You see those files called php.ini-dist and php.ini-recommended? Append "C:\PHP" or whatever your PHP location is to your PATH environment variable. You do this by going to Control Panel -> System -> Advanced -> Environment Variables, double-clicking on "Path" and adding ";C:\PHP" to it, then clicking OK a few times. Then make a copy of php.ini-recommended and call it php.ini. Then make the changes. __________________ Me :: You :: Them

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Programming Forums > Web Development and Design > PHP

another simple question about PHP and mySQL