How to install php scripts using MySQL,phpMyAdmin on Trap17

using preinstalled script/auto installation
cPanel > Preinstalled scripts > "Addon Scripts" or "Fantastico" or "phpBB" or the scripts which you wanted to install
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/5.jpg
explaination: this method is auto install the scripts in public_html folder, database name and granted database user respect to its database.
note: by Addon Scripts, you can not choose other folder structure. by fantastico you can choose the folder structure and it is good when you have created a subdomain. (you can point which domain to install)
to un-install if you wanted to un-install, just simple go back to respect scripts cPanel and find un-install command/button
phpBB example installation
this screenshot is example/ideal auto installation/un-installation setting of phpBB from cPanel


using manual installation by own
well, sometime you wanted to install the scripts that unavailable in preinstalled scripts like e.g. delta classifieds (which is better than Noah IMO view my installation demo on trap17)... the steps are:
step 1) read the scripts instruction/read me for any extra notes from authors
step 2) think about where do you want to install; either main domain or subdomain
e.g.main domain -> http://haalaaluu.trap17.com/forum/
e.g.subdomain -> http://nypmm.haalaaluu.trap17.com/forum/
step 3) upload the scripts folder to public_html folder or subdomain folder(if you have one) accordingly
step 4) CHMOD or set the folders and files permission according to author instructed (this step may or may not need sometime)
step 5) cPanel > Site Management Tools > MySQL databases > create database and create MySQL user (remember; it will prefix your cpanel user name so i suggest please don't use fancy name. just simple name will do. e.g. yourcpanelname_class for classifieds scripts)
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/4.jpg
step 6) grand permissons(full privileges) on MySQL user to its database you have just created(between create database & create MySQL user, you can find "Grand Permissions")
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/8.jpg

step 7) now goto your browser point the installation path(according to script and author instructed) e.g. http://yourname.trap17.com/classifieds/install.php
step 8) follow the wizard accordingly
- and when the wizard request for database and database username, just type in accordingly(just now you've crerated in step 4 and 5) note: host = localhost
step 9) follow the wizard accordingly and you woll finish your installation
step 10) delete the install.php and extra folders (which needed to be deleted) instruction by author e.g. install and contrib folder in phpBB

when you wanted to install your own implemeted scripts
e.g. Guestbook
- please follow until step 6 from above
- cPanel > Site Management Tools > phpMyAdmin
- left panel > goto your database (which you've created in step 5)
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/6.jpg
- right panel > click on "SQL" tab > paste or type your sql query in text box > press "Go" button
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/7.jpg
screenshot - > http://i6.photobucket.com/albums/y222/haalaaluu/3.jpg
e.g.


explaination: the code will create a table called guestbook under the database you've created with id = input index, name = input name, email = input mail address, url = input hyperlink, message = input visitor comments, entry_date = input date, primary key(id) = id is a index
- now you have created your table, database already and you can start use of script. you can alter the table if you need to add extra fields later on e.g. gender on above code
to un-install if you wanted to un-stall, delete the script folder, delete the database or table(depand on your config), delete the MySQL user(depand on whether you configured one by one database/user method on each scripts)

conclusion
Please suggest or correct me if anything wrong or any different point of installation method.
This is about php using MySQL and phpMyAdmin. There is also PostgreSQL and phpPgAdmin. Idea concept is the same but only the command can be different. It's depand on you to choose which type of database to use.

some reference urls:
http://www.phpbbhacks.com/forums/index.php?c=6
http://www.phpbb.com/kb/categories.php
http://www.e3servers.com/support/flash/pan..._phpmyadmin.htm
http://www.help.thinkhost.com/web-developm...torial_357.html
http://www.crucialparadigm.com/resources/t...s-in-cpanel.php

not bad of a tutorial should have thought of that long ago but i assumed that it was already done. but gj either way.

Good tutorial. I knew how to do this a long time ago though