[SOLVED] MySQL Update Query problem

adam291086 · January 2, 2008

also use this site http://www.w3schools.com/php/php_sessions.asp and php.net

psychowolvesbane · January 2, 2008

I tried implementing a session but it won't send the variable over when submitted. So I get echo '$a'; is displaying as $EditThisItemType (just that and not the contents).

<?php
session_start();

//get current type selected
$a = $_GET['EditThisItemType'];

// store session data
$_SESSION['Type']=$a;

$Submit = $_POST['SubmitB'];
$ItemType = $_POST['ItemType'];

echo $_GET['EditThisItemType'];

if ($_POST['SubmitB'] == "Submit")
{
echo '1';
$Valid_form = true;
$Valid_ItemType = true;

       if (empty($ItemType))
       {
 echo '2';
         ?>
 <div style="position:absolute; top:220px; left:200px; width:550px">   
	  <span class="errmsg">Please Enter an Item Type</span>
 </div>
 <?php     
	$Valid_form = false;
	$Valid_ItemType = false;
}     
else
        { 
             echo '3<br>';
             echo "Current Item Type is". $_SESSION['Type'];
             echo "<br>";
             echo "$ItemType is new Item Type<br>";
             $b = $_SESSION['Type'];
              
                 $conn = mysql_connect('host:port','username','password');
                 $db = mysql_select_db('dbname', $conn);
	 $sqlUpdate = "UPDATE ItemType SET ItemType = '$ItemType' WHERE ItemType ='$b'";
	 $rsUpdate = mysql_query($sqlUpdate,$conn) or die('Problem with query: ' . $sqlUpdate . '<br />' . mysql_error());	
	 $affectedrows = mysql_affected_rows($conn);
                 
                 echo "$sqlUpdate is sqlUpdate<br>";
                 echo "$rsUpdate is rsUpdate<br>";

                 echo "$affectedrows is number of affected rows<br>";

                 if(mysql_affected_rows($conn) == "1") {
	    echo '4';
                        $Edited = true;
		$NotExec = false;
	 }
	 elseif(mysql_affected_rows($conn) == "0"){
	    echo '5';	
                        $Edited = false;
		$NotExec = true;
		?>
                 <div style="position:absolute; top:250px; left:200px; width:550px">   
                 <span class="errmsg">Could not be edited, <?php echo "$ItemType";?> may already exist!</span>
                 </div>
		<?php     

	 }
	 mysql_close($conn);
}
}
else
{
             echo '6';	 
             $EditThisItemType = $_SESSION['Type'];
}
?>

<html>
<head>
   <title>Clothing Line</title>
   <link href="stylesheetCL.css" rel="stylesheet">
   <?php require('jscript.inc') ?>
   
   <?php if($NotExec == false && $Edited == true)
   {

      session_destroy();

   ?>
      <meta HTTP-EQUIV="REFRESH" content="0; url=display_item_types.php?Action=Edit&Edited=$Edited&NotExec=$NotExec">
   <?php
   }
   ?>
</head>
<body>


<div style="position:absolute; top:75px; left:200px; width:550px">

<?php
if($_POST['SubmitB'] == "Submit")
{
?>
<span class="head3">Edit Form for Item Type: <?php echo $_SESSION['Type'] ?></span>
<br>
<br>

<?php
}
if($_POST['SubmitB'] !="Submit")
{
?>
<span class="head3">Edit Form for Item Type: <?php echo $EditThisItemType?></span>
<br>
<br>

<?php
}
?>


<form method="post" action='edit_item_type_form.php'/>

<?php
if($Valid_ItemType == false and $_POST['SubmitB'] == "Submit")
{
?>
<span class="errmsg">! </span>
<?php
}
?>

Item Type: <input type="text" name="ItemType" value="
<?php 
if($_POST['SubmitB'] == "Submit")
{

echo $_POST['ItemType']?>"/>
<?php
}

if($_POST['SubmitB'] != "Submit")
{
echo $EditThisItemType ?>"/>
<?php
}
?>

<input type="submit" name="SubmitB" value="Submit"/>
</form>  

<br>
<br>
<br>
<br>
<a href="display_item_types.php?Action=Edit">Back to Edit Item Types List</a>
</div>

</body>
</html>

So my outputs when submitting are:

1
3
Current Item Type is
One Piece is new Item Type
UPDATE ItemType SET ItemType = 'One Piece' WHERE ItemType ='' is sqlUpdate
1 is rsUpdate
0 is number of affected rows
5

adam291086 · January 2, 2008

just try echo the session straight after the session is set also echo $a to ensure the variable is set.

