yii2 search where not in condition usage

suppose we have two parameters to check

Like for example

where country_id = 4  AND city_id not in (2,3,4)

then using yii2 we can do the following

 Members::find()->select(['id','name'])->where(['country_id'=>4])->andWhere(['not in','id',[2,3,4]])->all();

MySQL - replace first occurrance of string part - Example phone

Example for removing prefix + or 00 from phone number

we can replace first occurrence of string by using following methods using mysql functions REPLACE() , LEFT , INSTR(), LOCATE(), SUBSTRING()


To replace +  example (1 character)
SET @phone= '+923333333333';
SELECT  CONCAT(REPLACE(LEFT(@phone, INSTR(@phone, '+')), '+', ''), SUBSTRING(@phone, INSTR(@phone, '+') + 1)) as updated_phone;



Updating in DB:

Update [table] set phone = CONCAT(REPLACE(LEFT(@phone, INSTR(@phone, '+')), '+', ''), SUBSTRING(@phone, INSTR(@phone, '+') + 1))




To  replace 00 example (2 characters)
SET @phone= '00923333333333';
SELECT  CONCAT(REPLACE(LEFT(@phone, locate(@phone, '00')), '00', ''), SUBSTRING(@phone, instr(@phone, '00') + 2)) as updated_phone;



Updating in DB:
UPDATE [table] set phone = CONCAT(REPLACE(LEFT(@phone, locate(@phone, '00')), '00', ''), SUBSTRING(@phone, instr(@phone, '00') + 2))

Interview Questions and Answers - Object Orient Programming in PHP (OOP) - Intermediate

Question. No. 1:

What are magic methods ?

Answer:

• __construct : called while initializing an object with a "new" keyword
• __destruct : when object is going out of scope.
• __call : When method doesn't exists or access restricted in Object scope
• __callStatic : When method doesn't exists or access restricted in Static Scope
• __get : when trying to read a variable which doesn't exist or access restricted
• __set: when trying to set a variable which doesn't exist or access restricted
• __isset : when trying to check isset a variable which doesn't exist or access restricted
• __unset : when trying to unset a variable which doesn't exist or access restricted
• __sleep :  when serialize an object in order to store in database 

class myClass

{

       var $var1 = 3; 

private $var2 = 2;

    public function __sleep()

    {

        return array('var1', 'var2');

    }

}

$myObj= new myClass;

serialize($myObj);

• __wakeup : when un-serialize an object get serialize object then un-serialize it 

class myClass

{

       var $var1 = 3; 

private $var2 = 2;

    public function __wakeup ()

    {

        return array('var1', 'var2');

    }

}

$myObj= new myClass;

$se = serialize($myObj);

unserialize($se);

• __toString: when a class object was printed as string this method will be called

class myClass

{

    public function __toString()

    {

        return 'class name';

    }

}

$myObj = new myClass;

echo $myObj;

• __invoke : when declared ,it will be used as a callable function with instantiated object name. it takes same number of arguments passed.

class myClass

{

    public function __invoke($x,$y)

    {

        echo $x.$y;

    }

}

$myObj = new myClass;

$myObj (4,5);

• __set_state : when var_export() function called on the object

• __clone : when called clone on an object. when we try to tract the serials of cloned.
• __autoload : its not a method but Function, 

Interview Questions and Answers - Object Orient Programming in PHP (OOP) - Basics

Question.1. 
what is class?

Answer: 

• Its a blue print (Technical Design/structure) of how methods & behaviors will be written/shown. 

Question.2:
What is an object?

Answer:

• Its an instance of a class.

Question.3.
What is the Interface?
Answer:

• functionality cannot be provided
• properties cannot be defined
• it is to enforce child class to implement all the methods existing in interface is a MUST. 
• it cannot be instantiated. 
• methods can only be public inside interface.
• child class can only implement not extend with interface
• every method should be abstracted 
• multiple inheritance is possible with implements keyword
• multi-level inheritance is possible , that is an interface can extend parent interface and a class can implement child interface and it should implement all the methods from parents interfaces.

