10 PHP and MySQL development tutorials

Why you Should be using PHP?s PDO for Database Access
———————————————————————————

PHP-PDO-Tutorials



This is an article about PHP’s PDO. PDO stand for "PHP data objects". Many PHP programmers learned how to access databases by using either the mysql or mysqli extensions. Since PHP 5.1, there?s been a better way. PHP Data Objects. PDO provide methods for prepared statements and working with objects that will make you far more productive!...



Read more: http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/





How to Create a Forum in PHP from Scratch
—————————————————————

This is a tutorial for creating a small forum script by having minim features, using PHP & MySQL. Whole script has been made by OOP’s methode. All the codes preety clean,nice & well organized.



Read more and download codes: http://www.tuttoaster.com/how-to-create-a-forum-in-php-from-scratch/





How to connect your site with twitter using @Anywhere
———————————————————————————

How to connect your site with twitter using @Anywhere



Twitter has launched @Anywhere, a more simple way of integrating twitter in your site. With it you can add follow buttons, hovercards, linkify twitter usernames and connect with twitter.  In this tutorial, Irina Borozan has shown you how to use @Anywhere in your site.



Read more and download codes: http://www.1stwebdesigner.com/tutorials/connect-twitter-anywhere/

IMP note: Twitter no longer support basic authentication. In place of this they are now supporting OAuth. Get more info about this from here.. http://blog.twitter.com/2010/08/twitter-applications-and-oauth.html





Facebook Style Tag Friends with Jquery, Ajax and PHP
——————————————————————————-

Facebook Style Tag Friends with Jquery, Ajax and PHP



This is a really nice tutorial about how to make a "facebook like tag friends in your status or update box" by Srinivas Tamada. This has been build by using Ajax, PHP & JQuery.



Demo: http://demos.9lessons.info/tagfriends.html

Read more and download codes: http://www.9lessons.info/2010/08/tag-friends-with-jquery-ajax-and-php.html#comment-form





Creating a Upload/Download System Using PHP Classes
——————————————————————————

This is file uploading and downloading script by Cody Robertson. The script is able to upload files with certain file extensions and set a limit to the size of the file which you want to upload. This will all go along with a sharing link and a force download script.



Read more and download codes: http://www.tuttoaster.com/creating-a-uploaddownload-system-using-php-classes/





9 Useful PHP Functions and Features You Need to Know
———————————————————————————

Here is an article about 9 useful PHP functions by Burak Guzel for PHP developers. These are like…



* Functions with Arbitrary Number of Arguments

* Using Glob() to Find Files

* Memory Usage Information



Read more and download codes: http://net.tutsplus.com/tutorials/php/9-useful-php-functions-and-features-you-need-to-know/





Creating a Web Poll with PHP
——————————————-

Creating a Web Poll with PHP



This is polling script which has made by PHP from tutsPlus network. Whole script has made by using OOP’s & described in full details. Truely a full script which any one can use in their web development work without giving a lot of pain to their brain.



Read more and download codes: http://net.tutsplus.com/tutorials/php/creating-a-web-poll-with-php/





PHP Variables: The Ultimate Guide
—————————————————

PHP Variables: The Ultimate Guide



Variables are important in every programming language ? and it?s no different in PHP. Variables give developers the possibility of temporarily storing data to be used in PHP scripts (in PHP?s case, this happens in the server?s memory). This guide by Elias Zerrouq, is all about working with variables in PHP.



Read more: http://sixrevisions.com/web-development/php-variables-the-ultimate-guide/





Digg Style Follow Unfollow Application Using jQuery and PHP
——————————————————————————————

Digg Style Follow Unfollow Application Using jQuery and PHP



We all know about Digg’s new layout design. I’m really impress a lot about it. If you use digg you might have seen that follow profiles features. This tutorial by Zeeshan Rasool, is exactly about that. He has made this by using PHP & JQuery.



Demo: http://demos.99points.info/digg_like_follow_unfollow/

Read more and download codes: http://www.99points.info/2010/09/new-digg-style-follow-unfollow-application-using-jquery-and-php/





Quick Tip: Working with MySQL and SUM
———————————————————

This is a quick tip video about how to using SUM() and IF() functions to make some useful queries.















Source: http://net.tutsplus.com/tutorials/databases/quick-tip-working-with-mysql-and-sum/


24th Sep 2010 at 3:06 PM   6130 Views

Twitter is no longer support twitter auth ...

25th Sep 2010 at 12:18 AM  

Ya Matteo,
I know twitter is now using "OAuth" method for all their third party applications authentication.

25th Sep 2010 at 9:31 AM