[Resolved] update data problem!

[sirTemplar]

this is my php to output a search:

search.php

if ($EVENTYEAR == "")  

{$EVENTYEAR = '%';}  

if ($EVENTDATE == "")  

{$EVENTDATE = '%';} 

if ($id == "")  

{$id = '%';}

// Change this to fit your database 

$result = mysql_query ("SELECT * FROM table 
                         WHERE EVENTYEAR LIKE '%$EVENTYEAR%' 
                         AND EVENTDATE LIKE '%$EVENTDATE%' 
						 ORDER BY DAY ASC, EVENTYEAR
                       ",$conn);  

$resultall = mysql_query ("SELECT * FROM table");

$totalrecs = mysql_num_rows($resultall);
$totalrows = mysql_num_rows($result);

if ($row = mysql_fetch_array($result)) {  

do {  

if (($row["DAY"]) == "00")

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td>
<a href=edit.php?id=<?={$row['id']}?>edit</a> 
<a href=deletedata.php?id=<?={$row['id']}?>delete</a></td></table>"; 
}

else

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td>
<a href=edit.php?id=<?={$row['id']}?>edit</a> 
<a href=deletedata.php?id=<?={$row['id']}?>delete</a></td></td></table>"; 
}

  echo ("<p>");  

  echo ("<p>"); 
} while($row = mysql_fetch_array($result));  

} else {print "<font face=Verdana size=2 color=#FF0000><b>Sorry, no records were found!</font></b>";}   

?>

</td>
      </tr>
    </table>
    </td>

  </tr>

</table>
<?
echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<td align=left width=70% valign=top><font face=Verdana size=2 color=#FF0000><b>$totalrows</b></font><font face=Verdana size=2 color=#800000> out of </font><b><font face=Verdana size=2 color=#FF0000>$totalrecs</font></b><font face=Verdana size=2 color=#800000> record(s) found !</font></b></td></table>"; 
?>

this outputs the record with the edit or delete option.

when i press the edit, it goes to the edit.php which is:

edit.php

$sql="SELECT * FROM table"; 
$result=mysql_query($sql,$db); 

$row = mysql_fetch_array($result); 

$EVENTDATE = $row["EVENTDATE"]; 
$EVENTTEXT = $row["EVENTTEXT"]; 
$id=$_POST['id'];


if ($submit =="Edit") {  

if($EVENTDATE == "" || $EVENTTEXT == "") {  
    $error ="Sorry!You didn't fill in all the fields! Please fill in the correct information !";  
} else {  
    $query = "Update thisday set EVENTDATE='$EVENTDATE', EVENTTEXT='$EVENTTEXT' where id =$id";          
    $result = mysql_query($query) or die (" echo mysql_error() ");          
    echo"Thank You!Your Information Is Updated";  
}  

} else { 

//echo "data not updated"; 
} 


?> 

<p><b><font face="Verdana" size="4"><font color="#FF0000">EDIT DATA: </font><br>
<font color="#FFFF00">TODAY IN HISTORY</font></font></b><br>
<br>
<b><font face="Verdana" size="2" color="#FFFFFF">To edit event:</font></b></p>
<?


echo "<form method=post action=<edit.php>
  <p><font face=Verdana>
  <input type=hidden name=id value=$id> 
  <input type=text name=EVENTDATE size=10 
  value=$EVENTDATE maxlength=10><font size=2>";
echo "<b><font color=#FFFFFF>Date (format should be: </font><font color=#FF0000>
  YYYY-MM-DD)</font></b></font></font></p>
  <p><font face=Verdana><textarea rows=7 cols=40 name=EVENTTEXT value=$EVENTTEXT</textarea><font size=2 <font color=#FFFFFF><b>Text </b></font>
  <br><br></font>"; 
echo "<input type=submit value=Edit name=B1><input type=reset value=Reset name=B2></font></p>
</form>";
?>

the problem is that it puts the first data on the database even if i select other data, and it is not updating.

please help!

[barand]

