You are here: Home > Uncategorized > Get Ex Back Forum

Get Ex Back Forum

Posted in Uncategorized | January 29th, 2011

get ex back forum
What is the correct way to edit a database entry in PHP?

I fetch results with PHP by selecting a dates. I have a (lowerlimit) and (upperlimit). Ex.When i select Nov-2006, it displays all entries(journal) for the month of Nov in 2006 in a typical forum format.

I would like to add a tag at the top right of each result that comes back that would do the following. The a-href would direct the user to a different page say ‘editentry.php?y=2004&m=12&d=14 . At the top of editentry.php, id use _GET to fetch that particular entry and enter the results into a form. The form would be identical to the original form that was used to enter the information into it.

So the user would have all those entries fields in plain view. The auto-increment-primary key field and the date field would be viewable but not editable.

Anywho, at the bottom of editentry.php when all the changes are made, there would be a “submit changes” button and a “delete entry” button.

What would the mysql command be to
a)resubmit
b)delete

tyvm

Let’s assume you have a table with four columns: The uniqueid field, a datetime field called mydate, a text field called myname and a text field called mytext.

From your menu page, you would simply list off the records in a table. A column on the left would be the edit link column, and a column at the right would be the delete column.

'your connection info
$rs = mysql_query("SELECT * FROM mytable");

if(mysql_num_rows( $rs ) == 0) {
echo "No records";
}
else {
echo "

“;
echo “

“;
while($row = mysql_fetch_array($rs)) {
echo “

“;
echo “

“;
}
echo “

Edit	My Name	My Date	My Text	Delete
Edit	$row[myname]	” . date( ‘F j Y g:i a’, $row['mydate']) . “	$row[mytext]	Delete

“;
}
?>

This code calls on two pages: edit.php or delete.php. It uses the uniqueid column to know which record to edit.

Let’s do delete.php first, because it’s quick and dirty. All we’ll do is run a SQL command to delete the record and kick the user back to the list page (which we’ll call list.php). We don’t need any HTML; just connect to the DB and let PHP do the work.

'your connection script

if(!isset($_GET['id'])) {
header('Location: list.php');
}
else {
$sql = "DELETE FROM mytable WHERE uniqueid = $_GET[id]";
$rs = mysql_query($sql);
header('Location: list.php');
}
?>

Edit.php is a bit more complicated. We need to both get the current record, so we have something to edit, and update the record. We first check for page postback; if it is set, we go ahead and update the record. Then, we get a recordset corresponding to the same ID, and populate the form fields with the data:

'your connection info

if(!isset($_GET['id'])) {
header('Location: list.php');
}

if(isset($_POST['submit'])) {
$sql = "UPDATE mytable SET myname = '$_POST[myname]', mydate = $_POST[mydate], mytext = '$_POST[mytext]' WHERE uniqueid = $_GET[id]";
$rs = mysql_query($sql);
}
$sql = "SELECT * FROM mytable WHERE uniqueid = $_GET[id]";
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);
?>