Search options (Page 4 of 4)

    class ImageResize{
        public $name;
        // Seni img dydžiai
        public $W, $H;
        // Nauji img dydžiai
        public $NewW = 800;
        public $NewH = 600;
        // Pakeistų paveiksliukų nuorodos
        public $path;
        // Laikini kintamieji
        public $tmp;
        public $src;
        
        public function __construct(){
            $this->src = imageCreateFromJPEG($_FILES['upload']['tmp_name']);
            list($this->W, $this->H) = getImageSize($_FILES['upload']['tmp_name']);
            $this->name = $_FILES['upload']['name'];
            $this->path = $_SERVER['DOCUMENT_ROOT'] . "/abc/upload/";
        }
        
        public function resize(){
            $this->tmp = imageCreateTrueColor($this->newW, $this->newH);
            imageCopyResampled($this->tmp, $this->src, 0, 0, 0, 0, $this->newW, $this->newH, $this->W, $this->H);
            if ( file_exists($this->path . $this->name) ){                // Jei toks failas egzistuoja
                $exts = explode(".", $this->name);            // Explodinam vardą, kad atskirti extensioną nuo failo vardo
                $this->name = $exts[0] . "_" . rand(0, 999) . "." . $exts[1];
            }
            imageJPEG($this->tmp, $this->path . $this->name, 100);
            imageDestroy($this->tmp);
            return $this->path . $this->name;
        }
        
        public function setSize($width, $height){
            $this->newW = $width;
            $this->newH = $height;
        }
        
        public function setSizeVar($max){
            if ( $this->W > $this->H ){
                $this->newW = round( $this->W * ($max / $this->W) );
                $this->newH = round( $this->H * ($max / $this->W) );
            } else {
                $this->newW = round( $this->W * ($max / $this->H) );
                $this->newH = round( $this->H * ($max / $this->H) );
            }
        }
    }

LOCK TABLE test WRITE;
SELECT @myRight := rgt FROM test
WHERE parent = 'AC';
UPDATE test SET rgt = rgt + 2 WHERE rgt > @myRight;
UPDATE test SET lft = lft + 2 WHERE lft > @myRight;
INSERT INTO test(produktas, lft, rgt, parent, level) VALUES('qwe', @myRight + 1, @myRight + 2, '', '');
UNLOCK TABLES

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT @myRight := rgt FROM test WHERE parent = 'AC'; UPDATE test SET rg' at line 2

mysqli_multi_query($con, "LOCK TABLE test WRITE;
SELECT @myRight := rgt FROM test
WHERE parent = '$cat';
UPDATE test SET rgt = rgt + 2 WHERE rgt > @myRight;
UPDATE test SET lft = lft + 2 WHERE lft > @myRight;
INSERT INTO test(produktas, lft, rgt, parent, level) VALUES('$produktas', @myRight + 1, @myRight + 2, '', '');
UNLOCK TABLES") or die(mysql_error());

Warning: mysqli_multi_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\skelbiu\config.php on line 136

$con = mysqli_connect($host, $user, $pw, $db);