Web Hosting - Dedicated Servers
Dedicated Server Hosting
Web Hosting eCommerce Hosting Reseller Hosting Dedicated Server
Home arrow PHP and MySQL
PHP and MySQL

How to install your own Apache test server

Written by Website Tutorials   
Thursday, 02 October 2008

If you are a web developer building PHP/MySQL powered sites, the ultimate scenario is to test your applications before uploading them to the main web hosting server. A lot of developers set up test accounts on live web servers, however this means you always need to be connected to the web to test them. But there is another way using one of two ingenious applications that make setting up your own Apache/MySQL/PHP an absolute breeze.

Read more...
 

Backing up databases over SSH

Written by WebHosting Moderator   
Monday, 18 February 2008

Sometimes a MySQL database is simply too large to backup on a web based interface. In the event of this occurring, it is fairly easy to backup a database via SSH; all it takes is one command. This tutorial will show you how.

Read more...
 

Searching databases - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to search databases in phpmyadmin.

Read more...
 

Renaming tables - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to rename tables in phpmyadmin.

Read more...
 

Running SQL queries - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to run SQL queries in phpmyadmin.

Read more...
 

Modifying fields - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to modify fields in tables in phpmyadmin.

Read more...
 

Inserting fields - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to insert fields into tables in phpmyadmin.

Read more...
 

Importing databases and tables - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to import databases and tables in phpmyadmin.

Read more...
 

Becoming familiar with databases - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to become familiar with databases and phpmyadmin.

Read more...
 

Exporting databases and tables - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to expore databases and tables in phpmyadmin.

Read more...
 

Deleting tables - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to delete a table in phpmyadmin.

Read more...
 

Deleting fields - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to delete fields from a table in phpmyadmin.

Read more...
 

Creating tables - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to create a table in a database in phpmyadmin.

Read more...
 

Copying a database table - phpmyadmin

Written by WebHosting Moderator   
Tuesday, 29 January 2008

This video will show you how to copy a database table in phpmyadmin.

Read more...
 

Exporting and Importing MySQL data with phpMyAdmin

Written by Website Tutorials   
Friday, 28 September 2007

One question that comes up regularly is "How can I move my existing Joomla site to your servers?". This can be achieved relatively simply in 3 steps.
1. Upload your existing Joomla site files to your hosting account.
2. Export (or dump) your existing MySQL database, then create a new database and import the data.
3. Change your Joomla configuration settings.

This tutorial will focus on the process of exporting/importing the MySQL data.

Read more...
 

PHP 5 Advantages

Written by Website Tutorials   
Monday, 19 March 2007

PHP (PHP:Hypertext Preprocessor) was designed to create dynamic web pages, PHP's principal focus is server-side scripting. While running the PHP parser with a web server and web browser, the PHP model can be compared to other server-side scripting languages such as Microsoft's ASP.NET system, Sun Microsystems' JavaServer Pages, mod_perl and the Ruby on Rails framework, as they all provide dynamic content to the client from a web server.

Read more...
 

Security issues - allow_url_fopen

Written by Web Hosting Editor   
Monday, 05 March 2007
The PHP option allow_url_fopen would normally allow a programmer to open, include or otherwise use a remote file using a URL rather than a local file path. For security reasons, AUSWEB has disabled this feature; however, a feature-rich alternative exists in the form of the bundled cURL library
Read more...
 

How to upgrade the embedded phpBB forum within phpNuke

Written by Web Hosting Editor   
Tuesday, 03 October 2006

If you've recently installed phpNuke with Fantistico (it's at the bottom of your Control Panel - if you haven't seen it - go look), you may have noticed that the phpBB version is about 5 releases out of date.
The most recent version of phpBB is 2.0.21, but the version within the phpNuke 7.8 Release is 2.0.15. However, before you run out and download the standalone updates/patches for phpBB, please keep reading.

This is a special version of phpBB that is designed to run inside and with phpNuke, so DO NOT simply patch phpBB with the "official version" from phpbb.com. This WILL break some of the functionality of the embedded version. Your gonna have to do a little bit of work, but it'll be worth it. You will be required to download some files, unzip them, upload to your webspace, and then run 4 URLs from your browser.  Please note that this is a file-by-file update - and you cannot patch all in one fell swoop. It still will probably only take 10 minutes - and you'll have a much more secure version of phpBB.
Read more...
 

Banned PHP Scripts

Written by Website Tutorials   
Wednesday, 04 October 2006

The following scripts are banned due to these scripts causing harm to other sites on the same server.

- AlienForm (all versions)
- Greymatter (all versions)
- phpdig spider(all versions)
- Open Webmail
- Ikonboard (all versions)
- IRC Egg Drops & IRC related programs.(chat software)
- lstmrge.cgi
- Proxy Servers & Scripts (EX: nph-proxy)
- Shell, SSH, Telnet Scripts and Shell, SSH, Telnet Alternatives
- The Anonymizer
- UltimateBBS (all versions)
- Any script that uses & processes a massive number of flatfiles or large flatfile databases.

Read more...
 

PHP Tutorials and Guides

Written by Website Tutorials   
Wednesday, 04 October 2006

The official PHP site is http://www.php.net and the online documentation is found at http://www.php.net/manual

If you would rather follow a tutorial, then check out http://www.devshed.com (this covers PHP and others) or http://www.phpbuilder.com or just do a search on google for PHP Tutorials.

Especially look into how PHP integrates with MySQL so you can program database powered websites. If you are the type of person who likes to dive in the deepend, try downloading some basic scripts from http://www.hotscripts.com and/or http://php.resourceindex.com and start ripping apart the code to see what's being done.

 
 
 
RedHat Linux
cPanel Hosting
plesk windows
Fantastico SiteBuilder
 

AUSWEB Web Hosting PTY LTD © 2008 Network Info Data CenterPrivacy PolicySLA Terms and Conditions