Tuesday, April 23, 2019

Factorial Solver Using For Loop Statement in Python

A simple program to show how to use for loop statement in Python to solve factorial values.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com


Program Listing

print()
print("\tFactorial Solver Using For Loop Statement")
print()
factorial = 1
num = int(input("\tGive a Number : "))
for i in range(1, num + 1):
    factorial = (factorial* i)
print()
print("\tThe factorial value of ", num, " is ", factorial,'.')
print()
print("\tEND OF PROGRAM");


Thursday, April 18, 2019

Shell Sort in C

Here is a program will sort the series of a number using shell sort algorithm using C language.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com


Sample Program Output


Program Listing

/* shell_sort.c
   Author   : Mr. Jake Rodriguez Pomperada,BSCS,MAED-IT
   Tool     : Dev C++ 5.11
   Date     : April 18, 2019  Thursday   10:53 AM
   Website  : www.jakerpomperada.com
   Email    : jake_pomperada@tup.edu.ph and jakerpomperada@gmail.com
   Location : Bacolod City, Negros Occidental
*/

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

void shellsort(int arr[], int num);

int main()
{
 int items[1000], num=0,min=0,loc=0;
 int c=0, b=0,change=0,j=0,temp=0;
 system("cls");
 printf("\n\n");
 printf("\tShell Sort Program in C");
 printf("\n\n");
 printf("\tHow many items? : ");
 scanf("%d", &num);
 printf("\n\n");
 for (c= 0; c < num; c++) {
    printf("\tEnter item no. %d: ", c+1);
    scanf("%d", &items[c]);
 }
printf("\n\n");
printf("\tOriginal Arrangement of Numbers");
printf("\n\n");
 for ( c = 0 ; c < num ; c++ ) {
   printf("\t%d ",items[c]);
 }
 shellsort(items, num);
 printf("\n\n");
 printf("\tAsceding Order of Numbers");
 printf("\n\n");
 for ( c = 0 ; c < num ; c++ ) {
 printf("\t%d ", items[c]);
 }  
printf("\n\n");
printf("\tEnd of Program");
printf("\n\n");
system("pause");
}

void shellsort(int arr[], int num)
{
    int i, j, k, tmp;
    for (i = num / 2; i > 0; i = i / 2)
    {
        for (j = i; j < num; j++)
        {
            for(k = j - i; k >= 0; k = k - i)
            {
                if (arr[k+i] >= arr[k])
                    break;
                else
                {
                    tmp = arr[k];
                    arr[k] = arr[k+i];
                    arr[k+i] = tmp;
                }
            }
        }
    }
}



Bucket Sort in C

Here is a program that I wrote to ask the user to give a series of numbers and then the program will sort the series of a number using bucket sort algorithm using C language.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com



Sample Program Output


Program Listing

/* bucket_sort.c
   Author   : Mr. Jake Rodriguez Pomperada,BSCS,MAED-IT
   Tool     : Dev C++ 5.11
   Date     : April 18, 2019  Thursday   12:56 AM
   Website  : www.jakerpomperada.com
   Email    : jake_pomperada@tup.edu.ph and jakerpomperada@gmail.com
   Location : Bacolod City, Negros Occidental
*/

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

struct bucket 
{
    int count;
    int* value;
};

int compareIntegers(const void* first, const void* second)
{
    int x = *((int*)first), y =  *((int*)second);
    if (x == y)
    {
        return 0;
    }
    else if (x < y)
    {
        return -1;
    }
    else
    {
        return 1;
    }
}

void bucket_sort(int array[],int n)
{
    struct bucket buckets[3];
    int i, j, k;
    for (i = 0; i < 3; i++)
    {
        buckets[i].count = 0;
        buckets[i].value = (int*)malloc(sizeof(int) * n);
    }
    
    for (i = 0; i < n; i++)
    {
        if (array[i] < 0)
        {
            buckets[0].value[buckets[0].count++] = array[i];
        }
        else if (array[i] > 10)
        {
            buckets[2].value[buckets[2].count++] = array[i];
        }
        else
        {
            buckets[1].value[buckets[1].count++] = array[i];
        }
    }
    for (k = 0, i = 0; i < 3; i++)
    {
        qsort(buckets[i].value, buckets[i].count, sizeof(int), &compareIntegers);
        for (j = 0; j < buckets[i].count; j++)
        {
            array[k + j] = buckets[i].value[j];
        }
        k += buckets[i].count;
        free(buckets[i].value);
    }
}



