Free Programming Source Codes and Computer Programming Tutorials

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>

Math Machine Problem Functions C++

I wrote this math functions in C++ to help my friend in his C++ class I hope you will fund this math machine problem functions useful.

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

double density_rho(double p, double t)
{
double rho=0.00;
rho = -81.8940331877 + 0.78481129*t + 0.0005329766*p - 0.0018702673*t*t - 0.0000012965*t*p;
return(rho);
}

double speed_of_sound(double p, double t)
{
double sc=0.00;
sc = 39.0400504977 + 0.5091505919*t - 0.0000480685*p - 0.0005999919*t*t + 0.0000000876*t*p;
return(sc);
}

double specific_heat(double t)
{
double c_p=0.00;

c_p = - 1577063.4164665183+ 41224.896010033437*t - 455.96153366489557*t*t + 2.7672075004378294*t*t*t
- 0.0099538282420798870*t*t*t*t + 0.000021227412909644836*t*t*t*t*t
- 0.000000024859361943686458*t*t*t*t*t*t + 0.00000000001.2338077579028771*t*t*t*t*t*t*t;
return(c_p);
}

double thermal_conductivity(double t)
{
double ktc=0.00;
ktc = - 4.79705801855805 + 0.126580618555664*t - 0.00141015276114583*t*t + 0.00000861758538465397*t*t*t
- 0.0000000312200757403645*t*t*t*t + 0.0000000000670977270739948*t*t*t*t*t
- 0.0000000000000792496952896591*t*t*t*t*t*t + 0.0000000000000000397025645975445*t*t*t*t*t*t*t;
return(ktc);
}

double viscosity(double t)
{
double mu_lam = 0.00;
mu_lam = - 0.0015987149372354798 + 0.000042026515524978413*t - 0.00000046699891157692537*t*t
+ 0.0000000028508060545019561*t*t*t - 0.000000000010319166121085859*t*t*t*t
+ 0.000000000000022158014214734705*t*t*t*t*t - 0.00000000000000002.6149887177791217*t*t*t*t*t*t
+ 0.000000000000000000013095111471646806*t*t*t*t*t*t*t;

return(mu_lam);
}

Wednesday, April 15, 2020

Average of Number Using Hash in Perl

I wrote this program to ask the user to give key of the hash and then the program will accept a series of numbers based on the key values in the hash and compute the sum and the average of the numbers using Perl programming.

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/

Sample Program Output

Program Listing

# average_numbers_hash.pl # Author : Jake R. Pomperada,MAED-IT,MIT # Date : April 15, 2020 Tuesday 9:12 AM # Location : Bacolod City, Negros Occidental # Email : jakerpomperada@gmail.com # Websites : http://www.jakerpomperada.com # http://www.jakerpomperada.blogspot.com @$number_values=(1..50); my %val_num = (1 => 5, 2 => 10, 3 => 15, 4 => 20, 5 => 25, ); printf("\n"); printf("\tAverage of Number Using Hash in Perl\n"); printf("\n"); printf("\tEnter The Array Size Based on the Key Values (1..5) : "); chomp($num_input=<STDIN>); printf("\n"); for ($a=0; $a<$val_num{$num_input}; $a++) { printf("\tGive Value in Item No. %d: ",$a+1); chomp($number_values[$a]=<STDIN>); $sum+=$number_values[$a]; } $average = ($sum/$a); print("\n"); printf("\tThe total sum is %.2f.\n",$sum); printf("\tThe average is %.2f.",$average); printf("\n\n"); printf("\t\tEnd of Program"); printf("\n\n");

Tuesday, April 14, 2020

Bubble Sort Using Arrays in Perl

Write a program using a one-dimensional array to implement a bubble sort algorithm.
The program will ask the user how many items to be processed and then the program will
display the original arrangement of the numbers and then display the sorted
arrangement of the numbers on the screen.

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/

Sample Program Output

Program Listing

# bubble_sort_array.pl

# Author : Jake R. Pomperada,MAED-IT,MIT

# Date : April 11, 2020 Saturday 4:19 PM

# Location : Bacolod City, Negros Occidental

# Email : jakerpomperada@gmail.com

# Websites : http://www.jakerpomperada.com

# http://www.jakerpomperada.blogspot.com

@$items=(1..50);

$num_input,$a=0;

$b=0,$temp=0;

printf("\n\n");

printf("\tBubble Sort Using Arrays in Perl");

printf("\n\n");

printf("\tGive the size of array: ");

chomp($num_input=<STDIN>);

printf("\n");

for($a=0;$a<$num_input;$a+=1)

{

printf("\tEnter Grade No. %d : ",$a+1);

chomp($items[$a]=<STDIN>);

}

printf("\n\n");

printf("\tOriginal Array Elements Arrangement");

printf("\n");

printf("\t");

for($a=0;$a<$num_input;$a+=1) {

printf("%d ",$items[$a]);

}

# Bubble Sort Code

for($a=1;$a<$num_input;$a+=1)

