Overview
Query.popeye is an advanced image gallery script built on the JavaScript library jQuery. Use it to save space when displaying a collection of images and offer your users a nice and elegant way to show a big version of your images without leaving the page flow.

Though the script is quick and easy to setup, it offers great flexibility in both behaviour and styling.

It was designed as an alternative to the often-seen JavaScript image lightbox (see Lightbox 2, Fancybox or Colorbox, just to name a few). What they all have in common: they employ a modal window to display the large images, thus disrupting the workflow of the user interacting with a webpage.

jQuery.popeye takes a different approach: not only allows it for browsing all thumbnails as well as the large images in a single image space, it also repects the page flow and stays anchored and rooted in the webpage at all times, thus giving a less disruptive user experience than modal windows.

Demo

http://dev.herr-schuessler.de/jquery/popeye/demo.html

Download

http://plugins.jquery.com/project/popeye

jQuery.popeye 2.0 is a post from: Silenthinker

Overview
DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls to any HTML table.

Usage
http://datatables.net/usage

Examples
http://datatables.net/examples

Download
http://datatables.net/download

DataTables is a post from: Silenthinker

Overview
The jQuery Cycle Plugin is a slideshow plugin that supports many different types of transition effects. It supports pause-on-hover, auto-stop, auto-fit, before/after callbacks, click triggers and much more.

How it Works
The plugin provides a method called cycle which is invoked on a container element. Each child element of the container becomes a “slide”. Options control how and when the slides are transitioned.

Demo
http://malsup.com/jquery/cycle/

Download
http://malsup.com/jquery/cycle/download.html

jQuery Cycle Plugin is a post from: Silenthinker

What is Lorem Ipsum?
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. ~ source

Below are some example of Lorem Ipsum text:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque adipiscing sollicitudin augue sed congue. Cras nec nunc nisl, at cursus lacus. Sed pretium tincidunt sollicitudin. Pellentesque sed ligula lacus. Maecenas nulla diam, auctor vitae viverra ac, dignissim at urna. Maecenas non accumsan libero. Pellentesque bibendum pulvinar justo ac pretium. Vivamus eu ornare mi. Quisque volutpat pellentesque facilisis. Phasellus eu massa mauris, non ornare orci. Integer vulputate gravida tristique. Proin fermentum, lacus in lobortis pulvinar, tortor est iaculis quam, vel scelerisque elit mauris sit amet ipsum. Sed vitae condimentum enim. Aenean vel ipsum ac lectus euismod ultricies vel non quam. Integer lacus quam, scelerisque id ultrices id, fringilla vel ipsum. Donec auctor ultricies nisi ut semper.

Etiam porttitor placerat pretium. Mauris vel ante in tellus consectetur tristique. Mauris cursus felis ac ipsum tincidunt placerat. Maecenas eu dolor ut orci convallis iaculis nec a elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed dapibus ornare sem ac convallis. Donec diam libero, venenatis ac volutpat non, euismod non lorem. Nullam urna augue, euismod nec venenatis et, malesuada sed quam. Nulla sagittis, sapien ut semper congue, nibh leo consectetur nunc, ut facilisis lorem lorem ac erat. Integer in orci dolor, non tristique dolor. Nullam ut orci dolor. Fusce volutpat mauris et tortor scelerisque scelerisque.

Nunc porttitor elementum ante, eget vehicula massa congue tempus. Donec sit amet nibh mauris, vel convallis nunc. Phasellus sagittis eros vitae neque sollicitudin varius. Nunc vulputate bibendum odio molestie rutrum. Donec ornare, nibh in eleifend laoreet, leo ipsum venenatis lacus, et sodales sem diam sed magna. Ut sed nulla libero, non fringilla lacus. Nullam porta leo eu est scelerisque vel consectetur sapien sagittis. Mauris dui mauris, imperdiet nec tincidunt quis, rhoncus nec libero. Duis at laoreet dui. Vestibulum vestibulum arcu nec odio adipiscing sed vestibulum tortor ultricies. In leo lacus, laoreet eget sagittis non, suscipit a lectus. Donec accumsan, nulla et pulvinar gravida, justo metus ornare mauris, ut gravida metus nisi fermentum dolor. Sed malesuada ligula at est ultricies ac eleifend dui feugiat. Donec quis ligula dui, at dapibus magna. Aenean blandit malesuada dapibus. Duis sit amet mi quis orci vulputate vehicula id et odio. Nullam neque nibh, lobortis eget lobortis sit amet, fringilla eu ligula.

