Removing Title From database problem
Posted on
16th Feb 2014 07:03 pm by
admin
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:
Code: [Select]<?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 "
";
}
}
?>
<?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>
<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
No comments posted yet
Your Answer:
Login to answer
198 
23 
Other forums
AUTONUMBER PROBLEM
Hello Everyone,
My name is Jones and i am new to this forum and to oracle. I am using ora
Error with login script
I am getting an error with my login script:
Error:
Code: Warning: Cannot modify header inf
puting for loop in 1 value
hi ,
how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i
how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m
File upload issues
Hi Guys,
Can anyone see any issues with this code:
Code: $setImage= 'productimages/' . dat
Displaying image pathname instead of image
Hello
Im trying to upload and then display images from a mysql database - Its only basic and
Dynamic Array using glob?
Is there an easier way to do this?
I am trying to get create a dyamic array based on files wi
Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']
Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.
I
INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc
