Friday 9 August 2013

Validate Form with HTML5

We can easily validate the form by html5

<form method="post" action="get-student-info.php" name="WtpForm" >  <table width="415" height="98" border="0"  bgcolor="#FFFFFF" align="center">       <tr>     <td height="40"  colspan="2"><div align="center">Student Information</div></td>   </tr>     <tr><td width="166" height="24"><strong>Name<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "name" type= "text" value="" required x-moz-errormessage="Enter your name" / ></td></tr><tr><td width="166" height="24"><strong>Father Name<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "fname" type= "text" value="" required x-moz-errormessage="Enter your Father name" / ></td></tr><tr><td width="166" height="24"><strong>Age<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "age" type= "number" value="" min="18" max="99" required x-moz-errormessage="Enter your Age" / ></td></tr><tr><td width="166" height="24"><strong>Gender<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "gender" type= "text" value="" required x-moz-errormessage="Enter your Gender" ></td></tr><tr><td width="166" height="24"><strong>Mobile No.<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "mobile" type= "text" value="" required x-moz-errormessage="Enter your Mobile Number"></td></tr><tr><td width="166" height="24"><strong>Email ID<font color="#FF0000">*</font></strong></td><td width="177"><input name="email" type="email" value="" required x-moz-errormessage="Enter your Email Id"/></td></tr><tr><td width="166" height="24"><strong>College Name<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "clgname" type= "text" value="" required x-moz-errormessage="Enter your College name" / ></td></tr><tr><td width="166" height="24"><strong>City<font color="#FF0000">*</font></strong></td><td width="177" ><input name= "city" type= "text" value="" required x-moz-errormessage="Enter your City name" / ></td></tr><td height="1" colspan="2"><div align="center">  <input type="submit" name="Submit" value="PRINT" ></div></td></tr>  </table>  <div align="center"></div>  <div align="center"></div></form>



Monday 24 June 2013

Validation for Mobile text Field by JavaScript


<script>
function Validate()
        {
           
            var y =document.getElementById("y").value;
 
            if(isNaN(y)||y.indexOf(" ")!=-1)
            {
              alert("Enter numeric value")
              return false;
           }
           if (y.length>10)
           {
                alert("enter 10 characters");
                return false;
           }
           return true;
        }
</script>

Tuesday 4 June 2013

Redirect to other page by dropdown list :

<?php
if (isset($_POST['nav'])) {
header("Location: $_POST[nav]");
}
?>
<script type="text/javascript">
$(function() {

    $("#submit").hide();

    $("#page-changer select").change(function() {
        window.location = $("#page-changer select option:selected").val();
    })

});
</script>
<h1 align="center"><strong>Search PAID Students Records</strong></h1>
<p align="center">&nbsp;</p>
<form name="form1" id="page-changer" action="" method="post">
    <div align="center"><strong>Select Your Option  &nbsp;&nbsp;&nbsp;&nbsp;</strong>
      <select name="nav">
  <option value="">Select Your Option...</option>
  <option value="paidstp.php">All Paid Students</option>
  <option value="paidlocation.php">Search Date & Location Wise</option>
</select>
      <input type="submit" value="Go" id="submit" />
    </div>
</form>

Search records by entering multiple fields

Search records by entering multiple fields 

<form name="form1" action="searchdrop2.php" method="post" onsubmit="return ValidateContactForm()"; >
<table width="533" height="108" border="0" bgcolor="#FFFF99">
<tr>
  <td width="210" height="31">
    <strong>BATCH DATE</strong></td><td width="313"><select name="term2" >
<option value="" >Select option</option>
<option value="22nd Apr 2013"  >22nd Apr 2013</option>
<option value="29th April 2013" >29th April 2013</option>
<option value="06th May 2013" >06th May 2013</option>
<option value="13th May 2013"  >13th May 2013</option>
<option value="20th May 2013" >20th May 2013</option>
<option value="27th May 2013" >27th May 2013</option>
<option value="03rd June 2013"  >03rd June 2013</option>
<option value="10th June 2013" >10th June 2013</option>
<option value="17th June 2013" >17th June 2013</option>
<option value="24th June 2013"  >24th June 2013</option>
<option value="01st July 2013" >01st July 2013</option>
<option value="08th July 2013" >08th July 2013</option>
 <option value="15th July 2013">15th July 2013</option>
</select></td></tr>

<tr>
<td height="24">
  <strong>PAID/UNPAID </strong></td><td><select name="term3" >
<option value="" >Select option</option>
<option value="PAID"  >Paid</option>
<option value="0 ">Unpaid</option>
</select></td>
</tr>
<tr>
<td height="24">
  <strong>SELECT LOCATION </strong></td><td><select name="term4" >
