Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Tree: d0a58270cc
Fetching contributors…

Cannot retrieve contributors at this time

135 lines (133 sloc) 6.126 kB
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!-- template designed by Marco Von Ballmoos -->
<title></title>
<link rel="stylesheet" href="media/stylesheet.css" />
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
</head>
<body>
<a name="top"></a>
<h2>[QueryExplain] element index</h2>
<h3>Package indexes</h3>
<ul>
<li><a href="elementindex_MySQLTableReport.html">MySQLTableReport</a></li>
<li><a href="elementindex_default.html">default</a></li>
<li><a href="elementindex_QueryTableParser.html">QueryTableParser</a></li>
<li><a href="elementindex_Loader.html">Loader</a></li>
<li><a href="elementindex_Anemometer.html">Anemometer</a></li>
<li><a href="elementindex_AnemometerModel.html">AnemometerModel</a></li>
</ul>
<a href="elementindex.html">All elements</a>
<br />
<div class="index-letter-menu">
<a class="index-letter" href="elementindex_QueryExplain.html#e">e</a>
<a class="index-letter" href="elementindex_QueryExplain.html#g">g</a>
<a class="index-letter" href="elementindex_QueryExplain.html#q">q</a>
<a class="index-letter" href="elementindex_QueryExplain.html#r">r</a>
<a class="index-letter" href="elementindex_QueryExplain.html#_">_</a>
</div>
<a name="_"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">_</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">__construct</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#method__construct">QueryExplain::__construct()</a> in QueryExplain.php</div>
<div class="index-item-description">Constructor. See class documentation for explaination of the parameters</div>
</dd>
</dl>
<a name="e"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">e</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">explain</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#methodexplain">QueryExplain::explain()</a> in QueryExplain.php</div>
<div class="index-item-description">If the given query is a SELECT statement, return the explain plan</div>
</dd>
</dl>
<a name="g"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">g</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">get_create</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#methodget_create">QueryExplain::get_create()</a> in QueryExplain.php</div>
<div class="index-item-description">Extract the table names from a query, and return the result of SHOW CREATE TABLE tablename;</div>
</dd>
<dt class="field">
<span class="method-title">get_tables_from_query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#methodget_tables_from_query">QueryExplain::get_tables_from_query()</a> in QueryExplain.php</div>
<div class="index-item-description">Try to parse the real table names out of a sql query</div>
</dd>
<dt class="field">
<span class="method-title">get_table_status</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#methodget_table_status">QueryExplain::get_table_status()</a> in QueryExplain.php</div>
<div class="index-item-description">Extract the table names and the return the result of SHOW TABLE STATUS LIKE 'tablename' for each table;</div>
</dd>
</dl>
<a name="q"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">q</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
QueryExplain
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html">QueryExplain</a> in QueryExplain.php</div>
<div class="index-item-description">class QueryExplain rough utility class to get query explain plan and extract table names from abitrary sql so we can run show create table on them.</div>
</dd>
<dt class="field">
<span class="include-title">QueryExplain.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/_QueryExplain.php.html">QueryExplain.php</a> in QueryExplain.php</div>
</dd>
</dl>
<a name="r"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">r</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">result_as_table</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="QueryExplain/QueryExplain.html#methodresult_as_table">QueryExplain::result_as_table()</a> in QueryExplain.php</div>
<div class="index-item-description">given a mysqli result handle, format a string to look like the mysql cli</div>
</dd>
</dl>
<div class="index-letter-menu">
<a class="index-letter" href="elementindex_QueryExplain.html#e">e</a>
<a class="index-letter" href="elementindex_QueryExplain.html#g">g</a>
<a class="index-letter" href="elementindex_QueryExplain.html#q">q</a>
<a class="index-letter" href="elementindex_QueryExplain.html#r">r</a>
<a class="index-letter" href="elementindex_QueryExplain.html#_">_</a>
</div> </body>
</html>
Jump to Line
Something went wrong with that request. Please try again.