Tutorial : Auto Completer using Prototype, Script.aculo.us

How many of you have always dreamt of creating an Auto Suggest Box. I bet everyone must have seen one of these somewhere or the other. if you use Gmail to send mails, you might recall that while typing the To address, Gmail shows a probable list of users from your address book. Nowadays most of the modern browsers also have this Auto Suggest control built in them, i.e when the user begins to type in a text box, a menu appears below the text offering completion suggestions.

Today I am going to teach you how to create an Auto Suggest Box using Prototype, Script.aculo.us. The script.aculo.us auto suggest box (autocompleter) replicates this control, but gives the developer control of the probable suggestions.

Index

• Page 1 : Introduction and
• Page 2 : Auto Suggest Box (local)
• Page 3 : AJAX Auto Suggest Box (remote via PHP/MySQL)

Demo & Source Download

Type out the name of the states of U.S.A.
Local Auto Suggest Box Demo : Click Here
Remote Auto Suggest Box Demo : Click Here

Download Source Here

Tutorial : Creating “Pretty SEO URLS” using Apache’s mod_rewrite

Imagine this, You have a dynamic site powered by PHP/MySQL, its doing ok, you have submitted your website URL to all the known search engines, but still your site doesn’t seem to get much traffic from the search engines…ever wondered why ?

Well firstly, search engines have billions of pages to search. Imagine your link to be something like www.yourdomain.com/index.php?page=aboutme, its tough for any search engine to comprehend any keywords from the link.
But how about www.yourdomain.com/page/about-me.html ? These links are static Links, SEO Friendly Links, “Pretty Links”.

So today we are going to learn how to convert your ugly links into pretty links.

Index

1. Step 1 : Enable mod_rewrite in httpd.conf
2. Step 2 : Create A Simple PHP file
3. Step 3 : .htaccess file
   Method 1 – For only a single Variable
   Method 2 – For 1 and more than 1 Variable(s)
4. Conclusion

Ugly URLs
http://www.visionmasterdesigns.com/demo/seo/test.php?page=page1
http://www.visionmasterdesigns.com/demo/seo/test.php?page=page1&var=foo

Pretty URLs
http://www.visionmasterdesigns.com/demo/seo/page1.html
http://www.visionmasterdesigns.com/demo/seo/page1/foo.html

Click Here to download the script files.

Tutorial : AJAX interface/menu using jQuery/PHP

Hello Guys,

I have been busy with college lately, since this is my last year in college, I need to do a very cool project to get some good marks . Anyways that doesn`t mean I won`t be postin tutorials here . Want to present your data using AJAX/PHP/MySQL by just coding few lines ? Well here it is. This tutorial teaches you how to present data using AJAX (using jQuery) with some neat effects. We can use PHP/MySQL to store the data and call it. In this tutorial I`ll teach you how to do so with PHP. So lets begin !

You can check the demo HERE.
You can download these files HERE

Index

1. Create the HTML page – index.html
2. • The CSS
   • The HTML
   • The Javascript
   • Final interface.html page
3. Create the PHP File – boo.php

Tutorial : Using phpMyAdmin to manage mySQL

Hello Everyone !

I am really excited ! Its been 18 days since the blog started and the response is amazing. I really hope these tutorials are helpful. Anyways I have seen a lot of people having problem setting up phpmyadmin and Lot more have no idea how to use it. So this tutorial is dedicated to you folks. I`ll teach you the basics of how to play with phpMyAdmin. Frankly I have not seen much tutorials on how to use phpmyadmin, and I don`t know how well you guys will like it.
Anyways

phpMyAdmin 2.11.x Front Page

Tutorial : Creating a Content Management System using PHP/MySQL

Its been 2 weeks since visionmasterdesigns.com was started and I am very glad with the response. Lot of people want to explore PHP/MySQL more and I think I`ll give in to that . So Today lets design a Content Management System using PHP/MySQL.

Index

• Page 1 : Introduction
• Page 2 : Database Work
• Page 3 : functions.php
• Page 4 : articlefunctions.php
• Page 5 : insertarticle.php
• Page 6 : editarticle.php
• Page 7 : article.php – Our start File
• Demo – Here
• Script – Here

Don`t get scared seeing the number of pages. This system has 5 files as listed above. Our CMS features add,edit and delete article records.

Introduction to CMS

CMS is an application through which you can add content without the need of uploading any files. You can create,edit,delete articles directly online. These articles are stored in the backend i.e database, in our case MySQL. Everytime user requests for a particular article, the php script retrieves the article and displays it to the user.

I`ll try to keep it as simple as possible.

Tutorial : Intoduction to AJAX with PHP

Hey Everyone,

I have been busy lately, but that ain`t gonna stop me from writing tutorials ! Anyways I had promised a Ruby on Rails tutorial, I am working on that, I am trying to make it as descriptive as possible, but before I post that, a lot of people asked me what is AJAX, how to integrate it with PHP/MySQL etc ? Well guys, This tutorial is dedicated to you all !

Along with answering all your queries, I will be teaching you how to make a simple application in PHP/MySQL using AJAX.

Index

• Page 1 : Introduction
• Page 2 : Introduction to ‘AJAX’
• Page 3 : General AJAX code
• Page 4 : Ajax Application using PHP (Username validator)
• Click here to see demo

Required : Some basic knowledge in Javascript, HTML.