Question 4:
What is an Abstract class?

Answer:

• functionality can be provided inside it
• properties can be defined inside it
• Methods cannot be private, 
• child class must implement abstract methods
• child class can extend an abstract class with "extends" keyword instead of "implements" 
• not every method should be abstract
• multiple inheritance is not possible

Question 5:

What are properties?

Answer:

• information / data/state of an object

Question 6:
What is are Methods?

Answer:

• Functions or behaviors of the class

Question 7:
What is Encapsulation?

Answer:

• to enclose the properties and behaviors in curly braces so that we don't need to know the information processing inside a class while working with an API calls to this class.

Question 8:
What are Visibility/Access Modifiers?
Answer:

• Public - accessible from everywhere
• Protected - accessible from within class as well child classes
• private  - accessible from within class ONLY 

Question 9:
What is Static?

Answer:

• Method or property available at class level , no object needed
• changes will affect everywhere in all the instances of the class

Question 10:
What is Constructor?

Answer:

• Its a magic method
• used to initialize the properties of an object 

Question: 11:

What is Polymorphism:

Answer:

Its a concept that an object can have different forms, means a class can have many child classes which are related to parent class but having different behaviors.

example:

interface Speaking{

     public function speak();

}

cat implements speaking{

     

     public function speak(){

           echo 'meeaoo';

     }

}

dog implements speaking{

     

     public function speak(){

           echo 'woooah';

     }

}

person implements speaking{

     

     public function speak(){

           echo 'lets go';

     }

}

MEAN Stack Tutorials and courses - MongDB, ExpressJS, AngularJS, NodeJS

MEAN Stack RESTful API Tutorial (1/5) - Using MongoDB, Express, AngularJS, and NodeJS Together

https://www.youtube.com/watch?v=kHV7gOHvNdk

Node awesome modules to be used Take all updated module from this link https://www.airpair.com/node.js/posts/top-10-mistakes-node-developers-make

• https://www.npmjs.com/package/sendevent
• https://www.npmjs.com/package/bunyan

MEAN Stack Intro: Build an end-to-end application - must watch again and again https://www.youtube.com/watch?v=AEE7DY2AYvI

https://github.com/jpotts18/mean-stack-relational https://github.com/diegofss11/contact-list-application/tree/master/app https://github.com/ericdouglas/MEAN-Learning#videoshttps://thinkster.io/angulartutorial/mean-stack-tutorial/

RestFull API Basics https://www.youtube.com/watch?v=kIzdaR_cKWY REST call

https://www.youtube.com/watch?v=DeFJ9oQm-b0

http://darul75.github.io/ng-notification/

Building your first MEAN application - good intro to Mongo DB https://www.youtube.com/watch?v=PH_5lXxSpww

awesome blog example using mongodb node.js https://github.com/madhums/node-express-mongoose-demo

Good express module for Node js application for nitification https://github.com/madhums/node-notifier

MEAN

http://stackoverflow.com/questions/18708428/how-to-do-authentication-with-node-js-and-mean-stack

ANGULR

using jsonp with angular.js http://www.bennadel.com/blog/2610-using-jsonp-with-resource-in-angularjs.htm

angular.js promises http://chariotsolutions.com/blog/post/angularjs-corner-using-promises-q-handle-asynchronous-calls/

d3 with angular.js http://jsfiddle.net/en6k0zsc/1/

NODE

WATCH all this video TO LEARN NODE.JS http://technotip.com/3674/node-js-video-tutorial-list/

Event Emmit. https://codeforgeek.com/2014/11/eventemitter-node-js/ http://code.tutsplus.com/tutorials/using-nodes-event-module--net-35941

ndoejs stream http://www.sitepoint.com/basics-node-js-streams/

Mus read book for NODE.JS http://www.e-booksdirectory.com/details.php?ebook=7891https://github.com/tj/masteringnode

Good book for JS & NODE http://eloquentjavascript.net/ https://github.com/addyosmani/es6-equivalents-in-es5

