Guley

UPDATE tableA JOIN tabelB USING (id)
SET    tableA.column = tabelB.column

Guley

delete table
   from table
  inner join (
     select max(id) as lastId, product_id
       from table
      group by product_id
     having count(*) > 1) duplic on duplic.product_id = table.product_id
  where table.id < duplic.lastId;

Guley

Generating an SSH key pair

The first step in using SSH authorization with GitHub is to generate your own key pair.

You might already have an SSH key pair on your machine. You can check to see if one exists by moving to your .ssh directory and listing the contents.

$ cd ~/.ssh
$ ls

If you see id_rsa.pub, you already have a key pair and don't need to create a new one.

Guley

<?php

class BinarySearchTree {
	private $_root;
	public function __construct() {
		// setup sentinal node
		$this->_root = new BinarySearchNode(null);
	}
	public function getRoot() {
		return $this->hasNode() ? $this->_root->right : null;

Guley

<?php

require __DIR__ . '/vendor/autoload.php';

use ElephantIO\Client;
use ElephantIO\Engine\SocketIO\Version2X;

$options = [
    'context' => [
        'ssl' => [

Guley

<script>
 var imagesRef = document.getElementsByTagName('img'); 
  for(var i = 0; i < imagesRef.length; i++) {
		var filename = imagesRef[i].src;
		var oldAlt = imagesRef[i].alt;
		if(oldAlt != null){
			var newRa = filename.substring(0, filename.lastIndexOf('.'));
    		var imgObj = newRa.split("/");
			imagesRef[i].alt = imgObj.slice(-1);
		}

Guley

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdf.js/1.8.349/pdf.min.js"></script>

<button type="button" class="btn btn-default btn-lg tts-btn" title="Upload text, pdf or ebook file">
                    <span class="glyphicon glyphicon-open-file btn-glyph" aria-hidden="true"></span>
                    <input type="file" id="files" name="files[]">
                </button>

Guley

<?php
require('Pdf.php');
class PDF_Rotate extends Pdf
{
	var $angle=0;
	function Header()
    {
        //Put the watermark
        $this->SetFont('','B',40);
        $this->SetTextColor( 165, 203, 73 );

Guley

sudo chown -R $USER /var/www; ln -s /var/www /home/username/htdocs

Guley

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class XML extends CI_Controller {
    protected $xml;
    public function __construct() {
        parent::__construct();
        $this->xml = new DOMDocument('1.0', 'utf8');
        $this->xml->formatOutput = true;