![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 PHP Extension Manual » Cursor Functions » edb_colcount |
edb_colcount(<CursorHandle>) <CursorHandle> = Handle of cursor returned by edb_execute function
Cursor column count (INTEGER) if successful, or FALSE if there are any errors
<?php // The following script connects to an ElevateDB // Server and database, prepares a parameterized // SELECT statement, sets the parameter values, // executes the statement, and then displays the // result set in an HTML table by looping through // the columns using the edb_colcount() function $con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+ "uid=Administrator;pwd=EDBDefault;database=Test"); if (!$con) { die("Could not connect: " . edb_errmsg()); } $cmd = edb_prepare($con,"SELECT * FROM customer WHERE State=:State"); edb_setparam($cmd,"State","FL"); $cursor = edb_execute($cmd); echo "<table border=\"1\" cellpadding=\"3\">"; echo "<tr>"; // Dump out the column headers for ($i = 0; $i < edb_colcount($cursor); $i++) { $colinfo = edb_colinfo($cursor,$i); echo "<td>" . $colinfo["Name"] . "</td>"; } echo "</tr>"; // Now dump out the rows while (!edb_eof($cursor)): echo "<tr>"; for ($i = 0; $i < edb_colcount($cursor); $i++) { $col = edb_getcol($cursor,$i); if (is_null($col)) echo "<td>NULL</td>"; else echo "<td>" . $col . "</td>"; } echo "</tr>"; edb_next($cursor); endwhile; echo "</table>"; edb_disconnect($con); ?>
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |