stdpass != "") && ($this->stduser != "") && ($this->server != "")) {
$link = @mysql_connect($this->server, $this->stduser, $this->stdpass) or $this->DBDie( "Connection DB error, Please check again!
");
}
mysql_query("SET NAMES 'utf8'");
mysql_select_db($this->db);
$rs = mysql_db_query($this->db, $SQL) or $this->DBDie("Connection DB error, Please check again!
");
return $rs;//
if (($this->stdpass != "") && ($this->stduser != "") && ($this->server != "")) {
$this->DBClose($link);
}
}
function Execute($SQL) {
if (($this->stdpass != "") && ($this->stduser != "") && ($this->server != "")) {
$link = @mysql_connect($this->server, $this->stduser, $this->stdpass) or $this->DBDie("Connection DB error, Please check again!
");
}
mysql_query("SET NAMES 'utf8'");
mysql_select_db($this->db);
mysql_query("SET NAMES 'utf8'");
$rs = mysql_db_query($this->db, $SQL) or $this->DBDie("
DB name or SQL command error!
");
return mysql_insert_id();
if (($this->stdpass != "") && ($this->stduser != "") && ($this->server != "")) {
$this->DBClose($link);
}
}
function drop_category($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where CM_ID = '".$myID."' order by CM_Order ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by CM_Order ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function dropm_category($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where MCM_ID = '".$myID."' order by MCM_Order ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by MCM_Order ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function drop_brand_m_category($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where MCM_ID = '".$myID."' order by MCM_Order ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by MCM_Order ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function drop_news($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where NT_ID = '".$myID."' order by NT_Date DESC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by NT_Date DESC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function drop_area($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where NT_ID = '".$myID."' order by NT_Order asc");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by NT_Order asc");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function drop_faq($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where CM_ID = '".$myID."' order by CM_Order ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by CM_Order ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function drop_qa($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where CM_ID = '".$myID."' order by CM_Order ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by CM_Order ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function RecordCount($rs) {
if (!$rs) {return $this->DBDie("No connection flag!
");exit;}
return mysql_num_rows($rs) ;
}
function GetRows($rs) {
if (!$rs) {return $this->DBDie("No connection flag!
");exit;}
$arr = array();
$counter = 0;
while ($row = mysql_fetch_array($rs)) {
$arr[$counter] = $row;
$counter++;
}
return $arr;
}
function GetRows_Index($rs) {
if (!$rs) {return $this->DBDie("No connection flag!
");exit;}
$arr = array();
while ($row = mysql_fetch_array($rs)) {
$arr[$row[0]] = $row[1];
}
return $arr;
}
function GetString($rs, $col, $row) {
$return_str = "";
while($thisRow = mysql_fetch_row($rs)) {
$return_str .= join($col, $thisRow).$row;
}
return $return_str;
}
function GetFieldCount($rs) {
if (!$rs) {return $this->DBDie("No connection flag!
");exit;}
return mysql_num_fields($rs);
}
function DBClose($link) {
mysql_close($link);
}
function DBDie($error) {
echo $error;exit;
}
function GetExist($myTB,$LimCol,$GID)
{
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where ".$LimCol." = '$GID'");
$AllNum = $this->RecordCount($rs);
if($AllNum > 0){
return 1;
}else{
return 0;
}
}
function GetColName($myCol,$myTB,$LimCol,$UID)
{
$rs = $this->Recordset("SELECT ".$myCol." FROM ".$myTB." Where ".$LimCol." = '".$UID."'");
$ary = $this->GetRows($rs);
$Name = $ary[0]["$myCol"];
return $Name;
}
function GetColName_ptnew($myCol,$myTB,$LimCol,$UID,$LimCol2,$UID2)
{
$rs = $this->Recordset("SELECT ".$myCol." FROM ".$myTB." Where ".$LimCol." = '".$UID."' AND ".$LimCol2."= '".$UID2."' ");
$ary = $this->GetRows($rs);
$Name = $ary[0]["$myCol"];
return $Name;
}
function GetColNamebySort($myCol,$myTB,$LimCol,$UID,$odr,$ud)
{
$rs = $this->Recordset("SELECT ".$myCol." FROM ".$myTB." Where ".$LimCol." = '".$UID."' order by ".$odr." ".$ud );
$ary = $this->GetRows($rs);
$Name = $ary[0]["$myCol"];
return $Name;
}
function GetCount($myTB,$LimCol,$GID)
{
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where ".$LimCol." = '$GID'");
$AllNum = $this->RecordCount($rs);
return $AllNum;
}
function GetMaxID($myCol,$myTB,$N)
{
$day = date("Ymd");
$rs = $this->Recordset("SELECT max(".$myCol.") as ID FROM ".$myTB." Where SUBSTRING(".$myCol.",1,8) = '".$day."'");
$ary = $this->GetRows($rs);
if($ary[0]["ID"]!=NULL){
$num = substr($ary[0]["ID"],8,$N);
$num = (int)$num +1;
$num = str_pad($num,$N,0,STR_PAD_LEFT);
$ID=$day.$num;
}else{
$ID=$day;
for($i=1;$i<$N;$i++)
{
$ID.="0";
}
$ID.="1";
}
return $ID;
}
function drop_dpwnload($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where Sno = '".$myID."' order by Sort ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by Sort ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function dropm_dpwnload($myVal,$myCol,$myTB,$myID,$mySelected){
if($myID!=NULL){
$rs = $this->Recordset("SELECT * FROM ".$myTB." Where Sno = '".$myID."' order by Sort ASC");
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by Sort ASC");
}
$ary = $this->GetRows($rs);
$myStr = "";
for ($i=0;$i<$this->RecordCount($rs);$i++){
$selected=($ary[$i][$myVal]==$mySelected)?"selected":"";
$myStr .= "";
}
return $myStr;
}
function GetMaxID_Media($myCol,$myTB,$N,$Distinguish)
{
$day = date("Ymd");
$rs = $this->Recordset("SELECT max(".$myCol.") as ID FROM ".$myTB." Where SUBSTRING(".$myCol.",1,8) = '".$day."' AND ".$Distinguish);
$ary = $this->GetRows($rs);
if($ary[0]["ID"]!=NULL){
$num = substr($ary[0]["ID"],8,$N);
$num = (int)$num +1;
$num = str_pad($num,$N,0,STR_PAD_LEFT);
$ID=$day.$num;
}else{
$ID=$day;
for($i=1;$i<$N;$i++)
{
$ID.="0";
}
$ID.="1";
}
return $ID;
}
// $getID=$_GET[XX]
function get_first($getID,$myVal,$myTB,$ord){
if($getID != ""){
$first = $getID;
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." order by ".$ord." ASC");
$row = $this->GetRows($rs);
$first = $row[0]["$myVal"];
}
return $first;
}
// $getID=$_GET[XX]
function get_first_hidden($getID,$myVal,$myTB,$hid,$hidVal,$ord){
if($getID != ""){
$first = $getID;
}else{
$rs = $this->Recordset("SELECT * FROM ".$myTB." where ".$hid."='".$hidVal."' order by ".$ord." ");
$row = $this->GetRows($rs);
$first = $row[0]["$myVal"];
}
return $first;
}
}
?>