int main()
{
 int items[1000], num=0,min=0,loc=0;
 int c=0, b=0,change=0,j=0,temp=0;
 system("cls");
 printf("\n\n");
 printf("\tBucket Sort Program in C");
 printf("\n\n");
 printf("\tHow many items? : ");
 scanf("%d", &num);
 printf("\n\n");
 for (c= 0; c < num; c++) {
    printf("\tEnter item no. %d: ", c+1);
    scanf("%d", &items[c]);
 }
printf("\n\n");
printf("\tOriginal Arrangement of Numbers");
printf("\n\n");
 for ( c = 0 ; c < num ; c++ ) {
   printf("\t%d ",items[c]);
 }
  bucket_sort(items,num);

 printf("\n\n");
 printf("\tAsceding Order of Numbers");
 printf("\n\n");
 for ( c = 0 ; c < num ; c++ ) {
 printf("\t%d ", items[c]);
 }  
printf("\n\n");
printf("\tEnd of Program");
printf("\n\n");
system("pause");
}


Wednesday, April 3, 2019

Highest of the Three Numbers in Go

This sample program will ask the user to give three numbers and then the program will check which of the three numbers is the highest in terms of numerical value written in Go programming language.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com



Sample Program Output


Program Listing

package main

import "fmt"

var n1,n2,n3 int32

func main(){
fmt.Print("\n");
fmt.Print("\tHighest of the Three Numbers");
fmt.Print("\n\n");
fmt.Print("\tGive Three Numbers : ");
fmt.Scanln(&n1,&n2,&n3)
if(n1 >= n2 && n1 >= n3) {
fmt.Print("\n");
fmt.Print("\tThe highest number is ",n1,".");
}
if(n2 >= n1 && n2 >= n3) {
fmt.Print("\n");
fmt.Print("\tThe highest number is ",n2,".");
}
if(n3 >= n1 && n3 >= n2) {
fmt.Print("\n");
fmt.Print("\tThe highest number is ",n3,".");
}
fmt.Print("\n\n");
fmt.Print("\tEnd of Program");
fmt.Print("\n");
}



Automatic Teller Machine Simulation in Go

Here is a sample program that we wrote to simulate automatic teller machine using Go programming language. I hope you will find our code useful in learning Go.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com



Sample Program Output

Program Listing

/* atm.go   Written By :   Jake R. Pomperada   Rollyn M. Moises   Sunday Vince V. Latergo   April 3, 2019 Wednesday   Bacolod City, Negros Occidental*/
package main

import "fmt"
var bill1000,bill500,bill100,bill200,total_balance int32;
var withdraw, money_left int32;
var recieve1000,recieve500,recieve200,recieve100 int32;

