i having trouble thinking logic on how move forward this: trying create html form on webpage, , in form there's going 2 input text boxes, , trying add text table in database. doing in toad oracle way. making procedures going added package. after table, assume make procedure check text boxes , insert inputs table. heres code:
create or replace procedure pcspro.form_alfred begin htp.p (' <form action="userinput" method="post" name="inputform" > '); htp.p (' <table border="2" cellpadding="1" cellspacing="1" summary=""> <!-- table --> <tr> register new user </tr> <tr> <td>employee id: </td> <td><input type="text" name="employeeid" value=""/></td></tr> <tr> <td>employee name: </td> <td><input type="text" name="employeename" value=""/></td></tr> '); end;
i'm not sure understand question have @ simple example:
create or replace procedure formpage begin htp.prn('<!doctype html> <html> <head> <title>simple form</title> </head> <body> <form method="post" action="formprocess"> <table> <tr><td>first name:</td><td><input type="text" name="firstname"></td></tr> <tr><td>last name:</td><td><input type="text" name="lastname"></td></tr> <tr><td colspan="2"><input type="radio" name="sex" value="male">male</td></tr> <tr><td colspan="2"><input type="radio" name="sex" value="female">female</td></tr> <tr><td colspan="2"><input type="checkbox" name="vehicle" value="car">i have car </td></tr> <tr><td colspan="2"><input type="submit" value="submit"></td></tr> </table> </form> </body> </html>'); end formpage; / create or replace procedure formprocess(firstname in varchar2, lastname in varchar2, sex in varchar2, vehicle in varchar2) begin htp.prn('<!doctype html> <html> <head> <title>simple form</title> </head> <body> <table> <tr><td>first name:</td><td>'||firstname||'</td></tr> <tr><td>last name:</td><td>'||lastname||'</td></tr> <tr><td>sex:</td><td>'||sex||'</td></tr> <tr><td>vehicle:</td><td>'||vehicle||'</td></tr> </table> </body> </html>'); end formprocess; / 
Comments
Post a Comment