Tutorial by Examples: a

DELIMITER $$ CREATE DEFINER=`db_username`@`hostname_or_IP` FUNCTION `function_name`(optional_param data_type(length_if_applicable)) RETURNS data_type BEGIN /* SQL Statements goes here */ END$$ DELIMITER ; The RETURNS data_type is any MySQL datatype.

socket_last_error can be used to get the error ID of the last error from the sockets extension. socket_strerror can be used to convert the ID to human-readable strings. function onSocketFailure(string $message, $socket = null) { if(is_resource($socket)) { $message .= ": " ....

CSS Here are the minimum CSS rules that Google advises you to use, in a separate CSS file, or within an HTML style tag, e.g. <style type="text/css">...</style>. html, body { height: 100%; margin: 0; padding: 0; } #map { height: 400px; } HTML Goo...

Sub Theloopofloops() Dim wbk As Workbook Dim Filename As String Dim path As String Dim rCell As Range Dim rRng As Range Dim wsO As Worksheet Dim sheet As Worksheet path = "pathtofile(s)" & "\" Filename = Dir(path & "*.xl??") Set wsO =...

This example illustrates how to read various-type struct entries from MATLAB, and pass it to C equivalent type variables. While it is possible and easy to figure out from the example how to load fields by numbers, it is here achieved via comparing the field names to strings. Thus the struct fields ...

Import Element Tree module import xml.etree.ElementTree as ET Element() function is used to create XML elements p=ET.Element('parent') SubElement() function used to create sub-elements to a give element c = ET.SubElement(p, 'child1') dump() function is used to dump xml elements. ET.dump...

The default user interfaces for WPF controls are typically constructed from other controls and shapes. For example, a Button is composed of both ButtonChrome and ContentPresenter controls. The ButtonChrome provides the standard button appearance, while the ContentPresenter displays the button's cont...

<Window xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" x:Class="SDKSample.ControlTemplateButtonWindow" Title="Button with Control Template" Height=&quo...

Python xlrd library is to extract data from Microsoft Excel (tm) spreadsheet files. Installation:- pip install xlrd Or you can use setup.py file from pypi https://pypi.python.org/pypi/xlrd Reading an excel sheet:- Import xlrd module and open excel file using open_workbook() method. import x...

Actions are located in /usr/local/etc/scanbd/scanbd.conf. I have 4 buttons that are scan, copy, email and file. The default config file doesn't include all actions per default, you will probably have to add the block manually. You can have less or more buttons depending of your scanner model. ...

// register activation hook register_activation_hook( __FILE__, 'example_activation' ); // function for activation hook function example_activation() { // check if scheduled hook exists if ( !wp_next_scheduled( 'my_event' )) { // Schedules a hook // time() - the f...

For the current shell, this takes you to the previous directory that you were in, no matter where it was. cd - Doing it multiple times effectively "toggles" you being in the current directory or the previous one.

The default directory is the home directory ($HOME, typically /home/username), so cd without any directory takes you there cd Or you could be more explicit: cd $HOME A shortcut for the home directory is ~, so that could be used as well. cd ~

To change to an absolutely specified directory, use the entire name, starting with a backslash \, thus: cd /home/username/project/abc If you want to change to a directory near your current on, you can specify a relative location. For example, if you are already in /home/username/project, you can...

CakePHP 3.x has the ability to bake controllers, models, views and other framework defined objects. Note : If you have had some experience with the Laravel framework, the artisan component is similar to bake. The bake application is located in bin folder; the following are some of the availabl...

You can easily create tables for Your database or drop them if You want. If You wish to do that, You should learn how to write Migrations for desired database. Migrations files must be located in config/Migrations folder. File names can be in next formats: YYYYMMDDHHIISS_(Create|Alter|Delete)Ad...

Want to create a controller? There is 2 ways of creating it: Manually (You will be forced to manually create Controller file in src/Controller) Baked (Running bin/cake bake controller %controllerName% command from CLI) If You want to create it manually, go to src/Controller folder and create ...

from selenium import webdriver driver = webdriver.Chrome() # Creates a new chromedriver instance driver.get("https://www.python.org/") # Go to https://www.python.org/ # Sends the text "python" to the text search box driver.find_element_by_id("id-search-field").s...

This is a basic example of a Selenium testcase using the python Unittest library from selenium import webdriver import unittest class SeleniumTest(Unittest.testcase): def setUp(self): self.driver = webdriver.Chrome() self.driver.implicitly_wait(30) def te...

from selenium import webdriver # Create a new webdriver driver = webdriver.Chrome() # Get a page that has a popup window (Use mouse to click "try it" button) driver.get("http://www.w3schools.com/js/tryit.asp?filename=tryjs_alert") # Accept the opened alert driver.switch_t...