PHP/SQL, Anomalous behaviour with Assoc value

Cheeku

I am making an SQL query through PHP, and I need to retrieve a field called shipdate carrying a Datetime object.

Now,

$databk=sqlsrv_fetch_array( $qbk, SQLSRV_FETCH_ASSOC);

If I write

print_r($databk);

following is the output:

Array ( [prc_iva] => 22.00 [clientCode] => 000003 [artCode] => LEODRG-1104 [quantity] => 3 [shipdate] => DateTime Object ( [date] => 2014-04-23 00:00:00 [timezone_type] => 3 [timezone] => Europe/Belgrade ) [cod_um] => PZ [cod_art] => LEODRG-1104 [des_articolo] => SCATOLE C/FIORI PORCE [cod_immagine_small] => LEODRG-1104PIC.jpg [prz_listino] => 2.750000)

As you can see, we have the shipdate field here.

But, if I write

echo $databk['shipdate'];

the output is null/(blank string).

Now, here's why it gets creepy:

I used exactly the same query on another page. To be honest, I just copy-pasted the query so even the variable names are same. It works on the other page, but here is the problem on this page.

I need to resolve this as soon as possible. Thanks for your help, if any, in advance.

Ask for any additional information, if required. I shall be quick

EDIT2: Apparently, I couldn't echo date. But here's the new question. Why could I do it on another page. In fact, I still do. Why does it work at one place and not at the other?

Kristiyan

You stored in datebase DateTime object. Not a clear date stamp. You can try with this:

$date = $databk['shipdate'];
echo $date->format('Y-m-d');

I preffer and suggest to store in datebase only clear date. If you need help please show insert query with variables.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Emulate Python shell's "return value" behaviour

Filter anomalous and complex datasets

Golang reflection.Value behaviour

Behaviour subject initial value null?

Can Value Object have behaviour?

What does swap! with assoc and (-> % .-target .-value) syntax mean in ClojureScript?

fscanf != eof Clang compiler, anomalous behaviour

Extracting Key:Value pairs assoc with regex from string on Javascript

Correct behaviour if bound property cannot provide a value

Assoc array difference based on specific key value

Strange behaviour of default parameter value

php - sort multi dim assoc array by specific value

Return value of function in IF statement shows strange behaviour

php get value from array which stored in assoc array

How to choose a random Value from Assoc array then display the key and value

CSS [attribute~=value] selector behaviour

javascript assoc array add key value pairs unexpected result

php: variable in the href, anomalous value

Anomalous behaviours of fgets()

Why is this code showing anomalous behaviour? (form not submitted)

PHP Accessing mysqli_fetch_assoc value

Value behaviour within an object

Sorting assoc array by duplicate value on assoc array

PHP check assoc array for key, if exists, raise value by 1

Function giving precedence to GLOBAL variable instead of LOCAL - (Anomalous behaviour)

Get latest value of an Observable and a Behaviour Subject

Is reading an uninitialized value always an undefined behaviour? or are there exceptions to it?

Is "(unsigned)value" cast undefined behaviour?

Extends behaviour in js with default value

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    pump.io port in URL

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  5. 5

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  8. 8

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

  9. 9

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  10. 10

    How to remove the extra space from right in a webview?

  11. 11

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  12. 12

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  13. 13

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

  14. 14

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  15. 15

    How to use merge windows unallocated space into Ubuntu using GParted?

  16. 16

    flutter: dropdown item programmatically unselect problem

  17. 17

    Pandas - check if dataframe has negative value in any column

  18. 18

    Nuget add packages gives access denied errors

  19. 19

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  20. 20

    Generate random UUIDv4 with Elm

  21. 21

    Client secret not provided in request error with Keycloak

HotTag

Archive