How to Update Data into Database using PHP

-


index.php
<html>
<head>
<title>Update Data</title>
</head>
<body>
<form method="post" action="update.php" enctype="multipart/form-data">
<div class="name">
 <div class="name1"><h1>Student Name:</h1></div>
 <div class="name2"><input type="text" name="name" value="<?php echo $row['name']; ?>" /></div>
</div>
<div class="name">
 <div class="name1"><h1>Father Name:</h1></div>
 <div class="name2"><input type="text" name="father_name" value="<?php echo $row['father_name']; ?>" /></div>
</div>
<div class="name">
 <div class="name1"><h1>Mother Name:</h1></div>
 <div class="name2"><input type="text" name="mother_name" value="<?php echo $row['mother_name']; ?>" /></div>
</div>
<div class="name">
    <div class="name1"><h1>E-mail:</h1></div>
    <div class="name2"><input type="email" name="email" value="<?php echo $row['e_mail']; ?>"  /></div>
</div>
<div class="name">
    <div class="name1"><h1>Address:</h1></div>
    <div class="name2"><textarea name="address"><?php echo $row['address']; ?> </textarea></div>
</div>
<div class="name">
 <div class="name1"><h2>DOB:</h2></div>
    <div class="name2"><input type="text" class="inp" name="dob" value="<?php echo $row['dob']; ?>"  /></div>
</div>
<div class="name">
 <div class="name1"><h2>Category:</h2></div>
 <div class="name3"><input type="radio" name="gender" value="male" <?php if($row['category']== 'male' ) { ?> checked="checked" <?php } ?>/></div><h2 class="cat">male</h2>
    <div class="name3"><input type="radio" name="gender" value="female" <?php if($row['category']== 'female' ) { ?> checked="checked" <?php } ?>/></div><h2 class="cat">female</h2>
</div>
<div class="name">
 <div class="name1"><h2>Course:</h2></div>
    <div class="name4"><select name="course">
           <option value="<?php echo $row['courses']; ?>"><?php echo $row['courses']; ?></option>
           <option value="BCA">BCA</option>
                                <option value="MCA">MCA</option>
                                <option value="BBA">BBA</option>
                                <option value="DCA">DCA</option>
         </select></div>
</div>

    <input type="submit" class="sub" name="sub" value="Submit"  />
</form>
</body></html>
style.css
.name{
width:100%;
min-height:30px;
height:auto;
float:left;
margin-bottom:20px;
}
.name1{
width:14%;
min-height:20px;
float:left;
height:auto;
}
.name1 h1{
font-size:18px;
font-family:Verdana, Arial, Helvetica, sans-serif;
}
.name1 h2{
font-size:18px;
font-family:Verdana, Arial, Helvetica, sans-serif;
margin-top:55px;
}
.name2{
width:30%;
height:30px;
float:left;
}
.name input{
margin-top:10px;
height:25px;
width:50%;
border:#999999 1px solid;
border-radius:5px;
}
.name textarea{
margin-top:10px;
height:70px;
width:50%;
border:#999999 1px solid;
border-radius:5px;
}
.name2 input.inp{
margin-top:50px;
}
.sub{
margin-top:50px;
margin-left:120px;
}
.name3{
width:3%;
height:30px;
float:left;
margin-top:45px;
}
.cat{
float:left;
font-size:20px;
margin-top:55px;
}
.name4{
width:3%;
height:30px;
float:left;
margin-top:60px;
}
update.php
<?php
include(db.php);
$id = $_GET['id'];
if(isset($_POST['sub']) == 'Submit'){
$name = $_POST['name'];                                          // from input name/value
$father_name = $_POST['father_name'];
$mother_name = $_POST['mother_name'];
$e_mail = $_POST['email'];
$add = $_POST['address'];
$dob = $_POST['dob'];
$category = $_POST['gender'];
$courses = $_POST['course'];
$query = "update new set name='$name', father_name='$father_name', mother_name='$mother_name', address='$add', dob='$dob', e_mail='$e_mail', courses='$courses',   category='$category' where id = '$id'";                                             // from database
$num=mysql_query($query);
}
$query1 = "select * from new where id = '$id' ";
$query2 = mysql_query($query1);
$row = mysql_fetch_array($query2);
echo "<pre>";print_r($row);echo "</pre> <br>";
?>
db.php
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('db');
?>
Read Full article

Comments

Post a Comment

Popular posts from this blog

Student Result Management System

-
Image
Students can see the result in this system. After the training and Exam, it's very easy to shows the result to students with the help of student roll no. This application is also used for the college management system. Modules of Student Result Management System: Students:- You can add the student detail ie. fields (Student Name, Roll No, Email ID, Gender, Class, and DOB). Student Classes: - In this Module can easily create the class with the section option. Also, you can manage all classes and the section. Subjects:- you can create the subject with the subject code. A very simple method to manage the subjects. You can also assign the subject to the class in a simple way. Result:- Result Section is a very important part of the application. you have to select the class then select the student name after that you will see the subjects than just ad the marks in the subjects fields. Admin Features Change password:- Admin can change the password any time. Dashboard:- On the Dashb
Read more

What Is The Job Role Of A Customer Support Executive?

-
Image
Customer service representatives are the backbone of any company that interacts with its clients frequently. These specialists assist businesses in establishing and maintaining great customer and client connections. You can determine whether or not you would like to follow this career path by learning more about it. In this article, we will talk in detail about  customer support jobs  and support representatives, and go into their primary and high-level responsibilities, as also the scope for success in this field. A consumer service executive listens to customers’ problems and offers them appropriate solutions. They are among the most significant aspects of any company because they reflect the true essence of an organization. They are in charge of maintaining clients by assisting them and developing positive relationships with them. They are the ones who are in direct touch with the customer, hence a Client Service Executive could either make or break the sale. In addition, they are f
Read more

TOP RECRUITMENT COMPANIES IN INDIA

-
Image
Placement organization plays a vital role in matching potential candidates to employers. Today, the whole scenario of recruiting talented people has changed drastically as every company approaches placement agencies to hire candidates that would be valuable assets in the future. Every agency thoroughly checks the background details of candidates, interviews them, and trains them with professionals. Before going into detail about the top recruitment companies, we need to see the advantages of hiring through these organizations. Benefits For Recruiting Through Agencies:-  For the past, many year’s recruitment companies are taking the road map of agencies to hire the workforce, which has proven helpful as follow, 1. Quick hiring process 2. Meeting the purposes 3. Negotiate salary TOP RECRUITMENT COMPANIES IN INDIA 1. RANSSTAD INDIA Keeping the legacy of 28 years, the company has 57K+ temporary employees on-site and over 500K placement to date. The Ransstad is one of the best recruitment a
Read more