function get_fields() { global $tbl_users; global $fields, $field_props; array_splice($fields, 0); // clear out any existing field names array_splice($field_props, 0); // and properties $result = sql_query("select * from {$tbl_users} limit 1"); $nfields = sql_num_fields($result); for ($i = 0; $i < $nfields; $i++) { $field_name = sql_field_name($result, $i); $fields[] = $field_name; $field_props[$field_name]['type'] = sql_field_type($result, $i); $field_props[$field_name]['istext'] = $field_props[$field_name]['type'] == 'string' ? true : false; $field_props[$field_name]['isnum'] = preg_match('/(int|real)/', $field_props[$field_name]['type']) ? true : false; $field_props[$field_name]['isbool'] = $field_props[$field_name]['type'] == 'boolean' ? true : false; } sql_free($result); }
function adminfieldinp($result) { $fields = sql_num_fields($result); $idle = array(); for ($i = 0; $i < $fields; $i++) { // $field_info = sql_fetch_field_direct($result, $i); // if ($field_info->type == 'string') { // $idle[$field_info->name] = $field_info->length; // } $idle['b' . $i] = 'a'; } echo ' <script type="text/javascript"> //<![CDATA[ '; foreach ($idle as $k => $v) { echo $fields; echo ' inpandfieldlen("' . $k . '",' . $v . ')'; } echo ' //]]> </script>'; }
$query = ""; } $pagination = "Limit <input type='text' id='dbLimit' value='" . html_safe($limit) . "' style='width:50px;'>\n\t\t\t\t\t\t\t\t<span class='button' onclick=\"db_pagination('prev');\">prev</span>\n\t\t\t\t\t\t\t\t<span class='button' onclick=\"db_pagination('next');\">next</span>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbDB' value='" . html_safe($db) . "'>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbTable' value='" . html_safe($table) . "'>\n\t\t\t\t\t\t\t\t<input type='hidden' id='dbStart' value='" . html_safe($start) . "'>\n\t\t\t\t\t\t\t\t"; } $querys = explode(";", $query); foreach ($querys as $query) { if (trim($query) != "") { $query_query = sql_query($type, $query, $con); if ($query_query != false) { $res .= "<p>" . html_safe($query) . "; <span class='strong'>[</span> ok <span class='strong'>]</span></p>"; if (!empty($pagination)) { $res .= "<p>" . $pagination . "</p>"; } if (!is_bool($query_query)) { $res .= "<table class='border dataView sortable tblResult'><tr>"; for ($i = 0; $i < sql_num_fields($type, $query_query); $i++) { $res .= "<th>" . html_safe(sql_field_name($type, $query_query, $i)) . "</th>"; } $res .= "</tr>"; while ($rows = sql_fetch_data($type, $query_query)) { $res .= "<tr>"; foreach ($rows as $r) { if (empty($r)) { $r = " "; } $res .= "<td>" . html_safe($r) . "</td>"; } $res .= "</tr>"; } $res .= "</table>"; }
$nusers = sql_query1("select count(*) from {$tbl_users}"); if ($nusers == -1) { /* Then create it */ $cmd = "\nCREATE TABLE {$tbl_users}\n(\n /* The first four fields are required. Don't remove or reorder. */\n id int NOT NULL auto_increment,\n name varchar(30),\n password varchar(40),\n email varchar(75),\n\n /* The following fields are application-specific. However only int and varchar are editable. */\n\n\n PRIMARY KEY (id)\n);"; $r = sql_command($cmd); if ($r == -1) { // No need to localize this: Only the admin running this for the first time would see it. print "<p class=\"error\">Error creating the {$tbl_users} table.</p>\n"; print "<p class=\"error\">" . sql_error() . "</p>\n"; exit; } $nusers = 0; } /* Get the list of fields actually in the table. (Allows the addition of new fields later on) */ $result = sql_query("select * from {$tbl_users} limit 1"); $nfields = sql_num_fields($result); for ($i = 0; $i < $nfields; $i++) { $field_name = sql_field_name($result, $i); $fields[] = $field_name; $field_props[$field_name]['type'] = sql_field_type($result, $i); $field_props[$field_name]['istext'] = $field_props[$field_name]['type'] == 'string' ? true : false; $field_props[$field_name]['isnum'] = preg_match('/(int|real)/', $field_props[$field_name]['type']) ? true : false; } sql_free($result); /* Get localized field name */ function get_loc_field_name($name) { global $vocab; // Search for indexes "user_name", "user_password", etc, in the localization array. if (isset($vocab["user_" . $name])) { return get_vocab("user_" . $name);
if (!isset($p['pg'])) { $p['pg'] = 1; } $start = ((int) $p['pg'] - 1) * $config['SQLLimit']; $oracleLimit = $start + $config['SQLLimit']; $sBuff = ''; $con = sql_connect($p['type'], $p['host'], $p['user'], $p['pass']); foreach (explode(';', $p['code']) as $query) { if (trim($query) !== '') { $query = str_replace(array('{start}', '{limit}', '{oraclelimit}'), array($start, $config['SQLLimit'], $oracleLimit), $query); $sBuff .= '<hr /><p><b>' . tText('sq8', 'Executed') . ':</b> ' . hsc($query) . '; '; $res = sql_query($p['type'], $query, $con); if ($res !== false && !is_bool($res)) { $pag = genPaginator($p['pg'], -1, false) . '<br>'; $sBuff .= "<b>[ ok ]</b></p><br>{$pag}<table id='sort' class='explore sortable' style='width:100%;'><tr>"; $t = sql_num_fields($p['type'], $res, $con); for ($i = 0; $i < $t; $i++) { $sBuff .= '<th class="touch">' . @hsc(sql_field_name($p['type'], $res, $i)) . '</th>'; } $sBuff .= '</tr>'; while ($rows = sql_fetch_data($p['type'], $res)) { $sBuff .= '<tr>'; foreach ($rows as $r) { $sBuff .= '<td>' . @hsc($r) . '</td>'; } $sBuff .= '</tr>'; } $sBuff .= "</table><br>{$pag}"; } else { $sBuff .= '<b>[ ERROR ]</b></p><br>'; }
$show_form = true; $show_dbs = true; if (isset($_REQUEST['connect'])) { $con = sql_connect($sqltype, $sqlhost, $sqluser, $sqlpass); $sqlcode = isset($_REQUEST['sqlcode']) ? ssc($_REQUEST['sqlcode']) : ""; if ($con !== false) { $show_form = false; $s_result .= "<form action='" . $s_self . "db' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . $sqlhost . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . $sqlport . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . $sqluser . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . $sqlpass . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . $sqltype . "' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . $sqlcode . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>"; if (!empty($sqlcode)) { $querys = explode(";", $sqlcode); foreach ($querys as $query) { if (trim($query) != "") { $hasil = sql_query($sqltype, $query, $con); if ($hasil != false) { $s_result .= "<p style='padding:0;margin:6px 10px;font-weight:bold;'>" . $query . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>\n\t\t\t\t\t\t\t\t<table class='explore sortable' style='width:100%;'><tr>"; for ($i = 0; $i < sql_num_fields($sqltype, $hasil); $i++) { $s_result .= "<th>" . @hss(sql_field_name($sqltype, $hasil, $i)) . "</th>"; } $s_result .= "</tr>"; while ($rows = sql_fetch_data($sqltype, $hasil)) { $s_result .= "<tr>"; foreach ($rows as $r) { if (empty($r)) { $r = " "; } $s_result .= "<td>" . @hss($r) . "</td>"; } $s_result .= "</tr>"; } $s_result .= "</table>"; } else {
$s_c_num = substr(md5(time() . rand(0, 100)), 0, 3); } setcookie("c[" . $s_c_num . "]", $s_sql_cookie, time() + $s_login_time); } $s_show_form = false; $s_result .= "<form action='" . $s_self . "' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . hss($s_sql['host']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . hss($s_sql['port']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . hss($s_sql['user']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . hss($s_sql['pass']) . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . hss($s_sql['type']) . "' />\n\t\t\t\t\t<input type='hidden' name='x' value='db' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . hss($s_sqlcode) . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>"; if (!empty($s_sqlcode)) { $s_querys = explode(";", $s_sqlcode); foreach ($s_querys as $s_query) { if (trim($s_query) != "") { $s_hasil = sql_query($s_sql['type'], $s_query, $s_con); if ($s_hasil != false) { $s_result .= "<hr /><p style='padding:0;margin:6px 10px;font-weight:bold;'>" . hss($s_query) . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>"; if (!is_bool($s_hasil)) { $s_result .= "<table class='explore sortable' style='width:100%;'><tr>"; for ($s_i = 0; $s_i < sql_num_fields($s_sql['type'], $s_hasil); $s_i++) { $s_result .= "<th>" . @hss(sql_field_name($s_sql['type'], $s_hasil, $s_i)) . "</th>"; } $s_result .= "</tr>"; while ($s_rows = sql_fetch_data($s_sql['type'], $s_hasil)) { $s_result .= "<tr>"; foreach ($s_rows as $s_r) { if (empty($s_r)) { $s_r = " "; } $s_result .= "<td>" . @hss($s_r) . "</td>"; } $s_result .= "</tr>"; } $s_result .= "</table>"; }
/** * Creates a dump of the table content for one table */ function _backup_dump_contents($tablename) { // // Grab the data from the table. // $result = sql_query("SELECT * FROM {$tablename}"); if (sql_num_rows($result) > 0) { echo "\n#\n# " . sprintf(_BACKUP_BACKUPFILE_TABLEDATAFOR, $tablename) . "\n#\n"; } $num_fields = sql_num_fields($result); // // Compose fieldname list // $tablename_list = $this->_backup_get_field_names($result, $num_fields); // // Loop through the resulting rows and build the sql statement. // while ($row = sql_fetch_array($result)) { // Start building the SQL statement. echo "INSERT INTO `" . $tablename . "` {$tablename_list} VALUES("; // Loop through the rows and fill in data for each column for ($j = 0; $j < $num_fields; $j++) { if (!isset($row[$j])) { // no data for column echo ' NULL'; } elseif ($row[$j] != '') { // data echo " '" . sql_real_escape_string($row[$j]) . "'"; } else { // empty column (!= no data!) echo "''"; } // only add comma when not last column if ($j != $num_fields - 1) { echo ","; } } echo ");\n"; } echo "\n"; }
} return 1; } */ if (isset($p['sqlcode'])) { $sBuff = ''; $con = sql_connect($p['sqltype'], $p['sqlhost'], $p['sqluser'], $p['sqlpass']); foreach (explode(';', $p['sqlcode']) as $query) { if (trim($query) !== '') { $res = sql_query($p['sqltype'], $query, $con); if ($res !== false) { $sBuff .= '<hr /><p style="padding:0;margin:6px 10px;font-weight:bold;">' . hsc($query) . '; <span>[ ok ]</span></p>'; if (!is_bool($res)) { $sBuff .= '<table id="sort" class="explore sortable" style="width:100%;"><tr>'; for ($i = 0; $i < sql_num_fields($p['sqltype'], $res, $con); $i++) { $sBuff .= '<th>' . @hsc(sql_field_name($p['sqltype'], $res, $i)) . '</th>'; } $sBuff .= '</tr>'; while ($rows = sql_fetch_data($p['sqltype'], $res)) { $sBuff .= '<tr>'; foreach ($rows as $r) { //if ($r === '') $r = ' '; $sBuff .= '<td>' . @hsc($r) . '</td>'; } $sBuff .= '</tr>'; } $sBuff .= '</table>'; } } else { $sBuff .= '<p style="padding:0;margin:6px 10px;font-weight:bold;">' . hsc($query) . '; <span>[ error ]</span></p>';
function query_to_array($query, $conn) { $csv = array(); $resource = sql_query($query, $conn); if ($resource) { $row = array(); for ($i = 0; $i < sql_num_fields($resource); $i++) { $row[] = sql_field_name($resource, $i); } $csv[] = $row; } while ($item = sql_fetch_array($resource)) { $row = array(); for ($i = 0; $i < sql_num_fields($resource); $i++) { $row[] = $item[$i]; } $csv[] = $row; } return $csv; }
function topicedit($topicid) { global $hlpfile, $tipath, $NPDS_Prefix, $f_meta_nom, $f_titre, $adminimg, $radminsuper; include "header.php"; GraphicAdmin($hlpfile); $result = sql_query("SELECT topicid, topicname, topicimage, topictext, topicadmin FROM " . $NPDS_Prefix . "topics WHERE topicid='{$topicid}'"); list($topicid, $topicname, $topicimage, $topictext, $topicadmin) = sql_fetch_row($result); adminhead($f_meta_nom, $f_titre, $adminimg); echo '<h3>' . adm_translate("Editer le Sujet :") . ' ' . aff_langue($topictext) . '</h3>'; if ($topicimage != "") { echo ' <div class="thumbnail"> <img class="img-fluid " src="' . $tipath . $topicimage . '" alt="" /> </div>'; } echo ' <form class="form-horizontal" role="form" action="admin.php" method="post"> <fieldset> <div class="form-group"> <label class="col-sm-4" for="topicname">' . adm_translate("Intitulé") . '</label> <div class="col-sm-8"> <input id="topicname" class="form-control" type="text" name="topicname" maxlength="20" value="' . $topicname . '" placeholder="' . adm_translate("cesiteestgénial") . '" /> <span class="help-block">' . adm_translate("(un simple nom sans espaces)") . ' - ' . adm_translate("max caractères") . ' : <span id="countcar_topicname"></span></span> </div> </div> <div class="form-group"> <label class="col-sm-4" for="topictext">' . adm_translate("Texte") . '</label> <div class="col-sm-8"> <textarea id="topictext" class="form-control" rows="3" name="topictext" maxlength="250" placeholder="' . adm_translate("ce site est génial") . '">' . $topictext . '</textarea> <span class="help-block">' . adm_translate("(description ou nom complet du sujet)") . ' - ' . adm_translate("max caractères") . ' : <span id="countcar_topictext"></span></span> </div> </div> <div class="form-group"> <label class="col-sm-4" for="topicimage">' . adm_translate("Image") . '</label> <div class="col-sm-8"> <input id="topicimage" class="form-control" type="text" name="topicimage" size="21" maxlength="20" value="' . $topicimage . '" placeholder="genial.png" /> <span class="help-block">' . adm_translate("(nom de l'image + extension)") . ' (' . $tipath . '). - ' . adm_translate("max caractères") . ' : <span id="countcar_topicimage"></span></span> </div> </div> <div class="form-group"> <label class="col-sm-4" for="topicadmin">' . adm_translate("Administrateur(s) du sujet") . '</label> <div class="col-sm-8"> <div class="input-group"> <span class="input-group-btn"> <button class="btn btn-primary"><i class="fa fa-user fa-lg"></i></button> </span> <input id="topicadmin" class="form-control" type="text" name="topicadmin" maxlength="255" value="' . $topicadmin . '" /> </div> </div> </div> </fieldset> <fieldset> <h4>' . adm_translate("Ajouter des Liens relatifs au Sujet") . '</h4> <div class="form-group"> <label class="col-sm-4" for="name">' . adm_translate("Nom du site") . '</label> <div class="col-sm-8"> <input class="form-control" type="text" name="name" id="name" maxlength="30" /> <span class="help-block">' . adm_translate("max caractères") . ' : <span id="countcar_name"></span></span> </div> </div> <div class="form-group"> <label class="col-sm-4" for="url">' . adm_translate("URL") . '</label> <div class="col-sm-8"> <input class="form-control" type="url" name="url" id="url" maxlength="200" placeholder="http://www.valideurl.org" /> <span class="help-block">' . adm_translate("max caractères") . ' : <span id="countcar_url"></span></span> </div> </div> </fieldset> <input type="hidden" name="topicid" value="' . $topicid . '" /> <input type="hidden" name="op" value="topicchange" /> <div class="form-group"> <div class="col-sm-offset-4 col-sm-8"> <div class="btn-group" role="group" aria-label="..."> <button class="btn btn-primary" type="submit"><i class="fa fa-check-square fa-lg"></i> ' . adm_translate("Sauver les modifications") . '</button> <button class="btn btn-default" onclick="javascript:document.location.href=\'admin.php?op=topicsmanager\'">' . adm_translate("Retour en arrière") . '</button> <button class="btn btn-danger"><i class="fa fa-trash-o fa-lg"></i> ' . adm_translate("Effacer le Sujet !") . '</button> </div> </div> </div> </form> <form id="fad_deltop" action="admin.php" method="post"> <input type="hidden" name="topicid" value="' . $topicid . '" /> <input type="hidden" name="op" value="topicdelete" /> </form>'; echo '<h3>' . adm_translate("Gérer les Liens Relatifs : ") . ' ' . aff_langue($topictext) . '</h3>'; $res = sql_query("SELECT rid, name, url FROM " . $NPDS_Prefix . "related WHERE tid='{$topicid}'"); echo ' <table id="tad_linkrel" data-toggle="table" data-striped="true" data-icons="icons" data-icons-prefix="fa"> <thead> <th data-sortable="true" >' . adm_translate('Nom') . '</th> <th data-sortable="true">' . adm_translate('Url') . '</th> <th>' . adm_translate('Fonctions') . '</th> </thead> <tbody> '; while (list($rid, $name, $url) = sql_fetch_row($res)) { echo ' <tr> <td>' . $name . '</td> <td><a href="' . $url . '" target="_blank">' . $url . '</a></td> <td> <a href="admin.php?op=relatededit&tid=' . $topicid . '&rid=' . $rid . '" class="noir"><i class="fa fa-edit fa-lg" data-toggle="tooltip" title="' . adm_translate("Editer") . '"></i></a> <a href="' . $url . '" target="_blank"><i class="fa fa-external-link fa-lg"></i></a> <a href="admin.php?op=relateddelete&tid=' . $topicid . '&rid=' . $rid . '" class=""><i class="fa fa-trash-o fa-lg text-danger" data-toggle="tooltip" title="' . adm_translate("Effacer") . '"></i></a> </td> </tr>'; } echo ' </tbody> </table>'; $fv_parametres = ' topicadmin: { validators: { callback: { message: "Please choose an administrator from the provided list.", callback: function(value, validator, $field) { diff=""; var value = $field.val(); if (value === "") {return true;} function split( n ) { return n.split( /,\\s*/ ); } diff = $(split(value)).not(admin).get(); console.log(diff); if (diff!="") {return false;} return true; } } } }, topicimage: { validators: { regexp: { regexp: /^[\\w]+\\.(jpg|jpeg|png|gif)$/, message: "This must be a valid file name with one of this extension jpg, jpeg, png, gif." } } }, topicname: { validators: { regexp: { regexp: /^[a-z]+$/i, message: "This must be a simple word without space." } } }, '; $fields = sql_num_fields($result); echo auto_complete_multi('admin', 'aid', 'authors', 'topicadmin', ''); adminfieldinp($result); adminfieldinp($res); adminfoot('fv', $fv_parametres, '', ''); }
function dbSave_tofile($repertoire, $linebyline = 0, $savemysql_size = 256) { global $dbname, $name, $MSos, $crlf, $crlf2; @set_time_limit(600); $date_jour = date(adm_translate("dateforop")); $date_op = date("ymd"); $filename = $dbname . "-" . $date_op; $tables = sql_list_tables($dbname); $num_tables = sql_num_rows($tables); if ($num_tables == 0) { echo " " . adm_translate("Aucune table n'a été trouvée") . "\n"; } else { if (!isset($repertoire) or $repertoire == "") { $repertoire = "."; } if (!is_dir($repertoire)) { @umask("0000"); @mkdir($repertoire, 0777); $fp = fopen($repertoire . "/index.html", 'w'); fclose($fp); } $heure_jour = date("H:i"); $data0 = "# ========================================================{$crlf}" . "# {$crlf}" . "# Sauvegarde de la base de données : " . $dbname . " {$crlf}" . "# Effectuée le " . $date_jour . " : " . $heure_jour . " par " . $name . " {$crlf}" . "# {$crlf}" . "# ========================================================{$crlf}"; $data1 = ""; $ifile = 0; while ($row = sql_fetch_row($tables)) { $table = $row[0]; $data1 .= "{$crlf}" . "# --------------------------------------------------------{$crlf}" . "# {$crlf}" . "# Structure de la table '" . $table . "' {$crlf}" . "# {$crlf}{$crlf}"; $data1 .= get_table_def($table) . "{$crlf}{$crlf}" . "# {$crlf}" . "# Contenu de la table '" . $table . "' {$crlf}" . "# {$crlf}{$crlf}"; $result = sql_query("SELECT * FROM {$table}"); $count_line = sql_num_fields($result); while ($row = sql_fetch_row($result)) { $schema_insert = "INSERT INTO {$table} VALUES ("; for ($j = 0; $j < $count_line; $j++) { if (!isset($row[$j])) { $schema_insert .= " NULL"; } else { if ($row[$j] != "") { $schema_insert .= " '" . PrepareString($row[$j]) . "'"; } else { $schema_insert .= " ''"; } } if ($j < $count_line - 1) { $schema_insert .= ","; } } $schema_insert .= ");{$crlf}"; $data1 .= $schema_insert; if ($linebyline == 1) { if (strlen($data1) > $savemysql_size * 1024) { send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos); $data1 = ""; $ifile++; } } } $data1 .= "{$crlf}{$crlf}" . "# --------------------------------------------------------{$crlf}"; if ($linebyline == 0) { if (strlen($data1) > $savemysql_size * 1024) { send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos); $data1 = ""; $ifile++; } } } if (strlen($data1) > 0) { send_tofile($data0 . $data1, $repertoire, $filename . "-" . sprintf("%03d", $ifile), "sql", $MSos); $data1 = ""; $ifile++; } } }
$s_show_form = true; $s_show_dbs = true; if (isset($_REQUEST['connect'])) { $s_con = sql_connect($s_sqltype, $s_sqlhost, $s_sqluser, $s_sqlpass); $s_sqlcode = isset($_REQUEST['sqlcode']) ? urldecode(ssc($_REQUEST['sqlcode'])) : ""; if ($s_con !== false) { $s_show_form = false; $s_result .= "<form action='" . $s_self . "' method='post'>\n\t\t\t\t\t<input type='hidden' name='sqlhost' value='" . $s_sqlhost . "' />\n\t\t\t\t\t<input type='hidden' name='sqlport' value='" . $s_sqlport . "' />\n\t\t\t\t\t<input type='hidden' name='sqluser' value='" . $s_sqluser . "' />\n\t\t\t\t\t<input type='hidden' name='sqlpass' value='" . $s_sqlpass . "' />\n\t\t\t\t\t<input type='hidden' name='sqltype' value='" . $s_sqltype . "' />\n\t\t\t\t\t<input type='hidden' name='x' value='db' />\n\t\t\t\t\t<input type='hidden' name='connect' value='connect' />\n\t\t\t\t\t<textarea id='sqlcode' name='sqlcode' class='txtarea' style='height:150px;'>" . $s_sqlcode . "</textarea>\n\t\t\t\t\t<p><input type='submit' name='gogo' class='inputzbut' value='Go !' style='width:120px;height:30px;' />\n\t\t\t\t\t Separate multiple commands with a semicolon <span class='gaya'>[</span> ; <span class='gaya'>]</span></p>\n\t\t\t\t\t</form>"; if (!empty($s_sqlcode)) { $s_querys = explode(";", $s_sqlcode); foreach ($s_querys as $s_query) { if (trim($s_query) != "") { $s_hasil = sql_query($s_sqltype, $s_query, $s_con); if ($s_hasil != false) { $s_result .= "<p style='padding:0;margin:6px 10px;font-weight:bold;'>" . $s_query . "; \n\t\t\t\t\t\t\t\t<span class='gaya'>[</span> ok <span class='gaya'>]</span></p>\n\t\t\t\t\t\t\t\t<table class='explore sortable' style='width:100%;'><tr>"; for ($s_i = 0; $s_i < sql_num_fields($s_sqltype, $s_hasil); $s_i++) { $s_result .= "<th>" . @hss(sql_field_name($s_sqltype, $s_hasil, $s_i)) . "</th>"; } $s_result .= "</tr>"; while ($s_rows = sql_fetch_data($s_sqltype, $s_hasil)) { $s_result .= "<tr>"; foreach ($s_rows as $s_r) { if (empty($s_r)) { $s_r = " "; } $s_result .= "<td>" . @hss($s_r) . "</td>"; } $s_result .= "</tr>"; } $s_result .= "</table>"; } else {