![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 PHP Extension Manual » Cursor Functions » edb_locate |
edb_locate(<CursorHandle>, <SearchValues>, [<CaseInsSearch> [, <PartialSearch>]]) <CursorHandle> = Handle of cursor returned by edb_execute function <SearchValues> = Associative array of column names and values <CaseInsSearch> = Perform a case-insensitive search (STRING values only) <PartialSearch> = Perform a partial search on the last search value (STRING values only)
TRUE if successful, or FALSE if there are any errors
<?php // The following script connects to an ElevateDB // Server and database, prepares and executes a // direct table open, and then performs a case-insensitive, // partial-length locate using the edb_locate() // 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,"customer",EDB_COMMAND_TABLE); $cursor = edb_execute($cmd); if (edb_locate($cursor,array("State"=>"FL"),FALSE)) { echo "Row found"; } else { echo "Row not found"; } 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 ? ![]() |