DZone Snippets: Ki4ngel's Code Snippets

Copy MySQL table

ki4ngel (Benoit Asselin) — Tue, 13 May 2008 17:31:35 GMT



CREATE TABLE table_destination SELECT * FROM table_source ;



CREATE TABLE table_destination LIKE table_source ;

INSERT INTO table_destination SELECT * FROM table_source ;

Source: Asselin Benoit Development ( MySQL, SQL ) & Agence ici, agence de communication

parseInt() in PHP

ki4ngel (Benoit Asselin) — Sun, 16 Mar 2008 15:39:02 GMT



function parseInt($string) {

//	return intval($string);

	if(preg_match('/(\d+)/', $string, $array)) {

		return $array[1];

	} else {

		return 0;

	}

}



echo parseInt("2008"); // 2008

echo parseInt("99.90 dollars"); // 99

echo parseInt("www.w3.org"); // 3

echo parseInt("300 spartiates"); // 300

echo parseInt("block text..."); // 0

Source: AB-D Création de sites internet

insertAfter() with insertBefore() and node.nextSibling

ki4ngel (Benoit Asselin) — Tue, 26 Feb 2008 20:53:30 GMT

insertAfter() with insertBefore() and node.nextSibling



Node.prototype.insertAfter = function(newNode, refNode) {

	if(refNode.nextSibling) {

		return this.insertBefore(newNode, refNode.nextSibling);

	} else {

		return this.appendChild(newNode);

	}

}

Source: Benoit Asselin

Selector :target in CSS 3

ki4ngel (Benoit Asselin) — Tue, 19 Feb 2008 20:59:36 GMT





	"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">







	CSS3 *:target

	

	







	

	Title n°1

	CSS...

	CSS...

	CSS...

	

	

	Title n°2

	CSS...

	CSS...

	CSS...

	

	

	Title n°1 | Title n°2

Source: AB-D.fr

Position : fixed in MSIE6

ki4ngel (Benoit Asselin) — Mon, 11 Feb 2008 20:39:19 GMT





	"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">







	"position: fixed" compatible Microsoft Internet Explorer 6

	

	

	

	

	

	

	

	

	

	

	

	







	

	DIV in position: fixed;

	

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

	Content...

Source: Asselin Benoit Developpement, conception de sites internet

Make a variable CSS

ki4ngel (Benoit Asselin) — Wed, 06 Feb 2008 19:02:03 GMT

Page.html



	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">







	

	

	Variable CSS

	











Title



 Text  Text  Text  



 Text  Text  Text  



 Text  Text  Text

Style.php



header('Content-Type: text/css');



$color_0 = '#000000';

$color_1 = '#ff0000';

$color_2 = '#ff3300';

$color_3 = '#ff6600';



?>



* { font-family: sans-serif; }



h1 {

	padding: 5px;

	color: ;

	border: 5px solid ;

	background-color: ;

}



p.color-1 { color: ; }

p.color-2 { color: ; font-weight: bold; }

p.color-3 { color: ; font-style: italic; }

Source: Asselin Benoit Développement, création de site internet amiens

Regular Expressions with MySQL

ki4ngel (Benoit Asselin) — Sat, 19 Jan 2008 22:05:22 GMT



SELECT * FROM texts WHERE content REGEXP '[^a-z]Hello[^a-z]' ;

If you really want to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string.



SELECT * FROM texts WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ;

Warning: some characters do not work. Example :



SELECT * FROM texts WHERE content REGEXP '[^\w]Hello[^\w]' ;

ab-d.fr source code

Google Analytics

ki4ngel (Benoit Asselin) — Sun, 30 Dec 2007 15:10:36 GMT

src:ab-d

iPhone Orientation

ki4ngel (Benoit Asselin) — Sat, 22 Dec 2007 12:53:44 GMT

iPhoneOrientation
Demonstrates how to handle iPhone or iPod touch orientation events using HTML, CSS, and JavaScript.

index.html









		

		

		Handling iPhone or iPod touch Orientation Events 

		

		

		

		

		

		





		

		



		

		

			

			

			

					Debug Console

					Viewport Settings

			

			

					Highlighting Elements

					Form Auto Correction

iPhoneOrientation.css



body 

{

		margin: 0px;

		padding: 0px;

		font-size: 12px;

		font-family: 'Lucida Grande', Verdana, sans-serif;

		font-weight: bold;

		/* Turn off font resizing */

		-webkit-text-size-adjust: none;   

}







/* Set the background color of the page when the body tag's class attribute is equal to portrait. 

   The expression body[class="value"] is a CSS attribute selector where "body" is the html element to be styled, "class" the body's attribute to be

   manipulated, and "value" the class attribute's value, which is either portrait, landscapeLeft, or landscapeRight.

   This expression is used to dynamically select a body style according to the class attribute value. For instance, if the body's class attribute is set

   to landscapeLeft, then all style declarations matching body[class="landscapeLeft"] will be used to style "Handling iPhone or iPod touch Orientation Events". 

   The JavaScript updateOrientation function in the iPhoneOrientation.js file is used to set the body's class attribute to one of these values.

   Further information about CSS attribute selectors can be found at  http://www.w3.org/TR/css3-selectors/#attribute-selectors.

 */

body[class="portrait"] 

{

		background: white;    	

}





/* Adjust a button when the body's class attribute is equal to portrait */

body[class="portrait"] .button    

{	

		background: white;

		width: 210px;

		height: 13px;

		

		padding: 10px 0px;

		margin: 10px auto;

		

		font-size: 15px;

		

		/* text is black on the button */

		color: black;

}





