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: &pound;<?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 Like 23 Dislike
Previous forums Next forums
Other forums

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv

building a function with multiple outputs
I want to build a function that has multiple outputs.

I know but am not to sure how I should

losing session vars when arriving from an email link
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

$GPRMC and NMEA how to extract from report
Hi There,

Im a little bi lost and not sure where to start with this one, ive got a small gps

Perplexing problem showing a .jpg
Please disregard..........I figured it out

PO Release Strategy Issue
Hi Experts,

I am facing an issue related to PO release strategy. The details are-
<

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

how to export excel file in same server
My first post - php newbie, so appreciate your support.

I'm currently using headers to save w

change text color with a jQuery code
Hihow can I change the text in a asp:TextBox to a different color when I start typing using jQuery?I

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash