✏️ Edit: enginetype.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/modules/enginetype.php
Size: 1.85 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php /** * This file is a part of MyWebSQL package * * @file: modules/enginetype.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { $action = v($_REQUEST["id"]); include(BASE_PATH . "/lib/tableeditor.php"); $editor = new tableEditor($db); $editor->setName(v($_REQUEST["name"])); $editor->loadTable(false, false, true); $message = ''; if ($action == "alter") { $result = alterTableEngine($db, v($_REQUEST["enginetype"]), $editor); $formatted_query = preg_replace("/[\\n|\\r]?[\\n]+/", "<br>", htmlspecialchars($editor->getSql())); if ($result) { $message = '<div id="message">' .'<div class="message ui-state-default">'.__('The command executed successfully').'.</div>' //.'<div class="sql-text ui-state-default">'.$formatted_query.'</div>' .'</div>'; } else { $message = '<div id="message">' .'<div class="message ui-state-error">'.__('Error occurred while executing the query').':</div>' .'<div class="message ui-state-highlight">'.htmlspecialchars($db->getError()).'</div>' .'<div class="sql-text ui-state-error">'.$formatted_query.'</div>' .'</div>'; } } $props = $editor->getProperties(); include(BASE_PATH . '/lib/html.php'); $engines = html::arrayToOptions($db->getEngines(), $props->engine, true); $replace = array( 'TABLE_NAME' => htmlspecialchars($editor->getName()), 'ENGINE' => $engines, 'MESSAGE' => $message, ); echo view('enginetype', $replace); } function alterTableEngine(&$db, $engineType, &$editor) { $props = $editor->getProperties(); $props->engine = $engineType; $editor->setProperties($props); $sql = $editor->getAlterStatement(); if (!$db->query($sql)) return false; return true; } ?>
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF