Connect to a database server via domain name (‘example.com:3306’)<\/li>\n<\/ul>\nWhy this problem happens?<\/h3>\n
\nThis problem has nothing to do with your PHP code. In fact, the problem happens when PHP tries to look up the IP address of your domain name. Let’s take a look to the following example. Suppose I have the following code:<\/p>\n
\r\n$data = file_get_contents('http:\/\/example.com\/test.html')\r\n\r\n\/\/process the $data here...\r\n<\/pre>\nWhen PHP executes this code, it will try to get the IP address of example.com first, and talk to the server to retrieve the content. This problem happens because PHP is unable to get the IP address of example.com.<\/p>\n
Initially, I thought it was my server issues, therefore I tried to ping example.com on the server, i.e.,<\/p>\n
\r\n#ping example.com\r\n<\/pre>\nand the result looks fine to me. So the problem has nothing to do with the OS \/ server. Then I run the following code in PHP<\/p>\n
\r\n$IP = gethostbyname('example.com');\r\necho $IP;\r\n<\/pre>\nNormally, I expect to see the IP address of example.com. If it return ‘example.com’, that means PHP is unable to determine the IP address. That explains why the web application stops working.<\/p>\n
Solution #1: Restart XAMPP<\/h3>\n
Try to restart the XAMPP to see whether it resolves the problem or not:<\/p>\n
\r\nsudo \/opt\/lampp\/lampp stopapache\r\nsudo \/opt\/lampp\/lampp startapache\r\n<\/pre>\nThis method aims to resolve the situation that the XAMPP was already started but the network was not available. Restarting the Apache server helps to resolve this problem.<\/p>\n
Solution #2: \/etc\/hosts<\/h3>\n
Since PHP was unable to lookup the IP address, I decided to give some hints to PHP by editing \/etc\/hosts:<\/p>\n
\r\n123.1.1.1 example.com\r\n123.1.1.2 anotherexample.com\r\n<\/pre>\nThis is a quick and easy solution. However, if example.com is moved a different IP address, you will need to update the file. It is pain in long term.<\/p>\n
Solution #3: Stop using XAMPP<\/h3>\n
As I mentioned earlier, I notice that this problem happen in XAMPP environment only. I haven’t experienced this kind of problem with native Apache and native PHP. So I guess it may have something to do with XAMPP.<\/p>\n
In fact, it is quite easy to switch from XAMPP to native Apache+PHP+MySQL etc. Native applications give you better performance and reliability and most importantly: the packages get upgraded automatically.<\/p>\n
Hope it helps.<\/p>\n
–Derrick<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
One of my PHP web applications stopped working today. After I investigated the issues, I noticed that this is a very famous, yet unsolved error. I have no idea why Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[94,141,144,6,69],"tags":[172,58],"class_list":["post-3134","post","type-post","status-publish","format-standard","hentry","category-computer-problems-computer-help-pc-support","category-programming-problems","category-sever-problem","category-technology","category-troubleshooting-technology","tag-php","tag-xampp"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p1sqzr-Oy","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3495,"url":"https:\/\/icesquare.com\/wordpress\/xampp-php-fatal-error-class-ziparchive-not-found\/","url_meta":{"origin":3134,"position":0},"title":"XAMPP – PHP Fatal error: Class ‘ZipArchive’ not found","author":"Derrick","date":"March 11, 2014","format":false,"excerpt":"I just finished writing a program written in PHP today. When I moved to the another environment, I found that the script didn't work. After some investigations, I found that the program stopped running because of the following error: PHP Fatal error: Class 'ZipArchive' not found in ... The error\u2026","rel":"","context":"In "Computer Problems"","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/icesquare.com\/wordpress\/wp-content\/uploads\/2014\/03\/xampp-logo.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2788,"url":"https:\/\/icesquare.com\/wordpress\/phpfatal-error-allowed-memory-size-of-x-bytes-exhausted-tried-to-allocate-y-bytes\/","url_meta":{"origin":3134,"position":1},"title":"[PHP]Fatal error: Allowed memory size of x bytes exhausted (tried to allocate y bytes)","author":"Derrick","date":"May 4, 2012","format":false,"excerpt":"[ad#adbrite] A user complained to me that my PHP web applications stopped working today. After I digged into the error log, I found that following message: PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 261900 bytes) in Unknown on line 0 Obviously, this is related\u2026","rel":"","context":"In "Computer Problems"","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"\/wordpress\/wp-content\/uploads\/2011\/12\/computer-problem.jpg","width":350,"height":200},"classes":[]},{"id":305,"url":"https:\/\/icesquare.com\/wordpress\/installing-xampp-on-fedora-12-64-bit\/","url_meta":{"origin":3134,"position":2},"title":"Installing XAMPP on Fedora 12 64-bit system","author":"Derrick","date":"December 8, 2009","format":false,"excerpt":"I was installing XAMPP on Fedora 11 64-bit today, and I saw this famous message: sudo \/opt\/lampp\/lampp startapache XAMPP is currently only availably as 32 bit application. Please use a 32 bit compatibility library for your system. The message is very clear that XAMPP doesn't like 32-bit system. So, we\u2026","rel":"","context":"In "Computer Problems"","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2156,"url":"https:\/\/icesquare.com\/wordpress\/cant-connect-to-local-mysql-server-through-socket-varlibmysqlmysql-sock-2\/","url_meta":{"origin":3134,"position":3},"title":"Can’t connect to local MySQL server through socket ‘\/var\/lib\/mysql\/mysql.sock’ (2)","author":"Derrick","date":"December 21, 2011","format":false,"excerpt":"When I tried to connect to the MySQL server through PHP, I got the following error: Can't connect to local MySQL server through socket '\/var\/lib\/mysql\/mysql.sock' (2) To give you some background, here is my situation. My Fedora Linux is a 64-bit machine, and I have installed a 32-bit version of\u2026","rel":"","context":"In "Computer Problems"","block_context":{"text":"Computer Problems","link":"https:\/\/icesquare.com\/wordpress\/category\/technology\/computer-problems-computer-help-pc-support\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":832,"url":"https:\/\/icesquare.com\/wordpress\/think-twice-before-upgrading-your-server-to-php-5-3-3\/","url_meta":{"origin":3134,"position":4},"title":"Think twice before upgrading your server to PHP 5.3.3","author":"Derrick","date":"September 6, 2010","format":false,"excerpt":"I upgraded to PHP 5.3.3 today, and I was shocked! I found a huge security hole default setting change that may leak the source code to public, which never happened in the earlier version. Here is an example. Suppose my code looks like this: