From: diong at comcast dot net
Operating system: windows 2000
PHP version: 4.4.0
PHP Bug Type: MSSQL related
Bug description: problem returning data field
Description:
------------
when returning a char type data type from ms sql the field has an added
space at the end of it. This was not a problem in 4.3 and I just had to
copy the php_mssql.dll from the old version to 4.4 and it corrected the
problem.
Reproduce code:
---------------
I am calling a class to get the field:
$SVars = new SessionVars();
$userid = $SVars->GetVar("username");
$query = "SELECT * FROM tSecUser WHERE (SecUser='" . $userid . "')";
$resultsec = $sqlw->sqlquery($query,$cn);
$linesec = $sqlw->fetch_array($resultsec);
echo "<P>*".$linesec["SecUser"]."*";
The echo statement displays *dgering *
it should display *dgering*
here is the class for SessionVars
<?
//Define the SessionVars class
class SessionVars
{
var $seshid;
var $varname;
var $varvalue;
Function SaveVar($VarName,$VarValue)
{
$sqlw = new sqlwrapper();
$cn = $sqlw->dbcn();
Function GetVar($VarName)
{
// connect to database
$sqlw = new sqlwrapper();
$cn = $sqlw->dbcn();
// Retrieves Session Variable from SessVars Table
$sqlquery = "SELECT VarValue FROM SessVars WHERE (SessionID =
'" .
$this->seshid . "') AND (VarName = '" . $VarName . "')";
$res = $sqlw->sqlquery($sqlquery, $cn);
$row = $sqlw->fetch_row($res);
return $row[0];
}
}
?>
Expected result:
----------------
The echo statement displays *dgering *
Actual result:
--------------
it should display *dgering*
--
Edit bug report at http://bugs.php.net/?id=34497&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34497&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=34497&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=34497&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=34497&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=34497&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=34497&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=34497&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=34497&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=34497&r=support
Expected behavior: http://bugs.php.net/fix.php?id=34497&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=34497&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=34497&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=34497&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34497&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=34497&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=34497&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=34497&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=34497&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=34497&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=34497&r=mysqlcfg