also

change

   echo "$ItemType is new Item Type<br>";

to

   echo $ItemType "is new Item Type<br>";

psychowolvesbane · January 2, 2008

Okay new edits have been made for verification, I have the outputs for before submission (when page is first loaded), and outputs after submission.

Current code:

<?php
session_start();

//get current type selected
$a = $_GET['EditThisItemType'];

echo "Session Variable A is ". $a;
echo "<br>";

// store session data
$_SESSION['Type']=$a;

echo "Current Item Type is ". $_SESSION['Type'];
echo "<br>";

$Submit = $_POST['SubmitB'];
$ItemType = $_POST['ItemType'];

if ($_POST['SubmitB'] == "Submit")
{
echo '1';
echo"<br>";
$Valid_form = true;
$Valid_ItemType = true;

       if (empty($ItemType))
       {
 echo '2';
         ?>
 <div style="position:absolute; top:220px; left:200px; width:550px">   
	  <span class="errmsg">Please Enter an Item Type</span>
 </div>
 <?php     
	$Valid_form = false;
	$Valid_ItemType = false;
}     
else
        { 
             echo '3<br>';
             echo "Session Type is now ". $_SESSION['Type'];
             echo "<br>";
             echo "New Item Type is now ". $ItemType;
             echo "<br>";
             $b = $_SESSION['Type'];
              
                 $conn = mysql_connect('host:port','username','password');
                 $db = mysql_select_db('dbname', $conn);
	 $sqlUpdate = "UPDATE ItemType SET ItemType = '$ItemType' WHERE ItemType ='$b'";
	 $rsUpdate = mysql_query($sqlUpdate,$conn) or die('Problem with query: ' . $sqlUpdate . '<br />' . mysql_error());	
	 $affectedrows = mysql_affected_rows($conn);
                 
                 echo "$sqlUpdate is sqlUpdate<br>";
                 echo "$rsUpdate is rsUpdate<br>";

                 echo "$affectedrows is number of affected rows<br>";

                 if(mysql_affected_rows($conn) == "1") {
	    echo '4';
                        $Edited = true;
		$NotExec = false;
	 }
	 elseif(mysql_affected_rows($conn) == "0"){
	    echo '5';	
                        $Edited = false;
		$NotExec = true;
		?>
                 <div style="position:absolute; top:250px; left:200px; width:550px">   
                 <span class="errmsg">Could not be edited, <?php echo "$ItemType";?> may already exist!</span>
                 </div>
		<?php     

	 }
	 mysql_close($conn);
}
}
else
{
             echo '6';	 
             $EditThisItemType = $_SESSION['Type'];
}
?>

<html>
<head>
   <title>Clothing Line</title>
   <link href="stylesheetCL.css" rel="stylesheet">
   <?php require('jscript.inc') ?>
   
   <?php if($NotExec == false && $Edited == true)
   {

      session_destroy();

   ?>
      <meta HTTP-EQUIV="REFRESH" content="0; url=display_item_types.php?Action=Edit&Edited=$Edited&NotExec=$NotExec">
   <?php
   }
   ?>
</head>
<body>


<div style="position:absolute; top:75px; left:200px; width:550px">

<?php
if($_POST['SubmitB'] == "Submit")
{
?>
<span class="head3">Edit Form for Item Type: <?php echo $_SESSION['Type'] ?></span>
<br>
<br>

<?php
}
if($_POST['SubmitB'] !="Submit")
{
?>
<span class="head3">Edit Form for Item Type: <?php echo $EditThisItemType?></span>
<br>
<br>

<?php
}
?>


<form method="post" action='edit_item_type_form.php'/>

<?php
if($Valid_ItemType == false and $_POST['SubmitB'] == "Submit")
{
?>
<span class="errmsg">! </span>
<?php
}
?>

Item Type: <input type="text" name="ItemType" value="
<?php 
if($_POST['SubmitB'] == "Submit")
{

echo $_POST['ItemType']?>"/>
<?php
}

if($_POST['SubmitB'] != "Submit")
{
echo $EditThisItemType ?>"/>
<?php
}
?>

<input type="submit" name="SubmitB" value="Submit"/>
</form>  

<br>
<br>
<br>
<br>
<a href="display_item_types.php?Action=Edit">Back to Edit Item Types List</a>
</div>

</body>
</html>

First Output (Looks good)

Variable One Pieces is One Pieces
Current Item Type is One Pieces
6

