Friendshood is vulnerable to MySQL Injection and shouldn’t be used anymore. Please see my latest project : http://subinsb.com/2013/12/open-an-open-source-social-network-is-released

Original Post :

Many of you now know the project I’ve been working on. In that project I have created a social Network called FriendsHood. I created this social network because my friends have been telling me to create a social network. They told me because School said to block Facebook and no student should use Facebook.

... [READ MORE]

He may not be a doctor or a ladies man – but we love Howard Wolowitz all the same!

You might have know The Subins Project created by me. It is hosted by AppFog. If you want to add Subins Like button to your blog, then follow these steps.

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′)

... [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.

Increase value APT::Cache-Limit

sudo gedit /etc/apt/apt.conf.d/70debconf

... [READ MORE]