if (strlen($field["field"])) {
$set[] = (in_array($field["inout"], $inout) ? "{$field['inout']} " : "") . idf_escape($field["field"]) . process_type($field, "CHARACTER SET");
}
}
if ($mysql->query("CREATE {$routine} " . idf_escape($_POST["name"]) . " (" . implode(", ", $set) . ")" . (isset($_GET["function"]) ? " RETURNS" . process_type($_POST["returns"], "CHARACTER SET") : "") . "\n\t\t\t{$_POST['definition']}")) {
redirect(substr($SELF, 0, -1), strlen($_GET["procedure"]) ? lang('Routine has been altered.') : lang('Routine has been created.'));
}
}
$error = $mysql->error;
}
page_header(strlen($_GET["procedure"]) ? (isset($_GET["function"]) ? lang('Alter function') : lang('Alter procedure')) . ": " . htmlspecialchars($_GET["procedure"]) : (isset($_GET["function"]) ? lang('Create function') : lang('Create procedure')), $error);
$collations = get_vals("SHOW CHARACTER SET");
if ($_POST) {
$row = $_POST;
$row["fields"] = (array) $row["fields"];
process_fields($row["fields"]);
} elseif (strlen($_GET["procedure"])) {
$row = routine($_GET["procedure"], $routine);
$row["name"] = $_GET["procedure"];
} else {
$row = array("fields" => array());
}
?>
<form action="" method="post" id="form">
<table border="0" cellspacing="0" cellpadding="2">
<?php
edit_fields($row["fields"], $collations, $routine);
if (isset($_GET["function"])) {
?>
<tr><td><?php
}
$orig_fields = array();
$table_status = array();
if ($TABLE != "") {
$orig_fields = fields($TABLE);
$table_status = table_status($TABLE);
if (!$table_status) {
$error = lang('No tables.');
}
}
$row = $_POST;
$row["fields"] = (array) $row["fields"];
if ($row["auto_increment_col"]) {
$row["fields"][$row["auto_increment_col"]]["auto_increment"] = true;
}
if ($_POST && !process_fields($row["fields"]) && !$error) {
if ($_POST["drop"]) {
queries_adminer_redirect(substr(ME, 0, -1), lang('Table has been dropped.'), drop_tables(array($TABLE)));
} else {
$fields = array();
$all_fields = array();
$use_all_fields = false;
$foreign = array();
ksort($row["fields"]);
$orig_field = reset($orig_fields);
$after = " FIRST";
foreach ($row["fields"] as $key => $field) {
$foreign_key = $foreign_keys[$field["type"]];
$type_field = $foreign_key !== null ? $referencable_primary[$foreign_key] : $field;
//! can collide with user defined type
if ($field["field"] != "") {
<?php
$fp = fopen('fixed-width-records.txt', 'r', true) or die("can't open file");
while ($s = fgets($fp, 1024)) {
$fields[1] = substr($s, 0, 25);
// first field: first 25 characters of the line
$fields[2] = substr($s, 25, 15);
// second field: next 15 characters of the line
$fields[3] = substr($s, 40, 4);
// third field: next 4 characters of the line
$fields = array_map('rtrim', $fields);
// strip the trailing whitespace
// a function to do something with the fields
process_fields($fields);
}
fclose($fp) or die("can't close file");
