PHP,CSS,JQUERY,HTML tips for beginners

Email Activation For Registration Forms

2011-05-16T00:23:00.000-07:00

Registration page:

<html>
<body>
<form action="verify.php" method="post" name="register">
Username: <input type="text" name="username" />
Password: <input type="text" name="password" />
Email: <input type="text" name="email" />
<input type="submit" />
</form>
</body>

</html>

Verifying in php:

verify.php

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());

mysql_select_db("test") or die(mysql_error());

if ($_POST['form_submitted'] == '1') {
##User is registering, insert data until we can activate it

$activationKey = mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand();
$username = mysql_real_escape_string($_POST[username]);
$password = mysql_real_escape_string($_POST[password]);

$email = mysql_real_escape_string($_POST[email]);

$sql="INSERT INTO users (username, password, email, activationkey, status) VALUES ('$username', '$password', '$email', '$activationKey', 'verify')";

if (!mysql_query($sql))

{

die('Error: ' . mysql_error());

}

echo "An email has been sent to $_POST[email] with an activation key. Please check your mail to complete registration.";

##Send activation Email

$to = $_POST[email];

$subject = " YOURWEBSITE.com Registration";

$message = "Welcome to our website!\r\rYou, or someone using your email address, has completed registration at YOURWEBSITE.com. You can complete registration by clicking the following link:\rhttp://www.YOURWEBSITE.com/verify.php?$activationKey\r\rIf this is an error, ignore this email and you will be removed from our mailing list.\r\rRegards,\ YOURWEBSITE.com Team";

$headers = 'From: noreply@ YOURWEBSITE.com' . "\r\n" .

'Reply-To: noreply@ YOURWEBSITE.com' . "\r\n" .

'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

} else {

##User isn't registering, check verify code and change activation code to null, status to activated on success

$queryString = $_SERVER['QUERY_STRING'];

$query = "SELECT * FROM users";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){

if ($queryString == $row["activationkey"]){

echo "Congratulations!" . $row["username"] . " is now the proud new owner of an YOURWEBSITE.com account.";

$sql="UPDATE users SET activationkey = '', status='activated' WHERE (id = $row[id])";

if (!mysql_query($sql))

{

die('Error: ' . mysql_error());

}

}

}

}
?>

Mail script for user & admin at a time

2011-05-15T20:53:00.001-07:00

<?php

$yourname = $_POST['yourname'];
$subject = $_POST['subject'];
$email =$_POST['email'];
$comments = $_POST['comments'];
$package = $_POST['package'];
$price= $_POST['price'];

$to="rmonicse@gmail.com";

$subject = "Package Order";

$message = $package."\n".$price."\n".$yourname."\n".$subject."\n".$email."\n".$comments;

$headers = 'From: UPTREND TECHNOLOGIES LTD@ http://www.uptrendgroupbd.com' . "\r\n" .

'Reply-To: noReply@ http://www.uptrendgroupbd.com' . "\r\n" .

'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

$to=$email;
$subject = "Package Ordering Confirmation";
$message ="Thanks for ordering.We wil contact as soon as possible";
$headers = 'From: UPTREND TECHNOLOGIES LTD@ http://www.uptrendgroupbd.com' . "\r\n" .

'Reply-To: noReply@ http://www.uptrendgroupbd.com' . "\r\n" .

'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);
<script>
window.alert('message') ;
</script>
header("Location: http://www.uptrendgroupbd.com/uptrendsoft");
?>

Master Page concept using jquery

2011-05-09T20:59:00.000-07:00

Script:


<script type="text/javascript">
$().ready(function() {
  
  $('.unique_id').click(function(e){
    var segment =  $(this).attr('segment');
       $('.content_text').hide();

    $.ajax({
      url: segment+".html",
      dataType:  "text",
      success: function(data){
          $('.content_text').html(data);
       eval($(data).filter('script'));
       $('.content_text').fadeIn('slow');       
      }
    });
      e.preventDefault();
  }); 
 });
 var $VisualLightBoxParams$ = {autoPlay:true,borderSize:21,enableSlideshow:true,overlayOpacity:0.4,startZoom:true};
 
</script>

we can apply the class named unique_id in any div. Such as example


<div id="navcontainer">
       <ul id="navlist">
         <li id="active"><a href="index.html" class="panel_text">Home</a></li>
         <li class="green"><a href="#"  class="unique_id panel_text" segment="convention-program">Convention Program</a></li>
         <li> <a href="spech_of_delegates.html" class="panel_text unique_id"  segment="spech_of_delegates">Speech of all delegates.</a></li>
         <li><a href="#" class="panel_text unique_id"  segment="elected_ executive_body_ of_ ieb">Elected Executive body of IEB</a></li>
         <li><a href="time_series_list.html" class="unique_id panel_text" segment="time_series_list" >Time-series list of Presidents </a></li>
         <li><a href="agm_reports.html" class="unique_id panel_text" segment="agm_reports" >AGM Reports</a></li>
         <li><a href="#" class="panel_text">Memorial Lectures</a></li>
         <li><a href="bye-laws.html" class="unique_id panel_text" segment="bye-laws" >IEB Constitution/Bye-laws.</a></li>
         <li><a href="#" class="panel_text">Prof. Institutions's Introduction</a></li>
         <li><a href="#" class="panel_text">Member Database</a> </li>
         <li><a href="#" class="panel_text">Fellow Database</a> </li>
         <li><a href="#" class="panel_text">IEB welfare scheme  </a></li>
         <li> <a href="#" class="panel_text">IEB Publications </a></li>
         <li> <a href="gallery.html" class="unique_id panel_text" segment="gallery" >Photo Gallery  </a></li>
         <li> <a href="gallery.html" class="unique_id panel_text" segment="Advertisements of the Sponsors." >Advertisements of the Sponsors.  </a></li>
       </ul>
        </div>

The sub page : its depends on content_text class.

<div class="content_text">
<h1> Bye-laws</h1>
<p class="content_text_shape">

<iframe src="Binder1.pdf" style="width:600px; height:500px;" frameborder="0"></iframe>

</p>
</div>

<div style="clear:both;"></div>
</div>

Good design website

2010-12-01T23:31:00.000-08:00

http://www.wts.edu/
http://www.uwm.edu.pl/
http://www.uscupstate.edu/
http://www.bcu.ac.uk/
http://www.css.edu/
http://aut.ac.ir/www/aut/main/
http://www.dote.hu/i
http://www.francis.edu/

http://www.leadertech.com/confirmation_examples
http://www.uoit.ca/
http://www.nsula.edu/
http://www.aubg.bg/
http://www.longwood.edu/
http://www.udesa.edu.ar/
http://www.cabrillo.edu/
http://www.edinboro.edu/
http://www.mc.edu/
http://www.georgefox.edu/
http://www.drexelmed.edu/
http://www.ektf.hu/ujweb/index_en.php
http://top-seo-sem-tips.blogspot.com/
http://www.pol.lublin.pl/
http://www.aum.ed
http://www.iue.edu/
http://www.smsu.edu/
http://www.emu.edu/
http://www.ecsu.edu/

Snag IT:
SnagIT : 7.2
User Name: Mehede
Software Key:0EE433B1DCDEA5766F

SnagIT : 10
ZEN5H-24LZK-TNYET-2EGKJ-MMCE4

Html practice

2010-09-08T00:23:00.000-07:00

css:

.clr { clear:both; }
#wrap { width:860px; margin:0 auto; }
#curvy-container { width:253px; float:left; margin-left:10px; margin-top:20px; }
.curvy-container-top {
height:47px;
width:253px;
margin:0;
padding:0;
float:left;
clear:both;
background-image: url(images/help-box_01.jpg);
background-position:top;
background-repeat:no-repeat;
}
.curvy-container-mid { width:253px; background:url(images/img-mid-curvy.jpg) repeat-y; }
.curvy-container-mid ul { list-style:none; margin:0 0 0 10px; padding:0;}
.curvy-container-mid ul li { font-family:Arial, Helvetica, sans-serif; font-size:13px;margin:0;padding:3px;font-weight:normal; }
.curvy-container-mid ul li a{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;
color:#000000;
text-decoration:none;}

.curvy-container-mid ul li a:hover{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;
color:#0099FF;
text-decoration:none;}

.curvy-container-bottom {
height:25px;
background-image: url(images/img-bottom-curvy.jpg);
background-position:top;
background-repeat:no-repeat;
}
.span_text
{
padding-left:5px;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;

}
.span_text_2

{
font-size:12px;
font-family:Arial, Helvetica, sans-serif;
margin-left:15px;
text-decoration:none;

}
.span_text_3
{
color: #666666;
margin-left:70px;
margin-top:2px;

}
.span_text_more
{

font-family:Arial, Helvetica, sans-serif;
font-size:13px;
color: #0099FF;
text-decoration:none;

}
.break a
{
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#000000;
text-decoration:none;
font-weight:bold;
margin-left:20px;

}
.break a:hover
{
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color: #0099FF;
text-decoration:none;
font-weight:bold;

}

.arrow
{
padding-left:30px;
}
.box_span_text
{
width:253px;
font-size:15px;
font-family:"Trebuchet MS";
font-weight:bold;
color: #FFFFFF;
text-align:center;
line-height:40px;
margin-top:5px;

}

Html:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>free</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>

 <div id="wrap">
     <div id="curvy-container">
         <div class="curvy-container-top">
               <div class="box_span_text">Common Sections</div>
            </div>
            <div class="curvy-container-mid">            
              <ul>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Home</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>About Us</strong></a>
                     </span>
                   </li> 
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Sromobazar Solution</strong></a>
                     </span>
                   </li> 
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Contact Us</strong></a>
                     </span>
                   </li> 
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Overseas Education</strong></a>
                     </span>
                   </li> 
                    <div class="span_text_2">
                            <p style="margin-left:15px;"><strong class="span_text_more">Countrywise Universities List:</strong></p>
                            <ul>
                                 <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=1" >Asia</a></span>
                                <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a  href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=2">India</a></li>
                            </ul>
                                        
                    </div>
                    <div class="span_text_2">
                             <ul>
                                     <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=28" >Japan</a></span>
                                    
                                      
                                         
                                     <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2"> University Of Tokyo</a></li>
                                     <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2">University Of Tokyo</a></li>
                                     
                                     <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2"> University Of Tokyo</a></li>
                             </ul>
                    </div>
                    <div class="span_text_2">
                               <ul>
                                     <span class="break"><a href="#" >Africa</a></span>
                                     <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=140">South Africa</a></li>
                              </ul>
                </div>
                      <div class="span_text_2">
                                <ul>
                                     <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=2">North America</a></span>
                                    <li class="span_text_3" > <img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=104"> Unitied States</a></li>
                                </ul>
                </div>
                       <div class="span_text_2">
                                <ul>
                                     <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=96">Canada</a></span>
                                    <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2v2&ownerId=x2"> Mcgrill University</a></li>
                                </ul>
                </div>
                                
                                <div class="span_text_2">
                                        <ul>
                                             <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=3">South America</a></span>
                                            <li class="span_text_3" > <img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=113"> Argentina</a></li>
                                        </ul>
                                </div>
                                <div class="span_text_2">
                                        <ul>
                                             <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=4">Europe</a></span>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=90"> United Kingdom</a></li>
                                        </ul>
                                </div>
                <div class="span_text_2">
                      <ul>
                              <span class="break"><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=6">Australia</a></span>
                              <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=124">Australia</a></li>
                              <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=126">Newzealan</a></li>
                          </ul>
                                </div> 
                   </ul>
            </div>
            <div class="curvy-container-bottom" >
            
            </div>
        </div>
        <div id="curvy-container">
         <div class="curvy-container-top">
              <div class="box_span_text">Account Login Sections</div>
            </div>
            <div class="curvy-container-mid">
             <ul>
                  <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Create Account</strong></a>
                     </span>
                   </li>
                   
                   
                     <div>
                                        <ul>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=41">Employeer</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=11">Job seeker</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=21">Student</a></li>
                                           <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=51">University Admin</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=13">Corporate Group</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=61">University Agency</a></li>

                                        </ul>
                        </div>
                        
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Sign In</strong></a>
                     </span>
                   </li> 
                     <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Advance Search</strong></a>
                     </span>
                   </li>  
                     <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Job Listing</strong></a>
                     </span>
                   </li>  
                     <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Category Wise Job list</strong></a>
                     </span>
                   </li> 
                        <div class="span_text_2">
                                        <ul class="span_text_3">
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=job-listing&ID=42&isBidable=1">Accounts/Finance</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=job-listing&ID=57&isBidable=1">IT/Telecommunication</a></li>
                                        </ul>
                         </div>  
                     <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Employee Listing</strong></a>
                     </span>
                   </li> 
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Job seeker Listing</strong></a>
                     </span>
                   </li>     
                   
                </ul>
            </div>
            <div class="curvy-container-bottom"></div>
            
             <br />
             <div class="curvy-container-top">
               <div class="box_span_text">Common Sections</div>
            </div>
            <div class="curvy-container-mid">
             <ul>
                  <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>List of Student</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Universities</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>List of Embassy</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Get Widges</strong></a>
                     </span>
                   </li>    
                   
                </ul>
            </div>
            <div class="curvy-container-bottom"></div>
        </div>
        
        
        
        
        
  <!--help-->       
        <div id="curvy-container">
         <div class="curvy-container-top">
             <div class="box_span_text">Help</div>
            </div>
            <div class="curvy-container-mid">
             <ul>
                  <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Help and Support</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>FAQ</strong></a>
                     </span>
                   </li> 
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Payment Process</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>FAQ</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Searching For jobs</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Registering</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>For Corporate Group</strong></a>
                     </span>
                   </li>
                   <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Keeping Your details Uptodate</strong></a>
                     </span>
                   </li> 
                    <li> 
                    <img src="images/arrow2.jpg" />
                     <span class="span_text">
                     <a href="http://www.sromobazar.com/index.php"><strong>Technical And Other Help Issue</strong></a>
                     </span>
                   </li> 
                   
                </ul>
            </div>
            <div class="curvy-container-bottom"></div>
        </div>
    </div>
    
    
 </body>
</html>

HTML

2010-08-24T02:57:00.000-07:00

Css:
@charset "utf-8";
/* CSS Document */

.main_container
{
width:835px;
margin: 0 auto;

/* Do rounding (native in Firefox and Safari) */
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
-khtml-border-radius: 5px;
border:1px solid #0099FF;
padding:10px;
height:auto;

}
.sitemap_left_container
{
width:250px;
float:left;
padding:0px;
margin-left:10px;
height:auto;
}
.sitemap_content
{
width:250px;
-moz-border-radius:5px;
border-radius:5px;
-webkit-border-radius:5px;
border: 1px solid #999999;
margin: 0;
padding:0;
background: url(images/top_bg.jpg) repeat-x top;
background-color:#ffffff;
}
.sitemap_content h1
{
font-size:15px;
font-family:"Trebuchet MS";
font-weight:bold;
color: #FFFFFF;
line-height:20px;
text-align:center;
margin-top:7px;

}
.sitemap_content ul
{
width:auto;
padding:5px;
margin-top:8px;
margin-left:8px;
}
.sitemap_content li
{
width:auto;
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;
margin:0;
padding:0;
font-weight:normal;
margin-top:10px;

}
.sitemap_content li a
{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;
color:#000000;
text-decoration:none;
}
.sitemap_content li a:hover
{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;
color: #0099FF;
text-decoration:none;
}
.sitemap_content2 a
{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#000000;
text-decoration:none;
font-weight:bold;
}
.sitemap_content2 a:hover
{
list-style:none;
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color: #0099FF;
text-decoration:none;
font-weight:bold;
}
.span_text
{
padding-left:5px;
font-family:Arial, Helvetica, sans-serif;
font-size:13px;

}
.span_text_2
{padding-top:3px;
font-size:12px;
font-family:Arial, Helvetica, sans-serif;
margin-left:15px;

}
.span_text_3
{
color: #666666;
margin-left:60px;

}
.span_text_more
{
padding-left:15px;
padding-top:3px;
font-size:12px;
font-family:Arial, Helvetica, sans-serif;

}
.sitemap_middle_container
{
width:250px;
float:left;
padding:0px;
margin-left:10px;
height:auto;

}
.sitemap_right_container
{
width:250px;
float:left;
padding:0px;
margin-left:10px;
height:auto;

}
.break
{
font-family:Arial, Helvetica, sans-serif;
font-size:12px;
color:#000000;
text-decoration:none;
font-weight:bold;

}

.arrow
{
padding-left:10px;
}
HTML


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="sitemap.css" rel="stylesheet" type="text/css" />

<script src="js/curvycorners.src.js" type="text/javascript">
</script>

</head>

<body>
 <div class="main_container">
   <div class="sitemap_left_container">
          <div class="sitemap_content">
                 <h1>Common Sections</h1>
                     <ul>
                     
                        <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php"><strong>Home</strong></a></span></li>
                        <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-about-us.php"><Strong>About Us</Strong></a></span></li>
                        <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-sromobazar-solution.php"><strong>Sromobazar Solution</strong></a></span></li>
                        <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-contact-us.php"><strong>Contact Us</strong></a></span></li>
                        <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-overseas-education.php"><strong>Overseas Education</strong></a></span></li>
                              <div class="span_text_2">
                                        <p style="margin-left:15px;"><strong>Countrywise Universities List:</strong></p>
                                        <ul>
                                         <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=1"><span class="break">Asia</span></a>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a  href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=2">India</a></li>
                                        </ul>
                                </div>
                                <div class="span_text_2">
                                        <ul><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=28"><span class="break">Japan</span></a>
                                          <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2">University Of Tokyo</a>
</li>
                                          <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2"> University Of Tokyo</a></li>
                                          <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2z2&ownerId=x2">University Of Tokyo</a></li>
                                        </ul>
                                            
                       </div>
        <div class="span_text_2">
                                        <ul>
                                            <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=5"><span class="break">Africa</span></a>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=140">South Africa</a></li>
                                        </ul>
                                </div>
                                 <div class="span_text_2">
                                        <ul>
                                            <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=2"><span class="break">North America</span></a>
                                            <li class="span_text_3" > <img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=104"> Unitied States</a></li>
                                        </ul>
                                </div>
                                <div class="span_text_2">
                                        <ul>
                                            <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=96"><span class="break">Canada</span></a>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-detail&ID=w2v2v2&ownerId=x2"> Mcgrill University</a></li>
                                        </ul>
                                </div>
                                
                                <div class="span_text_2">
                                        <ul>
                                            <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=3"><span class="break">South America</span></a>
                                            <li class="span_text_3" > <img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=113"> Argentina</a></li>
                                        </ul>
                                </div>
                                <div class="span_text_2">
                                        <ul>
                                            <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=4"><span class="break">Europe</span></a>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=90"> United Kingdom</a></li>
                                        </ul>
                                </div>
                                <div class="span_text_2">
                                        <ul>
                                       <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=continent-university&continent_id=6"><span class="break">Australia</span></a>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=124">Australia</a></li>
                                            <li class="span_text_3" ><img src="images/arrow.jpg" class="arrow" /><a href="http://www.sromobazar.com/index.php?skin=default&area=student&action=university-listing&country_id=126">Newzealand</a></li>
                                        </ul>
                                </div>
                     </ul>
                </div>
        </div>
        <div class="sitemap_middle_container">
          <div class="sitemap_content">
                <h1>Account Login Section</h1>
                 <ul>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-user-profile-creator.php"><strong>Create Account</strong></a></span></li>
                              <div>
                                        <ul>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=41">Employeer</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=11">Job seeker</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=21">Student</a></li>
                                           <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=51">University Admin</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=13">Corporate Group</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=user-profile-creator&userTypeID=61">University Agency</a></li>

                                        </ul>
                                </div>
                                
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-user-login.php"><strong>Sign In</strong></a></span></li>
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-advance-search-form.php"><strong>Advance Search</strong></a></span></li>
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=job-listing&recent=yes"><strong>Job Listing</strong></a></span></li>
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="#"><strong>Category Wise Job list</strong></a></span></li>
                                <div class="span_text_2">
                                        <ul class="span_text_3">
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=job-listing&ID=42&isBidable=1">Accounts/Finance</a></li>
                                            <li class="span_text_3"><img src="images/arrow.jpg" class="arrow" /> <a href="http://www.sromobazar.com/index.php?skin=default&area=online&action=job-listing&ID=57&isBidable=1">IT/Telecommunication</a></li>
                                        </ul>
                                </div>
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=employeer&action=employer-listing"><strong>Employee Listing</strong></a></span></li>
                              <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=jobseeker&action=jobseeker-listing"><strong>Job seeker Listing</strong></a></span></li>  
                     </ul> 
                     <br /> 
                   
               </div>
                <br /> 
                <br />  
                
                <div class="sitemap_content">
                 <h1>Other Links</h1>
                    <ul>
                            <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-student-listing.php"><strong>List of Student</strong></a></span></li>
                            <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-university-listing.php"><strong>Universities</strong></a></span></li>
                            <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-embassy-listing.php"><strong>List of Embassy</strong></a></span></li>
                            <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-widget-listing.php"><strong>Get Widges</strong></a></span></li>
                             <br /> 
                             <br /> 
                             <br />  
                             <br />       
                    </ul>
                    
                </div>
                
        </div>
         <div class="sitemap_right_container">
           <div class="sitemap_content">
                <h1>Help</h1>
                 <ul>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/worldwide-job-and-education-help.php"><strong>Help and Support</strong></a></span></li>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=faq"><strong>FAQ</strong></a></span></li>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=payment-process"><strong>Payment Process</strong></a></span></li>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=help-searching-for-jobs"><strong>Searching For jobs</strong></a></span></li>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=registering"><strong>Registering</strong></a></span></li> 
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=for-corporate-group"><strong>For Corporate Group</strong></a></span></li>
                     <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=keeping-your-details-uptodate"><strong>Keeping Your details Uptodate</strong></a></span></li>  
                      <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.sromobazar.com/index.php?skin=default&area=help&action=technical-and-other-help-issues"><strong>Technical And Other Help Issues</strong></a></span></li>      
                  </ul> 
                  <br /> 
                  <br /> 
                  <br /> 
                  <br /> 
                </div>
                <br /> 
                 
                 
                <div class="sitemap_content">
                        <h1>Sister Sites</h1>
                         <ul>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.askbangladesh.com/"><strong>Ask Banglades.com Limited</strong></a></span></li>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.itbidding.com/"><strong>itbidding.com</strong></a></span></li>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.loginbd.com/"><strong>loginbd.com</strong></a></span></li>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.itreel.com/"><strong>itReel.com</strong></a></span></li> 
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.askbazar.com/"><strong>Askbazar.com</strong></a></span></li>
                             <li><img src="images/arrow2.jpg" /><span class="span_text"><a href="http://www.dressbazar.com/"><strong>Dressbazar.com</strong></a></span></li> 
                             <br />
                             <br />
                             <br />
                             <br /> 
                             <br />
                             <br />
                             <br /> 
                             <br />  
                             <br /> 
                            
                        </ul>  
             </div>
        </div>
 <div style="clear:both;"></div>       
 </div>