Secondary Output (Missing values for $a and subsequently for $_Session['Type']

Session Variable A is
Current Item Type is
1
3
Session Type is now
New Item Type is now One Piece
UPDATE ItemType SET ItemType = 'One Piece' WHERE ItemType ='' is sqlUpdate
1 is rsUpdate
0 is number of affected rows
5

adam291086 · January 2, 2008

where is the first output results coming from?

adam291086 · January 2, 2008

put this at the top of the page to look for errors

<?php
error_reporting(E_ALL);
?>

psychowolvesbane · January 2, 2008

I get these messages:

Notice: Undefined index: SubmitB in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 18

Notice: Undefined index: ItemType in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 19

Notice: Undefined index: SubmitB in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 21

6

Notice: Undefined variable: NotExec in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 91

Notice: Undefined variable: Edited in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 91

Notice: Undefined index: SubmitB in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 108

Notice: Undefined index: SubmitB in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 117

Edit Form for Item Type: One Pieces

Notice: Undefined variable: Valid_ItemType in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 132

Notice: Undefined index: SubmitB in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 132

psychowolvesbane · January 2, 2008

Sorry that was what errors occur before submission, which some are fine since they are only used once submission is done thus an error is reported.

the errors I get once submitted are:

Notice: Undefined index: EditThisItemType in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 7

Session Variable A is

Current Item Type is

1

3

Session Type is now

New Item Type is now dgdsg

UPDATE ItemType SET ItemType = 'dgdsg' WHERE ItemType ='' is sqlUpdate

1 is rsUpdate

0 is number of affected rows

5

adam291086 · January 2, 2008

it seems the session is not being set.

Try setting session to

$_SESSION['Type'] = true;

and see what happens

psychowolvesbane · January 2, 2008

No that didn't work, the Session is set fine before submission but the value gets lost in translation once the form is submitted, is there any line I need to add to the page address in the form action line to send the Session data over?

adam291086 · January 2, 2008

when the session is set that should be stores on the clients computer until destroyed. Look at your browser settings. is the site hosted remotely. If so let me have a look at whats going on.

psychowolvesbane · January 2, 2008

The site host is freehostia.com, my browser is Mozilla Firefox 2.0.0.11, I don't have any special restrictions or connections that I am aware of, and the same goes for Internet Explorer 7. I don't know specifically where to look in my cpanel but I'll try to find some stats that will help.

adam291086 · January 2, 2008

whats your url so i can have a look. I am still learning php so bear with me

psychowolvesbane · January 2, 2008

http://psychowolvesbane.freehostia.com

It's a work in progress as half of the stuff isn't made yet, I have another page on the go but I want this problem out of the way first.

adam291086 · January 2, 2008

try doing a simple session setting through the url. Then call on that session from a different page. Get that working and then intergrate it into your code.

psychowolvesbane · January 2, 2008

I tried putting in:

But it didn't work, am I doing this right?

adam291086 · January 2, 2008

show me the part where you are setting the session

psychowolvesbane · January 2, 2008

<?php
error_reporting(E_ALL);
session_start();

//get current type selected
$a = $_GET['EditThisItemType'];

echo "Session Variable A is ". $a;
echo "<br>";

$_SESSION['Type'] = true;

// store session data
$_SESSION['Type']=$a;
?>

adam291086 · January 2, 2008

change to

<?php
error_reporting(E_ALL);
session_start();

//get current type selected
$a = $_GET['EditThisItemType'];

// store session data
$_SESSION['Type']=$a;

echo $_SESSION['Type'];
echo $a;

What is the output. I thing you are not understanding how sessions work.

?>

psychowolvesbane · January 2, 2008

No, I'm not :'(

Anyway, I get


Notice: Undefined index: EditThisItemType in /home/www/psychowolvesbane.freehostia.com/admin/edit_item_type_form.php on line 6


1
3
Session Type is now
New Item Type is now One Piece
UPDATE ItemType SET ItemType = 'One Piece' WHERE ItemType ='' is sqlUpdate
1 is rsUpdate
0 is number of affected rows
5

Which doesn't display anything for either of the Session variables 'Type' or '$a'.

adam291086 · January 2, 2008

you are sure the url has EditThisItemType in it

psychowolvesbane · January 2, 2008

Take a look for yourself, http://psychowolvesbane.freehostia.com/admin/edit_item_type_form.php?EditThisItemType=One%20Pieces

adam291086 · January 2, 2008

it is echoing correctly. LOL. Look in the top left cornor it say what the url EditThisItemType is set to.

psychowolvesbane · January 2, 2008

I know! It just won't play ball and send the info over through the submit!

adam291086 · January 2, 2008

right so whats on that line 6 where the error is once submit is clicked

Sign In

[SOLVED] MySQL Update Query problem

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information