Google search

Basic and advanced computer skills like Excel with macros, How to speed up your PC, C, CPP, Java programming, HTML, JavaScript, PHP, Wordpress, all web tools, Android tutorials, MySQL Tutorials, WAMP server installation. etc.

PHP Function, Cookies, Session examples

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...
function without parameter





2. PHP Program to use of function with parameters.
<?php
function add($a, $b)
{
$c=$a+$b;
echo "sum=", $c;
}
add(2,5);
?>

 3. PHP Program to create cookies.
<html>
   <head>
    <title>Set Cookies</title>
   </head>

<?php
setcookie("username", "Raj", time()+120, "/","", 0);
setcookie("age", "50", time()+120, "/", "",  0);
setcookie("country", "India", time()+120, "/", "",  0);
?>
   
  <body>
    <?php echo "Setting Cookies..." ?>
   </body>
   
</html>
setting cookies


4. PHP Program to retrieve cookies values [from above program]
  <?php
echo "<h1>Fetching Cookies Value </h1>";
         echo $_COOKIE["username"]. "<br>";
         echo $_COOKIE["age"] . "<br>";
         echo $_COOKIE["country"] . "<br>";
      ?>


fetching cookies values





5. PHP Program to retrieve server information using super global variables. 
<?php 
echo "<h1> PHP Superglobal variables </h1>"; 
echo "Location:",$_SERVER['SERVER_NAME'];
echo "<br>";
echo "Port number:",$_SERVER['HTTP_HOST'];
echo "<br>";
echo "Browser info:", $_SERVER['HTTP_USER_AGENT'];
echo "<br>";
echo "File name:", $_SERVER['SCRIPT_NAME'];
?>

 Output of the program is...
superglobal-variables








6. PHP Program to use of SESSIONS.
<?php
   session_start();
   if( isset( $_SESSION['c'] ) ) 
{
 $_SESSION['c'] += 1;
}

else
{
$_SESSION['c'] = 1;
}
    
 $msg = "You are visitor number : ". $_SESSION['c'];
?>
<?php  echo ( $msg ); ?>

 Above program produces following output.
session-examples



7. PHP example to demonstrate destroy the sessions.
<?php
session_start();
session_destroy();
echo "<h1> Session destroyed!</h1>";
?>

And the output is...
session destroyed





No comments:

Skill India

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 Policy for Skill Development and Entrepreneurship.
  • Skill Loan scheme.    
Important links about Skill India.

Eligibility : Any one can register at affiliated diploma / engineering college / partners institute to use this opportunity to learn skills required for the today's competitive job market. 

Age : No age bar.

Course fee: Completely FREE!

Certification : Yes! Govt of India recognized.


P S: Country is facing acute shortage of skilled manpower in all areas, specially technical field. Hence it is important to gain job skills for our youth of this country to get desired job and improve our economy at next level. 

 For detail of this skill India and its various verticals you can find here.   

 We heartly thank to our beloved PM Modiji for stressing on this matter and bringing it into practical.
Jai Hind! Vande Mataram! Bharath Mata Ki Jai!
No comments:

MIT India Tech Blog: Applet Programming

MIT India Tech Blog: Applet Programming
No comments:

Skill development courses and its benefits

Skill development courses and its benefits

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.
Skill development

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 when it comes to work places.

In the 21st century, to get a job, one must have perfect skill set to face organizational challenges and its demands.

  In olden days, to acquire a skill was time consuming and of course matters lots of money but in present (Thanks to internet and mobiles!), due to advancement in the internet and its technology one can learn any type of course and gain excellence in that to faces challenges and improves his/her career prospective in the job market.

A simple example depicts here that if one wants to become a web developer, he/she needs to learn basics of web and its various designing tools like HTML/CSS/FORM/Photoshop/Corel Draw etc and also development tools / programming skills like Javascript/PHP or Database skills like MySQL/MSSQL/Oracle etc.

Not just learning the above skills makes one a perfect web designer/developer but practice and hard work with lots of dedication and patience make them to great career openings and getting good jobs.

So how to practice these things and on what basis?
Let’s talk about practical!, about 4 to 6 hours daily practices on different topics / web assignment work and perfection in every bit of things you do.


For example you may start a simple web assignment called “Web site on college administration” and decide how many pages can be developed with static and dynamic pages as well. For static its quite simple text with neat banner and well color combination but for dynamic it’s all about use of your programming logic behind the web page that how web page should behave with regards to event made by users (exa: after login where should be landing page and how track cookies etc). 

For further topics and sessions on skill development you can stay tuned to my blog.

Thank you! for reading and referring above article. 
No comments:
Labels:

Calculate Employee salary using MS Excel

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 value "D3" means  basic salary so all  values calculated on the basis of basic salary] 
Step 5: Press and Drag towards down to fill all cells as following.


 Step 6: repeat the step 4 to calculate  remaining columns and only change percentage values.







Step 7: Now, calculate the Net salary just by adding all columns and have a look at following image.













Step 8: To calculate Total Years of experience, just write the following equation to get it.












For Total Years of experience column, after getting result just right click and format cells and select number to get correct values.

 That's all for now!
No comments:

Mail merge using Microsoft Word

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: Open MS Word

Step3: Go to “Mailings” Tab

Step4: Click on “Select Recipient”

Step5: Select “Type New List”




Step6: Enter address as following
Step7: Click on “Insert merge field”
















Step8: Select Field name and their location to insert in.














Step9: Click on “Preview” button








After clicking on preview, you can see entered addresses, as following screen shot










Simple Marks calculation using Excel 


No comments:
Labels: ,

PHP-Database Programs

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 successfully';
}
?>

 The above program will show following output.





2. PHP Program to create database from localhost.
<?php
$con=mysqli_connect("localhost","root","");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="CREATE DATABASE demo_12";

if (mysqli_query($con,$sql))
  {
  echo "Database demo_12 created successfully";
  }
else
  {
  echo "Error creating database: " . mysqli_error();
  }
?>

 The above program produces following output.




3. PHP Program to create a table in database from localhost.
<?php
$con=mysqli_connect("localhost","root","","demo_12");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$sql="CREATE TABLE emp_ret(FirstName CHAR(30),LastName CHAR(30),Age INT)";

if (mysqli_query($con,$sql))
  {
  echo "Table emp_ret created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error();
  }
?>

 The above program will have a following output.





4. PHP Program to connect MS Access Database using ODBC Data source. [Click here to create DSN (Data Source Naming) for MS Access.]
<html>
<body>
<h3 style="background-color:yellow"> Connecting to Ms 

Access Database using PHP </h3>
<hr>
<?php
$conn=odbc_connect('acc_php','','');
if (!$conn)
 {
exit("Connection Failed: " . $conn);
}
$sql="SELECT * FROM Cust";
$rs=odbc_exec($conn,$sql);

if (!$rs)
{
exit("Error in SQL");
}
echo "<table border=1><tr>";
echo "<th>Customer Code</th>";
echo "<th>Customer Name</th>";
echo "<th>Address</th></tr>";
while (odbc_fetch_row($rs))
  {
  $c_code=odbc_result($rs,"ccode");
  $c_name=odbc_result($rs,"cname");
  $c_addr=odbc_result($rs,"caddr");
  echo "<tr><td>$c_code</td>";
  echo "<td>$c_name</td>";
  echo "<td>$c_addr</td></tr>";
  }
odbc_close($conn);
echo "</table>";
?>
</body>
</html>

 The above program produces following output.







That's all for now! for more PHP and MySQL programs click here

No comments:
Subscribe to: Posts (Atom)