Knowledgebase

Portal Home > Knowledgebase > Hosting > HTML, PHP, MySQL...

The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.

Search

Articles

Article Deleting tables from a database - Flash Tutorial
Learn how to delete tables from a database by watching this flash tutorial...
Views: 9
Article Configuring the PHP environment With php.ini
The servers use a master php.ini file for all directories without a php.ini file in it. You will...
Views: 9
Article Connecting to MySQL through PHP
Use the following outline to connect and begin querying the MySQL server from within your PHP...
Views: 12
Article Copying a database table - Flash Tutorial
The flash tutorial below shows you how to copy a dabtabase table...
Views: 10
Article Creating a database user through the MySQL console
Through the mysql command line, this is accomplished by running the following commands. In SSH,...
Views: 9
Article Database Hosting and Automation
In order to accomplish automation of your sales and service process, a database is generally...
Views: 7
Article Deleting fields from database tables - Flash Tutorial
Learn how to delete fields from databse tables by following this flash tutorial....
Views: 17
Article Emails not sending out with correct character set
This is a known issue with our servers. We are working to resolve this. In the meantime, you can...
Views: 9
Article FastCGI for PHP
FastCGI for PHP makes all your PHP applications run through mod_fastcgi instead of...
Views: 14
Article Fsockopen is not working.
Fsockopen does work for connecting to any url that is on port 80. If it is using another port it...
Views: 11
Article How can I execute php code as .htm or .html files
In your .htaccess file insert this line of code. AddType application/x-httpd-php .html .htm .php...
Views: 12
Article How do I create a MySQL user and grant them permission to a certain database?
In Telnet/Shell type: "mysql" This will load the mysql command line. Next type: GRANT ALL...
Views: 7
Article How do I disallow guests or anonymous users from adding comments to my Picture Pro photo gallery?
To disallow guests or anonymous users from adding comments to my Picture Pro photo gallery,...
Views: 11
Article How do I enable pdo_mysql?
First see whether pdo_mysql.so is already installed on your server...$ ls...
Views: 10
Article How do I find paths?
Finding a path to an application is very simple, just follow the below instructions and that will...
Views: 7
Article How do I import a Database(PhpMyAdmin)
) Once you have your sql file you will need to log into your CPanel 2) In the CPanel you will...
Views: 7
Article How do I install ioncube?
IonCube is already installed on the server your hosting account is on. To get your scripts to use...
Views: 8
Article How do I install SourceGuardian?
SourceGuardian is already installed on the server your hosting account is on. To get your scripts...
Views: 10
Article How do I stream RealMedia audio/video files?
HTTP streaming is a method of serving RealMedia audio and video files on the Internet without the...
Views: 12
Article How do I switch between PHP4 and PHP5?
1. Login into the Netfirms Members Control Panel 2. Click Site Tools3. From the Advanced section...
Views: 24
Article How do I tell if my account is using a localhost or a remote mysql host?
To see if your account is using localhost or remotemysql host: In cpanel 10 click on the...
Views: 8
Article How do I turn off register_globals?
To turn register_globals OFF follow these steps:1. Using a text editor (eg. Notepad) or File...
Views: 12
Article How do I use .html files to run SSI (Server Side Includes)?
Apache Handlers This is what you would use to specify how to treat file types. By default, .html...
Views: 6
Article How do I use Real Audio or Video?
You can use RealAudio/Video on your web site by using HTTP Streaming. In order to use http...
Views: 14
Article How do I view the php information page?
Create a page name phpinfo.php and insert the below code into it. Pull this page up in your...
Views: 9
Article How to change the collation for all tables in a MySQL database to UTF8?
Changing the collation for all tables in a MySQL database can be time consuming depending on how...
Views: 8
Article How to change the MySQL timezone
When you develop your website, you may have to compare a certain date/time with the current...
Views: 9
Article How to reset your password for Advanced Guestbook.
To retrive the guestbook password select the guest book db in PHPMyAdmin and the table book_auth....
Views: 170
Article How to use meta tags.
Meta Tags: * Meta tags are included in the html, between the and at the top of the document * It...
Views: 6
Article I can't log into MySQL from a remote computer using a MySQL admin tool(phpMyAdmin, Navicat, MySQLFront, MySQL-Admin, etc).
How to add yourself to the whitelist so that you can connect to mysql remotely.1. Log into your...
Views: 10
Article I would like to dump the Table Structure for my MySQL
The command line option from SSH is:mysql -d -p database_name > file.sqlWhere "database_name"...
Views: 9
Article I would like to dump the Table Structure for my MySQL Database, but none of the data.
The command line option from SSH is:mysql -d -p database_name > file.sqlWhere "database_name"...
Views: 8
Article Importing databases and tables - Flash Tutorial
Learn how to importa databases and tables by watching this flash tutorial...
Views: 8
Article Inserting fields into database tables - Flash Tutorial
Learn how to insert different fields into database tables by following instructions in this flash...
Views: 8
Article Limiting what search engines can index using /robots.txt
Various search engines such as Google have what are called "spiders" or "robots" continually...
Views: 6
Article Modifying fields in database tables - Flash Tutorial
Learn how to modify different fields in databse tables by following this flash tutorial...
Views: 12
Article Mysql database and user naming syntax
Since we run a shared hosting environment, we have to uniquely identify your usernames to your...
Views: 8
Article PHP Framework - PHP Cake
Cake is a rapid development framework for PHP which uses commonly known design patterns like...
Views: 14
Article PHP script for MySQL database import
You should start by creating a file called for example import.php and placing it in your...
Views: 8
Article Problem with old host and new host, my database still is looking at the old host.
When importing an old database from another host you must go through a multi-step process or it...
Views: 8
Article Protecting the php.ini file from being viewed
To prevent people to viewing your php.ini file via a browser a few lines need to be pasted into...
Views: 7
Article Renaming database tables - Flash Tutorials
Watch this flash tutorial to learn on how to rename a database table...
Views: 11
Article Running SQL queries on a database - Flash Tutorial
Check out how you can run multiple SQL qureries on a database by watching this flash tutorial...
Views: 7
Article Searching through a database - Flash Tutorial
Learn how to search through a database by watching this flash tutorial...
Views: 9
Article The problem here is one of cAsE sEnSiTiViTy. UNIX is fussy about the use of UPPER/lower case and will recognize Index.htm and index.htm as referring to two distinctly different files. If the Index.htm file is renamed to index.htm using all lower case and is uploaded to the public_html directory it will automatically be displayed as the site's index page. As far as all other documents while you can use upper and lower case at your descretion you MUST make sure that you the file names referenced in your image tags and hyperlinks match the names of the files you have uploaded (including upper/lower case) at all times. Just to simplify matters the best course of action is often to just use all lower case characters exclusively both in your HTML and when naming and uploading your files (and avoid long file names with spaces as well) however the key is consistancy...if you name a file MyFile.htm you must make sure to call it MyFile.htm in your A HREF tag (likewize for image tags) as MyFile.htm, myfile.htm, myfile.HTM etc will all be considered to be separate files and a call to one will not retrieve another.
The problem here is one of cAsE sEnSiTiViTy. UNIX is fussy about the use of UPPER/lower case and...
Views: 3
Article To retrive the guestbook password select the guest book db in PHPMyAdmin and the table book_auth. While browsing it will show you the user name. run this sql command to change the password at the SQL query box in PHPMyAdmin update book_auth set password=PASSWORD('pass') where username='user'; where 'pass' is your password and 'user' is the user name.
Log into your cpanel account and click on "MySQL Databases" then under "Users" create a new user...
Views: 7
Article Troubleshooting
Here are a few initial things (common mistakes) to take a look at: - Make sure that after you...
Views: 5
Article Understanding CGI Basics
What Is CGI and how is it going to help me? CGI is translated as Common Gateway Interface. It's...
Views: 7
Article What are the Basic Connection Settings for MySQL?
There are two different ways to connect to a MySQL database. Locally (from a script on the...
Views: 9
Article What do the different HTTP Status Codes like 200, 304, 404, 401, 403 mean?
Informational 1xx 100 Continue101 Switching ProtocolsSuccessful 2xx 200 OK201 Created202...
Views: 9
Article What Is CGI and how is it going to help me? CGI is translated as Common Gateway Interface. It's used to provide interactivity and turn static pages into dynamic ones. What do I mean? Let's take a guestbook for example. Most of them are powered by CGI. They allow your visitors to leave their comments on your site. This makes it interactive. But guestbook is only one example. You also have bulletin boards, form processing, counters, and much more. How am I supposed to install a script? Usually 95% of the scripts that I have tried before have complete instructions and a special ReadMe file with everything you need to know about installing that script. I recommend you reading the instructions a few times before starting to install the script. This will help you to make less mistakes. What does "chmod" mean? To chmod a file means to set a certain permission. Few of the most common chmod commands are 775 and 777. To chmod a certain file or a category using FTP client find something like "Change File Attributes" and enter the chmod command script instructions tell you. If you are using Telnet, here are a few commands that you should use in order to chmod a file or a directory: u = the file's user (or owner) r = read access g = the file's group x = execute access o = others w = write access a = the user, the group, and others.
One of the most common errors is "500 Internal Error". The chances are that you will experience...
Views: 4
Article What is PHP?
Short for PHP: Hypertext Preprocessor, an open source, server-side, HTML embedded scripting...
Views: 10
Article What is the information_schema database?
In MySQL version 5.02 and above there is an additional database called information_schema. This...
Views: 10
Article What is the path to PERL (interpretator)?
The perl path is the very first line in every .cgi or .pl file. Usually it looks something like...
Views: 6
Article What is the path to Perl?
Perl v5.5.3 scripts should include the following line at the beginning of all perl...
Views: 10
Article Where can I find more information on PHP?
PHP is quickly becoming a very popular scripting language. More information on PHP can be found...
Views: 8
Article Why am I Getting File Not Found When Executing My CGI?
"File Not Found" or "No Such File or Directory" This is usually the result of CGI scripts being...
Views: 14
Article Why do I get a red (x) where my images are supposed to be?
Either the image was not uploaded and therefore does not exist on the server or your path to the...
Views: 12
Article Why is my site not listed in a top search engine?
Many search engines reserve the right to reject Web sites based on content or quality. Check your...
Views: 9

Quick Navigation

Client Login

Email

Password

Remember Me

Search