if ($submit =="Edit") {

but the submit button has name "B1", therefore

if ($B1 =="Edit") {

[sirTemplar]

that did not change anything pal! 🙁

[barand]

What about

$B1 = $_POST['B1'];

if ($B1 =="Edit") {

[leatherback]

Hi,

As far as I can tell, you are not submitting the variable &submit. You are using a link to get to the edit page, where you only pass the $id variable (Or did I miss something??).

So:
In the link include &submit=edit

Instead of using $POST['variable'] you may have to use $GET['variable'] to get the vars.

[sirTemplar]

this is what i added on the search.php to get to the edit.php

<a href=edit.php?id={$row['id']}&submit=edit>edit</a> 

on edit.php i changed to what you suggested:

$id=$_GET['id']; 

still giving me the data with the 1 as id! i cannot update!

[sirTemplar]

let me give you again the complete code!

search.php

if ($EVENTYEAR == "")  

{$EVENTYEAR = '%';}  

if ($EVENTDATE == "")  

{$EVENTDATE = '%';} 

if ($id == "")  

{$id = '%';}

// Change this to fit your database 

$result = mysql_query ("SELECT * FROM table
                         WHERE EVENTYEAR LIKE '%$EVENTYEAR%' 
                         AND EVENTDATE LIKE '%$EVENTDATE%' 
						 ORDER BY DAY ASC, EVENTYEAR
                       ",$conn);  

$resultall = mysql_query ("SELECT * FROM table");

$totalrecs = mysql_num_rows($resultall);
$totalrows = mysql_num_rows($result);

if ($row = mysql_fetch_array($result)) {  

do {  

if (($row["DAY"]) == "00")

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td>
<a href=edit.php?id={$row['id']}&submit=edit>edit</a> 
<a href=deletedata.php?id={$row['id']}>delete</a></td></td></table>"; 
}

else

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td>
<a href=editphp?id={$row['id']}&submit=edit>edit</a> 
<a href=deletedata.php?id={$row['id']}>delete</a></td></td></table>"; 
}

  echo ("<p>");  

  echo ("<p>"); 
} while($row = mysql_fetch_array($result));  

} else {print "<font face=Verdana size=2 color=#FF0000><b>Sorry, no records were found!</font></b>";}   

?>

the edit.php

$db = mysql_connect("localhost", "user", "password"); 
mysql_select_db("database",$db); 

$sql="SELECT * FROM table"; 
$result=mysql_query($sql,$db); 

$row = mysql_fetch_array($result); 

$EVENTDATE = $row["EVENTDATE"]; 
$EVENTTEXT = $row["EVENTTEXT"]; 
$id=$_GET['id']; 

if ($B1 =="Edit") {  

if($EVENTDATE == "" || $EVENTTEXT == "") {  
    $error ="Sorry!You didn't fill in all the fields! Please fill in the correct information !";  
} else {  
    $query = "Update thisday set EVENTDATE='$EVENTDATE', EVENTTEXT='$EVENTTEXT' where id =$id";          
    $result = mysql_query($query) or die (" echo mysql_error() ");          
    echo"Thank You!Your Information Is Updated";  
}  

} else { 

//echo "data not updated"; 
} 


?> 

<p><b><font face="Verdana" size="4"><font color="#FF0000">EDIT DATA: </font><br>
<font color="#FFFF00">TODAY IN HISTORY</font></font></b><br>
<br>
<b><font face="Verdana" size="2" color="#FFFFFF">To edit event:</font></b></p>
<?


echo "<form method=post action=<edit.php>
  <p><font face=Verdana>
  <input type=hidden name=id value=$row[id]> 
  <input type=text name=EVENTDATE size=10 
  value=$row[EVENTDATE] maxlength=10><font size=2>";
echo "<b><font color=#FFFFFF>Date (format should be: </font><font color=#FF0000>
  YYYY-MM-DD)</font></b></font></font></p>
  <p><font face=Verdana><textarea rows=7 cols=40 name=EVENTTEXT value=$row[EVENTTEXT]</textarea><font size=2 <font color=#FFFFFF><b>Text </b></font>
  <br><br></font>"; 
echo "<input type=submit value=Edit name=B1><input type=reset value=Reset name=B2></font></p>
</form>";
?>

[leatherback]

Hi,

What does the link look like? Does it show ?id=1&.. or something like ?id=345&...

[sirTemplar]

the link looks like this:

edit.php?id=45&submit=edit

[barand]

Have I got this right

If you click on the link from the first form you want to display the record for editing

so you have $id = $_GET['id']

and if $_GET'submit'] == 'Edit'