Sed rhoncus rutrum erat ac convallis. Sed commodo, nisl eu fringilla auctor, mauris magna lacinia turpis, in molestie mi purus in risus. Duis id neque nunc. Praesent laoreet tincidunt lacus, a ultricies augue luctus facilisis. Ut vitae ullamcorper nibh. Fusce neque nisi, aliquam tristique aliquam et, semper id lectus. Morbi quis imperdiet neque. Nam malesuada felis ipsum. Cras pulvinar consectetur purus, a blandit nunc tincidunt sodales. Sed sed libero neque. Maecenas gravida semper tellus, laoreet pellentesque enim ultricies a. Morbi eu erat eu lorem porttitor placerat. Etiam eget egestas tortor. Morbi at leo sed purus consectetur ullamcorper eu sed metus.

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Pellentesque sollicitudin feugiat orci. Morbi vitae nisi quis lorem tincidunt aliquet. Curabitur nisi dui, blandit sed volutpat a, euismod sed mi. Sed hendrerit nibh rhoncus velit rhoncus et auctor ligula tristique. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed arcu magna, accumsan a dictum et, vulputate at justo. Aenean tellus ante, mollis vel pretium sit amet, mattis sit amet justo. In quis dui eros, eu varius arcu. Suspendisse potenti. Phasellus eget enim non turpis lobortis hendrerit. Sed vulputate enim sit amet erat porttitor tempor sit amet vitae sem. Vivamus eu pulvinar ante. Maecenas rhoncus blandit dolor, a convallis sem accumsan congue. Donec eu sem at velit cursus venenatis. Etiam ullamcorper nulla a nisl pellentesque dapibus. Suspendisse tellus magna, gravida a placerat sed, dapibus a purus.

Do you use Lorem Ipsum before?

Lorem Ipsum? is a post from: Silenthinker

Requirement

• latest browscap.ini from Gary Keith’s site
• download Jonathan Stoppani’s browscap.ini parser
• create a folder called cache as Browscap.php will store information for quick access in the folder.

The Code

<?php
require('Browscap.php');

$bc = new Browscap('cache');
$bc->localFile = 'php_browscap.ini';

$data = $bc->getBrowser();
print_r($data);
?>

Finally, access $data as an object

echo $data->Browser;

Source taken from http://www.evanbot.com/article/php-browscap/19

Browser Detection using PHP Browscap is a post from: Silenthinker

Database table schema

create table usersExample (
userID int not null primary key auto_increment,
userName varchar(32) not null,
userPassword varchar(32) not null);

‘Skeleton’ of the User Class

<?
// This is the start of the class definition.  Note the key word 'class'

class User {

// Next comes the variable list as defined above
// Note the key word 'var' and then a comma-separated list

var $userID,
$userName,
$userPassword,
$dbHost,
$dbUser,
$dbName,
$dbPass,
$dbUserTable;

// Next come all our methods with their argument lists
// The syntax for these is just like normal PHP functions
// Remember, this is just a skeleton, we will fill in these functions later

function registerUser($userName, $userPassword) {
} // End registerUser()

function verifyPassword() {
} // End verifyPassword()

function changePassword($newPassword) {
} // End changePassword()

function displayUserInfo() {
} // End displayUserInfo()

} // End User class definition
?>

Complete User Class Methods

<?
// NOTE: Previous comments in this file have been ommitted - so all the comments are new
// Please refer to the skeleton above for more comments on exactly what is happening

class User {

var $userID,
$userName,
$userPassword,
$dbHost,
$dbUser,
$dbName,
$dbPass,
$dbUserTable;

// This is the constructor function definition - it's possible to pass
// it values just like a normal function, but that isn't demonstrated here
// These variables will be set for each object that is created using this class
function User() {
$this->dbHost = 'localhost';
$this->dbUser = 'yourUser';
$this->dbName = 'yourDatabase';
$this->dbPass = 'yourPassword';
$this->dbUserTable = 'usersExample';
}

function registerUser($userName, $userPassword) {
// Connect to database
$dbLink = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
if(!$dbLink) die("Could not connect to database. " . mysql_error());

// Select database
mysql_select_db($this->dbName);

// Insert data
// Notice the "$userName" and "$userPassword" - these are the ones
// passed in from your main script, not the class/object variables!
$query = "insert into $this->dbUserTable values (NULL, \"$userName\", \"$userPassword\")";
$result = mysql_query($query);

// Test to make sure query worked
if(!$result) die("Query didn't work. " . mysql_error());

// Get the user ID
$this->userID = mysql_insert_id();

// Close database connection
mysql_close($dbLink);

// Assign the values to the data members
$this->userName = $userName;
$this->userPassword = $userPassword;
} // End registerUser()

function verifyPassword() {
// Remember, by the time this method is called, your main script will have already
// put the userName and userPassword variables equal to the ones the user typed in

// Connect to database
$dbLink = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
if(!$dbLink) die("Could not connect to database. " . mysql_error());

// Select database
mysql_select_db($this->dbName);

// Get data
$query = "select userPassword from $this->dbUserTable where userName = \"$this->userName\"";
$result = mysql_query($query);

// Test to make sure query worked
if(!$result) die("Query didn't work. " . mysql_error());

// Get the password from the database
$actualPassword = mysql_result($result, 0);

// Verify that they match
if(!($actualPassword == $this->userPassword)) die("Incorrect Password.");

// Close database connection
mysql_close($dbLink);
} // End verifyPassword()

function changePassword($newPassword) {
// This function assumes you've already verified that the user has
// permission to change the password - it recieves the new password
// as an argument, with the old password already registered in $userPassword

// Connect to database
$dbLink = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
if(!$dbLink) die("Could not connect to database. " . mysql_error());

// Select database
mysql_select_db($this->dbName);

// Get data
$query = "update $this->dbUserTable set userPassword = \"$newPassword\" where userName = \"$this->userName\"";
$result = mysql_query($query);

// Test to make sure query worked
if(!$result) die("Query didn't work. " . mysql_error());

// It worked, so update the password stored in the object
$this->userPassword = $newPassword;

// Close database connection
mysql_close($dbLink);
} // End changePassword()

function displayUserInfo() {
echo '<b>User ID: </b>' . $this->userID . '<br>';
echo '<b>User Name: </b>' . $this->userName . '<br>';
echo '<b>User Password: </b>' . $this->userPassword . '<br>';
} // End displayUserInfo()

} // End User class definition
?>

Examples Using the User Class

Register Form

<!-- registerForm.html -->

<form method="post" action="processRegister.php">
User Name: <input type="text" name="userName" maxlength="32"><br>
Password: <input type="password" name="userPassword" maxlength="32"><br>
<input type="submit">
</form>

<!-- End registerForm.html -->

processRegister.php

<?
// processRegister.php
//////////////////////

// First include the class definition
include('UserClass.php');

// Next, create an instance of the class
$newUser = new User;

// Call the registerUser() method, passing in the required variables
$newUser->registerUser($userName, $userPassword);

// If it was an error, the class will kill the script, if not, it will reach this point
$newUser->displayUserInfo();
?>

-

Change Password Form

<!-- passwordForm.html -->

<form method="post" action="processPassword.php">
User Name: <input type="text" name="userName" maxlength="32"><br>
Old Password: <input type="password" name="userPassword" maxlength="32"><br>
New Password: <input type="password" name="newPassword" maxlength="32"><br>
<input type="submit">
</form>

<!-- End passwordForm.html -->

processpassword.php

<?
// processPassword.php
//////////////////////

// First include the class definition
include('UserClass.php');

// Next, create an instance of the class
$myUser = new User;

// Register the variables with the object
$myUser->userName = $userName;
$myUser->userPassword = $userPassword;

// Verify the password is correct
$myUser->verifyPassword();

// Change the password
$myUser->changePassword($newPassword);

// If it was an error, the class will kill the script, if not, it will reach this point
$myUser->displayUserInfo();
?>

PHP Object Oriented Programming: Simple User Class Methods is a post from: Silenthinker

HTML Code

