Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("header.php");
- ?>
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
- </head>
- <body>
- <html>
- <body>
- <?php
- $b = $_POST['b'];
- $c = $_POST['c'];
- $d = $_POST['d'];
- $e = $_POST['e'];
- $f = $_POST['f'];
- $id = $_GET['id'];
- if($_POST['v'] == "1"){
- $dbconn = pg_connect("host=localhost dbname=project6 user=postgres password=p@ssw0rd")
- or die('Could not connect: ' . pg_last_error());
- $query = "update nutrition set shrt_desc='$b',water='$c',energ_kcal='$d',protein='$e',lipid_tot='$f' where ndb_no = '$id'";
- $update = pg_query($dbconn, $query);
- if($update)
- {
- ?>
- <meta http-equiv="refresh" content="0; url=inspect.php?id=<?php echo $id; ?>">
- <?php
- } else {
- echo "I can't update database.";
- }
- }
- ?>
- <form action="#" method="post">
- <input type="hidden" name="b" value="<?php echo $b; ?>">
- <input type="hidden" name="c" value="<?php echo $c; ?>">
- <input type="hidden" name="d" value="<?php echo $d; ?>">
- <input type="hidden" name="e" value="<?php echo $e; ?>">
- <input type="hidden" name="f" value="<?php echo $f; ?>">
- <input type="hidden" name="v" value="1">
- Ndb_No: <?php echo $a; ?><br>
- Shrt_desc: <?php echo $b; ?><br>
- Water: <?php echo $c; ?><br>
- Energy_kcal: <?php echo $d; ?><br>
- Protein: <?php echo $e; ?><br>
- Lipid_tot: <?php echo $f; ?><br><br>
- Are you sure you want to change this?<br>
- <input type="submit" value="Yes">
- <input type="button" value="No" onclick="location.href='edit.php?id=<?php echo $id; ?>'">
- </form>
- </body>
- </html>
Add Comment
Please, Sign In to add comment