select the record whose id is $id and display in form fields.

When edited, $_POST['B1'] == 'Edit'
so update the record.

Is that it?

[sirTemplar]

that's what exactly what i want to do barand! but still can't get it to work.

the links on the search now looks like this:

<a href=edit.php?id={$row['id']}&submit=edit>edit</a> 

the edit.php looks like this:

$db = mysql_connect("localhost", "user", "password"); 
mysql_select_db("database",$db); 

$sql="SELECT * FROM table"; 
$result=mysql_query($sql,$db); 

$row = mysql_fetch_array($result); 

$EVENTDATE = $row["EVENTDATE"]; 
$EVENTTEXT = $row["EVENTTEXT"]; 
$id=$_GET['id']; 


if ($B1 =="Edit") {  

if($EVENTDATE == "" || $EVENTTEXT == "") {  
    $error ="Sorry!You didn't fill in all the fields! Please fill in the correct information !";  
} else {  
    $query = "Update thisday set EVENTDATE='$EVENTDATE', EVENTTEXT='$EVENTTEXT' where id =$id";          
    $result = mysql_query($query) or die (" echo mysql_error() ");          
    echo"Thank You!Your Information Is Updated";  
}  

} else { 

//echo "data not updated"; 
} 


?> 

<p><b><font face="Verdana" size="4"><font color="#FF0000">EDIT DATA: </font><br>
<font color="#FFFF00">TODAY IN HISTORY</font></font></b><br>
<br>
<b><font face="Verdana" size="2" color="#FFFFFF">To edit event:</font></b></p>
<?


echo "<form method=post action=<editphp>
  <p><font face=Verdana>
  <input type=hidden name=id value=$row[id]> 
  <input type=text name=EVENTDATE size=10 
  value=$row[EVENTDATE] maxlength=10><font size=2>";
echo "<b><font color=#FFFFFF>Date (format should be: </font><font color=#FF0000>
  YYYY-MM-DD)</font></b></font></font></p>
  <p><font face=Verdana><textarea rows=7 cols=40 name=EVENTTEXT value=$row[EVENTTEXT]</textarea><font size=2 <font color=#FFFFFF><b>Text </b></font>
  <br><br></font>"; 
echo "<input type=submit value=Edit name=B1><input type=reset value=Reset name=B2></font></p>
</form>";
?>

it is still giving me the the first data from the database. and cannot edit!

[barand]

You were always selecting all records and reading just the first.

I've rearranged things a little for you

<?
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("database",$db);



if ($_POST['B1'] =="Edit") {
    $id=$_POST['id'];
    $EVENTDATE = $_POST['EVENTDATE']; // edit
    $EVENTTEXT = $_POST['EVENTTEXT']; // edit

if($EVENTDATE == "" || $EVENTTEXT == "") {
    $error ="Sorry!You didn't fill in all the fields! Please fill in the correct information !";
} else {
    $query = "Update thisday set EVENTDATE='$EVENTDATE', EVENTTEXT='$EVENTTEXT' where id =$id";
    $result = mysql_query($query) or die (" echo mysql_error() ");
    echo"Thank You!Your Information Is Updated";
}

} else {

echo "data not updated";
}



