Adding PHP to change data in Date Input Calendar

[multichild]

Hello,

Im building a CMS and one of the parts needs a date calendar so the user can input the start and end date of contracts.

Im using one of the tools from this site which is Jason's Date Input Calendar and have posted the code below for you to see how its currently being used.



<script type="text/javascript" src="calendarDateInput.js">

<script>DateInput('dateoriginal', true, 'YYYY-MM-DD')</script>


All works fine, but I am trying to do is get the date to change when the client tries to edit this contract, to reflect the date that has been set in the database.

So I was thinking something like this, but its not working:



<script>DateInput('dateoriginal', true, 'YYYY-MM-DD', '<?php $cStart; ?>')</script>


$cEnd is the variable for the corresponding field, and its a MSSQL database and the datetime field is set as YYYY-MM-DD

I just tried also to echo the date out of the database and it wont do it, so do I need to sort of get the code right first to handle a date before displaying it.
This is how my PHP looks and im using a MSSQL database.



$queryEdit="select * from CSF_Intranet where Contract_Number=$customer_Number";
$rowsEdit = sqlsrv_query($conn, $queryEdit);
while ($rows = sqlsrv_fetch_array($rowsEdit, SQLSRV_FETCH_ASSOC)) {

$cStart=$rows["Contract_Start"];



Cheers

[fastsol1]

I think you have the right concept. I have done this with the same js code you are using but it's been a while. In your example above you forgot to echo $cStart in the js code, so that may be part of it. Here is what I used

<script type="text/javascript">DateInput('sp_start', false<?php if(isset($sp_start)){if (!empty($sp_start)){echo ",'YYYY-MM-DD', '$sp_start'";}}?>)</script>

[multichild]

Hi there, thank you for getting back to me.

Is it just the case that you can just assign a value to a variable as below when pulling a date down from the database:


$queryEdit="select * from CSF_Intranet where Contract_Number=$customer_Number";
$rowsEdit = sqlsrv_query($conn, $queryEdit);
while ($rows = sqlsrv_fetch_array($rowsEdit, SQLSRV_FETCH_ASSOC)) {
$cStart=$rows["Contract_Start"];}


Or do I need to add extra code to it to allow it to recognise its a date and not just simply a number or a character.

The reason Im asking is because when I am in the stock update bit it doesnt display properly until I changed 'false' to true, and then in the update/edit part there is a problem as the date update widget doesnt show and the rest of the page doesnt display either.



<script type="text/javascript">DateInput('dateoriginal', true<?php if(isset($cStart)){if (!empty($cStart)){echo ",'YYYY-MM-DD', '$cStart'";}}?>)</script>


Ive had a go and Im wondering if this is it, but it messes the whole thing up then and the date changeer doesnt display.



$cStart=date_format($rows['Contract_Start'],'Y/M/D');




Thanks

[multichild]

OK I think I can see an obvious problem here and not sure how to fix it, which might be why its not displaying.

Here is my code to start off with as it is now:



$queryEdit="select * from CSF_Intranet where Contract_Number=$customer_Number";
$rowsEdit = sqlsrv_query($conn, $queryEdit);
while ($rows = sqlsrv_fetch_array($rowsEdit, SQLSRV_FETCH_ASSOC)) {
$cStart=date_format($rows["Contract_Start"],"M/D/Y");


Which seems to work fine.

Then I have this:



<script type="text/javascript">DateInput('dateoriginal', true<?php if(isset($cStart)){if (!empty($cStart)){echo ",'YYYY-MM-DD', '$cStart'";}}?>)</script>


I then echo'd out $cStart and this is what I got.


Jan/Thu/2012

When what I need is the week day bit to be a number date as it is the database. Not sure how Im going ot get around this.

[fastsol1]

What does this look like if you echo it - $rows["Contract_Start"]

[multichild]

Hi fastsol1,

I tried that and all it does is stop the whole page from working if I put it in the isset script as shown, or it stops the rest of the page loading if I put it where in its place in the form.

[multichild]

OK I have made a little bit of progress.

I have changed the way I grab the date from the database to below:



$cStart = date("m-d-Y", strtotime(Contract_Start));
echo $cStart;


And echo'd it out and it came back with this below:

01-01-1970

But the date in the database is this:

2012-01-12

But another bit of progress is that the date calendar is also working but with the wrong date above 70-01-01, and for that I'm using the code below:



<script type="text/javascript">DateInput('dateoriginal', false<?php if(isset($cStart)){if (!empty($cStart)){echo ",'MM-DD-YYYY', '$cStart'";}}?>)</script>


The date calendar is displaying:

Jan 1 1970

So I'm not sure whats going on here.

Getting there I think.