PHP mysql_class::close方法代码示例

 public function loadByName($name)
 {
     if (trim($name) != '') {
         $name = trim($name);
         $mysql = new mysql_class();
         $ln1 = $mysql->ex_sqlx("insert into shahr_tmp (name) values ('{$name}') ", FALSE);
         $tmp_id = $mysql->insert_id($ln1);
         $mysql->close($ln1);
         $mysql->ex_sql("select name from shahr_tmp where id = {$tmp_id}", $q1);
         if (isset($q1[0])) {
             $name = $q1[0]['name'];
         }
         $mysql->ex_sqlx("delete from shahr_tmp where id = {$tmp_id}");
         $mysql->ex_sql("select * from shahr where name='{$name}'", $q);
         if (isset($q[0])) {
             $r = $q[0];
             $this->id = $q[0]['id'];
             $this->name = $q[0]["name"];
             $this->en_name = $q[0]["en_name"];
         } else {
             $ln = $mysql->ex_sqlx("insert into shahr (name) values ('{$name}') ", FALSE);
             $this->id = $mysql->insert_id($ln);
             $this->name = $name;
             $mysql->close($ln);
         }
     }
 }

 public function add($tableName, $data, $query)
 {
     if ($tableName != '') {
         $createTime = date("Y-m-d H:i:s");
         $mysql = new mysql_class();
         $thisId = -1;
         $mysql->enableCache = FALSE;
         $mysql->directQuery("select `id` from `cache` where `tableName` = '{$tableName}' and `query` = '{$query}' ", $q);
         if ($r = $mysql->fetch_array($q)) {
             $thisId = $r['id'];
         }
         if ($thisId > 0) {
             $mysql->directQueryx("update  `cache` set `data` = '" . serialize($data) . "' where `id` = '{$thisId}'");
         } else {
             $ln = $mysql->ex_sqlx("insert into `cache` (`tableName`,`data`,`createTime`,`query`) values('{$tableName}','" . serialize($data) . "','{$createTime}','{$query}') ", FALSE);
             $thisId = (int) $mysql->insert_id($ln);
             $mysql->close($ln);
         }
         $this->id = $thisId;
         $this->tableName = $tableName;
         $this->data = $data;
         $this->query = $query;
         $this->createTime = $createTime;
         $this->viewCount = 1;
     }
     return $this->id;
 }

 public function add($sanad_record_id, $tarikh, $mablagh, $log_text)
 {
     $out = -1;
     $mysql = new mysql_class();
     $sql = "insert into `pardakht` (`sanad_record_id`,`tarikh`,`mablagh`,`log_text`) values ('{$sanad_record_id}','{$tarikh}',{$mablagh},'{$log_text}')";
     $conn = $mysql->ex_sqlx($sql, FALSE);
     $out = $mysql->insert_id($conn);
     $mysql->close($conn);
     return $out;
 }

 public function add()
 {
     $out = -1;
     $my = new mysql_class();
     $my->ex_sql("select id from `parvaz` where `shomare` = '" . $this->shomare . "'", $q);
     if (isset($q[0])) {
         $out = (int) $q[0]['id'];
     } else {
         $ln = $my->ex_sqlx("insert into parvaz (`shomare`, `name`, `sherkat_id`, `mabda_id`, `maghsad_id`, `havapiema_id`, `ghimat_def`, `zarfiat_def`, `saat_def`, `saat_kh_def`, `poor_def`, `typ_def`, `mablagh_kharid_def`, `customer_id_det`, `rang`, `is_shenavar`, `ghimat_ticket`) values ('" . $this->shomare . "','" . $this->name . "','" . $this->sherkat_id . "','" . $this->mabda_id . "','" . $this->maghsad_id . "','" . $this->havapiema_id . "','" . $this->ghimat_def . "','" . $this->zarfiat_def . "','" . $this->saat_def . "','" . $this->saat_kh_def . "','" . $this->poor_def . "','" . $this->typ_def . "','" . $this->mablagh_kharid_def . "','" . $this->customer_id_det . "','" . $this->rang . "','" . $this->is_shenavar . "','" . $this->ghimat_ticket . "')", FALSE);
         $out = $my->insert_id($ln);
         $my->close($ln);
     }
     return $out;
 }

 public function loadByName($name = '')
 {
     if (trim($name) != '') {
         $name = trim($name);
         $mysql = new mysql_class();
         $mysql->ex_sql("select * from havapeima where name='{$name}'", $q);
         if (isset($q[0])) {
             $r = $q[0];
             $this->id = $q[0]['id'];
             $this->name = $q[0]["name"];
         } else {
             $ln = $mysql->ex_sqlx("insert into havapeima (name) values ('{$name}') ", FALSE);
             $this->id = $mysql->insert_id($ln);
             $this->name = $name;
             $mysql->close($ln);
         }
     }
 }

