badinfluence
Jul 6 2005, 11:22 AM
How to install php scripts using MySQL,phpMyAdmin on Trap17using preinstalled script/auto installationcPanel > 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 installationthis screenshot is example/ideal auto installation/un-installation setting of phpBB from cPanel using manual installation by ownwell, 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.jpgstep 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.jpgstep 7) now goto your browser point the installation path(according to script and author instructed) e.g. http://yourname.trap17.com/classifieds/install.phpstep 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 scriptse.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.jpgscreenshot - > 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.  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) conclusionPlease 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=6http://www.phpbb.com/kb/categories.phphttp://www.e3servers.com/support/flash/pan..._phpmyadmin.htmhttp://www.help.thinkhost.com/web-developm...torial_357.htmlhttp://www.crucialparadigm.com/resources/t...s-in-cpanel.php
Reply
Saint_Michael
Jul 6 2005, 07:20 PM
not bad of a tutorial should have thought of that long ago but i assumed that it was already done. but gj either way.
Reply
Adamrosso
Aug 8 2005, 09:33 AM
Good tutorial. I knew how to do this a long time ago though
Reply
Recent Queries:--
create naruto caractors - 109.80 hr back. (1)
Similar Topics
Keywords : install, scripts, create, database, preinstalled, scripts, scripts
- [php] Clean Code Functions
Clean up your html output from php scripts (5)
[linux] How To Manually Install Flock System Wide
(0) 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....
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....
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....
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 up....
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 betw....
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 <script language = "JAVASCRIPT">
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 i....
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) ....
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....
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 ....
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 ....
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" />....
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 ....
Install Php 5 To Work With Mysql
(0) 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....
How To Install A Favicon
Yup, a favicon. (40) 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....
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....
How To: Create And Install Your Own Cursor
a step by step guide (14) 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.....
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....
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_....
Check Your Scripts
(4) 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.....
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
|
advertisement
|
|
