| Re: Edit a record? [message #176207 is a reply to message #176199] |
Sun, 04 December 2011 13:54   |
Arno Welzel
Messages: 317
Registered: October 2011
Karma:
|
Senior Member |
|
|
Charles, 2011-12-03 14:28:
> I'm working on an application. I'm trying to implement an update
> process that pulls a record out of a MySQL database, updates it, and
> puts it back.
>
> Broken down, let's assume I have a database made up of the fields:
> First_name
> Last_name
> Month_of_birth
> Day_of_birth
> Year_of_birth
Why not a simple DATE field for birth date?
> The steps I'm finding so far are:
>
> 1) Present a data entry form to enter the values on which the record
> selection is based (an HTML form with 5 input fields...this I have).
> 1) Query the database for the record (Submit for processing to a PHP
> script that opensn the database and submits the values for a SELECT
> query).
>
> =========={this is where I am stuck]==============
>
> 3) Somehow import those returned values into a form for editting.
Why are you stuck? It's simple to output the values just using echo or
similar. E.g. if the first name fetched from the db is in $db_firstname:
<input
name="firstname"
type="text"
value="<?php echo htmlspecialchars($db_firstname); ?>" />
And if you want to present multiple records, just create names with an
index, starting with 0 and increased by 1 with every record:
<input
name="firstname[<?php echo $db_rownum; ?>]"
type="text"
value="<?php echo htmlspecialchars($db_firstname); ?>" />
> 4) Indicate somehow (in the form) which records (if more than one)
> need to be returned as updated to the MySQL database.
One possible way:
Pass the original values as hidden fields in the form, so you can
compare the modified fields with the original values.
OR:
Store the current values as session variables, so you can compare them
with the modified fields.
> 5) Somehow post to database
Just use an UPDATE statement in MySQL.
Maybe you should start by learnig the basics about SQL databases,
session handling and form handling in PHP.
--
Arno Welzel
http://arnowelzel.de
http://de-rec-fahrrad.de
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]