ID: 40289
Updated by: [EMAIL PROTECTED]
Reported By: podunk dot vn at gmail dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: windows xp sp2/IIS/ASAPI
PHP Version: 5.2.0
Assigned To: wez
Previous Comments:
------------------------------------------------------------------------
[2007-03-28 13:33:03] podunk dot vn at gmail dot com
SQL Server
------------------------------------------------------------------------
[2007-03-28 12:44:36] [EMAIL PROTECTED]
Are you using the "SQL Native Client" driver, or the old "SQL Server"
driver?
------------------------------------------------------------------------
[2007-01-30 18:39:48] podunk dot vn at gmail dot com
<?php
$sql = "
USE [websvr]
GO
/****** Object: Table [dbo].[cms_files] Script Date: 01/30/2007
13:25:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[cms_files](
[fid] [int] IDENTITY(1,1) NOT NULL,
[data] [varbinary](max) NULL,
[content_type] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,
[name] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[label] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pagid] [int] NOT NULL,
CONSTRAINT [PK_files] PRIMARY KEY CLUSTERED
(
[fid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
";
$db = new
PDO('odbc:DSN=******;HOSTNAME=*********;PORT=****;DBNAME=******;PROTOCOL=TCPIP;UID=********;PWD=********;');
$db->query($sql);
$db->query("SET IDENTITY_INSERT cms_files ON");
$stmt = $db->prepare("insert into cms_files
(data,content_type,name,label,pagid,fid) values (?, ?, ?, ?, ?, ?)");
$fp = fopen($_FILES['file']['tmp_name'], 'rb');
$stmt->bindParam(1, $fp, PDO::PARAM_LOB);
$stmt->bindParam(2, $_FILES['file']['type']);
$stmt->bindParam(3, $_FILES['file']['name']);
$stmt->bindParam(4, 'test');
$stmt->bindParam(5, 1);
$stmt->bindParam(6, 1);
$stmt->execute();
$stmt = $db->prepare("select content_type,data from cms_files where
fid=1");
$stmt->execute();
$stmt->bindColumn(1, $type, PDO::PARAM_STR, 256);
$stmt->bindColumn(2, $lob, PDO::PARAM_LOB);
$stmt->fetch(PDO::FETCH_BOUND);
header("Content-Type: $type");
fpassthru($lob);
print($lob);
?>
------------------------------------------------------------------------
[2007-01-30 18:03:17] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
------------------------------------------------------------------------
[2007-01-30 18:01:28] podunk dot vn at gmail dot com
The latest win32 snapshot DOES NOT fix this bug.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/40289
--
Edit this bug report at http://bugs.php.net/?id=40289&edit=1