</body>
</html>

psd

2010-08-23T09:57:00.000-07:00

arrow:

hover effect using css & html

2010-08-18T01:00:00.000-07:00


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
.btnContinue {
 width: 120px;
 height: 64px;
 line-height:64px;
 text-align:center;
 font-family:Arial, Helvetica, sans-serif;
 font-size:13px;
 color:#FFFFFF;
 display: inline-block;
 text-decoration: none;
 background-repeat:no-repeat;
 background-image: url(images/pp.jpg);  
 margin:0;
 padding:0;
 text-decoration:none;
}

.btnContinue:hover {
background-position:bottom right;
font-family:Arial, Helvetica, sans-serif;
 font-size:13px;
 color:#000000;
}
.btnContinue1 {
 width: 145px;
 height: 64px;
 line-height:64px;
 text-align:center;
 display: inline-block;
 font-size: 10px;
 text-decoration: none;
 background-repeat:no-repeat;
 background-image: url(images/pp1.jpg);  
 margin:0;
 padding:0;
 text-decoration:underline;
}

.btnContinue1:hover {
background-position:bottom right;
}

</style>
</head>
<body style="width:1011px; border:1px solid #000000; height:67px; padding:0px; margin:0px;">
            <div style="margin-left:0px; float:left;">
                          <a class="btnContinue" href="http://learnwebdesignonline.com">Home</a>
            </div>

            <div style="margin-left:0px; float:left;">
            <a class="btnContinue" href="http://learnwebdesignonline.com"> </a>
            </div>
            <div style="margin-left:0px; float:left;">
            <a class="btnContinue" href="http://learnwebdesignonline.com"> </a>
            </div>
            <div style="margin-left:0px; float:left;">
            <a class="btnContinue" href="http://learnwebdesignonline.com"> </a>
            </div>

            <div style="margin-left:0px; float:left;">
            <a class="btnContinue" href="http://learnwebdesignonline.com"> </a>
            </div>
            <div style="margin-left:0px; float:left;">
            <a class="btnContinue1" href="http://learnwebdesignonline.com"> </a>
            </div>
              <div style="margin-left:0px; float:left;">
            <a class="btnContinue" href="http://learnwebdesignonline.com"> </a>
            </div>

            <div style="margin-left:0px; float:left;">
            <a class="btnContinue1" href="http://learnwebdesignonline.com"></a>
            </div>
             
            

</body>

</html>

jquery menu

2010-08-17T02:44:00.000-07:00

menu:
http://www.1stwebdesigner.com/resources/36-eye-catching-jquery-navigation-menus/

Rounded corner / Curved corner divs using CSS 3 in all browsers

2010-08-12T22:47:00.000-07:00


<a href="http://www.htmlremix.com/css/curved-corner-border-radius-cross-browser">
Rounded corner / Curved corner divs using CSS 3 in all browsers</a>
<a>

Fireworks & Photoshop online tutorial

2010-08-09T01:44:00.000-07:00

Fireworks & Photoshop online tutorial ::

1.http://www.entheosweb.com/fireworks/transparent_text.asp
2.http://www.vineyardesigns.com/tutorials/photoshop/document.shtml
3.http://www.pxleyes.com/blog/2009/09/20-fireworks-tutorials-for-absolute-beginners/
4.http://www.macronimous.com/resources/creating_image_banners_with_fireworksMX2004.htm
5.http://www.modernmorph.com/tutorials/cat/macromedia-fireworks/file/glossy-text/

html & css (part -2)

2010-08-06T03:03:00.000-07:00

Css page:

/* CSS Document */

.main_container
{
width:1016px;
margin:0 auto;
border:1px dashed #FF0000;

}
.container
{
width:1016px;
background-image: url(images/bg.jpg);
height:200px;

}
.blue_text
{
font-family:Arial, Helvetica, sans-serif;
font-size:25px;
font-weight:bold;
color:#0099CC;
width:450px;
float:left;
border:1px solid #00FFCC;

}
.blue_text_2
{
font-family:Arial, Helvetica, sans-serif;
font-size:25px;
font-weight:bold;
color:#0099CC;
width:450px;
float:left;
border:1px solid #00FFCC;

text-align:right;

}
.text
{
width:700px;
float:left;

padding:10px;
}
.text2
{
width:155px;
height:157px;
float: left;
border:1px solid #000099;
background-image: url(images/mohila.jpg);
background-repeat:no-repeat;

}

.button_container
{
width:1014px;
border:1px dashed #9999FF;
margin:0 auto;
}

.content
{
width:1016px;
border:1px solid #0033CC;
float:left;
}
.box
{
width:225px;
float:left;
border:1px solid #FF0000;
padding:10px;
}
.icon
{
width:37px;
height:47px;
background-repeat:no-repeat;
background-image: url(images/icon.jpg);
margin-left:50px;
}

.icon_text
{
font:"Courier New", Courier, monospace;
color: #009999;
text-align:center;
}

.button
{
width:195px;
height:48px;
line-height:48px;
background-image: url(images/button.jpg);
background-repeat:no-repeat;
text-align:center;
}
Html page:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>