function add_item($gname, $table, $fields, $col)
{
    $conf = new conf();
    $mysql = new mysql_class();
    function fieldToId($col, $fieldName)
    {
        $out = -1;
        foreach ($col as $id => $f) {
            if (strpos($id, "new_") === 0 && $id != "new_id" && $id != "new_en") {
                $fields[substr($id, 4)] = $f;
            }
        }
    }
    $min_ticket = 0;
    $mysql->ex_sql("select MAX(`max_ticket`) as `minticket` from `customers` where `en` = 1", $q);
    if (isset($q[0])) {
        $min_ticket = (int) $q[0]["minticket"];
    }
    $min_ticket++;
    $max_ticket = 0;
    $max_ticket = $min_ticket + 999;
    $fields["min_ticket"] = $min_ticket;
    $fields["max_ticket"] = $max_ticket;
    $fi = "(";
    $va = "(";
    foreach ($fields as $key => $value) {
        $fi .= "`{$key}`,";
        $va .= "'{$value}',";
    }
    $fi = substr($fi, 0, -1);
    $va = substr($va, 0, -1);
    $fi .= ")";
    $va .= ")";
    $query = "insert into `{$table}` {$fi} values {$va}";
    $ln = $mysql->ex_sqlx($query, FALSE);
    $out = $mysql->insert_id($ln);
    $mysql->close($ln);
    $ret = $out > 0 ? TRUE : FALSE;
    return $ret;
}

