PHP THREE

php five

<?php

if (isset ($_POST ['b1'])){

function add() {
$a = $_POST ['num1'];
$b = $_POST ['num2'];
echo  $a + $b ;
}
?>
   <h3>  <?php add () ?> </h3>
   <?php
}
?>

<?php

if (isset ($_POST ['b2'])){

function add() {
$a = $_POST ['num1'];
$b = $_POST ['num2'];
echo  $a - $b ;
}
?>
   <h3>  <?php add () ?> </h3>
   <?php
}
?>

<?php

if (isset ($_POST ['b3'])){

function add() {
$a = $_POST ['num1'];
$b = $_POST ['num2'];
echo  $a * $b ;
}
?>
   <h3>  <?php add () ?> </h3>
   <?php
}
?>

<?php

if (isset ($_POST ['b4'])){

function add() {
$a = $_POST ['num1'];
$b = $_POST ['num2'];
echo  $a / $b ;
}
?>
   <h3>  <?php add () ?> </h3>
   <?php
}
?>


<form method="post">
<label> Enter first number </label>
<input type="number" name="num1"/> 

</br>
 </br>
     
     
<label> Enter second number </label>
<input type="number" name="num2"/>     
        </br>
        </br>
        <input type="submit" value="Add" name="b1"/>
     
        <input type="submit" value="Sub" name="b2"/>
     
        <input type="submit" value="Mulip" name="b3"/>
     
        <input type="submit" value="Divid" name="b4"/>
   
</form>

Aggregate funtion in mysql

AVG()

BIT_AND()

BIT_OR()

BIT_XOR()

COUNT(DISTINCT)

COUNT()

GROUP_CONCAT()

MAX()

MIN()

STD()

STDDEV_POP()

STDDEV_SAMP()

STDDEV()

SUM()

VAR_POP()

VAR_SAMP()

VARIANCE()

Set password in mysql xampp

You want to edit this file: "\xampp\phpMyAdmin\config.inc.php"

change this line:

$cfg['Servers'][$i]['password'] = 'WhateverPassword';

Remote Connection Guide

1. Right Click on This PC
2. Goto to Properties
3. Click advanced system settings
4. Click Remote
5. Allow remote connection to this computer
6. disallow the below one
7. click ok

then 

1. type credential manager in search
2.  select windows credential
3. remove all credential 
4. and make new one with your username and password in windows credential

then

1. Goto another computer and type open remote desktop connection and type than name of that computer where you selected allow option and then type credential of your system thats it.