Saivaneri Web Tutor
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
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.
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.
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