PHP Database Wizard:

Return to Start

Error at $file:$line\n"; endif; PrintFoot(); } function FormStart() { Global $PHP_SELF; Global $DB; Global $TABLE; Global $SQL; Global $VIEW; Global $PAGESIZE; Global $IDFIELD; Global $IDTYPE; Global $FIELDS; Global $FIELDNAMES; Global $CAPTIONS; Global $OPTIONS; Global $OPTIONS1; Global $OPTIONS2; Global $CONTROLS; ?>
SQL:  SELECT
\n"; echo "

\n"; FormEnd("Select DB"); echo "\n"; PrintFoot(); elseif ("$cmd" == "Select DB"): //Database selected in $DB variable if (!mysql_select_db($DB)): NotAvailable(__FILE__, __LINE__ . "
" . mysql_error()); exit; endif; $tables = mysql_list_tables($DB); if (!$tables): NotAvailable(__FILE__, __LINE__); exit; endif; PrintHead("Type in SQL or select table"); PrintSqlInput(); echo "
\n"; FormStart(); ?> The error was: "; echo "" . mysql_error() . "\n"; PrintSqlInput(); PrintFoot(); else: // SQL parse ok $fields = mysql_list_fields($result); PrintHead("Select Fields to Show"); FormStart(); ?>

SQL: 'SELECT '

name; $table = $field->table; $maxlength = $field->max_length; $null = $field->not_null ? "No" : "Yes"; $keytype = " "; if ($field->primary_key): $keytype = "Pri"; elseif ($field->unique_key): $keytype = "Uni"; elseif ($field->multiple_key): $keytype = "Mul"; endif; $type = $field->type; echo ""; echo ""; ?>
ColumnTableSizeNull KeyTypeShow asCaption / Name
$name$table$maxlength$null$keytype$type

Show results as: Table UL Separated Records
Records per screen:


\n"; endif; endif; elseif ("$cmd" == "Proceed with selected"): // We have SQL and view type here PrintHead("Preview"); $SQL = stripslashes($SQL); echo "

SQL: 'SELECT $SQL'

\n"; if (!mysql_select_db($DB)): NotAvailable(__FILE__, __LINE__); exit; endif; $HasLimit = eregi("LIMIT", $SQL); if (!$HasLimit): $LSQL = "SELECT $SQL LIMIT $PAGESIZE"; // Prevent huge results transfer endif; $result = mysql_query($LSQL); if ("$VIEW" == "table"): ?> "; echo $CAPTIONS[$i]; echo ""; endif; $i++; endwhile; ?> "; $RecEnd = "\n"; $FieldStart = ""; elseif ("$VIEW" == "list"): echo "
"; $FieldEnd = "
\n"; elseif ("$VIEW" == "list"): echo ""; endif; if (!$HasLimit): ?>

">Next records

\n" . " Not available" . "

Sorry,\n \n is not available

\n" . " Reason: \$reason

\";\n" . " endif;\n ?>\n" . "\n" . "\n" . "\n" . "Query results\n" . "\n" . "\n"; if ("$VIEW" == "table"): $src .= "\n" . "\n"; $i = 0; while ($i < count($FIELDS)): if ($FIELDS[$i] != "Dont" && $FIELDS[$i] != "Hidden"): $src .= ""; endif; $i++; endwhile; $src .= "\n"; $RecStart = ""; $RecEnd = ""; $FieldStart = ""; elseif ("$VIEW" == "list"): $src .= "
    \n"; $RecStart = "
  • "; $RecEnd = "
    • "; $FieldStart = ""; $FieldEnd = ";"; elseif ("$VIEW" == "records"): $RecStart = ""; $RecEnd = "
    "; $FieldStart = "Caption:"; $FieldEnd = "
    "; endif; $src .= "\n \">\n\n"; if ("$FieldStart" == "Caption:"): $src .= " $caption:"; else: $src .= " $FieldStart"; endif; $src .= "\" BORDER=0 ALT=\"$caption\">$FieldEnd\n$caption:\";\n"; else: $src .= " echo \"$FieldStart\";\n"; endif; $src .= " if (\$val):\n" . "?>\n \">$caption\n$caption:\";\n"; else: $src .= " echo \"$FieldStart\";\n"; endif; $src .= " if (\$val):\n" . "?>\n" . " \">$caption\n" . "$caption: "; else: $src .= " echo \"$FieldStart"; endif; $src .= "\$val" . "$FieldEnd\";\n"; break; endswitch; $i++; endwhile; $src .= " echo \"$RecEnd\\n\";\n" . "endwhile;\n?>\n"; if ("$VIEW" == "table"): $src .= "
