Re: binding data type error

On Thu, Apr 16, 2015 at 10:33 PM, hadi <almarzuki2011@hotmail.com> wrote: > > > > -----Original Message----- > > From: Aziz Saleh [mailto:azizsaleh@gmail.com] > > Sent: Friday, April 17, 2015 5:20 AM > > To: hadi > > Cc: PHP General > > Subject: Re: [PHP] binding data type error > > > > On Thu, Apr 16, 2015 at 10:02 PM, hadi <almarzuki2011@hotmail.com> > wrote: > > > > > Hi dear list, > > > > > > > > > i have php script with Microsoft database. im trying to bind > > > SQLSRV_SQLTYPE_NVARCHAR('max') but im getting error Fatal error: > > > Unknown > > > PDO::PARAM_* constant given > > > > > > here is my code > > > > > > $stmt = $con->prepare('insert into [feedtable] > > > (title,link,pubdata,description,category,image,imagelink,source) > > > values > > > (:title,:link,:pubdata,:description,:category,:image,:imagelink,:source)'); > > > > > > $stmt->bindParam(':title',$item- > > >title,SQLSRV_SQLTYPE_NVARCHAR('max')) > > > ; > > > $stmt->execute(); > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: > > > http://www.php.net/unsub.php > > > > > > > > The allowed PDO params list: > > > > http://php.net/manual/en/pdo.constants.php > > > > I think you are trying to use this instead (mixing it with PDO): > > > > http://php.net/manual/en/book.sqlsrv.php > > > > What are you trying to do here? > > Im trying to insert data to mssql with " SQLSRV_SQLTYPE_NVARCHAR('max')". > > I already have the links which you post. > > Not sure what that method does to the query, but you can not use the constant SQLSRV_SQLTYPE_NVARCHAR in PDO. You will need to use sqlsrv driver instead (as pointed out in the StackOverflow question you posted): https://msdn.microsoft.com/en-us/library/cc626305.aspx