Gadgets

Monday, 29 December 2014

Conform Password with client side validation



Conform Password with client side validation

In this article I explained that, HTML Conform password with client side validation. Here in this form I taken password and conform password, here I taken password pattern, that password should be  a-z,A-Z,0-9 and password length is between 8 to 30 letters.




<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<form action=""method="post">
<table align="center">
<tr><td>Password :</td><td><input type="password" name="psw"  pattern="[a-zA-Z0-9 ]{8,30}"tabindex="1"class="input-box"onchange="this.setCustomValidity(this.validity.patternMismatch ? 'Password contain at least 8 charecters':'');if(this.checkValidity())form.cpsw.pattern=this.value"required/></td></tr>
<tr><td>Conform Password :</td><td><input type="password" pattern="[a-zA-Z0-9 ]{8,30}"name="cpsw"  tabindex="2"class="input-box"onchange="this.setCustomValidity(this.validity.patternMismatch ? 'Please enter same password as above':'');"required/></td></tr>
<tr><td></td><td><input type="submit" value="SignUp" tabindex="3"/></td></tr>
</table>
</form>
</body>
</html>


HTML Login form with validation

Password :
Conform Password :

HTML Login form with validation



HTML Login form with validation
In this article I explained that, HTML Login form with client side validation. Here in this form I taken email id and password, in this form we should give the correct email id pattern otherwise it will not take wrong email id pattern and here I taken password pattern, that password should be  a-z,A-Z,0-9 and password length is between 8 to 30 letters.



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<form action="" method="post">
<table align="center">
<tr><td>Email id :</td><td><input type="email"name="eid" pattern="^[_\.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+\.)+[a-zA-Z]{2,6}$" tabindex="1"required /></td></tr>
<tr><td>Password :</td><td><input type="password"name="psw" tabindex="2" pattern="[a-zA-Z0-9 ]{8,30}"required/></td></tr>
<tr><td></td><td><input type="submit" value="SignIn"tabindex="3"/></td></tr>
</table>
</form>
</body>
</html>
Email id :
Password :

Get the check box values from database in php


Get the check box values from database in php

This program teaches you how to get the multiple checkbox values, dropdown select option values and radio button values from database using PHP. By using this program we can get the values into HTML Form from Database. This article is easy to understand and I hope it will help you.



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
include “database_connection.php”;
$sql= mysql_query("select * from studentinfo where studentname”narendar”");
$row = mysql_fetch_array($sql);
$sname=$row[“studentname”];
$fname=$row[“fathername”];
$gender=$row[“gender”];
$sub  = explode(“,”,$row[“subjects”]);
$country=$row[“country”];
?>
<form action=""method="post">
<h3 align="center">Edit Information</h3>
<table border="1" cellpadding="2" cellspacing="2" align="center"><tr>
<td>Student Name :</td><td><input type="text" name="sname" value="<?echo $sname;?>"></td></tr>
<tr><td>Father Name:</td><td><input type="text" name="fname" value="<?echo $fname;?>"></td></tr>
<tr><td>Gender:</td><td><input type="radio" name="gender" value="male"
<?php echo ($gender==”male”)?"checked":"" ;?>>Male &nbsp;
<input type="radio" name="gender" value="female"
<?php echo ($gender==”female”)?"checked":"" ;?>>Female</td></tr>
<tr><td>Subjects:</td><td>
<?
if(in_array("maths",$sub))
echo “<input type="checkbox" name="subjects[]" value="maths" checked>Maths <br>”;
else
echo “<input type="checkbox" name="subjects[]" value="maths">Maths <br>”;
if(in_array("science",$sub))
echo “<input type="checkbox" name="subjects[]" value="science"checked>Science <br>”;
else
echo “<input type="checkbox" name="subjects[]" value="science">Science <br>”;
if(in_array("computers",$sub))
echo “<input type="checkbox" name="subjects[]" value="computers"checked>Computers <br>”;
else
echo “<input type="checkbox" name="subjects[]" value="computers">Computers <br>”;
if(in_array("english",$sub))
echo “<input type="checkbox" name="subjects[]" value="english"checked>English “;
else
echo “<input type="checkbox" name="subjects[]" value="english">English”;
?>
</td></tr>
<tr>
<td>Country:</td>
<td>
<select name="country">
<option disabled selected><?echo $country;?></option>
<option  >----select----</option>
<option>India</option>
<option>Japan</option>
<option>USA</option>
</select>
</td>
</tr>
<tr><td></td>
<td><input type="submit" name="submit" value="Update"></td>
</tr>
</table>
</form>
</body>
</html>

Friday, 19 December 2014

Insert Checkbox Values into MySQL Using PHP



Insert Checkbox Values into MySQL Using PHP

This article teaches you how to insert HTML form multiple checkbox values,dropdown select option values and radio button values into MySQL database using PHP. This article is easy to understand and I hope it will help you. 
<html>
<head>
<title>Student Registration</title>
</head>
<body>
<?php
include "database_connection.php";
if(isset($_POST["submit"])){
$sname  =   $_POST["sname"];
$fname  =   $_POST["fname"];
$gender =   $_POST["gender"];
$subjects    =   implode(",",$_POST["subjects"]);
$country    =   $_POST["country"];
$sql    =   "INSERT INTO  `studentinfo`(`studentname`,`fathername`,`gender`,`subjects`,`country`)
values("$sname","$fname","$gender","$subjects","$country")";
$query  =   mysql_query($sql) or die(mysql_error());
if
($query){
echo "<h1>Data inserted successful.....</h1>";
}else{
echo "<h1>Please Try again.....</h1>";
}
}
?>
<form name="registration" method="post" action="">
<table border="1" cellpadding="2" cellspacing="2" align="center">
<tr>
<td>Student Name :</td><td><input type="text" name="sname" required=""></td>
</tr>
<tr>
<td>Father Name:</td><td><input type="text" name="fname" required=""></td>
</tr>
<tr>
<td>Gender:</td><td><input type="radio" name="gender" value="male" required="">Male &nbsp;
<input type="radio" name="gender" value="female" >Female</td></tr>
<tr>
<td>Subjects:</td><td><input type="checkbox" name="subjects[]" value="maths">Maths &nbsp;<br>
<input type="checkbox" name="subjects[]" value="science">Science &nbsp; <br>
<input type="checkbox" name="subjects[]" value="computers">Computers &nbsp; <br>
<input type="checkbox" name="subjects[]" value="english">English &nbsp;</td></tr>
<tr><td>Country:</td>
<td><select name="country">
<option >----select----</option>
<option>India</option>
<option>Japan</option>
<option>USA</option>
</select></td></tr>
<tr><td></td>
<td><input type="submit" name="submit" value="Register"></td>
</tr>
</table>
</form>
</body>
</html>






Get the check box values from database in php