Technical Blog

Enabling the MySQL Event Scheduler After installation, be sure to enable the scheduler(new mysql installations have it off by default) to check status: Code: SELECT @@event_scheduler; to enable: Code: SET GLOBAL event_scheduler = 1; Execute mysql stored procedure call UpdateSales 'UpdateSales' <-- stored procedure name

http://www.dq.winsila.com/security/create-a-password-protected-folder-without-any-special-software.html

16.1. MySQL Cluster Overview MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. MySQL Cluster is designed not to have any single point of failure. In a shared-nothing system, each component is expected to have its own memory and disk, and the use of shared storage mechanisms such as network shares, network file systems, and SANs is not recommended or supported. MySQL Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “ N etwork D ata B ase ”). In our documentation, the term NDB refers to the part of the setup that is specific to the storage engine, whereas “ MySQL Cluster ” refers to the combination of one or more MySQL servers with the NDB storage engine. A MySQL Cluster consists ...

Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License. Based on the powerful editing component Scintilla, Notepad++ is written in C++ and uses pure Win32 API and STL which ensures a higher execution speed and smaller program size. By optimizing as many routines as possible without losing user friendliness, Notepad++ is trying to reduce the world carbon dioxide emissions. When using less CPU power, the PC can throttle down and reduce power consumption, resulting in a greener environment. You're encouraged to translate Notepad++ into your native tongue if there's not already a translation present in the Binary Translations page. And if you want, help translating Notepad++ official site into your native tongue would be greatly appreciated. official site : http://notepad-plus-plus.org Notepad...

XML Syntax Rules The syntax rules of XML are very simple and logical. The rules are easy to learn, and easy to use. 1.      All XML Elements Must Have a Closing Tag In XML, it is illegal to omit the closing tag. All elements must have a closing tag: <p>This is a paragraph</p> <p>This is another paragraph</p>   2.      XML Tags are Case Sensitive XML tags are case sensitive. The tag <Letter> is different from the tag <letter>. 3.      XML Elements Must be Properly Nested In XML, all elements must be properly nested within each other: <b><i>This text is bold and italic</i></b>   4.      XML Documents Must Have a Root Element XML documents must contain one element that is the parent of all other elements. This element is called the root element. <root>   <child>  ...

/* * PHP: Using setters and getters * This clsss will show the usage of PHP setters and getters * */ class Employee { //This is private, so this can't be accessed from out side the class. private $name = "Dantha Elvitigala"; //public function.this can be access from outside the class //it's used to set the employee name into variable $name public function setName($name){ $this->name= $name; } //public function.this also can be access from outside the class //this use for get the emploee name stored in $name public function getName(){ return $this -> name; } }//end class //create an instant of the Employee class $employee = new Employee(); //set $name with another employee name $employee -> setName("Chandika Elvitigala"); // printout the employee name echo $employee->getName();

* In PHP, there are three kind of arrays: * 1)Numeric array - An array with a numeric index * 2)Associative array - An array where each ID key is associated with a value * 3)Multidimensional array - An array containing one or more arrays 1)Numeric Arrays A numeric array stores each array element with a numeric index. There are two methods to create a numeric array. 1. In the following example the index are automatically assigned (the index starts at 0): $array1 = array(3,5,7,2); echo $array1[0]." "; $array2 = array(4,"dantha" ,"brown" ,array("x","y","z")); echo $array2[3][2]." "; $array2[3] = "Cat"; echo $array2[3]." "; 2. In the following example we assign the index manually: $cars[0]="Honda"; $cars[1]="Nissan"; $cars[2]="BMW"; $cars[3]="Toyota"; echo $cars[0]." and ".$cars[1]." are Japanese cars"; 2) ASSOCIAT...