Calculating Age from Birthdate

Calculate age from given birthdate

How to Calculate Age from Date of Birth in PHP

<?php

$dateOfBirth = "21-12-1983";
$today = date("Y-m-d");
$diff = date_diff(date_create($dateOfBirth), date_create($today));
echo 'Age is '.$diff->format('%y');

?>




VB6 Code

Function Age (varBirthDate As Variant) As Integer 

 Dim varAge As Variant 

 If IsNull(varBirthdate) then Age = 0: Exit Function 

 varAge = DateDiff("yyyy", varBirthDate, Now) 
 If Date < DateSerial(Year(Now), Month(varBirthDate), _ 
 Day(varBirthDate)) Then 
 varAge = varAge - 1 
 End If 
 Age = CInt(varAge) 

 End Function

Forcefully Close a Program in Ubuntu

How to close a program from the terminal in ubuntu

1. The program name with:

   pkill <name_of_program>
   

2. use of program PID (process id)
   • kill it with kill <PID>

Steps for close program

1. open a Terminal window

2. To view a list of running processes, enter the following text at the prompt and press Enter.

$ ps -A

eg : pkill filezilla   - use program name.


To kill a process using its PID, enter the “killall” command (without the quotes) at the prompt, followed by a space, and then the corresponding PID from the generated list. Press Enter.

How to play audio and video files in the background on Android

How to set play mx player in the background  on android mobile

Open your mobile

Just launch MX Player app and then press the menu icon at the top-right side of the screen.

Go to choose "Play".    or  (Go to “Settings” and then choose “Player”.)

Check the box next to “Background Play"  

How to enable background play. 

Always On Top for YouTube Video in Google Chrome

First select Google Chrome Settings and click to Extension menu.

Check Extension for app Always On Top for YouTube.

Launch icon your browser.

Click this icon and show your video always on top.

Thank You

Android Menu

Menus

Menus are a common user interface component in many types of applications.

This guide shows how to create the three fundamental types of menus or action presentations on all versions of Android:

Options menu and app bar
The options menu is the primary collection of menu items for an activity. It's where you should place actions that have a global impact on the app, such as "Search," "Compose email," and "Settings."

Context menu and contextual action mode
A context menu is a floating menu that appears when the user performs a long-click on an element. It provides actions that affect the selected content or context frame.

Popup menu
A popup menu displays a list of items in a vertical list that's anchored to the view that invoked the menu.

Android Option Menu Example

Defining a Menu in XML

It contains three items as show below. It is created automatically inside the res/menu directory.

menu with the following elements:

<menu>

Defines a Menu, which is a container for menu items. A <menu> element must be the root node for the file and can hold one or more <item> and<group> elements.

<item>

Creates a MenuItem, which represents a single item in a menu. This element may contain a nested <menu> element in order to create a submenu.

<group>

An optional, invisible container for <item> elements. It allows you to categorize menu items so they share properties such as active state and visibility. For more information, see the section about Creating Menu Groups.

<menu xmlns:androclass="http://schemas.android.com/apk/res/android" >      <item  android:id="@+id/item1"  
        android:title="Item 1"/> 
   <item  android:id="@+id/item2"  
        android:title="Item 2"/>  
    <item  android:id="@+id/item3"  
        android:title="Item 3"/>  
</menu>  


More Details

Write a Program to create menu with three menu items

Example

activity_main.xml

<?xml version="1.0" encoding="utf-8"?><RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:paddingBottom="@dimen/activity_vertical_margin"    android:paddingLeft="@dimen/activity_horizontal_margin"    android:paddingRight="@dimen/activity_horizontal_margin"    android:paddingTop="@dimen/activity_vertical_margin"    tools:context="com.example.root.myapplication.MainActivity">

    <TextView        android:layout_width="wrap_content"        android:layout_height="wrap_content"        android:text="Menu Program" />
</RelativeLayout>

main.xml   //main.xml file in res/menu

<?xml version="1.0" encoding="utf-8"?><menu xmlns:android="http://schemas.android.com/apk/res/android">

<item android:id="@+id/item1"    android:title="item1" />
<item android:id="@+id/item2"    android:title="item2" />
<item android:id="@+id/item3"    android:title="item3" />

</menu>

MainActivity.java

