close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Retaining state on update of date picker and a select

Thread began 5/13/2013 8:57 am by superpac250441 | Last modified 5/16/2013 6:46 am by Jason Byrnes | 1395 views | 3 replies |

superpac250441

Retaining state on update of date picker and a select

Hi there,
1) I have this select box on an update form. Can someone tell me how to retain the previous values:

<select class="formMenufield_Medium" name="NewsCategory" id="NewsCategory" tabindex="1">
<option value="">Please select</option>
<?php
do {
?>
<option value="<?php echo $row_rsNewsCat['CategoryName']?>"><?php echo $row_rsNewsCat['CategoryName']?></option>
<?php
} while ($row_rsNewsCat = mysql_fetch_assoc($rsNewsCat));
$rows = mysql_num_rows($rsNewsCat);
if($rows > 0) {
mysql_data_seek($rsNewsCat, 0);
$row_rsNewsCat = mysql_fetch_assoc($rsNewsCat);
}
?>
</select>


2) I have a date picker and I am hoping to retain value here on the previously selected date:

<input id="Date" name="Date" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("newsarticlesupdate","Date"):"".(($row_WADAnewsarticles["Date"])?date("n/d/Y",strtotime($row_WADAnewsarticles["Date"])):"")."")); ?>" class="formTextfield_Medium" tabindex="5" onblur="hideServerError('Date_ServerError');" />

Many thanks

Sign in to reply to this post

Jason ByrnesWebAssist

For the Select List, click the list in design View.

in the property inspector, click the dynamic button, for the Slect Value Equal to ioption, click the lightning bolt icon and selct the coresponding column from the WADAnewsarticles recordset.

for the date, it is already coded to return the previously inserted date.

Sign in to reply to this post

superpac250441

Many thanks Jason. That sorted out the drop downs perfectly.

The datepicker has been more problematic. I set it to yyyy-mm-dd and got it running okay when I added the following code at line1:

<?php
if(isset($_POST['date'])) {
$_POST['date'] = date("Y-m-d", strtotime($_POST['date']));
}
?>

So on the front end page it posts eg. 2013-05-15 00:00:00

If I just want date and not time, do I change the code to:

<?php
if(isset($_POST['date'])) {
$_POST['date'] = date("Y-m-d");
}
?>

Many thanks Jason

Sign in to reply to this post

Jason ByrnesWebAssist

Because the field is a date time field, the time is required.

you can leave it off when displaying the date on the results page by using the y-m-d date format:

<?php echo(date("Y-m-d", strtotime($row_recordsetName['date']))); ?>

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...