This simple function will help you to find the client’s IP. You could use $_SERVER[‘REMOTE_ADDR’] , but this method will not returns the actual IP address. To get the real IP address use this method. function getUserIpAddr(){     if (!empty($_SERVER[‘HTTP_CLIENT_IP’])){         return $_SERVER[‘HTTP_CLIENT_IP’];     }else if (!empty($_SERVER[‘HTTP_X_FORWARDED_FOR’])){         $ite=explode(‘,’,$_SERVER[‘HTTP_X_FORWARDED_FOR’]); return str_replace(" ",",$ite[0]);     }else{         return $_SERVER[‘REMOTE_ADDR’];     }... [READ MORE]

If you want to get client’s IP address you will use $_SERVER[‘REMOTE_ADDR’] function in PHP. But you will not get the real IP address of the client. To get the real IP address You can use the method I used. Also With this method you can also find the City, State, Country client’s in. The code is pretty simple. With the help of NetIP.de it was pretty easy. $response=@file_get_contents(‘http://www.netip.de’);if (empty($response)){throw new InvalidArgumentException("Error contacting Geo-IP-Server"... [READ MORE]

You might have know the project I have been working on. The Subins Project. I have spent a year on this project. My wish was to host this on a site. But I couldn’t afford the hosting charges cause I’m 12 and my dad won’t lend me money. I took a leave because of fever. On that day I was browsing the internet and out of nowhere I saw a post about a site named AppFog.... [READ MORE]

You might have wanted to do a SQL query inside an another SQL query. You can do this using SQL Subquery. It’s simple as ABC. Here’s an example : SELECT * FROM `fdposts` WHERE user IN (SELECT friend FROM `fdfriends` WHERE user=’subins2000′) The above code will select rows in table fdposts where user is the value of friend row in the table fdfriends. As you can see it’s very simple. Here’s another example : SELECT * FROM `posts` WHERE user IN (SELECT name FROM `members` WHERE user=’subins2000′) The above code will select rows in table posts where user is the value of the row name in the table members.... [READ MORE]

If you have installed phpMyAdmin do as below. Go to localhost/phpmyadmin/server_sql.php. Paste the SQL Code in the text box shown in the page and press GO button at the bottom right of the page. If you want to run code in PHP file do as below. Open your PHP file. Add these lines in the file. mysql_query("sql code here"); NOTE – Replace the red line with the SQL code.... [READ MORE]

If you want to manage your MySql table you can use a software called phpMyAdmin. You can install phpMyAdmin in any Operating Systems. This tutorial will help you to install phpMyAdmin in Linux. <h2 id="require" style="font-family: sans-serif; max-width: 70em;"> Requirements </h2> <ul style="font-family: sans-serif; margin: 1em; max-width: 70em;"> <li style="margin-top: 0.5em;"> <b>PHP</b> <ul style="margin: 1em 1em 0px; max-width: 70em;"> <li style="margin-top: 0.5em;"> You need PHP 5.2.0 or newer, with&nbsp;<tt>session</tt>&nbsp;support&nbsp;and the Standard PHP Library (SPL) extension.... [READ MORE]

This function will allow you to get a file’s extension in PHP. function getExtension($fileName){ $i = strrpos($fileName, "."); if (!$i) { return ""; } $length = strlen($str) - $i; $extens = substr($str, $i+1, $length); return $extens; } For example you need to get a extension of the file photo.jpg. To get the extension type this code in your PHP file. <span style="color: #660000;"><?php</span> <span style="color: #660000;">echo</span> getExtension<span style="color: #660000;">(</span>'<b><span style="... [READ MORE]

Some may have problem with uploading file more than 1 MB or 2 MB. You can fix this by editing the configuration file of PHP. To fix this follow the steps. Open Root Terminal (Applications -> System Tools -> Root Terminal). Type  sudo gedit /etc/php5/apache2/php.ini  and press enter key. You will get gedit application with the php.in file. Search for the words post_max_size & upload_max_filesize. If you found the words you will see a = after the word post_max_size & upload_max_filesize.... [READ MORE]

This tutorial will help you to insert XML file’s contents to a MySQL Database table using php. Note- If you can’t open PHP files in browser in Ubuntu Linux See the Tutorial : http://subinsb.com/how-to-open-php-files-in-ubuntu-instead-of-downloading This is the XML data we are going to insert in to our MySQL Table. <pre class="prettyprint"><code>&lt;span style="font-family: inherit;">&lt;items&gt;&lt;/span> <span style=“font-family: inherit;"> <item></span> <span style=“font-family: inherit;"> <title>Google</title></span> <span style=“font-family: inherit;"> <url>google.com</url></span> <span style=“font-family: inherit;"> </item></span> <span style=“font-family: inherit;"> <item></span> <span style=“font-family: inherit;"> <title>Google Accounts</title></span> <span style=“font-family: inherit;"> <url>accounts.... [READ MORE]

This tutorial will help you to send data to a php file to hide a div ie sending a string to a php file to hide a div.Follow these steps. 1 : Open the php file which contains the div to hide.       Paste this code above the  tag <blockquote class="tr_bq"> <p> <b><style type="text/css"></b><b><span style="font-family: Times, 'Times New Roman', serif;">#<?php echo $_GET[&#8216;div&#8217;]; ?>{</span></b><b><span style="font-family: Times, 'Times New Roman', serif;"><span style="color: red;">display:none;</span></span></b><b><span style="font-family: Times, 'Times New Roman', serif;">}</span></b><b><span style="font-family: Times, 'Times New Roman', serif;"></style></span></b> </p> </blockquote> If you want to show a div change the line "... [READ MORE]