<?php
SESSION_start();
if(!isset($_SESSION['email']))
{
echo"access denied";
exit;
}
else{
$email=$_SESSION['email'];
include("menu.php");
$num=$_SESSION['num'];
$date=date("Y/m/d");
}
?>
<html>
<head>
</head>
<body>
<div style="position:absolute; top:143px; left:292px; width:999px; height:244px; background-color:pink; border-radius:15px;">
<table>
<form enctype="multipart/form-data" action="" method= "POST">
<tr><td>Document Type:</td><td><select name="doc_type" >
<option value="police report" selected="true">Police report file</option>
<option value="medical report">Medical report file</option>
<option value="purchase bills">Purchase invoice report</option>
<option value="survey report">Survey report file</option>
</select></td></tr>
<tr><td>Settlement Number:</td><td><input type="text" name="cnum" value="<?php echo $num;?>" readonly /><br /></td></tr>
<tr><td>Created Date :</td><td><input type="text" name="doc_cdate" value="" /></td></tr>
<tr><td>Created By :</td><td><input type="text" name="doc_cby" value=" <?php echo $email; ?> " /></td></tr>
<tr><td>Description :</td><td><input type="text" name="doc_comment" value=" " /></td></tr>
<input type="hidden" name="max_file_size" value="124111111"/>
<tr><td>Pick your document ?</td><td><input type="file" size="2022222" name="thefile" /></td></tr>
<tr><td></td><td><input type="submit" name="submit" value=" Uplaod this!"></input></td></tr>
</form>
</div>
</body>
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("shri");
$sql="select * from doc where cnum='$num'";
$result=mysql_query($sql);
$count=mysql_affected_rows();
if($count>0)
{
echo"<table style=\" border: 1px solid black; background-color:pink; width:999px; cellborder:1; position:relative; top:53px;border-radius:22px; \">";
echo"<tr><td><h3>Document View</h3></td></tr>";
echo"<tr><td style=\" border: 1px solid black;\">Settlement No</td><td style=\" border: 1px solid black;\">Document Type</td><td style=\" border: 1px solid black;\">Created date</td><td style=\" border: 1px solid black;\">Created by</td><td style=\" border: 1px solid black;\">Comment</td><td style=\" border: 1px solid black;\">Veiw</td></tr>";
while($row=mysql_fetch_array($result))
{ $cnum=$row['cnum'];
$doc_type=$row['doc_type'];
$doc_cdate=$row['doc_cdate'];
$doc_cby=$row['doc_cby'];
$path=$row['path'];
$doc_comment=$row['doc_comment'];
echo"<tr><td style=\" border: 1px solid black;\">$cnum</td><td style=\" border: 1px solid black;\">$doc_type</td><td style=\" border: 1px solid black;\">$doc_cdate</td><td style=\" border: 1px solid black;\">$doc_cby</td><td style=\" border: 1px solid black;\">$doc_comment</td><td style=\"border: 1px solid black;\" ><a href=\"$path\" style=\"color:red;\">Click here</a></td></tr> ";
}echo"</div>";
echo"</table>";
}
else
{echo"<table style=\" border:1 solid gray ; background-color:pink ; width:999px; cellborder:1; position:relative; top:63px; \">";
echo"<tr><td>Settlement No</td><td>Document Type</td><td>Created date</td><td>Created by</td><td>View</td></tr>";
echo"<tr><td colspan=\"5\"><center/>No rows returned</td></tr>";
echo"</div>";
echo"</table>";
}
if((isset($_POST['submit'])))
{
$path="";
$doc_type=$_POST['doc_type'];
$doc_cby=$_POST['doc_cby'];
$doc_cdate=$_POST['doc_cdate'];
$cnum=$_POST['cnum'];
$doc_comment=$_POST['doc_comment'];
if(!empty($doc_comment))
{
if(($_FILES['thefile']['size']==0)|| (empty($_FILES['thefile']['tmp_name'])))
{
echo("<p>You didn't select document </p>\r\n");
} else if($_FILES['thefile']['size'] > 50001110)
{
echo("<p>The file was too large.</p>\r\n");
} else if($_FILES['thefile']['error'] !== UPLOAD_ERR_OK)
{
echo("<p>There was an error uploading.</p>\r\n");
}
else {
if(!file_exists('/image_uploaded')) mkdir('image_uploaded');
if(move_uploaded_file($_FILES['thefile']['tmp_name'],'image_uploaded/'. $_FILES['thefile']['name']))
{ echo("<p>File uploaded successfully!</p>\r\n");
$path='image_uploaded/'.$_FILES['thefile']['name'];
mysql_connect("localhost","root","");
mysql_select_db("shri");
$sql=("insert into doc(doc_type,cnum,doc_cdate,doc_cby,path,doc_comment) values('$doc_type','$cnum','$doc_cdate','$doc_cby','$path','$doc_comment')");
$result=mysql_query($sql);
$count= mysql_affected_rows();
echo $count;
if(mysql_affected_rows() > 0)
{
echo "Your document has been uploaded !!";
exit;
}
else{
echo "Oye!we missed it ,please submitagain,Thank you";
exit;
}
}else {
echo("<p>There was an error moving the file.</p>\r\n");
}
}
}
}
?>
shrikanthnk 0 Light Poster
shrikanthnk 0 Light Poster
Sorry i missed following para...
above code works fine with following functionality.
record gets inserted to doc table with correct url(selected by the user while uploading]. However i am facing following problem. whenever i click on refresh button after adding records to doc table, same records gets inserted again. in other words as and when refresh button is clicked , last inserted records gets inserted again and again.....please let me know what went wrong ... I am validating whether user is clicked submit button or not before inserting record. however it fails.. please help me . thanks ina dvance
pzuurveen 90 Posting Whiz in Training
That is normal browser behavior
Redirect to a deferent page when your done:
if(mysql_affected_rows() > 0)
{
header("location : thankyou.html");
exit;
}
shrikanthnk 0 Light Poster
Thank you very much!! it is working fine now.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.