func main(){
   fmt.Print("\n");
   fmt.Print("\tAutomatic Teller Machine Simulation");
   fmt.Print("\n\n");
   fmt.Print("\tHow many P1000 bills: ");
   fmt.Scanln( &bill1000);
   fmt.Print("\tHow many P500 bills: ");
   fmt.Scanln(&bill500);
   fmt.Print("\tHow many PHP 200 bills: ");
   fmt.Scanln(&bill200);
   fmt.Print("\tHow many PHP 100 bills: ");
   fmt.Scanln(&bill100);
   total_balance = (bill1000 * 1000)+(bill500 * 500) + (bill200 * 200) +  (bill100 * 100) ;
   fmt.Print("\n\n");
   fmt.Print("\tTotal Balance: PHP ", total_balance);
   fmt.Print("\n\n");
      fmt.Print("\tEnter amount to withdraw: PHP ");
      fmt.Scanln(&withdraw);
      money_left = withdraw ;
      if  (withdraw > total_balance) {
         fmt.Print("\tWithdraw amount greater than total balance.  ");
         fmt.Print("\n");
      }
      if (withdraw < total_balance)     {

         if  (money_left >= 1000 ) {
            recieve1000 = (money_left / 1000);
            if (recieve1000 > bill1000) {
               recieve1000 = bill1000;
               money_left = money_left - (recieve1000 * 1000);
               bill1000 = bill1000 - recieve1000;
            }
         }
      }
         if  (money_left >= 500 )   {
            recieve500 = (money_left / 500);
            if (recieve500 > bill500 ) {
               recieve500 = bill500;
            }
            money_left = money_left - (recieve500 * 500);
            bill500 = bill500 - recieve500;
         }

         if (money_left >= 200 ) {
            recieve200 = (money_left / 200);
            if (recieve200 > bill200) {
               recieve200 = bill200;
               money_left = money_left - (recieve200 * 200);
               bill200 = bill200 - recieve200;
            }
         }

         if (money_left >= 100 )    {
            recieve100 =(money_left / 100);
            if (recieve100 > bill100 ) {
               recieve100 = bill100;
            }
            money_left = money_left - (recieve100 * 100);
            bill100 = bill100 - recieve100;
         }

         fmt.Print("\tYou will receive:");
         fmt.Print("\n");
         fmt.Print("\tPHP 1000 bill :=> ", recieve1000);
         fmt.Print("\n");
         fmt.Print("\tPHP 500 bill :=>  ", recieve500);
         fmt.Print("\n");
         fmt.Print("\tPHP 200 bill :=>  ", recieve200);
         fmt.Print("\n");
         fmt.Print("\tPHP 100 bill :=>  ", recieve100);
         fmt.Print("\n\n");

         total_balance = total_balance - withdraw;

         fmt.Print("\tYour current balance is: PHP ",total_balance);
         fmt.Print("\n");
         fmt.Print("\tYou only have balance of:");
         fmt.Print("\n");
         fmt.Print("\tPHP 1000 bill :=> ",bill1000);
         fmt.Print("\n");
         fmt.Print("\tPHP 500 bill  :=> ",bill500);
         fmt.Print("\n");
         fmt.Print("\tPHP 200 bill  :=> ",bill200);
         fmt.Print("\n");
         fmt.Print("\tPHP 100 bill  :=> ",bill100);
         fmt.Print("\n\n");
         fmt.Print("\tEnd of Program");
         fmt.Print("\n");
}





Wednesday, March 27, 2019

Student Information System Using Python Flask and MySQL

Here is a simple program that we wrote using Python Flask and MySQL a simple student information system to store student name, email, and phone number. This will be our first web application written in Python and MySQL.

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com











Sample Program Output






Monday, March 25, 2019

EMPLOYEES INFORMATION SYSTEM IN PYTHON AND SQLITE

Here is my first database application that uses Python and SQLITE I called this program EMPLOYEES INFORMATION SYSTEM IN PYTHON AND SQLITE which allows the user to add,edit,delete,view and quit the program. The code is very simple yet easy to understand. I wrote this program for our upcoming book on Python programming with my best friend Mr. Rollyn M. Moises as my co-author. 

I am currently accepting programming work, 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 I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com





Sample Program Output


Program Listing

crud.py

"""
Simple CRUD in Python and SQLite
Authors :
Mr. Rollyn  M. Moises,MSCS
Mr. Jake R. Pomperada,MAED-IT
Date : March 25, 2019   Monday
Location :Bacolod City, Negros Occidental Philippines
"""

import sqlite3
import os

def create_table():
 conn = sqlite3.connect('employees.sqlite')

 cursor = conn.cursor()

 query = '''
     CREATE TABLE IF NOT EXISTS employee(
      id INTEGER PRIMARY KEY, 
      emp_id INTEGER, 
      name TEXT,
   position TEXT,
         department TEXT,
   salary TEXT
     )
 '''

 cursor.execute(query)
 conn.commit()
 conn.close()

def add_employee(emp_id,name,position,department,salary):
 conn = sqlite3.connect('employees.sqlite')

 cursor = conn.cursor()

 query = '''
     INSERT INTO employee(emp_id,name,position,department,salary)
              VALUES (?,?,?,?,?)
 '''
 cursor.execute(query,(emp_id,name.upper(),position.upper(),department.upper(),salary))
 conn.commit()
 conn.close()

def get_employees():
 conn = sqlite3.connect('employees.sqlite')

 cursor = conn.cursor()

 query = '''
     SELECT  emp_id,name,position,department,salary
     FROM employee
 '''

 cursor.execute(query)
 all_rows = cursor.fetchall()
 conn.commit()
 conn.close()
 return all_rows

def get_employee_by_emp_id(emp_id):
 conn = sqlite3.connect('employees.sqlite')
 cursor = conn.cursor()
 query = '''
     SELECT emp_id, name, position,department,salary
     FROM employee
     WHERE emp_id = {}
 ''' .format(emp_id)
 cursor.execute(query)
 all_rows = cursor.fetchall()
 conn.commit()
 conn.close()
 return all_rows

