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
HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen
regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q
php mysql script to find record
Hi,
Currently I have a simple table with 4 columns. A, B, C, D
If I want to find all
Help me with some material on Open Text Overview.
Hi Experts,
Please help me out with some material on Open Text. I have been supporting AP Workf
IIS & NW MII on the same server
Hi,
We're weighing the possibility to run both IIS and MII (NetWeaver) on the same server
php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat
Forum tutorial
Im a beginner in PHP. Im making a forum(previous questbook, counter and few others) to learn. For no
Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does
Data storage spaces in varchar2
Trying to understand what's happening.
I am selecting a value from a table that is defined as c
how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s
