2024-03-04 22:57:28 +08:00
|
|
|
|
|
|
|
|
<!doctype html>
|
|
|
|
|
<html lang="en">
|
|
|
|
|
<head>
|
|
|
|
|
<meta charset="utf-8">
|
|
|
|
|
<meta name="viewport" content="width=device-width">
|
|
|
|
|
|
|
|
|
|
<title>File system\helper\db_schema.php | OpenCart API API</title>
|
2024-03-04 23:29:14 +08:00
|
|
|
<link rel="stylesheet" href="http://localhost\opencart-master/docs/api/assets/main.css">
|
|
|
|
|
<script src="http://localhost\opencart-master/docs/api/assets/main.js" defer></script>
|
2024-03-04 22:57:28 +08:00
|
|
|
</head>
|
|
|
|
|
|
|
|
|
|
<body class="layout">
|
|
|
|
|
<div class="layout-aside">
|
|
|
|
|
<div class="menu">
|
|
|
|
|
<div class="menu-section">
|
|
|
|
|
<h3>Namespaces</h3>
|
|
|
|
|
<ul>
|
|
|
|
|
<li class="menuGroup-item">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.html">Opencart</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
<ul>
|
|
|
|
|
<li class="menuGroup-item">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Admin.html">Admin</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
<li class="menuGroup-item">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.Catalog.html">Catalog</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
<li class="menuGroup-item">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-Opencart.System.html">System</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
</ul>
|
|
|
|
|
</li>
|
|
|
|
|
<li class="menuGroup-item active">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-none.html">none</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
</ul>
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<div class="menu-section">
|
|
|
|
|
<h3>Functions</h3>
|
|
|
|
|
<ul>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_bbcode_decode.html">
|
|
|
|
|
oc_bbcode_decode
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_length.html">
|
|
|
|
|
oc_validate_length
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_email.html">
|
|
|
|
|
oc_validate_email
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_ip.html">
|
|
|
|
|
oc_validate_ip
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_filename.html">
|
|
|
|
|
oc_validate_filename
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_url.html">
|
|
|
|
|
oc_validate_url
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_validate_seo_url.html">
|
|
|
|
|
oc_validate_seo_url
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_strlen.html">
|
|
|
|
|
oc_strlen
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_strpos.html">
|
|
|
|
|
oc_strpos
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_strrpos.html">
|
|
|
|
|
oc_strrpos
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_substr.html">
|
|
|
|
|
oc_substr
|
2024-03-04 23:29:14 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_strtoupper.html">
|
|
|
|
|
oc_strtoupper
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_strtolower.html">
|
|
|
|
|
oc_strtolower
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_token.html">
|
|
|
|
|
oc_token
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-str_starts_with.html">
|
|
|
|
|
str_starts_with
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-str_ends_with.html">
|
|
|
|
|
str_ends_with
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-05 14:20:21 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_filter_keyword.html">
|
|
|
|
|
oc_filter_keyword
|
2024-03-04 22:57:28 +08:00
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li class="active">
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_db_create.html">
|
2024-03-04 22:57:28 +08:00
|
|
|
oc_db_create
|
|
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
<li>
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/function-oc_db_schema.html">
|
2024-03-04 22:57:28 +08:00
|
|
|
oc_db_schema
|
|
|
|
|
</a>
|
|
|
|
|
</li>
|
|
|
|
|
</ul>
|
|
|
|
|
</div>
|
|
|
|
|
</div>
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<div class="layout-main">
|
|
|
|
|
<div class="layout-navbar">
|
|
|
|
|
<nav class="navbar">
|
|
|
|
|
<div class="navbar-left">
|
|
|
|
|
<ul class="navbar-links">
|
|
|
|
|
<li>
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/index.html">Overview</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
<li>
|
|
|
|
|
|
2024-03-04 23:29:14 +08:00
|
|
|
<a href="http://localhost\opencart-master/docs/api/namespace-none.html">Namespace</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
|
|
|
|
|
</li>
|
2024-03-04 23:29:14 +08:00
|
|
|
<li class="active"><a href="http://localhost\opencart-master/docs/api/function-oc_db_create.html">Function</a></li> <li>
|
|
|
|
|
<a href="http://localhost\opencart-master/docs/api/tree.html">Tree</a>
|
2024-03-04 22:57:28 +08:00
|
|
|
</li>
|
|
|
|
|
</ul>
|
|
|
|
|
</div>
|
|
|
|
|
<div class="navbar-right">
|
2024-03-04 23:29:14 +08:00
|
|
|
<div class="search" data-elements="http://localhost\opencart-master/docs/api/assets/elements.js">
|
2024-03-04 22:57:28 +08:00
|
|
|
<input class="search-input" placeholder="Search class, function or namespace" autofocus>
|
|
|
|
|
<ul class="search-results"></ul>
|
|
|
|
|
</div>
|
|
|
|
|
</div>
|
|
|
|
|
</nav>
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<div class="layout-content">
|
|
|
|
|
<table class="source"><tr id="1" class="source-line"><td><a class="source-lineNum" href="#1"> 1: </a></td><td><span class="php-tag"><?php
</span></td></tr><tr id="2" class="source-line"><td><a class="source-lineNum" href="#2"> 2: </a></td><td><span class="php-tag"></span><span class="php-kw">function</span> oc_db_create(string <span class="php-var">$db_driver</span>, string <span class="php-var">$db_hostname</span>, string <span class="php-var">$db_username</span>, string <span class="php-var">$db_password</span>, string <span class="php-var">$db_database</span>, string <span class="php-var">$db_port</span>, string <span class="php-var">$db_prefix</span>, string <span class="php-var">$db_ssl_key</span>, string <span class="php-var">$db_ssl_cert</span>, string <span class="php-var">$db_ssl_ca</span>): bool {
</td></tr><tr id="3" class="source-line"><td><a class="source-lineNum" href="#3"> 3: </a></td><td> <span class="php-kw">try</span> {
</td></tr><tr id="4" class="source-line"><td><a class="source-lineNum" href="#4"> 4: </a></td><td> <span class="php-comment">// Database</span>
</td></tr><tr id="5" class="source-line"><td><a class="source-lineNum" href="#5"> 5: </a></td><td> <span class="php-var">$db</span> = <span class="php-kw">new</span> \Opencart\System\Library\DB(<span class="php-var">$db_driver</span>, <span class="php-var">$db_hostname</span>, <span class="php-var">$db_username</span>, <span class="php-var">$db_password</span>, <span class="php-var">$db_database</span>, <span class="php-var">$db_port</span>, <span class="php-var">$db_ssl_key</span>, <span class="php-var">$db_ssl_cert</span>, <span class="php-var">$db_ssl_ca</span>);
</td></tr><tr id="6" class="source-line"><td><a class="source-lineNum" href="#6"> 6: </a></td><td> } <span class="php-kw">catch</span> (\Exception <span class="php-var">$e</span>) {
</td></tr><tr id="7" class="source-line"><td><a class="source-lineNum" href="#7"> 7: </a></td><td> <span class="php-kw">return</span> <span class="php-kw">false</span>;
</td></tr><tr id="8" class="source-line"><td><a class="source-lineNum" href="#8"> 8: </a></td><td> }
</td></tr><tr id="9" class="source-line"><td><a class="source-lineNum" href="#9"> 9: </a></td><td>
</td></tr><tr id="10" class="source-line"><td><a class="source-lineNum" href="#10"> 10: </a></td><td> <span class="php-comment">// Set up Database structure</span>
</td></tr><tr id="11" class="source-line"><td><a class="source-lineNum" href="#11"> 11: </a></td><td> <span class="php-var">$tables</span> = oc_db_schema();
</td></tr><tr id="12" class="source-line"><td><a class="source-lineNum" href="#12"> 12: </a></td><td>
</td></tr><tr id="13" class="source-line"><td><a class="source-lineNum" href="#13"> 13: </a></td><td> <span class="php-kw">foreach</span> (<span class="php-var">$tables</span> <span class="php-kw">as</span> <span class="php-var">$table</span>) {
</td></tr><tr id="14" class="source-line"><td><a class="source-lineNum" href="#14"> 14: </a></td><td> <span class="php-var">$table_query</span> = <span class="php-var">$db</span>->query(<span class="php-str">"SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = '"</span> . <span class="php-var">$db_database</span> . <span class="php-str">"' AND TABLE_NAME = '"</span> . <span class="php-var">$db_prefix</span> . <span class="php-var">$table</span>[<span class="php-str">'name'</span>] . <span class="php-str">"'"</span>);
</td></tr><tr id="15" class="source-line"><td><a class="source-lineNum" href="#15"> 15: </a></td><td>
</td></tr><tr id="16" class="source-line"><td><a class="source-lineNum" href="#16"> 16: </a></td><td> <span class="php-kw">if</span> (<span class="php-var">$table_query</span>->num_rows) {
</td></tr><tr id="17" class="source-line"><td><a class="source-lineNum" href="#17"> 17: </a></td><td> <span class="php-var">$db</span>->query(<span class="php-str">"DROP TABLE `"</span> . <span class="php-var">$db_prefix</span> . <span class="php-var">$table</span>[
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<div class="layout-footer">
|
|
|
|
|
OpenCart API API documentation generated by <a href="https://www.apigen.org">ApiGen dev-master</a>
|
|
|
|
|
</div>
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<div class="layout-rest">
|
|
|
|
|
<div class="navbar"></div>
|
|
|
|
|
</div>
|
|
|
|
|
</body>
|
|
|
|
|
</html>
|
