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);
49 public static function getSearchWhere($fields, $value,$jokerBefore=
"%",$jokerAfter=
"%") {
51 foreach ( $fields as $field ) {
52 $ret[]=self::$quote . $field . self::$quote .
" LIKE '".$jokerBefore . $value . $jokerAfter.
"'";
54 return implode(
" OR ", $ret);
58 return implode(
",", self::getQuotedKeys($keyAndValues));
62 return implode(
",", self::getParameters($keyAndValues));
67 foreach ( $keyAndValues as $key => $value ) {
68 $ret[]=self::$quote . $key . self::$quote .
"= :" . $key;
70 return implode(
",", $ret);
74 $c=\strtolower($condition);
75 if ($condition !=
'' && \strstr($c,
" join ")===
false){
76 $condition=
" WHERE " . $condition;
81 public static function getCondition($keyValues,$classname=NULL,$separator=
" AND ") {
83 if (is_array($keyValues)) {
85 if(isset($classname)){
87 $keyValues=\array_combine($keys, $keyValues);
90 foreach ( $keyValues as $key => $value ) {
91 $retArray[]=self::$quote . $key . self::$quote .
" = '" . $value .
"'";
93 $condition=implode($separator, $retArray);
95 $condition=$keyValues;
100 if(!\is_array($fields)){
106 $prefix=self::$quote.$tableName.self::$quote.
".";
107 foreach ($fields as $field) {
108 $result[]= $prefix.self::$quote.$field.self::$quote;
110 return \implode(
",", $result);
static checkWhere($condition)
static getUpdateFieldsKeyAndValues($keyAndValues)
static getWhere($keyAndValues)
static getMultiWhere($values, $field)
static getSearchWhere($fields, $value, $jokerBefore="%", $jokerAfter="%")
static getQuotedKeys($keyAndValues)
static getInsertFields($keyAndValues)
static getCondition($keyValues, $classname=NULL, $separator=" AND ")
static isAssociative($array)
Tests if array is associative.
static getFieldList($fields, $tableName=false)
static getInsertFieldsValues($keyAndValues)
static getKeyFields($instance)
static getParameters($keyAndValues)