Wall ready for demonstration of BEST (pvt) Ltd.

Mean by showing the entire path for the students with variety of choices. I feel them which has the powerful tools to encourage the nation with knowledge society. They are the BEST Team in competitive market.

  

code for Check if a table exists in MYSQL.

use this command:
mysql> show tables like 'your_table_name';

in your php script you can check:
if(row_count==1)
/* then table exists; */

You can also try .

SHOW TABLES;

or

SHOW TABLES 'your_table_name';

For checking DataBases:

SHOW DATABASES;

or

SHOW DATABASES 'your_db_name';

Getting mechine ID...!

Problem Description:

In order to activate or get passcodes for my license, I must provide a Host ID or Machine ID.

Solution:
When a license file is generated for a specific computer, it is locked to a number that is unique to that machine. For some UNIX machines, the 32-bit hostid is used. For Linux, Mac, and Windows machines, the ethernet (MAC) address is used. Optionally, on Windows computers, the IP Address can also be used.
 
Instructions for finding your Host ID or Machine ID:

Windows® (all)
For standalone licenses (including the Student version), the Host ID can be

1. either the volume serial number of the C:\ drive (Option 1), or 
2. the MAC Address (Physical Address) of the first Ethernet adapter (Option 2).For network licenses, the Host ID can be the MAC Address (Physical Address) of the first Ethernet adapter (Option 2) or 
3. the IP Address of the first Ethernet adapter (Option 3).

Option 1: Volume Serial Number (Standalone licenses & Student Version only)
To obtain the Volume Serial Number, open a Command Prompt window, and run the command:

vol c:

Option 2: MAC Address (Physical Address, All licenses)
To obtain the MAC Address, open a Command Prompt window, and run the command:

getmac

Option 3: IP Address (Network licenses only)
To obtain the IP address, open a Command Prompt window, and run the command:

ipconfig

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
);