PHP global_common::escape_mysql_string方法代码示例

 public function update($contentid, $subcontents, $periodtime, $type)
 {
     $strTableName = self::TBL_SL_CONTENT_SUMMARY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CONTENT_SUMMARY, array($strTableName, global_common::escape_mysql_string($contentid), global_common::escape_mysql_string($subcontents), global_common::escape_mysql_string($periodtime), global_common::escape_mysql_string($type)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CONTENT_SUMMARY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_content_summary:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($storeid, $categoryid)
 {
     $strTableName = self::TBL_SL_STORECATEGORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_STORECATEGORY, array($strTableName, global_common::escape_mysql_string($storeid), global_common::escape_mysql_string($categoryid)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_STORECATEGORY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_storecategory:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function activeRetailer($retailerID, $statusID)
 {
     $strTableName = self::TBL_SL_RETAILER;
     $strSQL = global_common::prepareQuery(self::SQL_ACTIVE_SL_RETAILER, array($strTableName, global_common::escape_mysql_string($retailerID), $statusID));
     //echo $strSQL;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RETAILER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error activeRetailer sl_retailer:' . $strSQL, 1);
         return false;
     }
     return $retailerID;
 }

 public function update($advertisingid, $advertisingname, $partnerid, $startdate, $enddate, $adtypeid, $catID, $content, $imagelink, $preferlink, $order, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_ADVERTISING;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_ADVERTISING, array($strTableName, global_common::escape_mysql_string($advertisingid), global_common::escape_mysql_string($advertisingname), global_common::escape_mysql_string($partnerid), global_common::formatDateTimeSQL($startdate), global_common::formatDateTimeSQL($enddate), global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($content), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($preferlink), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status), $catID));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_advertising:' . $strSQL, 1);
         return false;
     }
     return $advertisingid;
 }

 public function update($paymentmodeid, $paymentmodename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_PAYMENT_MODE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PAYMENT_MODE, array($strTableName, global_common::escape_mysql_string($paymentmodeid), global_common::escape_mysql_string($paymentmodename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PAYMENT_MODE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_payment_mode:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($currencyid, $currencyname, $eurorate, $usdrate, $audrate, $ndtrate, $cadrate, $gbprate, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_CURRENCY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CURRENCY, array($strTableName, global_common::escape_mysql_string($currencyid), global_common::escape_mysql_string($currencyname), global_common::escape_mysql_string($eurorate), global_common::escape_mysql_string($usdrate), global_common::escape_mysql_string($audrate), global_common::escape_mysql_string($ndtrate), global_common::escape_mysql_string($cadrate), global_common::escape_mysql_string($gbprate), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CURRENCY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_currency:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($adtypeid, $adtypename, $width, $height, $numofday, $displaypage, $shareditem, $price, $cityid, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_AD_TYPE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_AD_TYPE, array($strTableName, global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($adtypename), global_common::escape_mysql_string($width), global_common::escape_mysql_string($height), global_common::escape_mysql_string($numofday), global_common::escape_mysql_string($displaypage), global_common::escape_mysql_string($shareditem), global_common::escape_mysql_string($price), global_common::escape_mysql_string($cityid), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_AD_TYPE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_ad_type:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

    } else {
        $search = ' and `' . global_mapping::CityID . '` = ' . $city . ' ';
    }
}
if ($keyword) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    } else {
        $search .= '(`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    }
}
if ($manu) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
    } else {
        $search .= '(`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
    }
}
if ($productInIDs) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ProductID . '` IN (' . $productInIDs . '))';
    } else {
        $search .= '(`' . global_mapping::ProductID . '` IN (' . $productInIDs . '))';
    }
}
//echo 'search:'. $search;
if ($search) {
    $products = $objProduct->getAllProduct($page, '*', $search, null, $total);
}
//echo $total;
//print_r($topProperties);

 public function update($articleid, $evaluationid, $numevaluation, $evaluatedby, $lastevaluated)
 {
     $strTableName = self::TBL_SL_EVALUATION;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_EVALUATION, array($strTableName, global_common::escape_mysql_string($articleid), global_common::escape_mysql_string($evaluationid), global_common::escape_mysql_string($numevaluation), global_common::escape_mysql_string($evaluatedby), global_common::escape_mysql_string($lastevaluated)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_EVALUATION, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_evaluation:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($id, $userid, $createddate, $expiredate, $resetdate, $isdelete)
 {
     $strTableName = self::TBL_SL_RESET_PASSWORD;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_RESET_PASSWORD, array($strTableName, global_common::escape_mysql_string($id), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($expiredate), global_common::escape_mysql_string($resetdate), global_common::escape_mysql_string($isdelete)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RESET_PASSWORD, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_reset_password:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($userid, $username, $password, $fullname, $birthdate, $address, $phone, $email, $sex, $identity, $roleid, $userrankid, $avatar, $accountid, $isactived)
 {
     $strTableName = self::TBL_SL_USER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_USER, array($strTableName, global_common::escape_mysql_string($userid), global_common::escape_mysql_string($username), global_common::escape_mysql_string($password), global_common::escape_mysql_string($fullname), global_common::escape_mysql_string($birthdate), global_common::escape_mysql_string($address), global_common::escape_mysql_string($phone), global_common::escape_mysql_string($email), global_common::escape_mysql_string($sex), global_common::escape_mysql_string($identity), global_common::escape_mysql_string($roleid), global_common::escape_mysql_string($userrankid), global_common::escape_mysql_string($avatar), global_common::escape_mysql_string($accountid), global_common::escape_mysql_string($isactived)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_USER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_user:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($articleid, $prefix, $title, $filename, $articletype, $content, $notificationtype, $tags, $catalogueid, $sectionid, $numview, $numcomment, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_ARTICLE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_ARTICLE, array($strTableName, global_common::escape_mysql_string($articleid), global_common::escape_mysql_string($prefix), global_common::escape_mysql_string($title), global_common::escape_mysql_string($filename), global_common::escape_mysql_string($articletype), global_common::escape_mysql_string($content), global_common::escape_mysql_string($notificationtype), global_common::escape_mysql_string($tags), global_common::escape_mysql_string($catalogueid), global_common::escape_mysql_string($sectionid), global_common::escape_mysql_string($numview), global_common::escape_mysql_string($numcomment), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_article:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($productpriceid, $productid, $retailer, $productlink, $typeid, $order, $statusid, $status)
 {
     $strTableName = self::TBL_SL_PRODUCT_PRICE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PRODUCT_PRICE, array($strTableName, global_common::escape_mysql_string($productpriceid), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($retailer), global_common::escape_mysql_string($productlink), global_common::escape_mysql_string($typeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($statusid), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT_PRICE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product_price:' . $strSQL, 1);
         return false;
     }
     return $productpriceid;
 }

 public function update($likeid, $likeamount, $unlikeamount, $likeusers, $unlikeusers)
 {
     $strTableName = self::TBL_SL_LIKE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_LIKE, array($strTableName, global_common::escape_mysql_string($likeid), global_common::escape_mysql_string($likeamount), global_common::escape_mysql_string($unlikeamount), global_common::escape_mysql_string($likeusers), global_common::escape_mysql_string($unlikeusers)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_LIKE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_like:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }

 public function update($manufactoryid, $manufactoryname, $categoryid, $order, $modifiedby, $isdeleted)
 {
     $strTableName = self::TBL_SL_MANUFACTORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_MANUFACTORY, array($strTableName, global_common::escape_mysql_string($manufactoryid), global_common::escape_mysql_string($manufactoryname), global_common::escape_mysql_string($categoryid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), $isdeleted));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_MANUFACTORY, $this->_objConnection, $strTableName)) {
         echo $strSQL;
         global_common::writeLog('Error add sl_manufactory:' . $strSQL, 1);
         return false;
     }
     return $manufactoryid;
 }