Tutorial by Examples: i

a. Running multiple queries at same time All queries in MySQL connection are done one after another. It means that if you want to do 10 queries and each query takes 2 seconds then it will take 20 seconds to complete whole execution. The solution is to create 10 connection and run each query in a di...

You send the query as a string and in response callback with the answer is received. The callback gives you error, array of rows and fields. Each row contains all the column of the returned table. Here is a snippet for the following explanation. connection.query('SELECT name,email from users', fu...

Follow previous example of creating a seed. This example uses a MySQL Dump to seed a table in the project database. The table must be created before seeding. <?php use Illuminate\Database\Seeder; class UserTableSeeder extends Seeder { /** * Run the database seeds. * ...

git checkout --orphan new-orphan-branch The first commit made on this new branch will have no parents and it will be the root of a new history totally disconnected from all the other branches and commits. source

You may define scripts in your package.json, for example: { "name": "your-package", "version": "1.0.0", "description": "", "main": "index.js", "author": "", "license": &qu...

Another example of "Hello World" style programs is FizzBuzz. This is one example of a FizzBuzz implementation. Very idiomatic Go in play here. package main // Simple fizzbuzz implementation import "fmt" func main() { for i := 1; i <= 100; i++ { s := &qu...

You can use a RecyclerView.ItemDecoration to put extra margins around each item in a RecyclerView. This can in some cases clean up both your adapter implementation and your item view XML. public class MyItemDecoration extends RecyclerView.ItemDecoration { private final int extraMargin; ...

You can use any element as an handle to drag another element around: <script> $(function() { $( "#draggable" ).draggable({ handle: ".handle" }); }); </script> <div id="draggable"> <span class="handle"&...

Once your setup.py is fully functional (see Introduction), it is very easy to upload your package to PyPI. Setup a .pypirc File This file stores logins and passwords to authenticate your accounts. It is typically stored in your home directory. # .pypirc file [distutils] index-servers = py...

Retrofit requests can be logged using an intercepter. There are several levels of detail available: NONE, BASIC, HEADERS, BODY. See Github project here. Add dependency to build.gradle: compile 'com.squareup.okhttp3:logging-interceptor:3.8.1' Add logging interceptor when creating Retrofit:...

You can group multiple boolean logic statements within parenthesis in order to create a more complex logic evaluation, especially useful in if statements. if ((age >= 18 && height >= 5.11) || (status === 'royalty' && hasInvitation)) { console.log('You can enter our club'); ...

This magic method is called when user tries to invoke object as a function. Possible use cases may include some approaches like functional programming or some callbacks. class Invokable { /** * This method will be called if object will be executed like a function: * * $invo...

__call() and __callStatic() are called when somebody is calling nonexistent object method in object or static context. class Foo { /** * This method will be called when somebody will try to invoke a method in object * context, which does not exist, like: * * $foo->...

This method is called by var_dump() when dumping an object to get the properties that should be shown. If the method isn't defined on an object, then all public, protected and private properties will be shown. — PHP Manual class DeepThought { public function __debugInfo() { return...

Any PHP expression within double curly braces {{ $variable }} will be echoed after being run through the e helper function. (So html special characters (<, >, ", ', &) are safely replaced for the corresponding html entities.) (The PHP expression must evaluate to string, otherwise an ...

With Blade, you can also include partial views (called 'partials') directly into a page like so: @include('includes.info', ['title' => 'Information Station']) The code above will include the view at 'views/includes/info.blade.php'. It will also pass in a variable $title having value 'Informat...

Subclassing UIControl gives us access to the following methods: beginTrackingWithTouch is called when the finger first touches down within the control's bounds. continueTrackingWithTouch is called repeatedly as the finger slides across the control and even outside of the control's bounds. endTr...

With local image Swift let image = UIImage(named: "imageFromBundleOrAsset") Objective-C UIImage *image = [UIImage imageNamed:@"imageFromBundleOrAsset"]; Note The method imageNamed caches the image's contents to memory. Loading many large images that way can cause low...

The most "popular" way of reversing a string in JavaScript is the following code fragment, which is quite common: function reverseString(str) { return str.split('').reverse().join(''); } reverseString('string'); // "gnirts" However, this will work only so long as ...

Just add the using at the beginning and the [WebMethod] decorator to the static method to be called in the aspx page: using System.Web.Services; public partial class MyPage : System.Web.UI.Page { [WebMethod] public static int GetRandomNumberLessThan(int limit) { var r = ...