TJ Holowaychuck's modular web applications with node js and express 1152x720 https://www.youtube.com/watch?v=9CTfGS0gEOk

---

using HTML5 in Jade.. express http://stackoverflow.com/questions/11495595/using-html-in-express-instead-of-jade

angular with Express.js http://briantford.com/blog/angular-express

Morris chart in angular.jss http://angular-js.in/angular-morris-chart/

wat TJ Holowaychuck's thinks http://skookum.com/blog/re-components-in-practice/ http://www.quora.com/TJ-Holowaychuk-1 http://www.infoq.com/articles/nodejs-in-action

kyle simpson about java script https://www.youtube.com/watch?v=__8eIX0QFXU

Leadn Java script God exp http://bonsaiden.github.io/JavaScript-Garden/#object.prototype

https://www.youtube.com/watch?feature=player_embedded&x-yt-ts=1421914688&x-yt-cl=84503534&v=c4ScybD2690 http://stephensugden.com/middleware_guide/http://stackoverflow.com/questions/7337572/what-does-middleware-and-app-use-actually-mean-in-expressjs

NOde.js Good ex http://mherman.org/blog/2013/10/20/handling-ajax-calls-with-node-dot-js-and-express-scraping-craigslist/#.VL-ZMtKUcoY

EXPRESS

Book. https://github.com/alessioalex/mastering_express_code

Node Guides - Understanding Event Emitter https://vimeo.com/46976277

http://stephensugden.com/middleware_guide/

http://expressjs.com/resources/middleware.html https://github.com/expressjs?_ga=1.258145352.395339391.1421702199 https://github.com/senchalabs/connect?_ga=1.256654153.395339391.1421702199#middleware

mongodb - http://www.mongodb.com/presentations/building-web-applications-mongodb-introduction

Good Ex http://cwbuecheler.com/web/tutorials/2014/restful-web-app-node-express-mongodb/

Ref above from this link http://webapplog.com/tutorial-node-js-and-mongodb-json-rest-api-server-with-mongoskin-and-express-js/

Write a todo list with Express and MongoDB http://dreamerslab.com/blog/en/write-a-todo-list-with-express-and-mongodb/ http://webapplog.com/todo-app-with-express-jsnode-js-and-mongodb/

JAVA SCRIPT

Leadn Java script God exp http://bonsaiden.github.io/JavaScript-Garden/#object.prototype

closuser in Java script - http://stackoverflow.com/questions/111102/how-do-javascript-closures-work

java script style guide https://github.com/airbnb/javascript#functions

JS Functions http://www.infragistics.com/community/blogs/dhananjay_kumar/archive/2015/01/20/11-things-about-javascript-functions-net-developers-must-know-part-1.aspx

SOURCE: https://www.reddit.com/r/meanstack/comments/2v68zd/mean_js/

document ready in javascript - alternative to $(document).ready

There are many Answers available for the above question on the following URL.

http://stackoverflow.com/questions/2304941/what-is-the-non-jquery-equivalent-of-document-ready

PNG to JPG - Conversion and Compression - PHP

Code is below:

<?php

if(isset($_POST['submit'])){

$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["myfile"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);

move_uploaded_file($_FILES["myfile"]["tmp_name"], $target_file);

$filePath = './uploads/'.basename( $_FILES["myfile"]["name"]);
$image = imagecreatefrompng($filePath);
$bg = imagecreatetruecolor(imagesx($image), imagesy($image));
imagefill($bg, 0, 0, imagecolorallocate($bg, 255, 255, 255));
imagealphablending($bg, TRUE);
imagecopy($bg, $image, 0, 0, 0, 0, imagesx($image), imagesy($image));
imagedestroy($image);
$quality = 50; // 0 = worst / smaller file, 100 = better / bigger file

$image_name = str_replace('.png','',$filePath);

imagejpeg($bg, $image_name . ".jpg", $quality);

imagedestroy($bg);


}


?>




<form action="" enctype="multipart/form-data" method="post">
         <input type="file" name="myfile" value="" >
         <input type="submit" name="submit" >
</form>