Create Facebook Like System With jQuery, MySQL, PDO In PHP

Facebook have it’s own like system which pretty good. This post will tell you how to create a “Like system” like that of Facebook. All you have to need is jQuery, MySQL Database and PDO PHP extension. This technic is partially used in my social network, Open. See the demo there in the social network. But you have to signup. DEMO You should create a user table with users data including user id, username, password, email etc…

[READ MORE]

How to run/execute SQL Code

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]

phpMyAdmin – A software to manage MySql Database

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. Requirements PHP You need PHP 5.2.0 or newer, with session support and the Standard PHP Library (SPL) extension. To support uploading of ZIP files, you need the PHP zip extension. For proper support of multibyte strings (eg. UTF-8, which is currently default), you should install mbstring and ctype extensions.

[READ MORE]