DataBase Connection in PHP
<?php
$con=mysql_connect("localhost","narendar","narendar");
if(!$con)
{
die('could not connect:'.mysql_error());
}
$bd=mysql_select_db('narendar');
if(!$bd)
{
die('select database unavailable:'.mysql_error());
}
?>
$con=mysql_connect("localhost","narendar","narendar");
if(!$con)
{
die('could not connect:'.mysql_error());
}
$bd=mysql_select_db('narendar');
if(!$bd)
{
die('select database unavailable:'.mysql_error());
}
?>
Registration Form in PHP
registration.php
<html>
<head>
<title></title>
</head>
<body>
<table>
<form action="registration_ser.php"method="post">
<tr><td>Enter First Name :</td><td>
<input type="text" name="fname" value="" /> </td></tr>
<tr><td>Enter Last Name :</td><td>
<input type="text" name="lname" value="" /> </td></tr>
<tr><td>Enter User_Id :</td><td>
<input type="text" name="uid" value="" /> </td></tr>
<tr><td>Enter Password :</td><td>
<input type="password" name="psw" value="" /> </td></tr>
<tr><td>Enter Phone Number :</td><td>
<input type="text" name="phno" value="" /> </td></tr>
<tr><td></td><td>
<input type="submit" name="" value="submit" />
<input type="reset" name="" value="resset" /> </td></tr>
</form>
</table>
<?php
// put your code here
?>
</body>
</html>
<tr><td>Enter First Name :</td><td>
<input type="text" name="fname" value="" /> </td></tr>
<tr><td>Enter Last Name :</td><td>
<input type="text" name="lname" value="" /> </td></tr>
<tr><td>Enter User_Id :</td><td>
<input type="text" name="uid" value="" /> </td></tr>
<tr><td>Enter Password :</td><td>
<input type="password" name="psw" value="" /> </td></tr>
<tr><td>Enter Phone Number :</td><td>
<input type="text" name="phno" value="" /> </td></tr>
<tr><td></td><td>
<input type="submit" name="" value="submit" />
<input type="reset" name="" value="resset" /> </td></tr>
</form>
</table>
<?php
// put your code here
?>
</body>
</html>
registration_ser.php
<?php
if($_POST["fname"]&&$_POST["lname"]&&$_POST["uid"]&&$_POST["psw"]&&$_POST["phno"])
{
$con=mysql_connect("localhost","narendar","narendar");
if(!$con)
{
die('could not connect:'.mysql_error());
}
$bd=mysql_select_db('narendar');
if(!$bd)
{
die('select database unavailable:'.mysql_error());
}
//mysql_select_db("narendar",$con);
$sql="insert into user_reg1(firstname,lastname,user_id,password,ph_number) values ('$_POST[fname]','$_POST[lname]','$_POST[uid]','$_POST[psw]','$_POST[phno]')";
if(!mysql_query($sql,$con))
{
die('error:'.mysql_error());
}
else{
echo "successfully registred";
}
}
else{
echo 'invalid data';
}
//mysql_close($con);
?>
if($_POST["fname"]&&$_POST["lname"]&&$_POST["uid"]&&$_POST["psw"]&&$_POST["phno"])
{
$con=mysql_connect("localhost","narendar","narendar");
if(!$con)
{
die('could not connect:'.mysql_error());
}
$bd=mysql_select_db('narendar');
if(!$bd)
{
die('select database unavailable:'.mysql_error());
}
//mysql_select_db("narendar",$con);
$sql="insert into user_reg1(firstname,lastname,user_id,password,ph_number) values ('$_POST[fname]','$_POST[lname]','$_POST[uid]','$_POST[psw]','$_POST[phno]')";
if(!mysql_query($sql,$con))
{
die('error:'.mysql_error());
}
else{
echo "successfully registred";
}
}
else{
echo 'invalid data';
}
//mysql_close($con);
?>
No comments:
Post a Comment