กระทู้รณรงค์ ตอน "มาเขียน php แบบ OOP กันเถอะ" คือผมก็เห็นว่า community ที่นี่มีคนเก่งเยอะ

<?php
interface DBConnect{
	public static function defaultConnect();
	public static function connect();
}


class MySQLConnect implements DBConnect{
    const DEF_HOST = 'localhost';
    const DEF_USER = 'root';
    const DEF_PASSWORD = '';
    const DEF_DB = 'dbhanler';
     
    public static function defaultConnect(){
        return self::connect(self::DEF_HOST, self::DEF_USER, self::DEF_PASSWORD, self::DEF_DB);
    }
     
    public static function connect($host, $user, $pass, $db_name, $pconnect = false){
        global $conn;
         
        if($pconnect)
            $conn = mysql_pconnect($host, $user, $pass);
        else
            $conn = mysql_connect($host, $user, $pass);
         
        if(!$conn) exit( mysql_error() );
         
        if( !mysql_select_db($db_name, $conn) ) exit('Cannot select database.');
        mysql_query("SET NAMES UTF8");
         
        return $conn;
    }
}//DBHandler class
?>

<?php
interface DBConnect{
	public static function defaultConnect();
	public static function connect($host, $user, $pass, $db_name, $pconnect = false);
}


class MySQLConnect implements DBConnect{
    const DEF_HOST = 'localhost';
    const DEF_USER = 'root';
    const DEF_PASSWORD = '';
    const DEF_DB = 'dbhanler';
     
    public static function defaultConnect(){
        return self::connect(self::DEF_HOST, self::DEF_USER, self::DEF_PASSWORD, self::DEF_DB);
    }
     
    public static function connect($host, $user, $pass, $db_name, $pconnect = false){
        global $conn;
         
        if($pconnect)
            $conn = mysql_pconnect($host, $user, $pass);
        else
            $conn = mysql_connect($host, $user, $pass);
         
        if(!$conn) exit( mysql_error() );
         
        if( !mysql_select_db($db_name, $conn) ) exit('Cannot select database.');
        mysql_query("SET NAMES UTF8");
         
        return $conn;
    }
}//DBHandler class
?>

<?php
// Copy from php manual ^^!
class Foo
{
   public static $my_static = 'foo';

   public function staticValue() {
       return self::$my_static;
   }
}

class Bar extends Foo
{
   public function fooStatic() {
       return parent::$my_static;
   }
}


print Foo::$my_static . "\n";

$foo = new Foo();
print $foo->staticValue() . "\n";
print $foo->my_static . "\n";      // Undefined "Property" my_static 

print $foo::$my_static . "\n"; // ตามที่เข้าใจ น่าจะบรรทัดนี้ ว่า ไม่ควร
$classname = 'Foo';
print $classname::$my_static . "\n"; // หรือว่าจะ บรรทัดนี้

print Bar::$my_static . "\n";
$bar = new Bar();
print $bar->fooStatic() . "\n";
?>

<?
class db
{
	public function query ($cmd)
	{
		return @mysql_query ($cmd);
	}
	
	public function fetch ($cmd)
	{
		return @mysql_fetch_array ($cmd);
	}
	
	public function num ($cmd)
	{
		return @mysql_num_rows (self::query ($cmd) );
	}
	
	public function quickfetch ($cmd)
	{
		return self::fetch ( self::query ($cmd) );	
	}
	
	public function connect ()
	{
		global $data;
		$connect = @mysql_connect ($data['host'], $data['user'], $data['pass']);
		@mysql_select_db ($data['db']);
		return $connect;
	}
	
	public function close ($con = "")
	{
		@mysql_close ($con);
	}
}
?>

<?php

/**
 * Enter description here...
 *
 */
class test {
	/**
	 * Enter description here...
	 *
	 * @param string $d (1-31)
	 * @param string $m (1-12)
	 * @param string $y
	 * @return integer
	 */
	public function getWeek($d = '', $m = '', $y = '')
	{
	    $day     =     date('j');
	    $month     =    date('n');
	    $year     =     date('Y');
	    
	    if ( is_numeric($d) && $d > 0 ) $day     = $d;
	    if ( is_numeric($m) && $m > 0 ) $month     = $m;
	    if ( is_numeric($y) && $y > 0 ) $year     = $y;
	    
	    $firstWeek         =     date('w', mktime( 0, 0, 0, $month, 1, $year));
	    
	    return ceil( ( $day + $firstWeek )  / 7 );
	}
}

?>

<?php
interface DBConnect{
	public static function connect($host ='', $user ='', $pass ='', $db_name ='', $flag ='');
	public static function endConnection();
}
?>

<?php
class MySQLConnect implements DBConnect{
    const DEF_HOST = 'localhost';
    const DEF_USER = 'root';
    const DEF_PASSWORD = '';
    const DEF_DB = 'mysql';
     
