Re: [PHP] Cannot connect to database when using Zend studio debugger
Thanks, Burhan. Supersky Burhan Khalid [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Supersky wrote: Dear Richard, Thanks. After I swaped to PHP4 option in the preference of Zend Studio, I can connect to the database. However, other problems arised. The problem might be that my PHP version installed is 5.0.3 indeed. You should post this stuff at the My Zend center at zend.com -- they are really good with supporting such things. I've had a few issues with Zend studio that they showed me how to fix. Although I'm still a bit annoyed that they don't support subversion, studio is still a great product. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to database when using Zend studio debugger
Supersky wrote: Dear Richard, Thanks. After I swaped to PHP4 option in the preference of Zend Studio, I can connect to the database. However, other problems arised. The problem might be that my PHP version installed is 5.0.3 indeed. You should post this stuff at the My Zend center at zend.com -- they are really good with supporting such things. I've had a few issues with Zend studio that they showed me how to fix. Although I'm still a bit annoyed that they don't support subversion, studio is still a great product. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to database when using Zend studio debugger
Hello Supersky, Thursday, March 31, 2005, 11:49:37 AM, you wrote: S I am learning how to use Zend studio 4.0 debugger. With internal S mode, when I debug a program that needs a connection to a Mysql S database, I get the message Fatal error/b: Call to undefined S function mysql_connect() in bD:\Program Files\Apache S Group\Apache2\htdocs\topiclist.php. Sounds to me like Zend is debugging with the wrong PHP library. mysql_connect() is a PHP4 function, it's mysqli_connect() in PHP5 (by default anyway) - see if it helps swapping over the debug version used in the Zend Studio properties for your project? Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I do not fear computers. I fear the lack of them. - Isaac Asimov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to database when using Zend studio debugger
Dear Richard, Thanks. After I swaped to PHP4 option in the preference of Zend Studio, I can connect to the database. However, other problems arised. The problem might be that my PHP version installed is 5.0.3 indeed. Best regards, Supersky Richard Davey [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Supersky, Thursday, March 31, 2005, 11:49:37 AM, you wrote: S I am learning how to use Zend studio 4.0 debugger. With internal S mode, when I debug a program that needs a connection to a Mysql S database, I get the message Fatal error/b: Call to undefined S function mysql_connect() in bD:\Program Files\Apache S Group\Apache2\htdocs\topiclist.php. Sounds to me like Zend is debugging with the wrong PHP library. mysql_connect() is a PHP4 function, it's mysqli_connect() in PHP5 (by default anyway) - see if it helps swapping over the debug version used in the Zend Studio properties for your project? Best regards, Richard Davey -- http://www.launchcode.co.uk - PHP Development Services I do not fear computers. I fear the lack of them. - Isaac Asimov -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Supersky, Thursday, January 27, 2005, 8:55:04 AM, you wrote: S But I cannot, and I see Fatal error: Call to undefined function S mysql_connect() in 1. Make sure you uncomment the extension=php_mysql.dll in your php.ini 2. Copy the php_mysql.dll to your Windows/System folder 3. Restart Apache. You might look at: ?php phpinfo(); ? To see before and after (Look for the section on MySQL.) -- Leif (TB lists moderator and fellow end user). Using The Bat! 3.0.2.3 Rush under Windows XP 5.1 Build 2600 Service Pack 2 on a Pentium 4 2GHz with 512MB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Supersky wrote: Hello, I'm using the following statements to connect to a database. ?php $conn = mysql_connect('localhost', 'root', '') or die (Can't Connect To Database); $db = mysql_select_db(testDB, $conn) or die (Can't Select Database. mysql_error()); ? But I cannot, and I see Fatal error: Call to undefined function mysql_connect() in My OS is WinXP, I have installed Mysql 4.1, Apache 2.0.52, and PHP 5.03. Apache and PHP work well if I don't connect to a database. Please any help or suggestions are welcome. Thanks! Gan uncomment mysql.dll in your php.ini and restart apache -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Dear Leif, Thank you for your help. I have done what you told me to do. But it doesn't work. Best, Supersky Leif Gregory [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Supersky, Thursday, January 27, 2005, 8:55:04 AM, you wrote: S But I cannot, and I see Fatal error: Call to undefined function S mysql_connect() in 1. Make sure you uncomment the extension=php_mysql.dll in your php.ini 2. Copy the php_mysql.dll to your Windows/System folder 3. Restart Apache. You might look at: ?php phpinfo(); ? To see before and after (Look for the section on MySQL.) -- Leif (TB lists moderator and fellow end user). Using The Bat! 3.0.2.3 Rush under Windows XP 5.1 Build 2600 Service Pack 2 on a Pentium 4 2GHz with 512MB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Supersky, Thursday, January 27, 2005, 1:37:12 PM, you wrote: S Thank you for your help. I have done what you told me to do. But it S doesn't work. Does phpinfo(); output anything like below (except it looks prettier! :grin: )? mysql MySQL Support enabled Active Persistent Links 0 Active Links0 Client API version 4.1.7 Directive Local Value Master Value mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no valueno value mysql.default_password no valueno value mysql.default_port no valueno value mysql.default_socketno valueno value mysql.default_user no valueno value mysql.max_links Unlimited Unlimited mysql.max_persistentUnlimited Unlimited mysql.trace_modeOff Off If you don't see that in the phpinfo(); output, then it didn't get loaded correctly. Hmmm. It's been a bit since I've installed PHP. Find libmysql.dll and dump that in your windows/system folder too. See: http://php.mirrors.powertrip.co.za/manual/en/install.windows.extensions.php However, I checked my system folder and I do not have that one in there. It might be pulling it from my path somewhere though. I'll have to check when I get home. -- Leif (TB lists moderator and fellow end user). Using The Bat! 3.0.2.3 Rush under Windows XP 5.1 Build 2600 Service Pack 2 on a Pentium 4 2GHz with 512MB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Supersky wrote: Thank you for your help. I have done what you told me to do. But it doesn't work. Are you seeing the same error message, or is it not working in a different way? If it's the same way: 1. Did you restart Apache? 2. What does ?php phpinfo()? say about php.ini? 3. What does ?php phpinfo()? say about MySQL? -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Richard, 1. I restarted Apache. 2. ?php phpinfo()? say D:\WINDOWS. 3. ?php phpinfo()? say nothing about MySQL. Thanks, Supersky Richard Lynch [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Supersky wrote: Thank you for your help. I have done what you told me to do. But it doesn't work. Are you seeing the same error message, or is it not working in a different way? If it's the same way: 1. Did you restart Apache? 2. What does ?php phpinfo()? say about php.ini? 3. What does ?php phpinfo()? say about MySQL? -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Leif, There is nothing about mysql on the information page. Thanks for your link and I am reading it. Thanks, Supersky Leif Gregory [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Supersky, Thursday, January 27, 2005, 1:37:12 PM, you wrote: S Thank you for your help. I have done what you told me to do. But it S doesn't work. Does phpinfo(); output anything like below (except it looks prettier! :grin: )? mysql MySQL Support enabled Active Persistent Links 0 Active Links0 Client API version 4.1.7 Directive Local Value Master Value mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no valueno value mysql.default_password no valueno value mysql.default_port no valueno value mysql.default_socketno valueno value mysql.default_user no valueno value mysql.max_links Unlimited Unlimited mysql.max_persistentUnlimited Unlimited mysql.trace_modeOff Off If you don't see that in the phpinfo(); output, then it didn't get loaded correctly. Hmmm. It's been a bit since I've installed PHP. Find libmysql.dll and dump that in your windows/system folder too. See: http://php.mirrors.powertrip.co.za/manual/en/install.windows.extensions.php However, I checked my system folder and I do not have that one in there. It might be pulling it from my path somewhere though. I'll have to check when I get home. -- Leif (TB lists moderator and fellow end user). Using The Bat! 3.0.2.3 Rush under Windows XP 5.1 Build 2600 Service Pack 2 on a Pentium 4 2GHz with 512MB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Supersky wrote: 2. ?php phpinfo()? say D:\WINDOWS. And is your php.ini file in D:\WINDOWS? Cuz if it ain't, PHP ain't reading it. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Richard, I've added my PHP folder to the system path. I think this can do the same as putting in in D:\windows. My problem has been solved. Thank you very much. Gan Richard Lynch [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Supersky wrote: 2. ?php phpinfo()? say D:\WINDOWS. And is your php.ini file in D:\WINDOWS? Cuz if it ain't, PHP ain't reading it. -- Like Music? http://l-i-e.com/artists.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Cannot connect to Database
Hello Leif, I've solved my problem. Thanks! Supersky Supersky [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Leif, There is nothing about mysql on the information page. Thanks for your link and I am reading it. Thanks, Supersky Leif Gregory [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Supersky, Thursday, January 27, 2005, 1:37:12 PM, you wrote: S Thank you for your help. I have done what you told me to do. But it S doesn't work. Does phpinfo(); output anything like below (except it looks prettier! :grin: )? mysql MySQL Support enabled Active Persistent Links 0 Active Links0 Client API version 4.1.7 Directive Local Value Master Value mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no valueno value mysql.default_password no valueno value mysql.default_port no valueno value mysql.default_socketno valueno value mysql.default_user no valueno value mysql.max_links Unlimited Unlimited mysql.max_persistentUnlimited Unlimited mysql.trace_modeOff Off If you don't see that in the phpinfo(); output, then it didn't get loaded correctly. Hmmm. It's been a bit since I've installed PHP. Find libmysql.dll and dump that in your windows/system folder too. See: http://php.mirrors.powertrip.co.za/manual/en/install.windows.extensions.php However, I checked my system folder and I do not have that one in there. It might be pulling it from my path somewhere though. I'll have to check when I get home. -- Leif (TB lists moderator and fellow end user). Using The Bat! 3.0.2.3 Rush under Windows XP 5.1 Build 2600 Service Pack 2 on a Pentium 4 2GHz with 512MB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php