($table_name) , ($num_fields). , , : , .
.
-:
Lt;?php
, $table_name $num_fields :
if ((!$_REQUEST["table_name"]) || (!$_REQUEST["num_fields"])) {
header ("Location: show_createtable.html");
exit;
}
, .
$form_block, post do_createtable.php. , (\) .
:
" " () , , . , , , .
$table_name:
<input type=\"hidden\" name=\"table_name\" value=\"".$_REQUEST["table_name"]."\">
, .
HTML-, . co $form_block.
:
for :
for ($i = 0; $i < $_REQUEST["num_fields"]; $i++) {
while, for , . for $i, 0 , $i $num_fields. $i .
for $form_block. HTML- SQL.
HTML-:
HTML- HTML-, SQL.
([]) field_name . , , $field_name. , 0. , . , , $field_name : $field_name[0], $field_name[1], $field_name [2], $field_name[3], $field_name[4] $field_name[5].
HTML- ,
|
|
, , $form_block:
for:
}
$form_block HTML-, :
:
?>
HTML:
, HTML :
<H1> <?php echo $_REQUEST["table_name"];?></H1>
, , .
$form_block:
<?php echo $form_block;?>
HTML- :
do_showfielddef.php Web-.
, , .
, , , . , .
Web-,
http://localhost/show_createtable.html
Enter. : 1 , .
my_music.
8.
2. : 2
, , . , . , , .
, , id, int, 5.
, , format, char, 2.
, , title, varchar, 150.
, , artist_fn, varchar, 100.
, , artist_ln, varchar, o 100.
, , rec_label, varchar, 50.
, , my_notes, text.
, , date_asq, date.
:
|
|
, , .
Pa
, , SQL MySQL, my_music.
.
:
Lt;?php
, :
$db_name="testDB2";
mysql_connect ():
@ , die() - .
mysql_select_db ():
@ , die () - , .
mysgl_select_db () : .
, $sql:
$sql="create table ".$_REQUEST["table_name"]." (";
for, SQL:
for ($i=0; $i<count($_REQUEST["field_name"]); $i++) {
, $field_name.
count () .
SQL :
$sql.= $_REQUEST["field_name"][$i]." ".$_REQUEST["field_type"][$i];
, - , if...else. , SQL.
if...else:
if ($_REQUEST["field_length"][$i]!= "") {
$sql.= " (".$_REQUEST["field_length"][$i]."),";
, SQL (,), if...else.:
:
}
SQL . for, SQL-, . , SQL . substr (), .
:
substr () . , , , - , . ( 0) .
SQL:
mysql_query ():
@ , die () - , .
mysql_query () SQL .
$result, if...else:
|
|
if ($result) {
$msg="<P> ".$_REQUEST["table_name"]." !</P>";
}
$result , .
:
?>
HTML:
: 3 , :
<h1> <?php echo "$db_name";?>...</h1>
:
<?php echo "$form_block";?>
HTML:
db_createtable.php Web-.
.
Web- , .
. : 3
, , :
http://localh.ost/db_listtable.php ( )
Enter.
, db_listtable.php, . MySQL
, my_music test_DB.