Home         Back

Saivaneri Web Tutor

CHAPTER 9

In this chapter we will give you UPDATED KNOWLEDGE BASE on web site management, database connectivity and PHP, ASP. 

What is database connectivity?

You are hosting a web site in which lots of people joins everyday. You want to update them to a database yourself manually (slow) or you may like to update themselves on the site itself by using database connection. 

What all you need for a DB connection

  1. Your site must support database
  2. it should be able to run a DB application
  3. It should be able to do the basic DB queries and operations like SQL commands
  4. It should be able to display the results dynamically on another page
  5. It should consume less power and flexible

What are the popular DB applications?

For Linux based servers My SQL is best FREE DB software

For Win* based servers Access DB is best 

What cost it is?

DB connectivity will cost you Rs.2000 per annum in India, on a Linux hosting

On a NT hosting it will be at least Rs5000 per annum 

What Language I should use for DB application?

PHP or ASP is better.

SQL,CGI, Java, PERL, C,C++ -any how serves the purpose. 

The following text is courtesy  http://www.php.net/docs.php. 

PHP
PHP, a recursive acronym which stands for "PHP: Hypertext Preprocessor" is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. Its syntax draws upon C, Java, and Perl, and is easy to learn. The main goal of the language is to allow web developers to write dynamically generated webpages quickly, but you can do much more with PHP.  You can download this manual in several formats at http://www.php.net/docs.php.  

What can PHP do?

Anything. PHP is mainly focused on server-side scripting, so you can do anything any other CGI program can do, such as collect form data, generate dynamic page content, or send and receive cookies. But PHP can do much more.

There are three main fields where PHP scripts are used.

bullet Server-side scripting.
bullet Command line scripting. 
bullet Writing client-side GUI applications

You can get FREE php scripts here..

www.Perl.com, www.hotscripts.com, www.worldwidemart.com, www.freecode.com , www.cgicript.net , www.transloader.com  etc.. 

I use PHPGEEK. This loads three things. One http Apache Webserver, Two the PHP compiler thirdly the MYSQL database. It is the best and easy way to learn, use and control the php at your home and at your site.

http://localhost/ is your web site opening page

http://localhost/phpmyadmin becomes your mysql db admin page

 put all your html, php files at C:\apache\htdocs\test folder

on web you must have a MYSQL account

www.freesql.org provides you a free mysql account. check it.

connect to your mysql db using connecting script

 

Next chapter on ASP

PREVIOUS CHAPTER                 NEXT CHAPTER

FOR FULL CHAPTER PLEASE CLICK HERE