472,958 Members | 2,642 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

Update row via HTML form

A little problem I've run into is the following.

I have a script that allows a user to edit a story.

I have an HTML form for title and main_text which gets it's values by pulling the selected data from the database.

If the user either

i) doesn't change anything, and then saves.
ii)enters the exact same text.

[php]if (mysql_affected_rows() == 1) [/php]

fails, so an error message is output.

But in fact there is no error, as everything ran fine.

Hopefully I explained that alright.

Do you have any ideas on how to ffix this problem?


Here is the full code
# Filename - edit_story.php
# Date - 9th August 2007
# Author - Stephen Hoult
# Author Email - stephen@hoult.org.uk

// This file allows logged in users to edit a story.

// Include config file for error management and such

// Set page title and include HTML header
$page_title = 'Edit a Story';

// If no first_name variable exists, redirect the user.
if (!isset($_SESSION['first_name'])) {

// Start defining the URL.
$url = 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']);
// Check for a trailing slash.
if ((substr($url, -1) == '/') OR (substr($url, -1) == '\\') ) {
$url = substr ($url, 0, -1); // Chop off the slash.

// Add the page.
$url .= '/login.php';

ob_end_clean(); // Delete the buffer.
header("Location: $url");
exit(); // Quit the script.

} else { // First name variable exists - user is logged in

// Connect to the Database

if (isset($_POST['submitted'])) { // if the form has beeen submitted

// Get story ID
if (isset($_POST['id'])) {
$id = escape_data($_POST['id']);

} else {
$id = FALSE;

// Handle the form

// Validate title
if(!empty($_POST['title'])) {
$t = escape_data($_POST['title']);
} else {
echo '<p><font color="red" size="+1">Please enter a title.</font></p>';

// Validate main text
if(!empty($_POST['main_text'])) {
$mt = escape_data($_POST['main_text']);
} else {
echo '<p><font color="red" size="+1">Please enter the main text.</font></p>';

// Check that the ID exists in the database.
// Build query
$query = "SELECT id, title, main_text FROM content WHERE id = $id";
$result = mysql_query($query);
$num = mysql_num_rows($result);

if ($num == 1) { // If a row was found by the query - ie the story id exists in the table.

// Update the database
$query = "UPDATE content SET title='$t', main_text='$mt' WHERE id = $id";
$result = mysql_query($query);

// Check to see if update was successful
if (mysql_affected_rows() == 1) { // If 1 row was affected by the update
echo '<p>The story has been edited.</p>';

} else {
echo '<p><font color="red" size="+1">The story could not be updated. Please try again</font></p>';
}// End If update was successful

} else {
echo '<p><font color="red" size="+1">The selected ID does not exist in the database. Please try again.</font></p>';
} // End mysql_num_rows() to see if id exists in the table.

} else { // The form has not yet been submitted - Display the form

// Get story ID
if (isset($_GET['id'])) {
$id = escape_data($_GET['id']);

} else {
$id = FALSE;

$query = "SELECT id, title, main_text FROM content WHERE id = $id";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

<fieldset><legend>Edit a story</legend>

<form action="edit_story.php" method="post" >

<p>Title: <input type="text" name="title" size="30" maxlength="50" value="<?php if (isset($_POST['title'])) {echo $_POST['title'];
} else { echo $row['title'];} ?>" /></p>

<p>Main Text<textarea name="main_text" cols="40" rows="5"/><?php if (isset($_POST['main_text'])) {echo $_POST['main_text'];
} else { echo $row['main_text'];} ?></textarea></p>

<p><input type="submit" name="submit" value="Submit" /></p>
<input type="hidden" name="submitted" value="TRUE" />
<input type="hidden" name="id" value="<?php $_POST['id'] = $id; echo $_POST['id'] ;?>">



}// End of if is submitted

} // End of is logged in

include('./includes/footer.html'); // Include HTML footer
Aug 11 '07 #1
5 2417
I assume one way to do this would be to add a field 'modified_on' as a timestamp, to my database and add the appropriate values to the query.

Then when updated, even if none of the title, or main text changes, the 'modified_on' field would, so the error would not be kicked out.
Aug 11 '07 #2
5,058 Expert 4TB
Try changing
Expand|Select|Wrap|Line Numbers
  1. if(mysql_affected_rows() == 1)
Expand|Select|Wrap|Line Numbers
  1. if($result)
If a query failes, the $result is always FALSE. But when a query is successful it either retuns data, or it retuns TRUE which will both be evaluated as true in an if statement.
Aug 11 '07 #3
Thanks that works great.

I tried adding a timestamp as i thought about in post #2 and updating it when the query runs and it also worked great.
Aug 11 '07 #4
5,058 Expert 4TB
Glad I could help.

The timestamp thing is a good idea. You could add a 'Last edited at' thing to your stories :)
Aug 11 '07 #5
Yeah that was what I thought when I was thinking about adding the TIMESTAMP.

Although in hindsight it may be easier in the long run to use DATETIME instead of TIMESTAMP .

This would save having to convert back and forth between the two whe outputing the Last modified date and time.

Thanks for your help. :)
Aug 11 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Mark | last post by:
A beginner in this area, I have been able to read a record from a MySQL database and populate an HTML form (wow!). Now, my goal is to allow the user to edit the contents of the form and then...
by: Fredrik/Sweden | last post by:
Hi folks ! got this problem... i have a table 'Accounts' in my database, which contains a bunch of users. From the main menu i choose "edit user" and all users in the db are presented in a table....
by: mursyidatun ismail | last post by:
Dear all, database use: Ms Access. platform: .Net i'm trying to update a record/records in a table called t_doctors by clicking da edit link provided in the database. when i ran through da...
by: Metal2You | last post by:
I'm working on an ASP.NET 2.0 application in Visual Studio 2005 that accesses a Sybase database back end. We're using Sybase SQL Anywhere I have installed and registered the Sybase...
by: cover | last post by:
I have an input form that passes data when submitted to a second form to let the user know what they have just entered into the db. My question comes with using 'update'. I'd like to query the...
by: teenagelcruise | last post by:
hi, i have a problem with my code which is i cannot update and addnew data into the database but i can delete the data.plz give me an idea.this is my code that i wrote. <html> <head> <meta...
by: ARC | last post by:
Hello all, So I'm knee deep in this import utility program, and am coming up with all sorts of "gotcha's!". 1st off. On a "Find Duplicates Query", does anyone have a good solution for...
by: stantron | last post by:
Setup: I only have one database with one table in it. The first page has a form that adds a record (w/ 6 fields in it) to the mySQL database's lone table via PHP. This works fine. I also have a PHP...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.