Viewing file: member_print.php (4.18 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<script type="text/javascript">
function print1(strid) { if(confirm("Do you want to print?")) { var values = document.getElementById(strid); var printing = window.open('','','left=0,top=0,width=550,height=400,toolbar=0,scrollbars=0,sta?tus=0'); printing.document.write(values.innerHTML); printing.document.close(); printing.focus(); printing.print(); printing.close(); } } </script> <form id="form1" name="form1" method="post" action=""> <div id="print2">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head>
<body>
<?php
$con=mysqli_connect("localhost","anshdiam_user","rb!ans838","anshdiam_sarkmicr_data"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); }
$ncode=$_POST['agent_code'].','.$_POST['network_code'];
$sql="INSERT INTO addmember(membercode,branch,name,mmidname,msurname,fname,fmidname,fsurname,village,post,distt,state,pin,pan,aadharno,occupation,dob, phoneno,nationality,experience,nomineename,nomineerelationship,religion,networkcode,rank)
VALUES ('$_POST[membercode]', '$_POST[branchname]','$_POST[name]','$_POST[mmidname]', '$_POST[msurname]', '$_POST[fname]', '$_POST[fmidname]', '$_POST[fsurname]', '$_POST[village]', '$_POST[post]','$_POST[distt]', '$_POST[state]', '$_POST[pin]', '$_POST[pan]', '$_POST[aadharno]', '$_POST[occupation]', '$_POST[dob]', '$_POST[phoneno]', '$_POST[nationality]', '$_POST[experience]','$_POST[nomineename]', '$_POST[relationship]','$_POST[religion]','$ncode','$_POST[rank]')";
if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); }
mysqli_close($con); ?>
</body> </html>
<?php echo "<table width=\"803\" height=\"253\" border=\"0\">\n"; echo " <tr>\n"; echo ""; echo " </tr>\n"; echo " <tr>\n"; echo " <td>MEMBER CODE</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[membercode]</td>\n"; echo " <td>Name</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[name]$_POST[midname]$_POST[surname] </td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Occupation</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[occupation]</td>\n"; echo " <td>Pan No</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[pan]</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Religion</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[religion]</td>\n"; echo " <td>Relationship</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[relationship]</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Aadhar No</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[aadharno] </td>\n"; echo " <td>Mobile No</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[phoneno]</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Branch Name</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[branch]</td>\n"; echo " <td>Father Name</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[fname]$_POST[fmidname]$_POST[fsurname]</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Address</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[village] $_POST[post] $_POST[pin] $_POST[distt]</td>\n"; echo " <td>Registration Fees</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[experience]</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Branch Name</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[branch]</td>\n"; echo " <td></td>\n"; echo " <td>:</td>\n"; echo " <td></td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td>Nominee</td>\n"; echo " <td>:</td>\n"; echo " <td>$_POST[nomineename]</td>\n"; echo " <td>Rank</td>\n"; echo " <td>$_POST[rank]</td>\n"; echo " <td> </td>\n"; echo " </tr>\n"; echo "</table>\n"; echo "\n"; ?> </div> <br/><br/>
<input type="button" name="printbutton" value="Prin table" onClick="return print1('print2')"/> </form>
<form action=""> <input type="button" value="New" onClick="window.location.href='addmember.php';"/> </form>
|