, , , .
.
:
<?php
, $id, $format, $title, :
if ((!$_REQUEST["id"]) || (!$_REQUEST["format"]) || (!$_REQUEST["title"])) {
header ("Location: show_addrecord.html");
exit;
}
( ), .
, , , , .
, :
, ( testDB2).
, :
mysql_connect ():
@ , die () - , MySQL.
mysql_select_db ():
@ , die () - , .
SQL. . , . , .
SQL:
$db=mysql_select_db ($db_name, $connection) or die (" ");
$sql="INSERT INTO $table_name (id, format, title, artist_fn, artist_ln, rec_label, my_notes, date_asq) VALUES (";
$sql.= "\"".$_REQUEST["id"]."\","."\"".$_REQUEST["format"]."\",";
$sql.= "\"".$_REQUEST["title"]."\","."\"".$_REQUEST["artist_fn"]."\","."\"".$_REQUEST["artist_ln"]."\",";
$sql.= "\"".$_REQUEST["rec_label"]."\","."\"".$_REQUEST["my_notes"]."\","."\"".$_REQUEST["date_asq"]."\")";
mysql_query ():
$result=@mysql_query($sql, $connection) or die (" ");
@ , die () - , .
:
|
|
?>
HTML:
, , :
<H1> <?php echo "$table_name";?></H1>
show_addrecord.html. , , HTML , , . , (ID).
:
<TABLE CELLSPACING=3 CELLPADDING=3>
<TR>
<TD VALIGN=TOP>
<p><STRONG> ID: </STRONG></BR>
<?php echo "$id";?></p>
HTML- :
<p><strong> (--): </STRONG><BR>
<?php echo "$date_asq";?></p>
</TD >
HTML-, :
<TD VALIGN=TOP>
<p><STRONG> : </STRONG><BR>
<?php echo "$format";?></p>
</TD></TR>
HTML- , , :
<TR>
<TD VALIGN=TOP>
<p><STRONG> : </STRONG><BR>
<?php echo "$title";?></p>
</TD>
HTML- , :
<TD VALIGN=TOP>
<p><STRONG> : </STRONG><BR>
<?php echo "$rec_label";?></p>
</TD></TR>
HTML- , , :
<TR><TD VALIGN=TOP>
<p><STRONG> : </STRONG><BR>
<?php "$artist_fn";?></p></TD>
HTML- , :
<TD VALIGN=TOP>
<p><STRONG> (): </STRONG><BR>
<?php "$artist_ln";?></p>
</TD></TR>
HTML- , , :
<TR>
<TD VALIGN=TOP COLSPAN=2 ALIGN=CENTER>
<p><STRONG> : </STRONG><BR>
<?php echo stripslashes ($my_notes);?></p>
stripslashes () (\), . magic_quotes_gpc php.ini . , , ( ). magic_quotes_gpc, php.ini. , .
|
|
:
, , HTML-, :
do_addrecord.php a Web-.
Web-, http://localhost/show_addrecord.html ( , ) Enter. .
ID: 1.
-.
(--): .
: LADY IN RED.
: .
(): : Collection.
: : . !
. .
.
. .
.
, : ID, .
, ID , , .