Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › PHP Explode Search Results

PHP Explode Search Results

Thread began 6/21/2012 1:23 pm by Daryl | Last modified 6/21/2012 2:07 pm by Jason Byrnes | 4455 views | 3 replies |

6/21/2012 1:23 pm | #1 DarylBeta Tester

PHP Explode Search Results

I have a Data Assist database search which works OK, but I am trying to figure out how to explode the result so that only the first sentence that contains the keyword is shown by looking for the deliminator of a fullstop and a space.

Has anyone else done this?

6/21/2012 1:30 pm | #2 Ian S

Yes... In the Data Assist Search GUI there is a value type of keyword.

I use it frequently for checkbox arrays.

Choose that and it should work OK

Cheers
Ian

6/21/2012 1:34 pm | #3 DarylBeta Tester

Hi Ian

I am using Keyword as the type, but this shows the entire database record that contains that keyword.

I just want an extract of the record that contains that word

6/21/2012 2:07 pm | #4 Jason ByrnesWebAssist

here is an example outside of Data Assist Search that should help give a direction for accomplishing this:

php:

<?php

$heystack = "The quick brown fox jumps over the lazzy dog. Humpty Dumpty sat on a wall. Jack and jill went up the hill";

$retStr = $heystack;

$heystackArray = explode(". ", $heystack);

if(isset($_POST['keyword']) && $_POST['keyword'] != "") {

    $needle = $_POST['keyword'];

    for($i = 0; $i < sizeof($heystackArray); $i++) {

        $termArray = explode(" ", $heystackArray[$i]);

        if(in_array($needle, $termArray)) $retStr = $heystackArray[$i];

    }

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>Untitled Document</title>

</head>



<body>

<form id="form1" name="form1" method="post"  action="">

  <input type="text" name="keyword" id="keyword" />

  <input type="submit" name="button" id="button" value="Submit" />

</form>

<?php echo $retStr; ?>

</body>

</html>

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.