Tag: company

Employee Bonus Calculation: C

In this c program, we ask the user/employee to enter current year and his / her year of joining the organization/company. We check if the employee has served the company / organization for more than 3 years. If yes, then we give him/her a bonus of $2500 and if he or she has served for less than 3 years we’ll give $1000 as bonus.

Related Read:
if else statement in C
Relational Operators In C

Source Code: Employee Bonus Calculation: C

view plaincopy to clipboardprint?
  1.    
  2. #include < stdio.h >  
  3.   
  4. int main()  
  5. {  
  6.     int bonus, cy, yoj;  
  7.   
  8.     printf("Enter current year and year of joining\n");  
  9.     scanf("%d %d", &cy, &yoj);  
  10.   
  11.     if( (cy - yoj) > 3 )  
  12.     {  
  13.         bonus = 2500;  
  14.     }  
  15.     else  
  16.     {  
  17.         bonus = 1000;  
  18.     }  
  19.   
  20.     printf("You get a bonus of %d \n", bonus);  
  21.   
  22.     return 0;  
  23. }  

Output 1:
Enter current year and year of joining
2019
2017
You get a bonus of 1000

Output 2:
Enter current year and year of joining
2019
2014
You get a bonus of 2500

C Program to Calculate Employee Bonus



YouTube Link: https://www.youtube.com/watch?v=nB7ngERD3Tc [Watch the Video In Full Screen.]


In this program we check if the employee has worked for 3 years in the organization or not. We subtract his year of joining from current year and then based on that we decide his or her bonus.

For full C programming language free video tutorial list visit:C Programming: Beginner To Advance To Expert

Dynamic Suggested List: HTML5 + jQuery + PHP + MySQL

Today lets build a dynamic suggested list input field using HTML5, jQuery, PHP and MySQL.

Dynamic-suggested-list-html5-jquery-php-mysql

We have 55 company names in our database table – and the import file(.sql) can be downloaded at the end of this tutorial page. By using jQuery we pass user input to suggest.php file and the result is embedded into index.html file.

Related read: Suggested Entries Using datalist Element: HTML5

HTML file
index.html

view plaincopy to clipboardprint?
  1. <!DOCTYPE HTML>  
  2. <html>  
  3. <head>  
  4. <title>Dynamic Auto-Suggestion using datalist element: HTML5</title>  
  5. <meta charset="utf-8"/>  
  6. <script src="jQuery.js"></script>  
  7. <script src="myScript.js"></script>  
  8. </head>  
  9. <body>  
  10.    
  11. <form>  
  12. <input type="text" list="myCompanies" name="company" id="suggest" />  
  13. <datalist id="myCompanies">  
  14.    
  15. </datalist>  
  16. </form>  
  17.    
  18. </body>  
  19. </html>  

Here we have included jQuery library file before our script myScript.js
We also have an input field of type text, with an id = suggest, name = company and list = myCompanies. And a datalist element is linked/associated with input field, by matching it’s id with the name of input field’s list attribute. The value for option tag will be filled by jQuery, using the results output by suggest.php file.

PHP file
suggest.php

view plaincopy to clipboardprint?
  1. < ?php  
  2.   
  3.     $db         = mysqli_connect('localhost', 'root', '', 'search');  
  4.       
  5.     $company    = $_GET['company'];  
  6.       
  7.     $sql        = "SELECT name FROM table1 WHERE name like '$company%' ORDER BY name";  
  8.       
  9.     $res        = $db->query($sql);  
  10.       
  11.     if(!$res)  
  12.         echo mysqli_error($db);  
  13.     else  
  14.         while( $row = $res->fetch_object() )  
  15.             echo "<option value="".$row->name."">";  
  16.           
  17. ?>  

Here we connect php file to database(search). Get the keyword entered by the user in the input field and form a sql query. By using query() method, we process it and finally format it the way we need it i.e., we wrap the company names inside option tag’s value attribute.

jQuery file
myScript.js

view plaincopy to clipboardprint?
  1. $(document).ready(function(){  
  2.     $("#suggest").keyup(function(){  
  3.         $.get("suggest.php", {company: $(this).val()}, function(data){  
  4.             $("datalist").empty();  
  5.             $("datalist").html(data);  
  6.         });  
  7.     });  
  8. });  

For every keyup event on the input field we trigger jQuery method $.get() and pass the user input keys to suggest.php file and the result is collected back by the callback function and the result set is stored in a variable called data.

Now we first make sure to clear out previous data present inside datalist element i.e., we clear the previous results by removing any option tags present inside datalist element. Now we fill the datalist element with the new data/result output from suggest.php file.

Since we’re using jQuery here, page does not reload and the suggested entries looks real and spontaneous.

Here is the list of company names I’ve taken for this tutorial

3M
7-Eleven
Accenture
Acer
Adidas
Adobe systems
Amazon.com
AMD
AOL
Apache
Apple inc
Appolo group
Aricent
Ask.com
Asus
AT&T
Bank of America
BBC
BE Aerospace
BMC Software
Boeing
Bosch Brewing Company
Boston Acoustic
CA Technologies
Citrix Systems
Cognizant Technolog
Cognizant Technology Solutions
Convergys
Dell
Delphi
DHL
Divx Inc
eBay
EMC Corporation
Exelon
Facebook
Ford Motor Company
Fox Entertainment Group
GCI
GoDaddy
Goodrich Corporation
Google
Hawaiian Airlines
Hewlett-Packard
Honeywell
IBM
Intel
Johnson & Johnson
KFC
McDonalds
Microsoft
Motorola
Nvidia
Red Hat
Yahoo!

Video Tutorials: Dynamic Suggested List: HTML5 + jQuery + PHP + MySQL



YouTube Link: https://www.youtube.com/watch?v=YqMtE8UO-xw [Watch the Video In Full Screen.]


Note: For any older browsers which do not support datalist element or list attribute, it will simply fall back to text type input field and it doesn’t produce any error.