Health, Technology, Education

Submit checkbox value to MySQL

PHP-MySQL / SKB / June 21, 2016

Below example states that checkbox values can be stored into MySQL database using PHP program. Step 1: Create a table in MySQL with following screen shot. (Table name : Booked_Status) Step 2: Create connection string / configuration page as following example and name it ‘config2.php’ <?php $host=”localhost”; $username=”root”; $password=””; $dbname=”demo”; $con=mysql_connect(“$host”,”$username”,”$password”); mysql_select_db(“$dbname”,$con); ?> Step 3: […]

Submit checkbox value to MySQL Read More »

Gantt chart and PERT Chart

Tech / SKB / June 21, 2016

1. A Gantt chart: A Gantt chart is developed as a production control tool in 1917 by Henry L. Gantt, an American engineer. Gantt chart is frequently used in project management, this chart provides a graphical explaination of a schedule that helps to plan,research, analyse, coordinate, and track specific tasks in a project. To create

Gantt chart and PERT Chart Read More »

Password recovery example using php from MySQL

PHP-MySQL / SKB / June 21, 2016

To retrieve the password from your MySQL Database with using PHP script. Step 1 : Create a table called “users” in your MySQL database with following structure for the same. Step 2: Create a configuration file called ‘config.php’ which contains connection string and local host / remote server path. <?php $connection = mysql_connect(‘localhost’, ‘root’, ”);

Password recovery example using php from MySQL Read More »

Responsibilities of a typical Web developer

General, Management, PHP-MySQL, Tech, Wordpress / SKB / June 18, 2016

Before we begin about responsibilities of web developer, let’s understand more about what are the skills and qualifications are required to become a web developer. In web developing, various skills are required to master the huge world of web. Hence one needs to learn various technologies as following. For Designing: HTML, HTML5, CSS, CSS5,

Responsibilities of a typical Web developer Read More »

PHP-Database Programs

PHP-MySQL / SKB / June 18, 2016

Following are the various PHP programs to demonstrate Database connections. 1. PHP Program to demonstrates whether the connection to mysql database is active or not. <?php $dbhost = ‘localhost’; $dbuser = ‘root’; $dbpass = ”; $db = ‘mars_db’; $conn = mysql_connect($dbhost,$dbuser,$dbpass); if (!$conn) { die(‘Could not connect: ‘ . mysql_error()); } else { echo ‘Connected

PHP-Database Programs Read More »

Mail merge using Microsoft Word

General / SKB / June 18, 2016

Mail merge is used to create personalized letters and pre-written addressed envelopes. So one can send bulk emails or take prints without editing document. Mail merge contains addresses and main letter. Mail merge can be created using MS word and here are the steps to do same. Step1: Create a sample letter as following. Step2:

Mail merge using Microsoft Word Read More »

Calculate Employee salary using MS Excel

Excel, Management / SKB / June 18, 2016

The following example explains the calculation of Employee salary using MS Excel with simple understanding steps. Step 1 : Create a sheet with following data in it. Step 2: To calculate Bonus, click on “Insert Function” Step 3: select “if” from the list Step 4: Enter the formula as per following screen image [Here Cell

Calculate Employee salary using MS Excel Read More »

Skill development courses and its benefits

General, Management, Uncategorized / SKB / June 18, 2016

To work in a good company or organization one needs to have strong set of skills and it is very much needed in any organization. So skills refer to ability to work on specific technology (areas of one’s interest may be non technical also) and one needs to have specialized in any area of interest

Skill development courses and its benefits Read More »

Skill India

General / SKB / June 18, 2016

Skill India was launched by Indian Prime Minister Mr. Narendra Modi on 16th July 2015 to train over 40 Crore youth of this country by 2022 in different fields and sector. Skill India is initiated by Government of India and it includes following. National Skill Development Mission. Pradhan Mantri Kaushal Vikas Yojana (PMKVY). National

Skill India Read More »

PHP Function, Cookies, Session examples

1 Comment / PHP-MySQL / SKB / June 18, 2016

1. PHP Program to use of user-defined function. <?php function msg() { echo “Hello from msg function!”; } function test() { echo “Hello from test function!”; } test(); echo “<hr>”; msg(); ?> Output of above code is… 2. PHP Program to use of function with parameters. <?php function add($a, $b) { $c=$a+$b; echo “sum=”, $c;

PHP Function, Cookies, Session examples Read More »

PHP Array and Compressing Data

1 Comment / PHP-MySQL / SKB / June 18, 2016

Following example shows that use of an array to sort records in ascending and descending order using PHP program. <?php $arr = array(‘Apple’, ‘Zensor’, ‘MITIndia’); echo “ Without sorted values are.. ”; echo $arr[0], “ ”; echo $arr[1], “ ”; echo $arr[2], “ ”; echo “ Sorted values are.. ”; sort($arr); $len=count($arr); for($i=0; $i<$len; $i++) { echo $arr[$i], “ ”; } echo “ Reverse

PHP Array and Compressing Data Read More »