function find($type = "all", $options = null) { $mydata; $r = []; $condString = ""; $virtualFieldString = $this->toVirtualFieldString(); if (isset($options['conditions'])) { $condString = $this->buildCond("or", $options['conditions']); } $condString = (empty($condString) ? "" : "where ") . $condString; if (!isset($options['fields'])) { $selector = "* {$virtualFieldString}"; } else { $selector = $this->buildFields($options['fields']); } if (!isset($options["joins"]["left"])) { $leftjoin = ""; } else { $leftjoin = $this->buildLeftjoin($options["joins"]["left"]); } if (!isset($options["group"])) { $groupby = ""; } else { $groupby = $this->buildGroupBy($options["group"]); } switch ($type) { case "first": $result = $this->db->query("" . "select {$selector}" . "from {$this->table} {$this->name} " . "{$leftjoin} " . "{$condString} " . "{$groupby} " . "limit 1"); $mydata = $r[$this->name] = buildResult($result->fetch_fields(), $result->fetch_row()); if (empty($mydata['id'])) { $mydata = $r = []; } break; case "all": $result = $this->db->query("" . "select {$selector} " . "from {$this->table} {$this->name} " . "{$leftjoin} " . "{$condString} " . "{$groupby} "); $mydata = $r = buildResults($result); break; } if (isset($options["contains"]) && !empty($mydata)) { $r = array_merge($r, $this->buildContain($options["contains"], $mydata)); } return $r; }
$XmlMode = $attributes["XmlMode"]; $ProtocolVersion = $attributes["ProtocolVersion"]; $LibraryVersion = $attributes["LibraryVersion"]; $LibraryName = $attributes["LibraryName"]; $ClientName = $attributes["ClientName"]; // Use requested version $xmlRoot->setAttribute("ProtocolVersion", $ProtocolVersion); checkVersion($ProtocolVersion, LIBDVDETECT_PROTOCOL_VERSION); $mysqli = connect_server(); // Check connection if (!$mysqli) { $ResponseText = "Cannot connect to database.\nSQL Error: " . mysqli_connect_error(); throw new Exception($ResponseText, XMLRESULT_SQL_ERROR); } search_dvd($mysqli, $xml, $rsDVDVMGM); $found = buildResults($domtree, $mysqli, $xmlRoot, null, $rsDVDVMGM, $ProtocolVersion); if (!$found) { $Result = XMLRESULT_NOT_FOUND; $ResponseText = "No data found for '" . $xml->Search . "'"; } else { $Result = XMLRESULT_SUCCESS; $ResponseText = "Operation successful"; } // free result set $rsDVDVMGM->close(); $rsDVDVMGM = null; } catch (Exception $e) { $Result = $e->getCode(); $ResponseText = $e->getMessage(); } disconnect_server($mysqli);
<?php ////////////////////////////////////////////// //index.php (TESTING PURPOSES ONLY) ///////////////////////////////////////////// //require the include files require_once 'includes/std.form.class.inc'; require_once 'includes/std.table.class.inc'; require_once 'includes/std.html.class.inc'; require_once 'includes/std.div.class.inc'; require_once 'includes/functions.php'; //testing $html = new html("ChangeLog Management", "style.css"); $results = buildResults("select url as URL, nav_bar as Bar, description as Description from links where active = 1"); $table = buildTable($results); $page = $html->Content($table); $page .= $html->page_end(); echo $page;