	 //@implement inteface DBConnect::connect()
    public static function connect($host = self::DEF_HOST, $user = self::DEF_USER, $pass = self::DEF_PASSWORD, $db_name = self::DEF_DB, $flag = false){
        global $conn;
         
        if($flag)
            $conn = mysql_pconnect($host, $user, $pass); // persistent connection
        else
            $conn = mysql_connect($host, $user, $pass);
         
        if(!$conn) exit( mysql_error() );
         
        if( !mysql_select_db($db_name, $conn) ) exit('Cannot select database.');
        mysql_query("SET NAMES UTF8");
         
        return $conn;
    }
	
	//@implement interface DBConnect::endConnection()
	public static function endConnection(){
		return mysql_close($conn);
	}
}//MySQLConnect class
?>

<?php
// ไม่เคยใช้ oracle แต่ลองมั่วๆ ตามแมนน่วนดู ไม่รู้ว่าจะทำงานป่าว
class OracleConnect implements DBConnect{
	const DEF_USER = 'root';
    const DEF_PASSWORD = '';
    const DEF_DB = 'oracle';
	
	//@implement interface DBConnect::connect()
	public static function connect($host='', $user = self::DEF_USER, $pass = self::DEF_PASSWORD, $db_name = self::DEF_DB, $flag = ''){
		global $conn;
		
		if($flag) //if 1
			if( is_array($flag) ){//if 2
				foreach($flag as $key=>$val)
					$$key = $val;
				
				if($charset && $session_mode)
					$conn = ocilogon($user, $pass, $db_name, constant($charset), constant($session_mode));
				else if($charset)
					$conn = ocilogon($user, $pass, $db_name, constant($charset));
				else if($session_mode)
					$conn = ocilogon($user, $pass, $db_name, NLS_LANG, constant($session_mode));
				else
					exit('พารามิเตอร์ไม่ถูกต้อง'); // หรือ trow Exception
			}else{ // if 2
				$conn = ocilogon($user, $pass, $db_name, constant($flag));
			}
		else //if 1
			$conn = ocilogon($user, $pass, $db_name);
			
		if(!$conn) exit('Error: connect to oracle.');
		
		return $conn;
	}
	
	//@implement interface DBConnect::endConnect()
	public static function endConnection(){
		return oci_close($conn);
	}
}//end OracleConnect
?>

<?php
//คลาสโรงาน ^^
class DBConnectFactory{
	//to establish default connection
	public static function createDefaultConnection($db_type ='MySQL'){
		switch($db_type){
			case 'MySQL':
				return MySQLConnect::connect();
				break;
			case 'Oracle':
				return OracleConnect::connect();
				break;
			default:
				exit("Sory No Connection to '$db_type' database");
		}
	}
	
	//to establish user connection
	public static function createConnection($db_type = 'MySQL', $host='', $user ='', $pass ='', $db_name ='', $flag =''){
		switch($db_type){
			case 'MySQL':
				return MySQLConnect::connect($host, $user, $pass, $db_name, $flag);
				break;
			case 'Oracle':
				return OracleConnect::connect($host, $user, $pass, $db_name, $flag);
				break;
			default:
				exit("Sory No Connection to '$db_type' database");
		}
	}
}// DbConnectFactory class
?>

<?php

class test {
	public static function functionStatic(){
		
	}
}
test::functionStatic();

?>

<?php

class test {
	public function functionNonStatic(){
		
	}
}
$test = new test();
$test->functionNonStatic();

?>

<?php

class test {
	public function functionNonStatic(){
		
	}
}
// แบบ initiate object ก่อน
$test = new test();
$test->functionNonStatic();

// แบบ static
test::functionNonStatic();

?>

<?php

class test {
	public static function functionNonStatic(){
		
	}
}
// แบบ initiate object ก่อน
$test = new test();
$test->functionNonStatic();

// แบบ static
test::functionNonStatic();

?>

<?php
$conn = DBConnectFactory::createConnection("MySQL", "localhost", "root", "mysql", "db_test1");
//หรือ
$conn = DBConnectFactory::createConnection("Oracle", "localhost", "root", "mysql", "db_test1");
?>

<?php
class Test{
	protected static $abc = 0;
	
	public function __construct(){
		self::$abc++;
	}
	
	public function getABC(){
		return self::$abc;
	}
}

echo '<br><br>';
$t = new Test();
echo $t->getABC(), '<br><br>';

$t2 = new Test();
echo $t->getABC();

//echo TEST::$abc; //เรียกไม่ได้เพราะเป็น protected
?>

<?php
class a{
private $a;
function __construct () {
self::$a = 1;
}
}
?>

<?php
class a{
private $a;
self::$a = 1;
?>