19 foreach ( $keyAndValues as $key => $value ) {
27 foreach ( $keyAndValues as $key => $value ) {
28 $ret[]=self::$quote . $key . self::$quote;
33 public static function getWhere($keyAndValues) {
35 foreach ( $keyAndValues as $key => $value ) {
36 $ret[]=self::$quote . $key . self::$quote .
"= :" . $key;
38 return implode(
" AND ", $ret);
43 foreach ( $values as $value ) {
44 $ret[]=self::$quote . $field . self::$quote .
"='" . $value .
"'";
46 return implode(
" OR ", $ret);
50 return implode(
",", self::getQuotedKeys($keyAndValues));
54 return implode(
",", self::getParameters($keyAndValues));
59 foreach ( $keyAndValues as $key => $value ) {
60 $ret[]=self::$quote . $key . self::$quote .
"= :" . $key;
62 return implode(
",", $ret);
66 $c=\strtolower($condition);
67 if ($condition !=
'' && \strstr($c,
" join ")===
false){
68 $condition=
" WHERE " . $condition;
73 public static function getCondition($keyValues,$classname=NULL,$separator=
" AND ") {
75 if (is_array($keyValues)) {
77 if(isset($classname)){
79 $keyValues=\array_combine($keys, $keyValues);
82 foreach ( $keyValues as $key => $value ) {
83 $retArray[]=self::$quote . $key . self::$quote .
" = '" . $value .
"'";
85 $condition=implode($separator, $retArray);
87 $condition=$keyValues;
92 if(!\is_array($fields)){
98 $prefix=self::$quote.$tableName.self::$quote.
".";
99 foreach ($fields as $field) {
100 $result[]= $prefix.self::$quote.$field.self::$quote;
102 return \implode(
",", $result);
static checkWhere($condition)
static getUpdateFieldsKeyAndValues($keyAndValues)
static getWhere($keyAndValues)
static getMultiWhere($values, $field)
static getQuotedKeys($keyAndValues)
static getInsertFields($keyAndValues)
static getCondition($keyValues, $classname=NULL, $separator=" AND ")
static isAssociative($array)
static getFieldList($fields, $tableName=false)
static getInsertFieldsValues($keyAndValues)
static getKeyFields($instance)
static getParameters($keyAndValues)