Gecko [ www.foryou-vip.com ]

Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.112
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
CONFLICTS	5 B	-rw-rw-r--	2022-10-31 11:36
bug44618.phpt	1.61 KB	-rw-rw-r--	2022-10-31 11:36
bug46050.phpt	532 B	-rw-rw-r--	2022-10-31 11:36
bug47803.phpt	3.26 KB	-rw-rw-r--	2022-10-31 11:36
bug60616.phpt	1.97 KB	-rw-rw-r--	2022-10-31 11:36
bug68087.phpt	1.22 KB	-rw-rw-r--	2022-10-31 11:36
bug69354.phpt	845 B	-rw-rw-r--	2022-10-31 11:36
bug69975.phpt	726 B	-rw-rw-r--	2022-10-31 11:36
bug71171.phpt	838 B	-rw-rw-r--	2022-10-31 11:36
bug73448.phpt	1.14 KB	-rw-rw-r--	2022-10-31 11:36
bug73725.phpt	947 B	-rw-rw-r--	2022-10-31 11:36
bug78470.phpt	342 B	-rw-rw-r--	2022-10-31 11:36
bug78473.phpt	343 B	-rw-rw-r--	2022-10-31 11:36
bug80147.phpt	677 B	-rw-rw-r--	2022-10-31 11:36
bug80152.phpt	598 B	-rw-rw-r--	2022-10-31 11:36
config.inc	292 B	-rw-rw-r--	2022-10-31 11:36
odbc_columnprivileges_001.phpt	651 B	-rw-rw-r--	2022-10-31 11:36
odbc_columns_001.phpt	615 B	-rw-rw-r--	2022-10-31 11:36
odbc_data_source_001.phpt	621 B	-rw-rw-r--	2022-10-31 11:36
odbc_exec_001.phpt	950 B	-rw-rw-r--	2022-10-31 11:36
odbc_exec_002.phpt	678 B	-rw-rw-r--	2022-10-31 11:36
odbc_free_result_001.phpt	1.25 KB	-rw-rw-r--	2022-10-31 11:36
odbc_tables_001.phpt	612 B	-rw-rw-r--	2022-10-31 11:36
skipif.inc	192 B	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
odbc_exec(): Getting accurate date data from query
--SKIPIF--
<?php include 'skipif.inc'; ?>
--FILE--
<?php

include 'config.inc';

$id_1_date = '2014-09-23';
$id_2_date = '2014-09-24';

$conn = odbc_connect($dsn, $user, $pass);

@odbc_exec($conn, 'CREATE DATABASE odbcTEST');

odbc_exec($conn, 'CREATE TABLE FOO (ID INT, VARCHAR_COL VARCHAR(100), DATE_COL DATE)');

odbc_exec($conn, "INSERT INTO FOO(ID, VARCHAR_COL, DATE_COL) VALUES (1, 'hello', '$id_1_date')");
odbc_exec($conn, "INSERT INTO FOO(ID, VARCHAR_COL, DATE_COL) VALUES (2, 'helloagain', '$id_2_date')");

$res = odbc_exec($conn, 'SELECT * FROM FOO ORDER BY ID ASC');

while(odbc_fetch_row($res)) {
	$id = odbc_result($res, "ID");
	$varchar_col = odbc_result($res, "VARCHAR_COL");
	$date = odbc_result($res, "DATE_COL");

if ($id == 1) {
		if ($date != $id_1_date) {
			print "Date_1 mismatched\n";
		} else {
			print "Date_1 matched\n";
		}
	} else {
		if ($date != $id_2_date) {
			print "Date_2 mismatched\n";
		} else {
			print "Date_2 matched\n";
		}
	}
}

?>
--EXPECT--
Date_1 matched
Date_2 matched
--CLEAN--
<?php
include 'config.inc';

$conn = odbc_connect($dsn, $user, $pass);

odbc_exec($conn, 'DROP TABLE FOO');
odbc_exec($conn, 'DROP DATABASE odbcTEST');