Tutorial by Examples: ti

Table/Column Names Two common ways of formatting table/column names are CamelCase and snake_case: SELECT FirstName, LastName FROM Employees WHERE Salary > 500; SELECT first_name, last_name FROM employees WHERE salary > 500; Names should describe what is stored in their object. Th...

There is no widely accepted standard. What everyone agrees on is that squeezing everything into a single line is bad: SELECT d.Name, COUNT(*) AS Employees FROM Departments AS d JOIN Employees AS e ON d.ID = e.DepartmentID WHERE d.Name != 'HR' HAVING COUNT(*) > 10 ORDER BY COUNT(*) DESC; At th...

Creating Express Web Server Express server came handy and it deeps through many user and community. It is getting popular. Lets create a Express Server. For Package Management and Flexibility for Dependency We will use NPM(Node Package Manager). Go to the Project directory and create package....

$man <command> Displays the on-line manual pages for the command $clear Clears the terminal screen $pwd Returns the working directory name $echo <string> Writes the string to the standard output $printf <string> Format and print the string Example: print $PATH ...

A common problem with remote services is rate limiting. The remote service allows us to send only a limited number of requests or amount of data per time period. In RxJS 5 a very similar functionality is provided by the bufferTime operator and especially if we leave the second parameter unspecified...

Registering items is done from your main mod class, or a ModItems class method invoked from the main mod class during preInit. Item item = new CustomItem(); string registryname = "my_item"; item.setRegistryName(registryname); item.setUnlocalizedName(item.getRegistryName().toString()); ...

One of the most common and useful ways to replace text with regex is by using Capture Groups. Or even a Named Capture Group, as a reference to store, or replace the data. There are two terms pretty look alike in regex's docs, so it may be important to never mix-up Substitutions (i.e. $1) with Back...

I am using eclipse here, and you need to add below given dependency to your pom.xml 1.) POM.XML <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://m...

XSS means cross-site scripting. CodeIgniter comes with XSS filtering security. This filter will prevent any malicious JavaScript code or any other code that attempts to hijack cookie and do malicious activities. To filter data through the XSS filter, use the xss_clean() method as shown below. $data...

SQL injection is an attack made on the database query. In PHP, we use mysql_real_escape_string() function to prevent this along with other techniques but CodeIgniter provides inbuilt functions and libraries to prevent this. We can prevent SQL Injection in CodeIgniter in the following three ways − ...

CSRF stands for cross-site request forgery. You can prevent this attack by enabling an option in the application/config/config.php file as shown below. $config['csrf_protection'] = TRUE; When you create a form using the form_open() function, it will automatically insert a CSRF token in a hidden ...

Don't rely on any user input. user input everything like <script> tag or any javascript alert(); so we have to prevent this all data will no run in our browser. so we have to use xss prevention method to restrict our secure data to kept in hacker hand and also it's developer's responsibility t...

<?php // Setting parameters $time = time(); $values = [7, $time, $time]; // Prints "At 3:50:31 PM on Apr 19, 2015, there was a disturbance on planet 7." $pattern = "At {1, time} on {1, date}, there was a disturbance on planet {0, number}."; $formatter = new Messa...

It's relatively easy to parse the command line by hand if you aren't looking for anything too complex: # Naive error checking abort('Usage: ' + $0 + ' site id ...') unless ARGV.length >= 2 # First item (site) is mandatory site = ARGV.shift ARGV.each do | id | # Do something interestin...

Detailed instructions on getting identityserver4 set up or installed.

By setting Multi-Release: true in the MANIFEST.MF file, the Jar file becomes a multi-release Jar and the Java runtime (as long as it supports the MRJAR format) will pick the appropriate versions of classes depending on the current major version. The structure of such a Jar is the following: jar ro...

The jar command can be used to create a multi-release Jar containing two versions of the same class compiled for both Java 8 and Java 9, albeit with a warning telling that the classes are identical: C:\Users\manouti>jar --create --file MR.jar -C sampleproject-base demo --release 9 -C sampleproje...

Given the following multi-release Jar: jar root - demo - SampleClass.class - META-INF - versions - 9 - demo - SampleClass.class The following class prints the URL of the SampleClass: package demo; import java.net.URL; public class Main...

A couple of other options allow stack traces to include implementation and/or reflection frames. This may be useful for debugging purposes. For instance, we can add the SHOW_REFLECT_FRAMES option to the StackWalker instance upon creation, so that the frames for the reflective methods are printed as ...

Table ORDERS +---------+------------+----------+-------+--------+ | orderid | customerid | customer | total | items | +---------+------------+----------+-------+--------+ | 1 | 1 | Bob | 1300 | 10 | | 2 | 3 | Fred | 500 | 2 | | 3 | ...