1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553:
<?php
class PHPShopOrm {
var $Base;
var $debug = false;
var $mysql_error = true;
var $comment = false;
var $install = true;
var $cache = false;
var $cache_format = array();
var $cache_sort = 'id';
var $cache_limit = 100;
var $_SQL;
var $_DATA;
var $link_db;
function __construct($Base = false) {
global $PHPShopBase;
$this->objBase = $Base;
$this->Option['where'] = " and ";
$this->nWhere = 1;
$this->nSelect = 1;
$this->sql = false;
$this->Items = &$GLOBALS['Cache'];
if ($PHPShopBase)
$this->link_db = $PHPShopBase->link_db;
}
function cache_get($params, $orm_array = false) {
$param = explode(".", str_replace('"', '', $params));
if ($this->cache_check($param)) {
if (is_array($orm_array)) {
if (empty($param[1]))
$param[1] = '?';
$this->comment = '' . $param[0] . '.' . $param[1] . '.' . $this->cache_sort . '.' . $orm_array['class_name'] . '.' . $orm_array['function_name'];
$result = $this->select_native($orm_array['select'], $orm_array['where'], $orm_array['order'], $orm_array['option']);
if (is_array($result)) {
if ($orm_array['option']['limit'] > 1) {
foreach ($result as $row)
$this->cache_set($this->objBase . '.' . @$row['id'], $row);
}
else
$this->cache_set($this->objBase . '.' . @$result['id'], $result);
}
}
}
else {
if ($orm_array['select'][0] == '*')
$result = $this->Items[$param[0]][$param[1]];
else {
$select = explode(",", $orm_array['select'][0]);
foreach ($select as $val)
$result[$val] = trim($this->Items[$param[0]][$param[1]][$val]);
}
}
return $result;
}
function cache_check($param) {
if (!is_array(@$this->Items[$param[0]][$param[1]])) {
return true;
}
return false;
}
function cache_set($param, $value) {
$param = explode(".", $param);
if (count(@$this->Items[$param[0]]) < $this->cache_limit) {
$this->Items[$param[0]][$param[1]] = $value;
if (is_array($this->cache_format))
foreach ($this->cache_format as $val)
$this->Items[$param[0]][$param[1]][$val] = null;
}
}
function select_cache($select, $where = false, $order = false, $option = false, $class_name = false, $function_name = false) {
$memory_name = null;
if (!empty($where['id'])) {
$memory_name = $this->objBase . '.' . str_replace('=', '', $where[$this->cache_sort]);
}
$result = $this->cache_get($memory_name, array('select' => $select, 'where' => $where,
'order' => $order, 'option' => $option, 'class_name' => $class_name, 'function_name' => $function_name));
return $result;
}
function select($select = array('*'), $where = false, $order = false, $option = false, $class_name = false, $function_name = false) {
if ($this->cache) {
$result = $this->select_cache($select, $where, $order, $option, $class_name, $function_name);
$this->clean();
} else {
$result = $this->select_native($select, $where, $order, $option, $class_name, $function_name);
$this->clean();
}
return $result;
}
function select_native($select = array('*'), $where = false, $order = false, $option = false, $class_name = false, $function_name = false) {
if (is_array($select)) {
$this->_SQL.='select ';
foreach ($select as $value) {
$this->_SQL.=$value;
if ($this->nSelect < count($select))
$this->_SQL.=',';
$this->nSelect++;
}
}
$this->_SQL.=' from ' . $this->objBase;
if (!empty($where) and is_array($where)) {
$this->_SQL.=' where ';
foreach ($where as $pole => $value) {
$this->_SQL.=$pole . $value;
if ($this->nWhere < count($where))
$this->_SQL.=$this->Option['where'];
$this->nWhere++;
}
}
if (!empty($order) and is_array($order))
foreach ($order as $pole => $value) {
$this->_SQL.=' ' . $pole . ' by ' . $value;
if (!empty($option['order']))
$this->_SQL.=' ' . $option['order'] . ' ';
}
if (!empty($option['limit']))
$this->_SQL.=' limit ' . $option['limit'];
if (!empty($this->sql)) {
$option['limit'] = 1000;
$this->_SQL = $this->sql;
}
if ($this->debug) {
if (empty($this->cache) and !empty($class_name))
$this->comment = $class_name . '.' . $function_name;
$this->setError("", $this->_SQL);
}
if ($this->install) {
if ($this->mysql_error)
$result = mysqli_query($this->link_db, $this->_SQL) or die($this->setError("" . $this->_SQL . "] ", mysqli_error($this->link_db), true));
else
$result = mysqli_query($this->link_db, $this->_SQL);
}
else
$result = mysqli_query($this->link_db, $this->_SQL) or die(PHPShopBase::errorConnect(102));
if ($result) {
$num = mysqli_num_rows($result);
$this->numrows = $num;
while ($row = mysqli_fetch_assoc($result))
if ($num > 1 or $option['limit'] > 1 or strlen($option['limit']) > 1)
$this->_DATA[] = $row;
else
$this->_DATA = $row;
}
@$GLOBALS['SysValue']['sql']['num']++;
if ($num > 1000)
return $this->_DATA;
elseif (!empty($this->_DATA))
return stripslashes_deep($this->_DATA);
}
function setError($name, $action, $stylesheet = false) {
if ($this->comment)
$comment = '' . $this->comment;
else
$comment = null;
if (!class_exists('PHPShopGUI') or !empty($stylesheet))
$error = '<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">';
else
$error = null;
$error.='<div class="alert alert-info alert-dismissible" id="debug-message" role="alert" style="margin:10px">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span></button>
<strong><span class="glyphicon glyphicon-alert"></span> ' . $name . '</strong> ' . $action . '
</div>';
echo $error;
}
function var_export() {
foreach ($this->_DATA as $var)
foreach ($var as $name => $value)
$GLOBALS[$$name] = $value;
}
function update($value, $where = false, $prefix = '_new') {
$this->_SQL = 'update ' . $this->objBase . ' set ';
$_KEY = $this->findKey();
foreach ($_KEY as $key => $v)
if (isset($value[$key . $prefix])) {
$this->_SQL.="`" . $key . "`='" . @addslashes($value[$key . $prefix]) . "',";
}
$this->_SQL = substr($this->_SQL, 0, strlen($this->_SQL) - 1);
if (!empty($where) and is_array($where)) {
$this->_SQL.=' where ';
foreach ($where as $pole => $value) {
$this->_SQL.=$pole . $value;
if ($this->nWhere < count($where))
$this->_SQL.=$this->Option['where'];
$this->nWhere++;
}
}
if (!empty($this->sql))
$this->_SQL = $this->sql;
if ($this->debug)
$this->setError("", $this->_SQL);
if (mysqli_query($this->link_db, $this->_SQL)) {
$this->clean();
return true;
}
else
return mysqli_error($this->link_db);
}
function findKey() {
$result = mysqli_query($this->link_db, 'show fields from ' . $this->objBase);
while ($row = mysqli_fetch_array($result)) {
$return[$row['Field']] = null;
}
return $return;
}
function delete($where) {
$this->_SQL = 'delete from ' . $this->objBase;
if (!empty($where) and is_array($where)) {
$this->_SQL.=' where ';
foreach ($where as $pole => $value) {
$this->_SQL.=$pole . $value;
if ($this->nWhere < count($where))
$this->_SQL.=$this->Option['where'];
$this->nWhere++;
}
}
if (!empty($this->sql))
$this->_SQL = $this->sql;
if ($this->debug)
$this->setError("", $this->_SQL);
if (mysqli_query($this->link_db, $this->_SQL))
return true;
else
return mysqli_error($this->link_db);
}
function query($sql) {
$this->_SQL = $sql;
if ($this->debug)
$this->setError("", $this->_SQL);
if ($this->mysql_error)
$result = mysqli_query($this->link_db, $this->_SQL) or die($this->setError("" . $this->_SQL . "] ", mysqli_error($this->link_db) . ""));
else
$result = mysqli_query($this->link_db, $this->_SQL);
$GLOBALS['SysValue']['sql']['num']++;
return $result;
}
function trace($var) {
echo '<pre>';
print_r($var);
echo "</pre>";
}
function insert($value, $prefix = '_new') {
$this->_SQL = 'insert into ' . $this->objBase . ' set ';
$_KEY = $this->findKey();
foreach ($_KEY as $key => $v)
if (isset($value[$key . $prefix])) {
$this->_SQL.="`" . $key . "`='" . @addslashes($value[$key . $prefix]) . "',";
}
$this->_SQL = substr($this->_SQL, 0, strlen($this->_SQL) - 1);
if (!empty($this->sql))
$this->_SQL = $this->sql;
if ($this->debug)
$this->setError("", $this->_SQL);
if (mysqli_query($this->link_db, $this->_SQL))
return mysqli_insert_id($this->link_db);
else
return mysqli_error($this->link_db);
}
function clean() {
$this->nWhere = 1;
$this->nSelect = 1;
$this->_SQL = '';
unset($this->_DATA);
}
function updateZeroVars() {
$Arg = func_get_args();
foreach ($Arg as $value) {
if (strpos($value, '.')) {
$param = explode(".", $value);
if (empty($_POST[$param[0]][$param[1]]))
$_POST[$param[0]][$param[1]] = 0;
}
else if (empty($_POST[$value]))
$_POST[$value] = 0;
}
}
}
function stripslashes_deep($value) {
$value = is_array($value) ?
array_map('stripslashes_deep', $value) :
stripslashes($value);
return $value;
}
?>