[PHP] Re: verify text in field
PJ wrote: Is there a shorter way of determining if a field contains text? This works but I wonder if I can K.I.S.S. it? I really only need to know if there is or is not a field containing the text specified. I don't need to see it. ?php // Request the text $text = Joe of Egypt; $sql = SELECT title FROM book WHERE title LIKE '$text'; $result = mysql_query($sql); if (!$result) { echo(PError performing query: . mysql_error() . /P); exit(); } // Display the text while ( $row = mysql_fetch_array($result) ) { echo(P . $row[title] . /P); } if ($row[title] == ) echo (Empty!) ? // Request the text $text = Joe of Egypt; $sql = SELECT title FROM book WHERE title LIKE '%$text%'; $result = mysql_query($sql); if (!$result) { die(PError performing query: . mysql_error() . /P); } if (mysql_num_rows($result) 0) { // you found text } -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: verify text in field
Shawn McKenzie wrote: PJ wrote: Is there a shorter way of determining if a field contains text? This works but I wonder if I can K.I.S.S. it? I really only need to know if there is or is not a field containing the text specified. I don't need to see it. ?php // Request the text $text = Joe of Egypt; $sql = SELECT title FROM book WHERE title LIKE '$text'; $result = mysql_query($sql); if (!$result) { echo(PError performing query: . mysql_error() . /P); exit(); } // Display the text while ( $row = mysql_fetch_array($result) ) { echo(P . $row[title] . /P); } if ($row[title] == ) echo (Empty!) ? // Request the text $text = Joe of Egypt; $sql = SELECT title FROM book WHERE title LIKE '%$text%'; $result = mysql_query($sql); if (!$result) { die(PError performing query: . mysql_error() . /P); } if (mysql_num_rows($result) 0) { // you found text } Not relevant to your question, but you should be able to shorten it up more like this: --instead of this: $result = mysql_query($sql); if (!$result) { die(PError performing query: . mysql_error() . /P); } --try this: $result = mysql_query($sql) or die(PError performing query: . mysql_error() . /P); -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: verify text in field
PJ wrote: Is there a shorter way of determining if a field contains text? This works but I wonder if I can K.I.S.S. it? I really only need to know if there is or is not a field containing the text specified. I don't need to see it. ?php // Request the text $text = Joe of Egypt; $sql = SELECT title FROM book WHERE title LIKE '$text'; $result = mysql_query($sql); if (!$result) { echo(PError performing query: . mysql_error() . /P); exit(); } // Display the text while ( $row = mysql_fetch_array($result) ) { echo(P . $row[title] . /P); } if ($row[title] == ) echo (Empty!) ? In addition to other answers, don't forget to escape the string you are passing to the query with mysql_real_escape_string(), otherwise your query will have problems with some characters e.g. apostrophe. Cheers -- David Robley I refuse to make an agenda, Tom said listlessly. Today is Pungenday, the 58th day of Chaos in the YOLD 3175. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php