<option value="" >Select option</option>
<option value="Delhi"  >Delhi</option>
<option value="Noida" >Noida</option>
<option value="Gwalior" >Gwalior</option>
<option value="Haryana"  >Haryana</option>
<option value="Ahmedabad" >Ahmedabad</option>
<option value="Bangalore" >Bangalore</option>
<option value="Bhopal"  >Bhopal</option>
<option value="Chandigarh" >Chandigarh</option>
<option value="Chennai" >Chennai</option>
<option value="Dehradun"  >Dehradun</option>
<option value="Ghaziabad" >Ghaziabad</option>
<option value="Hyderabad" >Hyderabad</option>
<option value="Jaipur">Jaipur</option>
<option value="Kolkata">Kolkata</option>
<option value="Lucknow">Lucknow</option>
<option value="Mumbai">Mumbai</option>
<option value="Nagpur">Nagpur</option>
</select></td>
</tr>
<tr><td colspan="2">
  <div align="center">
    <input class="button" type="submit" name="submit" value="Search">
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <input class="button" type="reset" name="reset" value="Reset">
    
  </div></td>
  </tr>
</table>
</form>
php code


<table>
 <tr>
   <td align="center"><h1><strong>Details of Student</strong></h1></td>
 </tr>
 <tr>
   <td>
     <table width="524" height="55" border="1">
     <tr>
       <td width="59" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Name</strong></font></div></td>
            <td width="60" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>STP ID</strong></font></div></td>
       <td width="69" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Course Name</strong></font></div></td>
<td width="79" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Batch Date</strong></font></div></td>
            <td width="81" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Contact No.</strong></font></div></td>
            <td width="68" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Location</strong></font></div></td>
            <td width="62" bgcolor="#000000"><div align="center"><font color="#FFFFFF"><strong>Fee Status</strong></font></div></td>
         
     </tr>
<?php
include('config.php');
$term2=$_POST['term2'];
$term3=$_POST['term3'];
$term4=$_POST['term4'];

$query=mysql_query("SELECT * FROM tbltransaction WHERE batch_date='$term2' and status='$term3' and training_location='$term4'");
//$result=mysql_query($query);
$num=mysql_numrows($query);
$i=0;
while ($i < $num){
@$b_name=mysql_result($query,$i,"b_name");
@$refno=mysql_result($query,$i,"refno");
@$course_name=mysql_result($query,$i,"course_name");
@$batch_date=mysql_result($query,$i,"batch_date");
@$b_telephone=mysql_result($query,$i,"b_telephone");
@$training_location=mysql_result($query,$i,"training_location");
@$status=mysql_result($query,$i,"status");
echo "<tr><td> $b_name</td><td>RST/STP/$refno</td><td> $course_name</td><td>$batch_date</td><td>$b_telephone</td><td>$training_location</td><td>$status</td></tr>";

$i++;
}

?>
</table></td></tr></table>



Sunday 19 May 2013

To Prevent Copy, Cut and Paste into HTML Input Text Fields

If you want to prevent copy, paste and cut from the textbox the you should do like this....

<input type="text" name="name" id="name" onpaste="return false;" onCopy="return false" onCut="return false">  

Thursday 16 May 2013

Dynamic Dropdown list

<form>
 <table align="center" bgcolor="gray">
 <tr><td>State</td>
<td>
<select id="course_name" onChange="updateSecondSelection();">
<option value="0">Select your courses</option>
<option value="Andhra Pradesh">Andhra Pradesh</option>
<option value="Assam">Assam</option>
<option value="Arunachal Pradesh">Arunachal Pradesh</option>
<option value="Andaman and Nicobar Islands">Andaman and Nicobar Islands</option>
<option value="Bihar">Bihar</option>
<option value="Chhattisgarh">Chhattisgarh</option>
<option value="Delhi">Delhi</option>
<option value="Gujarat">Gujarat</option>
<option value="Goa">Goa</option>
<option value="Haryana">Haryana</option>
<option value="Himachal Pradesh">Himachal Pradesh</option>
<option value="Jammu and Kashmir">Jammu and Kashmir</option>
<option value="Jharkhand">Jharkhand</option>
<option value="Karnataka">Karnataka</option>
<option value="Kerala">Kerala</option>
<option value="Uttar Pradesh">Uttar Pradesh</option>
<option value="Uttarakhand">Uttarakhand</option>

