ID: 24125
Updated by: [EMAIL PROTECTED]
Reported By: michael at redboxcode dot com
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: Win NT
PHP Version: 4.3.2
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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