package com.example.root.myapplication;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    @Override    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    @Override    public boolean onCreateOptionsMenu(Menu menu){

        getMenuInflater().inflate(R.menu.main,menu);
        return true;
    }

    @Override    public boolean onOptionsItemSelected(MenuItem item) {
        int id = item.getItemId();
        if (id == R.id.item1) {
            Toast.makeText(getApplicationContext(), "First Item Selected!",
                    Toast.LENGTH_SHORT).show();
        }
        if (id == R.id.item2) {
            Toast.makeText(getApplicationContext(), "Second Item Selected!", Toast.LENGTH_SHORT).show();
        }
        if (id == R.id.item3) {
            Toast.makeText(getApplicationContext(), "Third Item Selected!",
                    Toast.LENGTH_SHORT).show();
        }
        return true;
    }


}

Problem - res/menu and res/xml are not there

down vote

If it is in android studio 2.1.1, to create a res/menu folder follow these steps. right click on res -> new -> Android resource directory -> change the resource type to 'menu' in the dropdown menu -> click ok to create menu file in menu folder right click on menu folder -> new -> menu resource file ->give the file name -> click ok.

Yii2 dropdown multiple selected

MultiSelect Widget for Yii2

It supports searching, remote data sets, and infinite scrolling of results.

https://github.com/kartik-v/yii2-widget-select2

Kartik Multiselect widget

in _form.php

use kartik\select2\Select2;



<?php
    echo Select2::widget([
        'model' => $model,
        'name' => 'certificates',
        'attribute' => 'certificates',
        'data' => ArrayHelper::map(Mulcertificates::find()->orderBy('description')->all(),'id','description'),  //['1'=>'1','2'=>2],
        'options' => [
            'placeholder' => 'Select certificates ...',
            'multiple' => true
    ],
    ]);
    ?>


Controller.php

public function actionCreate()
    {
        $model = new Mulselect();

        if ($model->load(Yii::$app->request->post())) {
         
            $model->certificates = implode(",",$model->certificates);
            
            $model->save();
            return $this->redirect(['view', 'id' => $model->id]);
         
        } else {
            return $this->render('create', [
                'model' => $model,
            ]);
        }
    }


 public function actionUpdate($id)
    {
        $model = $this->findModel($id);

        if ($model->load(Yii::$app->request->post()) && $model->save()) {
            return $this->redirect(['view', 'id' => $model->id]);
        } else {
            $model->certificates= explode(',', $model->certificates);
            return $this->render('update', [
                'model' => $model,
            ]);
        }
    }


Links

Select2 Widget 

2amigos/yii2-multi-select-widget

PHP - MySQL - Connection

MySQL Connection Using PHP Script

PHP provides mysql_connect() function to open a database connection.

Syntax

connection mysql_connect(server,user,passwd,new_link,client_flag);

Returns a MySQL link identifier on success or FALSE on failure.

Example

<?php
         $dbhost = 'localhost';
         $dbuser = 'test';
         $dbpass = 'Ii@21!abg';

         $conn = mysql_connect($dbhost, $dbuser, $dbpass);

         if(! $conn ) {
            die('Could not connect: ' . mysql_error());
         }
         echo 'Connected successfully<br>';

         $sql = 'SELECT id, name, course FROM std';

         mysql_select_db('ellorahs_test');
         $retval = mysql_query( $sql, $conn );
   
         if(! $retval ) {
              die('Could not get data: ' . mysql_error());
         }
   
         while($row = mysql_fetch_array($retval, MYSQL_ASSOC)) {
            echo "ID :{$row['id']}  <br> ".
                 "Name : {$row['name']} <br> ".
                 "Course : {$row['course']} <br> ".
                 "--------------------------------<br>";
         } 

         echo "Fetched data successfully\n";

         mysql_close($conn);
?>

mysql_close()

Disconnect from the MySQL database anytime using another PHP function mysql_close().

SELECT command is used to fetch data from the MySQL database. 

Selecting a MySQL Database Using PHP



mysql_select_db to select a database. 

It returns TRUE on success or FALSE on failure.

Fetching Data Using a PHP

The SQL SELECT command is used to fetch data from the MySQL database.

SELECT command into a PHP function mysql_query().

mysql_fetch_array() can be used to fetch all the selected data.