<link href="stylesheet.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div class="main_container">
        <div class="container">
                <div class="blue_text">Rakhi Moni Mitro</div>
                <div class="blue_text_2">Rakhi</div>
                <div class="content">
                            
                            <div class="text">ferlgdrlghtljyg[ljk[ylg ferlgdrlghtljyg[ljk[ylg ferlgdrlghtljyg[ljk[ylg</div>
                            <div class="text2"></div>
                            <div style="clear:both;"></div> 
                </div>
                
           </div>
                
                
                
                
                <div style="clear:both;"></div> 
                </div>
                <div class="button_container">
                            <div class="box">
                                    <div class="icon"></div>
                                     <div class="icon_text">kgdkf hghgjmn mnlmjh</div>
                            </div>
                   <div class="box">
                              <div class="icon"></div>
                                     <div class="icon_text">kgdkf hghgjmn mnlmjh</div>
                            </div>
                            <div class="box">
                                     <div class="icon"></div>
                                     <div class="icon_text">kgdkf hghgjmn mnlmjh</div>
                            </div>
                            <div class="box">
                                     <div class="button">Start Order Now</div>
                            </div>
                    
                <div style="clear:both;"></div> 
                </div>

<div style="clear:both;"></div>          
</div>
</body>
</html>

HTML & CSS practice

2010-08-04T03:29:00.000-07:00




 /* CSS Document */
 
 .content
 {
 width:1014px;
 border:1px solid #0033CC;
 height:250px;
 
 }
 .box
 {
 width:225px;
 height:300px;
 float:left;
 border:1px solid #FF0000;
 padding-top:10px;
 
 
 
 }
 .icon
 {
 width:37px;
 height:47px;
 background-repeat:no-repeat;
 background-image: url(images/icon.jpg);
 }
 
 .button
 {
 width:180px;
 height:50px;
 background-image: url(images/button.jpg);
 background-repeat:no-repeat;
 margin-top:30px;
 }
 .myBox {
 margin: 0 auto;
 border: 0px solid #fff;
 color: #9966CC;
 width: 25%;
 padding: 20px;
 text-align: left;
 background-color: #f00;
 border-top: #FF0000;
 border-bottom:  #FF0000;
 
 border-left: #fff;
 border-right:  #fff;
 float:left;
 margin-left:10px;
 
 /* Do rounding (native in Firefox and Safari) */
 -webkit-border-radius: 20px;
 -moz-border-radius: 20px;
 }
 
 .small_logo
 {
 width:37px;
 height:46px;
 background-repeat:no-repeat;
 background-image: url(images/brwoser.jpg);
 float:left;
 margin-left:5px; 
 }
 
 ul#footerlinks {
 
 float:left;
 
 width:250px
 
 }
 
 #footerlinks li {
 
 color:#666;
 
 display:inline;
 
 list-style-type:none;
 
 font:11px Arial, Helvetica, sans-serif;
 
 }
 
 #footerlinks a {
 
 color:#666;
 
 text-decoration:none;
 
 font:11px Arial, Helvetica, sans-serif;
 
 }
 
 #footerlinks a:link, #navlist a:visited {
 
 color:#666;
 
 text-decoration:none;
 
 font:11px Arial, Helvetica, sans-serif;
 
 }
 
 #footerlinks a:hover {
 
 color:#ff9800;
 
 text-decoration:none;
 
 font:11px Arial, Helvetica, sans-serif;
 
 }

 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<script type="text/JavaScript" src="js/curvycorners.src.js"></script>

</head>

 <body>
  <div class="content">
     
     <div class="box">
     <dd class="icon"></dd></br></br>
     <dd>Send the design</dd></br>
     <dd>send us your design in any common format</dd>
     </div>
     
     <div class="box">
     <dd class="icon"></dd></br></br>
     <dd>Send the design</dd></br>
     <dd>send us your design in
     any common format</dd>
        </div>
      
     <div class="box">
     <dd class="icon"></dd></br></br>
     <dd>Send the design</dd></br>
     <dd>send us your design in any common format</dd>
     </div> 
      
     <div class="box">
     <dd class="icon"></dd></br></br>
     <dd class="button"><span style="line-height:50px; text-align:center; margin-left:70px;">Home</span></dd>
     </div>
  </div>
  <div class="content">
        <div class="myBox">
      <dd>Welcome to Rakhi</dd>
      <dd><h5>{elcome to Rakhi}</h5></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd>Starting form -20$  90$</dd>
      <dd style="text-align:right;">Homepage   Innerpage</dd>
      
           </div>
      
     <div class="myBox">
      <dd>Welcome to Rakhi</dd>
      <dd><h5>{elcome to Rakhi}</h5></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd class="small_logo"></dd>
      <dd>Starting form -20$  90$</dd>
      <dd style="text-align:right;">Homepage   Innerpage</dd>
      
    </div>
    <div class="myBox">
 
    </div>
 
  </div>
  
     <div id="footerlinks">
       <ul>
         <li><a href="index.html" >Home</a> |</li>
    
         <li><a href="about.html">About</a> |</li>
    
          <li><a href="index.html" >Home</a> |</li>
    
         <li><a href="about.html">About</a> |</li>
    
          <li><a href="index.html" >Home</a> |</li>
    
         <li><a href="about.html">About</a> |</li>
    
        </ul>
        </div>
 
  <div class="content">
       <dd class="icon"></dd>
     <dd style="margin-left:5px; float: inherit;">wetreytyikjl</dd>
  </div> 
</body>
</html>

Making hover effect in css & html

2010-08-01T23:29:00.000-07:00

i use two jpg button for this implimentation.

text-align:center;cursor:pointer; cursor:hand;width: 135px; height: 49px;" src="http://4.bp.blogspot.com/_J984QyaybsA/TFZmX0MkQkI/AAAAAAAAAD8/Jgu2eG79FqI/s320/button_hover.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5500696554214015554" />


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>CSS Rollover Trifecta Buttons</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style media="screen" type="text/css">
   /* NAVIGATION BUTTONS */
   .menu {
      height: 44px;
      width: 844px;
   }
   .cssnav {
      position:relative;
      float: left;
      margin: 0; 
      padding: 0;
      font-family: arial, helvetica, sans-serif;
      background: url(images/button.jpg) no-repeat;
      width: 135px;
      height: 49px;
                     overflow:hidden;/* for ie to hide extra height*/
      text-align: center;
      line-height:49px; 
      
   }
   .cssnav a {
     
      color: #000000;
      font-size: 11px;
      width: 135px;
      height: 49px; 
      float: left;
      color: black; 
      text-decoration: none;
      overflow:hidden;/* for ie to hide extra height*/
      text-align: center;
   }
   .cssnav a:hover {
      color: #ffffff;
      text-align: center;
      background-image:url(images/button_hover.jpg);
   }
   

   

   
   /* END OF NAVIGATION */
</style>

<body>

<!--MAIN NAVIGATION START-->
<div class="menu">
<div class="cssnav"><a href="#" title="Search Engine Optimization">Home</a></div>
<div class="cssnav"><a href="#" title="Search Engine Submission">Search Engine Submission</a></div>

<div class="cssnav"><a href="#" title="Website Design">Website Design</a></div>
<div class="cssnav"><a href="#" title="Website Promotion">Website Promotion</a></div>
<div class="cssnav"><a href="#" title="Website Promotion">Website Promotion</a></div>
<div class="cssnav"><a href="#" title="Website Promotion">Website Promotion</a></div>

</div>
<!--MAIN NAVIGATION END-->


</body>
</html>

Rounded corner using html & css (ie6 supported)

2010-07-31T03:45:00.000-07:00


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>curvyCorners Demo 6</title>
<script type="text/JavaScript"  src="curvycorners.src.js"></script>
<style type="text/css">

.myBox {
    margin: 0 auto;
    border: 0px solid #fff;
    color: #9966CC;
    width: 60%;
    padding: 20px;
    text-align: left;
    background-color: #f00;
    border-top: #FF0000;
    border-bottom:  #FF0000;

    border-left: #fff;
    border-right:  #fff;

    /* Do rounding (native in Firefox and Safari) */
    -webkit-border-radius: 20px;
    -moz-border-radius: 20px;
}

html,body{
    height: 100%;
    text-align: center;
    font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
    font-size: 12px;
    margin: 0px;
   
    color:#FA0;
}
.style4 {color: #FF}
</style>
</head>

<body>

    <h1>curvyCorners Demo 6</h1>

    <div class="myBox">

    Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Curabitur mi est, cursus sit amet, pellentesque et, ultricies a, ipsum. Nulla facilisi. Sed quis lacus. Aenean ut risus et lectus blandit gravida. Nam sed nunc. Aliquam non felis non diam aliquam gravida. Phasellus quis sem. Curabitur at velit. Vivamus libero velit, condimentum sit amet, tempus ut, aliquam sit amet, velit. Nunc hendrerit ante. Quisque egestas feugiat erat. Morbi tellus.
    <br /><br />
    Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla ac ante sit amet metus hendrerit euismod. Aenean vestibulum, lectus in eleifend tempor, quam libero iaculis dolor, pellentesque pellentesque lorem nibh ut urna. Nulla rhoncus, ante sit amet tristique interdum, eros nulla nonummy justo, eu dapibus risus quam sit amet metus. Maecenas tristique augue vel enim. Duis blandit euismod pede. Pellentesque facilisis. Fusce dapibus sapien tristique massa. Nunc accumsan. Integer pretium risus et odio. Phasellus tincidunt rhoncus velit. Donec eu neque at massa mollis iaculis. Aliquam pellentesque auctor mi. Cras ante justo, ultricies quis, iaculis eu, tincidunt ac, velit. Etiam nunc erat, tincidunt sit amet, luctus quis, interdum a, nunc. Suspendisse elit.
    <br /><br />
    Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla ac ante sit amet metus hendrerit euismod. Aenean vestibulum, lectus in eleifend tempor, quam libero iaculis dolor, pellentesque pellentesque lorem nibh ut urna. Nulla rhoncus, ante sit amet tristique interdum, eros nulla nonummy justo, eu dapibus risus quam sit amet metus. Maecenas tristique augue vel enim. Duis blandit euismod pede. Pellentesque facilisis. Fusce dapibus sapien tristique massa. Nunc accumsan. Integer pretium risus et odio. Phasellus tincidunt rhoncus velit. Donec eu neque at massa mollis iaculis. Aliquam pellentesque auctor mi. Cras ante justo, ultricies quis, iaculis eu, tincidunt ac, velit. Etiam nunc erat, tincidunt sit amet, luctus quis, interdum a, nunc. Suspendisse elit.

    </div>


    <span class="style4"></span>
</body>
</html>

logo

2010-07-31T03:31:00.000-07:00

Code(KR)

2010-07-29T04:42:00.001-07:00

//for user section view

<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<textarea name="newsletterContent" rows="50" cols="100" style="border:1px solid #a2a2a2;">
<?php if(strstr(html_entity_decode($thisDataPaket['NewsletterContent']), "-->"))
{
echo substr(html_entity_decode($thisDataPaket['NewsletterContent']), strrpos(html_entity_decode($thisDataPaket['NewsletterContent']), "-->")+3);
}
else
{
echo html_entity_decode($thisDataPaket['NewsletterContent']);
}
?>
</textarea>
</td>
<td><?php if($newsletterContenttError) {?><span style='color:red;'>*</span> <?php } else { ?> <span style='color:black;'>*</span><?php } ?></td>
</tr>
</table>

//For insert tinymce data

$newsletterContent = "";
if(!empty($_REQUEST['newsletterContent'])) $newsletterContent = $_REQUEST["newsletterContent"];

if($_REQUEST['newsletterContent'] != "")
{
if(get_magic_quotes_gpc())
{
$newsletterContent = stripslashes($_REQUEST['newsletterContent']);
}
}
$newsletterContent = htmlspecialchars($_REQUEST['newsletterContent']);
$newsletterContent = str_replace("'", "\'", $newsletterContent);

Simple Project(part-3d)

2010-07-05T04:31:00.000-07:00

editMyprofile.php


<?php
include("connect.php");

// get value of id that sent from address bar
$id=$_REQUEST['id'];



// retrive data from database
 $query=mysql_query("select * from create_profile where id='$id'");
$dataPacket=mysql_fetch_array($query);

?>


<form name="userUpdateProfile" method="post" 
action="editProfile_action.php">
<center>
<div ><h3>Create Profile</h3>
            <div>Name:
            <input name="userName"  type="text" value="<?php  echo $dataPacket['userName']; ?>"id="Name"/>*
            </div>
            
            </br>
            <div>Father's Name:
            <input name="userfatherName" type="text" 
value="<?php echo $dataPacket['userfatherName'];?>" id="fatherName">*
            </div>
            
            </br>
            <div>Occupation:
            <input name="userOccupation" type="text" 
value="<?php echo $dataPacket['userOccupation']; ?>" 
id="Occupation">*
            </div>
            
            </br>
            <div>Nationality:
            <input name="userNationality" type="text"
 value="<?php echo $dataPacket['userNationality']; ?>" 
id="Nationality">*
            </div>
             </br>
            <div>Religion:
            <input name="userReligion" 
type="text" value="<?php echo $dataPacket['userReligion']; ?>" id="Religion">*
            </div>
             </br>
           
            <div>Address:
            <textarea rows="10" cols="35" name="userAddress"> 
            </textarea>
            </div>
              </br>
            <div>Designation:
            <input name="userDesignation" type="text" 
value="<?php echo $dataPacket['userDesignation']; ?>" 
id="Designation">*
            </div>
             </br>
              <div>Country:
              <?php  $query="SELECT COUNTRY_ID, COUNTRY 
from  countrys where ISACTIVE=1 ORDER BY COUNTRY"; 
       $result=mysql_query($query);
    
     ?>
            
              <select name="country" >
             
                <option value="" >Select a country</option>
                <?php 
while($country =mysql_fetch_array($result))
    {
     ?>
                    <option value="<?php echo $country['COUNTRY_ID'];?>" <?php if($country['COUNTRY_ID']==$dataPacket['country'])
 echo 'selected';?> > <?php echo $country['COUNTRY'];?></option>
                    <?php
    }
    ?>
              </select>
              
               </br>
               </br>
               <input name="id" type="hidden" id="id" value="<?php echo $dataPacket['id']; ?>">
               <input name="update" type="submit" value="update"/>
               <input name="Reset" type="Reset" value="Reset"/>
               <input name="Cancel"  type="button" value="Cancel"/>
            </div>
            
</div>

</center>
</form>

editProfile_action.php


<?php
include("connect.php");
session_start();
//..........................................Variable default section.........................................................

$userName=$_REQUEST['userName'];
$userfatherName =$_REQUEST['userfatherName'];
$userOccupation =$_REQUEST['userOccupation'];
$userNationality =$_REQUEST['userNationality'];
$userReligion=$_REQUEST['userReligion'];
$userAddress=$_REQUEST['userAddress'];
$userDesignation =$_REQUEST['userDesignation'];
$Country=$_REQUEST['country']; 
$id=$_REQUEST['id'];



//............................................Update data........................................................................

$query=" Update create_profile set 
        
  userName='$userName',
  userfatherName='$userfatherName',
  userOccupation='$userOccupation',
  userNationality='$userNationality',
  userReligion='$userReligion',
  userAddress='$userAddress',
  userDesignation='$userDesignation',
  country='$Country' WHERE id=".$id
  
  
  
  
  
  ;
  $result=mysql_query($query);
  if($result)
  {
   echo "Ur Profile is updated";
   echo "</br>";
      ?>
         <script language="javascript">
   window.location="viewMyProfile.php?id=<?php echo $id;?>";
  </script>
  
  <?php
  }

 
?>

Simple Project(part 3c)

2010-07-03T04:36:00.000-07:00

.....................................................................................

This code is for displaying the profile after insertion.

.....................................................................................

viewMyProfile.php:



<?php
session_start();
?>


<table cellpadding="0" cellspacing="0" bgcolor="#FFDFFF" width="900px;">
        
                    <tr>
                            
                        
                       
                            
                        <?php
                                include("connect.php");
            
                          
        
        
        echo $query="select * from  create_profile where userid='{$_SESSION['id']}'";
                                $result=mysql_query($query);
                                $dataPacket =mysql_fetch_array($result);
                                
                                
                            
                         ?>
                
                        
                    </tr>
                
        
</table>
<table cellpadding="3" cellspacing="3"  bgcolor="#C9C9C9" width="900px;">
     <tr>
                    <td colspan="4" rowspan="2" valign="middle" height="50px" align="left" style=" font-family:Verdana, Geneva, sans-serif; font-weight:bold; font-size:14px; margin-left:70px; ">My Profile</td>    
           </tr>
                    <tr>
                    <td  align="right" style=" font-family:Verdana, Geneva, sans-serif; font-weight:bold; font-size:14px; margin-left:70px; "><a href="editProfile.php?id=<?php echo  $dataPacket['id']; ?>">Edit Profile</a></td>    
           </tr>
       <caption style="background-color: #999; color: #FFF; font-size:14px; font-weight:bold;"> Congratulations ! Ur profile is created.</caption>
         
            <tr>
                    <th width="35%">Name:</th> 
                    <td><?php echo $dataPacket['userName']; ?></td>
                 
           </tr>
           <tr>
                    <th>Father's Name:</th>
                    <td><?php echo $dataPacket['userfatherName']; ?></td>
           </tr>
            <tr>
                    <th>Occupation:</th>
                    <td><?php echo $dataPacket['userOccupation']; ?></td>
           </tr>
           <tr>
                    <th>Nationality:</th>
                    <td><?php echo $dataPacket['userNationality']; ?></td>
           </tr>
           <tr>
                    <th>Religion:</th>
                    <td><?php echo $dataPacket['userReligion']; ?></td>
                    </tr>
             <tr>
                             <th>Address:</th>
                             <td><?php echo  nl2br($dataPacket['userAddress']); ?></td>
                    </tr>
                    <tr>
                             <th>Designation:</th>
                             <td><?php echo $dataPacket['userDesignation']; ?></td>
                   </tr>
                    <tr>
                             <th>Country:</th>
                             <td><?php echo countryName($dataPacket['country']); ?></td>
           </tr>
                    
        
</table>
<?php
function countryName($id)
{
    $query="select COUNTRY from countrys where COUNTRY_ID='$id'";
 $res=mysql_query($query);
 $result=mysql_fetch_array($res);
 $result=$result['COUNTRY'];
 return $result;
}

?>

Simple Project(part-3b)

2010-07-02T23:43:00.000-07:00

.......................................................................................

In this section i create a page for creation for user profile .

.......................................................................................

profile.php


<script language="javascript">
 function displayDiv(id)
 {
  document.getElementById(id).style.display='';
 }
 function hideDiv()
 {
  document.getElementById("pofile").style.display='none';
 }

</script>

  <?php
  include("connect.php");
  if(isset ($error)  && $error==true)
    
  {
   ?>
   <center>
   <div style="border:1px solid #F00; background-color:#FFF2FF; width:300px;">
   <?php
   echo $errorMessage;
   ?>
   </div>
   </center>
   <?php
  }
          
  ?>

<?php if(isProfileCreated()==1)
 { 

?>
 <script language="javascript">
window.location="viewMyProfile.php";
</script>
 <?php 
  }
  
 else
 {

?>

<a href="javascript:displayDiv('pofile')">Create Profile</a>


<link type="text/css" rel="stylesheet"  href="style.css"/>
<div id="pofile" <?php if(!$error) {?> style="display:none;" <?php }?>> 
<form name="userCreateProfile" method="post" action="profile_action.php">
<center>
<div ><h3>Create Profile</h3>
            <div>Name:
            <input name="userName"  type="text" value="<?php if(isset($_POST['userName'])) echo $_POST['userName']; ?>"id="Name">*
            </div>
            
            </br>
            <div>Father's Name:
            <input name="userfatherName" type="text" value="<?php if(isset($_POST['userfatherName'])) echo $_POST['userfatherName'];?>" id="fatherName">*
            </div>
            
            </br>
            <div>Occupation:
            <input name="userOccupation" type="text" value="<?php if(isset($_POST['userOccupation'])) echo $_POST['userOccupation']; ?>" id="Occupation">*
            </div>
            
            </br>
            <div>Nationality:
            <input name="userNationality" type="text" value="<?php if(isset($_POST['userNationality'])) echo $_POST['userNationality']; ?>" id="Nationality">*
            </div>
             </br>
            <div>Religion:
            <input name="userReligion" type="text" value="<?php if(isset($_POST['userReligion'])) echo $_POST['userReligion']; ?>" id="Religion">*
            </div>
             </br>
           
            <div>Address:
            <textarea rows="10" cols="35" name="userAddress"> 
            </textarea>
            </div>
              </br>
            <div>Designation:
            <input name="userDesignation" type="text" value="<?php if(isset($_POST['userDesignation'])) echo $_POST['userDesignation']; ?>" id="Designation">*
            </div>
             </br>
              <div>Country:
              <?php  $query="SELECT COUNTRY_ID, COUNTRY from  countrys where ISACTIVE=1 ORDER BY COUNTRY"; 
       $result=mysql_query($query);
    
     ?>
            
              <select name="country" >
                <option value="" >Select a country</option>
                <?php while($country =mysql_fetch_array($result))
    {
     ?>
                    <option value="<?php echo $country['COUNTRY_ID'];?>" <?php if($country['COUNTRY_ID']==$_REQUEST['country']) echo 'selected';?> > <?php echo $country['COUNTRY'];?></option>
                    <?php
    }
    ?>
              </select>
              
               </br>
               </br>
               <input name="Create" type="submit" value="Create"/><input name="Reset" type="Reset" value="Reset"/>
               <input name="Cancel" onClick="hideDiv()" type="button" value="Cancel"/>
            </div>
            
</div>

</center>
</form>

</div>
<div id="gallery" style="display:none;">Gallery</div>
<?php
 }
function isProfileCreated()
{
  $query="select userName  from  create_profile where userid='{$_SESSION['id']}'";
   $result=mysql_query($query);
   $val= mysql_num_rows($result);
 
   return $val;
}
 
?>

..........................................................................................................................................................................

profile_action.php


<?php
session_start();
include("connect.php");

//..........................get values from from.........................................................//

$userName=$_REQUEST['userName'];
$userfatherName = $_REQUEST['userfatherName'];
$userOccupation = $_REQUEST['userOccupation'];
$userNationality = $_REQUEST['userNationality'];
$userReligion    =   $_REQUEST['userReligion'];
$userAddress    =  $_REQUEST['userAddress'];
$userDesignation =  $_REQUEST['userDesignation'];
$Country=$_REQUEST['country']; 

// .......................Error Message................................

     $error=false;
     $errorMessage="";

     if(empty($userName))
     {
      $error=true;
      $userNameError=true;
      $errorMessage.="Please provide username.</br>";
     }
     if(empty($userfatherName))
     {
      $error=true;
      $userfatherNameError=true;
      $errorMessage.="Please provide Father's name.</br>";
     }
     if(empty($userNationality))
     {
      $error=true;
      $userNationalityError=true;
      $errorMessage.="Please provide Nationality.</br>";
     }
     if(empty($userReligion ))
     {
      $error=true;
      $userReligionNameError=true;
      $errorMessage.="Please provide Religion.</br>";
     }
     if(empty($userDesignation))
     {
      $error=true;
      $userDesignationNameError=true;
      $errorMessage.="Please provide Designation.</br>";
     }
     /*if(empty($country))
     {
      $error=true;
      $countryError=true;
      $errorMessage.="Please select country</br>";
     }*/

//..........................insert data .........................................................//
      if($error)
     
      {
     
       include("profile.php");
      }
      else
      {
        $sql="
          INSERT into  create_profile 
          (
          userid,
           userName,
           userfatherName,
           userOccupation,
           userNationality,
           userReligion,
           userAddress,
           userDesignation,
           country
          )
          values
          
          ('$_SESSION[id]','$userName','$userfatherName','$userOccupation','$userNationality','$userReligion','$userAddress','$userDesignation','$Country')
          
         ";
         $result=mysql_query($sql);
         $id=mysql_insert_id();
           if($result)
           {
          
           
           ?>
                                            <script language="javascript">
           window.location="viewMyProfile.php?id=<?php echo $id;?>";
           </script>
           <?php
         } 
 
      }
?>

Simple Project(Part-3a)

2010-07-02T23:35:00.000-07:00

.......................................................................................

In this section i will try to create some functions for logged user.Here first one is create profile.It's badly need to create two table(country,create_profile).
.......................................................................................

1.CREATE TABLE `create_profile` (
`id` int(10) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`userName` varchar(255) NOT NULL,
`userfatherName` varchar(255) NOT NULL,
`userOccupation` varchar(255) NOT NULL,
`userNationality` varchar(255) NOT NULL,
`userReligion` varchar(255) NOT NULL,
`userAddress` varchar(255) NOT NULL,
`userDesignation` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

2.CREATE TABLE `countrys` (
`COUNTRY_ID` int(11) NOT NULL auto_increment,
`COUNTRY` varchar(100) collate utf8_unicode_ci default NULL,
`ISO3166CODE` varchar(2) collate utf8_unicode_ci default NULL,
`CONTINENT_ID` int(10) default NULL,
`ISACTIVE` tinyint(1) NOT NULL default '1',
`USER_ID_INSERTED` int(10) default NULL,
`USER_ID_UPDATED` int(10) default NULL,
`DATE_INSERTED` datetime default NULL,
`DATE_UPDATED` datetime default NULL,
PRIMARY KEY (`COUNTRY_ID`),
KEY `FK_COUNTRY_CONTINENT` (`CONTINENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=245 ;

--
-- Dumping data for table `countrys`
--

INSERT INTO `countrys` (`COUNTRY_ID`, `COUNTRY`, `ISO3166CODE`, `CONTINENT_ID`, `ISACTIVE`, `USER_ID_INSERTED`, `USER_ID_UPDATED`, `DATE_INSERTED`, `DATE_UPDATED`) VALUES
(1, 'Bangladesh', 'BD', 1, 1, 0, 3, '2010-02-06 08:02:57', '2010-06-16 15:06:26'),
(2, 'India', 'IN', 1, 1, 0, 5, '2010-02-06 09:02:09', '2010-02-08 12:02:11'),
(4, 'Afghanistan', 'AF', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:43'),
(5, 'Armenia', 'AM', 1, 1, 0, 91, '2010-02-06 09:02:13', '2010-04-23 10:04:02'),
(6, 'Azerbaijan', 'AZ', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:28'),
(7, 'Brunei', 'BN', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:12'),
(8, 'Bhutan', 'BT', 1, 1, 0, 91, '2010-02-06 09:02:42', '2010-04-23 10:04:25'),
(9, 'Cambodia', 'KH', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:43'),
(10, 'Indonesia', 'ID', 1, 1, 0, 91, '2010-02-06 09:02:31', '2010-04-23 10:04:59'),
(12, 'Malaysia', 'MY', 1, 1, 0, 91, '2010-02-06 09:02:05', '2010-04-23 10:04:54'),
(13, 'Maldives', 'MV', 1, 1, 0, 91, '2010-02-06 09:02:29', '2010-04-23 10:04:07'),
(14, 'Myanmar', 'MM', 1, 1, 0, 91, '2010-02-06 09:02:50', '2010-04-23 10:04:20'),
(15, 'Nepal', 'NP', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:33'),
(16, 'Pakistan', 'PK', 1, 1, 0, 91, '2010-02-06 09:02:19', '2010-04-23 10:04:47'),
(17, 'Papua New Guinea', 'PG', 1, 1, 0, 91, '2010-02-06 09:02:35', '2010-04-23 10:04:02'),
(18, 'Philippines', 'PH', 1, 1, 0, 91, '2010-02-06 09:02:48', '2010-04-23 10:04:15'),
(19, 'Singapore', 'SG', 1, 1, 0, 91, '2010-02-06 09:02:01', '2010-04-23 10:04:37'),
(20, 'Sri Lanka', 'LK', 1, 1, 0, 91, '2010-02-06 09:02:18', '2010-04-23 10:04:54'),
(21, 'Thailand', 'TH', 1, 1, 0, 91, '2010-02-06 09:02:30', '2010-04-23 10:04:08'),
(22, 'Vietnam', 'VN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:27'),
(23, 'Kazakhstan', 'KZ', 1, 1, 0, 91, '2010-02-06 09:02:15', '2010-04-23 10:04:46'),
(24, 'Kyrgyzstan', 'KG', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:14'),
(25, 'Turkmenistan', 'TM', 1, 1, 0, 91, '2010-02-06 09:02:21', '2010-04-23 10:04:37'),
(26, 'Uzbekistan', 'UZ', 1, 1, 0, 91, '2010-02-06 09:02:34', '2010-04-23 10:04:53'),
(27, 'China', 'CN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:17'),
(28, 'Japan', 'JP', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:36'),
(29, 'North Korea', 'KP', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:07'),
(30, 'South Korea', 'KR', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:57'),
(31, 'Mongolia', 'MN', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:13'),
(32, 'Taiwan', 'TW', 1, 1, 0, 91, '2010-02-06 09:02:17', '2010-04-23 10:04:40'),
(33, 'Bahrain', 'BH', 1, 1, 0, 91, '2010-02-06 09:02:02', '2010-04-23 10:04:58'),
(34, 'Georgia', 'GE', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:15'),
(35, 'Iran', 'IR', 1, 1, 0, 91, '2010-02-06 09:02:24', '2010-04-23 10:04:34'),
(36, 'Iraq', 'IQ', 1, 1, 0, 91, '2010-02-06 09:02:41', '2010-04-23 10:04:47'),
(37, 'Israel', 'IL', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:02'),
(38, 'Jordan', 'JO', 1, 1, 0, 91, '2010-02-06 09:02:03', '2010-04-23 10:04:18'),
(39, 'Kuwait', 'KW', 1, 1, 0, 91, '2010-02-06 09:02:16', '2010-04-23 10:04:36'),
(40, 'Lebanon', 'LB', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:53'),
(41, 'Oman', 'OM', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:16'),
(42, 'Qatar', 'QA', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:35'),
(43, 'Saudi Arabia', 'SA', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:08'),
(44, 'Syria', 'SY', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:55'),
(45, 'U.A.E.', 'AE', 1, 1, 0, 91, '2010-02-06 09:02:36', '2010-04-23 10:04:27'),
(46, 'Yemen', 'YE', 1, 1, 0, 91, '2010-02-06 09:02:08', '2010-04-23 10:04:43'),
(47, 'Albania', 'AL', 4, 1, 0, 91, '2010-02-06 09:02:45', '2010-04-23 10:04:02'),
(48, 'Andorra', 'AD', 4, 1, 0, 91, '2010-02-06 10:02:22', '2010-04-23 10:04:21'),
(49, 'Austria', 'AT', 4, 1, 0, 91, '2010-02-06 10:02:05', '2010-04-23 10:04:35'),
(50, 'Belgium', 'BE', 4, 1, 0, 91, '2010-02-06 10:02:33', '2010-04-23 10:04:53'),
(51, 'Bulgaria', 'BG', 4, 1, 0, 5, '2010-02-06 10:02:55', '2010-04-23 10:04:35'),
(52, 'Belarus', 'BY', 4, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:54'),
(53, 'Bosnia and Herzegovina', 'BA', 4, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:41'),
(54, 'Cyprus', 'CY', 4, 1, 0, 5, '2010-02-06 10:02:27', '2010-04-23 10:04:23'),
(55, 'Croatia', 'CR', 4, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(56, 'Czech Republic', 'CZ', 4, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:52'),
(57, 'Denmark', 'DK', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:48'),
(58, 'Estonia', 'EE', 4, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:53'),
(59, 'Finland', 'FI', 4, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:57'),
(60, 'France', 'FR', 4, 1, 0, 3, '2010-02-06 10:02:36', '2010-04-23 10:04:34'),
(61, 'Germany', 'GE', 4, 1, 0, 3, '2010-02-06 10:02:52', '2010-04-23 10:04:32'),
(62, 'Greece', 'GR', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:37'),
(63, 'Hungary', 'HU', 4, 1, 0, 3, '2010-02-06 10:02:39', '2010-04-23 10:04:57'),
(64, 'Iceland', 'IS', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:22'),
(65, 'Ireland', 'IE', 4, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:00'),
(66, 'Italy', 'IT', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:23'),
(67, 'Latvia', 'LV', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:50'),
(68, 'Lithuania', 'LT', 4, 1, 0, 3, '2010-02-06 10:02:22', '2010-04-23 10:04:53'),
(69, 'Luxembourg', 'LU', 4, 1, 0, 3, '2010-02-06 10:02:35', '2010-04-23 10:04:29'),
(70, 'Liechtenstein', 'LI', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:00'),
(71, 'Malta', 'MT', 4, 1, 0, 3, '2010-02-06 10:02:11', '2010-04-23 10:04:13'),
(72, 'Moldova', 'MD', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:44'),
(73, 'Monaco', 'MC', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:13'),
(74, 'Montenegro', 'ME', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:45'),
(75, 'Netherlands', 'NL', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:02'),
(76, 'Norway', 'NO', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:30'),
(77, 'Poland', 'PL', 4, 1, 0, 3, '2010-02-06 10:02:09', '2010-04-23 10:04:05'),
(78, 'Portugal', 'PT', 4, 1, 0, 3, '2010-02-06 10:02:25', '2010-04-23 10:04:37'),
(79, 'Romania', 'RO', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(80, 'Russia', 'RU', 4, 1, 0, 3, '2010-02-06 10:02:30', '2010-04-23 10:04:52'),
(82, 'Serbia', 'RS', 4, 1, 0, 3, '2010-02-06 10:02:00', '2010-04-23 10:04:20'),
(84, 'Slovenia', 'SI', 4, 1, 0, 3, '2010-02-06 10:02:29', '2010-04-23 10:04:42'),
(85, 'Spain', 'ES', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:15'),
(86, 'Sweden', 'SE', 4, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:01'),
(87, 'Switzerland', 'CH', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:25'),
(88, 'Turkey', 'TR', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:01'),
(89, 'Ukraine', 'UA', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(90, 'United Kingdom', 'GB', 4, 1, 0, 3, '2010-02-06 10:02:18', '2010-04-23 10:04:11'),
(91, 'Vatican City State', 'VA', 4, 1, 0, 5, '2010-02-06 10:02:46', '2010-04-23 11:04:06'),
(92, 'Antigua and Barbuda', 'AG', 2, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:10'),
(93, 'Bahamas', 'BS', 2, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:44'),
(95, 'Belize', 'BZ', 2, 1, 0, 3, '2010-02-06 10:02:33', '2010-04-23 10:04:22'),
(96, 'Canada', 'CA', 2, 1, 0, 3, '2010-02-06 10:02:55', '2010-04-23 10:04:18'),
(97, 'Costa Rica', 'CR', 2, 1, 0, 3, '2010-02-06 10:02:12', '2010-04-23 10:04:43'),
(98, 'Cuba', 'CU', 2, 1, 0, 3, '2010-02-06 10:02:53', '2010-04-23 10:04:51'),
(99, 'Dominica', 'DM', 2, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:26'),
(100, 'Dominican- Republic', 'DO', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 10:04:18'),
(101, 'El Salvador', 'SV', 2, 1, 0, 5, '2010-02-06 10:02:00', '2010-04-23 10:04:42'),
(102, 'Greenland', 'GL', 2, 1, 0, 3, '2010-02-06 10:02:21', '2010-07-02 11:07:59'),
(103, 'Grenada', 'GD', 2, 1, 0, 5, '2010-02-06 10:02:34', '2010-04-23 10:04:28'),
(104, 'United States', 'US', 2, 1, 0, 3, '2010-02-06 10:02:48', '2010-06-24 15:06:39'),
(105, 'Trinidad and Tobago', 'TT', 2, 1, 0, 5, '2010-02-06 10:02:12', '2010-04-23 10:04:49'),
(106, 'Saint Vincent and the Grenadines', 'VC', 2, 1, 0, 5, '2010-02-06 10:02:29', '2010-04-23 11:04:50'),
(107, 'Panama', 'PA', 2, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:49'),
(108, 'Mexico', 'MX', 2, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:22'),
(109, 'Jamaica', 'JM', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 11:04:07'),
(110, 'Haiti', 'HT', 2, 1, 0, 5, '2010-02-06 10:02:02', '2010-04-23 11:04:38'),
(111, 'Honduras', 'HN', 2, 1, 0, 5, '2010-02-06 10:02:22', '2010-04-23 11:04:13'),
(112, 'Guatemala', 'GT', 2, 1, 0, 5, '2010-02-06 10:02:35', '2010-04-23 10:04:28'),
(113, 'Argentina', 'AR', 3, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(114, 'Bolivia', 'BO', 3, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:44'),
(115, 'Brazil', 'BR', 3, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:39'),
(116, 'Chile', 'CL', 3, 1, 0, 5, '2010-02-06 10:02:17', '2010-04-23 10:04:15'),
(117, 'Colombia', 'CO', 3, 1, 0, 5, '2010-02-06 10:02:32', '2010-04-23 10:04:45'),
(118, 'Ecuador', 'EC', 3, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:58'),
(119, 'Guyana', 'GY', 3, 1, 0, 5, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(120, 'Paraguay', 'PY', 3, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:11'),
(121, 'Peru', 'PE', 3, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:46'),
(122, 'Uruguay', 'UY', 3, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:25'),
(123, 'Venezuela', 'VE', 3, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:53'),
(124, 'Australia', 'AU', 6, 1, 0, 5, '2010-02-06 10:02:20', '2010-04-23 10:04:13'),
(125, 'Fiji', 'FJ', 6, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:01'),
(126, 'New Zealand', 'NZ', 6, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:24'),
(127, 'Solomon Islands', 'SB', 6, 1, 0, 5, '2010-02-06 10:02:10', '2010-04-23 10:04:07'),
(128, 'Algeria', 'DZ', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:35'),
(129, 'Chad', 'TD', 5, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:01'),
(130, 'Congo', 'CG', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:43'),
(131, 'Egypt', 'EG', 5, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:13'),
(132, 'Ethiopia', 'ET', 5, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:52'),
(133, 'Gambia', 'GM', 5, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:28'),
(134, 'Ghana', 'GH', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:50'),
(135, 'Kenya', 'KE', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:39'),
(136, 'Liberia', 'LR', 5, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(137, 'Libya', 'LY', 5, 1, 0, 5, '2010-02-06 11:02:35', '2010-04-23 10:04:56'),
(138, 'Nigeria', 'NG', 5, 1, 0, 5, '2010-02-06 11:02:30', '2010-04-23 10:04:58'),
(139, 'Senegal', 'SN', 5, 1, 0, 5, '2010-02-06 11:02:12', '2010-04-23 10:04:19'),
(140, 'South Africa', 'ZA', 5, 1, 0, 5, '2010-02-06 11:02:14', '2010-04-23 10:04:50'),
(141, 'Sudan', 'SD', 5, 1, 0, 5, '2010-02-06 11:02:39', '2010-04-23 10:04:18'),
(142, 'Tanzania', 'TZ', 5, 1, 0, 5, '2010-02-06 11:02:04', '2010-04-23 10:04:00'),
(143, 'Togo', 'TG', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:18'),
(144, 'Western Sahara', 'EH', 5, 1, 0, 5, '2010-02-06 11:02:42', '2010-04-23 10:04:57'),
(145, 'Uganda', 'UG', 5, 1, 0, 5, '2010-02-06 11:02:08', '2010-04-23 10:04:29'),
(146, 'Zimbabwe', 'ZW', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:07'),
(147, 'Morocco', 'MA', 5, 1, 5, 5, '2010-02-09 06:02:10', '2010-04-23 10:04:26'),
(148, 'Palestine', 'PS', 1, 1, 5, 5, '2010-02-09 07:02:41', '2010-04-23 10:04:50'),
(149, 'CAMEROON', 'CM', 5, 1, 3, 3, '2010-06-16 16:06:42', '2010-07-02 11:07:54'),
(150, 'HONG KONG', 'HK', 1, 1, 3, NULL, '2010-06-29 10:06:09', NULL),
(151, 'JERSEY', 'JE', 4, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(152, 'KIRIBATI', 'KI', 6, 1, 3, NULL, '2010-07-02 14:07:39', NULL),
(153, 'LESOTHO', 'LS', 5, 1, 3, NULL, '2010-07-02 14:07:20', NULL),
(154, 'MACAO', 'MO', 1, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(155, 'ANGOLA', 'AO', 5, 1, 3, NULL, '2010-07-02 14:07:08', NULL),
(156, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK', 4, 1, 3, NULL, '2010-07-02 14:07:25', NULL),
(157, 'MADAGASCAR', 'MG', 5, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(158, 'MALAWI', 'MW', 5, 1, 3, NULL, '2010-07-02 14:07:01', NULL),
(159, 'MALI', 'ML', 5, 1, 3, NULL, '2010-07-02 14:07:34', NULL),
(160, 'BENIN', 'BJ', 5, 1, 3, NULL, '2010-07-02 14:07:44', NULL),
(161, 'MARSHALL ISLANDS', 'MH', 6, 1, 3, NULL, '2010-07-02 14:07:16', NULL),
(162, 'BERMUDA', 'BM', 2, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(163, 'MARTINIQUE', 'MQ', 3, 1, 3, NULL, '2010-07-02 14:07:00', NULL),
(164, 'MAURITANIA', 'MR', 5, 1, 3, NULL, '2010-07-02 14:07:09', NULL),
(165, 'BOTSWANA', 'BW', 5, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(166, 'MAURITIUS', 'MU', 5, 1, 3, NULL, '2010-07-02 14:07:55', NULL),
(167, 'MAYOTTE', 'YT', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(168, 'BRITISH INDIAN OCEAN TERRITORY', 'AO', 1, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(169, 'MICRONESIA, FEDERATED STATES OF', 'FM', 6, 1, 3, NULL, '2010-07-02 14:07:04', NULL),
(170, 'BURKINA FASO', 'BF', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(171, 'BURUNDI', 'BI', 5, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(172, 'MONTSERRAT', 'MS', 3, 1, 3, NULL, '2010-07-02 14:07:50', NULL),
(173, 'CAPE VERDE', 'CV', 5, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(174, 'MOZAMBIQUE', 'MZ', 5, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(175, 'NAMIBIA', 'NA', 5, 1, 3, NULL, '2010-07-02 14:07:18', NULL),
(176, 'CAYMAN ISLANDS', 'KY', 2, 1, 3, NULL, '2010-07-02 14:07:54', NULL),
(177, 'NAURU', 'NR', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(178, 'NETHERLANDS ANTILLES', 'AN', 2, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(179, 'CENTRAL AFRICAN REPUBLIC', 'CF', 5, 1, 3, NULL, '2010-07-02 14:07:22', NULL),
(180, 'ANTARCTICA', 'AQ', 7, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(181, 'NEW CALEDONIA', 'NC', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(182, 'NICARAGUA', 'NI', 2, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(183, 'NIGER', 'NE', 5, 1, 3, NULL, '2010-07-02 14:07:53', NULL),
(184, 'NIUE', 'NU', 6, 1, 3, NULL, '2010-07-02 14:07:31', NULL),
(185, 'NORFOLK ISLAND', 'NF', 6, 1, 3, NULL, '2010-07-02 14:07:03', NULL),
(186, 'NORTHERN MARIANA ISLANDS', 'MP', 6, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(187, 'PALAU', 'PW', 6, 1, 3, NULL, '2010-07-02 15:07:26', NULL),
(188, 'PITCAIRN', 'PN', 2, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(189, 'PUERTO RICO', 'PR', 2, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(190, 'ANGUILLA', 'AI', 2, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(191, 'ALAND ISLANDS', 'AX', 6, 1, 3, 3, '2010-07-02 15:07:02', '2010-07-02 15:07:21'),
(192, 'ARUBA', 'AW', 3, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(193, 'CHRISTMAS ISLAND', 'CX', 1, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(194, 'COMOROS', 'KM', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(195, 'REUNION', 'RE', 5, 1, 3, NULL, '2010-07-02 15:07:22', NULL),
(196, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 5, 1, 3, NULL, '2010-07-02 15:07:48', NULL),
(197, 'RWANDA', 'RW', 5, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(198, 'COOK ISLANDS', 'CK', 3, 1, 3, NULL, '2010-07-02 15:07:03', NULL),
(199, 'SAINT BARTHÃƒâ€°LEMY', 'BL', 2, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(200, 'SAINT HELENA', 'SH', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(201, 'DJIBOUTI', 'DJ', 5, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(202, 'SAINT KITTS AND NEVIS', 'KN', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(203, 'EQUATORIAL GUINEA', 'GQ', 6, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(204, 'COCOS (KEELING) ISLANDS', 'CC', 5, 1, 3, NULL, '2010-07-02 15:07:56', NULL),
(205, 'ERITREA', 'ER', 5, 1, 3, NULL, '2010-07-02 15:07:06', NULL),
(206, 'FALKLAND ISLANDS (MALVINAS)', 'FK', 7, 1, 3, NULL, '2010-07-02 15:07:53', NULL),
(207, 'FAROE ISLANDS', 'FO', 4, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(208, 'FRENCH GUIANA', 'GF', 3, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(209, 'FRENCH POLYNESIA', 'PF', 6, 1, 3, NULL, '2010-07-02 15:07:33', NULL),
(210, 'SAINT LUCIA', 'LC', 2, 1, 3, NULL, '2010-07-02 15:07:45', NULL),
(211, 'FRENCH SOUTHERN TERRITORIES', 'TF', 6, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(212, 'GABON', 'GA', 5, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(213, 'GIBRALTAR', 'GI', 4, 1, 3, NULL, '2010-07-02 15:07:54', NULL),
(214, 'SAINT MARTIN', 'MF', 4, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(215, 'SAINT PIERRE AND MIQUELON', 'SA', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(216, 'SAMOA', 'WS', 6, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(217, 'SAN MARINO', 'SM', 4, 1, 3, NULL, '2010-07-02 15:07:36', NULL),
(218, 'SAO TOME AND PRINCIPE', 'ST', 5, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(219, 'SLOVAKIA', 'SK', 4, 1, 3, NULL, '2010-07-02 15:07:07', NULL),
(220, 'SEYCHELLES', 'SC', 5, 1, 3, NULL, '2010-07-02 15:07:21', NULL),
(221, 'SIERRA LEONE', 'SL', 5, 1, 3, NULL, '2010-07-02 15:07:31', NULL),
(222, 'SOMALIA', 'SO', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(223, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 3, 1, 3, NULL, '2010-07-02 15:07:17', NULL),
(224, 'SWAZILAND', 'SZ', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(225, 'SVALBARD AND JAN MAYEN', 'SJ', 4, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(226, 'SURINAME', 'SR', 3, 1, 3, NULL, '2010-07-02 15:07:18', NULL),
(227, 'GUADELOUPE', 'GP', 2, 1, 3, NULL, '2010-07-02 15:07:14', NULL),
(228, 'GUAM', 'GU', 2, 1, 3, NULL, '2010-07-02 15:07:41', NULL),
(229, 'GUERNSEY', 'GG', 4, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(230, 'GUINEA', 'GN', 5, 1, 3, NULL, '2010-07-02 15:07:19', NULL),
(231, 'GUINEA-BISSAU', 'GW', 5, 1, 3, NULL, '2010-07-02 15:07:10', NULL),
(232, 'TAJIKISTAN', 'TJ', 1, 1, 3, NULL, '2010-07-02 15:07:16', NULL),
(233, 'TIMOR-LESTE', 'TL', 1, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(234, 'TOKELAU', 'TK', 6, 1, 3, NULL, '2010-07-02 16:07:40', NULL),
(235, 'TONGA', 'TO', 6, 1, 3, NULL, '2010-07-02 16:07:49', NULL),
(236, 'TUNISIA', 'TN', 5, 1, 3, NULL, '2010-07-02 16:07:20', NULL),
(237, 'TURKS AND CAICOS ISLANDS', 'TC', 2, 1, 3, NULL, '2010-07-02 16:07:21', NULL),
(238, 'TUVALU', 'TV', 6, 1, 3, NULL, '2010-07-02 16:07:34', NULL),
(239, 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 6, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(240, 'VANUATU', 'VU', 6, 1, 3, NULL, '2010-07-02 16:07:01', NULL),
(241, 'VIRGIN ISLANDS, BRITISH', 'VG', 2, 1, 3, NULL, '2010-07-02 16:07:53', NULL),
(242, 'VIRGIN ISLANDS, U.S.', 'VI', 2, 1, 3, NULL, '2010-07-02 16:07:17', NULL),
(243, 'WALLIS AND FUTUNA', 'WF', 6, 1, 3, NULL, '2010-07-02 16:07:46', NULL),
(244, 'ZAMBIA', 'ZM', 5, 1, 3, NULL, '2010-07-02 16:07:16', NULL);

-- --------------------------------------------------------

Simple Project(Part 2b)

2010-07-02T23:28:00.000-07:00

.....................................................................................

Now i will create a login page for registered user.
.....................................................................................

userLogin.php:


<?php
session_start();
echo $_SESSION['uName'];
  
?>

<html>
<link type="text/css" rel="stylesheet"  href="style.css"/>
    <body>
   
       <form name="userlogin" method="post" action="userLogin_action.php">
            <center> 
                        <table cellpadding=4 cellspacing=2 border=0>
                                <th bgcolor="#CCCCFF" colspan=2>
                                            <font size=5>USER LOGIN</font>
                                            <br>
                                            <font size=1><sup>*</sup> Required Fields</font>
                                 </th>
                                 <tr bgcolor="#c8d8f8">
                                        <td valign=top colspan=2>
                                            <b>User Name<sup>*</sup></b>
                                            <input type="text" name="uName" size=20  maxlength=20>
                                         </td>
                               </tr>
                                <tr bgcolor="#c8d8f8">
                                        <td valign=top>
                                            <b>Password<sup>*</sup></b> 
                                                          
                                            <input type="password" name="userPassword1" > 
                                
                                        </td>
                                <tr bgcolor="#c8d8f8">
                                        <td  align=center colspan=2>
                                                <input type="submit" name="submit" value="Submit"> 
                                        </td>
                                </tr>
                           </table>
               </center>
       </form>
    
    </body>
  
</html>

.....................................................................................

....................................................................................

userLogin_action.php:


<?php
include("connect.php");
session_start();
 
  if($_SESSION['uName'])
     {
     ?>
     <div style="text-align:right;">
     <a  href="logout.php"> <strong>Logout</strong></a>
      </a>
      </div>
      <?php
      }
                                               
    
   
   
//...................... get values from from.........................................
   
    $userName=$_REQUEST['uName'];
    $userPassword1=md5($_REQUEST['userPassword1']);
    $id=$_REQUEST['id'];

/// To protect MySQL injection (more detail about MySQL injection)
//$userName = stripslashes($userName);
//$userPassword1 = stripslashes ($userPassword);
//$userName = mysql_real_escape_string($userName);
//$userPassword1 = mysql_real_escape_string($userPassword1);

//...................... Database Query.........................................

   
    $sql="SELECT * from sign_up where userName='$userName' and password='".$userPassword1."'";
     
    $result = mysql_query($sql);
   
     $rs = mysql_fetch_array($result);
   
   
   // $rs['userName'];
   //  $rs['password'];



  if($rs ['userName']==$userName &&  $rs['password']==$userPassword1)
    {
      $_SESSION['uName']=$userName;
      $_SESSION['id']=$rs['id'];
      
      echo " Welcome ".  "<span style='color:#69F;' ><b>". $userName."</b></span>".'!'.' your login is successful. Enjoy this site. Thank you very much';
      ?>
                        
      <table bgcolor="#CCCCCC" width="800px;">
        <tr >
         <td align="left"><a href="profile.php">My Profile</a></td>
                                   
        </tr>
               <tr>
                                  <td align="left"><a href="lifeStyle.php">My lifestyle</a></td>
                                 </tr>
                                 <tr>
                                  <td align="left"><a href="createGallery.php">Create Gallery</a></td>
                                 </tr>
                                 <tr>
                                  <td align="left"><a href="aboutMe.php">About Me</a></td>
                                 </tr>
                                   <tr>
                                  <td align="left"><a href="contactMe.php">Contact Me</a></td>
                                 </tr>
      </table>
                        
      
      <?php
     
    }
 
           
  else
      
         {
       
       
   echo "Invalid username or Password";
          }


                           ?>

Simple Project (part-2a)

2010-07-02T23:06:00.000-07:00

signUp.php:


<?php
if(isset($error) && $error==true )
{
 ?>
    <center>
    <div style="border:1px solid #F00; background-color:#FFF2FF; width:300px;">
    <?php
 echo $errorMessage;
 
 ?>
    </div>
    </center>
    <?php
}
?>



<html>
<link type="text/css" rel="stylesheet"  href="style.css"/>
<body>

       <div>
             <form name="userSignUp" method="post" action="signUp_action.php">
             <center>
                   <table border="0" width="600px" cellpadding="0" cellspacing="0" >
                   <tr>
                       <td><h1>User Registration</h1></td>
                       </tr>
                        <tr>
                       <td>
                                                                       
                                               

                    
                       
                      </td>
                       </tr>
                    <tr>
                       <td>User Name:
                       <input name="userName" type="text" id="userName" value="<?php if(isset($_POST['userName'])) echo $_POST['userName']; ?>"/>*
                       
                      </td>
                       </tr>
                      <br>
                      <tr>
                       <td>Email:
                       <input name="userEmail" type="text" id="userEmail" value="<?php if (isset($_POST['userEmail'])) echo $_POST['userEmail']; ?>"/>*
                       
                       </td>
                         
                    </tr>
                    <br>
                      <tr>
                       <td>Password:
                      <input type="password" name="userPassword1" value="">*
                       
                       </td>
                       
                    </tr>
                    <br>
                      <tr>
                       <td>Confirm Password:
                       <input type="password" name="userPassword2" value="">*
                       
                       </td>
                       
                    </tr>
                     <br>
                      <tr>
                       <td>
                       <input type="submit" name="submit" value="Submit"> <input type="reset"  
value="Reset">
                       
                       </td>
                       
                    </tr>
                   </table>
               </center>
              </form>
        </div>
</body>
</html>

.....................................................................................

Then i provide the form's required action.The name of page is signUp_action.php

.....................................................................................

signUp_action.php:


<?php
include("connect.php");


//.................................Variable default section...................................

    $userName=$_REQUEST['userName'];
    $userEmail=$_REQUEST['userEmail'];
       $userPassword1=$_POST['userPassword1'];
    $userPassword2=$_POST['userPassword2'];
    $password=md5($userPassword1);
     
   // .......................Email validation................................


   function isValidEmail($userEmail)
   {
      $pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";
     
      if (eregi($pattern, $userEmail))
      {
      return true;
      }
      else 
      {
      return false;
       
       }   
    }
   
   // .......................Error Message................................
  
              $error=false;
     $errorMessage="";
     
     if(empty($userName))
     {
      $error=true;
      $userNameError=true;
      $errorMessage.="PLease provide username.</br>";
     }
      if(empty($userEmail))
     {
      $error=true;
      $userEmailError=true;
      $errorMessage.="PLease provide email.</br>";
     }
     
           

      if($userPassword1=="")
      {
       $error=true;
       $userPassword1Error=true;
       $errorMessage.="PLease provide password.</br>"; 
       
      }
       /*if($userPassword1)
      {
       if(preg_match("/^.*(?=.{8,})(?=.*[a-z]+)(?=.*[^A-Za-z0-9])(?=.*[0-9\.\-\@\#\$\&]).*$/",$userPassword1))
   
            {   
                   $successMessage.= "Successfuly checked your password.U have to login now";
    
                       }
               {
         $error=true;
         $paswordValidationError=true;  
         $errorMessage.= "Please Enter"."<br />"."Atleast 8 character"."<br />"."Alpha numeric value"."<br />"."1 Special character";
         }
       }
     */
     if($userPassword1!=$userPassword2)
      {
       $error=true;
       $passwordMatchingError=true;
       $errorMessage.="Password does not match.</br>"; 
       
      }
     
     
     if(!isValidEmail($userEmail))
     {
      $error=true;
       $emailValidationError=true;
       $errorMessage.="Invalid email id.</br>"; 
     }
     
     
//..............................duplicate email check.........................................................
     
     
     $query = "SELECT userEmail FROM sign_up WHERE userEmail='" . $userEmail . "'";
     $result=mysql_query($query);
       
                     $loginFoundEmail = mysql_num_rows($result);
      if($loginFoundEmail)
         {
          $error=true;
            $loginFoundEmailError=true;
         $errorMessage.="User email is already in use.";
         }
     
     
//.............................Insert Data...............................

     if($error)
     
      {
     
       include("signUp.php");
      }
      else
      {
      
        $sql="insert into sign_up
       (
       userName,
       userEmail,
       password
       
       )
         values
         
       ('$userName','$userEmail','$password')
       ";
       
     
       $result=mysql_query($sql);
       if($sql)
       {
      
       $succes="Successfully inserted";
       ?>
                            <script language="javascript">
       window.location="message.php";
       </script>
                            <?php
       
       }
       
      }
  

    

    
?>

.....................................................................................

Here i create a page for message displaying after successful registration and redirects user to login page.

.....................................................................................

message.php:


<?php

session_start();
if(!session_is_registered(userName))
{
 ?>
    <script language="javascript">
 window.location="userLogin.php";
 </script>
    <?php
}
?>

<html>
<body>
Login Successful
</body>
</html>

Simple PHP project BY me

2010-07-02T22:49:00.000-07:00

Here i will try to build up a simple project step by step..........................................................................................................................................................................

Step 1: Create database connection in php & table sign_up

**.................................................................................**
Create database
**.................................................................................**

CREATE TABLE `sign_up` (
`id` int(20) NOT NULL auto_increment,
`userName` varchar(50) NOT NULL,
`userEmail` varchar(50) NOT NULL,
`password` varchar(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12346 ;

**...................................................................................**
connect.php
**...................................................................................**
<?php
mysql_connect("localhost", "root", "") or die ("Cannot connected database");
mysql_select_db("rakhi_database")or die ("Cannot connected db");

?>

What is Jquery?

2010-06-23T23:46:00.000-07:00

jQuery is a cross-browser JavaScript library designed to simplify the client-side scripting of HTML.[1] It was released in January 2006 at BarCamp NYC by John Resig. Used by over 27% of the 10,000 most visited websites, jQuery is the most popular JavaScript library in use today.

jQuery is free, open source software, dual-licensed under the MIT License and the GNU General Public License, Version 2.[ jQuery's syntax is designed to make it easier to navigate a document, select DOM elements, create animations, handle events, and develop Ajax applications. jQuery also provides capabilities for developers to create plugins on top of the JavaScript library. Utilizing these facilities, developers are able to create abstractions for low-level interaction and animation, advanced effects and high-level, theme-able widgets. This contributes to the creation of powerful and dynamic web pages.

Validation in PHP

2010-06-22T23:47:00.000-07:00

1.Create a from


<?php $securityCheck = new Security(); $securityCheck->UserIsLogin(); ?>

<div id="page_content" style="height:680px;">

<script language="JavaScript">
function doValidation(objForm)
{
//return ;
objFormValidation = new glbDataValidation(objForm);
if(objFormValidation.isFieldValid( 'name', ' Name ', ' Required, LengthMax=255 ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'fatherName', ' Father\'s Name ', ' Required, LengthMax=255 ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'motherName', ' Mother\'s Name ', ' Required, LengthMax=200 ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'presentAddress', ' Present Address ', ' Required, LengthMax=255 ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}

if(objFormValidation.isFieldValid( 'permanentAddress', ' Permanent Address ', ' Required, LengthMax=255 ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
/*if(objFormValidation.isFieldValid( 'passportNo', ' Passport No ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}*/
if(objFormValidation.isFieldValid( 'countryID', ' Country ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'gender', ' Gender ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'dateOfBirth', ' Date Of Birth ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
if(objFormValidation.isFieldValid( 'maritalStatus', ' Marital Status ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}
/*if(objFormValidation.isFieldValid( 'religion', ' Religion ', ' Required ' ))
{
objField = objFormValidation.getFieldObject();
objField.focus();
return objFormValidation.doErrorAlertPrompt();
}*/
/*if(document.getElementById('cUserPassword').value != document.getElementById('userPassword').value)
{
alert('Password Mismatch');
document.getElementById('cUserPassword').focus();
}*/
}
</script>

<?php
//$result_view=mysql_query("SELECT OWNER_ID FROM educations where OWNER_ID='$_SESSION[UserID]'");
//allreadyPost=mysql_num_rows($result_view);

$urlLeft = "";

if(!empty($_REQUEST['addMember']))
{
$urlLeft = "&addMember=yes&userID={$_REQUEST['userID']}";
}

if(!empty($_REQUEST['EmployeeID']))
{
//$title = "EDIT REFERENCE";
//$button = "Update";

$query = " SELECT *, SUBSTRING( HEIGHT, 1, 1 ) AS FEET, SUBSTRING( HEIGHT, -9, 2 ) AS INCHES
FROM employees WHERE USER_ID = {$_SESSION['UserID']} AND ISACTIVE = 1 AND EMPLOYEE_ID = {$_REQUEST['EmployeeID']}";
$employeePacket = SelectQuery($query);
$thisEmployeePacket = $employeePacket[0];
$urlLeft = "&EmployeeID={$thisEmployeePacket['EMPLOYEE_ID']}";
}
/*else
{
$title = "CREATE REFERENCE";
$button = "Insert";
}*/

// variable default section
$name = "";
if(!empty($thisEmployeePacket['NAME'])) $name = $thisEmployeePacket['NAME'];
if(!empty($_REQUEST['name'])) $name = $_REQUEST["name"];
$fatherName = '';
if(!empty($thisEmployeePacket['FATHER_NAME'])) $fatherName = $thisEmployeePacket['FATHER_NAME'];
if(!empty($_REQUEST['fatherName'])) $fatherName = $_REQUEST["fatherName"];
$motherName = '';
if(!empty($thisEmployeePacket['MOTHER_NAME'])) $motherName = $thisEmployeePacket['MOTHER_NAME'];
if(!empty($_REQUEST['motherName'])) $motherName = $_REQUEST["motherName"];
$presentAddress = '';
if(!empty($thisEmployeePacket['PRESENT_ADDRESS'])) $presentAddress = $thisEmployeePacket['PRESENT_ADDRESS'];
if(!empty($_REQUEST['presentAddress'])) $presentAddress = $_REQUEST["presentAddress"];
$permanentAddress = '';
if(!empty($thisEmployeePacket['PERMANENT_ADDRESS'])) $permanentAddress = $thisEmployeePacket['PERMANENT_ADDRESS'];
if(!empty($_REQUEST['permanentAddress'])) $permanentAddress = $_REQUEST["permanentAddress"];
$gender = '';
if(!empty($thisEmployeePacket['GENDER'])) $gender = $thisEmployeePacket['GENDER'];
if(!empty($_REQUEST['gender'])) $gender = $_REQUEST["gender"];
$dateOfBirth = '';
if(!empty($thisEmployeePacket['DATE_OF_BIRTH'])) $dateOfBirth = date('d-m-Y', strtotime($thisEmployeePacket['DATE_OF_BIRTH']));
if(!empty($_REQUEST['dateOfBirth'])) $dateOfBirth = date('d-m-Y', strtotime($_REQUEST["dateOfBirth"]));
$maritalStatus = '';
if(!empty($thisEmployeePacket['MARITAL_STATUS'])) $maritalStatus = $thisEmployeePacket['MARITAL_STATUS'];
if(!empty($_REQUEST['maritalStatus'])) $maritalStatus = $_REQUEST["maritalStatus"];
$religion = '';
if(!empty($thisEmployeePacket['RELIGION'])) $religion = $thisEmployeePacket['RELIGION'];
if(!empty($_REQUEST['religion'])) $religion = $_REQUEST["religion"];
$passportNo = '';
if(!empty($thisEmployeePacket['PASSPORT_NO'])) $passportNo = $thisEmployeePacket['PASSPORT_NO'];
if(!empty($_REQUEST['passportNo'])) $passportNo = $_REQUEST["passportNo"];
$countryID = '';
if(!empty($thisEmployeePacket['COUNTRY_ID'])) $countryID = $thisEmployeePacket['COUNTRY_ID'];
if(!empty($_REQUEST['countryID'])) $countryID = $_REQUEST["countryID"];
$heightFeet = '';
if(!empty($thisEmployeePacket['FEET'])) $heightFeet = $thisEmployeePacket['FEET'];
if(!empty($_REQUEST['heightFeet'])) $heightFeet = $_REQUEST["heightFeet"];
$heightInches = '';
if(!empty($thisEmployeePacket['INCHES'])) $heightInches = $thisEmployeePacket['INCHES'];
if(!empty($_REQUEST['heightInches'])) $heightInches = $_REQUEST["heightInches"];

// Set the error flags section
if(empty($error)) $error = false;
if(empty($errorMessage)) $errorMessage = "";

if(empty($nameError)) $nameError = false;
if(empty($fatherNameError)) $fatherNameError = false;
if(empty($motherNameError)) $motherNameError = false;
if(empty($presentAddressError)) $presentAddressError = false;
if(empty($permanentAddressError)) $permanentAddressError = false;
if(empty($passportNoError)) $passportNoError = false;
if(empty($countryIDError)) $countryIDError = false;
if(empty($genderError)) $genderError = false;
if(empty($dateOfBirthError)) $dateOfBirthError = false;
if(empty($religionError)) $religionError = false;
if(empty($maritalStatusError)) $maritalStatusError = false;

?>

<div align="center">
<?php if($error){?><div class="erroMessageLog"><ul><?php print $errorMessage;?></ul></div><?php }?>
<form name="step1Form" action="index.php?area=jobseeker&action=jobseeker-profile-action-step-1<?php echo $urlLeft;?>" method="post">
<table cellpadding="5" cellspacing="0" border="0" width="100%">
<tr>
<td align="left" class="resumeHeading">
<div>
» Personal Information </div> </td>
<td align="right" class="resumeHeading"><strong>Step-1</strong></td>
</tr>
<tr>
<td align="right"> </td>
<td align="left"> </td>
</tr>
<tr>
<td width="30%" align="right"><strong>Name :</strong></td>
<td align="left"><input type="text" name="name" value="<?php print $name;?>" style=" width:250px;" />
<?php if($nameError){ ?>
<span style="color:red;">* </span>
<?php }else{?>
<span>* </span> <?php } ?></td>
</tr>
<tr>
<td width="30%" align="right"><strong>Father's Name :</strong></td>
<td align="left"><input type="text" name="fatherName" value="<?php print $fatherName;?>" style=" width:250px;"><?php if($fatherNameError){ ?> <span style="color:red;">* </span> <?php }else{?> <span>* </span> <?php } ?></td>
</tr>
<tr>
<td width="30%" align="right"><strong>Mother's Name :</strong></td>
<td align="left"><input type="text" name="motherName" value="<?php print $motherName;?>" style=" width:250px;" />
<?php if($motherNameError){ ?> <span style="color:red;">* </span> <?php }else{?> <span>* </span> <?php } ?></td>
</tr>
<tr>
<td width="30%" align="right" valign="top"><strong>Present Address :</strong></td>
<td align="left"><span style="float:left;"><textarea name="presentAddress" rows="5" cols="15" class=" textarea" style=" width:250px;" ><?php print $presentAddress;?></textarea></span><?php if($presentAddressError){ ?> <span style="color:red;"> * </span> <?php }else{?> <span> * </span> <?php } ?></td>
</tr>
<tr>
<td width="30%" align="right" valign="top"><strong>Permanent Address :</strong></td>
<td align="left"><span style="float:left;"><textarea name="permanentAddress" rows="5" cols="15" class="textarea" style=" width:250px;"><?php print $permanentAddress;?></textarea></span><?php if($permanentAddressError){ ?> <span style="color:red;"> * </span> <?php }else{?> <span> * </span> <?php } ?></td>
</tr>
<tr>
<td width="30%" align="right" ><strong>Passport No. :</strong></td>
<td align="left"><input type="text" name="passportNo" value="<?php print $passportNo;?>" style=" width:250px;" ><?php if($passportNoError){ ?> <span style="color:red;">* </span> <?php }?></td>
</tr>
<tr>
<td width="30%" align="right"><strong>Nationality :</strong></td>
<td align="left">
<select type="text" name="countryID" style="width:253px; " class="inputText" >
<option value="">Select Country</option>

<?php
$query = " SELECT * FROM countrys WHERE 1 = 1 ORDER BY COUNTRY";
$countryPacket = SelectQuery($query);
foreach($countryPacket as $thisCountryPacket)
{
print "
<option value=\"{$thisCountryPacket['COUNTRY_ID']}\"
";
if($thisCountryPacket['COUNTRY_ID'] == $countryID) print " selected";

print ">{$thisCountryPacket['COUNTRY']}</option>
";
}
?>
</select><?php if($passportNoError){ ?> <span style="color:red;">* </span> <?php }else{?> <span> * </span> <?php } ?> </td>
</tr>
<tr>
<td align="right"><strong>Gender :</strong></td>
<td align="left">
<input type="radio" name="gender" value="Male" <?php if($gender == "Male") print "checked";?> />Male
<input type="radio" name="gender" value="Female" <?php if($gender == "Female") print "checked";?> />Female
<?php if($genderError){ ?> <span style="color:red;">* </span> <?php }else{?> <span> * </span> <?php } ?>
</td>
</tr>
<tr>
<td align="right"><strong>Date of Birth :</strong></td>
<td align="left">
<input type="text" name="dateOfBirth" value="<?php print $dateOfBirth;?>" readonly="readonly" size="10" style="width:250px" >
<img src="./skin/<?php echo $_REQUEST['skin']; ?>/images/calendar/cal.gif" width="16" height="16" alt="Pick a date" onClick="scwShow(scwID('dateOfBirth'),event);" style="cursor:pointer;"/>
<?php if($dateOfBirthError){ ?><span style="color:red;">* </span> <?php }else{?> <span> * </span> <?php } ?> </td>
</tr>
<tr>
<td align="right"><strong>Marital Status :</strong></td>
<td align="left">
<select name="maritalStatus" style="width:253px; " class="inputText" >
<option value="">Select</option>
<option value="Single" <?php if($maritalStatus == "Single") print "selected";?>>Single</option>
<option value="Married" <?php if($maritalStatus == "Married") print "selected";?>>Married</option>
<option value="Widowed" <?php if($maritalStatus == "Widowed") print "selected";?>>Widowed</option>
<option value="Divorced" <?php if($maritalStatus == "Divorced") print "selected";?>>Divorced</option>
<option value="Separated" <?php if($maritalStatus == "Separated") print "selected";?>>Separated</option>
</select><?php if($maritalStatusError){ ?> <span style="color:red;">* </span> <?php }else{?> <span> * </span> <?php } ?>
</td>
</tr>
<tr>
<td align="right"><strong>Height :</strong></td>
<td align="left">
<select name="heightFeet" class="inputText" style=" width:108px;">
<option value="">Select Feet</option>
<?php
for($i=3;$i<=8;$i++)
{
print "
<option value='{$i}'
";
if($heightFeet == $i) print "selected";
print">{$i}</option>
";
}
?>
</select> Feet
<select name="heightInches" class="inputText" style=" width:108px;">
<option value="0">Select Inches</option>
<?php
for($i=0;$i<=11;$i++)
{
print "
<option value='{$i}'
";
if($heightInches == $i) print "selected";
print">{$i}</option>
";

}
?>
</select> Inches </td>
</tr>
<tr>
<td align="right"><strong>Religion :</strong></td>
<td align="left">
<select name="religion" style="width:253px; " class="inputText" >
<option value="">Select Religion</option>
<option value="Islam" <?php if($religion == "Islam") print "selected";?>>Islam</option>
<option value="Hindu" <?php if($religion == "Hindu") print "selected";?>>Hindu</option>
<option value="Christian" <?php if($religion == "Christian") print "selected";?>>Christian</option>
<option value="Buddist" <?php if($religion == "Buddist") print "selected";?>>Buddist</option>
<option value="Others" <?php if($religion == "Others") print "selected";?>>Others</option>
</select>
<?php if($religionError){ ?> <span style="color:red;">*</span> <?php }?>
</td>
</tr>
<tr>
<td></td>
<td align="left">
<input type="hidden" value="<?php echo $urlLeft;?>" name="urlLeft">
<?php
if(!empty($_REQUEST['EmployeeID']))
{
?>
<input type="submit" value="Update" onclick="return doValidation(step1Form);" class="btton-details">
<?php
}
else
{
?>
<input type="submit" value="Next" onclick="return doValidation(step1Form);" class="btton-details">
<input type="submit" value="skip" name="skip" class="btton-details">
<?php
}
?>
</td>
</tr>
</table>
</form>
</div>
</div>

Javascript Validation

validation.js

// ************************************************************************
// * Begin Data Validation constructor
// ************************************************************************

function glbDataValidation(paramFormName){
/************************************************************
* Begin configure error message
************************************************************/
var REQUIRED = "The <fieldlabel> field is required";
var LENGTHMIN = "The <fieldlabel> field can not contain fewer than <length> characters.";
var LENGTHMAX = "The <fieldlabel> field can not contain more than <length> characters.";
var TEXTONLY = "The <fieldlabel> field must contain text only.";
var NUMONLY = "The <fieldlabel> field must contain only numbers.";
var NUMONLY_LT_MAXIMUM = "The <fieldlabel> field must be a number less than or equal to <maximum>.";
var NUMONLY_GT_MINIMUM = "The <fieldlabel> field must be a number greater than or equal to <minimum>.";
var ISMONEY = "The <fieldlabel> field must contain a numbers such as 200,000.00.";
var ISMONEY_DOLLARSIGN = "The <fieldlabel> field contains a dollar sign. Remove it and try again.";
var ISMONEY_LT_MAXIMUM = "The <fieldlabel> field must be a number less than or equal to <maximum>.";
var ISMONEY_GT_MINIMUM = "The <fieldlabel> field must be a number greater than or equal to <minimum>.";
var ISNUMFORMAT = "The <fieldlabel> field must contain only numbers.";
var ISNUMFORMAT_LT_MAXIMUM = "The <fieldlabel> field must be a number less than or equal to <maximum>.";
var ISNUMFORMAT_GT_MINIMUM = "The <fieldlabel> field must be a number greater than or equal to <minimum>.";
var ALPHACHARONLY = "The <fieldlabel> field must contain only letters from A-Z.";
var NOCHARONLY = "The <fieldlabel> field field must contain only letters from A-Z and numbers from 0-9";
var ISEMAIL = "The <fieldlabel> field contains an invalid email address\. Example: myname@domain\.com";
var COMPAREFIELD = "The <fieldlabel> does not confirm. Check the spelling then try again";
var ISUSERNAME = "The <fieldlabel> field is an invalid user name\.";
ISUSERNAME += "The <fieldlabel> accepts letters from A-Z, numbers from 0-9, \'_\', and \'-\'\.";
ISUSERNAME += "The <fieldlabel> must contain more than 4 and less than 30 characters\.";
var ISPASSWORD = "The <fieldlabel> field is an invalid password\.";
ISPASSWORD += " The field only accepts letters from A-Z, numbers from 0-9, \'_\', and \'-\'\.";
ISPASSWORD += " The field must contain more than 8 and less than 20 characters\.";

/************************************************************
* End configure error message
************************************************************/

/************************************************************
* Begin public methods
************************************************************/
this.isFieldValid = isFieldValid;
this.getErrorMessage = getErrorMessage;
this.doErrorAlertPrompt = doErrorAlertPrompt;
this.getFieldObject = getFieldObject;
this.isBlank = isBlank; // returns a true or false;
/************************************************************
* End public methods
************************************************************/

/************************************************************
* Begin create the form object if the client passes an object
* or an form name;
************************************************************/
var objForm = null;
if(typeof paramFormName == 'object'){ // if the client passes a form object
objForm = paramFormName;
} else { // if the user passes a form name
objForm = eval('document.'+paramFormName);
}
/************************************************************
* End create the form object if the client passes an object
************************************************************/

/************************************************************
* Begin variables/objects used by methods through out the component.
************************************************************/
var objField = null;
var strErrMessage = "";
/************************************************************
* End variables/objects used by methods through out the component.
************************************************************/

function getErrorMessage(){
return strErrMessage;
}

function doErrorAlertPrompt(){
alert(strErrMessage);
return false;
}

function setErrorMessage(msg){
strErrMessage = msg;
}

function getFieldObject(){
return objField;
}

function doErrorDetected(msg){
strErrMessage = msg;
blnErrorFlag = true;
}

function isBlank(s){ // This function is used to check for blank field
var checkchar = s.replace(/\s*\n*\t*\r*/g,'');
if (checkchar == ''){
return true;
} else {
return false;
}
}

function isFieldValid(frmFieldName,frmFriendlyName,frmValidate){
objField = eval('objForm'+'.'+frmFieldName);
blnErrorFlag = false;

// ************************************************************************
// * Begin prepare the field object variables use for validation
// ************************************************************************

var objTextProp = new Object();
objTextProp.frmFieldType = objField.type;

frmValidate = frmValidate.toLowerCase()

if(!objTextProp.frmFieldType){
objTextProp.frmFieldType = 'checked' ;
}
// ************************************************************************
// End prepare the field object variables use for validation
// ************************************************************************
// ************************************************************************
// *Begin Only Text, Textarea and Password fields can access the following code
// ************************************************************************

if (objTextProp.frmFieldType == 'text' || objTextProp.frmFieldType == 'textarea' ||
objTextProp.frmFieldType == 'password' || objTextProp.frmFieldType == 'hidden' ||
objTextProp.frmFieldType == 'file'){

if (blnErrorFlag == false && frmValidate.match(/required/g)){
if (isBlank(objField.value)){
msg = REQUIRED.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/lengthmin=\d*/g)){
var minlength = eval('"'+frmValidate.match(/lengthmin=\d*/g)+'"');
minlength = parseInt(minlength.match(/\d+/));
if (!isBlank(objField.value) && objField.value.length < minlength){
msg = LENGTHMIN.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',minlength);
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/lengthmax=\d*/g)){
var maxlength = eval('"'+frmValidate.match(/lengthmax=\d*/g)+'"');
maxlength = parseInt(maxlength.match(/\d+/));
if (!isBlank(objField.value) && objField.value.length > maxlength){
msg = LENGTHMAX.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',maxlength);
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/textonly/g)){
if (!isNaN(objField.value) && !isBlank(objField.value)){
msg = TEXTONLY.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}

// Begin only number validations
if (blnErrorFlag == false && frmValidate.match(/numonly/g)){
if (isNaN(objField.value.replace(/[\.]/g,'a')) && !isBlank(objField.value) ){
msg = NUMONLY.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}

if (!isNaN(objField.value.replace(/[\.]/g,'a'))
&& !isBlank(objField.value) ){
tmpMinMaxValue = frmValidate.match(/numonly\[[\d]+,[\d]+\]/g);

if(tmpMinMaxValue){
// Begin build the array
tmpMinMaxValue2 = ''+frmValidate.match(/numonly\[[\d]+,[\d]+\]/g);
tmpMinMaxValue2 = eval(tmpMinMaxValue2.replace(/numonly/,''));
tmpMinValue = tmpMinMaxValue2[0] // Min
tmpMaxValue = tmpMinMaxValue2[1] // Max
// End build the array

// Begin check to see if the developer has the number range correct.
// Else check the validation.
if(tmpMinValue > tmpMaxValue){
alert('Component Error: The Minimun can not greater that the Maximum');
return false;
// Begin check to see if the developer has the number range correct.

} else {
if(objField.value.replace(/[\.]/g,'a') < tmpMinValue){
msg = NUMONLY_GT_MINIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<minimum>',tmpMinValue);
doErrorDetected(msg);
} else if(objField.value.replace(/[\.]/g,'a') > tmpMaxValue){
msg = NUMONLY_LT_MAXIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<maximum>',tmpMaxValue);
doErrorDetected(msg);
}
}
}
}
}
// End only number validations

// Begin money format.
if (blnErrorFlag == false && frmValidate.match(/ismoney/g)){
if (isNaN(objField.value.replace(/[,$]/g,''))
&& !isBlank(objField.value)){
msg = ISMONEY.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
} else if(objField.value.match(/[$]/g)) {
msg = ISMONEY_DOLLARSIGN.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}

if (!blnErrorFlag){
tmpMinMaxValue = frmValidate.match(/ismoney\[[\d]+,[\d]+\]/g);

if(tmpMinMaxValue){
// Begin build the array
tmpMinMaxValue2 = ''+frmValidate.match(/ismoney\[[\d]+,[\d]+\]/g);
tmpMinMaxValue2 = eval(tmpMinMaxValue2.replace(/ismoney/,''));
tmpMinValue = tmpMinMaxValue2[0] // Min
tmpMaxValue = tmpMinMaxValue2[1] // Max
// End build the array

// Begin check to see if the developer has the number range correct.
// Else check the validation.
if(tmpMinValue > tmpMaxValue){
alert('Component Error: The Minimun can not greater that the Maximum');
return false;
} else {
// End check to see if the developer has the number range correct.

if(objField.value.replace(/[,$]/g,'') < tmpMinValue){
msg = ISMONEY_GT_MINIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<minimum>',tmpMinValue);
doErrorDetected(msg);
} else if(objField.value.replace(/[,$]/g,'') > tmpMaxValue){
msg = ISMONEY_LT_MAXIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<maximum>',tmpMinValue);
doErrorDetected(msg);
}
}
}
}
}
// End money format.

// Begin Number Format
if (blnErrorFlag == false && frmValidate.match(/isnumformat/g)){

if (isNaN(objField.value.replace(/[,]/g,''))
&& !isBlank(objField.value) ){
msg = ISNUMFORMAT.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}

if (!blnErrorFlag){
tmpMinMaxValue = frmValidate.match(/isnumformat\[[\d]+,[\d]+\]/g);

if(tmpMinMaxValue){
// Begin build the array
tmpMinMaxValue2 = ''+frmValidate.match(/isnumformat\[[\d]+,[\d]+\]/g);
tmpMinMaxValue2 = eval(tmpMinMaxValue2.replace(/isnumformat/,''));
tmpMinValue = tmpMinMaxValue2[0] // Min
tmpMaxValue = tmpMinMaxValue2[1] // Max
// End build the array

if(tmpMinValue > tmpMaxValue){
alert('Component Error: The Minimun can not greater that the Maximum');
return false;
} else {

if(objField.value.replace(/[,]/g,'') < tmpMinValue){
msg = ISNUMFORMAT_GT_MINIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<minimum>',tmpMinValue);
doErrorDetected(msg);
} else if(objField.value.replace(/[,]/g,'') > tmpMaxValue){
msg = ISNUMFORMAT_GT_MINIMUM.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<minimum>',tmpMaxValue);
doErrorDetected(msg);
}
}
}
}
}
//End Number Format
if (blnErrorFlag == false && frmValidate.match(/alphacharonly/g)){
if (objField.value.replace(/(([a-z])*)(([A-Z])*)/g,'') != ''
&& !isBlank(objField.value)){
msg = ALPHACHARONLY.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
if (blnErrorFlag == false && frmValidate.match(/nocharonly/g)){
if (eval(objField.value.replace(/(([a-z])*)(([A-Z])*)(\d*)/g,'')) != ''
&& !isBlank(objField.value)){
msg = NOCHARONLY.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
if (blnErrorFlag == false && frmValidate.match(/isemail/g)){
if (eval(objField.value.match(/\w@\w+\.\w{2,3}/g)) == null
&& !isBlank(objField.value)){
msg = ISEMAIL.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
if (blnErrorFlag == false && frmValidate.match(/comparefield/g)){
var txtFieldObject = eval('"'+frmValidate.match(/comparefield=\w*.\w*.\w*/g)+'"')
txtFieldObject = txtFieldObject.replace(/CompareField=/,'')
if (eval(objField.value) != eval(txtFieldObject+'.value')){
msg = COMPAREFIELD.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
if (blnErrorFlag == false && frmValidate.match(/isusername/g)){
if (
(
(objField.value.match(/[aA-zZ|0-9|_|-]+/g)
!= objField.value)
&& !isBlank(objField.value)
)
||
(
(objField.value.length < 4) || (objField.value.length > 30))
){
msg = ISUSERNAME.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
if (blnErrorFlag == false && frmValidate.match(/ispassword/g)){
if (
(
(objField.value.match(/[aA-zZ|0-9|_|-]+/g)
!= objField.value)
&& !isBlank(objField.value)
)
||
(
(objField.value).length < 8 || eval(objField.value.length > 20)
)
){
msg = ISPASSWORD.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}
}

// ************************************************************************
// *End Only Text, Textarea and Password fields can access the following code
// ************************************************************************

// ************************************************************************
// * Only OPTION fields can access the following code
// ************************************************************************
if (objTextProp.frmFieldType == 'select-multiple' || objTextProp.frmFieldType == 'select-one'){

if (blnErrorFlag == false && frmValidate.match(/required/g)){
var strSelectedValue = '';
var strSelectedLength = 0;
for (var i = 0; i < objField.length; i++) { // Loop through the selected items to create the strSelectedValue
if (objField.options[i].selected){
strSelectedValue = strSelectedValue += objField.options[i].value;
}
}

if (strSelectedValue == ''){
msg = REQUIRED.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/lengthmin=\d*/g)){
var strSelectedLength = 0;
var minlength = eval('"'+frmValidate.match(/lengthmin=\d*/g)+'"');
minlength = parseInt(minlength.match(/\d+/));
for (var i = 0; i < objField.length; i++) { // Loop through the selected items to create the strSelectedValue
if (objField.options[i].selected){
++strSelectedLength;
}
}

if (strSelectedLength < minlength){
msg = LENGTHMIN.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',minlength);
if(minlength == 1){
msg += ".";
} else {
msg += "s.";
}
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/lengthmax=\d*/g)){
var strSelectedLength = 0;
var maxlength = eval('"'+frmValidate.match(/lengthmax=\d*/g)+'"');
maxlength = parseInt(maxlength.match(/\d+/));

for (var i = 0; i < objField.length; i++) { // Loop through the selected items to create the strSelectedValue
if (objField.options[i].selected){
strSelectedLength = strSelectedLength+1;
}
}
if (strSelectedLength > maxlength ){
msg = LENGTHMAX.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',maxlength);
doErrorDetected(msg);
}
}
}
// ************************************************************************
// * End of Only OPTION fields can access the following code
// ************************************************************************

// ************************************************************************
// * Only radio and check box fields can access the following code
// ************************************************************************
if (objTextProp.frmFieldType == 'checked'){
if (blnErrorFlag == false && frmValidate.match(/required/g)){
var strSelectedValue = '';

for (i = 0, j = objField.length; i < j; i++) { // Loop through the selected items to create the strSelectedValue
if (objField[i].checked == true){
strSelectedValue = strSelectedValue += objField[i].value;
}
}

if (strSelectedValue == ''){
msg = REQUIRED.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
doErrorDetected(msg);
}

}

if (blnErrorFlag == false && frmValidate.match(/lengthmin=\d*/g)){
var strSelectedLength = 0
var minlength = eval('"'+frmValidate.match(/lengthmin=\d*/g)+'"');
minlength = parseInt(minlength.match(/\d+/));

for (i = 0, j = objField.length; i < j; i++) { // Loop through the selected items to create the strSelectedValue
if (objField[i].checked == true){
++strSelectedLength;
}
}

if (strSelectedLength < minlength){
msg = LENGTHMIN.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',minlength);
if(minlength == 1){
msg += ".";
} else {
msg += "s.";
}
doErrorDetected(msg);
}
}

if (blnErrorFlag == false && frmValidate.match(/lengthmax=\d*/g)){
var strSelectedLength = 0
var maxlength = eval('"'+frmValidate.match(/lengthmax=\d*/g)+'"');
maxlength = parseInt(maxlength.match(/\d+/));

for (i = 0, j = objField.length; i < j; i++) { // Loop through the selected items to create the strSelectedValue
if (objField[i].checked == true){
++strSelectedLength;
}
}

if (strSelectedLength > maxlength){
msg = LENGTHMAX.replace('<fieldlabel>',frmFriendlyName.toUpperCase());
msg = msg.replace('<length>',maxlength);
doErrorDetected(msg);
}
}
}
// ************************************************************************
// * End of only radio and check box fields can access the following code
// ************************************************************************

// Begn the return value sent back let the client know the field pass or failed
// the validation
return blnErrorFlag;
// End the return value sent back let the client know the field pass or failed
}

}

function Confirmit(mess) {
var confirmVar=confirm(mess);
return confirmVar;

}

// ************************************************************************
// * A new function added to check for valid dates
// ************************************************************************

function isDate(dateStr) {

var datePat = /^(\d{1,2})(\/|-)(\d{1,2})(\/|-)(\d{4})$/;
var matchArray = dateStr.match(datePat); // is the format ok?

if (matchArray == null) {
alert("Please enter date as either mm/dd/yyyy or mm-dd-yyyy.");
return false;
}

month = matchArray[1]; // p@rse date into variables
day = matchArray[3];
year = matchArray[5];

if (month < 1 || month > 12) { // check month range
alert("Month must be between 1 and 12.");
return false;
}

if (day < 1 || day > 31) {
alert("Day must be between 1 and 31.");
return false;
}

if ((month==4 || month==6 || month==9 || month==11) && day==31) {
alert("Month "+month+" doesn`t have 31 days!")
return false;
}

if (month == 2) { // check for february 29th
var isleap = (year % 4 == 0 && (year % 100 != 0 || year % 400 == 0));
if (day > 29 || (day==29 && !isleap)) {
alert("February " + year + " doesn`t have " + day + " days!");
return false;
}
}
return true; // date is valid
}

function isEuroDate(dateStr) {

var datePat = /^(\d{1,2})(\/|-)(\d{1,2})(\/|-)(\d{4})$/;
var matchArray = dateStr.match(datePat); // is the format ok?

if (matchArray == null) {
alert("Please enter date as either mm/dd/yyyy or mm-dd-yyyy.");
return false;
}

day = matchArray[1]; // p@rse date into variables
month = matchArray[3];
year = matchArray[5];

if (month < 1 || month > 12) { // check month range
alert("Month must be between 1 and 12.");
return false;
}

if (day < 1 || day > 31) {
alert("Day must be between 1 and 31.");
return false;
}

if ((month==4 || month==6 || month==9 || month==11) && day==31) {
alert("Month "+month+" doesn`t have 31 days!")
return false;
}

if (month == 2) { // check for february 29th
var isleap = (year % 4 == 0 && (year % 100 != 0 || year % 400 == 0));
if (day > 29 || (day==29 && !isleap)) {
alert("February " + year + " doesn`t have " + day + " days!");
return false;
}
}
return true; // date is valid
}

Badge

2010-06-22T00:44:00.001-07:00

The Best Collection of Bengali Songs

How to use pagination in php

2010-06-20T20:45:00.000-07:00

DESCRIPTION
--------------
This set contains 3 different pagination functions that can be easily implemented
into any other script to paginate the output results retrieved from MySQL database
or elsewhere. Note that these functions do not query the DB by theirselves, you
should previously have counted the total number of matches and retrieved the
appropriate results, specified number of results per page etc.

USAGE
---------
1. Upload the appropriate function script to the root folder on your server.
2. Open demo.php in any text editor to find out the inclusion code for the
appropriate function.
3. Paste the code into your scripts. Note that if you use other variable names
in your scripts, you will have to provide those names in function calling
code instead the specified ones.
4. Feel free to link to paginate.css file from your scripts to stylize the links.

Start Coding

Start Coding

1.demo.php

<?php
//pagination example code
$adjacents = intval($_GET['adjacents']);

if(!$page) $page = 1;
if(!$adjacents) $adjacents = 4;

$reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents;
?>
<html>
<head>
<title>Pagination Example</title>
<link rel="stylesheet" type="text/css" href="paginate.css">
</head>
<body>

<div align="center">
<p><b>Pagination DEMO</b></p>
<form action="<?=$_SERVER['PHP_SELF'];?>" method="get">
<table cellspacing="0" cellpadding="4">
<tr><th>Specify values for pagination test:</th></tr>
<tr><td>total pages: <input type="text" name="tpages" size="2" value="<?=$tpages;?>">,
adjacents: <input type="text" name="adjacents" size="2" value="<?=$adjacents;?>">
<input type="submit" value="Go"></td></tr>
</table>
</form>
<br>
<p><b>View Results for page <?=$page;?> of <?=$tpages;?> (adjacent pages: <?=$adjacents;?>)</b></p>
<p>paginate_one:</p>
<?php
include("pagination1.php");
echo paginate_one($reload, $page, $tpages);
?>
<br>
<p>paginate_two:</p>
<?php
include("pagination2.php");
echo paginate_two($reload, $page, $tpages, $adjacents);
?>
<br>
<p>paginate_three:</p>
<?php
include("pagination3.php");
echo paginate_three($reload, $page, $tpages, $adjacents);

?>
</div>

</body>
</html>

2.Attaching stylesheet pagination.css in demo.php

/* pagination style */
.pagin {
padding: 2px 0;
margin: 0;
font-family: "Verdana", sans-serif;
font-size: 7pt;
font-weight: bold;
}
.pagin * {
padding: 2px 6px;
margin: 0;
}
.pagin a {
border: solid 1px #666666;
background-color: #EFEFEF;
color: #666666;
text-decoration: none;
}
.pagin a:visited {
border: solid 1px #666666;
background-color: #EFEFEF;
color: #60606F;
text-decoration: none;
}
.pagin a:hover, .pagin a:active {
border: solid 1px #CC0000;
background-color: white;
color: #CC0000;
text-decoration: none;
}
.pagin span {
cursor: default;
border: solid 1px #808080;
background-color: #F0F0F0;
color: #B0B0B0;
}
.pagin span.current {
border: solid 1px #666666;
background-color: #666666;
color: white;
}

<?php
/*************************************************************************
php easy :: pagination scripts set - Version One
==========================================================================
********************/
function paginate_one($reload, $page, $tpages) {

$firstlabel = "First";
$prevlabel = "Prev";
$nextlabel = "Next";
$lastlabel = "Last";

$out = "<div class=\"pagin\">\n";

// first
if($page>1) {
$out.= "<a href=\"" . $reload . "\">" . $firstlabel . "</a>\n";
}
else {
$out.= "<span>" . $firstlabel . "</span>\n";
}

// previous
if($page==1) {
$out.= "<span>" . $prevlabel . "</span>\n";
}
elseif($page==2) {
$out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
}

// current
$out.= "<span class=\"current\">Page " . $page . " of " . $tpages . "</span>\n";

// next
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" .($page+1) . "\">" . $nextlabel . "</a>\n";
}
else {
$out.= "<span>" . $nextlabel . "</span>\n";
}

// last
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" . $tpages . "\">" . $lastlabel . "</a>\n";
}
else {
$out.= "<span>" . $lastlabel . "</span>\n";
}

$out.= "</div>";

return $out;
}
?>
<?php
/*************************************************************************
php easy :: pagination scripts set - Version Two
==========================================================================
*************************************************************************/
function paginate_two($reload, $page, $tpages, $adjacents) {

$firstlabel = "« ";
$prevlabel = "‹ ";
$nextlabel = " ›";
$lastlabel = " »";

$out = "<div class=\"pagin\">\n";

// first
if($page>($adjacents+1)) {
$out.= "<a href=\"" . $reload . "\">" . $firstlabel . "</a>\n";
}
else {
$out.= "<span>" . $firstlabel . "</span>\n";
}

// previous
if($page==1) {
$out.= "<span>" . $prevlabel . "</span>\n";
}
elseif($page==2) {
$out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
}

// 1 2 3 4 etc
$pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
$pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
for($i=$pmin; $i<=$pmax; $i++) {
if($i==$page) {
$out.= "<span class=\"current\">" . $i . "</span>\n";
}
elseif($i==1) {
$out.= "<a href=\"" . $reload . "\">" . $i . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . $i . "\">" . $i . "</a>\n";
}
}

// next
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" .($page+1) . "\">" . $nextlabel . "</a>\n";
}
else {
$out.= "<span>" . $nextlabel . "</span>\n";
}

// last
if($page<($tpages-$adjacents)) {
$out.= "<a href=\"" . $reload . "&page=" . $tpages . "\">" . $lastlabel . "</a>\n";
}
else {
$out.= "<span>" . $lastlabel . "</span>\n";
}

$out.= "</div>";

return $out;
}
?>