def update_employee(emp_id,name,position,department,salary):
 conn = sqlite3.connect('employees.sqlite')
 cursor = conn.cursor()
 query = '''
     UPDATE employee
     SET name = ?, position = ?,department = ?, salary = ?
     WHERE emp_id = ?
 '''
 cursor.execute(query,(name.upper(),position.upper(),department.upper(),salary.upper(),emp_id))
 conn.commit()
 conn.close()

def delete_employee(emp_id):
 conn = sqlite3.connect('employees.sqlite')
 cursor = conn.cursor()
 query = '''
     DELETE
     FROM employee
     WHERE emp_id = {}
 ''' .format(emp_id)

 cursor.execute(query)
 all_rows = cursor.fetchall()
 conn.commit()
 conn.close()
 return all_rows

create_table()


def add_data(id_,name,position,department,salary):
 add_employee(id_,name,position,department,salary)
def get_data():
 return get_employees()

def show_data():
 employees_record = get_data()
 for emp in employees_record:
  print(emp)

def show_data_by_id(id_):
 employees_record = get_employee_by_emp_id(id_)
 if not employees_record:
  print("No Data Found at emp_id",id_)
 else:
  print (employees_record)

def option():
 os.system('cls')
 print()
 print("\tEMPLOYEES INFORMATION SYSTEM IN PYTHON AND SQLITE")
 print()
 print("\t1.ADD RECORD \n\t2.SHOW RECORD\n\t3.FIND RECORDS\n\t4.EDIT RECORDS\n\t5.ERASE RECORDS\n\t6.QUIT PROGRAM")
 print()
 select_option= input("\tSELECT YOUR CHOICE ==> ")
 print()
 
 if select_option=='1':
  os.system('cls')
  id_emp = int(input('\tGive Employees ID : '))
  name = input('\tName: ')
  position = input('\tPosition: ')
  department = input('\tDepartment: ')
  salary = input('\tSalary: ')
  add_data(id_emp,name,position,department,salary)
  input("\n\tYour record has been saved.\n\tPRESS ENTER KEY TO RETURN TO MAIN MENU")
  option()
 elif select_option=='2':
  os.system('cls')
  show_data()
  input("\n\tPRESS ENTER KEY TO RETURN TO MAIN MENU")
  option()
 elif select_option=='3':
  os.system('cls')
  id__ = int(input('\tEnter Employees ID: '))
  show_data_by_id(id__)
  input("\n\tPRESS ENTER KEY TO RETURN TO MAIN MENU")
  option()
 elif select_option=='4':
  os.system('cls')
  id_emp = int(input('\tEnter Employees ID: '))
  show_data_by_id(id_emp)
  print()
  name = input('\tName: ')
  position = input('\tPosition: ')
  department = input('\tDepartment: ')
  salary = input('\tSalary: ')
  update_employee(id_emp,name,position,department,salary)
  input("\nYour data has been updated. \n\tPRESS ENTER KEY TO RETURN TO MAIN MENU")
  option()
 elif select_option=='5':
  os.system('cls')
  id_emp = int(input('\tEnter Employees ID: '))
  show_data_by_id(id_emp)
  delete_employee(id_emp)
  input("\n\tYour record has been deleted. \n\tPRESS ENTER KEY TO RETURN TO MAIN MENU")
  option()
 else:
   print()
   print("\tTHANK YOU FOR USING THIS SOFTWARE.")
   return 0;
   return 1;

while(option()):
 pass


DOWNLOAD SOURCE CODE HERE

Friday, March 15, 2019

Two Number Checker Using Python

Write a program that will ask the user to give two numbers and then the program will determine which of the two number is higher, lower or they are just the same numerical value.

Program Listing

# Rollyn M. Moises and Jake R. Pomperada
# two_numbers.py
# February 7, 2019  Thursday
# Bacolod City, Negros Occidental
print();
print("\t Two Number Checker ");
print();
x = int(input("\tEnter First  Value : "));
y = int(input("\tEnter Second Value : "));
if x < y:
    print();
    print("\t{0} is less than {1}.".format(x,y));
else:
    if x > y:
        print();
        print("\t{0} is greater than {1}.".format(x,y));
    else:
        print();
        print("\t{0} and {1} must be equal.".format(x,y));
print();
print("\tEND OF PROGRAM");