/* The leftContainer and rightContainer div elements are stacked up one after the other when the body's class attribute is equal to portrait. 

   They are both 200 pixels wide. */

body[class="portrait"] #leftContainer

{

		width: 200px;

		margin: auto auto;

}





body[class="portrait"] #rightContainer

{

		width: 200px;

		margin: auto auto;

}





/* Set the background color of the page when the body's class attribute is set to landscapeLeft */

body[class="landscapeLeft"] 

{

		background: lightgrey;

}





/* Adjust a button when the body's class attribute is set to landscapeLeft */

body[class="landscapeLeft"] .button  

{

		background: black;

}





/* The container div is evenly split between leftContainer and rightContainer when the body's class attribute is set to landscapeLeft.

   leftContainer and rightContainer are stacked side by side. leftContainer aligns buttons to the left side of the page; 

   rightContainer aligns buttons to the right side of the page. */

body[class="landscapeLeft"] #leftContainer

{

		width: 50%;

		/* Align the div to the left of the page  */

		float: left;

}





body[class="landscapeLeft"] #rightContainer

{

		width: 50%;

		/* Align the div to the right of the page  */

		float: right;

}







/* Set the background color of the page when the body's class attribute is equal to landscapeRight */

body[class="landscapeRight"] 

{

		background: tan;

}





/* Adjust a button when the body's class attribute is equal to landscapeRight */

body[class="landscapeRight"] .button  

{

		background: darkred;

}





/* The container div is evenly split between leftContainer and rightContainer when the body's class attribute is set to landscapeRight.

   leftContainer aligns buttons to the left side of the page; rightContainer aligns buttons to the right side of the page. */

body[class="landscapeRight"] #leftContainer

{

		width: 50%;

		float: left;

}



body[class="landscapeRight"] #rightContainer

{

		width: 50%;

		float: right;

}





/* Draw a rounded rectangle around a text */

 .button    

{

		font-weight: bold;

		text-align: center;

		

		width: 130px;

		height: 13px;

		font-size: 10px;

		

		/* text is white on the button */

		color: white;	

	

		/* Draw a rectangle around a text */

		border: 1px solid black;    

		

		/* Round each corner of the generated rectangle */

		-webkit-border-radius: 5px;   

		padding: 5px 0px;

		margin: 5px auto;

}





/* Defines styling properties for the currentOrientation div, which shows a message that indicates iPhone's current orientation after rotation */

#currentOrientation

{		

		width: 280px;

		text-align: center;

		margin: 10px auto;

}





a

{

		text-decoration: none;

}





/* The container div contains four buttons that are evenly divided between the inner leftContainer and rightContainer div elements.

   Its width does not change when iPhone switches between portrait and landscape orientations. */

#container

{

		/* fixed width across all iPhone orientation changes */

		width: 300px;

		margin: 10px auto;

}

iPhoneOrientation.js



/* updateOrientation checks the current orientation, sets the body's class attribute to portrait, landscapeLeft, or landscapeRight, 

   and displays a descriptive message on "Handling iPhone or iPod touch Orientation Events".  */

function updateOrientation()

{

	/*window.orientation returns a value that indicates whether iPhone is in portrait mode, landscape mode with the screen turned to the

	  left, or landscape mode with the screen turned to the right. */

	var orientation=window.orientation;

	switch(orientation)

	{

	

		case 0:

				/* If in portrait mode, sets the body's class attribute to portrait. Consequently, all style definitions matching the body[class="portrait"] declaration

				   in the iPhoneOrientation.css file will be selected and used to style "Handling iPhone or iPod touch Orientation Events". */

				document.body.setAttribute("class","portrait");

				

				/* Add a descriptive message on "Handling iPhone or iPod touch Orientation Events"  */

				document.getElementById("currentOrientation").innerHTML="Now in portrait orientation (Home button on the bottom).";

				break;	

				

		case 90:

				/* If in landscape mode with the screen turned to the left, sets the body's class attribute to landscapeLeft. In this case, all style definitions matching the

				   body[class="landscapeLeft"] declaration in the iPhoneOrientation.css file will be selected and used to style "Handling iPhone or iPod touch Orientation Events". */

				document.body.setAttribute("class","landscapeLeft");

				

				document.getElementById("currentOrientation").innerHTML="Now in landscape orientation and turned to the left (Home button to the right).";

				break;

		

		case -90:	

				/* If in landscape mode with the screen turned to the right, sets the body's class attribute to landscapeRight. Here, all style definitions matching the 

				   body[class="landscapeRight"] declaration in the iPhoneOrientation.css file will be selected and used to style "Handling iPhone or iPod touch Orientation Events". */

				document.body.setAttribute("class","landscapeRight");

				

				document.getElementById("currentOrientation").innerHTML="Now in landscape orientation and turned to the right (Home button to the left).";

				break;

	}



}



// Point to the updateOrientation function when iPhone switches between portrait and landscape modes.

window.onorientationchange=updateOrientation;

Source: http://developer.apple.com/samplecode/iPhone/idxSafari-date.html
( AB-D )

count() in JavaScript

ki4ngel (Benoit Asselin) — Sat, 08 Dec 2007 13:11:46 GMT

The same function as count() in php.



Array.prototype.count = function() {

	return this.length;

};

Sample :



var v_array = [ 5, 10, 15, 20, 25];

document.writeln(v_array.count());  // 5

Source: AB-D.fr