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
Checking if field is empty AND using !is_numeric
Hi lads,
Need to be able to display an error message (using isset?) that says "Cant lea
Beginner question regarding Array's
Hi everyone, the page im working on has an array of variable at the top...
Code: $define_li
php/mysql auto logout after 2 hour and reset password
Hi all,
This I hope will make sense. I've the following code which when a user logins in, cr
connect() succeeds but accept() does not?
Please help me with this problem. I'm working on a time-sensitive project where I'm using TCP socket
PHP Cannot redeclare class
I have 6 files, and two of them do not seem to want to play well. I keep getting a "Cannot rede
How to Create a Dynamic table
col1 col2 date1 date2 date3 date4..........
a b v1 v2 v3 v4
Mysql query, two times?
Hello to all,
I'm new to php coding and i like it alot. I need help with some noob stuff.
PL/SQL: ORA-00947: not enough values error message
Hi all i am getting Error(25,63): PL/SQL: ORA-00947: not enough values error message when executing
What is SAP Avatar ?
Hi All,
This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet
ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al
