This is strictly a copy-and-paste code section. Questions may be welcome!?!
So here we are going to be looking at some php copy and paste codes - few explanations where necessary.

We are going to dealing with code snippets, functions and maybe classes when necessary.


First code snippet will be dual php/mysql connector - this is a code that allows you to setup both your internet and local server config once so that if you upload you will not need to start creating new users account, especially if your local server and web server config settings are different,

Posts shall be continued later - i will have to search my archives for that code - the simple version that is.

dual.config.php

<?php
############### config start ##################

//Internet server config
$webserver="mysite.com";
$web_username="cpanel_user";
$web_password="cpanel_pass";

//Local server config
$localserver="localhost";
$local_username="toni";
$local_password="laser";

//general config
$dbase_name_1="site_dbase";
$dbase_name_2="site_dbase2";

############### config stop ##################

###local server_name => 127.0.0.1,localhost or computername
function sonline() {if ($_SERVER['SERVER_NAME']=="localhost"||$_SERVER['SERVER_NAME']=="127.0.0.1"||strtolower($_SERVER['SERVER_NAME'])==strtolower(getenv('COMPUTERNAME'))) {return false;} else {return true;}}

if(sonline()) {
 $server="$webserver";
 $admin_user="$web_username";
 $admin_pass="$web_password";
 $dbname=$web_username.'_'.$dbase_name_1;
 $dbname2=$web_username.'_'.$dbase_name_2;

 //internet ftp setup
 $ftp_server="$webserver";
 $ftp_user_name="$admin_user";
 $ftp_user_pass="$admin_pass";

} else {
 //iis ftp setup
 $ftp_server="localhost";
 $ftp_user_name="Anonymous";
 $ftp_user_pass="";

 $server="$localserver";
 $admin_user="$local_username";
 $admin_pass="$local_password";
 $dbname="$dbase_name_1";
 $dbname2="$dbase_name_2";
}

?>

dual.connect.php

<?php
include_once 'dual.config.php';
$link = mysql_connect('localhost', $admin_user, $admin_pass);
if (!$link) {die('Could not connect to mysql server. Check your account settings! ' . mysql_error());}
if(!isset($dbname)) {die("No dbname specified in your server config, ";}
mysql_select_db($dbname,$link) or die ("Could not select database '$dbname'.";
?>