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

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 recruitme...
Read more

Best Indian Colleges For MBA

-
Image
  Every Master’s degree plays an important role in any student’s career. For pursuing a Master’s degree selection of the right college is a must. There are many best Indian colleges for MBA. These colleges will provide proper guidance and grooming which is the major need of every MBA student. Prestige Institute of Management And Research The organization has been Accredited Thrice Consecutively by NAAC with the most noteworthy Grade A++ now. The Institute is ISO 9001:2015 affirmed. In acknowledgment of its Performance and High principles in giving quality schooling, the Institute has been presented Autonomous Status by the University Grants Commission 2006, 2012, 2018 just as Devi Ahilya Vishwavidyalaya on the proposal of a powerful master board of trustees named by UGC to assess the Institute. This is a crucial achievement for the Institute. Eminence Institute of Management and Research is pleased to have set up AIC – Prestige Inspire Foundation under the aegis of Atal Innovation ...
Read more

Boost Your Brand New Site Up Google’s Ranking

-
Image
  The best way to rank any of your sites is through Google. There’s a no-brainer to that. Google is regarded as one of the most powerful tools to help you boost your site. If you have developed a brand new site, you should be aware of the effectiveness and importance of google. Google is the world’s biggest search engine which holds 88% of total searches and contains the world’s information, including webpages, images, videos, and much other information. Google SEO  is the most powerful tool to grow your website organically and the rest of other techniques include  Social Media Marketing , Email Marketing, Pay-Per-Click (PPC), and others. All sites want to rank up their sites on Google’s first page as most of the clicks come through the first page only; more than 75% of people don’t tend to go past Google’s first page. Step by Step Guide: Boost your Brand New Site up Google’s ranking To make your site grow, you should target to appear on google’s first page as more  ...
Read more