I have a couple of text data type fields in a MS SQL Server 2000 database. It stores
the data in the table without any problem. However, when I go to display the data on a
PHP page it is being truncated after 255 characters.
Any suggestions?
Jimmy
This document may contain information covere
In your sample code the value is being truncated because size="2" -- so only 2
characters are being assigned to $_POST['Q']
Addslahses should work...
Based on your example here is how (I changed the size to 50:
And my user enters:2 " copper tubing
$q = addslashes($_POST['Q']; // new valu
If you compiled PHP with DOM support you can use XML to create dynamic trees.
Here's a link to an article that uses XML...it's in ASP but the code could be
converted to PHP.
http://xefteri.com/articles/may312002/default.aspx
Hope this helps,
Jimmy Brock
-Original Message-
From: Galbre
I don't use this product, but I know some non-programs that use ASAP
http://www.data-asap.com/
It creates many db functions: add, edit, delete, and search records.
Jimmy Brock
-Original Message-
From: Michal Masa [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 11:36 AM
To: [E
Open your php.ini file and uncomment the line:
extension=php_mssql.dll
Happy coding,
Jimmy Brock
-Original Message-
From: Santhosh Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 5:17 AM
To: PHP DB; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP - MSSQL - LINUX
Hi Madhu,
These are not errors...they are warnings...which is why it opens the file.
Check the permissions on this file so the account that your web server uses has
read/write permissions. On my server it is 'www'. Once you fix this warning the other
two warnings should go away as well.
Hope this Helps,