Problem printing MSSQL datetime to html using PHP (sqlsrv extension)

Question

I've got a flexible block of code that allows me to print the results of a query to a simple html table. However, when that table contains a field of type 'datetime', the print() function doesn't work and my loop ends.

In the past, using PHP and MySQL (as opposed to Microsoft SQL Server, which is what I'm using now) printing the date was no problem, so I'm not sure what I'm missing now.

Here's the code:

// $row is the current row.
// $nkeys is the array of (String) keys that correspond to columns in the table.
do {
    print ("<tr>\n");
    foreach($nkeys as $k) {
        echo ("<td>$row[$k]</td>");
    } 
    print ("</tr>\n");
} while ($row = sqlsrv_fetch_array($stmt));

Is there a special function other than print() or echo that will properly print the date?

Álvaro González · Accepted Answer · 2013-11-25 16:54:17Z

4

The SQLSRV extension returns DateTime objects. Just format it to your liking:

if( !is_null($row[$k]) ){
    echo $row[$k]->format('r');
}

In the procedural interface you are using you can also disable the feature by providing a ReturnDatesAsStrings connection option (this option is not available in the PDO interface) but there's normally no reason to do so.

edited Nov 25, 2013 at 16:54

answered Jul 27, 2011 at 14:28

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gee · Accepted Answer · 2013-12-11 21:18:33Z

1

Very important to have this in your connection string when using date fields in jqGrid.

"ReturnDatesAsStrings"=>true

Great stuff, thanks Mrigesh !

answered Dec 11, 2013 at 21:18

Gee

111 bronze badge

Comments

the Tin Man · Accepted Answer · 2012-10-27 16:53:23Z

0

When using SQLSRV, you can't use something like:

date('d/m/y', strtotime($row['ActivityDate']))

Instead, you have to use:

date_format($row['ActivityDate'], 'd/m/y')

edited Oct 27, 2012 at 16:53

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered Jan 5, 2012 at 0:42

kurdtpage

3,2631 gold badge26 silver badges24 bronze badges

Comments

Mrigesh Raj Shrestha · Accepted Answer · 2013-02-21 08:25:48Z

0

Although you can change the behavior of returning Date Time Object by SQLSRV. This can be done by keeping ReturnDatesAsStrings TRUE in connection option. Changing connection code like below will do the trick:

$link = sqlsrv_connect( $db_server_name, array( "UID"=>$db_user,
            "PWD"=>$db_pass,
            "Database"=>$db_name,
            "ReturnDatesAsStrings"=>true
          ));

With this your existing code echo ("<td>$row[$k]</td>"); will return the values without any other workaround. Consider this if you have got many spots to apply "->format('r')".

answered Feb 21, 2013 at 8:25

Mrigesh Raj Shrestha

6204 silver badges16 bronze badges

Collectives™ on Stack Overflow

Problem printing MSSQL datetime to html using PHP (sqlsrv extension)

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related