Mysql not updating

lowsky13

Here is my full code...can't figure out why it is not updating...it fills in the textboxes from a db like it is supposed to but when I click Update it doesn't give me any errors and it doesn't UPDATE. Where is the prob...?

<?php include("sessioncheck.php");
if (isset($GET['show'])) {
$SESSION['showit'] = $_GET['show'];
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Edit your show</title>
<link href="styles.css" rel="stylesheet" type="text/css" />

</head>

<body class="oneColFixCtr">

<?php

ERROR_REPORTING(E_ALL);

// Connects to your Database
mysql_connect("*", "", "****") or die(mysql_error());
mysql_select_db("slideshow") or die(mysql_error());

$show=$GET['show'];
$showit = $SESSION['showit'];

$sql = "SELECT * FROM slideshow WHERE showname='$show'";

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

//if (mysql_num_rows($result) == 0) {
// echo "No rows found, nothing to print so am exiting";
//exit;
//}

// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
// then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
$title = $row["title"];
$description = $row["description"];
$showname = $row["showname"];
$embed = $row["embedcode"];
}

mysql_free_result($result);

//This code runs if the form has been submitted
if (isset($_POST['submit'])) {

//This makes sure they did not leave any fields blank
if (!$POST['showname'] | !$POST['title'] | !$_POST['description2']) {
die('You did not complete all of the required fields');
}

if (!get_magic_quotes_gpc()) {
$POST['title'] = addslashes($POST['title']);
$POST['description2'] = addslashes($POST['description2']);
$POST['showname'] = addslashes($POST['showname']);
}

//update title and description
$title = $POST['title'];
$description = $POST['description2'];
$showname = $POST['showname'];
$user = $SESSION['username'];

//Update the db
mysql_query("UPDATE slideshow SET showname = '" .
mysql_real_escape_string($showname) . "' WHERE username = '" .
mysql_real_escape_string($user) . "' AND showname= '" .
mysql_real_escape_string($showit) . "'");

if(mysql_affected_rows() == 0)
{
user_error("No rows updated with query:<br />\n$query");
}
}

?>

<div id="container">
<div id="mainContent">
<div id="editShowContainer">
<div id="header"></div>

<div id ="leftEditShow">
<div id="signupHeadline"><?php echo $showname; ?></div>
<br />

<div class="signuplabels"><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">Show name:</div>
<input name="showname" type="text" class="captionBox2" id="showname" value="<?php echo $showname; ?>" />
<br />

<div class="signuplabels">Title:</div>
<span id="SignUptextBoxes">
<input name="title" type="text" class="captionBox2" id="title" value="<?php echo $title; ?>" />
<br />
<div class="signuplabels">Description:</div>
<span id="SignUptextBoxes">
<textarea name="description2" cols="19" rows="5" class="captionBox2" id="description2"><?php echo $description; ?></textarea>
<br />
<div class="signuplabels">Embed code:</div>
<span id="SignUptextBoxes"><input name="embed" type="text" class="captionBox2" id="embed" readonly="readonly" value="<?php echo $embed; ?>" />
<br />
<br />
 <div id = "updateTitle">
<input name="submit" type="submit" class="captionBox2" id="submit" value="Update" /><?php echo $showit ?>
</form></div>


 <br />
 <br />
</div>

  <div id="RightEditShow"><div id="signupHeadline">Your photos:</div><br />
  <?php 
if ($handle = opendir('shows/' . $SESSION['username'] . "/" . $SESSION['showit'])) {
while (false !== ($file = readdir($handle)))
{
if ($file != "." && $file != "..")
{
		$thelist .= '<a href="editshow.php?photo=' . urlencode($file) . '">'
     . htmlspecialchars($file) . '</a>

	  <FORM METHOD="LINK" ACTION="delete.php?photo=' . urlencode($file) . '">'
     . htmlspecialchars($file) . ' ">
    <input type="submit" class="redirect" value="Delete photo" />
 </FORM>


	 <br>'; 


      }
   }
closedir($handle);
}
?>

<?php echo $thelist; ?>
</div>

  <div id="signupHeadline">Add photos</div>
  <div id="upload">



<form action="uploader.php" method="post"
enctype="multipart/form-data">
<label for="file">Upload files:<br />
<br />
Filename:</label>
<input type="file" name="file" id="file" />
<input type="submit" name="submit" value="Upload" />
<br />
</form>
</div>
 <br />
 <br />


 <div id="signupButtonCenter">
 </div>
 <br /><br />
</form>
</div>
<div id="footer">Home | Create a show | Edit a show | Sign in</div></div>

</body>
</html>

dagon

add

or die(mysql_error());

to the update query to see whats going on

bradgrafelman

Also, when posting PHP code please use the board's [PHP]/PHP] bbcode tags as they make your code much easier to read and analyze. Please go back and edit your post now to include these tags.

lowsky13

So now I am trying to have it update from my update.php file...I now have the form post to update.php (the code is below for update.php) and I can echo out all my variables in my update.php but it is not updating correctly in the db. Now it erases everything that I had and it is now a blank row for what I am trying to update.

Like I said before $updateshow, $updateuser, $updateshowit all echo out to what I want. Why is it not inserting/putting in blanks?

// Connects to your Database 
mysql_connect("***", "***", "***")  or 

die(mysql_error());
mysql_select_db("slideshow") or die(mysql_error());


$updateshow = $_POST['showname'];
$updateuser = $_SESSION['username'];
$updateshowit = $_SESSION['showit'];

//Update the db
mysql_query("UPDATE slideshow SET showname = '" . 
mysql_real_escape_string($updateshow) . "' WHERE username = '" . 
mysql_real_escape_string($updateuser) . "' AND showname= '" . 
mysql_real_escape_string($updateshowit) . "'"); 

echo $updateshow;
echo $updateuser;
echo $updateshowit;

if(mysql_affected_rows() == 0)
{
   die(mysql_error());
}

bradgrafelman

Try building the UPDATE query in a string in your code and echo out that string before querying the database, then paste the query here for us to examine.