[php] Breadcrumbs for Codeigniter in the helper function

function _breadcrumbs()
{
    $ci = & get_instance();
    $urlSegment = $ci->uri->segment_array();

    if (($key = array_search("product", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }
    if (($key = array_search("products", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }
    if (($key = array_search("product-category", $urlSegment)) !== false) {
        unset($urlSegment[$key]);
    }

    // print_r($urlSegment);

    $breadcrumbs = '<div class="row">
            <div class="col-sm-12">
                <p class="breadcrumb"><a href="" title=""><img src="' . base_url() .'assets/frontend/img/home.svg" alt="" /></a> ';

    foreach ($urlSegment as $key => $segment) {
        $breadcrumbs .= '<img src="'. base_url() .'assets/frontend/img/gt.png" alt="" /> '. ucfirst($segment) . ' ';
    }

    $breadcrumbs .= '</p>
            </div>
        </div>';

    echo $breadcrumbs;
}

Ajax Search PHP through MySQL record


var searchRequest = null;

$(function () {
    var minlength = 3;

    $("#spedostech_search").keyup(function () {
        var that = this,
        value = $(this).val();

        if (value.length >= minlength ) {
            if (searchRequest != null) 
                searchRequest.abort();

            console.log( );
            // return;
            
            searchRequest = $.ajax({
                type: "GET",
                url: BASE_URL + "spedostech/search",
                data: {
                    'search_keyword' : value
                },
                dataType: "json",
                success: function(msg){
                    // var obj = JSON.stringify(msg);
                    console.log(msg);
                    //we need to check if the value is the same
                    if (value==$(that).val()) {
                        var container = $('<ul />');
                        $.each( msg, function( section, List ) {
                          var li = $('<li>Nalezeno v '+section+' (3)</li>');

                          // container.append('<li>Nalezeno v '+section+' (3)</li>');
                          // console.log( section + " : ");
                          var ul = $('<ul />');
                          $.each( List, function( key, item ) {
                            ul.append('<li><a href="#'+item.id+'" title="">'+item.name+'</a></li>');
                            // console.log("Name : " + item.name);
                          });
                          li.append(ul);
                          container.append(li);  
                        });

                    // console.log(container);
                        // $('#tt').html(container);
                        $('#search-whisperer').html(container);

                    //Receiving the result of search here
                    }
                }
            });
        }
    });
});



Photo Collage [PHP]


<?php if (!empty($entry['photos'])) {
?>
<div class="crispbx">
    <div class="crispcont1">

        <!-- <p> -->
        <?php 
            // echo "string";
            $i = 0;
            if (count($entry['photos']) <= 9) {
                $linhas = floor(count($entry['photos']) / 3);
                $resto = count($entry['photos']) % 3;

                $tam1h = '143px';
                $tam2h = '216.5px';
                $tam3h = '436px';
                                                            
                $tam1w = '32.8%';
                $tam2w = '49.2%';
                $tam3w = '99.1%';
                
            }
            $photoDiv .= '<div class="wall_photoboard">';
            $i = 1;
            foreach ($entry['photos'] as $path) {

                if ($i <= ($linhas * 3)) {
                    // $tamAtual = $tam1;

                    $tamAtual = $tam1w;
                    $tamAtualh = $tam1h;   

                } else {
                    if ($resto == 2) {
                        // $tamAtual = $tam2;

                        $tamAtual = $tam2w;
                        $tamAtualh = $tam2h;

                    } else 
                        // $tamAtual = $tam3;

                        $tamAtual = $tam3w;
                        $tamAtualh = $tam3h;

                }

                $margin = 'margin: 2px 0 0 2px';
                if (count($entry['photos']) == 1) {
                    $margin = 'margin: 0';
                    $tamAtualh = '100%';
                    $tamAtual = '100%';
                }
                $photoDiv .= '<a class="mid2wall" href="photo_detail.php?id=' . $path['id'] . '" ><img  style="width: ' . $tamAtual . '; height: ' . $tamAtualh . '; border-radius:px;' . $margin .';border:1px solid #ccc !important;"  src="uploads/' . $path['file'] . '"/></a>';
                $i++;
                if ($i >= 9 && count($entry['photos']) > 9) {
                    $photoDiv .= ' and ' . (count($entry['photos']) - 9) . ' more photos';
                    break;
                }

            }
            $photoDiv .= '</div>';

            echo $photoDiv;

            $photoDiv = '';

         ?>

Error reporting management snippets in php [dev/prod]

/*
 *---------------------------------------------------------------
 * APPLICATION ENVIRONMENT
 *---------------------------------------------------------------
 *
 * You can load different configurations depending on your
 * current environment. Setting the environment also influences
 * things like logging and error reporting.
 *
 * This can be set to anything, but default usage is:
 *
 *     development
 *     testing
 *     production
 *
 * NOTE: If you change these, also change the error_reporting() code below
 */
	define('ENVIRONMENT', isset($_SERVER['CI_ENV']) ? $_SERVER['CI_ENV'] : 'development');

/*
 *---------------------------------------------------------------
 * ERROR REPORTING
 *---------------------------------------------------------------
 *
 * Different environments will require different levels of error reporting.
 * By default development will show errors but testing and live will hide them.
 */
switch (ENVIRONMENT)
{
	case 'development':
		error_reporting(0);
		// error_reporting(-1);
		ini_set('display_errors', 1);
		ini_set('max_execution_time', -1);
	break;

	case 'testing':
	case 'production':
		ini_set('display_errors', 0);
		if (version_compare(PHP_VERSION, '5.3', '>='))
		{
			error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_STRICT & ~E_USER_NOTICE & ~E_USER_DEPRECATED);
		}
		else
		{
			error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_USER_NOTICE);
		}
	break;

	default:
		header('HTTP/1.1 503 Service Unavailable.', TRUE, 503);
		echo 'The application environment is not set correctly.';
		exit(1); // EXIT_ERROR
}

Price Calculation with php depending on tax and discount price and percentage


function priceCalc($price, $discount_price, $discount_percent, $id_tax = -1)
{
    // $baseTax = _s("shop-base-tax");
    // $priceType = _s("shop-base-price");

    $baseTax = 21;
    $priceType = 1;

    // $ci = & get_instance();
    // $ci->load->database();

    // if( $id_tax != -1 ){
    //     $ci->db->select('t.*')
    //         ->from("tax as t")        
    //         ->where("id_tax", $id_tax);    
    //     $query = $ci->db->get();
    //     $baseTax = $query->row()->value;
    // }

    // return var_dump($baseTax);

    // $baseTax = 15;

    $tax = $baseTax; /* == $data_tax->value ? $baseTax : $data_tax->value; */

    $result = new stdClass();
    $result->oldPrice =  $price;

    // return $result->oldPrice;

    if ($discount_price > 0) {
        //samotná hodnota daně
        $taxvalue = ($discount_price / 100) * $tax;

        if ($priceType) {
            $result->newPrice = $discount_price + $taxvalue;
        } else {
            $result->newPrice = $discount_price;
        }
        $result->switch = 1;
    } elseif ($discount_percent > 0) {
        //samotná hodnota daně
        // $taxvalue = ($price / 100) * $tax;
        $taxvalue = ($result->oldPrice / 100) * $tax;


        if ($priceType) {
        	$result->oldPrice = (( $tax + 100 ) / 100 ) * $price;
            // $result->newPrice = $price - ((($price + $taxvalue) / 100) * $discount_percent);
            $result->newPrice = $result->oldPrice - ( ($result->oldPrice / 100) * $discount_percent);
        } else {
            $result->newPrice = $price - (($price / 100) * $discount_percent);
        }

        $result->switch = 1;
    } else {
        //samotná hodnota daně
        // $taxvalue = ($price / 100) * $tax;
        $taxvalue = ($result->oldPrice / 100) * $tax;
        

        if ($priceType) {
        	$result->oldPrice = (( $tax + 100 ) / 100 ) * $price;
            // $result->newPrice = $price + $taxvalue;
            $result->newPrice = $result->oldPrice;
        } else {
            $result->newPrice = $price;
        }
        //        $result->newPrice = $price;
        $result->switch = 0;
    }
    //    $priceFormat = number_format(, 2);
    $priceRound = (int) round($result->newPrice);
    //    $priceReplace = str_replace(",", " ", $priceRound);
    $result->newPrice = $priceRound;

    return $result;
}

var_dump(priceCalc(3469,0,30));

MYSQL backup by command in php

add a xml file called database.xml and also folders sql/ and sql_zip/ and

add a php file call backupdb.php and paste this class snippet


	/**
	* Database Backup classed for all the db at once
	*/
	class DatabaseBackup
	{

		private $dbhost = '';
		private $dbuser = '';
		private $dbpass = '';

		public $connection = null;
		
		function __construct($dbhost = 'localhost',$dbuser = 'root',$dbpass = '')
		{
			$this->dbhost = $dbhost;
			$this->dbuser = $dbuser;
			$this->dbpass = $dbpass;

			$this->connection = mysqli_connect($this->dbhost, $this->dbuser ,$this->dbpass);

		}


		// export all single database recursively 
		public function exportAll($extract_type = 'sql', $path = 'sql/')
		{
			
			$res = mysqli_query($this->connection,"SHOW DATABASES");
			
			while ($row = mysqli_fetch_assoc($res)) {
			   
				$dbname = $row['Database'];   

				if($extract_type == 'zip'){
				 
				$backup_file = $dbname . date("Y-m-d-H-i-s") . '.sql.gz';
				$command = "mysqldump --opt 
							-h $this->dbhost 
							-u $this->dbuser $dbname 
							| gzip > sql_zip/$backup_file";

				system($command);
				}
				else {
					$backup_file = $dbname . date("Y-m-d-H-i-s") . '.sql';
				$command = "mysqldump --user=$this->dbuser --password=$this->dbpass --host=$this->dbhost $dbname  > sql/" . $backup_file;
				// return $command;

				exec($command);
				}



				$db[] = [

				 'filename' => $backup_file,
				 'dbname' 	=> $dbname

				];

				 
			}

			return $db;
		}

		// export all single database recursively and save log to xml
		public function dbToXMLRecord($file = null)
		{
			$dbs = $this->exportAll();

			$xml = new SimpleXMLElement('<?xml version="1.0" encoding="utf-8"?><databases></databases>');

			$xml->addAttribute('version', '1.0');

			foreach ($dbs as $key => $db) {

				$item  =  $xml->addChild('item');
				$item->addChild('filename',$db['filename']);
				$item->addChild('dbname',$db['dbname']);

			
			}

			$databaseXML = fopen("databases.xml", "w") or die("Unable to open file!");
			
			fwrite($databaseXML, $xml->asXML());
			
			fclose($databaseXML);

			return $xml->asXML();
		
		}

		// import single db from xml recursively from xml file
		public function xmlToDBRecord($file = 'databases.xml')
		{
			$xmlDoc = new DOMDocument();
			$xmlDoc->load($file);
			$x = $xmlDoc->documentElement;

			$count = 1;

			foreach ($x->childNodes AS $items) {

				print_r($items->childNodes[1]->nodeValue);


				$res = mysqli_query($this->connection,"CREATE DATABASE IF NOT EXISTS ". $items->childNodes[1]->nodeValue);
				mysqli_query($this->connection,"USE ".$items->childNodes[1]->nodeValue);
				
				$command = "mysql -u $this->dbuser -p $this->dbpass < sql/". $items->childNodes[0]->nodeValue ;
				// return $res;

				exec($command,$output=array(),$worked);

				switch($worked){
				    case 0:
				        echo 'Import file <b>' .$items->childNodes[0]->nodeValue .'</b> successfully imported to database <b>' .$items->childNodes[1]->nodeValue .'</b>';
				        break;
				    case 1:
				        echo 'There was an error during import. Please make sure the import file is saved in the same folder as this script and check your values:<br/><br/><table><tr><td>MySQL Database Name:</td><td><b>' .$items->childNodes[1]->nodeValue .'</b></td></tr><tr><td>MySQL User Name:</td><td><b>' .$this->dbuser .'</b></td></tr><tr><td>MySQL Password:</td><td><b>NOTSHOWN</b></td></tr><tr><td>MySQL Host Name:</td><td><b>' .$this->dbhost .'</b></td></tr><tr><td>MySQL Import Filename:</td><td><b>' .$items->childNodes[0]->nodeValue .'</b></td></tr></table>';
				        break;
				}
				
				echo $command . "<br>";

				$count++;
								
			}

			return $count;
		}

		// test import 
		public function tryImport()
		{
			$command = "mysql -u $this->dbuser -p $this->dbpass < sql/music2017-02-02-23-21-12.sql" ;
            return $command;
            exec($command);
		}

		// all database in one sql file and xml
		public function tryAllExport()
		{
			// return $extract_type;
			$res = mysqli_query($this->connection,"SHOW DATABASES");
			// return $res;

			$databases = '';
			while ($row = mysqli_fetch_assoc($res)) {

				$databases .= $row['Database'] . ' ';
				
			}

			// return $databases;

			$command = "mysqldump -u $this->dbuser -p $this->dbpass --databases $databases > all_backup_2.sql" ;
			// $command = "mysqldump -u $this->dbuser -p $this->dbpass --databases c9db cashmemo clientapi db_lms > all_backup.sql" ;

			// return $command;

			$command = "mysqldump -u $this->dbuser -p $this->dbpass --all-databases > alldb_backup2.sql" ;
            
            // exec($command);
            exec('mysqldump -u root -p --all-databases --skip-lock-tables > alldb.sql');
		}



	}

	$dbBackup = new DatabaseBackup();

	if(isset($_GET['type']) && ($_GET['type'] == 'zip')){
		var_dump($dbBackup->exportAll('zip'));
	}
	else if(isset($_GET['to']) && ($_GET['to'] == 'xml')){
			var_dump($dbBackup->dbToXMLRecord());
	}
	else if(isset($_GET['to']) && ($_GET['to'] == 'db')){
			var_dump($dbBackup->xmlToDBRecord());
			// var_dump($dbBackup->tryImport());
	}
	else if(isset($_GET['to']) && ($_GET['to'] == 'tryx')){
			// var_dump($dbBackup->xmlToDBRecord());
			var_dump($dbBackup->tryAllExport());
	}
	else{
		var_dump($dbBackup->exportAll());
	}

in the browser serve “http://localhost/backupdb.php?to=xml
// here
to=xml for export from db to individuals sql file and xml enty
to=tryx all in a single file and also xml entry
to=zip all sqls file to zip in the sql_zip folder
to=db import from xml entry from sql files to db
record are saved as sql files in the sql folder and sql_zip folder