<?php
/*************************************************************************
php easy :: pagination scripts set - Version Three
==========================================================================
*************************************************************************/
function paginate_three($reload, $page, $tpages, $adjacents) {

$prevlabel = "‹ Prev";
$nextlabel = "Next ›";

$out = "<div class=\"pagin\">\n";

// previous
if($page==1) {
$out.= "<span>" . $prevlabel . "</span>\n";
}
elseif($page==2) {
$out.= "<a href=\"" . $reload . "\">" . $prevlabel . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . ($page-1) . "\">" . $prevlabel . "</a>\n";
}

// first
if($page>($adjacents+1)) {
$out.= "<a href=\"" . $reload . "\">1</a>\n";
}

// interval
if($page>($adjacents+2)) {
$out.= "...\n";
}

// pages
$pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
$pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
for($i=$pmin; $i<=$pmax; $i++) {
if($i==$page) {
$out.= "<span class=\"current\">" . $i . "</span>\n";
}
elseif($i==1) {
$out.= "<a href=\"" . $reload . "\">" . $i . "</a>\n";
}
else {
$out.= "<a href=\"" . $reload . "&page=" . $i . "\">" . $i . "</a>\n";
}
}

// interval
if($page<($tpages-$adjacents-1)) {
$out.= "...\n";
}

// last
if($page<($tpages-$adjacents)) {
$out.= "<a href=\"" . $reload . "&page=" . $tpages . "\">" . $tpages . "</a>\n";
}

// next
if($page<$tpages) {
$out.= "<a href=\"" . $reload . "&page=" . ($page+1) . "\">" . $nextlabel . "</a>\n";
}
else {
$out.= "<span>" . $nextlabel . "</span>\n";
}

$out.= "</div>";

return $out;
}
?>

