[SOLVED] Removing Title From database problem

mraza · October 17, 2009

Hi again ! i am having an issue with updating database. When i update any price of a title it remove the title from database please can somebody help me what i am missing in my code. here it is:

<?php ob_start() ; ?>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="description" content="Your description goes here..." />
<meta name="keywords" content="your,keywords,goes,here" />
<meta name="author" content="Raza / Webbuilderstudio.com" />
<link rel="stylesheet" type="text/css" href="../style.css" title="1024px style" media="screen,projection" />
<title>CSCS Products</title>
</head>

<body>
<?php include_once("include_header.php");
	include('db_fns.php');

?>

	<h3>Your Administration Center</h3>
<?php
// Connects to your Database
db_connect();

//checks cookies to make sure they are logged in
if(isset($_COOKIE['ID_my_site']))
{
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{

//if the cookie has the wrong password, they are taken to the login page
if ($pass != $info['password'])
{ header("Location: login.php");
}

//otherwise they are shown the admin area
else
{ ?>
<?php 
//If cmd has not been initialized
if(!isset($cmd)) 
{
   //displaying all products on the page with title and price
   $result = mysql_query("select * from booklist order by id"); 
   echo'<center><h3>Product List</h3></center>';
   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result)) 
   { 
     
      $title=$r["title"];// title
      $id=$r["id"];// id
     

      echo "$id : $title - <a href='manager.php?cmd=edit&id=$id'>Edit</a>";
      echo "<br>";
    }
}
?>
<?php
if($_GET["cmd"]=="edit" || $_POST["cmd"]=="edit")
{
   if (!isset($_POST["submit"]))
   {
      $id = $_GET["id"];
      $sql = "SELECT * FROM booklist WHERE id=$id";
      $result = mysql_query($sql);        
      $myrow = mysql_fetch_array($result);
      ?>
  
      <form action="manager.php" method="post">
      <input type="hidden" name="id" value="<?php echo $myrow["id"] ?>">
      <h3>Please Enter New Price For the Unit:</h3>
      <b>Title:</b><?php echo $myrow["title"] ?><br />
      <b>Message:</b><? echo $myrow["body"] ?><br />
      <b>Enter New Price:<b/><INPUT TYPE="TEXT" NAME="price" VALUE="<?php echo $myrow["price"] ?>" SIZE=4><br>
   
      <input type="hidden" name="cmd" value="edit">
   
      <div style="margin:10px 0 0 120px;"><input type="submit" name="submit" value="submit"></div>
   
      </form>
   
<? } ?>
<?php
   if ($_POST["submit"])
   {
      $title = $_POST["title"];
  $body = $_POST["body"];
  $price = $_POST["price"];
  // Here i am having issue when i update it remove the title but update the price
  $sql = "UPDATE booklist SET title='$title',body='$body',price='$price' WHERE id=$id";
           $result = mysql_query($sql);
      echo "<br /><center><font color=\"red\">The Product Price Has been Updated. </font></center>";
}
}
   echo'<center><h3>Orders List</h3></center>';
?>
<div style="border: 2px solid #FFFFFF; width: 700px; height: 260px; overflow: auto;">
<?php $orders = find_orders();
foreach($orders as $order): ?>

<div class="order">
<h3>Order ID: ( <?php echo $order['id']; ?> ) Dated: <?php echo $order['created_at']; ?></h3>
 <b>Buyer: <?php echo $order['firstname']; ?> <?php echo $order['lastname']; ?></b> <br />
 Amount Received: £<?php echo number_format($order['amount'], 2); ?> <br />
 Email Address: <?php echo $order['email']; ?><br />
 Payment Status: <?php echo $order['status']; ?><br /> 
 Paypal Trans ID: <?php echo $order['paypal_trans_id']; ?><br />
    Address: <?php echo $order['address']; ?> <?php echo $order['city']; ?> <?php echo $order['state']; ?> <?php echo $order['zip_code']; ?> <?php echo $order['country']; ?>
</div>

<?php $items = find_items($order['id']); ?>

<?php foreach($items as $item): ?>

[Product X Quantity]: <?php echo $item['title']; ?> X <?php echo $item['qty']; ?>

<?php endforeach; ?>

<hr/>


<?php endforeach; ?>
</div>
<?php
}
}
}
else

//if the cookie does not exist, they are taken to the login screen
{
header("Location: login.php");
}
?> 

<?php include_once("sidebar.php");?>

<?php include_once("include_footer.php");?>

</div>
</body>
</html>
<?php ob_flush() ; ?>

Thanks for the help Team ::)

mraza · October 17, 2009

ok solved it there was missing the title and body input type i added as hidden fields.. Regards

mraza · October 17, 2009

sorry its not solved now if i change one item it is changing other items title and price please help

mrMarcus · October 17, 2009

$id = $_GET["id"];

you're mixing $_GET with $_POST .. your script is very inefficient, but that's another story .. you've set your form action to 'post', therefore, values coming in need to be addressed appropriately, ie:

$id = $_POST['id'];

try that.

next time, echo out your query:

echo $sql;

and see if the query is right.

mraza · October 17, 2009

thanks mrMarcus

i just solved it like this :

$id=(int) $_POST["id"];
$title = $_POST["title"];
     $body = $_POST["body"];
     $price = $_POST["price"];
     // Here i am having issue when i update it
     $sql = "UPDATE booklist SET title='$title',body='$body',price='$price' WHERE id=$id";
           $result = mysql_query($sql) or die(mysql_error());

Sign In

[SOLVED] Removing Title From database problem

Recommended Posts

mraza

Link to comment

Share on other sites

mraza

Link to comment

Share on other sites

mraza

Link to comment

Share on other sites

mrMarcus

Link to comment

Share on other sites

mraza

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information