Increase your programming skills with android and backend for software designing, development, learning and updates
Saturday, 15 October 2016
Saturday, 1 October 2016
how to make login page using session kookies mysql all in one
How to make a login page using mysql , session , cookies , in php
itis is a very simple method see below
<head>
<?php
session_start();
mysql_connect("localhost","root","");
mysql_select_db("form");
if (isset($_POST["btn"])){
$email = $_POST["n3"];
$password = $_POST["n4"];
if (isset($_POST["btn"])){
setcookie("email",$em,time()+60);
setcookie("password",$pa,time()+60);
}
$q = "select * from submit where email = '$email' && password ='$password' ";
$sr = mysql_query($q);
$num = mysql_num_rows($sr);
if($num > 0){
$row = mysql_fetch_array($sr);
if ($row["email"] == $email && $row ["password"] == $password ) {
$_SESSION ["useremail"] = $email;
header("location:dashboard.php");
}
}
}
?>
</head>
<body>
<div class="wraper" >
<div class="logout">
<p align="center"> <a href="">LOGOUT</a></p>
</div>
<div class="header">
<div class="menu">
<form method="post" ><b><h2><pre>
email : <input type="email" name="n3" /><br />
Password : <input type="password" name="n4" /><br />
<input type="submit" name="btn" value="submit" />
<a href="">forget password</a>
</pre> </h2>
</b></form>
</div>
</div>
</div>
</body>
itis is a very simple method see below
<head>
<?php
session_start();
mysql_connect("localhost","root","");
mysql_select_db("form");
if (isset($_POST["btn"])){
$email = $_POST["n3"];
$password = $_POST["n4"];
if (isset($_POST["btn"])){
setcookie("email",$em,time()+60);
setcookie("password",$pa,time()+60);
}
$q = "select * from submit where email = '$email' && password ='$password' ";
$sr = mysql_query($q);
$num = mysql_num_rows($sr);
if($num > 0){
$row = mysql_fetch_array($sr);
if ($row["email"] == $email && $row ["password"] == $password ) {
$_SESSION ["useremail"] = $email;
header("location:dashboard.php");
}
}
}
?>
</head>
<body>
<div class="wraper" >
<div class="logout">
<p align="center"> <a href="">LOGOUT</a></p>
</div>
<div class="header">
<div class="menu">
<form method="post" ><b><h2><pre>
email : <input type="email" name="n3" /><br />
Password : <input type="password" name="n4" /><br />
<input type="submit" name="btn" value="submit" />
<a href="">forget password</a>
</pre> </h2>
</b></form>
</div>
</div>
</div>
</body>
Thursday, 29 September 2016
Latest HTML, CS6 Tutorials Learning free ONLINE and DOWNLOAD: image raspberry pi board with raspberry camera usi...
Latest HTML, CS6 Tutorials Learning free ONLINE and DOWNLOAD: image raspberry pi board with raspberry camera usi...: image raspberry pi board with raspberry camera element used 1 ) raspberry pi3 board 2 ) raspberry camera 3 ) charger ...
image raspberry pi board with raspberry camera using various element
element used
1 ) raspberry pi3 board
2 ) raspberry camera
3 ) charger
4 ) HDMI port
5 ) Menory
6 ) Box
Wednesday, 28 September 2016
beautiful registration page designing with codes
beautiful registration page designing with css,html and php codes
body{
margin:0px 0px 0px 0px;
}
.header{
background-color:#000;
height:100%;
width:55%;
position:fixed;
border:#F00 thin solid;
margin-left:300px;
}
.logo{
background-color:#F93;
height:50px;
width:98.4%;
border:#F93 6px solid;
border-radius:2px;
}
.menu{
margin-top:0px;
height:auto;
border:#000 thin solid;
}
input{
height:25px;
width:315px;
border:#FFF thin solid;
border-radius:5px;
padding-left:10px;
}
.option{
height:30px;
width:315px;
border:#FFF thin solid;
border-radius:5px;
}
.select,.option2{
height:25px;
width:110px;
border:#FFF thin solid;
border-radius:5px;
}
.option1{
height:25px;
width:60px;
border:#FFF thin solid;
border-radius:5px;
}
.gender input ,.gender1 input{
height:15px;
width:15px;
border:#FFF thin solid;
}
.footer{
background-color:#F93;
height:50px;
width:98.4%;
border:#F93 6px solid;
border-radius:2px;
margin-top:-38px;
}
.submit input{
height:30px; width:70px;
border: #F60 thin solid;
}
.submit{
margin-top:10px;
float:right;
height:30px; width:15s0px;
border: #F93 thin solid;
float:right;
}
</style>
<body>
<div class="header">
<div class="logo">
<h2> <b><a href="" style="color:#FF0">Sign Up</a></b></h2>
</div>
<div class="menu">
<form method="post">
<h3>
<pre><ul style="color:#FF0">
First Name <input type="text" name="n1" /><br />
Last Name <input type="text" name="n2" /><br />
Screen Name <input type="text" name="n3" /><br />
Date of Birtt <select class="select" name="n4">
<option value="jan"> January </option>
<option value="fbb">feb</option>
<option value="mar">mar</option>
<option value="apr">apr</option>
<option value="may">may</option>
<option value="jum">jun</option>
<option value="jul">jul</option>
<option value="aug">aug</option>
<option value="sep">sep</option>
<option value="oct">oct</option>
<option value="nov">nov</option>
<option value="dec">dec</option>
</select> <select class="option1" name="n5">
<option value="1"> 1</option>
<option value="2">2</option>
<option value="3" >3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
</select> <select class="option2" name="n6">
<option value="1993"> 1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
</select><div class="gender">
Gender <input type="radio" name="n7" value="M" >Male <input type="radio" name="n7" value="F">Female</div>
Country <select class="option" name="n8">
<option value="Afghanistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antartica">Antarctica</option>
<option value="Antigua and Barbuda">Antigua and Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba">Aruba</option>
<option value="Australia">Australia</option>
<option value="Austria">Austria</option>
</select>
E-mail <input type="email" name="n9" /><br/>
Phone <input type="text" name="n10" /><br/>
Password <input type="password" name="n11" /><br/>
Conform Password <input type="password" name="n12" /><br/><ul class="gender1">
<input type="checkbox" name="n13" value="checkbox"/>I agree to The Terms of Use</ul><br/>
</ul></pre></h3></div>
<div class="footer">
<div class="submit">
<input type="submit" name="btn" value="submit" style="background-color:#060"/> <input type="reset" name="cancel" value="cancel" style="background-color:#C00"/>
</div>
</div></form>
</div>
<?php
mysql_connect("localhost","root","");
mysql_select_db("php");
if(isset($_POST["btn"])){
$name = $_POST["n1"];
$lastname = $_POST["n2"];
$screenname = $_POST["n3"];
$birthday = $_POST["n4"];
$birthday1 = $_POST["n5"];
$birthday2 = $_POST["n6"];
$gender = $_POST["n7"];
$country = $_POST["n8"];
$email = $_POST["n9"];
$phone = $_POST["n10"];
$password = $_POST["n11"];
$confpassword = $_POST["n12"];
if(isset( $_POST["n13"])){
$condition1 = $_POST["n13"];
}
else{
$condition = "";
}
$qeury = "insert into my (name,lastname,screenname,birthday,birthday1,birthday2,gender,country,email,phone,password,confpassword, condition1) values ('$name','$lastname', '$screenname', '$birthday', '$birthday1', '$birthday2', '$gender', '$country','$email', '$phone', '$password', '$confpassword', '$condition')";
if(!mysql_query($qeury))
{
mysql_error();
}
echo"welcome";
}
?>
</body>
Friday, 23 September 2016
HOW TO CREAT DELETE DATA USING MYSQL IN PHP
HOW TO CREAT DELETE DATA USING MYSQL IN PHP
<head>
<?php
mysql_connect("localhost","root","");
mysql_select_db("exam");
if(isset($_REQUEST['del'])){
$id = $_REQUEST['del'];
$delete = " delete from result where id = '$id' ";
$q = mysql_query ($delete);
};
$qr = " select * from result";
$rs = mysql_query($qr);
$num= mysql_num_rows($rs);
?>
</head>
<body>
<table border="1">
<tr>
<td>name</td>
<td>last name</td>
<td>father's name</td>
<td>email</td>
<td>password</td>
<td>phone</td>
<td>gender</td>
<td>address</td>
<td>nationality</td>
<td>country</td>
<td>delete</td>
</tr>
<?php
if ($num > 0){
while($row = mysql_fetch_array($rs)){
?>
<tr>
<td> <?php echo $row['name']; ?> </td>
<td> <?php echo $row['lastname']; ?></td>
<td><?php echo $row['father']; ?></td>
<td> <?php echo $row['email']; ?> </td>
<td><?php echo $row['password']; ?></td>
<td><?php echo $row['phone']; ?></td>
<td> <?php echo $row['gender']; ?> </td>
<td><?php echo $row['address']; ?></td>
<td> <?php echo $row['nationality']; ?> </td>
<td> <?php echo $row['country']; ?> </td>
<td><a href="exam select delete.php?del=<?php echo $row['id'];?>"> delete</a> </td>
</tr>
<?php }} ?>
</table>
</body>
Tuesday, 20 September 2016
HOW TO CREAT UPTATE USING MYSQL IN PHP
HOW TO CREAT UPTATE USING MYSQL IN PHP
using MYSQL creat and update database in php
<?php
//database connection
mysql_connect("localhost","root","");
//database selection
mysql_select_db("exam");
$q = "select * from result";
$rs = mysql_query($q);
$num = mysql_num_rows($rs);
//$row = mysql_fetch_array($rs);
?>
<body>
<table border="1" cellspacing="1">
<tr>
<td>Name</td>
<td>Password</td>
</tr>
<?php if ($num > 0){ while($row = mysql_fetch_array($rs)){?>
<tr>
<td><?php echo $row['Name'];?></td>
<td><a href="update.php?upt=<?php echo $row['id']; ?>">update</a></td>
</tr>
<?php }}?>
</table>
<form method="post">
<table border="1" cellspacing="1">
<?php
if(isset($_REQUEST['upt'])){
if(isset($_POST['btn'])){
$Name = $_POST['Name'];
$id = $_REQUEST['upt'];
$q = "update result set Name='$Name' where id ='$id'";
$rs = mysql_query($q);
}
$id = $_REQUEST['upt'];
$sel = "select * from result where id = '$id'";
$rs1 = mysql_query($sel);
while($row = mysql_fetch_array($rs1)){?>
<tr>
<td>Name</td>
</tr>
<tr>
<td><input type="text" value="<?php echo $row['Name'];?>" name="Name" /></td>
<td><input type="submit" name="btn" value="click here"/></td>
</tr>
<?php }} ?>
</table>
</form>
</body>
Sunday, 18 September 2016
Full registration form using MysQl insert data in simple method
*---Full registration form using MysQl insert data ----*
<?php
mysql_connect("localhost","root","");
mysql_select_db("exam");
if (isset($_POST["submit"])){
$name = $_POST['n1'];
$lastname = $_POST['n2'];
$father = $_POST['n3'];
$email = $_POST['n4'];
$password = $_POST['n5'];
$phone= $_POST['n6'];
$gender = $_POST['n7'];
$address = $_POST['n8'];
$nationality = $_POST['n9'];
$country = $_POST['n10'];
if(isset($_POST['n9'])){
$nationality = $_POST['n9'];
}
else{
$nationality = "";
}
$q = " insert into result(name,lastname,father,email,password,phone,gender,address,nationality,country) values ('$name','$lastname','$father','$email','$password','$phone','$gender','$address','$nationality','$country')";
$rs = mysql_query($q);
echo"submmite sussfully";
}
?>
<body>
<form method="post"><pre>
name<input type="text" name="n1" /><br />
last name<input type="text" name="n2" /><br />
father's name<input type="text" name="n3" /><br />
email<input type="email" name="n4" /><br />
password<input type="password" name="n5" /><br />
phone<input type="number" name="n6" /><br />
gender<input type="radio" name="n7" value="m"/>M<input type="radio" name="n7" value="f"/>F<br />
address<input type="text" name="n8" /><br />
nationality<input type="checkbox" name="n9" value ="india"/>Iinian<input type="checkbox" name="n9" value="other"/>Other<br />
country<select name="n10">
<option value="india">india</option>
<option value="nepal">nepal</option>
<option value="america">america</option>
<option value="other">other</option>
</select>
<br />
<input type="submit" name="submit" value="submit"/>
</form></pre>
</body>
<?php
mysql_connect("localhost","root","");
mysql_select_db("exam");
if (isset($_POST["submit"])){
$name = $_POST['n1'];
$lastname = $_POST['n2'];
$father = $_POST['n3'];
$email = $_POST['n4'];
$password = $_POST['n5'];
$phone= $_POST['n6'];
$gender = $_POST['n7'];
$address = $_POST['n8'];
$nationality = $_POST['n9'];
$country = $_POST['n10'];
if(isset($_POST['n9'])){
$nationality = $_POST['n9'];
}
else{
$nationality = "";
}
$q = " insert into result(name,lastname,father,email,password,phone,gender,address,nationality,country) values ('$name','$lastname','$father','$email','$password','$phone','$gender','$address','$nationality','$country')";
$rs = mysql_query($q);
echo"submmite sussfully";
}
?>
<body>
<form method="post"><pre>
name<input type="text" name="n1" /><br />
last name<input type="text" name="n2" /><br />
father's name<input type="text" name="n3" /><br />
email<input type="email" name="n4" /><br />
password<input type="password" name="n5" /><br />
phone<input type="number" name="n6" /><br />
gender<input type="radio" name="n7" value="m"/>M<input type="radio" name="n7" value="f"/>F<br />
address<input type="text" name="n8" /><br />
nationality<input type="checkbox" name="n9" value ="india"/>Iinian<input type="checkbox" name="n9" value="other"/>Other<br />
country<select name="n10">
<option value="india">india</option>
<option value="nepal">nepal</option>
<option value="america">america</option>
<option value="other">other</option>
</select>
<br />
<input type="submit" name="submit" value="submit"/>
</form></pre>
</body>
Friday, 16 September 2016
how o used insert query
how o used insert query
<?php
mysql_connect("localhost","root","");
mysql_select_db("php1");
if (isset($_POST["n6"])){
$name = $_POST["n"];
$surname = $_POST["n1"];
$email = $_POST["n3"];
$password = $_POST["n4"];
$hobyes = $_POST["n5"];
$address = $_POST["n2"];
$q = "insert into hobyes (name, surname, email, password, hobyes, address ) values ('$name', '$surname', '$email', '$password', '$hobyes', '$address')";
mysql_query($q);
echo"welcome";
}
?>
<?php
mysql_connect("localhost","root","");
mysql_select_db("php1");
if (isset($_POST["n6"])){
$name = $_POST["n"];
$surname = $_POST["n1"];
$email = $_POST["n3"];
$password = $_POST["n4"];
$hobyes = $_POST["n5"];
$address = $_POST["n2"];
$q = "insert into hobyes (name, surname, email, password, hobyes, address ) values ('$name', '$surname', '$email', '$password', '$hobyes', '$address')";
mysql_query($q);
echo"welcome";
}
?>
<body>
<div class="header" align="center" >
<div class="menu" >
<form action="" method="POST"><pre style="color:#FF0"><b>
<table border="1">
Name<input type="text" name="n" /><br />
Sur name<input type="text" name="n1" /><br />
E-mail<input type="email" name="n3" /><br />
Password<input type="password" name="n4" /><br />
Hobyes<input type="radio" name="n5" value="circket"/>circket<input type="radio" name="n5" value="chess" />chess<br />
Address<textarea name="n2"></textarea>
<br />
<input type="submit" name="n6" value="submit" />
</table>
</form></b></pre>
</div>
</div>
</body>
Monday, 12 September 2016
How to used basic Insert query in input field
How to used basic Insert query in input field
<head>
<?php
// database connection
mysql_connect("localhost","root","");
//database sel
mysql_select_db("php");
if(isset($_POST["n1"])){
$name = $_POST["n"];
$address = $_POST["n3"];
$email = $_POST["n2"];
$password = $_POST["n5"];
$q = "insert into advanc_ephp (name, address, email, password) value ('$name', '$address', '$email', '$password')";
mysql_query($q);
echo'<h3 align="center">registration sussessfully</h3>';
}
?>
</head>
<body>
<form action="" method="post" ><pre>
name<input type="text" name="n" />
address<input type="text" name="n3" />
email<input type="email" name="n2" />
password<input type="password" name="n5" />
<input type="submit" name="n1" value="submit" />
</pre>
</form>
</body>
<head>
<?php
// database connection
mysql_connect("localhost","root","");
//database sel
mysql_select_db("php");
if(isset($_POST["n1"])){
$name = $_POST["n"];
$address = $_POST["n3"];
$email = $_POST["n2"];
$password = $_POST["n5"];
$q = "insert into advanc_ephp (name, address, email, password) value ('$name', '$address', '$email', '$password')";
mysql_query($q);
echo'<h3 align="center">registration sussessfully</h3>';
}
?>
</head>
<body>
<form action="" method="post" ><pre>
name<input type="text" name="n" />
address<input type="text" name="n3" />
email<input type="email" name="n2" />
password<input type="password" name="n5" />
<input type="submit" name="n1" value="submit" />
</pre>
</form>
</body>
Subscribe to:
Posts (Atom)