if ($_GET['submit']=='Edit') {

?>

<p><b><font face="Verdana" size="4"><font color="#FF0000">EDIT DATA: </font><br>
<font color="#FFFF00">TODAY IN HISTORY</font></font></b><br>
<br>
<b><font face="Verdana" size="2" color="#FFFFFF">To edit event:</font></b></p>
<?

$id=$_GET['id'];
$sql="SELECT * FROM table WHERE id = $id";
$result=mysql_query($sql,$db);

$row = mysql_fetch_array($result);

$EVENTDATE = $row["EVENTDATE"];
$EVENTTEXT = $row["EVENTTEXT"];


echo "<form method=post action=<editphp>
  <p><font face=Verdana>
  <input type=hidden name=id value=$row[id]>
  <input type=text name=EVENTDATE size=10
  value=$row[EVENTDATE] maxlength=10><font size=2>";
echo "<b><font color=#FFFFFF>Date (format should be: </font><font color=#FF0000>
  YYYY-MM-DD)</font></b></font></font></p>
  <p><font face=Verdana><textarea rows=7 cols=40 name=EVENTTEXT value=$row[EVENTTEXT]</textarea><font size=2 <font color=#FFFFFF><b>Text </b></font>
  <br><br></font>";
echo "<input type=submit value=Edit name=B1><input type=reset value=Reset name=B2></font></p>
</form>";

} // submit==edit

hth

[sirTemplar]

thanks for the patience. i tried that one but it when i click th edit i go to a page with:

data not updated

[barand]

Sorry, got a bit mixed up with the {}'s

MkII version

<?
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("database",$db);
$error = '';


if ($_POST['B1'] =="Edit") {
    $id=$_POST['id'];

if($EVENTDATE == "" || $EVENTTEXT == "") {
    $error ="Sorry!You didn't fill in all the fields! Please fill in the correct information !";
} else {
    $query = "Update thisday set EVENTDATE='$EVENTDATE', EVENTTEXT='$EVENTTEXT' where id =$id";
    $result = mysql_query($query) or die (" echo mysql_error() ");
    echo"Thank You!Your Information Is Updated";


// put link back to first form here     ****************

exit;

}
}



if (($_GET['submit']=='Edit') || ($error != '')) {

?>

<p><b><font face="Verdana" size="4"><font color="#FF0000">EDIT DATA: </font><br>
<font color="#FFFF00">TODAY IN HISTORY</font></font></b><br>
<br>
<b><font face="Verdana" size="2" color="#FFFFFF">To edit event:</font></b></p>
<?

$id=$_GET['id'];
$sql="SELECT * FROM table WHERE id = $id";
$result=mysql_query($sql,$db);

$row = mysql_fetch_array($result);

$EVENTDATE = $row["EVENTDATE"];
$EVENTTEXT = $row["EVENTTEXT"];


echo "<form method=post action=<editphp>
  <p><font face=Verdana>
  <input type=hidden name=id value=$row[id]>
  <input type=text name=EVENTDATE size=10
  value=$row[EVENTDATE] maxlength=10><font size=2>";
echo "<b><font color=#FFFFFF>Date (format should be: </font><font color=#FF0000>
  YYYY-MM-DD)</font></b></font></font></p>
  <p><font face=Verdana><textarea rows=7 cols=40 name=EVENTTEXT value=$row[EVENTTEXT]</textarea><font size=2 <font color=#FFFFFF><b>Text </b></font>
  <br><br></font>";
echo "<input type=submit value=Edit name=B1><input type=reset value=Reset name=B2></font></p>
</form>";

} // submit==edit

[barand]

Just editted to move return link position and the exit up a bit

[barand]

I just noticed you textarea. Does not have value, the 'value' is the text between the tags

<textarea rows=7 cols=40 name=EVENTTEXT>$row[EVENTTEXT]</textarea>

[sirTemplar]

now when i click the edit. i just go to a blank page!

[barand]

The edit link from first page or B1 from edit form?

[sirTemplar]

this is the url when i try to click the edit on search.php

http://www.mypage/mypage/mypage/edit.php?id=2

[sirTemplar]

i am not getting an edit form!

i have search.php that lists all the data. on the output there is the edit link (edit.php) where i want the edit form and where i want to edit and submit! sorry for all the problems!