</select></td>
</tr>
<tr>
<td>District</td>
<td>
<select id="training_location">
<option value="NA"></option>
</select>
<td></tr>
</table></form>
<script type="text/javascript" language="JavaScript">
function updateSecondSelection(){
var embeddedBasic = new Array('Hyderabad','Warangal');
var pcbBasic = new Array('Silchar','Guwahati','Golaghat','Nagaon','Sivasagar','Tezpur');
var arunanchalPradesh = new Array('Bubang','Changlang','Deban','Dharampur','Gandhigram','Jairampur','Rajanagar','Ranglum');
var andamanandNicobarIslands = new Array('');
var bihar = new Array('Patna','Gaya','Bhagalpur','Muzaffarpur','Purnia','Siwan','Motihari','Nawada','Buxar','Aurangabad');
var chhattisgarh = new Array('Raipur','Bilaspur','Rajnandgaon','Raigarh','Jagdalpur','Ambikapur','Dhamtari');
var delhi = new Array('New Delhi');
var gujarat = new Array('Ahmedabad','Surat','Surat','Rajkot','Rajkot','Jamnagar',' Junagadh','Gandhinagar','Nadiad','Morbi',' Surendranagar','Gandhidham','Godhra');
var goa = new Array('Goa');
var haryana = new Array('Faridabad','Gurgaon','Panipat','Yamunanagar','Rohtak','Hisar','Karnal','Sonipat','Panchkula','Bhiwani','Sirsa','Kurukshetra','Rewari');
var himachalPradesh = new Array('Chamba','Bharmaur','Masrur','Baijnath','Diyar','Khokhan','Manali','Simla');
var jammuandKashmir = new Array('Srinagar','Jammu','Anantanag');
var jharkhand = new Array('Dhanbad','Ranchi','Bokaro','Deoghar');
var karnataka = new Array('Bagalkot','Bangalore','Belgaum','Bellary','Bangalore','Mysore');
var kerala = new Array('Kakkanad','Painavu','Kannur','Palakkad');
var uttarPradesh = new Array('Agra','Aligarh','Allahabad',' Azamgarh','Bareilly','Basti','Chitrakoot','Gonda','Faizabad','Gorakhpur','Jhansi','Kanpur','Lucknow','Meerut','Mirzapur','Moradabad','Saharanpur','Varanasi');
var uttarakhand = new Array('Almora','Bageshwar','Chamoli ','Champawat','Dehradun','Haridwar','Nainital','Pauri','Pithoragarh','Rudraprayag','New Tehri','Rudrapur','Uttarkashi');

var course_name = document.getElementById('course_name');
var training_location = document.getElementById('training_location');
var selected = course_name.value;

/** Remove all options in second dropdown list selection **/
training_location.options.length=0;

if(selected=='Andhra Pradesh'){
for(node in embeddedBasic){
training_location.options[node] 
= new Option(embeddedBasic[node],embeddedBasic[node]);
}
}else if(selected=='Assam'){
for(node in pcbBasic){
training_location.options[node] 
= new Option(pcbBasic[node],pcbBasic[node]);
}
}else if(selected=='Arunachal Pradesh'){
for(node in arunanchalPradesh){
training_location.options[node] 
= new Option(arunanchalPradesh[node],arunanchalPradesh[node]);
}
}else if(selected=='Andaman and Nicobar Islands'){
for(node in andamanandNicobarIslands){
training_location.options[node] 
= new Option(andamanandNicobarIslands[node],andamanandNicobarIslands[node]);
}
}else if(selected=='Bihar'){
for(node in bihar){
training_location.options[node] 
= new Option(bihar[node],bihar[node]);
}
}else if(selected=='Chhattisgarh'){
for(node in chhattisgarh){
training_location.options[node] 
= new Option(chhattisgarh[node],chhattisgarh[node]);
}
}else if(selected=='Delhi'){
for(node in delhi){
training_location.options[node] 
= new Option(delhi[node],delhi[node]);
}
}else if(selected=='Gujarat'){
for(node in gujarat){
training_location.options[node] 
= new Option(gujarat[node],gujarat[node]);
}
}else if(selected=='Goa'){
for(node in goa){
training_location.options[node] 
= new Option(goa[node],goa[node]);
}
}else if(selected=='Haryana'){
for(node in haryana){
training_location.options[node] 
= new Option(haryana[node],haryana[node]);
}
}else if(selected=='Himachal Pradesh'){
for(node in himachalPradesh){
training_location.options[node] 
= new Option(himachalPradesh[node],himachalPradesh[node]);
}
}else if(selected=='Jammu and Kashmir'){
for(node in jammuandKashmir){
training_location.options[node] 
= new Option(jammuandKashmir[node],jammuandKashmir[node]);
}
}else if(selected=='Jharkhand'){
for(node in jharkhand){
training_location.options[node] 
= new Option(jharkhand[node],jharkhand[node]);
}
}else if(selected=='Karnataka'){
for(node in karnataka){
training_location.options[node] 
= new Option(karnataka[node],karnataka[node]);
}
}else if(selected=='Kerala'){
for(node in kerala){
training_location.options[node] 
= new Option(kerala[node],kerala[node]);
}
}else if(selected=='Uttar Pradesh'){
for(node in uttarPradesh){
training_location.options[node] 
= new Option(uttarPradesh[node],uttarPradesh[node]);
}
}else if(selected=='Uttarakhand'){
for(node in uttarakhand){
training_location.options[node] 
= new Option(uttarakhand[node],uttarakhand[node]);
}
}else{
training_location.options[0] = new Option('No option selected','NA');
}
}
</script>