Make website attractive using jquery

2010-06-18T02:48:00.000-07:00

Make website attractive using jquery:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>



</head>

<body>
<div><a href=""> Home</a></div>
<a href=""> Home</a></div>

<div id="divTopRight" style="position: absolute; left: 1122px; top: 10px;">
<div><img src="images/Untitled-1.png" /></div>



</div>

<script type="text/javascript">
var ns = (navigator.appName.indexOf("Netscape") != -1);
var d = document;
function JSFX_FloatDiv(id, sx, sy)
{
var el=d.getElementById?d.getElementById(id):d.all?d.all[id]:d.layers[id];
var px = document.layers ? "" : "px";
window[id + "_obj"] = el;
if(d.layers)el.style=el;
el.cx = el.sx = sx;el.cy = el.sy = sy;
el.sP=function(x,y){this.style.left=x+px;this.style.top=y+px;};

el.floatIt=function()
{
var pX, pY;
pX = (this.sx >= 0) ? 0 : ns ? innerWidth :
document.documentElement && document.documentElement.clientWidth ?
document.documentElement.clientWidth : document.body.clientWidth;
pY = ns ? pageYOffset : document.documentElement && document.documentElement.scrollTop ?
document.documentElement.scrollTop : document.body.scrollTop;
if(this.sy<0)
pY += ns ? innerHeight : document.documentElement && document.documentElement.clientHeight ?
document.documentElement.clientHeight : document.body.clientHeight;
this.cx += (pX + this.sx - this.cx)/8;this.cy += (pY + this.sy - this.cy)/8;
this.sP(this.cx, this.cy);
setTimeout(this.id + "_obj.floatIt()", 40);
}
return el;
}
JSFX_FloatDiv("divTopRight", -170, 10).floatIt();

