PHP 4.0 Bug #10155: Insert or update query not functioning correctly
| From: | jules at bj-design dot co dot uk | Date: | Wed, 04 Apr 2001 11:02:59 +0000 |
| Subject: | PHP 4.0 Bug #10155: Insert or update query not functioning correctly | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-50825@lists.php.net to get a copy of this message | ||
From: jules@bj-design.co.uk
Operating system: Windows NT 4.0 build 1381
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: Insert or update query not functioning correctly
The database is Access 2000 with a few tables and relations set up in the relationships area.
Put simply the update, insert and, possibly, delete querys all appear to work perfectely with no
errors reported, except that the database ends up being unchanged afterwards. The only way I have
been able to fix this is to query the same table with a select before the end of the script, the
changes are then implemented.
I have played with autocommit and commit with no effect so I figure it must be a bug in either PHP
or the ODBC drivers.
Here is one of the scripts with a totally unecessary select towards the end to make it work.
<html>
<head>
<?
/*
Site by Just Biz
http://www.justbiz.co.uk
ida@justbiz.co.uk
+ 44 (0)870 841 3040
Project: Space Windows
Routine: ModifySeries2.php
Created: 23/03/01
Descrip: Modify series number, title and description, update database. Also inserts new records.
Revision: a
Rev. Date 23/03/01
Descrip: Created.
Parameters - From ModifySeries.php form
*/
error_reporting(63);
require("Security.php");
require("OpenDatabase.php");
if($SeriesId == "-1") {
// Create append query
$Query = "insert into tbl_Series ";
$Query .= "(SeriesNumber, ShortSeriesTitle, Description) ";
$Query .= "values('$SeriesNumber', '$ShortSeriesTitle',
'$Description')";
}
else {
// Create update query
$Query = "update tbl_Series ";
$Query .= "set SeriesNumber= '$SeriesNumber', ShortSeriesTitle=
'$ShortSeriesTitle', ";
$Query .= "Description= '$Description' where (SeriesId = $SeriesId)";
}
$Result = odbc_do($Connect, $Query);
?>
<title>Space Windows - Series modified</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<?
print($Query."<br>");
$Query = "select SeriesId, SeriesNumber, ShortSeriesTitle, Description from tbl_Series";
$Result = odbc_do($Connect, $Query);
while(odbc_fetch_row($Result)) {
print(odbc_result($Result,1));
print(odbc_result($Result,2)."<br>");
}
if(!$Result) print("<br>Failed");
Print("<h3>Database Updated for Series ".$SeriesNumber."</h3>");
?> <a href="ProductSeries.php">Return to Series Page</a>
</body>
</html>
--
Edit Bug report at: http://bugs.php.net/?id=10155&edit=1