001.<?php
002.class clear_db{
003. function my_sql_connect($host,$username,$password,$dbname){
004. $connect= mysql_connect($host, $username, $password,true) or die(mysql_error());
005. $db=mysql_select_db($dbname,$connect) or die(mysql_error());
006. return $db;
007. }
008. function my_sql_query($field,$table,$event){
009. if($field == NULL && $event == NULL){
010. $objQuery=mysql_query("SELECT * FROM ".$table);
011. }else if($field == NULL){
012. $objQuery=mysql_query("SELECT * FROM ".$table." WHERE ".$event);
013. }else if($event == NULL){
014. $objQuery=mysql_query("SELECT ".$field." FROM ".$table);
015. }else {
016. $objQuery=mysql_query("SELECT ".$field." FROM ".$table." WHERE ".$event);
017. }
018. $objShow=mysql_fetch_object($objQuery);
019. return $objShow;
020. }
021. function my_sql_select($field,$table,$event){
022. if($field == NULL && $event == NULL){
023. $objQuery=mysql_query("SELECT * FROM ".$table);
024. }else if($field == NULL){
025. $objQuery=mysql_query("SELECT * FROM ".$table." WHERE ".$event);
026. }else if($event == NULL){
027. $objQuery=mysql_query("SELECT ".$field." FROM ".$table);
028. }else {
029. $objQuery=mysql_query("SELECT ".$field." FROM ".$table." WHERE ".$event);
030. }
031. return $objQuery;
032. }
033. function my_sql_show_rows($table,$event){
034. if($event != NULL){
035. $objQuery=mysql_query("SELECT * FROM ".$table." WHERE ".$event);
036. }else{
037. $objQuery=mysql_query("SELECT * FROM ".$table);
038. }
039. $objShow=mysql_num_rows($objQuery);
040. return $objShow;
041. }
042. function my_sql_show_field($table,$event){
043. if($event != NULL){
044. $objQuery=mysql_query("SELECT * FROM ".$table." WHERE ".$event);
045. }else{
046. $objQuery=mysql_query("SELECT * FROM ".$table);
047. }
048. $objShow=mysql_num_field($objQuery);
049. return $objShow;
050. }
051. function my_sql_update($table,$set,$event){
052. if($event != NULL){
053. return mysql_query("UPDATE ".$table." SET ".$set." WHERE ".$event);
054. }else{
055. return mysql_query("UPDATE ".$table." SET ".$set);
056. }
057. }
058. function my_sql_insert($table,$set){
059. return mysql_query("INSERT INTO ".$table." SET ".$set);
060. }
061. function my_sql_delete($table,$event){
062. if($event != NULL){
063. return mysql_query("DELETE FROM ".$table." WHERE ".$event);
064. }else{
065. return mysql_query("DELETE FROM ".$table);
066. }
067. }
068. function my_sql_string($string){
069. return mysql_query($string);
070. }
071. function my_sql_set_utf8(){
072. $cs1 = "SET character_set_results=utf8";
073. mysql_query($cs1) or die('Error query: ' . mysql_error());
074. $cs2 = "SET character_set_client = utf8";
075. mysql_query($cs2) or die('Error query: ' . mysql_error());
076. $cs3 = "SET character_set_connection = utf8";
077. mysql_query($cs3) or die('Error query: ' . mysql_error());
078.
079. mysql_query("SET NAMES utf8");
080. mysql_query("SET CHARACTER SET utf8");
081. mysql_query("SET collation_connection='utf8_unicode_ci'");
082. mysql_query("SET character_set_results=utf8");
083. mysql_query("SET character_set_client='utf8'");
084. mysql_query("SET character_set_connection='utf8'");
085. mysql_query("collation_connection = utf8_unicode_ci");
086. mysql_query("collation_database = utf8_unicode_ci");
087. mysql_query("collation_server = utf8_unicode_ci");
088. }
089. function my_sql_set_tis620(){
090. $cs1 = "SET character_set_results=tis620";
091. mysql_query($cs1) or die('Error query: ' . mysql_error());
092. $cs2 = "SET character_set_client = tis620";
093. mysql_query($cs2) or die('Error query: ' . mysql_error());
094. $cs3 = "SET character_set_connection = tis620";
095. mysql_query($cs3) or die('Error query: ' . mysql_error());
096.
097. mysql_query("SET NAMES tis620");
098. mysql_query("SET CHARACTER SET tis620");
099. mysql_query("SET collation_connection='tis620_thai_ci'");
100. mysql_query("SET character_set_results=tis620");
101. mysql_query("SET character_set_client='tis620'");
102. mysql_query("SET character_set_connection='tis620'");
103. mysql_query("collation_connection = tis620_thai_ci");
104. mysql_query("collation_database = tis620_thai_ci");
105. mysql_query("collation_server = tis620_thai_ci");
106. }
107. function my_sql_close(){
108. return mysql_close();
109. }
110.}
111.?>