</script>


</body>
</html>

Office picture: Me & my

2010-06-04T03:32:00.000-07:00

This is my office...me ,with kobir bhai & Sobuj da

Jquery links:It's very easy to apply jquery

2010-05-29T03:44:00.000-07:00

css tips:

Http://forums.devarticles.com/javascript-development-22/auto-refresh-parent-window-after-closing-popup-4864.html

http://www.instantshift.com/2010/03/15/47-css-tips-tricks-to-take-your-site-to-the-next-level/

dropdownmenu

http://www.lwis.net/free-css-drop-down-menu/

jquery

http://visionwidget.com/inspiration/web/295-jquery-content-sliders.html
http://www.malsup.com/jquery/corner/
http://blueprintds.com/2009/01/20/top-14-jquery-photo-slideshow-gallery-plugins/
http://spaceforaname.com/gallery-light.html

http://nettuts.s3.amazonaws.com/078_screencast2/jFlowTutorial/index.htm
http://demo.webdeveloperplus.com/featured-content-slider/
http://cssglobe.com/lab/easyslider1.5/04.html
http://nettuts.s3.amazonaws.com/377_slider/slider_sourcefiles/slider.html

Most attractive
http://css-tricks.com/examples/StartStopSlider/
http://devthought.com/wp-content/projects/mootools/barackslideshow/Demo/

