Create a website in local language (unitext)

English is the international language as international communication.But in many other times, a developer needs to work with local languages where they are developing a website in PHP. So, what is the technique? Just use the class for to connect the database.

Code:

<?php
/**
 * Database Connection
 * @package MySql connection with php
 * @since 2013
 * @uses unitext
 * @author Md. Mahedi Azad
 */
class DBCofig {
	public $dbUserName = 'root'; //Database username
	public $dbUserPassword = 'root123'; //Database password
	public $dbName = 'unitext'; //Database name
	public $dbHostName = 'localhost'; //Host name
	
	private $link;
	
	public function __construct(){
		if(!$this->link = mysql_pconnect($this->dbHostName, $this->dbUserName, $this->dbUserPassword)){
			die('could not connect to the database');
		}
		mysql_select_db($this->dbName, $this->link);
		
		//For unitext data
		mysql_query('SET CHARACTER SET utf8');
		mysql_query("SET SESSION collation_connection= 'utf8_general_ci'");
		
		//mysql_query("SET character_set_results=utf8");
	}
	
	public function doQuery($query)
	{
		$result = mysql_query($query, $this->link);
		
		return $result;
	}
	
	public function fetchObject($result)
	{
		$row = mysql_fetch_object($result);

		return $row;
	}
	
	public function fetchArray($result)
	{
		$row = mysql_fetch_array($result);

		return $row;
	}
	
	public function numOfRows($result)
	{
		$numberOfRows = mysql_num_rows($result);

		return $numberOfRows;
	}
	
}
?>

Create a website in local language (unitext)

Sunday, February 10, 2013