Free Programming Source Codes and Computer Programming Tutorials: Printing a Report Using JavaScript

Friday, April 17, 2020

Printing a Report Using JavaScript

Here is a code that I wrote to print a report using JavaScript and PHP in a web page. I hope this code will help you learned and understand how to use JavaScript to print a report.

I am currently accepting programming work inventory system, enrollment system, accounting system, payroll system, information system, website design and development using WordPress, IT projects, school and application development, programming projects, thesis, and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details. If you want to advertise on my website kindly contact me also in my email address also. Thank you.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.
My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.

Here in Bacolod City, Negros Occidental I also accepting computer repair, web development using WordPress, Computer Networking and Arduino Project development at a very affordable price.
My personal website is http://www.jakerpomperada.com

My programming website is http://www.jakerpomperada.blogspot.com

I am also a book author you can purchase my books on computer programming and information technology in the following links below.

https://www.mindshaperspublishing.com/

https://www.unlimitedbooksph.com/

Program Listing

<?php

error_reporting(0);

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "hris";

$db = new mysqli($servername, $username, $password, $dbname);

if (isset($_GET['print'])) {

$id = $_GET['print'];

$update = true;

// personal info

//$record = mysqli_query($db, "SELECT * FROM tbl_p_info WHERE employee_id=$id");

$record = mysqli_query($db,"SELECT * FROM `tbl_p_info` Where `tbl_p_info`.`employee_id` = '$id'");

if (count($record) == 1 ) {

$n = mysqli_fetch_array($record);

$surname = $n['surname'];

$first_name = $n['first_name'];

$middle_name = $n['middle_name'];

$name_extension = $n['name_extension'];

$date_birth = $n['date_birth'];

$place_of_birth = $n['place_of_birth'];

$sex = $n['sex'];

$civil_status = $n['civil_status'];

$height_m = $n['height_m'];

$weight_m = $n['weight_m'];

$blood_type = $n['blood_type'];

$gsis_id_no = $n['gsis_id_no'];

$pagibig_id_no = $n['pagibig_id_no'];

$philhealth_no = $n['philhealth_no'];

$sss_no = $n['sss_no'];

$tin_no = $n['tin_no'];

$agency_employee_no = $n['agency_employee_no'];

$citizenship = $n['citizenship'];

$country = $n['country'];

$dual_citizenship = $n['dual_citizenship'];

$residential_house_block_lot_no = $n['residential_house_block_lot_no'];

$residential_street = $n['residential_street'];

$residential_subdivision_village = $n['residential_subdivision_village'];

$residential_barangay = $n['residential_barangay'];

$residential_city_municipality = $n['residential_city_municipality'];

$residential_province = $n['residential_province'];

$residential_zipcode = $n['residential_zipcode'];

$permanent_house_block_lot_no = $n['permanent_house_block_lot_no'];

$permanent_street = $n['permanent_street'];

$permanent_subdivision_village = $n['permanent_subdivision_village'];

$permanent_barangay = $n['permanent_barangay'];

$permanent_city_municipality = $n['permanent_city_municipality'];

$permanent_province = $n['permanent_province'];

$permanent_zipcode = $n['permanent_zipcode'];

$telephone_no = $n['telephone_no'];

$mobile_no = $n['mobile_no'];

$email_address = $n['email_address'];

}

if ($sex ==='Male'){

$sexy = 'checked';

$sexn = 'no';

} else {

$sexy = 'no';

$sexn = 'checked';

}

if ($civil_status ==='Single'){

$civil_statuss = 'checked';

$civil_statusm = 'no';

$civil_statusw = 'no';

$civil_statusse = 'no';

$civil_statuso = 'no';

} elseif ($civil_status ==='Married'){

$civil_statuss = 'no';

$civil_statusm = 'checked';

$civil_statusw = 'no';

$civil_statusse = 'no';

$civil_statuso = 'no';

} elseif ($civil_status ==='Widowed'){

$civil_statuss = 'no';

$civil_statusm = 'no';

$civil_statusw = 'checked';

$civil_statusse = 'no';

$civil_statuso = 'no';

} elseif ($civil_status ==='Separated'){

$civil_statuss = 'no';

$civil_statusm = 'no';

$civil_statusw = 'no';

$civil_statusse = 'checked';

$civil_statuso = 'no';

} else{

$civil_statuss = 'no';

$civil_statusm = 'no';

$civil_statusw = 'no';

$civil_statusse = 'no';

$civil_statuso = 'checked';

}

if ($citizenship ==='Filipino'){

$citizenshipy = 'checked';

$citizenshipn = 'no';

} else {

$citizenshipy = 'no';

$citizenshipn = 'checked';

}

if ($dual_citizenship ==='By Birth'){

$dual_citizenshipy = 'checked';

$dual_citizenshipn = 'no';

} else {

$dual_citizenshipy = 'no';

$dual_citizenshipn = 'checked';

}

// spouse

$record1 = mysqli_query($db, "SELECT * FROM tbl_spouse WHERE employee_id=$id");

if (count($record1) == 1 ) {

$s = mysqli_fetch_array($record1);

$spouses_surname = $s['spouses_surname'];

$sfirst_name = $s['first_name'];

$smiddle_name = $s['middle_name'];

$sname_extension = $s['name_extension'];

$soccupation = $s['occupation'];

$semployer_business_name = $s['employer_business_name'];

$sbusiness_address = $s['business_address'];

$stelephone_no = $s['telephone_no'];

}

// family fathers

$record2 = mysqli_query($db, "SELECT * FROM tbl_family WHERE employee_id=$id and relationship = 'Father' LIMIT 0,1");

if (count($record2) == 1 ) {

$f = mysqli_fetch_array($record2);

$frelationship = $f['relationship'];

$fsurname = $f['surname'];

$ffirst_name = $f['first_name'];

$fmiddle_name = $f['middle_name'];

$fname_extension = $f['name_extension'];

$fmaidenname = $f['maidenname'];

}

// family fathers

$record3 = mysqli_query($db, "SELECT * FROM tbl_family WHERE employee_id=$id and relationship = 'Mother'");

if (count($record3) == 1 ) {

$fm = mysqli_fetch_array($record3);

$fmrelationship = $fm['relationship'];

$fmsurname = $fm['surname'];

$fmfirst_name = $fm['first_name'];

$fmmiddle_name = $fm['middle_name'];

$fmname_extension = $fm['name_extension'];

$fmmaidenname = $fm['maidenname'];

}

// family children 0

$record4 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 0,1");

if (count($record4) == 1 ) {

$fc = mysqli_fetch_array($record4);

$fcname_of_children = $fc['name_of_children'];

$fcdate_of_birth = $fc['date_of_birth'];

}

// family children 1

$record5 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 1,1");

if (count($record5) == 1 ) {

$fc = mysqli_fetch_array($record5);

$fc1name_of_children = $fc['name_of_children'];

$fc1date_of_birth = $fc['date_of_birth'];

}

// family children 2

$record6 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 2,1");

if (count($record6) == 1 ) {

$fc = mysqli_fetch_array($record6);

$fc2name_of_children = $fc['name_of_children'];

$fc2date_of_birth = $fc['date_of_birth'];

}

// family children 3

$record7 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 3,1");

if (count($record7) == 1 ) {

$fc = mysqli_fetch_array($record7);

$fc3name_of_children = $fc['name_of_children'];

$fc3date_of_birth = $fc['date_of_birth'];

}

// family children 4

$record8 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 4,1");

if (count($record8) == 1 ) {

$fc = mysqli_fetch_array($record8);

$fc4name_of_children = $fc['name_of_children'];

$fc4date_of_birth = $fc['date_of_birth'];

}

// family children 5

$record9 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 5,1");

if (count($record9) == 1 ) {

$fc = mysqli_fetch_array($record9);

$fc5name_of_children = $fc['name_of_children'];

$fc5date_of_birth = $fc['date_of_birth'];

}

// family children 6

$record10 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 6,1");

if (count($record10) == 1 ) {

$fc = mysqli_fetch_array($record10);

$fc6name_of_children = $fc['name_of_children'];

$fc6date_of_birth = $fc['date_of_birth'];

}

// family children 7

$record11 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 7,1");

if (count($record11) == 1 ) {

$fc = mysqli_fetch_array($record11);

$fc7name_of_children = $fc['name_of_children'];

$fc7date_of_birth = $fc['date_of_birth'];

}

// family children 8

$record12 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 8,1");

if (count($record12) == 1 ) {

$fc = mysqli_fetch_array($record12);

$fc8name_of_children = $fc['name_of_children'];

$fc8date_of_birth = $fc['date_of_birth'];

}

// family children 9

$record13 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 9,1");

if (count($record13) == 1 ) {

$fc = mysqli_fetch_array($record13);

$fc9name_of_children = $fc['name_of_children'];

$fc9date_of_birth = $fc['date_of_birth'];

}

// family children 10

$record14 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 10,1");

if (count($record14) == 1 ) {

$fc = mysqli_fetch_array($record14);

$fc10name_of_children = $fc['name_of_children'];

$fc10date_of_birth = $fc['date_of_birth'];

}

// family children 11

$record15 = mysqli_query($db, "SELECT * FROM tbl_children WHERE employee_id=$id LIMIT 11,1");

if (count($record15) == 1 ) {

$fc = mysqli_fetch_array($record15);

$fc11name_of_children = $fc['name_of_children'];

$fc11date_of_birth = $fc['date_of_birth'];

}

// Special Skills 1

$record16 = mysqli_query($db, "SELECT * FROM tbl_skills_hobbies WHERE employee_id=$id LIMIT 0,1");

if (count($record16) == 1 ) {

$sp = mysqli_fetch_array($record16);

$sp1special_skills_hobbies = $sp['special_skills_hobbies'];

}

// Special Skills 2

$record17 = mysqli_query($db, "SELECT * FROM tbl_skills_hobbies WHERE employee_id=$id LIMIT 1,1");

if (count($record17) == 1 ) {

$sp = mysqli_fetch_array($record17);

$sp2special_skills_hobbies = $sp['special_skills_hobbies'];

}

// Special Skills 3

$record18 = mysqli_query($db, "SELECT * FROM tbl_skills_hobbies WHERE employee_id=$id LIMIT 2,1");

if (count($record18) == 1 ) {

$sp = mysqli_fetch_array($record18);

$sp3special_skills_hobbies = $sp['special_skills_hobbies'];

}

// Special Skills 4

$record19 = mysqli_query($db, "SELECT * FROM tbl_skills_hobbies WHERE employee_id=$id LIMIT 3,1");

if (count($record19) == 1 ) {

$sp = mysqli_fetch_array($record19);

$sp4special_skills_hobbies = $sp['special_skills_hobbies'];

}

// NON-ACADEMIC DISTINCTIONS / RECOGNITION 1

$record20 = mysqli_query($db, "SELECT * FROM tbl_recog WHERE employee_id=$id LIMIT 0,1");

if (count($record20) == 1 ) {

$na = mysqli_fetch_array($record20);

$na1non_academic_distinctions = $na['non_academic_distinctions'];

}

// NON-ACADEMIC DISTINCTIONS / RECOGNITION 2

$record21 = mysqli_query($db, "SELECT * FROM tbl_recog WHERE employee_id=$id LIMIT 1,1");

if (count($record21) == 1 ) {

$na = mysqli_fetch_array($record21);

$na2non_academic_distinctions = $na['non_academic_distinctions'];

}

// NON-ACADEMIC DISTINCTIONS / RECOGNITION 3

$record22 = mysqli_query($db, "SELECT * FROM tbl_recog WHERE employee_id=$id LIMIT 2,1");

if (count($record22) == 1 ) {

$na = mysqli_fetch_array($record22);

$na3non_academic_distinctions = $na['non_academic_distinctions'];

}

// NON-ACADEMIC DISTINCTIONS / RECOGNITION 4

$record23 = mysqli_query($db, "SELECT * FROM tbl_recog WHERE employee_id=$id LIMIT 3,1");

if (count($record23) == 1 ) {

$na = mysqli_fetch_array($record23);

$na4non_academic_distinctions = $na['non_academic_distinctions'];

}

// MEMBERSHIP IN ASSOCIATION/ORGANIZATION 1

$record24 = mysqli_query($db, "SELECT * FROM tbl_membership WHERE employee_id=$id LIMIT 0,1");

if (count($record24) == 1 ) {

$ma = mysqli_fetch_array($record24);

$ma1membership_asso_organization = $ma['membership_asso_organization'];

}

// MEMBERSHIP IN ASSOCIATION/ORGANIZATION 2

$record25 = mysqli_query($db, "SELECT * FROM tbl_membership WHERE employee_id=$id LIMIT 1,1");

if (count($record25) == 1 ) {

$ma = mysqli_fetch_array($record25);

$ma2membership_asso_organization = $ma['membership_asso_organization'];

}

// MEMBERSHIP IN ASSOCIATION/ORGANIZATION 3

$record26 = mysqli_query($db, "SELECT * FROM tbl_membership WHERE employee_id=$id LIMIT 2,1");

if (count($record26) == 1 ) {

$ma = mysqli_fetch_array($record26);

$ma3membership_asso_organization = $ma['membership_asso_organization'];

}

// MEMBERSHIP IN ASSOCIATION/ORGANIZATION 4

$record27 = mysqli_query($db, "SELECT * FROM tbl_membership WHERE employee_id=$id LIMIT 3,1");

if (count($record27) == 1 ) {

$ma = mysqli_fetch_array($record27);

$ma4membership_asso_organization = $ma['membership_asso_organization'];

}

// tbl_additional_info

$record28 = mysqli_query($db, "SELECT * FROM tbl_additional_info WHERE employee_id=$id");

if (count($record28) == 1 ) {

$qa = mysqli_fetch_array($record28);

$question_34_a = $qa['question_34_a'];

$question_34_b = $qa['question_34_b'];

$yes_details_34_b = $qa['yes_details_34_b'];

$question_35_a = $qa['question_35_a'];

$yes_details_35_a = $qa['yes_details_35_a'];

$question_35_b = $qa['question_35_b'];

$question_35_b_datefiled = $qa['question_35_b_datefiled'];

$status_cases_35_b = $qa['status_cases_35_b'];

$question_36 = $qa['question_36'];

$yes_details_36 = $qa['yes_details_36'];

$question_37 = $qa['question_37'];

$yes_details_37 = $qa['yes_details_37'];

$question_38_a = $qa['question_38_a'];

$yes_details_38_a = $qa['yes_details_38_a'];

$question_38_b = $qa['question_38_b'];

$yes_details_38_b = $qa['yes_details_38_b'];

$question_39 = $qa['question_39'];

$yes_details_39 = $qa['yes_details_39'];

$question_40_a = $qa['question_40_a'];

$a_yes_details_40 = $qa['a_yes_details_40'];

$question_40_b = $qa['question_40_b'];

$b_yes_details_b = $qa['b_yes_details_b'];

$question_40_c = $qa['question_40_c'];

$c_yes_details_c = $qa['c_yes_details_c'];

}

if ($question_34_a === 'YES'){

$question_34_ay = 'checked';

$question_34_an = 'no';

} else {

$question_34_ay = 'no';

$question_34_an = 'checked';

}

if ( $question_34_b ==='YES'){

$question_34_by = 'checked';

$question_34_bn = 'no';

}else{

$question_34_by = 'no';

$question_34_bn = 'checked';

}

if ( $question_35_a ==='YES' ){

$question_35_ay = 'checked';

$question_35_an = 'no';

}else{

$question_35_ay = 'no';

$question_35_an = 'checked';

}

if ($question_35_b ==='YES' ){

$question_35_by = 'checked';

$question_35_bn = 'no';

}else{

$question_35_by = 'no';

$question_35_bn = 'checked';

}

if ( $question_36 ==='YES'){

$question_36y = 'checked';

$question_36n = 'no';

}else{

$question_36y = 'no';

$question_36n = 'checked';

}

if ( $question_37 ==='YES'){

$question_37y = 'checked';

$question_37n = 'no';

}else{

$question_37y = 'no';

$question_37n = 'checked';

}

if ($question_38_a ==='YES'){

$question_38_ay = 'checked';

$question_38_an = 'no';

}else{

$question_38_ay = 'no';

$question_38_an = 'checked';

}

if ($question_38_b ==='YES'){

$question_38_by = 'checked';

$question_38_bn = 'no';

}else{

$question_38_by = 'no';

$question_38_bn = 'checked';

}

if ($question_39 ==='YES'){

$question_39y = 'checked';

$question_39n = 'no';

}else{

$question_39y = 'no';

$question_39n = 'checked';

}

if ( $question_40_a ==='YES'){

$question_40_ay = 'checked';

$question_40_an = 'no';

}else{

$question_40_ay = 'no';

$question_40_an = 'checked';

}

if ($question_40_b ==='YES'){

$question_40_by = 'checked';

$question_40_bn = 'no';

}else{

$question_40_by = 'no';

$question_40_bn = 'checked';

}

if ($question_40_c ==='YES'){

$question_40_cy = 'checked';

$question_40_cn = 'no';

} else {

$question_40_cy = 'no';

$question_40_cn = 'checked';

}

// tbl_gov_id

$record29 = mysqli_query($db, "SELECT * FROM tbl_gov_id WHERE employee_id=$id");

if (count($record29) == 1 ) {

$g = mysqli_fetch_array($record29);

$ggov_id = $g['gov_id'];

$gid_no = $g['id_no'];

$gdate_place_issuance = $g['date_place_issuance'];

}

table#t01{

width: 950px;

border: 1px solid black;

border-collapse: collapse;

font-size: 13px;

}

