form in class

Copy Code To Clipboard | CodingLab

php

form:

	
<html>
<body>
<form action="formdb.php" metod="post" >
<table align="center"> 
    <tr>
      	<th>  Name:</th>
     	<td> <input type="text" name="name"id="name" placeholder="Enter Your Name"></td>
	</tr>


	<tr>
		<th>Email</th>
		<td><input type="email" name="email"id="email" placeholder="Enter Email Id" ></td>
	</tr>

	<tr>
		<th>Passwored</th>
		<td><input type="password" name="password"id="password" placeholder="Enter Your Passwored"></td>
	</tr>

	<tr>
		<th>Contact</th>
		<td><input type="number" name="contact" id="contact" placeholder="Enter Your Contact Number" ><td>
	<tr>

  	<th><input type="submit" name="submit" value="Submit"></th>
  	<th><input type="reset" name="reset" value="clear"><th>

</form>
</body>
</html>

formdb:

	
<?php
	include "config.php";
	$name=$_REQUEST['name'];
	$email = $_REQUEST['email'];
	$password=$_REQUEST['password'];
	$contact=$_REQUEST['contact'];
	//$addrese=$_REQUEST['addrese'];

	$insert="INSERT INTO `form`(`name`,`email`,`password`,`contact`)VALUES('$name','$email','$password','$contact')";
	$result= mysqli_query($con,$insert);
     
	header("location:form.php");



?>

config:

<?php
    $con =mysqli_connect("localhost","root","","siddharth");
   /* if($con == true)
    {
        echo"YES";
    }
    else{
        echo"NO";
    }*/
?>

edit

<?php 
	include"config.php";
	$id=$_REQUEST['id'];
	$sql="SELECT * from `form` WHERE `id`='$id'";
	$result=mysqli_query($con,$sql);
	$row=mysqli_fetch_assoc($result);

?>
<html>
<body>
    <form method="post" action="editac.php?id=<?php echo $row['id'];?>">
        <table>
            <tr>
                    <td>NAME:</td>
                    <td><input type="text" name="name" value="<?php echo $row['name'];?>"></td>
            </tr>
            <tr>
                    <td>EMAIL:</td>
                    <td><input type="email" name="email" value="<?php echo $row['email'];?>"></td>
            </tr>
            <tr>
                    <td>CONTACT:</td>
                    <td><input type="number" name="contact" value="<?php echo $row['contact'];?>"></td>
            </tr>
            
            <tr>
                    <td><input type="submit" name="submit" value="submit"></td>
</tr>   
</table>
</form>
</body>
</html>

editac:

<?php
include"config.php";


    $id=$_REQUEST['id'];
    $name=$_REQUEST['name'];
    $email=$_REQUEST['email'];
    $contact=$_REQUEST['contact'];
   // $addrese=$_REQUEST['addrese'];


    $edit="UPDATE `form` SET `name`='$name',`email`='$email',`contact`='$contact' WHERE `id`='$id'";
    $result = mysqli_query($con,$edit);
    if($result)
    {
        header("location:formtable.php");
    }
?>

delete

<?php
	include"config.php";

	
	$id=$_REQUEST['id'];
	$delete="DELETE from `form` WHERE  `id`='$id'";
	$result=mysqli_query($con,$delete);

	if($result)
	{
	    header("location:formtable.php");
	}
?>

search:

<?php

	$con =mysqli_connect("localhost","root","","siddharth");

	if(isset($_POST['submit']))
	{
        $id=$_POST['id'];
            //$addrese=$_POST['address'];


        $search="SELECT * FROM `form` WHERE `id`='$id'";


        $result=mysqli_query($con,$search);

        $row=mysqli_fetch_assoc($result);
      $tru=mysqli_num_rows($result);
      if($tru>0)
      {
         $name=$row['name'];
         $email=$row['email'];
         $password=$row['password'];
         $contact=$row['contact'];

      //    echo "Name : ".$name ."<br>";


      }
      else
      {
         echo"not found";
      }
  	}

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
<table border="1" align="center">
        <tr>
            <td colspan="6" aligh="right"></td>
            <th><input type="submit" value="search"></th>
        </tr>
    <tr>
        <th>Id</th>
        <th>Name</th>
        <th>Email</th>
        <th>Passwored</th>
        <th>Contact</th>
        
        <th>Edit</th>
        <th>Delete</th>
    <form  method="post">
                <input type="text" name="id">
                  <input type="submit" name="submit">
    </tr>
    <tr>
        <td><?php echo $row['id'];?></td>
         <td><?php echo $row['name'];?></td>
         <td><?php echo $row['email'];?></td>
         <td><?php echo $row['password'];?></td>
         <td><?php echo $row['contact'];?></td>
         
         <td><a href="edit.php?id=<?php echo $row['id']?>">EDIT</a></td>
         <td><a href="delete.php?id=<?php echo $row['id']?>">DELETE</a></td>
    </tr>
</table>
    </form>
</body>
</html>

table:

<?php
    include"config.php";
    $result = "";
    $sql="select * from `form`  ";
    $result=mysqli_query($con,$sql);

    $result2 = "";
    if(isset($_POST['sb']))
	{
        $name = $_POST['se'];
        $sql2="select * from `form` WHERE `name` = '$name' or `id` = '$name' or `email`='$name'";
        $result2=mysqli_query($con,$sql2);
    }
        

?>
<html>
<head>
    <style>
        .sb 
        {
            width: 100px;
        }
        .se{
            width:100%;
        }
        </style>
</head>
<body>
    <h1 align="center"><a href="formtable.php">Table</a></h1>
    <table border="1" align="center">
    <tr>
          <form  method="POST" >
            <th colspan="5" >
                <input class="se" name="se" type = "text">
            </th>
            <th>
                <input class="sb" name="sb" value="Search" type ="submit">
            </th>
            </form>
        </tr>
        <!-- <input type="submit" value="search"> -->
    <tr>
        <th>Id</th>
        <th>Name</th>
        <th>Email</th>
        <th>Passwored</th>
        <th>Contact</th>
        
        <th>Edit</th>
        <th>Delete</th>
</tr>
<?php
if($result2){
$row2=mysqli_fetch_assoc($result2) ;
    
 
?>
    <tr>
        <td><?php echo $row2['id'];?></td>
         <td><?php echo $row2['name'];?></td>
         <td><?php echo $row2['email'];?></td>
         <td><?php echo $row2['password'];?></td>
         <td><?php echo $row2['contact'];?></td>
         <td><a href="edit.php?id=<?php echo $row2['id']?>">EDIT</a></td>
         <td><a href="delete.php?id=<?php echo $row2['id']?>">DELETE</a></td>
    </tr>
    <?php
    
}
else{
while($row=mysqli_fetch_assoc($result))       
{
?>
<tr>
    <td><?php echo $row['id'];?></td>
     <td><?php echo $row['name'];?></td>
     <td><?php echo $row['email'];?></td>
     <td><?php echo $row['password'];?></td>
     <td><?php echo $row['contact'];?></td>
     
     <td><a href="edit.php?id=<?php echo $row['id']?>">EDIT</a></td>
     <td><a href="delete.php?id=<?php echo $row['id']?>">DELETE</a></td>
</tr>
<?php
}
}

    ?>
        </table>
</body>
</html>

Search This Blog

c programming , javascript , css and html

form in class

Comments

Popular posts from this blog

SIDDHARTH

SH