Jump to content
xisto Community
Sign in to follow this  

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

Recommended Posts

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


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. :unsure: 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)



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:






Share this post

Link to post
Share on other sites

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

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.