Edit text retrieved from oracle table
|
Nandhu |
2008-04-22 14:59:53 |
Hi,
I have retrieved a data from the database table and displayed it in a table format in a php file. Now i've got to edit that retieved data when a link "EDIT" is clicked, using php.
for e.g.,
file1.php:
=========
NAME SUBJECT MARKS ACTION
Nandhu Maths 78 Edit
----
Benhur English 80 Edit
----
Is that possible?
|
Veselin |
2008-04-23 09:05:16 |
yes you can edit the data. You need to create a web page (edit.php) with a form and input fields for each data element. Then next to each record in the table you have will put an edit link which passes record id e.g. edit.php?id=1, edit.php?id=2, ... When the edit.php page is opened you will select only the record with selected ID and fill in the values in the input fields. Then upon submitting the form you should run update query to change the record.
|
Nandhu |
2008-04-23 09:19:49 |
Yes Thank u....
But, this isn't a form im using in this file1.php
i'm just using a table for display...
jus have a look at the foll. coding....
<?
$LoginRequired="No";
include("templates/npes_adminheader.php");
?>
<?
$q=db_query("select * from supregistration");
$r=db_fetch_object($q);
?>
<table width=96% align=center border=1 cellpadding=0 cellspacing=0 height=300>
<tr>
<td class=formtitle align=center>S.No.</td>
<td class=formtitle align=center>Supplier ID</td>
<td class=formtitle align=center>Main Product Name</td>
<td class=formtitle align=center>Action</td>
</tr>
<?
while($res=db_fetch_object($q))
{?>
<tr>
<td class=formdata align=center><?=$res->CompanyReg_id?></td>
<td class=formdata align=center><?=$res->CompanyReg_id?></td>
<td class=formdata><?=$res->companyname?></td>
<td class=formdata align=center><a href=edit_suplist.php>Edit</a></td>
</tr>
<?
}
?>
</table>
Here when i click on the link 'EDIT' i should be able to edit the field 'Main Product' for every record.
So is dat possible?
|
Veselin |
2008-04-23 09:25:38 |
using JavaScript (or Ajax) you can make it edit the record without refreshing the page. But easier is to click on edit link and open new page with form and all fields values filled in.
|
Nandhu |
2008-04-23 09:30:34 |
Thanks for ur suggestion.
ok... I'll make a try n get back to u...
|
Nandhu |
2008-04-23 11:49:03 |
I opted for the easier method u suggested n I got it. Thanks a lot...