HTML Layout
http://cssglobe.com/post/1415/3-simple-steps-in-coding-a-rounded-corners-layout

More Jquery
http://www.smashingmagazine.com/2009/01/15/45-new-jquery-techniques-for-a-good-user-experience/

Animated Button in Jquery
http://apycom.com/

Error messge in php

2010-05-23T21:24:00.000-07:00

Step 1: registration.php
lt;?PHP
if($_REQUEST['err']) {?gt;
lt;br /gt;
lt;div style="border:1px solid red;text-align:center;width:400px;margin:auto;color:red;"gt;
lt;?php echo $error=$_REQUEST['err']; ?gt;
lt;/divgt;

lt;?php } ?gt;

lt;?PHP
if($_REQUEST['succes']) {?gt;
lt;br /gt;
lt;div style="border:1px solid red;text-align:center;width:400px;margin:auto;color:red;"gt;
lt;?php echo $succes=$_REQUEST['succes']; ?gt;
lt;/divgt;

lt;?php } ?gt;

lt;/brgt;

lt;htmlgt;
lt;headgt;
lt;/headgt;
lt;bodygt;
lt;form action="registration_action.php" method="post"gt;
lt;centergt;
lt;divgt;
lt;font size=5gt;USER REGISTRATIONlt;/fontgt;
lt;brgt;
lt;font size=1gt;lt;supgt;*lt;/supgt; Required Fieldslt;/fontgt;
lt;brgt;
lt;input type="hidden" name="id"gt;
lt;brgt;
lt;bgt;First Namelt;supgt;*lt;/supgt;lt;/bgt;

lt;input type="text" name="firstName" size=15 maxlength=20gt;
lt;brgt;
lt;brgt;
lt;bgt;Last Namelt;supgt;*lt;/supgt;lt;/bgt;

lt;input type="text" name="lastName" size=15 maxlength=20gt;

lt;brgt;
lt;brgt;
lt;bgt;User Namelt;supgt;*lt;/supgt;lt;/bgt;

lt;input type="text" name="userName" size=15 maxlength=20gt;
lt;brgt;
lt;brgt;
lt;bgt;Passwordlt;supgt;*lt;/supgt;lt;/bgt;

lt;input type="password" name="password1" size=15 maxlength=20 style="margin-left:10px;"gt;
lt;brgt;
lt;brgt;
lt;bgt;Confirm Passwordlt;supgt;*lt;/supgt;lt;/bgt;
lt;input type="password" name="password2" size=15 maxlength=20gt;
lt;brgt;
lt;brgt;

lt;bgt;What music are you interested in?lt;/bgt;
lt;brgt;
lt;input type="checkbox" name="faveMusic[]"
value="Rock"gt;Rock
lt;input type="checkbox" name="faveMusic[]" value="Pop"gt;Pop
lt;input type="checkbox" name="faveMusic[]" value="Bluegrass"gt;Bluegrasslt;brgt;
lt;input type="checkbox" name="faveMusic[]" value="Blues"gt;Blues
lt;input type="checkbox" name="faveMusic[]" value="Jazz"gt;Jazz
lt;input type="checkbox" name="faveMusic[]" value="Country"gt;Countrylt;brgt;

lt;bgt;What u are?lt;/bgt;
lt;brgt;
lt;input type="radio" name="male_female" value="Male" checkedgt;Male

lt;input type="radio" name="male_female" value="Female" gt; Female
lt;brgt;
lt;brgt;
lt;input type="submit" name="submit" value="Submit"gt;
lt;input type="reset" value="Reset"gt;
lt;/divgt;

lt;/centergt;
lt;/formgt;

lt;/bodygt;
lt;/htmlgt;

Step 2. registration.php

lt;?php
if(isset($_REQUEST['submit']))
{
mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("registration") or die (mysql_error());

// Variable Section

$firstName=$_REQUEST['firstName'];
$lastName=$_REQUEST['lastName'];
$userName=$_REQUEST['userName'];
$password1=$_REQUEST['password1'];
$password2=md5($_REQUEST['password2']);
$faveMusic=$_REQUEST['faveMusic'];
$male_female=$_REQUEST['male_female'];

//Error Message
if(empty($firstName))
{
echo $error="Firstname Cannot be Empty";
}

else if(empty($lastName))
{
echo $error="Lastname Cannot Be Empty";
}

else if(empty($password1))
{
echo $error="Password Cannot Be Empty";
}
else if(empty($password2))
{
echo $error="Confirm Password Cannot Be Empty";
}

else if(empty($faveMusic))
{
echo $error="Music Cannot Be Empty";
}

else if(empty($male_female))
{
echo $error="male /female Cannot Be Empty";
}

if ($error==NULL)
{
//transfer to Mutliple Data in check box
$data="";
$data=implode("",$faveMusic);
$sql="INSERT into tbl_registration

VALUES

('','$firstName','$lastName','$email','$userName','$password1','$password2','$data','$male_female)";
$result=mysql_query($sql);
if($result)
{
$succes="Successfully inserted";
header("location:login.php");
}

?gt;

lt;body onLoad="document.form.submit();"gt;
lt;form name="form" method="post" action="registration.php?&succes=lt;?php echo $succes;?gt;"gt;
lt;/formgt;
lt;/bodygt;

lt;?php
}else{
?gt;
lt;body onLoad="document.form.submit();"gt;
lt;form name="form" method="post" action="registration.php?&err=lt;?php echo $error;?gt;"gt;
lt;/formgt;
lt;/bodygt;
lt;?php
}
}
?gt;

Registration,login & Email validation in php

2010-05-19T22:29:00.000-07:00

Step 1: insert.php

lt;?php
session_start();
echo $_SESSION['UNAME'];

?gt;

lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"gt;
lt;html xmlns="http://www.w3.org/1999/xhtml"gt;
lt;headgt;
lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /gt;
lt;titlegt;Untitled Documentlt;/titlegt;

lt;bodygt;

lt;?php echo $_REQUEST['err']; ?gt;
lt;table width="300" border="1" align="center" cellpadding="0" cellspacing="1"gt;
lt;trgt;
lt;tdgt;lt;form name="form1" method="post" action="insert_action.php" gt;
lt;table width="100%" border="0" cellspacing="1" cellpadding="3"gt;
lt;trgt;
lt;td colspan="3" align="center"gt;lt;stronggt;Registrationlt;/stronggt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td colspan="3" align="center"gt;lt;stronggt;
lt;?php
if($_SESSION['UNAME'])
{
?gt;
lt;a href="logout.php"gt;Logoutlt;/stronggt;lt;/agt;
lt;?php
}
else
{
?gt;
lt;a href="login.php"gt;Loginlt;/stronggt;lt;/agt;
lt;?php
}
?gt;

lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td width="71"gt;Namelt;/tdgt;
lt;td width="6"gt;:lt;/tdgt;
lt;td width="301"gt;lt;input name="name" type="text" id="name"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Lastnamelt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="lastname" type="text" id="lastname"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Emaillt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="email" type="text" id="email" gt;lt;/tdgt;
lt;/trgt;

lt;trgt;
lt;td colspan="3" align="center"gt;lt;input type="submit" name="Submit" value="Submit"gt;lt;/tdgt;
lt;/trgt;

lt;/tablegt;
lt;/formgt;
lt;/tdgt;
lt;/trgt;
lt;/tablegt;
lt;/bodygt;
lt;/htmlgt;

Step 2: insert_action.php
lt;?php
include("connect.php");

// get values from from

function isValidEmail($email){
$pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";

if (eregi($pattern, $email)){
return true;
}
else {
return false;
}
}

if ($_POST['Submit'])
{

$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email= $_REQUEST['email'];

if(!isValidEmail($email))
{
$err = "Invalid Email";

}

if($err==NULL)
{

$sql="INSERT INTO test_mysql(name,lastname,email)VALUES ( '$name','$lastname', '$email')";
$result=mysql_query($sql);
}
else

{
?gt;
lt;body onload="insertform.submit();"gt;
lt;form name="insertform" method="post" action="insert.php"gt;
lt;input type="hidden" name="err" value="lt;?php echo $err; ?gt;"
lt;/formgt;
lt;/bodygt;
lt;?php

}

}

// Insert data into mysql
if($result)
{
echo "Congratulations!Please login ";
echo "lt;BRgt;";
echo "lt;a href='login.php'gt;loginlt;/agt;";
echo "lt;BRgt;";

echo "lt;a href='list_records.php'gt;Click here to edit/deletelt;/agt;";
}

/*
{
echo "sorry ! U are not succesful";
}*/
mysql_close();
?gt;

Step 3: login.php

lt;htmlgt;
lt;bodygt;
lt;table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"gt;
lt;trgt;
lt;form name="form1" method="post" action="login_action.php"gt;
lt;tdgt;
lt;table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"gt;
lt;trgt;
lt;td colspan="3"gt;lt;stronggt;Member Login lt;/stronggt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td width="78"gt;namelt;/tdgt;
lt;td width="6"gt;:lt;/tdgt;
lt;td width="294"gt;lt;input name="uname" type="text" id="name"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Emaillt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="email" type="text" id="email"gt;lt;/tdgt;

lt;/trgt;
lt;trgt;
lt;tdgt; lt;/tdgt;
lt;tdgt; lt;/tdgt;
lt;tdgt;lt;input type="submit" name="Submit" value="Login"gt;lt;/tdgt;
lt;/trgt;
lt;/tablegt;
lt;/tdgt;
lt;/formgt;
lt;/trgt;
lt;/tablegt;
lt;/bodygt;
lt;/htmlgt;

Step 4: login_action.php

lt;?php
session_start();
include("connect.php");

// get value from from
$name=$_REQUEST['uname'];
$email=$_REQUEST['email'];
$id=$_REQUEST['id'];

/// To protect MySQL injection (more detail about MySQL injection)
$name = stripslashes($name);
$email = stripslashes($email);
$name = mysql_real_escape_string($name);
$email = mysql_real_escape_string($email);

$sql="SELECT * FROM test_mysql where name='$name' and email='$email' ";
$rs=mysql_query($sql);

$result = mysql_fetch_array($rs);

echo $result['name'];
echo $result['email'];

if($result['name']==$name && $result['email']==$email)
{

$_SESSION['UNAME']=$name;

header("location:list_records.php");

}
else
echo "Wrong Username or Password";

//$count=mysql_num_rows($result);
//if($count==1)
//{
//session_register='$name';
//session_register='$email';
//header:"location:success.php";

//}

//else {
//echo "Wrong Username or Password";
//}

?gt;

Session concept in php

2010-05-19T21:39:00.000-07:00

Step 1:Session concept in php

lt;?php
session_start();
echo $_SESSION['UNAME'];
// This function tests whether the email address is valid

?gt;
lt;?php
function isValidEmail($email){
$pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";

if (eregi($pattern, $email)){
return true;
}
else {
return false;
}
}
?gt;
lt;?php
if ($_POST['Submit'])
{

$emial= $_REQUEST['email'];

if(!isValidEmail($emial))
{
$err = "Invalid Email";

}

if (isValidEmail($_POST['email'])){
echo "lt;trgt;lt;tdgt;The email: ".$_POST['email']." is valid!lt;/tdgt;lt;/trgt;";
}
else{
echo "lt;trgt;lt;tdgt;The email: ".$_POST['email']." is invalid!lt;/tdgt;lt;/trgt;";
}
}
?gt;

lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"gt;
lt;html xmlns="http://www.w3.org/1999/xhtml"gt;
lt;headgt;
lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /gt;
lt;titlegt;Untitled Documentlt;/titlegt;

lt;bodygt;

lt;?php echo $err; ?gt;
lt;table width="300" border="1" align="center" cellpadding="0" cellspacing="1"gt;
lt;trgt;
lt;tdgt;lt;form name="form1" method="post" action="insert_action.php" gt;
lt;table width="100%" border="0" cellspacing="1" cellpadding="3"gt;
lt;trgt;
lt;td colspan="3" align="center"gt;lt;stronggt;Registrationlt;/stronggt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td colspan="3" align="center"gt;lt;stronggt;
lt;?php
if($_SESSION['UNAME'])
{
?gt;
lt;a href="logout.php"gt;Logoutlt;/stronggt;lt;/agt;
lt;?php
}
else
{
?gt;
lt;a href="login.php"gt;Loginlt;/stronggt;lt;/agt;
lt;?php
}
?gt;

lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td width="71"gt;Namelt;/tdgt;
lt;td width="6"gt;:lt;/tdgt;
lt;td width="301"gt;lt;input name="name" type="text" id="name"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Lastnamelt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="lastname" type="text" id="lastname"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Emaillt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="email" type="text" id="email" gt;lt;/tdgt;
lt;/trgt;

lt;trgt;
lt;td colspan="3" align="center"gt;lt;input type="submit" name="Submit" value="Submit"gt;lt;/tdgt;
lt;/trgt;

lt;/tablegt;
lt;/formgt;
lt;/tdgt;
lt;/trgt;
lt;/tablegt;
lt;/bodygt;
lt;/htmlgt;

Step 2:Session concept in php

lt;?php
include("connect.php");

// get values from from

$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];

// Insert data into mysql
$sql="INSERT INTO test_mysql(name,lastname,email)VALUES ( '$name','$lastname', '$email')";
$result=mysql_query($sql);
if($result)
{
echo "Congratulations!Please login ";
echo "lt;BRgt;";
echo "lt;a href='login.php'gt;loginlt;/agt;";
echo "lt;BRgt;";

echo "lt;a href='list_records.php'gt;Click here to edit/deletelt;/agt;";
}

/*
{
echo "sorry ! U are not succesful";
}*/
mysql_close();
?gt;

Step 3:Session concept in php

lt;htmlgt;
lt;bodygt;
lt;table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"gt;
lt;trgt;
lt;form name="form1" method="post" action="login_action.php"gt;
lt;tdgt;
lt;table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"gt;
lt;trgt;
lt;td colspan="3"gt;lt;stronggt;Member Login lt;/stronggt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;td width="78"gt;namelt;/tdgt;
lt;td width="6"gt;:lt;/tdgt;
lt;td width="294"gt;lt;input name="uname" type="text" id="name"gt;lt;/tdgt;
lt;/trgt;
lt;trgt;
lt;tdgt;Emaillt;/tdgt;
lt;tdgt;:lt;/tdgt;
lt;tdgt;lt;input name="email" type="text" id="email"gt;lt;/tdgt;

lt;/trgt;
lt;trgt;
lt;tdgt; lt;/tdgt;
lt;tdgt; lt;/tdgt;
lt;tdgt;lt;input type="submit" name="Submit" value="Login"gt;lt;/tdgt;
lt;/trgt;
lt;/tablegt;
lt;/tdgt;
lt;/formgt;
lt;/trgt;
lt;/tablegt;
lt;/bodygt;
lt;/htmlgt;

Step 4:Session concept in php

lt;?php
session_start();
include("connect.php");

// get value from from
$name=$_REQUEST['uname'];
$email=$_REQUEST['email'];
$id=$_REQUEST['id'];

/// To protect MySQL injection (more detail about MySQL injection)
$name = stripslashes($name);
$email = stripslashes($email);
$name = mysql_real_escape_string($name);
$email = mysql_real_escape_string($email);

$sql="SELECT * FROM test_mysql where name='$name' and email='$email' ";
$rs=mysql_query($sql);

$result = mysql_fetch_array($rs);

echo $result['name'];
echo $result['email'];

if($result['name']==$name && $result['email']==$email)
{

$_SESSION['UNAME']=$name;

header("location:list_records.php");

}
else
echo "Wrong Username or Password";

//$count=mysql_num_rows($result);
//if($count==1)
//{
//session_register='$name';
//session_register='$email';
//header:"location:success.php";

//}

//else {
//echo "Wrong Username or Password";
//}

?gt;

Step 5:Session concept in php

lt;?php
session_start();
echo $_SESSION['UNAME'];
include("connect.php");
//select query
$result = mysql_query("SELECT * FROM test_mysql");

