Warning: Invalid argument supplied for foreach() in /home/trap17/public_html/index.php on line 795
How To: Install Scripts And Create Database
  Nov 21, 2009

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

free web hosting
Open Discussion > MODERATED AREA > Tutorials

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

badinfluence
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.
CODE

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. smile.gif 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

 

 

 


Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)

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

Comment/Reply (w/o sign-up)



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

This textarea will convert to Rich-Text automatically (IE, Firefox, Chrome)

Similar Topics

Keywords : Install Scripts Database Preinstalled Scripts Scripts

  1. Check Your Scripts - (6)
    As I am reading through some of the (Mostly PHP) scripts posted here, the following posts are that
    of people saying that the script does not work. I suggest that you should test and make sure that
    your script works BEFORE you post it here. Craig....
  2. Install Php 5 To Work With Mysql - (1)
    hi, all php 5 is new to all people a long time( actually, I forget how long...). it introduced a
    more object-oriented design to developer. like, access type(public, private, protected), abstract
    type(classes that can't create objects), interface support, and more . althrought it is
    widerly available, someone still can't get it running with mysql. every time the php is starting
    up. a message prompted stated that some xtensions can not be found, and therefore, not loaded. so, I
    have written this to help other and newbie get it start quickly. note: thi...
  3. How To: Create And Install Your Own Cursor - a step by step guide (15)
    How To: Create And Install Your Own Cursor a step by step guide using animation shop (a
    program free with paint shop pro) Requirements: Animation Shop (can be found on the same disk
    as Paint Shop Pro) Any image Are you displeased with the cursor you've got? Are you
    dissatisified with those cursors you downloaded from that site? Then this tutorial's for you.
    Read on... Create or download your favourite image off the web. Open it in some image editing
    software (ie Paint Shop Pro) and resize it to 15x15. In Paint Shop go to Image --> Resize. Ent...
  4. How To Install A Favicon - Yup, a favicon. (51)
    Ok, you know those little icons that are to the left of a web address? |_ /smile.gif' border='0'
    style='vertical-align:middle' alt='smile.gif' /> http://www.domain.com_| Well that is called a
    favicon, folks. If you want one, simply do the following: 1.) Make sure your favicon is in .ico
    format. Name it favicon.ico 2.) Upload the favicon.ico to the same folder as your main index.html or
    index.php or index.asp, whatever. Basciaaly, you should have: http://domain.com/blah/favicon.ico
    http://domain.com/blah/index.___ , whatever you have. 3.) Put this into the head...
  5. How To Install Opengeu In Ubuntu - OpenGEU is a distro based on Enlightenment and derived from Ubuntu (2)
    First of all please note well that E17 is in beta phase, and can make your computer segfault
    (which by contrary - WILL NOT ERASE YOUR DATA - your computer will be restored to the statein which
    it was before it segfaulted), and if you don't want this to happen then don't install this!
    I'll now tell you how to install OpenGEU when you already have Ubuntu (or Kubuntu and
    Xubuntu ) installed already on your machine. First of all I need to introduce you to OpenGEU,
    it's a relativelly new Linux distro which uses Enlightenment instead of ...
  6. [linux] How To Manually Install Flock System Wide - (1)
    Since i am currently in the process of making my own Ubuntu-based distro and will be including Flock
    as one of the browsers to choose from, i figured i'd make a tutorial out of how to install Flock
    manually, since there appears to be no package for it in Ubuntu's repository and many other
    popular distros, and it is said that only Ultima Linux has Flock available. For those that
    don't know what Flock is, rather than going into deep detail here, i'll just provide a link
    to the browser's site: http://www.flock.com/ And yes, to start, you're going...
  7. Sql Injection, How To Do It, And How To Prevent It - NOT a hacking tutorial, learn how to secure PHP scripts (0)
  8. Install An Aef Forum Onto The Trap17 - From a zip file (11)
    Installing an AEF Forum on the Trap17 Server Preparation for Installing the AEF Forum
    The following items are required for the installation of the packaage onto your site: 1. - a copy
    of the AEF Forum zip package from http://anelectron.com/download.php 2. - a MySql Database 3. - a
    Database User 4. - a password for the Database User 5. - Privileges allowed for the Database User
    The details for ensuring that you have all of these items are as follows: 1. - a copy of the AEF
    Forum zip package from http://anelectron.com/download.php . Simply browse to t...
  9. Simple Scripts In Html And Javascript - Things like BackgroundColorChanger and so (7)
    like in the topic, here is a description how to change the Backgroundcolor "On The Fly", by klicking
    on a button or radio-box first, we ned the html-and body-tags, create a new html-file on your
    desktop and write the following: QUOTE browser interpretation: html - tag
    means "hey, browser, here comes HTML" in the body-tag you define the looking of your site. you can
    add things like "bgcolor" for the background, "text" for the textcolor and link / alink / hlink /
    vlink to define the linkcolor ( ) the scripttag is the tag, we'll need now (sorr...
  10. [php] Clean Code Functions - Clean up your html output from php scripts (5)
    There is another Topic about writing 'clean' HTML code posted elsewhere on the Forum.
    I'll edit this Topic and add the link so you can review it on your own, and there is no need for
    me to comment on it in this thread, but the purpose of this Topic is to introduce a pair of
    functions which can be used for making sure that the HTML output from my scripts is readable when a
    view-source is reviewed. Two handy functions are included here. They work together quite nicely,
    and I will start this Tutorial with a short summary of the reasons for their 'being...
  11. Cpanel Preinstalled Scripts, Extras, And Cpanel Options - Part 6 of My 7 Part Tutorial (1)
    This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
    other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
    emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 2: Useful Site
    Management Tools Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5:
    Advanced Tools Part 7: Fantastico Detailed Cpanel Tutorial Part 4: PreInstalled Scripts,
    Extra, and Cpanel Options In this tutorial I will, in detail explain all of th...
  12. Adding Data To A Database And Displaying It Later - Using Forms, PHP and MySQL (1)
    Requirements: PHP Support MySQL Database access I am going to use a news program as an example.
    Ok, first you are going to need to connect to the database. Do so by using the code below. I have
    added some comments where you will need to edit to fit your server's specifications. Create a
    new file with notepad and call it config.php QUOTE //Change root to your database
    account's username $dbusername = "root"; //Add your account's password in between the
    quotations $password = " "; //Add the name of the database you are using in between the qu...
  13. How To Install Phpbb? - (8)
    QUOTE Here are the steps: Download the latest version of phpBB2. Currently it can be
    found at http://www.phpbb.com/downloads.php . I prefer the .tar.gz files, and winzip has no
    problems dealing with them. Decompress the files to a directory on your local system, making sure
    that you maintain the relationship between directories. I'll suggest that you decompress them to
    c:\webupload Now, within C:\webupload, you should have a phpBB2 directory, full of goodies. Open
    up your FTP client, and connect to where your web host tells you to go for uploading yo...
  14. How To Install Php Scripts - for people who don't like uploading all the time (0)
    OK. Here's what you need: 1. Web hosting that has FTP 2. A script or something to install 3.
    A program called SmartFTP I'll use my site for an example... 1. Enter your FTP login info
    2. When you login in your files, images, and stuff will show up. 3. Now that you're logged in
    you have to choose what file you want to import into your website. Go to "My Documents" and right
    click on the file you want to put on your site and select "copy". 4. Next you got to open put the
    dictionary that your website is in. Ok what that means the place where the "i...
  15. How To Install Php-nuke - How to install PHP-Nuke manually (12)
    Download PHPNuke (www.phpnuke.org) and unzip it into a directory. Now go to where your web server is
    installed (or web hosting ftp)! Create a folder and call it phpnuke. Now upload everything from the
    HTML folder into the phpnuke folder you created. Than go to the config file of phpnuke
    (\phpnuke\config.php) Ok now, if you have phpedit installed than this will be easier than using
    Notepad. Go to line 32 and you sould see this: $dbhost = "localhost"; $dbuname = "root"; $dbpass =
    ""; $dbname = "nuke"; $prefix = "nuke"; $user_prefix = "nuke"; $dbtype = "MySQL"; If this...
  16. Cpanel Mysql Database Management - Part 2.1 Of My 7 Part Cpanel Tutorial (6)
    This tutorial is an extension to my 7 tutorial series about the Cpanel. The 7 different Cpanel
    tutorials can be found below. Part 1: E-mail Management Part 2: Useful Site Management Tools
    Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part
    6: PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel
    Tutorial Part 2.1: MySQL Management In this tutorial, i will explain how to add, edit, delete
    and over-all manage the MySQL Feature in the Cpanel. Creating a MySQL Database 1) ...
  17. Install A Simple Machines Forum - (11)
    If you want to have your own Simple Machines running up without any ADs of any kind , sign up at
    Trap17 and posting until you have enough credits then post an application form and then wait to be
    approved. After that , do like this and you will have your own forum setting up : 1.Download
    Simple Machines You can get it at Simple Machines download page , click here to get one
    2.Upload SMF to the Server This step is too long so be patient , log in to Trap17 forum then log in
    to your own cPanel , click on File Manager. A pop up Explorer will appear , then click on ...
  18. Fantastico Scripts - A 'how To' - (0)
    This isnt really a tutorial, more like an idiots guide on how to avoid the problems I encountered
    when setting up my site. This eventually invoved 3 complete reinstalls - you soon learn from your
    mistakes when that happens. I shall use php-nuke as the example here, but it applies to all scripts
    you intend to modify. If you have the disk space available - install your script twice, set up a
    temporary sub-domain for this. The reason for this is you have a full, clean install to go back &
    retrieve any files you may mess up whilst changing code (you will have to do this ...
  19. How To Install An Openoffice Dictionary Manually - adding the new dictionary by yourself (3)
    How To Install An OpenOffice Dictionary Manually Introduction The Tutorial
    What's OpenOffice? Introduction Before you all rant at me and tell me that there is a
    wizard to install dictionaries for you, it can sometimes not work. I know this because on my copy of
    OpenOffice Writer, it doesn't. This tutorial is very easy to follow and it's for those
    whose wizard is broking, just like mine or people who like to be difficult and do things the hard
    way /tongue.gif" style="vertical-align:middle" emoid=":P" border="0" alt="tongue.gif" />...
  20. How To Install S9y Weblog Software - (0)
    Right , here's my guide at how to install S9Y ( www.s9y.org ) 1. Download the version of S9Y
    you want from the website above 2. Extract the rar file 3.Upload all the files to a Web host 4.
    Go to you domain/subdomain , also at this point make sure all the files are CHMOD 775 5. S9Y's
    Installer should start and give you an overview of you system's setup 6. Make sure there is
    nothing in red and click Simple Install 7. Fill in all the spaces , with you Database name ,
    Password , etc ... From here on S9Y is very easy to set-up ! Just use it as you ...
  21. Mysql Database Setup - tutorial walk through (1)
    Post copied. Google cache to source Credits have been adjusted. Setting Up Your MySQL &
    phpMyAdmin For The First Time This tutorial will show you how to set up your MySQL and your
    phpMyAdmin with ease, regardless of whether you are going to be using PHP Nuke or PHP Nuke
    Platinum. The process is still the same. -Log into your CPanel with your User Name and Password.
    -Click on MySQL icon -Now, we need to create a database also known as Db , Your User Name will
    make up part of the necessary details, but you don't need to do this as it will be done au...
  22. How To Install Winxp And Linux To The Same Compute - a double boot (12)
    when I install a double boot linux/winxp, I always want to keep the Windows boot menu to choose the
    operating symtem. This is what I usually do: -Install Winxp -Install linux (if you dont have space
    to create a new partition for linux, you have to use partition magic to reduce the size of the WinXP
    partition and leave some space to create the partition for linux. You can create the partition
    during the linux setup. - During the linux setup, choose to install the boot manager (lilo or grub)
    in the boot sector of the partition where you are installing linux (not in the MB...
  23. Install New Fonts - on Windows XP / 98 (5)
    Having a great arsenal of fonts is a must in web design. If you have a personal web page, having
    unique fonts on your site will set your site apart from all the other personal web sites out there.
    Downloading new fonts is simple. Browse Google for some sites that have free fonts. To download
    the font, click the appropriate system type (usually pc or mac) that you'll have the font on.
    Fonts normally come compressed as either .zip or .rar . Extract the fonts to a directory on your
    desktop named "New Fonts." Note : Supported font types for Windows are .ttf, .f...



Looking for install, scripts, create, database, preinstalled, scripts, scripts

Searching Video's for install, scripts, create, database, preinstalled, scripts, scripts
See Also,
advertisement


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

Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com