How To Create Custom Block Programatically

===============
.info File
===============

name = custom_block
description = My Custom Block using module
core = 7.x

===============
.Module File
===============

<?php

/**
 * Implements hook_block_info().
 */
function custom_block_block_info() {
    $blocks = array();
    $blocks['my_block'] = array(
        'info' => t('My Custom Block'),
    );

    return $blocks;
}

/**
 * Implements hook_block_configure().
 */
function custom_block_block_configure($delta = '') {
    $form = array();


    switch ($delta) {
        case 'my_block' :
            // Text field form element
            $form['text_body'] = array(
                '#type' => 'text_format',
                '#title' => t('Enter your text here in WYSIWYG format'),
                '#default_value' => variable_get('text_variable', ''),
            );

            // File selection form element
            $form['file'] = array(
                '#name' => 'block_image',
                '#type' => 'managed_file',
                '#title' => t('Choose an Image File'),
                '#description' => t('Select an Image for the custom block.  Only *.gif, *.png, *.jpg, and *.jpeg images allowed.'),
                '#default_value' => variable_get('block_image_fid', ''),
                '#upload_location' => 'public://block_image/',
                '#upload_validators' => array(
                    'file_validate_extensions' => array('gif png jpg jpeg'),
                ),
            );
            break;
    }
    return $form;
}

/**
 * Implements hook_block_save().
 */
function custom_block_block_save($delta = '', $edit = array()) {
    switch ($delta) {
        case 'my_block' :
            // Saving the WYSIWYG text    
            variable_set('text_variable', $edit['text_body']['value']);

            // Saving the file, setting it to a permanent state, setting a FID variable
            $file = file_load($edit['file']);
            $file->status = FILE_STATUS_PERMANENT;
            file_save($file);
            $block = block_load('custom_block', $delta);
            file_usage_add($file, 'custom_block', 'block', $block->bid);
            variable_set('block_image_fid', $file->fid);
            break;
    }
}

/**
 * Implements hook_block_view().
 */
function custom_block_block_view($delta = '') {
    $block = array();

    switch ($delta) {
        case 'my_block' :
            $block['content'] = my_block_view();
            break;
    }

    return $block;
}

/**
 * Custom function to assemble renderable array for block content.
 * Returns a renderable array with the block content.
 * @return
 *   returns a renderable array of block content.
 */
function my_block_view() {
    $block = array();

    // Capture the image file path and form into HTML with attributes
    $image_file = file_load(variable_get('block_image_fid', ''));
    $image_path = '';

    if (isset($image_file->uri)) {
        $image_path = $image_file->uri;
    }

    $image = theme_image(array(
        'path' => ($image_path),
        'alt' => t('Image description here.'),
        'title' => t('This is our block image.'),
        'attributes' => array('class' => 'class_name'),
    ));

    // Capture WYSIWYG text from the variable
    $text = variable_get('text_variable', '');

    // Block output in HTML with div wrapper
    $block = array(
        'image' => array(
            '#prefix' => '',
            '#type' => 'markup',
            '#markup' => $image,
            'message' => array('#type' => 'markup', '#markup' => $text, '#suffix' => '')
        )
    );
    return $block;
}

moment.js date format

Moment.js set yyyy-mm-dd format date

  

moment().format('YYYY-MM-DD H:m:s');  

How to add missing date month year in mysql (php)

Hi 

I have tried many solutions with MySQL but at the end, i found solution with PHP

which  is best 

$begin = new DateTime('2016-01-20');

$end = new DateTime('2017-12-10');

while ($begin <= $end) {

    echo $begin->format('Y-m'), "n";

    $begin->modify('first day of next month');

}