Cannot display values from MySql in text fields when JQuery datepicker is used.

[angel1987]

Hello all, I have been searching for hours on google for answer but i couldnt find anything. So i have this "edit your post" form which is a set of text fields, text area, radio buttons and two datepicker calendar fields.

 

I am getting the data from the MySql table to display it in these form fields and the submit button will simply fire Update query. But the problem is that when i add datepicker JQuery to this form, it does not display any values in the text fields from database but only in textarea box.

 

Below is the JQuery script that i am using...

 

<link rel="stylesheet" href="css/themes/base/jquery-ui.css" />

<script src="js/jquery-1.9.1.js"></script>
<script src="js/ui/jquery-ui.js"></script>

<script>
$(function() {
$( "#datepicker" ).datepicker();
$( "#datepicker2" ).datepicker();
});
</script>

This is the form that is supposed to display values from database table. When i remove the above Javascript, it works. And when i use the above script, it shows values as Undefined for all the textfields.

<form name="frmPost" method="post" action="">
	<table border="0" cellpadding="5" cellspacing="5">
		<tr><td>Title : </td></tr>
		<tr><td><input type="text" name="txttitle" size="75" value="<?php echo $title; ?>"/></td></tr>
		
		<tr><td valign="top">Description : </td></tr>
		<tr><td><textarea name="txtdescription" rows="10" cols="75" ><?php echo $description; ?></textarea></td></tr>
		
		<tr><td>Listing End date : </td></tr>
		<tr><td><input type="text" name="txtenddate" value="<?php echo $enddate; ?>" id="datepicker"/></td></tr>
			
		<tr><td>Project Completion Dead line : </td></tr>
		<tr><td><input type="text" name="txtdeadline" value="<?php echo $deadline; ?>" id="datepicker2"/></td></tr>
		
		<?php if($ptype=='w') { ?>
		<tr><td>
			<input type="radio" name="txttype" value="w" checked> Web Based
			<input type="radio" name="txttype" value="s">Desktop Based
		</td></tr>

		<?php } else if($ptype=='s') { ?>
		<tr><td>
			<input type="radio" name="txttype" value="w">Web Based
			<input type="radio" name="txttype" value="s" checked>Desktop Based
		</td></tr>

		<?php } else { ?>
		<tr><td>
			<input type="radio" name="txttype" value="w">Web Based
			<input type="radio" name="txttype" value="s">Desktop Based
		</td></tr>
		<?php }	?>

		<tr><td><input type="submit" name="btnupdate" value="Update" class="button" /></td></tr>
	</table>
</form>

 

I need some help in fixing this.

 

[rgopal101]

the date picker can't work if u use the value="some thing".

if u want to see the date from the database then remove the id of the input .

here you can change the date manual not by using the date picker.

Edited March 5, 2013 by rgopal101