th, td {

border: 1px solid black;

border-collapse: collapse;

padding: 2px;

</style>

<html>

<body>

<tr>

</tr>

<tr>

Revised 2017

</td>

</tr>

<tr>

PERSONAL DATA SHEET

</td>

</tr>

<tr>

<td colspan="12">WARNING: Any misrepresentation main in the Personal Data Sheet and the

Work Experience Sheet shall cause the filing of administative/criminal case/s

against the person concerned.</td>

</tr>

<tr>

<td colspan="12">WARNING: Any misrepresentation main in the Personal Data Sheet and the

Work Experience Sheet shall cause the filing of administative/criminal case/s

against the person concerned.</td>

</tr>

<tr>

<td colspan="12">READ THE ATTACHED GUIDE TO FILLING OUT THE PERSONAL DATA SHEET (PDS)

BEFORE ACCOMPLISHING THE PDS FORM</td>

</tr>

<tr>

<td colspan="9">Print legibly. Tick appropriate boxes ( <input type="checkbox" checked> ) ad use

seperate sheet if necessary. Indicate N/A if not applicable. DO NOT ABBREVIATE.</td>

<td colspan="1" style="border:1px solid#000b;background:#757575;width:8%;">1. CS ID

No.</td>

<td colspan="2" class="text-right" style="border:1px solid #000;width:20%;">(Do not fill

up. For CSC use only)</td>

</tr>

<tr>

<td colspan="12" class="text-white separator">I. PERSONAL INFORMATION</td>

</tr>

<tr>

2. SURNAME

</td>

</tr>

<tr>

<td colspan="1" class="s-label border-0"> FIRST NAME</td>

<td colspan="2" class="align-top">NAME EXTENSION (JR.,SR)

<?php echo $name_extension; ?>

</td>

</tr>

<tr>

<td colspan="1" class="s-label border-0"> MIDDLE NAME</td>

</tr>

<tr>

3. DATE OF BIRTH

(mm/dd/yyyy)

</td>

16. CITIZENSHIP

</td>

<input type="checkbox" <?php echo $citizenshipy; ?> disabled>

<label for="my-input">Filipino</label>

</div>

<input type="checkbox" <?php echo $citizenshipn; ?> disabled>

<label for="my-input">Dual Citizenship</label>

</div>

</td>

</tr>

<tr>

If holder of dual citizenship,

</td>

<input type="checkbox" <?php echo $dual_citizenshipy; ?> disabled>

<label for="my-input">by birth</label>

</div>

<input type="checkbox" <?php echo $dual_citizenshipn; ?> disabled>

<label for="my-input">by naturalization</label>

</div>

<label for="my-input">Pls. indicate country:</label>

</td>

</tr>

<tr>

<td colspan="1" class="s-label">4. PLACE OR BIRTH</td>

<td colspan="3" class="s-label align-top border-0 text-center small"> please indicate the

details.</td>

</tr>

<tr>

<input type="checkbox" <?php echo $sexy; ?> disabled>

</div>

<input type="checkbox" <?php echo $sexn; ?> disabled>

<label for="my-input">Female</label>

</div>

</td>

</tr>

<tr>

<td colspan="1" rowspan="2" class="s-label border-bottom-0">6. CIVIL STATUS</td>

<input type="checkbox" <?php echo $civil_statuss; ?> disabled>

<label for="my-input">Single</label>

</div>

<input type="checkbox" <?php echo $civil_statusm; ?> disabled>

<label for="my-input">Married</label>

</div>

<input type="checkbox" <?php echo $civil_statusw; ?> disabled>

<label for="my-input">Widowed</label>

</div>

<input type="checkbox" <?php echo $civil_statusse; ?> disabled>

<label for="my-input">Separated</label>

</div>

<input type="checkbox" <?php echo $civil_statuso; ?> disabled>

<label for="my-input">Other/s</label>

</div>

</td>

17. RESIDENTIAL ADDRESS

</td>

</tr>

<tr>

</tr>

<tr>

<td colspan="1" class="s-label">7. HEIGHT (m)</td>

</tr>

<tr>

<td colspan="1" class="s-label">8. WEIGHT (kg)</td>

ZIP CODE

</td>

</tr>

<tr>

<td colspan="1" class="s-label">9. BLOOD TYPE</td>

<td colspan="2" class="s-label border-bottom-0">18. PERMANENT ADDRESS

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td colspan="1" class="s-label">12. PHILHEALTH NO.</td>

</tr>

<tr>

<td colspan="2" class="s-label">19. TELEPHONE NO.</td>

</tr>

<tr>

<td colspan="2" class="s-label">20. MOBILE NO.</td>

</tr>

<tr>

<td colspan="1" class="s-label">15. AGENCY EMPLOYEE NO.</td>

<td colspan="2" class="s-label">21. EMAIL ADDRESS (if any)</td>

</td>

</tr>

<tr>

<td colspan="12" class="text-white separator">II. FAMILY BACKGROUND</td>

</tr>

<tr>

22. SPOUSE SURNAME

</td>

23. NAME of CHILDREN (Write full name and list all)

</td>

<td colspan="3" class="s-label text-center" style="width: 18%;">DATE OF BIRTH (mm/dd/yyyy)</td>

</tr>

<tr>

FIRST NAME

</td>

NAME EXTENSION (JR.,SR)

<?php echo $sname_extension; ?>

</td>

</tr>

<tr>

MIDDLE NAME

</td>

</tr>

<tr>

OCCUPATION

</td>

</tr>

<tr>

EMPLOYER/BUSINESS NAME

</td>

</tr>

<tr>

BUSINESS ADDRESS

</td>

</tr>

<tr>

TELEPHONE NO.

</td>

</tr>

<tr>

24. FATHER'S SURNAME

</td>

</tr>

<tr>

FIRST NAME

</td>

NAME EXTENSION (JR.,SR)

<?php echo $fname_extension; ?>

</td>

</tr>

<tr>

MIDDLE NAME

</td>

</tr>

<tr>

25. MOTHERS MAIDEN NAME

</td>

</tr>

<tr>

SURNAME

</td>

</tr>

<tr>

FIRST NAME

</td>

</tr>

<tr>

MIDDLE NAME

</td>

<td colspan="6" class="s-label text-danger text-center">(Continue on seperate sheet if

necessary)</td>

</tr>

<tr>

<td colspan="12" class="text-white separator">III. EDUCATIONAL BACKGROUND</td>

</tr>

26.

LEVEL

</td>

NAME OF SCHOOL (Write in full)

</td>

BASIC EDUCATION/DEGREE/COURSE

(Write in full)

</td>

PERIOD OF ATTENDANCE

</td>

<td colspan="2" class="s-label border-bottom-0"> HIGHEST LEVEL / UNITS EARNED (If not graduated)

</td>

<td colspan="1" class="s-label border-bottom-0">YEAR GRADUATED</td>

<td colspan="1" class="s-label border-bottom-0">SCHOLARSHIP/ ACADEMIC HONORS RECEIVED

</td>

</tr>

</tr>

<?php

require('db_config.php');

$id = $_GET['print'];

$sql = "SELECT * FROM tbl_educ WHERE employee_id=$id ORDER BY educational_id";

$educs = $mysqli->query($sql);

while($educ = $educs->fetch_assoc()){

<tr>

<?php echo $educ['ed_level'] ?>

</td>

</tr>

<?php } ?>

<tr>

(Continue on seperate sheet if necessary)

</td>

</tr>

<tr>

<td colspan="1" class="text-center">SIGNATURE</td>

</tr>

</table>

</div>

</body>

</html>

function PrintElement(elem) {

var divName = "main-tbl";

var printContents = document.getElementById(divName).innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function PrintElement1(elem) {

var divName = "c1";

var printContents = document.getElementById(divName).innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function PrintElement2(elem) {

var divName = "c2";

var printContents = document.getElementById(divName).innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function PrintElement3(elem) {

var divName = "c3";

var printContents = document.getElementById(divName).innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function PrintElement4(elem) {

var divName = "c4";

var printContents = document.getElementById(divName).innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

</script>

function codespeedy(){

var print_div = document.getElementById("pds_print");

var print_area = window.open();

print_area.document.write(print_div.innerHTML);

print_area.document.close();

print_area.focus();

print_area.print();

print_area.close();

// This is the code print a particular div element

}

</script>

Free Programming Source Codes and Computer Programming Tutorials

Friday, April 17, 2020

Printing a Report Using JavaScript

No comments:

Post a Comment

Google Ads

Followers