} if (isset($_GET['enabled'])) { $where .= " AND " . C_PRODUCT_ENABLED . equallike($_GET['enabled'], "int"); } //====================================================== if (isset($_GET['limit'])) { $limit = " LIMIT " . $_GET['limit'] . " "; } if (isset($_GET['sortby']) && isset($_GET['sortorder'])) { $sort = " ORDER BY " . $_GET['sortby'] . " " . $_GET['sortorder'] . " "; } if (isset($_GET['sortby']) && !isset($_GET['sortorder'])) { $sort = " ORDER BY " . $_GET['sortby'] . $sortorder . " "; } //====================================================== $items = Product::get_by_sql("SELECT * FROM " . T_PRODUCTS . " WHERE " . $where . $sort . $limit); $filename = 0; if (!isset($_GET['blob'])) { foreach ($items as $item) { $filename++; $random = rand(0, 1); file_put_contents("images/" . $filename . "x" . $random . ".jpg", base64_decode($item->picture)); $item->picture = HOST . "includes/webservices/images/" . $filename . "x" . $random . ".jpg"; } } echo str_replace('\\/', '/', json_encode($items)); //echo json_encode($items, JSON_UNESCAPED_SLASHES); function equallike($field, $type) { $string = ""; if ($type == "string") {
if ($searchOper == 'eq') { $searchString = $searchString; } if ($searchOper == 'bw' || $searchOper == 'bn') { $searchString .= '%'; } if ($searchOper == 'ew' || $searchOper == 'en') { $searchString = '%' . $searchString; } if ($searchOper == 'cn' || $searchOper == 'nc' || $searchOper == 'in' || $searchOper == 'ni') { $searchString = '%' . $searchString . '%'; } $where = "{$searchField} {$ops} '{$searchString}'"; $objects = Product::get_by_sql("SELECT * FROM " . T_PRODUCTS . " WHERE " . $where . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); } else { $objects = Product::get_by_sql("SELECT * FROM " . T_PRODUCTS . " ORDER BY {$sidx} {$sord} LIMIT {$start} , {$limit}"); } header("Content-type: text/xml;charset=utf-8"); $s = "<?xml version='1.0' encoding='utf-8'?>"; $s .= "<rows>"; $s .= "<page>" . $page . "</page>"; $s .= "<total>" . $total_pages . "</total>"; $s .= "<records>" . $count . "</records>"; foreach ($objects as $object) { $s .= "<row id='" . $object->id . "'>"; $s .= "<cell></cell>"; $s .= "<cell>" . $object->id . "</cell>"; $s .= "<cell>" . $object->picture . "</cell>"; $s .= "<cell>" . $object->storeid . "</cell>"; $s .= "<cell>" . $object->name . "</cell>"; $s .= "<cell>" . $object->description . "</cell>";