Learn php |Web programming| php tutorials for beginners

Datepicker jquery validation message not disappear.date picker validation message using rules jquery.

Solution:use the $(this).valid() function in the date picker For example see the below code

<input type="text" class="form-control" id="myDate" name="myDate" value="">

1	<input type="text" class="form-control" id="myDate" name="myDate" value="">

$('#myDate').datepicker({
      autoclose: true
    }).on('change', function() {
        $(this).valid(); 
    });

$('#myDate').datepicker({

autoclose: true

}).on('change', function() {

$(this).valid();

});

Simple Example for Datatable display

Simple Example for Datatable display. If the html button not displaying in the view page use the escapeColumns([‘id’]) function return Datatables::of($result)->escapeColumns([‘id’])->make(true); Javascript File test.js

$(function () {
    var site_datatable;
    var site_data = {};
    site_datatable = $('#dashboard_employee').DataTable({
        "serverSide": true,
        "destroy": true,
        "autoWidth": false,
        "searching": true, 
        "aaSorting": [2,'asc'],
        "columnDefs": [ {
                    "targets": 0,
                    "searchable": false
                        } ],
        "ajax": {
            type: "GET",
            data: site_data,
            url: siteUrl + '/get_empdata',
        }
    })

    
})

$(function () {

var site_datatable;

var site_data = {};

site_datatable = $('#dashboard_employee').DataTable({

"serverSide": true,

"destroy": true,

"autoWidth": false,

"searching": true,

"aaSorting": [2,'asc'],

"columnDefs": [ {

"targets": 0,

"searchable": false

} ],

"ajax": {

type: "GET",

data: site_data,

url: siteUrl + '/get_empdata',

}

})

Php Files

 public function get_empdata() {
        $result = array();
        $whereArray = array();
        $empDetails = EmpTable::getimpData($whereArray)->get(); 
       
        foreach ($empDetails as $id) { 
            $row = array();
            
            $row[] = $id->name;
            $row[] = $id->age;
            $row[] = $id->designation;
            $delete_url = '<span><th style="text-align:center"><button type="button" class="btn btn-danger">Delete</button></th></span>';
            $row[] = $delete_url;
            $result[] = $row;
            
        }
        return Datatables::of($result)->escapeColumns(['id'])->make(true);
        //return Datatables::of($result)->make(true);
// if we are not using the escapeColumns() then the button will not display in the view page
        
    }

public function get_empdata() {

$result = array();

$whereArray = array();

$empDetails = EmpTable::getimpData($whereArray)->get();

foreach ($empDetails as $id) {

$row = array();

$row[] = $id->name;

$row[] = $id->age;

$row[] = $id->designation;

$delete_url = '<span><th style="text-align:center"><button type="button" class="btn btn-danger">Delete</button></th></span>';

$row[] = $delete_url;

$result[] = $row;

}

return Datatables::of($result)->escapeColumns(['id'])->make(true);

//return Datatables::of($result)->make(true);

// if we are not using the escapeColumns() then the button will not display in the view page

}

view File mypage.php

	<table id="dashboard_employee" class="table table-responsive table-bordered table-hover table-striped">
                                    <thead>
                                        <tr>
                                            
                                            <th>Name</th>
                                            <th>Age</th>
                                            <th>Designation</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                </table>

<thead>

<tr>

<th>Designation</th>

<th>Action</th>

</tr>

</thead>

</table>

Getting the error in laravel SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’

Getting the error in laravel SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’ (SQL: update emp_details set testID = 999, updated_at = 2018-09-03 14:50:09 where (testID = 1)) This error usually comes when the updated_at field missing in the laravel table.if the fields are not in the table in the database we… Read More »

Redirect to a url when the video playing ends using html5

<!DOCTYPE html>
<html>
<body>
   <script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js">
    </script>
    <script type="text/javascript">
      $(document).ready(function(){   
       $("#myVideo").bind('ended', function(){
             window.open("http://www.mydoubts.in", "_blank");
			 //window.open("http://www.mydoubts.in", "_self");
       }); 
      });
    </script>
 <video id="myVideo" width="320" height="240" controls="controls">
      <source src="movie.mp4" type="video/mp4" />
      
      
    </video>
<h1>My First Heading</h1>

<p>My first paragraph.</p>

</body>
</html>

<!DOCTYPE html>

<html>

<body>

</script>

$(document).ready(function(){

$("#myVideo").bind('ended', function(){

window.open("http://www.mydoubts.in", "_blank");

//window.open("http://www.mydoubts.in", "_self");

});

</script>

</video>

<h1>My First Heading</h1>

<p>My first paragraph.</p>

</body>

</html>

Creating Routing module in angularjs6

we can use the below cli to generate routing module. ng generate module app-routing –flat –module=app –flat put the routing file inside src/app folder –module tells the cli to register it in the imports array of AppModule

Jquery Click event firing Multiple times/On change event happens more than twice

Below Ajax code executing more than once in a single change event.Here if i m trying to upload the file in the ajax call server side script is executing more than once

$('.myfile').on('change',function(){    
  
        $.ajax({
            url: siteUrl+'/getdata',
            async: true,
            type: "POST",
            data: formData,
            dataType: "json",
            success: function (data)
			{ 
                
                 
            }

        });
     });

$('.myfile').on('change',function(){

$.ajax({

url: siteUrl+'/getdata',

async: true,

type: "POST",

data: formData,

dataType: "json",

success: function (data)

{

}

});

Soultion: change the click action with bind option as below

use the below line 
	$('.myfile').unbind().on('change',function(){    
	instead of 
    $('.myfile').on('change',function(){

use the below line

$('.myfile').unbind().on('change',function(){

instead of

$('.myfile').on('change',function(){

Dynamicallay generated Checkbox validation using jquery

Laravel blade

{!! Form::open(array('id'=>'myForm','name'=>'myForm','method' => 'post', 'url' => url('submit_my_form'), 'class' => '')) !!}
	<input type="checkbox" name="mychkbox_1" id="mychkbox_1">
	<input type="checkbox" name="mychkbox_2" id="mychkbox_2">
	<input type="checkbox" name="mychkbox_3" id="mychkbox_3">
	{!! Form::close() !!}

{!! Form::open(array('id'=>'myForm','name'=>'myForm','method' => 'post', 'url' => url('submit_my_form'), 'class' => '')) !!}

{!! Form::close() !!}

Jquery code

$(".mybutton").click(function(){
    if($('#myForm').find('input[type=checkbox]:checked').length == 0)
    {
        $(".myformerror").html('Please select atleast one checkbox');
        return false;
     }
   });

$(".mybutton").click(function(){

if($('#myForm').find('input[type=checkbox]:checked').length == 0)

{

$(".myformerror").html('Please select atleast one checkbox');

return false;

}

});

Special character issue in Excel file reading/writing in Laravel

Read the data from mysql table and it is inserting into the excel sheet and generating excel file shows the junk/ascii characters. Solution:This issue will happen if the page contains any buffer statement. or print_r,echo pre commands Please remove all those codes before geneerating the excel.

Ajax based File upload using Form data not working in laravel

Below is my ajax code to upload the file

$('.fileupload').on('change',function(){    
        var formObj = $('#myForm');
        var formData = new FormData(formObj[0]);
        $.ajax({
            url: siteUrl+'/getmydata',
            async: true,
            type: "POST",
            data: formData,
            dataType: "json",
            success: function (data)
            {
                alert(data.count);
               
            }

        });
     });

$('.fileupload').on('change',function(){

var formObj = $('#myForm');

var formData = new FormData(formObj[0]);

$.ajax({

url: siteUrl+'/getmydata',

async: true,

type: "POST",

data: formData,

dataType: "json",

success: function (data)

{

alert(data.count);

}

});

Please add the below code to work the fileupload proper

<script type="text/javascript">
    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });
</script>

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

</script>

if the issue still exists add the following extra things in the ajax call

url: siteUrl+'/get_gstrefno_from_excel',
            async: true,
            type: "POST",
            data: formData,
            dataType: "json",
			
            contentType: false,
            cache: false,
            processData: false,

url: siteUrl+'/get_gstrefno_from_excel',

async: true,

type: "POST",

data: formData,

dataType: "json",

contentType: false,

cache: false,

processData: false,

Dynamically generated content in the web page contains an onclick action not working

please see the code below link is generated via ajax call based on one dropdown selection

<p  style="padding-left:10px;cursor: pointer;" class="file_download"   uploaded_file_name="'.$data->uploaded_file_name.'"  uploaded_path="'.$data->uploaded_path.'" >'.$data->filename.'</p>

1	<p style="padding-left:10px;cursor: pointer;" class="file_download" uploaded_file_name="'.$data->uploaded_file_name.'" uploaded_path="'.$data->uploaded_path.'" >'.$data->filename.'</p>

file download code looks like as below

  $('.file_download').click(function (e) { 
               var uploaded_file_name = $(this).attr('uploaded_file_name');
                var file_path=$(this).attr('uploaded_path');
                $('#download_hidden_filename').val(uploaded_file_name);
                $("#download_hidden_file_path").val(file_path);
                $('#upload_form_submit').submit();
            });

$('.file_download').click(function (e) {

var uploaded_file_name = $(this).attr('uploaded_file_name');

var file_path=$(this).attr('uploaded_path');

$('#download_hidden_filename').val(uploaded_file_name);

$("#download_hidden_file_path").val(file_path);

$('#upload_form_submit').submit();

});

The above code is not firing the download action Solution: change the first line of code-instead of click add on action

$(document).on("click", '.file_download', function(event) { 
var uploaded_file_name = $(this).attr('uploaded_file_name');
                var file_path=$(this).attr('uploaded_path');
                $('#download_hidden_filename').val(uploaded_file_name);
                $("#download_hidden_file_path").val(file_path);
                $('#upload_form_submit').submit();
            });

$(document).on("click", '.file_download', function(event) {

var uploaded_file_name = $(this).attr('uploaded_file_name');

var file_path=$(this).attr('uploaded_path');

$('#download_hidden_filename').val(uploaded_file_name);

$("#download_hidden_file_path").val(file_path);

$('#upload_form_submit').submit();

});