[Resolved] help edit data

sirTemplar

can anyone help me out with this. i have a searchform and then outputs searched data in html. what i want to do is to be able to have the edit and delete option on the output! how should i do that?

sirTemplar

this is my php to search:

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

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

$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></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></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>";}

?>

this prints the results nicely but....

what i would like to do is to put an EDIT and DELETE option on the result. how should i implement that? that is when i press the EDIT button a new window will popup with the data on a form ready to be edited or when i press the DELETE button the data is deleted. please help!

bad76

Hi,
try to change this

<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td> <a href=editdata.htm>edit</a> delete</table>

into

<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td>
<td><a href=editdata.php?id=<?=$row['EVENTID']?>>edit</a>
<a href=deletedata.php?id=<?=$row['EVENTID']?>>delete</a></td></table>

where $row['EVENTID'] is your own unique key field.

In deletedata.php and editdata.php you can use this naumber to delete/edit the right entry...

see you

sirTemplar

thanks bad76.

but i really need more help. could you help me out in writing the deletedata.php and editdata.php?

pls. be patient pal!

sirTemplar

hi! i tried what you suggested. first for the edit:

the code is this:

{
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>";
}

now the edit.php is:

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"; 
}

?>

<form method="post" action="edit.php">
<p><font face="Verdana">
<input type=hidden name="id" value="<?php echo $_POST["id"]?>">
<input type="text" name="EVENTDATE" size="10"
value="<?php echo $row['EVENTDATE'] ?>" maxlength="10"><font size="2">
<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="5" name="EVENTTEXT" cols="40"></textarea><font size="2"
value="<?php echo $row['EVENTTEXT'] ?>">
<font color="#FFFFFF"><b>Text </b></font><br>
<br>
</font><input type="submit" value="Edit" name="B1"><input type="reset" value="Reset" name="B2"></font></p>
</form>

my problem is that the initial value to be edited is not shown on the form. but the url shows the number to be edited. i did not check if it actually update afterwards.

bad76

Well done.

Now to fill the form, for each input field you have to set the value param.

First, when you load edit.php make a query to retrieve the value.
The in the form form each <input> tag write <input name="myfield" value="<?=$row("myfield")?>">

this will fill the input field.

For TEXTAREA you have to put the value in tag, like this:

sirTemplar

i have already resolved this problem with your help guys, thanks again! 🙂

my new problem regards pagination. someone may wish to help me out again:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10244555