"; $src .= $CAPTIONS[$i]; $src .= "
"; $FieldEnd = "
\n"; elseif ("$VIEW" == "list"): $src .= ""; endif; if ($PagedOutput): $src .= "

\n" . "Next " . "\$PAGSIZE records\";\n" . "?>\n

\n"; endif; $src .= "\n" . "\n" . "\n"; // echo $src; highlight_string($src); ?>
Add / Delete / Modify form\n"; FormStart(); FormEnd("Add/Edit records", 1); echo "

Table display

\n"; // Just process "SELECT * FROM table" SQL $SQL = "* FROM $TABLE"; FormStart(); FormEnd("Table View", 1); PrintFoot(); elseif ("$cmd" == "Add/Edit records"): // Add / change record form start if (!mysql_select_db($DB)): NotAvailable(__FILE__, __LINE__); exit; endif; if (!($fields = mysql_list_fields($DB, $TABLE))): NotAvailable(__FILE__, __LINE__); exit; endif; PrintHead("Add / Modify form generation ($TABLE)"); FormStart(); ?> "; $name = mysql_field_name($fields, $i); $flags = mysql_field_flags($fields, $i); $len = mysql_field_len($fields, $i); $type = mysql_field_type($fields, $i); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if (eregi("primary", $flags)): $SELECTED = "CHECKED"; else: $SELECTED = ""; endif; echo ""; echo ""; echo ""; echo "\n"; $i++; endwhile; ?>
NameLengthFlags TypeIDCaptionControl
$name$len$flags$type

"); PrintFoot(); elseif ("$cmd" == "Next>"): // Add / change record form continue if (!mysql_select_db($DB)): NotAvailable(__FILE__, __LINE__); exit; endif; if (!($fields = mysql_list_fields($DB, $TABLE))): NotAvailable(__FILE__, __LINE__); exit; endif; PrintHead("Add / modify record form creation ($TABLE)"); FormStart(); ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; $i++; endwhile; ?>
NameLengthType CaptionControlProperty
$name$len$type".$CAPTIONS[$i]."".$CONTROLS[$i].""; switch ($CONTROLS[$i]): case "Auto": case "Now": echo " "; break; case "Integer": case "Float": case "Password": case "Text": echo "Size:"; break; case "Textarea": echo "Cols/Row:"; break; case "Preset": echo "PHP code:<??>"; break; case "Checkbox": echo "Checked value:"; break; case "Radio": echo "Lbl1|Lbl2:"; break; case "Lookup": $tables = mysql_list_tables($DB); echo "Table: "; break; case "Mysql": echo "MySQL function:"; break; case "PHP": echo "PHP function:"; break; endswitch; echo "

>"); PrintFoot(); elseif ("$cmd" == "Next>>"): // Add / change record form continue 2 if (!mysql_select_db($DB)): NotAvailable(__FILE__, __LINE__); exit; endif; if (!($fields = mysql_list_fields($DB, $TABLE))): NotAvailable(__FILE__, __LINE__); exit; endif; PrintHead("Add / modify record form creation ($TABLE)"); FormStart(); ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; $i++; endwhile; ?>
NameLengthType CaptionControlPropertySub 1 Sub 2
$name$len$type".$CAPTIONS[$i]."".$CONTROLS[$i]."".$OPTIONS[$name].""; switch ($CONTROLS[$i]): case "Integer": case "Float": case "Text": echo "Default:"; break; case "Textarea": echo "Default:"; break; case "Checkbox": echo "Default:"; break; case "Radio": echo "Val1|Val2:"; break; case "Lookup": $lookup = mysql_list_fields($DB, $OPTIONS[$name]); echo "Key: "; break; default: echo " "; break; endswitch; echo ""; switch ($CONTROLS[$i]): case "Lookup": $lookup = mysql_list_fields($DB, $OPTIONS[$name]); echo "Display: "; break; default: echo " "; break; endswitch; echo "

\n" . " Not available" . "

Sorry,\n \n is not available

