Connecting to a new Database in PHP

[dcebb2001]

I have been searching for that on google all morning. Can’t find it. That’s why I am back here asking for help.

[astonecipher]

Just checking, in an actual RDBMS you can. I don’t deal with anything in access and haven’t for a number of years and wasn’t sure.

The example Jim showed will take a time string, that comes from access, and convert it to a datetime object. You can then format it how you wish to display the new format.

[JimL]

I’m not sure what to do with that code. Here is the line that the result containing the data coming out with those milliseconds, etc. is in. How do I modify this line by itself to make sure that the result only pulls in the day, month, year?

$RatingsLastUpdated = odbc_result($rs,“RatingsLastUpdated”);

That code is plug-and-play to convert your date string to the format you want. Just change my first line with your line here. It was an answer to this question:

I have data values appearing like this: 2015-08-14 00:00:00.000.

How do I get rid of the hours/minutes/seconds/milliseconds, etc? Is there a good function for that?

[hr]

Your second question - how to get it properly from the db - is a much better approach, so I suggest you go that route.

How to get a date in YYYY-MM-DD format from a TSQL datetime field?

[dcebb2001]

Yeah that didn’t work either. Instead it just put today’s date at the top of my page.

$RatingsLastUpdated = odbc_result($rs,“RatingsLastUpdated”);
$dateTime = new DateTime($RatingsLastUpdated);
echo $dateTime->format(‘m-d-Y’); // 08-14-2015

The database contains dates that I manually enter. Those appear on the site as this field: $RatingsLastUpdated. However, that field is showing up as this on the page: Ratings Last Updated: 2015-08-14 00:00:00.000.

Here is the code for that section that pulls it in.

Ratings Last Updated: <?= $RatingsLastUpdated ?>

I just want anything aside from the d/m/y to go away on the site.

[JimL]

So, it works fine. Usually when you copy/paste code you need to apply it to your use-case. Just echoing it where I did will of course echo it wherever that code is pasted. Which in this case above the rest of your output.

You are still echoing out $RatingsLastUpdated on the page, which is the value returned from the DB. To use the solution I pasted you need to change that to echo the formatted datetime value.

But, as said previously. You should change the query to return the correct value. I have no experience with MSSQL so won’t get into that.

[dcebb2001]

Thanks Jim. I really don’t know what you are talking about but what I can tell you is that I cannot change anything with the SQL itself. I cannot mess with the backend and don’t have access to it. I have to do everything on the PHP webpage itself.

[JimL]

Ok, no problem - outputting the formatted date is fine as well. It’s just generally recommended to get the wanted result set as early as possible in the code.

[dcebb2001]

Thanks. I’m giving up on this. I need an expert. Going to find a freelancer.