Tutorial by Examples: p

Splitting Strings using CROSS APPLY (Oracle 12c)

Sample Data: CREATE TABLE table_name ( id, list ) AS SELECT 1, 'a,b,c,d' FROM DUAL UNION ALL -- Multiple items in the list SELECT 2, 'e' FROM DUAL UNION ALL -- Single item in the list SELECT 3, NULL FROM DUAL UNION ALL -- NULL list SELECT 4, 'f,,g' FROM DUAL; -- NULL item...

Oracle Database • Splitting Delimited Strings

Encryption and Decryption using Cryptography (AES)

Decryption Code public static string Decrypt(string cipherText) { if (cipherText == null) return null; byte[] cipherBytes = Convert.FromBase64String(cipherText); using (Aes encryptor = Aes.Create()) { Rfc2898DeriveBytes pdb = ...

.NET Framework • Encryption / Cryptography

Replacing fragments with ajax

If you want to replace parts of your website, ajax is an easy way to do it. The website.html where you want to replace the content based on the selected value: <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org"> ...

thymeleaf • Getting started with thymeleaf

Types of Validations

Let's initially understand basic types of custom validators: Inline Validator Standalone Validator Inline Validator: It is the type of the validator we create inside the class which is basically a method we define just like other methods but with extra parameters which is passed in by Yii2. ...

yii2 • Custom Validations

Access to Request in a Twig or PHP template.

In Twig template, Request object is available at {{ app.request }} When you want display request method in Twig, try this: <p>Request method: {{ app.request.method }}</p> In PHP template <p>Request method: <?php echo $app->getRequest()->getMethod() ?></p>...

symfony2 • Request

Grouping a few input fields

While designing a form, you might like to group a few input fields into a group to help organise the form layout. This can be done by using the tag . Here is an example for using it. For each fieldset, you can set a legend for the set using the tag LEGEND TEXT Example <form> <fieldset...

HTML • Forms

Adding the "Theme page title" item to the nav bar

Code function add_the_theme_page(){ add_menu_page('Theme page title', 'Theme menu label', 'manage_options', 'theme-options', 'page_content', 'dashicons-book-alt'); } add_action('admin_menu', 'add_the_theme_page'); function page_content(){ echo '<div class="wrap"><h2&...

WordPress • add_menu_page()

Secure your WebApp with Login and Logout

This example is a very simple Spring Boot application. Maven Dependencies At first add the following dependencies to your project. Spring Initializr is recommended when you create a new project. <parent> <groupId>org.springframework.boot</groupId> <artifactId>spr...

thymeleaf • Spring Security and Thymeleaf

Example

First you have to create a file constants.php and it is a good practice to create this file inside app/config/ folder. You can also add constants.php file in compose.json file. Example File: app/config/constants.php Array based constants inside the file: return [ 'CONSTANT' => 'This...

Laravel • Constants

Adding the "Submenu Page" as a sub-page of "Tools" to the nav bar

Code add_action('admin_menu', 'register_my_custom_submenu_page'); function register_my_custom_submenu_page() { add_submenu_page( 'tools.php', 'Submenu Page', 'My Custom Submenu Page', 'manage_options', 'my-custom-submenu-page', 'my_cust...

WordPress • add_submenu_page()

Handling non-existing options

Code <?php echo get_option( 'something_bla_bla_bla' ); ?> Output false Code <?php echo get_option( 'something_bla_bla_bla', 'Oh no!' ); ?> Output Oh no!

WordPress • get_option()

Using tools like lscpu and lshw

By using tools like lscpu as lscpu is an easy way to get CPU information. $ lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 4 On-line CPU(s) list: 0-3 Thread(s) per core: 1 Core(s) per socket: 4 So...

GNU/Linux • Getting System Information

Reshape from wide to long format with gather()

library(tidyr) ## example data df <- read.table(text =" numbers firstName secondName 1 1 1.5862639 0.4087477 2 2 0.1499581 0.9963923 3 3 0.4117353 0.3740009 4 4 -0.4926862 0.4437916", header = T) df # numbers firstName secondName # 1 ...

R Language • Reshape using tidyr

Making a button in your UI that pauses callback execution

Sometimes we'd like to pause code execution to inspect the state of the application (see Debugging). When running code through the MATLAB editor, this can be done using the "Pause" button in the UI or by pressing Ctrl+c (on Windows). However, when a computation was initiated from a GUI (vi...

MATLAB Language • MATLAB User Interfaces

Creating a video with OpenCV (Java)

VideoWriter videoWriter; videoWriter = new VideoWriter(outputFile, VideoWriter.fourcc('x', '2','6','4'), fps, frameSize, isRGB); //We have stated that we will use x264 as codec with FourCC //For writing, we add the following method and it will write the image we give as parameter...

opencv • Creating a Video

pseudocode for a dumb file manager

/* * Component is an interface * which all elements (files, * folders, links ...) will implement */ class Component { public: virtual int getSize() const = 0; }; /* * File class represents a file * in file system. */ class File : public Component { public: virtual int...

Design patterns • Composite pattern

Including a Section on a Page

Including a Static Section on a page is similar to including a snippet. The only difference is instead of using the word include you use the word section. {% section 'section-file-name' %} Using this tag will "hardcode" the section into your theme at the place where you put the code an...

Shopify • Implementing Sections

Open Close Principle violation

/* * This design have some major issues * For each new shape added the unit testing * of the GraphicEditor should be redone * When a new type of shape is added the time * for adding it will be high since the developer * who add it should understand the logic * of the Gr...

Design patterns • Open Close Principle

Open Close Principle support

/* * For each new shape added the unit testing * of the GraphicEditor should not be redone * No need to understand the sourcecode * from GraphicEditor. * Since the drawing code is moved to the * concrete shape classes, it's a reduced risk * to affect old functionallity when new * functionall...

Design patterns • Open Close Principle

Maven dependencies

This example is based on spring boot 1.5.1.RELEASE. with the following dependencies:  <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency>...

spring-boot • Spring boot + Hibernate + Web UI (Thymeleaf)