<html>
<body bgcolor="pink">
<form
action="inserttable.php" method="post">
<fieldset>
<legend>Student Registration Form</legend>
Name<input type="textbox" name ="s_name"
placeholder="ex. rajesh"><br><br><br>
F_name<input type="textbox" name ="f_name"
placeholder="ex. Mr. Abhinash"><br><br><br>
Email<input type="textbox"
name="email"
placeholder="abc1234@gmail.com"><br><br><br>
Phone<input type="textbox" name ="phone"
placeholder="6789452390"><br><br><br>
Address<br><textarea name= "address" rows="4" cols="50"name
="email" placeholder="ex.
abc@gmail.com"></textarea><br>
<br><br><br>
Gender:<br>
<input type="radio" name ="r1"
value="Male">Male<br>
<input type="radio" name ="r1"
value="female">Female<br>
<br><br><br>
Hobby:<br>
<input type="checkbox" name
="checklist[]">Spots<br>
<input type="checkbox" name
="checklist[]">Reading<br>
<input type="checkbox" name
="checklist[]">Dance<br>
<input type="checkbox" name
="checklist[]">Sing<br>
<br><br><br>
<input type="submit" value="register"
name="submit">
</fieldset>
</form>
</body>
</html>
<?php
if(isset($_POST['submit']))
{
$a= $_POST['s_name'];
echo "welcome $a";
}
?>
Save as data.php
Establish connection
<?php
$conn=mysqli_connect("localhost","root","");
if($conn)
echo
"connected";
else
echo mysqli_connect_error();
?>
Create
database
<?php
$conn=mysqli_connect("localhost","root","");
$sql="CREATE
DATABASE student2";
if(mysqli_query($conn,$sql))
{
echo "Database created";
}
else
{
echo mysqli_error($conn);
}
?>
First we try entry only for name,email ,phone and gender only
<?php
$conn=new
mysqli("localhost","root","","student2");
$sql="CREATE TABLE admission(id INT(20) PRIMARY KEY NOT
NULL AUTO_INCREMENT ,
S_name VARCHAR(30) NOT NULL,
Email VARCHAR(50) NOT NULL,
phone VARCHAR(10) ,
Sex VARCHAR(50) NOT NULL)";
if(mysqli_query($conn,$sql))
{
echo "
Table Created";
}
else
{
echo
mysqli_error($conn);
}
?>
Alter
table by add address column
<?php
$con=new
mysqli("localhost","root","","student2");
$sql="ALTER TABLE admission ADD
Address VARCHAR(150)NOT NULL AFTER phone";
if(mysqli_query($con,$sql))
{
echo
"table alter successfully";
}
else
{
echo
"NO".mysqli_error($con);
}
?>
No comments:
Post a Comment