//again i am sending this code
my first table is
1)
DOCUMENT_ID DOCUMENT_NAME
1 TC
2 SSC MARKSHEET
3 HSC MARKSHEET
4 GRADUATION MARKSHEET
5 GRADUATION DEGREE
6 PG MARKSHEET
7 PG DEGREE
8 CASTE CERTIFICATE
9 SPORTS CERTIFICATE
2) & mysecond table is
Name Null? Type
FORM_REGI_NO NUMBER(4)
DOCUMENT_ID NUMBER(2)
RCVD_DATE DATE
RETURNED_DATE DATE
/ i have to only insert FORM_REGI_NO,DOCUMENT_ID
other two date field are DEFAULT no problem with us
when i insert record form registration no will be same only
that sutdent document id change
it should be like ex:
my oracle out put should be like :
/
/
form_regi_no DOCUMENT_ID
17 3
7
8
/
<form method=post>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tr>
<td><p align="center"><font face="Verdana" size="2">
<b>Select Checkboxes to Attach the Document</b>
</font>
</td>
</tr>
<?
$con=ocilogon("student","student","ghriu.sdomain.ghrce.edu") or die ("Couldn't Connect");
$stmt_doc = ociparse($con, "select DOCUMENT_ID,DOCUMENT_NAME from UNIV_ATTACH_DOCUMENT_MASTER order by document_id");
ociexecute($stmt_doc,OCI_DEFAULT);
while(ocifetch($stmt_doc))
{ //for($doc=0; $doc < sizeof($doc_id); $doc++)
$doc_id=ociresult($stmt_doc,1);
$doc_name=ociresult($stmt_doc,2);
print("<tr><td><font face=Verdana size=1><input type=\"checkbox\" name= doc_id[] value=$doc_id[$i]>  $doc_name    <br></font>");
//print ( $doc_id[] ); print ("<br>");
}
?>
</td></tr>
<tr><td> </td></tr>
<tr><td> <input type=submit Value="Submit"> <input type=reset name=reset> </tr></td>
</table></center>
</form>
<? // getting maximum form_regi_no
$stmt=ociparse($con,"select max(FORM_REGI_NO)from student.univ_form_registration ");
ociexecute($stmt, OCI_DEFAULT);
while(ocifetch($stmt))
{
$form_reg_no=ociresult($stmt,1);
}
// print($doc_id[$doc] );
// print($form_reg_no);
?>
<?
if (isset($HTTP_POST_VARS)) {
$doc_id = $HTTP_POST_VARS["doc_id"];
// $doc_name = $HTTP_POST_VARS["doc_name"];
echo("Douments chosen: " . count($doc_id) . "<br><br>");
if(count($doc_id)>0) {
echo("You chose the following Documents:<br>");
for($i=0; $i<count($doc_id[$i]); $i++) {
// echo( ($i+1) . ") " . $doc_id[$i] . "<br>");
/* print ("hope");
if($doc_id[$i]==true){
$doc_id[$i]=$doc_id[$i];
}
else {
if($doc_id[$i]==false){
$doc_id[$i]=$doc_id[$i];
}
} */
$sql = "INSERT INTO UNIV_STUD_ATTACH_DOCU_MASTER (FORM_REGI_NO,DOCUMENT_ID) values ($form_reg_no,$doc_id[$i])";
// print ($sql);
if(!isset($sql)){
print ($sql);
print("<br><center><table border=2 style=border-collapse:collpase cellspacing=2 cellpadding=2 width=70%");
print("<tr bgcolor=#AACFEA><td><center><font face=verdana size=3 color=blue><b>Sorry<br>Sorry Error while inserting checkboxes Information.</b></td></tr>");
print("</table>");
print("<br><a href=\"javascript:history.back()\"><b>Back</b></a>");
//$strsql = "";
//include ("footer.php");
exit();
}
else { print ($sql);
$stmt=ociparse($con,$strsql) ;
ociexecute($stmt) or die("Error in inserting data.Please Try Again");
ocicommit($con);
print("<tr bgcolor=#AACFEA><td><center><font face=verdana size=3 color=blue><b><br> Thanks For Your Patient Now Information is add Successfully </b></td></tr>");
}
}
}
}
?>
/
/ when I execute this code following error occured.
and if u solved my problem please tell me how can i get the error free code from u because i am newly joined this forum
/
Warning: ociexecute(): OCIStmtExecute: ORA-24337: statement handle not prepared in F:\Prakash\checkbox.php on line 72
Error in inserting data.Please Try Again
/
