Download IBM Informix Web DataBlade Module Application Developer`s Guide

Transcript
Example
The following example shows the upload_file AppPage:
<HTML>
<HEAD><TITLE>File Upload Form</TITLE></HEAD>
<BODY>
<HR>
<FORM ENCTYPE=multipart/form-data METHOD=POST
ACTION=<?MIVAR>$WEB_HOME<?/MIVAR>>
<INPUT TYPE=HIDDEN NAME=MIval VALUE=/upload_file.html>
<INPUT TYPE=HIDDEN NAME=action VALUE=on>
<TABLE>
<TR><TD>Name: </TD><TD><INPUT NAME=name SIZE=40 TYPE=TEXT>
</TD></TR>
<TR><TD>File: </TD><TD><INPUT NAME=upload SIZE=40 TYPE=FILE>
</TD></TR>
</TABLE>
<HR>
<INPUT TYPE=SUBMIT VALUE="Insert New Object">
</FORM>
<?MIBLOCK COND=$(XST,$action)>
<HR>
<?MIVAR NAME=sql_statement>
INSERT into uploads VALUES
('$name', '$upload_type',
FileToBlob('$upload','client','uploads','object'),
'$upload_name');
<?/MIVAR>
<?MISQL SQL="$sql_statement">
Inserted $MI_ROWCOUNT new objects.<P><?/MISQL>
<?MIVAR>The SQL executed was <I>$sql_statement</I>.<P><?/MIVAR>
<?/MIBLOCK>
<B> Here are all of the uploaded objects:</B>
<TABLE>
<?MISQL SQL="select name, object, object_type, local_file from uploads;">
<TR><TD><A HREF="$WEB_HOME?LO=$2&type=$3">$1</A>
</TD><TD>$4</TD></TR>
<?/MISQL>
</TABLE>
</BODY>
</HTML>
13-10
IBM Informix Web DataBlade Module Application Developer’s Guide