apple4

7:page edit.php
<?php
include 'db.php';
$id = $_GET['edit'];
echo $id;

$query=mysql_query("select * from apple where id='$id' ");

$row =mysql_fetch_array($query);


 if(isset($_POST['save']))
 {

$name = $_POST['name'];
$up = "update apple set name = '$name' where id = '$id' ";
$results =mysql_query($up);
echo "successfully updated";
}

?>

<h1><a href="index.php">Back</a></h1>
<form action="" method="post">
Name: <input type="text" name="name" value="<?php echo $row['name']; ?> ">
<input type="submit" value="update" name="save">
</form>
////////////////////////////End////////////////////////////
8: page delete.php

<?php
include 'db.php';

$id = $_GET['delete'];

$del = "DELETE FROM apple WHERE id='$id' ";
$run =mysql_query($del);
header("Location:index.php");
?>
///////////////////////////////////End//////////////////////

Comments

Post a Comment

Popular posts from this blog

Complete Php

Db.php  <?php $host = "localhost"; $user = "root"; $pass = ""; $db   = "practice"; $link =mysqli_connect($host,$user,$pass,$db) or die(mysqli_error()); if($link) { echo "Database Connected Successfully"; } else { echo "Not Connected with a database"; } ?> insert.php <?php include 'db.php'; $phone = $_POST['phone']; $sql =mysqli_query($link,"insert into user (phone) values ('$phone')  "); ?> <hr> Welcome to insert page <br> <a href="logout.php">Logout</a><a href="show.php">show php</a> <form method="post" action=""> Phone<input type="text" name="phone" > <input type="submit"> </form> Show.php with Edit starts here <?php include 'db.php'; $sql = ("select * from user "); $re...
Read more

Crud

Db.php <?php mysql_connect("localhost","root",""); mysql_select_db('crud'); echo "crud Database" ?>              ====================================================== <?php // Steps Edit ////////////////////Show data in the edit field // 1 connection // $id = $_GET['edit']; variable to get data from the last page from <a href="edit.php?edit=' $row['id']">edit</a> //$query = mysql_query("select * from table where id='$id' "); //catch data in $row = mysql_fetch_array($query); //Show data in input field in value="<?php echo $row['id']; > " /////////////// // Update data // if(isset($_POST['update'])){ // set variable names $name=$_POST['name']; and phone etc //$update = "update table set name ='$name' , phone='$phone' where id='$id' "; // $result =mysql_query($update); //} in...
Read more

apple

1: Page: db.php  // to make connection  <?php mysql_connect("localhost","root","");  mysql_select_db('login'); echo "Login database"; ?> //////////End/////////// 2: Page index.php <?php include "db.php";      if(isset($_POST['enter'])) { $name =$_POST['name']; echo $name; $in = "insert into apple (name) values('$name')"; $re = mysql_query($in); } $show = "select * from apple "; $results =mysql_query($show); echo "<table class=\"table table-striped\">       <tr>             <th>ID</th>             <th>Name</th>             <th>Edit</th>             <th>Delete</th>             <th>insert</th>       </tr>"; while ($row = mysql_fetch_array($results)) {...
Read more