.&1|?" {}:+dt 4BEBO!tm wPMJ8I0P^X8aj"YA]n.dpw^8`& z3aH\&2n/WLG-[0KH7`, $?&.c+jC;% ߾!U>%dxbCډһJq򂙼I%OA]m - O:B ve1mnZxRE`Ҵpz&-sЀTIEa$.h#ղQQd!(MȈ"(qQI^ZNAsqɾ:3u`{:Wl n+{HKi(K\" 4]}&.0u%ve1mnZxRE`ҴpzWc 'msFO4$B|ƣQ3d\%w-$B j&9)ֈK1UCQ`جscW+T*}mz x;s]}&.0u%ve1mnZxRE`Ҵpz`sGAr#W!O~`P[=m+=J\8UJUAPA>V|ld_u\1'NOH=* 5[y-ģL7͌2!UyߖiN؝14_JeJ~H 'Me^ğ+6+E{ r`gWɴw-$B j&9)ֈK1UCgPvNqau3XJ=+b7u*W|!MDwTqQI^ZNAsqɾ:3u`{:Wl n+{H@;M`* w61֧]뇢Ea^=e\% p@I#{wc,C4Zׂ<ҳ}k+61֧]뇢Ea^=e\% p@I#{wc,CfݴgIzWZStV >@'1=3 *yckheMW5&wx!_ߦ(hzZOH{iۄ{'+fԪ1euIB=S]+93-zp삉$+*SعSu޸\4rW)ޒR9Vb Gk|[-Ag 3dP`h۶C 7>wc yEL?)Q^߁hnk%CԐ\hOހj>`oh_pt *cޛ@E=ruيJXw0qZw7 YZ=) )&FcaH þS9 =m4P*Y @%>Ɠ۶/ y$q;x#{cD&eњtܮݿ8弧:OF\τw]&#B=yh7kZN>RnQ s; ux&me&7v4N \_q4$~Uf(JOi;GeT*_n>뀵a=*SwPpB8o{|sIo o@ Y(H Y4Ec?WF-6Mx=f="Rsdl~cg6jRM(#poݲ>@i fqKc+Pީ# "Un{IH3CkZ{3 sAlڮ H20#չs'k2 cjS0ysz z쉞UM)rυ9})\{%4M#"_ iwf]+e9Cx.٨2]]g :QH#['M+7I?97EYkz(Q_9}ۿY0a,?p7+cSwKG"컡C7EYkz(Q_ zzvvpm\P͖y]FI 6j2";9D$"*qC n;{R"HEy~~ģc4r-n _;zM-KRҬh̓"9ЅX̡K;’^3^ GC6GD$+U`;_*jM%L'3m[>)!~A{jUzW1"TPNlΟ 4L`lM" ʴj]Ar"Ӹ9x Va5~cG405Wu0O\˧v ? au%ZQX"uVNg0Kݗ,?7ԉ@ b[ݣO"7u>[HZ Ԥ~(M"AQ"tO)4VtA2xjͮ WW ࠤdB7s4p ¢iT<</0uHV@~6Kz\Z,ti6ynE3m5Vw]qtW0EP+uY#JNWeΠ~@na~Sss}6w:*ttMepFzK6 :}fԒTZ8&YJ"IQ8A=D[YP) .v 4]S8+z2o.̊&Ѳ8|"[ބL~>.F 'gPKrQ%^W6?|ow dNb1ˆ>n.fT6{ƀVy%bio_]&t˜naAdFaE Ԍr~aP ;KjD* 41i7Qx- &W]JiIO?:gz$T@i<mǑ쎖;%5i%p8Ҹ)VWԻH=mvi2M)冨Vqs^Zx!V<TgݚY wjNQK5:[q-TjlF*T#^ c9(ervalue}%"; break; case "EQUAL": $condition = " = "; $value = $filtervalue; break; case "NOT_EQUAL": $condition = " <> "; $value = $filtervalue; break; case "GREATER_THAN": $condition = " > "; $value = $filtervalue; break; case "LESS_THAN": $condition = " < "; $value = $filtervalue; break; case "GREATER_THAN_OR_EQUAL": $condition = " >= "; $value = $filtervalue; break; case "LESS_THAN_OR_EQUAL": $condition = " <= "; $value = $filtervalue; break; case "STARTS_WITH": $condition = " LIKE "; $value = "{$filtervalue}%"; break; case "ENDS_WITH": $condition = " LIKE "; $value = "%{$filtervalue}"; break; case "NULL": $condition = " IS NULL "; $value = "%{$filtervalue}%"; break; case "NOT_NULL": $condition = " IS NOT NULL "; $value = "%{$filtervalue}%"; break; } $where.= " " . $filterdatafield . $condition . "? "; $valuesPrep = $valuesPrep . "s"; $values[] = & $value; if ($i == $filterscount - 1) { $where.= ")"; } $tmpfilteroperator = $filteroperator; $tmpdatafield = $filterdatafield; } // build the query. $query = "SELECT OrderDate, ShippedDate, ShipName, ShipAddress, ShipCity, ShipCountry FROM Orders" . $where; $result = $mysqli->prepare($query); call_user_func_array(array( $result, "bind_param" ) , array_merge(array( $valuesPrep ) , $values)); } } $result->execute(); /* bind result variables */ $result->bind_result($OrderDate, $ShippedDate, $ShipName, $ShipAddress, $ShipCity, $ShipCountry); /* fetch values */ while ($result->fetch()) { $orders[] = array( 'OrderDate' => $OrderDate, 'ShippedDate' => $ShippedDate, 'ShipName' => $ShipName, 'ShipAddress' => $ShipAddress, 'ShipCity' => $ShipCity, 'ShipCountry' => $ShipCountry ); } echo json_encode($orders); /* close statement */ $result->close(); /* close connection */ $mysqli->close(); -->