Showing posts with label insert. Show all posts
Showing posts with label insert. Show all posts

Monday, 8 July 2013

Insert to DataBase in php using mysql

//index.php 

 // Insert to DataBase in php using mysql

<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="regcode.php" >
 <table width="299" border="0" align="center">
      <tr>
        <td colspan="2" align="center"><font color="red" size="+1">Employee Registration Form</font></td>
      </tr>
      <tr>
        <td width="143" align="left">&nbsp;</td>
        <td width="264" align="left">&nbsp;</td>
      </tr>
      <tr>
        <td align="left">Name</td>
        <td align="left"><label for="name"></label>
        <input name="name" type="text" id="name" size="25" placeholder="Enter ur Name" /></td>
      </tr>
       <tr>
        <td align="left">Phone No</td>
        <td align="left"><label for="phone_no"></label>
        <input name="phone_no" type="text" id="phone_no" size="25" maxlength="10" placeholder="Enter Phone Number" /></td>
      </tr>
      <tr>
        <td align="left">Email Id</td>
        <td align="left"><label for="email_id"></label>
        <input name="email_id" type="text" id="email_id" size="25" /></td>
      </tr>
      <tr>
        <td align="left">User Name</td>
        <td align="left"><label for="username"></label>
        <input name="username" type="text" id="username" onKeyUp="loadXMLDoc(this.value)" size="25"/></td>
      </tr>
      <tr>
        <td align="left">Password</td>
        <td align="left"><label for="password"></label>
        <input name="password" type="password" id="password" size="25" /></td>
      </tr>
      <tr>
        <td align="right"><input type="submit" name="submit" id="submit" value="Submit" /></td>
        <td align="center"><input type="reset" name="reset" id="reset" value="Reset" /></td>
      </tr>
    </table>
    <div align="center"></div>
</form>
</form>
</body>
</html>


Read more »
Posted by at No comments:
Labels: , ,

Insert, Edit, Delete in php mysql

// index.php
 
<?php
if(isset($_POST['add']))
{
$name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("bnr");
$sql="insert into idauto values('$id','$name','$email')";
$query=mysql_query($sql);
if($query==true)
{
    echo "Registered Successfull";
}
else
{
    echo "fail";
}}
/*$result=mysql_query("select id from idauto where name='$name' and email='$email'");
while($row = mysql_fetch_array($result))
{
    echo "<br/>Your Id Is:"." ".$row['id'];
}*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>

<form id="form1" name="form1" method="post">
  <table width="745" border="0" align="center">
   
   
   
    <tr>
      <td>Id</td>
      <td><label for="id"></label>
      <input name="id" type="text" disabled="disabled" id="id" /></td>
    </tr>
    <tr>
      <td>Name</td>
      <td><label for="name"></label>
      <input type="text" name="name" id="name" /></td>
    </tr>
    <tr>
      <td>Email Id</td>
      <td><label for="email"></label>
      <input type="text" name="email" id="email" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="add" id="save" value="Add" />
       
      </td>
    </tr>
  
    </table>
  <table border="1" align="left">
  <?php
  $name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("bnr");
$sql="select *from idauto";
$query=mysql_query($sql);

while($test = mysql_fetch_array($query))
            {
                $id = $test['id'];   
                echo "<tr>";   
                echo"<td><font color='black'>" .$test['id']."</font></td>";
                echo"<td><font color='black'>" .$test['name']."</font></td>";
                echo"<td><font color='black'>". $test['email']. "</font></td>";
                   
                echo"<td> <a href ='update.php?id=$id'>Edit</a>";
                echo"<td> <a href ='delete.php?id=$id'><center>Delete</center></a>";
                                   
                echo "</tr>";
            }
            mysql_close($con);

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

//savecode.php
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
    <?php
//$id=$_REQUEST['id'];
$name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("bnr");
$sql="insert into idauto values('$id','$name','$email')";
$query=mysql_query($sql);
if($query==true)
{
    echo "Registered Successfull";
}
else
{
    echo "fail";
}
$result=mysql_query("select id from idauto where name='$name' and email='$email'");
while($row = mysql_fetch_array($result))
{
    echo "<br/>Your Id Is:"." ".$row['id'];
}
?>
</body>
</html>
 // update.php

<?php
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("bnr");
$id =$_REQUEST['id'];

$result = mysql_query("SELECT * FROM idauto WHERE id  = '$id'");
$test = mysql_fetch_array($result);
if (!$result)
        {
        die("Error: Data not found..");
        }
                $name=$test['name'] ;
                $email= $test['email'] ;                   
               
if(isset($_POST['update']))
{   
    $name_save = $_POST['name'];
    $email_save = $_POST['email'];

    mysql_query("UPDATE idauto SET name ='$name_save', email ='$email_save' WHERE id = '$id'")
                or die(mysql_error());
    echo "Saved!";
   
    header("Location: index.php");           
}
mysql_close($con);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="">
  <table width="274" height="91" border="1" align="center">
    <tr>
      <td width="72">Id</td>
      <td width="186"><label for="id"></label>
      <input name="id" type="text" disabled="disabled" id="id" value="<?php echo $id ?>"/></td>
    </tr>
    <tr>
      <td>Name</td>
      <td><label for="name"></label>
      <input type="text" name="name" id="name" value="<?php echo $name ?>" /></td>
    </tr>
    <tr>
      <td>Email Id`</td>
      <td><label for="email"></label>
      <input type="text" name="email" id="email" value="<?php echo $email ?>"/></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="update" id="update" value="Submit" /></td>
    </tr>
  </table>
</form>
</body>
</html>

Read more »
Posted by at No comments:
Labels: , , , , , ,
Subscribe to: Posts (Atom)