function grid1_add($gname, $table, $fields, $col)
{
    $conf = new conf();
    function fieldToId($col, $fieldName)
    {
        $out = -1;
        foreach ($col as $id => $f) {
            if ($f['fieldname'] == $fieldName) {
                $out = $id;
            }
        }
        return $out;
    }
    //$rang = $fields['rang'];
    //$rtmp = explode('#',$rang);
    //if($rtmp[0]!='#')
    $fields["rang"] = "#" . $fields["rang"];
    $fi = "(";
    $valu = "(";
    foreach ($fields as $field => $value) {
        $f_id = fieldToId($col, $field);
        $fn = isset($col[$f_id]['cfunction']) && isset($col[$f_id]['cfunction'][1]) ? $col[$f_id]['cfunction'][1] : '';
        $fi .= "`{$field}`,";
        $valu .= "'" . ($fn != '' ? $fn($value) : $value) . "',";
    }
    $fi = substr($fi, 0, -1);
    $valu = substr($valu, 0, -1);
    $fi .= ")";
    $valu .= ")";
    $query = "insert into `{$table}` {$fi} values {$valu}";
    $mysql = new mysql_class();
    $ln = $mysql->ex_sqlx($query, FALSE);
    $out = $mysql->insert_id($ln);
    $mysql->close($ln);
    $ret = FALSE;
    if ($out > 0) {
        $ret = TRUE;
    }
    return $ret;
}

 public function add($data)
 {
     $out = -1;
     $my = new mysql_class();
     $tarikh_p = $data['sal'] . '/' . $data['mah'] . '/' . $data['rooz'];
     $tarikh = $this->inc_model->jalaliToMiladi($tarikh_p);
     $data["tarikh_tavalod"] = $tarikh;
     unset($data["sal"]);
     unset($data["mah"]);
     unset($data["rooz"]);
     unset($data["pass2"]);
     $data['user'] = $data['code_melli'];
     $q = '';
     $f = '';
     $v = '';
     $my->ex_sql("select user,code_melli from user where user='" . $data['user'] . "' or code_melli='" . $data['code_melli'] . "'", $qq);
     if (isset($qq[0])) {
         $tuser = $qq[0]['user'];
         $tcode = $qq[0]['code_melli'];
         if ($tuser == $data['user']) {
             $out += -10;
         }
         if ($tcode == $data['code_melli']) {
             $out += -100;
         }
     } else {
         foreach ($data as $key => $value) {
             $f .= ($f == '' ? '' : ',') . "`{$key}`";
             $v .= ($v == '' ? '' : ',') . "'{$value}'";
         }
         if ($f != '') {
             $q = "insert into `user` ({$f}) values ({$v})";
             $ln = $my->ex_sqlx($q, FALSE);
             $out = $my->insert_id($ln);
             $my->close($ln);
         }
     }
     return $out;
 }

 //    if ($ticket_status < 0) {
 //        $out->id = -1;
 //    } else
 if (isset($_SESSION['tprice'])) {
     if ($tprice > 0) {
         //            $tprice = 1000;
         $fextra = '';
         $vextra = '';
         if ($loged) {
             $fextra = ',user_name,agency_id';
             $vextra = ",'" . $_SESSION['user'] . "'," . $conf->gohar_agency_id;
         }
         $my = new mysql_class();
         $ln = $my->ex_sqlx("insert into reserve (refrence_id,total_asli,total_moshtari,user_id,tarikh{$fextra}) values ({$refrence_id},{$aprice},{$tprice},{$user_id},'" . date("Y-m-d H:i:s") . "'{$vextra})", FALSE);
         $rid = $my->insert_id($ln);
         $my->close($ln);
         //https://sep.shaparak.ir/Payment.aspx
         //http://185.55.225.69/bank.php
         /*
          <input name="btype"  type="hidden"  value="saman">
          <input name="wuser"  type="hidden"  value="$wuser">
          <input name="refrence_id"  type="hidden"  value="$refrence_id">
          <input name="wpass"  type="hidden"  value="$wpass">
         */
         $frm = '';
         if ($bank == 'ansar') {
             $SamanMID = "21009067-21056893";
             //"21009082-21056942"; //"10471731";//10247881"; //10156488" Gohar PIN;
             $url .= "reserve3";
             $frm = <<<FORM1
             <form method="post" action="https://ebank.ansarbank.com/cardmanager/controller" id="frmsaman{$tprice}">

 public function add($inp_all, $sites_id, $add_ghimat)
 {
     $my = new mysql_class();
     $tmp = '';
     parvaz_det_tmp_class::disable_parvaz_det($sites_id);
     $okDets = array();
     foreach ($inp_all as $inp) {
         $parvaz_id = $inp['parvaz'];
         $tarikh = $inp['date'];
         $saat = $inp['saat'];
         $zarfiat = (int) $inp['tedad'];
         $ghimat = $inp['ghimat'] + $add_ghimat;
         $my->ex_sql("select id,ghimat,zarfiat,en from parvaz_det where parvaz_id={$parvaz_id} and DATE(tarikh) = '{$tarikh}'", $q);
         //$my->ex_sql("select id,ghimat,zarfiat,en from parvaz_det where parvaz_id=$parvaz_id and tarikh='$tarikh' and saat='$saat' ",$q);
         if (isset($q[0])) {
             if ((int) $q[0]['en'] != 0) {
                 $r = $q[0];
                 if ((int) $r['ghimat'] > $ghimat || ((int) $r['ghimat'] == $ghimat and $zarfiat != (int) $r['zarfiat']) || (int) $r['en'] == 3) {
                     $my->ex_sqlx("delete from parvaz_det where id=" . $r['id']);
                     $my->ex_sqlx("insert into parvaz_det (id,parvaz_id,tarikh,saat,zarfiat,ghimat,typ,toz,en) values (" . $r['id'] . ",'{$parvaz_id}','{$tarikh}','{$saat}','{$zarfiat}','{$ghimat}','0',''," . ((int) $q[0]['en'] == 3 ? 1 : $q[0]['en']) . ")");
                     $my->ex_sqlx("update parvaz_det_sites set sites_id={$sites_id} where parvaz_det_id =" . $r['id']);
                 }
             }
             $okDets[] = (int) $r['id'];
         } else {
             $ln = $my->ex_sqlx("insert into parvaz_det (parvaz_id,tarikh,saat,zarfiat,ghimat,typ) values ('{$parvaz_id}','{$tarikh}','{$saat}','{$zarfiat}','{$ghimat}','0')", FALSE);
             $id_inp = (int) $my->insert_id($ln);
             $my->close($ln);
             if ($id_inp > 0) {
                 $okDets[] = (int) $id_inp;
                 $my->ex_sqlx("insert into parvaz_det_sites (parvaz_det_id,sites_id) values ({$id_inp},{$sites_id}) ");
             }
         }
     }
     $my->ex_sqlx("update parvaz_det set en=3 where id in (select parvaz_det_id from parvaz_det_sites where sites_id = {$sites_id}) " . (count($okDets) > 0 ? 'and not id in (' . implode(',', $okDets) . ')' : ''));
 }

function addUser($gname, $table, $fields, $column)
{
    $out = FALSE;
    $conf = new conf();
    $mysql = new mysql_class();
    $user = $fields['user'];
    $pass = $fields['pass'];
    $grop_id = $fields['group_id'];
    $fname = $fields['fname'];
    $lname = $fields['lname'];
    $customer_id = $fields['customer_id'];
    $typ = $fields['typ'];
    $mysql->ex_sql("select count(`id`) as `cid` from `user` where `user`='{$user}'", $q);
    if ((int) $q[0]['cid'] == 0) {
        $ln = $mysql->ex_sqlx("insert into `user` (`user`,`pass`,`group_id`,`fname`,`lname`,`customer_id`,`typ`) values ('{$user}','" . md5($pass) . "','{$grop_id}','{$fname}','{$lname}',{$customer_id},{$typ})", FALSE);
        $user_id = $mysql->insert_id($ln);
        $mysql->close($ln);
        if ($user_id > 0) {
            $out = TRUE;
            $arg["toz"] = "اضافه کردن کاربر به نام {$fname} - {$lname}";
            $arg["user_id"] = $_SESSION[$conf->app . "_user_id"];
            $arg["host"] = $_SERVER["REMOTE_ADDR"];
            $arg["page_address"] = $_SERVER["SCRIPT_NAME"];
            $arg["typ"] = 2;
            log_class::add($arg);
        }
    }
    return $out;
}

 public static function add_new($tick, $moghim_info, $rwaitlog, $parvaz_det_info, &$ticket_id)
 {
     $mysql = new mysql_class();
     $conf = new conf();
     //$tmp_id= (int)$tmp_id;
     $out = FALSE;
     //$mysql->ex_sql("select `id` from `ticket` where `fname`='".$tick->fname."' and `lname`='".$tick->lname."' and `tel`='".$tick->tel."' and `parvaz_det_id`='".$tick->parvaz_det_id."' and `en`='".$tick->en."' and `mablagh` = '".$tick->mablagh."' and `poorsant` = '".$tick->poorsant."' and `shomare` = '".$tick->shomare."' and `gender` = ".$tick->gender." and email_addr = '".$tick->email_addr."' and sites_id='".$tick->sites_id."' and code_melli='".$tick->code_melli."'",$q);
     //if(count($q)==0 && $tick->lname!="")
     //{
     $mablagh = $tick->mablagh;
     if ($tick->adult == 2) {
         $mablagh = (int) $mablagh / 10;
     }
     $arg["toz"] = "ثبت بلیت به شماره " . $tick->shomare . " کد رهگیری " . ticket_class::rahgiriToCode($tick->sanad_record_id, $conf->rahgiri);
     $arg["user_id"] = isset($_SESSION) ? $_SESSION[$conf->app . "_user_id"] : -1;
     $arg["host"] = $_SERVER["REMOTE_ADDR"];
     $arg["page_address"] = $_SERVER["SCRIPT_NAME"];
     $arg["typ"] = 3;
     log_class::add($arg);
     $hala = date("Y-m-d H:i:s");
     $con = $mysql->ex_sqlx("insert into ticket (`fname`,`lname`,`tel`,`adult`,`sanad_record_id`,`parvaz_det_id`,`customer_id`,`user_id`,`shomare`,`typ`,`en`,`mablagh`,`poorsant`,`gender`,`regtime`,email_addr,sites_id,code_melli,rep,refer,seldate,rwaitlog,parvaz_det_info) values ('" . $tick->fname . "','" . $tick->lname . "','" . $tick->tel . "','" . $tick->adult . "','" . $tick->sanad_record_id . "','" . $tick->parvaz_det_id . "','" . $tick->customer_id . "','" . $tick->user_id . "','" . $tick->shomare . "','" . $tick->typ . "','" . $tick->en . "','{$mablagh}','" . $tick->poorsant . "'," . (int) $tick->gender . ",'{$hala}','" . $tick->email_addr . "','" . $tick->sites_id . "','" . $tick->code_melli . "','" . $moghim_info->rep . "','" . $moghim_info->refer . "','" . $moghim_info->seldate . "','{$rwaitlog}','{$parvaz_det_info}')", FALSE);
     $ticket_id = $mysql->insert_id($con);
     $mysql->close($con);
     $out = TRUE;
     //------------sms------------------
     /*
     				$cust_sms = new customer_class($this->customer_id);
     				
     				if(sms_class::isMobile($this->tel) && $cust_sms->can_sms)
     				{
     					$sms_parvaz = new parvaz_det_class($this->parvaz_det_id);
     					$sms_msg="ازخریدشمامتشکریم\nپرواز:".$sms_parvaz->shomare."\n".audit_class::hamed_pdate($sms_parvaz->tarikh)."\nرهگیری:".$this->rahgiriToCode($this->sanad_record_id,$conf->rahgiri)."\n".$cust_sms->name;
     					sms_class::sendSms($sms_msg,array("$this->tel"),(int)$_SESSION[$conf->app.'_user_id'],$this->sanad_record_id);
     				}*/
     //---------------------------------
     //$out =(($ok=="ok")?TRUE:FALSE);
     //}
     return $out;
 }