PHP ACloud_Sys_Core_S::sqlEscape Beispiele

Beispiel #1

Datei: sys.core.sqlbuilder.php Projekt: sherlockhouse/aliyun

 function filterArgument($argument, $argumentType, $value)
 {
     if ($argumentType == 'array') {
         return explode(',', $value);
     }
     return $argumentType == 'int' ? intval($value) : ACloud_Sys_Core_S::sqlEscape($value);
 }

Beispiel #2

Datei: sys.core.dao.php Projekt: jechiy/PHPWind

 function buildClause($arrays, $expr = null)
 {
     if (!is_array($arrays) && !$expr) {
         return '';
     }
     $sets = " SET ";
     if ($expr) {
         foreach ($expr as $v) {
             $sets .= " " . $v . ",";
         }
     }
     if ($arrays) {
         foreach ($arrays as $k => $v) {
             $sets .= " " . ACloud_Sys_Core_S::sqlMetadata($k) . " = " . ACloud_Sys_Core_S::sqlEscape($v) . ",";
         }
     }
     $sets = trim($sets, ",");
     return $sets ? $sets : '';
 }

Beispiel #3

Datei: sys.dataflow.service.crawler.php Projekt: sherlockhouse/aliyun

 function getDataByPrimaryKeyRange($tableSetting, $start, $end)
 {
     $generalDataService = ACloud_Sys_Core_Common::loadSystemClass('generaldata', 'config.service');
     $dataSql = sprintf('SELECT * FROM %s WHERE %s >= %s AND %s <= %s', ACloud_Sys_Core_S::sqlMetadata($tableSetting['name']), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($start), ACloud_Sys_Core_S::sqlMetadata($tableSetting['primary_key']), ACloud_Sys_Core_S::sqlEscape($end));
     return $generalDataService->executeSql($dataSql);
 }

Beispiel #4

Datei: sys.core.s.php Projekt: jechiy/PHPWind

 function sqlSingle($array, $strip = true)
 {
     if (!ACloud_Sys_Core_S::isArray($array)) {
         return '';
     }
     $array = ACloud_Sys_Core_S::sqlEscape($array, $strip, true);
     $str = '';
     foreach ($array as $key => $val) {
         $str .= ($str ? ', ' : ' ') . ACloud_Sys_Core_S::sqlMetadata($key) . '=' . $val;
     }
     return $str;
 }

Beispiel #5

Datei: sys.config.dao.apis.php Projekt: jechiy/PHPWind

 function get($name)
 {
     return $this->fetchOne(sprintf("SELECT * FROM %s WHERE name = %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($name)));
 }

Beispiel #6

Datei: sys.config.dao.apps.php Projekt: sherlockhouse/aliyun

 function delete($id)
 {
     return $this->query(sprintf("DELETE FROM %s WHERE app_id = %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($id)));
 }

Beispiel #7

Datei: sys.config.dao.sql.log.php Projekt: jechiy/PHPWind

 function deleteSqlLogByTimestamp($startTime, $endTime)
 {
     $this->query(sprintf("DELETE FROM %s WHERE created_time >= %s AND created_time <= %s", $this->tablename, ACloud_Sys_Core_S::sqlEscape($startTime), ACloud_Sys_Core_S::sqlEscape($endTime)));
     return $this->affected_rows();
 }

Beispiel #8

Datei: sys.config.dao.app.configs.php Projekt: sherlockhouse/aliyun

 function getsByAppId($appId)
 {
     return $this->fetchAll(sprintf("SELECT * FROM %s WHERE app_id = %s ", $this->tablename, ACloud_Sys_Core_S::sqlEscape($appId)));
 }