Tutorial by Examples: ga

To call a stored procedure on the server: $query = "{call [dbo].[myStoredProcedure](?,?,?)}"; //Parameters '?' includes OUT parameters $params = array( array($name, SQLSRV_PARAM_IN), array($age, SQLSRV_PARAM_IN), array($count, SQLSRV_PARAM_OUT, SQLSRV_PHPTYPE_INT) //$cou...

$conn = sqlsrv_connect($dbServer, $connectionInfo); $query = "SELECT * FROM [users] WHERE [name] = ? AND [password] = ?"; $params = array("joebloggs", "pa55w0rd"); $stmt = sqlsrv_query($conn, $query, $params); If you plan on using the same query statement more...

Intro An array is a container object that holds a number of values. In the following image you can see an array with size 10, the first element indexed 1 and the last element 10. Autohotkey offers a few ways of defining and creating arrays. Array := [] Array := Array() Creating and initia...

Save the session variable as a variable. $session = Yii::$app->session; $sess = $session['keys']; Then create or update the array value you want $sess['first'] = 'abc'; And finally save to the session variable $session['keys'] = $sess

To bootstrap a new Erlang project, simply choose the template you want to use from the list. The available templates can be retrieved by the following command: $ rebar3 new app (built-in): Complete OTP Application structure cmake (built-in): Standalone Makefile for building C/C++ in c_src escr...

Hash tables are created by make-hash-table: (defvar *my-table* (make-hash-table)) The function may take keyword parameters to further specify the behavior of the resulting hash table: test: Selects the function used to compare keys for equality. Maybe a designator for one of the functions eq,...

String#at Returns a substring of a string object. Same interface as String#[]. str = "hello" str.at(0) # => "h" str.at(1..3) # => "ell" str.at(-2) # => "l" str.at(-2..-1) # => "lo" str.at(5) # => nil str.at(5..-...

Say you want to add a foreign key company_id to the users table, and you want to have a NOT NULL constraint on it. If you already have data in users, you will have to do this in multiple steps. class AddCompanyIdToUsers < ActiveRecord::Migration def up # add the column with NULL allowed ...

decoded, err := base64.StdEncoding.DecodeString(`biws`) if err != nil { log.Fatal(err) } fmt.Printf("%s", decoded) // Output: n,, Playground

Instead of adding an observer with a selector, a block can be used: id testObserver = [[NSNotificationCenter defaultCenter] addObserverForName:@"TestNotification" object:nil ...

$username = 'Hadibut'; $email = '[email protected]'; $variables = compact('username', 'email'); // $variables is now ['username' => 'Hadibut', 'email' => '[email protected]'] This method is often used in frameworks to pass an array of variables between two components.

You can display an SVG file within an HTML document, by specifying it as a background image in CSS. For example: .element { background-size: 100px 100px; background: url(my_svg_file.svg); height: 100px; width: 100px; } If the dimensions specified in your SVG file are larger ...

A Gemfile is the standard way to organize dependencies in your application. A basic Gemfile will look like this: source 'https://rubygems.org' gem 'rack' gem 'sinatra' gem 'uglifier' You can specify the versions of the gem you want as follows: # Match except on point release. Use only 1.5....

To create a search form, enter the following code <%= form_tag("/search", method: "get") do %> <%= label_tag(:q, "Search for:") %> <%= text_field_tag(:q) %> <%= submit_tag("Search") %> <% end %> form_tag: This is t...

This is an example of a package-info.java file that binds an XML namespace to a serializable Java class. This should be placed in the same package as the Java classes that should be serialized using the namespace. /** * A package containing serializable classes. */ @XmlSchema ( xmlns = ...

express my-app

To create a NuGet package from a project, run this command from a directory that contains project.json: dotnet pack The resulting .nupkg file will be named and versioned according to the properties in project.json. If there are multiple frameworks targeted in the project file, the package will s...

Running dotnet test from inside a folder that contains a test project will launch the test runner. The test runner will discover and run the tests in the project. To be compatible with dotnet test, the project.json file must contain a testRunner property and a dependency on a compatible test runner...

Chaining assignments as part of a var declaration will create global variables unintentionally. For example: (function foo() { var a = b = 0; })() console.log('a: ' + a); console.log('b: ' + b); Will result in: Uncaught ReferenceError: a is not defined 'b: 0' In the above examp...

WebSocket provides a duplex/bidirectional communication protocol over a single TCP connection. the client opens a connection to a server that is listening for a WebSocket request a client connects to a server using a URI. A server may listen to requests from multiple clients. Server Endpoint...