Create Backup in Localhost

Create Backup in Localhost

function EXPORT_TABLES($host,$user,$pass,$name,       $tables=false, $backup_name=false){ 
    set_time_limit(3000); $mysqli = new mysqli($host,$user,$pass,$name); $mysqli->select_db($name); $mysqli->query("SET NAMES 'utf8'");
    $queryTables = $mysqli->query('SHOW TABLES'); while($row = $queryTables->fetch_row()) { $target_tables[] = $row[0]; }   if($tables !== false) { $target_tables = array_intersect( $target_tables, $tables); } 
    $content = "SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET time_zone = \"+00:00\";\r\n\r\n\r\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\r\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\r\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\r\n/*!40101 SET NAMES ut...

Posted in Php, Sql No comments August 16, 2017

Generating Barcode Using PHP

Posted in Php No comments August 13, 2017

jQuery Editor

Posted in Jquery No comments August 3, 2017

Add textbox dynamically with jQuery

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>

<script type="text/javascript">

$(document).ready(function(){

    var counter = 2;

    $("#addButton").click(function () {

	if(counter>5){
            alert("Only 5 textboxes allow");
            return false;
	}

	var newTextBoxDiv = $(document.createElement('div'))
	     .attr("id", 'TextBoxDiv' + counter);

	newTextBoxDiv.after().html('<label>Textbox #'+ counter + ' : </label>' +
	      '<input type="text" name="textbox' + counter +
	      '" id="textbox' + counter + '" value="" >');

	newTextBoxDiv.appendTo("#TextBoxesGroup");


	counter++;
     });

     $("#removeButton")...

Posted in Jquery No comments August 2, 2017

Merge Table Common Rows

All Columns

function MergeCommonRows(table) {
    var firstColumnBrakes = [];
    // iterate through the columns instead of passing each column as function parameter:
    for(var i=1; i<=table.find('th').length; i++){
        var previous = null, cellToExtend = null, rowspan = 1;
        table.find("td:nth-child(" + i + ")").each(function(index, e){
            var jthis = $(this), content = jthis.text();
            // check if current row "break" exist in the array. If not, then extend rowspan:
            if (previous == content && content !== "" && $.inArray(index, firstColumnBrakes) === -1) {
                // hide the row instead of remove(), so the DOM index won't "move" inside loop.
                jthis...

Posted in Jquery No comments July 28, 2017

Bootstrap popup

HTML

<!-- BEGIN # BOOTSNIP INFO -->
<div class="container">
	<div class="row">
		<h1 class="text-center">Modal Login with jQuery Effects</h1>
        <p class="text-center"><a href="#" class="btn btn-primary btn-lg" role="button" data-toggle="modal" data-target="#login-modal">Open Login Modal</a></p>
	</div>
</div>
<!-- END # BOOTSNIP INFO -->

<!-- BEGIN # MODAL LOGIN -->
<div class="modal fade" id="login-modal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" style="display: none;">
    	<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header" align="center">
					<img class="img-circle" id="img_logo" src="http://bootsnipp.com/img/logo...

Posted in Bootstrap, CSS, Jquery No comments July 21, 2017

Easy understand Inheritance in php

class A {
	public function myage() {
	return  ' age is 80';
	}
}
class B extends A {	
	public function mysonage() {
	return  ' age is 50';
	}
}
class C extends B {
	public function mygrandsonage() {
	return  'age is 20';
	   }
        public function myHistory() {
        echo "Class A " .$this->myage();
        echo "Class B ".$this-> mysonage();
        echo "Class C " . $this->mygrandsonage();
        }
}
$obj = new C();
$obj->myHistory();

Output => Class A age is 80Class B age is 50Class C age is 20

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

class A {

public function myage() {

return ' age is 80';

}

}

class B extends A {

public function mysonage() {

return ' age is 50';

}

}

class C extends B {

public

Posted in Php No comments July 21, 2017

Backup MySQL Database to a Email using PHP

Posted in Php No comments July 20, 2017

Show all data of table in small screen

<style>
.tablescroll{overflow-x: scroll;overflow-y: hidden;}
</style>

1

2

3

<style>

.tablescroll{overflow-x: scroll;overflow-y: hidden;}

</style>

Posted in CSS No comments July 16, 2017

Disabled Right Click using Javascript

document.addEventListener('contextmenu', event => event.preventDefault());

1	document.addEventListener('contextmenu', event => event.preventDefault());

Posted in Jquery No comments June 5, 2017

Tweet