✏️ Edit: objcreate.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/modules/objcreate.php
Size: 3.07 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/objcreate.php * @author Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ function processRequest(&$db) { // $_REQUEST[name] may contain the schema id, e.g. 'public.Tables' $refresh = false; $type = "message ui-state-highlight"; if (isset($_REQUEST["objinfo"])) { $msg = createDatabaseObject($db, $_REQUEST["id"], $_REQUEST["objinfo"]); if (!$msg) { // msg will be returned only if error (bad programming guys, dont learn from it !) $msg = __('The command executed successfully'); $type = "message ui-state-default"; $refresh = true; } else $type="message ui-state-error"; } else $msg = __('Any existing object with the same name should be dropped manually before executing the creation command') .'!<br />' .__('Enter command for object creation'); displayCreateObjectForm($db, $msg, $type, $refresh); } function displayCreateObjectForm(&$db, $msg, $type, $refresh) { $id = $_REQUEST["id"]; if (isset($_REQUEST["objinfo"])) $objInfo = htmlspecialchars($_REQUEST["objinfo"]); else $objInfo = getObjectCreateCommand($db, $id); print "</textarea></td></tr>"; $min = file_exists('js/min/minify.txt'); $js = $min ? 'codemirror' : 'editor/codemirror'; $editor_link = "<script type=\"text/javascript\" language=\"javascript\" src=\"cache.php?script=$js\"></script>"; $editor_options = $min ? 'basefiles: ["js/min/codemirror_base.js"]' : 'parserfile: "mysql.js", path: "js/editor/"'; $replace = array('ID' => htmlspecialchars($id), 'MESSAGE' => $msg, 'MESSAGE_TYPE' => $type, 'OBJINFO' => $objInfo, 'EDITOR_LINK' => $editor_link, 'EDITOR_OPTIONS' => $editor_options, 'REFRESH' => $refresh ? '1' : '0' ); echo view('objcreate', $replace); } function getObjectCreateCommand(&$db, $id) { $folder = $db->name() . '/templates'; $x = ''; switch($id) { case 0: $x = view(array($folder.'/table', 'templates/table')); break; case 1: $x = view(array($folder.'/view', 'templates/view')); break; case 2: $x = view(array($folder.'/procedure', 'templates/procedure')); break; case 3: $x = view(array($folder.'/function', 'templates/function')); break; case 4: $x = view(array($folder.'/trigger', 'templates/trigger')); break; case 5: $x = view(array($folder.'/event', 'templates/event')); break; case 6: $x = view(array($folder.'/schema', 'templates/schema')); break; } return htmlspecialchars($x); } function createDatabaseObject(&$db, $id, $info) { $cmd = trim($info); if (strtolower(substr($cmd, 0, 6)) != "create") return __('Only create commands are accepted'); if (!$db->query($cmd)) return htmlspecialchars($db->getError()); $warnings = $db->getWarnings(); if (count($warnings) > 0) { foreach($warnings as $code=>$warning) return htmlspecialchars($warning); // return the first warning (for this module always true) } return ""; } ?>
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF