Load the MYSQL data into combo box element

The data from another table is used with HTML combo control, can maintain the accuracy of the database as well as relationship with them are verified with no objections.

my new code blocks will release on future in complete manner. Here are the few blocks only that can help for anyone with combo box control within form tag. ------------------------------
//Here is the place for connection with MYSQL

// Write out our query.
$query = "SELECT username FROM users";
// Execute it, or return the error message if there's a problem.
$result = mysql_query($query) or die(mysql_error());

CSS interactive navigation menu...

For the DHTML Designing, we can achieve more effects with CSS. They have provided amazing functionality with designing objects in the Web site and it is getting rich and professional looking.

Here are the example coding of HTML.

The style sheet is looking like this.

ul.navigation
{
list-style:none; /* this line will remove any kind of bullet from the menu */
width: 160px; /* sets the menu width */
margin:0;
padding:0;
}

#menu a
{
display: block; /* this is a very important property here and it controls the way the menu elements are displayed - like block-level elements */
padding: 5px 3px 5px 10px; /* sets the padding properties */
font-weight:bold; /* sets the font weight */
background-color: #833331; /* sets the color of the background */
border-top: 1px solid #efefef; /* this code sets the line between the menu items */
}

#menu a:link
{
color: #efefef; /* sets the font color */
text-decoration: none;
}

#menu a:visited
{
color: #efefef;
text-decoration: none;
}

#menu a:hover
{
background:#100008 url(menu-arrow.gif) no-repeat left center; /* when the cursor is over, in the left side of the menu item background it will be display the arrow.gif picture */
text-decoration: underline;
text-indent:15px; /* this line of code move the text 15 px to the right */
}

#menu a:active
{
color: #efefef;
text-decoration: none;
}

Logout script in PHP 5...

Have set them all with Session variables in php and maintain the 100% security in the entire web site effectively.

here are the example code blocks for checking the user table in mysql database.

session_start();

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="lib_db"; // Database name
$tbl_name="members"; // Table name=

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and

password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
}
?>

I have verified the log-out script also as follows.

session_start();
session_destroy();
header("location:main_login.php");
?>

How display Log-in success message:
 
// Check if session is not registered , redirect back to main page.
// Put this code in first line of web page.
session_start();

if(!session_is_registered($_SESSION['myusername'])){
header("location:main_login.php");
}
?>;

Login Successful
session_start();
//echo $_SESSION['myusername'];
//echo $_SESSION['mypassword'];
?>

Table schema has been modified.

I have changed some little bit of Loan table as follows.

Here are code blocks of them.

CREATE TABLE Loans
(
LoanID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(LoanID),
BorrowerID int,
BookID int,
LoanDate date
);

CD Cover Design for Social Night of the RUSL

My last CD Cover for Social Night of the Rajarata University Of Sri Lanka.
This is 1st Draft Image.

Social network promotion

After Convert to vintage effect with Photoshop 7.0

This is the Original Image which I have selected.

Cargills Ceylon Ltd. Presentation Background Design

Monthly Tution Card example

with Photoshop CS3

Use Hidden field in HTML to navigate the information.

Here are some code blocks to navigate the ID value for updating the mysql query. But We can use the PHP session also with maximum performance and hihg reusable compatibility.

Library Management System in web Server

source web site:
http://www.picnicpt-h.schools.nsw.edu.au/Faculty_Webs/TAS/IT/year12/InfoSysDB/2_3.htm
this database is refer with Library Management System.