<ul id="sddm">
    <li><a href="#"
        onmouseover="mopen('m1')"
        onmouseout="mclosetime()">Home</a>
        <div id="m1"
            onmouseover="mcancelclosetime()"
            onmouseout="mclosetime()">
        <a href="#">HTML Drop Down</a>
        <a href="#">DHTML Menu</a>
        <a href="#">JavaScript DropDown</a>
        <a href="#">Cascading Menu</a>
        <a href="#">CSS Horizontal Menu</a>
        </div>
    </li>
    <li><a href="#"
        onmouseover="mopen('m2')"
        onmouseout="mclosetime()">Download</a>
        <div id="m2"
            onmouseover="mcancelclosetime()"
            onmouseout="mclosetime()">
        <a href="#">ASP Dropdown</a>
        <a href="#">Pulldown menu</a>
        <a href="#">AJAX Drop Submenu</a>
        <a href="#">DIV Cascading Menu</a>
        </div>
    </li>
    <li><a href="#">Order</a></li>
    <li><a href="#">Help</a></li>
    <li><a href="#">Contact</a></li>
</ul>
<div style="clear:both"></div>

CSS Code

#sddm {
	margin: 0;
	padding: 0;
	z-index: 30
}

#sddm li {
	margin: 0;
	padding: 0;
	list-style: none;
	float: left;
	font: bold 11px arial
}

#sddm li a {
	display: block;
	margin: 0 1px 0 0;
	padding: 4px 10px;
	width: 60px;
	background: #5970B2;
	color: #FFF;
	text-align: center;
	text-decoration: none
}

#sddm li a:hover {
	background: #49A3FF
}

#sddm div {
	position: absolute;
	visibility: hidden;
	margin: 0;
	padding: 0;
	background: #EAEBD8;
	border: 1px solid #5970B2
}

	#sddm div a {
		position: relative;
		display: block;
		margin: 0;
		padding: 5px 10px;
		width: auto;
		white-space: nowrap;
		text-align: left;
		text-decoration: none;
		background: #EAEBD8;
		color: #2875DE;
		font: 11px arial
	}

	#sddm div a:hover	{
		background: #49A3FF;
		color: #FFF
	}

JavaScript Code

var timeout	= 500;
var closetimer	= 0;
var ddmenuitem	= 0;

// open hidden layer
function mopen(id)
{
	// cancel close timer
	mcancelclosetime();

	// close old layer
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';

	// get new layer and show it
	ddmenuitem = document.getElementById(id);
	ddmenuitem.style.visibility = 'visible';

}
// close showed layer
function mclose()
{
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';
}

// go close timer
function mclosetime()
{
	closetimer = window.setTimeout(mclose, timeout);
}

// cancel close timer
function mcancelclosetime()
{
	if(closetimer)
	{
		window.clearTimeout(closetimer);
		closetimer = null;
	}
}

// close layer when click-out
document.onclick = mclose;

Simple Drop Down Menu is a post from: Silenthinker

I just start using WAMP (http://www.wampserver.com/en/download.php) and try to learn how to import  .sql file into a database in WAMP environment using command line.

After googling in the internet, I found the way as the following:

1. After you have installed the WAMP, go run the cmd (DOS) and get into the mysql folder, for example:

C:\>cd C:\wamp\bin\mysql\mysql5.1.32\bin

2. Then use this command to fire up MySQL

C:\wamp\bin\mysql\mysql5.1.32\bin>mysql.exe -use databasename -u username -p optional_password

This line basically connects you to the mysql database of your choice.

3. To make things easier, copy the SQL file into the same folder where the mysql.exe file is located. And then run this

mysql> source myfilename.sql;

This should works then!

How to Import MySQL File Using Command Line in WAMP is a post from: Silenthinker

If you ever encounter problem where your website can’t display the unicode character properly even you have added <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ /> in your html files, please try to add following line to your htaccess.

AddType application/x-httpd-php .html

This should work then.

How to solve website encoding problem for html? is a post from: Silenthinker

Redirects all files that end in .html to be served from filename.php  so it looks like all your pages are .html but really they are .php

Options +FollowSymLinks
RewriteEngine On
RewriteBase /
RewriteRule ^(.*)\.html$ $1.php [R=301,L]

How to internal redirect .php files to .html files? is a post from: Silenthinker