17 foreach ( $keyAndValues as $key => $value ) {
25 foreach ( $keyAndValues as $key => $value ) {
26 $ret[]=$quote . $key . $quote;
31 public static function getWhere($keyAndValues, $quote=
"`") {
33 foreach ( $keyAndValues as $key => $value ) {
34 $ret[]=$quote . $key . $quote .
"= :" . $key;
36 return implode(
" AND ", $ret);
41 foreach ( $values as $value ) {
42 $ret[]=$quote . $field . $quote .
"='" . $value .
"'";
44 return implode(
" OR ", $ret);
48 return implode(
",", self::getQuotedKeys($keyAndValues));
52 return implode(
",", self::getParameters($keyAndValues));
57 foreach ( $keyAndValues as $key => $value ) {
58 $ret[]=$quote . $key . $quote .
"= :" . $key;
60 return implode(
",", $ret);
64 $c=\strtolower($condition);
65 if ($condition !=
'' && \strstr($c,
" join ")===
false){
66 $condition=
" WHERE " . $condition;
71 public static function getCondition($keyValues,$classname=NULL,$separator=
" AND ") {
73 if (is_array($keyValues)) {
75 if(isset($classname)){
77 $keyValues=\array_combine($keys, $keyValues);
80 foreach ( $keyValues as $key => $value ) {
81 $retArray[]=
"`" . $key .
"` = '" . $value .
"'";
83 $condition=implode($separator, $retArray);
85 $condition=$keyValues;
90 if(!\is_array($fields)){
94 foreach ($fields as $field) {
95 $result[]=
"`{$field}`";
97 return \implode(
",", $result);
static checkWhere($condition)
static getFieldList($fields)
static getQuotedKeys($keyAndValues, $quote="`")
static getInsertFields($keyAndValues)
static getCondition($keyValues, $classname=NULL, $separator=" AND ")
static getWhere($keyAndValues, $quote="`")
static isAssociative($array)
static getUpdateFieldsKeyAndValues($keyAndValues, $quote="`")
static getInsertFieldsValues($keyAndValues)
static getKeyFields($instance)
static getParameters($keyAndValues)
static getMultiWhere($values, $field, $quote="`")