\n" . " Reason: \$reason

\";\n" . " endif;\n?>\n \n" . "\n" . " \n" . " New record ($TABLE)\n" . " \n" . " \n" . " \" METHOD=\"POST\">\n"; $field_num = count($FIELDS); $i = 0; while ($i < $field_num): $name = $FIELDS[$i]; $caption = $CAPTIONS[$i]; $control = $CONTROLS[$i]; $options = $OPTIONS[$name]; $sub1 = $OPTIONS1[$name]; $sub2 = $OPTIONS2[$name]; switch ($control): case "Auto": case "Now": break; case "Integer": case "Float": case "PHP": case "Mysql": case "Text": $size = $options; $default = $sub1; $src .= " \n"; break; case "Password": $size = $options; $src .= " \n" . " \n"; break; case "Textarea": list($cols, $rows) = explode("/", $options); $default = $sub1; $src .= " \n"; break; case "Preset": $src .= " \">\n"; break; case "Checkbox": $val = $options; $checked = $sub1; $src .= " \n"; break; case "Radio": $labels = explode("|", $options); $values = explode("|", $sub1); $src .= " \n"; break; case "Lookup": $src .= " "; break; endswitch; $i++; endwhile; $src .= " " . "\n" . " \n" . "
$caption:" . "
$caption:" . "
$caption:" . "
$caption:" . "
$caption:" . "
$caption:\n"; $j = 0; while ($j < count($values)): $label = $labels[$j]; $val = $values[$j]; $src .= " $label:\n"; $j++; endwhile; $src .= "
$caption:\n" . " \n" . "
\n" . " \n" . " \n" . "\n" . " \n" . " \n" . " Record added\n" . " \n" . " \n" . "

Record added

\n" . " \">Add more\n" . " \n" . " \n" . ""; highlight_string($src); ?>


\n" . " Not available\n" . "

Sorry,\n \n is not available

\n" . " Reason: \$reason

\";\n" . " endif;\n?>\n \n" . "\n" . " \n" . " Edit record ($TABLE)\n" . " \n" . " \n" . " \" METHOD=\"POST\">\n" . " \">\n"; $field_num = count($FIELDS); $i = 0; while ($i < $field_num): $name = $FIELDS[$i]; $caption = $CAPTIONS[$i]; $control = $CONTROLS[$i]; $options = $OPTIONS[$name]; $sub1 = $OPTIONS1[$name]; $sub2 = $OPTIONS2[$name]; switch ($control): case "Auto": case "Now": break; case "Integer": case "Float": case "PHP": case "Mysql": case "Text": $size = $options; $src .= " \n"; break; case "Password": $size = $options; $src .= " \n" . " \n"; break; case "Textarea": list($cols, $rows) = explode("/", $options); $src .= " \n"; break; case "Preset": break; case "Checkbox": $val = $options; $checked = $sub1; $src .= "\n"; $src .= " \n"; break; case "Radio": $labels = explode("|", $options); $values = explode("|", $sub1); $src .= " \n"; break; case "Lookup": $src .= " "; break; /* */ endswitch; $i++; endwhile; $src .= " " . "\n" . " \n" . " \n" . " \n" . "
$caption:" . "\" " . "SIZE=\"$size\">
$caption:" . "\" " . "SIZE=\"$size\">
Retype $caption:" . "\" " . "SIZE=\"$size\">
$caption:" . "
$caption:" . ">
$caption:\n"; $j = 0; while ($j < count($values)): $label = $labels[$j]; $val = $values[$j]; $src .= "\n" . " $label:>\n"; $j++; endwhile; $src .= "
$caption:\n" . " \n" . "
" . "
\n" . "\n" . " \"><<Previous record\n" . "\n" . " \n" . " $idval ORDER BY $IDFIELD LIMIT 1\";\n" . " \$next = mysql_query(\$SQL);\n" . " if (mysql_num_rows(\$next)):\n" . " \$row = mysql_fetch_row(\$next);\n" . " \$nextid = \$row[0];\n" . "?>\n" . " \">Next record>>\n" . "\n" . "
\n" . " \n" . " \n" . "\n" . " \n" . " \n" . " Record updated\n" . " \n" . " \n" . "

Record updated

\n" . " \">What now?\n" . " \n" . " \n" . ""; highlight_string($src); ?>