Tuesday 14 May 2013

Forgot Password in php

First of all create the html file forget.htm


<form name='forget' action='forget.php' method='POST' onsubmit="return ValidateContactForm();">
<h1 align="center"><strong>Forget STP ID </strong></h1>
<table width="504" height="134" align="center" bgcolor="#FFFF66">
<tr>
  <td width="148" height="36"><div align="center"><strong>Enter Email ID<font color="#FF0000">*</font></strong></div></td><td width="344"><input type='text' id='b_email' name='b_email' size="40" ></td>
</tr>
<tr><td height="39" colspan="2"><div align="center">
  <input type='Submit' value='Submit'>
</div></td>
</tr>
</table>
</form>
now create forget.php


<?php
    // For Localhost connection
    define('USER','root');
    define('PASSWORD','');
    define('HOST','localhost');
    define('DATABASE','robo');
   
    $dbname = DATABASE;
    $dbc = @mysql_connect(HOST,USER,PASSWORD) or die('Could not connect to mysql '.mysql_error());
    @mysql_select_db(DATABASE) or die('Could not select the database '.mysql_error());
$b_email=$_POST['b_email'];
$query=mysql_query("SELECT * from tbltransaction where b_email='$b_email'");
@$b_name=mysql_result($query,0,"b_name");
@$refno=mysql_result($query,0,"refno");
@$course_name=mysql_result($query,0,"course_name");
@$batch_date=mysql_result($query,0,"batch_date");
echo "<tr><td> $b_name</td><td>RST/STP/$refno</td><td> $course_name</td><td>$batch_date</td></tr>";

?>
</table></td></tr></table>






Dropdown Box with lable



If you want to categorized your dropdown box data the you can do it as follow


 <td>Course Name :</td>
        <td><select name="course_name" id="course_name" onchange="getrate();" >
        <option selected="selected">-----------Select Course Name---------</option>
        <optgroup label="BASIC MODULE" style="padding-left: 10px;">
        <option value="Embedded System & Robotics - BASIC-Weekend">Embedded System & Robotics - BASIC / 2 Weeks</option>
          <option value="Image Processing using MatLab - BASIC-Weekend">Image Processing using MatLab - BASIC / 2 Weeks</option>
          <option value="PCB & Circuit Designing - BASIC-Weekend">PCB & Circuit Designing - BASIC / 2 Weeks</option>
          <option value="STAAD PRO for Civil Engg - BASIC-Weekend">STAAD PRO for Civil Engg - BASIC / 2 Weeks</option>
           <option value="Ethical Hacking - BASIC-Weekend">Ethical Hacking - BASIC / 2 Weeks </option>
          <option value="Android Applications- BASIC-Weekend">Android Applications - BASIC / 2 Weeks</option>
          <option value="3D Animation & MAX - BASIC-Weekend">3D Animation & MAX - BASIC / 2 Weeks</option>
          <option value="Web Designing - BASIC-Weekend">Web Designing - BASIC / 2 Weeks</option>
<optgroup label="ADVANCE MODULE" style="padding-left: 10px;">
 <option value="Embedded System & Robotics - ADVANCED-Weekend">Embedded System & Robotics - ADVANCED / 4 Weeks</option>
          <option value="Image Processing using MatLab - ADVANCED-Weekend">Image Processing using MatLab - ADVANCED / 4 Weeks </option>
          <option value="PCB & Circuit Designing - ADVANCED-Weekend">PCB & Circuit Designing - ADVANCED / 4 Weeks</option>
          <option value="STAAD PRO for Civil Engg - ADVANCED-Weekend">STAAD PRO for Civil Engg - ADVANCED / 4 Weeks</option>
</optgroup>
<optgroup label="ULTRA MODULE" style="padding-left: 10px;">
<option value="Embedded System & Robotics - ULTRA-Weekend">Embedded System & Robotics - ULTRA / 6 Weeks</option>
          <option value="Image Processing using MatLab - ULTRA-Weekend">Image Processing using MatLab - ULTRA / 6 Weeks</option>    
          <option value="PCB & Circuit Designing - ULTRA-Weekend">PCB & Circuit Designing - ULTRA / 6 Weeks</option>
          <option value="STAAD PRO for Civil Engg - ULTRA-Weekend">STAAD PRO for Civil Engg - ULTRA / 6 Weeks</option>
</optgroup>
</optgroup>
</select>