{

for($b=0;$b<($num_input-$a);$b+=1) {

if($items[$b]>$items[$b+1])

{

$temp=$items[$b];

$items[$b]=$items[$b+1];

$items[$b+1]=$temp;

}

printf("\n\n");

printf("\tSorted Array Elements Arrangement");

printf("\n");

printf("\t");

for($a=0;$a<$num_input;$a+=1) {

printf("%d ",$items[$a]);

}

printf("\n\n");

printf("\tEnd of Program");

printf("\n\n");

Multiplication Table Generator Using Hash in Perl

Write a program using hash that will ask the user to give a key value based on
the follow key values 5=>5,6=>6,7=>7,8=>8,9=>9 and 10=>10. The program will
generate multiplication table based on the user key values given. I am usin strawberry Perl as my Perl interpreter in writing this program.

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/

Sample Program Output

Program Listing

# multiplication_table_hash.pl

# Author : Jake R. Pomperada,MAED-IT,MIT

# Date : April 14, 2020 Tuesday 2:35 PM

# Location : Bacolod City, Negros Occidental

# Email : jakerpomperada@gmail.com

# Websites : http://www.jakerpomperada.com

# http://www.jakerpomperada.blogspot.com

my %val_num = (5 => 5,

6 => 6,

7 => 7,

8 => 8,

9 => 9,

10 => 10,

);

printf("\n");

printf("\tMultiplication Table Generator Using Hash in Perl\n\n");

printf("\n");

printf("\tEnter a Key Number : ");

chomp( $val = <>);

printf("\n");

for $-(1..$val_num {$val}){

printf'%5d',$_*$-for 1..$val_num{$val};

print$/

}

printf("\n");

print " "// "The Key '$a' doesn't exist.\n";

printf("\n");

printf("\t\tEnd of Program");

printf("\n\n");

Volume of Cylinder Solver in C

I wrote this program to explain how to calculate volume of cylinder using the C programming language.

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

/* This program is used to explain how to calculate
volume of cylinder using C programming language */

/* Author : Jake Rodriguez Pomperada,MAED-IT,MIT */
/* Date : April 13, 2020 9:00 AM Monday */
/* Location : Bacolod City, Negros Occidental Philippines. */

#include <stdio.h>
#include <stdlib.h>

int main()
{
float r=0.00,h=0.00,v=0.00;
printf("\tVolume of Cylinder Solver in C");
printf("\n\n");
printf("\tGive Radius & Height of Cylinder : ");
scanf("%f%f",&r,&h);

v = 3.14 * r * r * h; /* Calculation of Volume */
printf("\n\n");
printf("\tThe Volume of Cylinder is %5.2f.",v);
printf("\n\n");
printf("\tEnd of Program");
printf("\n\n");
system("pause");

}

Alert Box in JavaScript

I wrote this simple program using JavaScript to show how to declare and use alert box.

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

index.htm

<html>
<head>
<title>Alert Box in JavaScript </title>
</head>
<body>
<h1> Alert Box Demo in JavaScript </h1>
<script type="text/javascript">
alert("Welcome to JavaScript Programming");
</script>
</body>

</html>

Average Grade Solver Using Array in Perl

I wrote this program to ask the user to give five grades and then the program will compute the average grade of the student in the subject and determine whether the student pass or fail in that subject using Perl programming language.

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/

Sample Program Output

Program Listing

# average_grade_array.pl

# Author : Jake R. Pomperada,MAED-IT,MIT

# Date : April 11, 2020 Saturday 2:49 PM

# Location : Bacolod City, Negros Occidental

# Email : jakerpomperada@gmail.com

# Website : http://www.jakerpomperada.com

@$grades=(1..5);

$a=0,$solve=0,$sum=0;

printf("\n");

printf("\t\tAverage Grade Solver Using Array in Perl");

printf("\n\n");

for ($a=0; $a<=4; $a+=1) {

printf("\tEnter Grade No. %d : ",$a+1);

chomp($grades[$a]=<STDIN>);

}

printf("\n\n");

for ($a=0; $a<=4; $a+=1) {

$sum+= $grades[$a];

$solve=($sum/5);

}

printf("\tThe average grades is %d. ",$solve);

printf("\n");

if ($solve >=75) {

printf("\n");

printf("\tYou Passed the subject.");

}

else {

printf("\n");

printf("\tYou Failed the subject.");

}

printf("\n\n");

printf("\tEnd of Program");

printf("\n\n");

Free Programming Source Codes and Computer Programming Tutorials

Friday, April 17, 2020

Printing a Report Using JavaScript

Math Machine Problem Functions C++

Wednesday, April 15, 2020

Average of Number Using Hash in Perl

Tuesday, April 14, 2020

Bubble Sort Using Arrays in Perl

Multiplication Table Generator Using Hash in Perl

Volume of Cylinder Solver in C

Volume of Cylinder Solver in C

Alert Box in JavaScript

Alert Box in JavaScript

Average Grade Solver Using Array in Perl

Google Ads

Followers