Droncaps latest news: November 2017

Monday 20 November 2017

1. How to check in signup form your email address is already exist in php.......
१ आपका email address already exist है या नहीं चेक by php.....

<?php
if(isset($_POST['submit1'])){
$email = $_POST['email1'];
$sql21="SELECT * FROM `user_register` WHERE `email1`='".$email."'";
$query21=$mysqli->query($sql21);
$row21=mysqli_fetch_array($query21);
if($row21['email1']==$_POST['email1']){
echo "<script>alert('this user already exist');</script>";
echo "<script>window.location.href='user_signup.php';</script>";
}
else{

$name = $_POST['name1'];
$email = $_POST['email1'];
$password = $_POST['password1'];
$gender = $_POST['gender1'];
$dob =$_POST['dob1'];
$select=$_POST['select1'];
$file =$_FILES['file1'];
$image_name=$file['name'];//image name
$destination="image/".$image_name;
if(move_uploaded_file($file['tmp_name'] ,$destination)){}

$cat = "INSERT INTO `user_register` (`name1`,`email1`,`password1`,`gender1`,`dob1`,`select1`,`file1`) VALUES('$name','$email','$password','$gender','$dob','$select','$image_name')";
$dog=$mysqli->query($cat);

if($dog){
echo '<script type="text/javascript">alert("signup successful")</script>';
echo '<script type="text/javascript">window.location.href="index.php";</script>';
}
else
{
echo "error";
}
}
}

?>

Friday 17 November 2017

how to id pass from current page to another page in php progrms...?
एक पेज से दूसरे page par move करे by id in php ..... program?

<?php
$sql1="SELECT * FROM `table_name` where `id`='".id."';
$query1=$mysqli->query($sql1);
$row=mysqli_fetch_array($query1);

?>
<a href="exam_question1.php?id=<?php echo $row['id'];?>" >next page</a>

Thursday 16 November 2017

Hii guy today i explain you how to aply delete query in our php program and delete data from data base ?
दोस्तों आज में आपको बताऊंगा की किस प्रकार डाटा बेस से डाटा delete कर सकते है php program me...?

<?php
include "connection.php";

$id=$_GET['id'];

$sql="DELETE FROM `user_register` WHERE `id`='$id'";

$query=$mysqli->query($sql);

if($query){

echo "delete succfully";

}

else {

echo "error";

}

Sunday 12 November 2017

<!DOCUTYPE html>
<link href="css/bootstrap.css" rel="stylesheet" type="text/css"/>
<link href="css/bootstrap-theme.css" rel="stylesheet" />
<script src="js/bootstrap.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.14.0/jquery.validate.js"></script> 
<link rel="stylesheet" type="text/css" href="css/decoration1.css">

</html>

Saturday 4 November 2017

how to timer start in php by using a simple javascript code

2. How to timer start in oline quies test by using javascript code who easily write code.
<html>
<body>
<div id="start"></div>
</body>
</html>

\\--->

<script type="text/javascript">
var total_seconds = 5*1;
var c_minutes=parseInt(total_seconds/60);
var c_seconds=parseInt(total_seconds%60);
var min=zerowork(c_minutes);
var sec=zerowork(c_seconds);
function checkTime(){
document.getElementById("start").innerHTML='Time Left: '+min+' min '+sec+' sec';
if(total_seconds<=0){

}
else
{

total_seconds=total_seconds-1;
c_minutes=parseInt(total_seconds/60);
c_seconds=parseInt(total_seconds%60);
min=zerowork(c_minutes);
sec=zerowork(c_seconds);
setTimeout("checkTime()",1000);

}
}
function zerowork(msg){
if(msg<10)
{
msg="0"+msg;
}
return msg;
}
setTimeout("checkTime()",1000);
</script>

Droncaps latest news