Skip to main content

Database Connection in PHP

Database Connection in PHP


Syntax of Database Connection:-

mysql_connect("host","username","password");
mysql_select_db("database_name");

 Index.php

<?php include('header.php'); ?>
<html>
<head>
<title>hello</title>
<style>
.error{color:red}
  body{background:#333;color:white;}
 a{color:inherit;text-decoration:none;}
 a:hover{color:inherit;text-decoration:underline; font-size:20px; transition:0.8s;}
.error{color:white;}
.div{width:1000px;margin:0px auto; height:500px; background:orangered;text-align:center;
   padding-top:20px;
}
#frm{width:300px; height:30px; outline:none; border:0px;text-indent:1in;background:#333;}
#button{background:#333;color:white;outline:none; border:0px;border-radius:10px; height:30px; 
 width:70px;
 }
</style>
</head>

<body> 
<?php  
if(!empty($_POST[submit]))
{
if(empty($_POST[name]))
{
$error[0]='<span class="error">Enter YOUR NAME</span>';
}
if(empty($_POST[gender]))
{
$error[1]='<span class="error">Select Gender</span>';
}
if(empty($_POST[mob]))
{
$error[2]='<span class="error">Enter Your Contacts No.</span>';
}
if(empty($_POST[qualification]))
{
$error[3]='<span class="error">Select your Qualification</span>';
}
if(empty($_POST[uname]))
{
$error[4]='<span class="error">Enter USERNAME</span>';
}

if(empty($_POST[email]))
{
$error[5]='<span class="error">Enter Your Email_Address</span>';
}
if(empty($_POST[password]))
{
$error[6]='<span class="error">Enter password</span>';

}
if(empty($_POST[password2]))
{
$error[7]='<span class="error">RE Enter password</span>';
}
if(!empty($_POST[password])&&($_POST[password2]))
    {
    if($_POST[password]!=$_POST[password2])
    {
$error[7]='<span class="error">PASSWORD Not matching</span>';
}
    }

   if(empty($error))
   {
$result=mysql_query("SELECT * FROM login");  
    $count=0;
while($row=mysql_fetch_array($result))
{
if($_POST[uname]==$row[uname])
{
$count=1;
break;
}

}

if($count==1)
{
$error[4]='<span class="error">USERNAME NOT AVIALALE</span>';
}

else
include('insert.php');


}
   
   
}
?>
<div class="div">
<form method="post">
<br/>
<input id="frm" type="text" name="name" value="<?php echo $_POST['name'];?>" placeholder="NAME"/><!--name-->
<?php if(!empty($error[0])) echo $error[0]; ?><br/><br/>

Male<input id="frm" type="radio" name="gender" value="Male" <?php if($_POST['gender']=='Male') echo 'checked'; ?>><!--Gender male-->
Female<input id="frm" type="radio" name="gender" value="Female" <?php if($_POST['gender']=='Female') echo 'checked'; ?> /><!--gender female-->
<?php if(!empty($error[1])) echo $error[1]; ?><br/><br/>

<input id="frm" type="text" name="mob" value="<?php echo $_POST['mob'];?>" placeholder="Contacts No"/><!--username---->
<?php if(!empty($error[2])) echo $error[2]; ?><br/><br/>

<select id="frm" name="qualification">
<option value="0">SELECT QUL</option>
<option value="Graducation" <?PHP if($_POST['qualification']=="Graducation") echo 'selected'; ?>>Graduation</option>
<option value="Uder Graduate" <?PHP if($_POST['qualification']=="Uder Graduate") echo 'selected'; ?>>Uder Graduate</option>
<option value="POST Graduate" <?PHP if($_POST['qualification']=="POST Graduate") echo 'selected'; ?>>POST Graduate</option>
</select><?php if(!empty($error[3])) echo $error[3]; ?><br/><br/>

<input id="frm" type="text" name="uname" value="<?php echo $_POST['uname'];?>" placeholder="USERNAME"/><!--username---->
<?php if(!empty($error[4])) echo $error[4]; ?><br/><br/>

<input id="frm" type="text" name="email" value="<?php echo $_POST['email'];?>" placeholder="Email_Address"/><!--email-->
<?php if(!empty($error[5])) echo $error[5]; ?><br/><br/>

<input id="frm" type="password" name="password" value="<?php echo $_POST['password'];?>" placeholder="PASSWORD"/><!--password-->
<?php if(!empty($error[6])) echo $error[6]; ?><br/><br/>

<input id="frm" type="password" name="password2" value="<?php echo $_POST['password2'];?>" placeholder="REtype PASSWORD"/><!-- re password-->
<?php if(!empty($error[7])) echo $error[7]; ?><br/><br/>

<input id="button" type="submit" name="submit" value="SUBMIT"/><!--submit-->
<input id="button" type="reset" name="reset" value="RESET"/><!--reset-->
</form>
</div>
</body>

</html>





Insert.php

<?php

Syntax of Database Connection:-

mysql_connect("host","username","password");
mysql_select_db("database_name");

$name=$_POST['name'];
$gender=$_POST['gender'];
$mob=$_POST['mob'];
$qualification=$_POST['qualification'];
$uname=$_POST['uname'];
$email=$_POST['email'];
$password=$_POST['password'];




mysql_query("insert into login(name,gender,mob,qualification,uname,email,password) values('$name','$gender','$mob','$qualification','$uname','$email','$password')");


?>


Comments

Popular posts from this blog

PHP SUPER GLOBALS

Superglobals are variable that are automatically available throughout all program code,in all scopes. These variables require no declaration they can simply be accessed. Super global variables provide: Useful information about the environment Allow access to HTML form  variables or parimeters Access to cookies stored on a client Keeping track of sessions and file uploads   They are as follows: $_GET  - $_GET is used for data passed using the HTTP GET method,which includes variables passed as part of the URL. For Example: www.designevlop.blogspot.com/index.php?book=PHP&cat=linux                                                                                                             ...

hello

gdfgdfgdgdd jkhjk ghjgfh hjkhgjk ghkhkhgjkh jgjufgjfgyukhguk jghjghjgjgjgjhjghjgjgjgfj mfghbnmbmbmbnbmbnmbnbnm nvbnvbnvbnvbnghfhgghghmghmghgmghm nvbnvbnvbnvbnvbnvbncvbnvbnvbnvbnvbnvbnvnv