How To: Install Scripts And Create Database preinstalled scripts, own scripts

[badinfluence 0]

How to install php scripts using MySQL,phpMyAdmin on Xisto

 

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 Xisto)... 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://forums.xisto.com/no_longer_exists/

e.g.subdomain -> http://forums.xisto.com/no_longer_exists/

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://forums.xisto.com/no_longer_exists/

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.

CREATE TABLE guestbook (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,name VARCHAR(30) NOT NULL,email VARCHAR(50) NOT NULL,url VARCHAR(50) NULL,message TEXT NOT NULL,entry_date DATE NOT NULL,PRIMARY KEY(id));

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://forums.xisto.com/no_longer_exists/

http://www.e3servers.com/

http://forums.xisto.com/no_longer_exists/

http://forums.xisto.com/no_longer_exists/

[Saint_Michael 3]

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

[Adamrosso 0]

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