?gt;
lt;table width="400" border="0" cellspacing="1" cellpadding="0"gt;
lt;trgt;
lt;tdgt;
lt;table width="400" border="1" cellspacing="0" cellpadding="3"gt;
lt;trgt;
lt;td colspan="4"gt;lt;stronggt;List data from mysql lt;/stronggt; lt;/tdgt;
lt;/trgt;
lt;?php
if($_SESSION['UNAME'])
{
?gt;
lt;a href="logout.php"gt;Logoutlt;/stronggt;lt;/agt;
lt;?php
}
else
{
?gt;
lt;a href="login.php"gt;Loginlt;/stronggt;lt;/agt;
lt;?php
}
?gt;
lt;trgt;
lt;td align="center"gt;lt;stronggt;Namelt;/stronggt;lt;/tdgt;
lt;td align="center"gt;lt;stronggt;Lastnamelt;/stronggt;lt;/tdgt;
lt;td align="center"gt;lt;stronggt;Emaillt;/stronggt;lt;/tdgt;
lt;td align="center"gt;lt;stronggt;Updatelt;/stronggt;lt;/tdgt;
lt;td align="center"gt;lt;stronggt;Deletelt;/stronggt;lt;/tdgt;
lt;/trgt;
lt;?php
while($rows=mysql_fetch_array($result)){
?gt;
lt;trgt;
lt;tdgt;lt;?php echo $rows['name']; ?gt;lt;/tdgt;
lt;tdgt;lt;?php echo $rows['lastname']; ?gt;lt;/tdgt;
lt;tdgt;lt;?php echo $rows['email']; ?gt;lt;/tdgt;
lt;td align="center"gt;lt;a href="update.php?id=lt;?php echo $rows['id']; ?gt;"gt;updatelt;/agt;lt;/tdgt;
lt;td align="center"gt;lt;a href="delete.php?id=lt;?php echo $rows['id']; ?gt;"gt;deletelt;/agt;lt;/tdgt;

lt;/trgt;
lt;?php
}
?gt;
lt;/tablegt;
lt;/tdgt;
lt;/trgt;
lt;/tablegt;
lt;?php
mysql_close();
?gt;

Pagination in php

2010-05-19T21:33:00.001-07:00

form.php

lt?php
$ColorID = "";
if(!empty($_REQUEST['ID'])) $ColorID = $_REQUEST['ID'];

if(!empty($_REQUEST['ID']))
{
$title = "EDIT COLOR";
$button = "Update";
$closeButton = "javascript:window.close();";

$query = " SELECT * FROM colors WHERE ColorID = '{$_REQUEST['ID']}' ";
$colorPacket = SelectQuery($query);
$thisColorPacket = $colorPacket[0];
}
else
{
$title = "ADD COLOR";
$button = "Insert";
$closeButton = "javascript:history.back();";
}

// variable default section
$colorCode = '';
if(!empty($thisColorPacket['ColorCode'])) $colorCode = $thisColorPacket['ColorCode'];
if(!empty($_REQUEST['colorCode'])) $colorCode = $_REQUEST["colorCode"];
$publish = '';
if(!empty($thisColorPacket['IsActive'])) $publish = $thisColorPacket['IsActive'];
if(!empty($_REQUEST['publish'])) $publish = $_REQUEST["publish"];

// Set the error flags section
if(empty($error)) $error = false;
if(empty($errorMessage)) $errorMessage="";

if(empty($colorCodeError)) $colorCodeError=false;
?gt
ltdiv align="center"gt
lt?php if($error && $errorMessage!=""){?gt
ltdiv class="erroMessage"gt
ltulgt
lt?php print " {$errorMessage}";?gt
lt/ulgt
lt/divgt
lt?php }?gt
lt!-- Build the interface --gt
ltform name="oColorInsertUpdateForm" action="lt?php echo $_SERVER['SCRIPT_NAME'];?gt?skin=admin&area=lt?php echo $_REQUEST['area']; ?gt&action=color-action" method="post"gt
ltfieldset class="fieldDesign3"gt
ltlegend class="legendDesign"gtlt?php echo $title;?gtlt/legendgt
lttable width="0" border="0" cellpadding="4" cellspacing="4" class="formtable"gt
lt?php
if(!empty($_REQUEST['message']))
{
print"
lttr valign=\"top\"gtlttd align=\"center\" colspan=\"2\" style=\"font-weight:bold;color:orange;\"gt{$_REQUEST['message']}
";
}
?gt

lt?php

// the interface for sitefontFamilyName
if($colorCodeError)
{
print "

lttrgtlttd style='color: red;'gtColor Codelt/tdgt
";
}
else
{
print "lttrgtlttdgtColor Codelt/tdgt";
}
print "lttdgtltinput name='colorCode' value='{$colorCode}' type='text' size='60' class='inputText2'gtltspan style='color:red;'gt*lt/spangtlt/tdgtlt/trgt";
?gt
lttrgt
lttdgtPublishlt/tdgt
lttdgt
ltselect name="publish" style="width:70px;" class='inputText2'gt
ltoption value="1" lt?php if($publish == 1) echo "Selected"; ?gtgtEnablelt/optiongt
ltoption value="0" lt?php if($publish == 0) echo "Selected"; ?gtgtDisablelt/optiongt
lt/selectgt
ltspan style="color:red;"gt*lt/spangt
lt/tdgt
lt/trgt
lt!-- the interface for insert, reset or cancel button --gt
lttr height="2"gtlttd colspan="2"gt lt/tdgtlt/trgt
lttrgt
lttdgt lt/tdgt
lttdgt
ltinput name="btnlt?php echo $button;?gt" type="submit" value="lt?php echo $button;?gt" class="inputBtn2"gt
ltinput name="btnReset" type="Reset" class="inputBtn2"gt
ltinput name="btnCancel" type="button" value="Cancel" onclick="lt?php echo $closeButton; ?gt" class="inputBtn2"gt
ltinput type="hidden" name="ID" value="lt?php echo $ColorID;?gt"gt
lt/tdgt
lt/trgt
lt/tablegt
lt/fieldset gt
lt/formgt
lt/divgt

2. select.php

lt?php
/* Set Default Variable */
if (empty($_REQUEST["startValue"])) $_REQUEST["startValue"] = 0;
if (empty($_REQUEST["limitValue"])) $_REQUEST["limitValue"] = 20;
if (empty($_REQUEST["OrderBy"])) $_REQUEST["OrderBy"] = "UserID";
if (empty($_REQUEST["Order"])) $_REQUEST["Order"] = "ASC";
if (empty($_REQUEST["publish"])) $_REQUEST["publish"] = "";

$colorCode = "";
if(!empty($_REQUEST['colorCode'])) $colorCode = $_REQUEST['colorCode'];
$publish = "";
if(!empty($_REQUEST['publish'])) $publish = $_REQUEST['publish'];

?gt

ltpgtltstronggt COLOR MANAGERlt/stronggtlt/pgt
lt!-- Starting the search interface --gt
ltform name="oColorCodeSearchForm" method="post" action="lt?php echo $_SERVER['SCRIPT_NAME']; ?gt?skin=admin&area=lt?php echo $_REQUEST['area']; ?gt&action=lt?php echo $_REQUEST['action']; ?gt"gt
ltpgtPlease select the desired options and press listlt/pgt
lttable width="100%" cellpadding="4" cellspacing="0" class="borderStyle" gt
lttr valign="top"gt
lttdgt
Color Code
ltinput name="colorCode" value="lt?php echo $colorCode;?gt" type="text" class="inputText2"gt
lt/tdgt
lttdgt
Publish
ltselect name="publish" class="inputText2"gt
ltoption value="" lt?php if(empty($publish)) echo "Selected";?gtgt lt/optiongt
ltoption value="1" lt?php if($publish == '1') echo "Selected";?gtgtEnablelt/optiongt
ltoption value="0" lt?php if($publish == '0') echo "Selected";?gtgtDisablelt/optiongt
lt/selectgt
lt/tdgt
lttd valign="middle"gt
Records Per Page lt/tdgt
lttd valign="middle"gt
ltselect name="limitValue" class="inputText2"gt
ltoption value="20" lt?php if($_REQUEST['limitValue'] == 20) echo "Selected";?gtgt20lt/optiongt
ltoption value="50" lt?php if($_REQUEST['limitValue'] == 50) echo "Selected";?gtgt50lt/optiongt
ltoption value="100" lt?php if($_REQUEST['limitValue'] == 100) echo "Selected";?gtgt100lt/optiongt
ltoption value="500" lt?php if($_REQUEST['limitValue'] == 500) echo "Selected";?gtgt500lt/optiongt
ltoption value="1000" lt?php if($_REQUEST['limitValue'] == 1000) echo "Selected";?gtgt1000lt/optiongt
lt/selectgt
lt/tdgt
lttd align="right"gtltinput type="Submit" name="btnSubmit" value="View List" class="inputBtn2"gt
lt/tdgt
lt/trgt
lt/tablegt
lt/formgt

lt!-- Do the search only if search button was clicked or show the entire list --gt
lt?php
if(!empty($_REQUEST['btnSubmit']) or true)
{
$query = " SELECT * FROM colors WHERE TRUE ";
if(!empty($_REQUEST['colorCode'])) $query.=" AND LOWER(ColorCode) LIKE LOWER('%{$_REQUEST['colorCode']}%') ";
if(!empty($_REQUEST['publish'])) $query.=" AND IsActive = {$_REQUEST['publish']} ";
$query.=" ORDER BY ColorID ";
//print $query;

$dataPacket = SelectQuery($query);
// Display the record
if($dataPacket != 0)
{
$records=count($dataPacket);
//print $records;
print "
lttable width='100%' border='0' cellspacing='2' cellpadding='4' class='borderStyle' bgcolor='#ffffff'gt
lttr valign='top'gt
lttd colspan='5'gt
lttable width='100%' cellspacing='0' cellpadding='0'gt
lttrgt
lttd align='left'gtList of Record(s)lt/tdgt
lttd align='right'gtTotal of ltstronggt{$records}lt/stronggt record(s) found.lt/tdgt
lt/trgt
lt/tablegt
lt/tdgt
lt/trgt
lttrgt
lttd colspan=4gtlt/tdgtlttd class='main_menu'gt
lta href='{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-form'gtADD NEWlt/agt
lt/tdgt
lt/trgt
lttr style='font-weight:bold;' bgcolor='#00CCFF'gt
lttdgt#lt/tdgt
lttdgtColor Codelt/tdgt
lttdgtCreatedlt/tdgt
lttdgtPublishlt/tdgt
lttd align='center'gtActionlt/tdgt
lt/trgt
";

$flag=false;
foreach($dataPacket as $thisPacket)
{
$url = "{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-form&ID={$thisPacket['ColorID']}";

if($thisPacket['IsActive']==1) $publish="Enable";
if($thisPacket['IsActive']==0) $publish="Disable";

if($flag)
{
$flag=false;
$color="#F7F7F7";
}
else
{
$flag=true;
$color="#EEEEEE";
}

print "
lttr valign='top' bgcolor='{$color}'gt
lttdgt". $thisPacket['ColorID'] ."lt/tdgt
lttdgt". ucwords($thisPacket['ColorCode']) ."lt/tdgt
lttdgt". $thisPacket['DateInserted'] ."lt/tdgt
lttdgt". $publish ."lt/tdgt
lttd align='center' class='main_menu'gt
lta href=\"javascript:popUp('{$url}');\" gtEDITlt/agt
lt/tdgt
lt/trgt
";

}
print "
lttrgt
lttd colspan='4' align='left' class='main_menu'gt
";
/* Start Paging */
$PageNo = 1;
$PageIncrement = 0;
$RowIncrement = $_REQUEST["limitValue"];
$ShowPage = ceil($records/$_REQUEST["limitValue"]);

$ShowstartValue = $_REQUEST["startValue"]+1;

print "Showing results {$ShowstartValue} - ";

if ($_REQUEST["limitValue"] gt $records)
print "{$records} of {$records}";
else
{
$viewValue = $_REQUEST["startValue"] + $_REQUEST["limitValue"];
if ($viewValue gt $records)
print "{$records} of {$records}";
else
print "{$viewValue} of {$records}";
}

print " ";

if($ShowstartValue gt 1)
{
//if(intval($_REQUEST["startValue"] + $RowIncrement) == $records)
//{
// $PreviousLink = $_REQUEST["startValue"];
//}
//else
//{
$PreviousLink = $_REQUEST["startValue"] - $RowIncrement;
//}
print "lta href=\"{$_SERVER['PHP_SELF']}?skin=admin&area={$_REQUEST['area']}&action=site-cat-select&startValue=$PreviousLink&limitValue=$RowIncrement\"gtPreviouslt/agt ";
}

$NextLink=$_REQUEST["startValue"] + $RowIncrement;
if(intval($records - $NextLink) lt $_REQUEST["limitValue"])
{
$RowIncrement = intval($records - $NextLink);
}
if($NextLink lt $records)
{

print "lta href=\"{$_SERVER['PHP_SELF']}?skin=admin&area={$_REQUEST['area']}&action=site-cat-select&startValue=$NextLink&limitValue=$RowIncrement\"gtNextlt/agt ";
$RowIncrement = $_REQUEST["limitValue"];
}
/* End Paging */
print "
lt/tdgt
lttd class='main_menu'gt
lta href='{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-form'gtADD NEWlt/agt
lt/tdgt
lt/trgt
lt/tablegt
";
}
else
{
print "
ltdiv style='padding-right:10px; text-align:right;'gt
Total of ltstronggt0lt/stronggt record found.
lta href='{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-form'gtADD NEWlt/agt
lt/divgt
";
}
}
?gt

action.php

lt?php
//Build the server side error check
$error = false;
$errorMessage = "";

// existance check
$table = "colors";
$column = "ColorCode";
$value = trim($_REQUEST['colorCode']);
//$column2 = "CategoryID";
//$value2 = trim($_REQUEST['categoryName']);
if(empty($_REQUEST['ID']) && !empty($_REQUEST['colorCode']))
{
$colorQuery = " SELECT * FROM $table WHERE $column='$value' OR $column='LOWER($value)'";
$colorResult=mysql_query($colorQuery);

if($colorResult != false)
{
$colorRecords = mysql_num_rows($colorResult);
if($colorRecords gt 0)
{
$error = true;
$colorCodeError = true;
$errorMessage.=" ltligtColor Code already exist.lt/ligt";
$thiscolorResult = mysql_fetch_array($colorResult);
if($thiscolorResult['IsActive'] == 0)
{
$errorMessage.=" ltligtPlease enable previous one.lt/ligt";
}
}
}
}
if($_REQUEST['colorCode'] == "")
{
$error = true;
$colorCodeError = true;
$errorMessage.=" ltligtColor Code cannot be empty.lt/ligt";
}

// back to insert user if error occurs
if($error)
{
include "color-form.php";
}
else
{
if(!empty($_REQUEST['ID']))
{
echo $query = "
UPDATE colors
SET
ColorCode = '" . trim($_REQUEST['colorCode']) . "',
IsActive = '" . trim($_REQUEST['publish']) . "',
UserIDUpdated = '" . trim($_SESSION["UserID"]) . "',
DateUpdated = '" . trim(date('Y-m-d H:m:s')) . "'
WHERE ColorID = '{$_REQUEST['ID']}'
";
}
else
{
echo $query = "
INSERT INTO colors
(
ColorCode,
IsActive,
UserIDInserted,
DateInserted
)
VALUES
(
'" . trim($_REQUEST['colorCode']) . "',
'" . trim($_REQUEST['publish']) . "',
'" . trim($_SESSION["UserID"]) . "',
'" . trim(date('Y-m-d H:m:s')) . "'
)
";
}
//exit;
//OperationQuery($query);

$url = "http://{$_SERVER['HTTP_HOST']}{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-select";
if(!empty($_REQUEST['ID']))
{
$url = "http://{$_SERVER['HTTP_HOST']}{$_SERVER['SCRIPT_NAME']}?skin=admin&area={$_REQUEST['area']}&action=color-form&ID={$_REQUEST['ID']}&message=Successfully updated";
}

print "
ltscript language='JavaScript'gt
lt!--
//window.location='$url';
//--gt
lt/scriptgt
";
}

?gt

insert ,update & delete script in php

2010-05-13T04:52:00.001-07:00

Table creation:

CREATE TABLE `test_mysql` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`lastname` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

Then creating our database connection called connect.php
<?php
mysql_connect("localhost", "$root", "")or die("cannot connect");
mysql_select_db("test")or die("cannot select DB");
?>

<span style="font-weight:bold;">step 1: insert data in mysql (insert.php)</span>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table width="300" border="1" align="center" cellpadding="0" cellspacing="1">
<tr>
<td><form name="form1" method="post" action="../rakhi_practice/insert_action.php">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3" align="center"><strong>Registration</strong></td>
</tr>
<tr>
<td width="71">Name</td>
<td width="6">:</td>
<td width="301"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td>Lastname</td>
<td>:</td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input name="email" type="text" id="email"></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>

<span style="font-weight:bold;">Step 2: insert_action.php</span>
<?php
include("connect.php");

// get values from from
$name=$_POST['name'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];
// Insert data into mysql
$sql="INSERT INTO test_mysql(name,lastname,email)VALUES ( '$name','$lastname', '$email')";
$result=mysql_query($sql);
if($result)
{
echo "Congratulations!Please login ";
echo "<BR>";

echo "<a href='list_records.php'>Click here to edit</a>";
}

/*
{
echo "sorry ! U are not succesful";
}*/
mysql_close();
?>

step 3:list_records.php

<?php
include("connect.php");
//select query
$result = mysql_query("SELECT * FROM test_mysql");

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
<td align="center"><strong>Update</strong></td>
<td align="center"><strong>Delete</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><?php echo $rows['name']; ?></td>
<td><?php echo $rows['lastname']; ?></td>
<td><?php echo $rows['email']; ?></td>
<td align="center"><a href="update.php?id=<?php echo $rows['id']; ?>">update</a></td>
<td align="center"><a href="delete.php?id=<?php echo $rows['id']; ?>">delete</a></td>

</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>
<span style="font-weight:bold;">step 4:update.php</span>

<?php
include("connect.php");

// get value of id that sent from address bar
$id=$_REQUEST['id'];

// Retrieve data from database
$result = mysql_query("SELECT * FROM test_mysql WHERE id='$id'");

$rows=mysql_fetch_array($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="../rakhi_practice/update_action.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td> </td>
<td colspan="3"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="name" type="text" value="<?php echo $rows['name']; ?>"></td>
<td align="center"><input name="lastname" type="text" value="<?php echo $rows['lastname']; ?>" size="15"></td>
<td><input name="email" type="text" value="<?php echo $rows['email']; ?>" size="15"></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<?php echo $rows['id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value="Submit"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?php

// close connection
mysql_close();

?>

step 5: Update_action.php</span>

<?php
include("connect.php");

$name =$_REQUEST['name'];
$lastname =$_REQUEST['lastname'];
$email =$_REQUEST['email'];
$id =$_REQUEST['id'];

// update data in mysql database
$sql="UPDATE test_mysql SET name='$name', lastname='$lastname', email='$email' WHERE id=".$id;
$result=mysql_query($sql);

// if successfully updated.
if($result)
{
echo "Thanks for update";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}
else
{
echo "ERROR";
}

?>

step 6: Delete.php
<?php
include("connect.php");

// get value of id that sent from address bar
echo $id=$_REQUEST['id'];

$name =$_REQUEST['name'];
$lastname =$_REQUEST['lastname'];
$email =$_REQUEST['email'];
$id =$_REQUEST['id'];

// Retrieve data from database
$result = mysql_query("SELECT * FROM test_mysql WHERE id='$id'");

$rows=mysql_fetch_array($result);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="delete_action.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td> </td>
<td colspan="3"><strong>Delete data </strong> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<tr>
<td> </td>
<td align="center"><input name="name" type="text" value="<?php echo $rows['name']; ?>"></td>
<td align="center"><input name="lastname" type="text" value="<?php echo $rows['lastname']; ?>" size="15"></td>
<td><input name="email" type="text" value="<?php echo $rows['email']; ?>" size="15"></td>
</tr>
<tr>
<td> </td>
<td><input name="id" type="hidden" id="id" value="<?php echo $rows['id']; ?>"></td>
<td align="center"><input type="submit" name="delete" value="delete"></td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?php

// close connection
mysql_close();

?>

step 7: delete_action.php
<?php
include("connect.php");

$id =$_REQUEST['id'];
$sql="DELETE from test_mysql WHERE id=".$id;
$result = mysql_query($sql);
if($sql)
{
echo "The record is deleted";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}
else
{
echo "ERROR";
}

?>

Strong Password using Javascript and PHP

2010-05-08T03:33:00.000-07:00

Php scripts in Strong password

2010-05-08T03:21:00.000-07:00

User Registration

$username=$_REQUEST['username'];
$password=$_REQUEST['userPassword'];
//$retype=$_REQUEST['retypePassword'];

if($_REQUEST['submit']=="login")
{
if($password)
{
if(preg_match("/^.*(?=.{8,})(?=.*[a-z]+)(?=.*[^A-Za-z0-9])(?=.*[0-9\.\-\@\#\$\&]).*$/",$password))

{
echo "Successfuly checked your password";

}
else
{
echo "Please Enter"."
"."Atleast 8 character"."
"."Alpha numeric value"."
"."1 Special character";
}
}

else
{
echo "Password field can not be empty";
}
}

?>

My friends

2010-03-07T22:39:00.000-08:00

my dear friend, i miss u all..........this is my first blog ..............so visit it..........