ID: 24125
User updated by: michael at redboxcode dot com
Reported By: michael at redboxcode dot com
-Status: Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Win NT
-PHP Version: 4.3.2
+PHP Version: 4.3.1
New Comment:
please note: I noticed that I am actually on version 4.3.1
Windows NT localhost 4.0 build 1381
inserting a record then reading the database works in this code
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
// First insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
echo $result." = ".$sql_command."\n";
// this will work correctly
?>
reading the database and THEN inserting the records does NOT work in
this code.
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
// first read the table
$sql_command = "select * from mytable order by time_stamp;";
$rsDetail = odbc_exec($connect_id, $sql_command);
// Now insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
// The command returns a valid results, but the record is NOT in the
database
?>
Previous Comments:
------------------------------------------------------------------------
[2003-06-12 05:44:39] [EMAIL PROTECTED]
Maybe I didn't stress enough the word SHORT example script..? :)
Can you please make this ONE file and max. 15 lines.
No HTML either, please.
------------------------------------------------------------------------
[2003-06-11 23:17:35] michael at redboxcode dot com
note: these files, the access database and phpinfo() are zipped at
www.redboxcode.com/Michael.zip
************************* page1.php *******************
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
echo "<html>\n";
echo "<head>\n";
echo "<title>Insert record then read table</title>\n";
echo "</head>\n";
echo "<body>\n";
// First insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
echo "<br>".$result." = ".$sql_command."<br>";
// Display the table
$sql_command = "select * from mytable order by time_stamp;";
$rsDetail = odbc_exec($connect_id, $sql_command);
echo "<br>".$rsDetail." = ".$sql_command."<br>";
$more_records = odbc_fetch_row($rsDetail);
echo "<table border=1><tr><th>id</th><th>name</th><th>time
stamp</th></tr>\n";
while ($more_records)
{
echo "<tr><td>".odbc_result($rsDetail,'id')."</td>";
echo "<td>".odbc_result($rsDetail,'name')."</td>";
echo "<td>".odbc_result($rsDetail,'time_stamp')."</td></tr>\n";
$more_records = odbc_fetch_row($rsDetail);
}
echo "</table>\n";
echo "<br><a href='page2.php'>Next try to read table then insert a
record</a><br>";
echo "<br><a href='page3.php'>Clear the table</a><br>";
echo "</body>\n";
echo "</html>\n";
?>
************************* page2.php *******************
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
echo "<html>\n";
echo "<head>\n";
echo "<title>Read table then insert a record</title>\n";
echo "</head>\n";
echo "<body>\n";
// Display the table
$sql_command = "select * from mytable order by time_stamp;";
$rsDetail = odbc_exec($connect_id, $sql_command);
echo "<br>".$rsDetail." = ".$sql_command."<br>";
$more_records = odbc_fetch_row($rsDetail);
echo "<table border=1><tr><th>id</th><th>name</th><th>time
stamp</th></tr>\n";
while ($more_records)
{
echo "<tr><td>".odbc_result($rsDetail,'id')."</td>";
echo "<td>".odbc_result($rsDetail,'name')."</td>";
echo "<td>".odbc_result($rsDetail,'time_stamp')."</td></tr>\n";
$more_records = odbc_fetch_row($rsDetail);
}
echo "</table>\n";
// Now insert a record into the database
$sql_command = "insert into mytable (name,time_stamp) values
('Michael','".date("F j G:i:s")."');";
$result = odbc_exec( $connect_id, $sql_command );
echo "<br>".$result." = ".$sql_command."<br>";
echo "<br><a href='page1.php'>Back to insert a record then display
table</a><br>";
echo "<br><a href='page3.php'>Clear the table</a><br>";
echo "</body>\n";
echo "</html>\n";
?>
************************* page3.php *******************
<?PHP
$connect_id = odbc_pconnect("mydata","",0) or die ("Cannot connect to
database");
echo "<html>\n";
echo "<head>\n";
echo "<title>Clear the table and start over</title>\n";
echo "</head>\n";
echo "<body>\n";
// Clear mytable database
$sql_command = "delete * from mytable;";
$result = odbc_exec( $connect_id, $sql_command );
echo "<br>".$result." = ".$sql_command."<br>";
// Display the table
$sql_command = "select * from mytable order by time_stamp;";
$rsDetail = odbc_exec($connect_id, $sql_command);
echo "<br>".$rsDetail." = ".$sql_command."<br>";
$more_records = odbc_fetch_row($rsDetail);
echo "<table border=1><tr><th>id</th><th>name</th><th>time
stamp</th></tr>\n";
while ($more_records)
{
echo "<tr><td>".odbc_result($rsDetail,'id')."</td>";
echo "<td>".odbc_result($rsDetail,'name')."</td>";
echo "<td>".odbc_result($rsDetail,'time_stamp')."</td></tr>\n";
$more_records = odbc_fetch_row($rsDetail);
}
echo "</table>\n";
echo "<br><a href='page1.php'>Insert a record then display the
table</a><br>";
echo "<br><a href='page2.php'>Display the table then insert a
record</a><br>";
echo "</body>\n";
echo "</html>\n";
?>
------------------------------------------------------------------------
[2003-06-11 12:13:31] [EMAIL PROTECTED]
You should have added the short sample without us having to ask for
it..(doesn't this read in the help page for "how to report" ??)
------------------------------------------------------------------------
[2003-06-11 09:58:29] michael at redboxcode dot com
This problem went away when I changed odbc_Pconnect to just
odbc_connect
If I read a table then attempt to insert a record to the table the
results are reported successful but the record is NOT added.
If I insert the record then read the table it works correctly.
Changing the pconnect to connect corrected the problem.
If you need additional info, please email. I can strip down the scripts
to create a sample of the problem.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24125&edit=1
