Collections:
PHP ODBC - Searching Records by Keywords
PHP ODBC - How To Perform Key Word Search in Tables?
✍: Guest
The simplest way to perform key word search is to use the SELECT statement with a LIKE operator in the WHERE clause. The LIKE operator allows you to match a text field with a keyword pattern specified as '%keyword%', where (%) represents any number of any characters. Any single quote (') in the keyword needs to be protected by replacing them with two single quotes (''). The tutorial exercise below shows you how to search for records whose "notes" contains "e":
<?php $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter'); $key = "e"; $key = str_replace("'", "''", $key); $sql = "SELECT id, url, notes FROM fyi_links" . " WHERE notes LIKE '%".$key."%'"; $res = odbc_exec($con, $sql); while ($row = odbc_fetch_array($res)) { print($row['id'].", ".$row['url'].", " . $row['notes']."\n"); } odbc_free_result($res); odbc_close($con); ?>
If you run this script, you will get something like this:
102, dba.fyicenter.com, Nice site. 202, www.yahoo.com, It's another search engine! 301, netscape.com, Added long time ago! 302, myspace.com, Added today!
⇒ PHP ODBC - Query Multiple Tables Jointly
⇐ PHP ODBC - Computing Date and Time Differences
⇑ SQL Server FAQs - PHP ODBC Functions - Managing Tables and Data Rows
2024-05-05, 1224🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...