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;
