= 1)) { //echo substr_count($search,' '); //echo '
'.$search.''; $search = str_replace(' ',' ',$search); } //remove multiple speech marks: while ((substr_count($search,'""') >= 1)) { $search = str_replace('""','"',$search); } //define globals so they can be returned by functions //$GLOBALS['highlight1'] = ''; //$GLOBALS['highlight2'] = ''; $GLOBALS['result'] = ''; //rem out two globals above to turn off highlighting function debug($lineno) { echo 'PHP line no: '.$lineno.''; } function test($variable,$lineno) { echo '
PHP line no: '.$lineno.' TEST VARIABLE = '.$variable.'
'; } function highlight($colloop,$thefield,$thesearch) { $fieldlength = strlen($thefield); $searchlength = strlen($thesearch); $pos = strpos($thefield, $thesearch); $stringend = $searchlength + $pos; $slice1 = substr($colloop, 0, $pos); $slice2 = substr($colloop, $pos, $searchlength); $slice3 = substr($colloop, $stringend); $GLOBALS['result'] = $slice1.$GLOBALS['highlight1'].$slice2.$GLOBALS['highlight2'].$slice3; //rebuild text with highlight // echo '
Stan Olszewski, Byram, Connecticut - Contact Me Select Vintage $change Items & Ephemera For Sale |
Enter Any Search Term In The Field Below (To See All, Just Leave Blank) And Click Search |
ERROR: Unable to open database file!
');} $row = 0; //ORG //while (!feof($fp)) { // $line = fgets($fp,2048); //use 1024 for short lines - 2048 if very long lines // $temp[$row] = explode('|', $line); // if ($sortby == 'firstname') {$sortkey = strtolower($temp[$row][0]);} // if ($sortby == 'writer') {$sortkey = strtolower($temp[$row][1]);} // if ($sortby == 'director') {$sortkey = strtolower($temp[$row][2]);} // if ($sortby == 'producer') {$sortkey = strtolower($temp[$row][3]);} // if ($sortby == 'aired') {$sortkey = strtolower($temp[$row][4]);} // array_unshift($temp[$row], $sortkey); //add sortkey to start of array // $col[$row] = $sortkey.'|'.$temp[$row][1].'|'.$temp[$row][2].'|'.$temp[$row][3].'|'.$temp[$row][4].'|'.$temp[$row][5]; // $row++; //} while (!feof($fp)) { $line = fgets($fp,2048); //use 1024 for short lines - 2048 if very long lines $temp[$row] = explode('|', $line); if ($sortby == 'seq') {$sortkey = strtolower($temp[$row][0]);} if ($sortby == 'codeOZ') {$sortkey = strtolower($temp[$row][1]);} if ($sortby == 'code') {$sortkey = strtolower($temp[$row][2]);} if ($sortby == 'description') {$sortkey = strtolower($temp[$row][3]);} if ($sortby == 'condition') {$sortkey = strtolower($temp[$row][4]);} if ($sortby == 'notes') {$sortkey = strtolower($temp[$row][5]);} if ($sortby == 'tmb') {$sortkey = strtolower($temp[$row][6]);} if ($sortby == 'view') {$sortkey = strtolower($temp[$row][7]);} if ($sortby == 'price') {$sortkey = strtolower($temp[$row][8]);} if ($sortby == 'keyword') {$sortkey = strtolower($temp[$row][9]);} if ($sortby == 'quantity') {$sortkey = strtolower($temp[$row][10]);} if ($sortby == 'ORD') {$sortkey = strtolower($temp[$row][11]);} if ($sortby == 'state') {$sortkey = strtolower($temp[$row][12]);} if ($sortby == 'code1sort') {$sortkey = strtolower($temp[$row][13]);} if ($sortby == 'code2sort') {$sortkey = strtolower($temp[$row][14]);} array_unshift($temp[$row], $sortkey); //add sortkey to start of array $col[$row] = $sortkey.'|'.$temp[$row][1].'|'.$temp[$row][2].'|'.$temp[$row][3].'|'.$temp[$row][4].'|'.$temp[$row][5].'|'.$temp[$row][6].'|'.$temp[$row][7].'|'.$temp[$row][8].'|'.$temp[$row][9].'|'.$temp[$row][10].'|'.$temp[$row][11].'|'.$temp[$row][12].'|'.$temp[$row][13]; $row++; } fclose($fp); sort($col); reset($col); /* echo ''; print_r($col); exit; */ $arrays = count($col) - 1; $tablecells = ''; $loop = -1; $and = $once = $found = $found1 = $found2 = $bothfound = $search2also = 'no'; $count = 0; $speechmarks = ''; //test for AND but not two words that must be together (""): if ((strstr($search,' AND ')) and ($search[0] <> '"')) { $and = 'yes'; list ($word1, $word2, $word3) = explode (' ', $search); //remove AND $word1 = strtolower($word1); $word3 = strtolower($word3); if ($word1 == $word3) { $search = $word1; $and = 'no'; } else { $search1 = $word1; $search2 = $word3; while ($loop < $arrays) { $loop++; $field = strtolower($col[$loop]); if ((strstr($field,$search1)) and (strstr($field,$search2))) { $found = $found1 = $found2 = $bothfound = 'yes'; //word1 highlight($col[$loop],$field,$search1); $col[$loop] = $GLOBALS['result']; //word2 $field = strtolower($col[$loop]); //update field to include highlighted version from above highlight($col[$loop],$field,$search2); //add rows $col[$loop] = explode('|',$GLOBALS['result']); $tablecells.=''; $count++; } } } } if (($and == 'no') and ($bothfound == 'no')) { $search = strtolower($search); $search1 = $search2 = ''; if (strstr($search,' ')) { list ($search1, $search2) = explode (' ', $search); if ($search2 == $search1) {//when both words are the same $search = $search1; //make search just first word $search1 = $search2 = ''; //destroy both words from split } } //test for space in search but not two words that must be together (""): if ((strstr($search,' ')) and ($search[0] <> '"')) { list ($search1, $search2) = explode (' ', $search); //search for two separate words while ($loop < $arrays) { $loop++; $search2also = 'no'; $field = strtolower($col[$loop]); $fieldkept = $field; //preserve text without web code if (strstr($field,$search1)) { if (strstr($field,$search2)) {$search2also = $bothfound = 'yes';} $found = $found1 = 'yes'; highlight($col[$loop],$field,$search1); $col[$loop] = $GLOBALS['result']; if ($search2also <> 'yes') { //only output once when both words on same row //add rows $col[$loop] = explode('|',$GLOBALS['result']); $tablecells.=' '.$col[$loop][3].' '.$col[$loop][4].' '.$col[$loop][5].' '.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'
View Front ImagePrice: $'.$col[$loop][9].'
Check out now'; $count++; } } $field = strtolower($col[$loop]); //update field to include highlighted version from above if (strstr($fieldkept,$search2)) { //search on line without highlighting added $found = $found2 = 'yes'; highlight($col[$loop],$field,$search2); if (($search2also == 'yes') or ($found2 == 'yes')) { //add rows $col[$loop] = explode('|',$GLOBALS['result']); $tablecells.=' '.$col[$loop][3].' '.$col[$loop][4].' '.$col[$loop][5].' '.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'
View Front ImagePrice: $'.$col[$loop][9].'
Check out now'; $count++; } } } } else { //check if speech marks and remove them: if ($search[0] == '"') { $search = str_replace('"','',$search); $speechmarks = '\''; //for output later } if ($search <> '') { //do normal search while ($loop < $arrays) { $loop++; $field = strtolower($col[$loop]); if (strstr($field,$search)) { $found = $found1 = 'yes'; highlight($col[$loop],$field,$search); //add rows $col[$loop] = explode('|',$GLOBALS['result']); $tablecells.=' '.$col[$loop][3].' '.$col[$loop][4].' '.$col[$loop][5].' '.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'
View Front ImagePrice: $'.$col[$loop][9].'
Check out now'; $count++; } } } else {exit('No usable search string found!');} } } //if ($and == 'no') //ORG //echo ' '.$col[$loop][3].' '.$col[$loop][4].' '.$col[$loop][5].' '.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'
View Front ImagePrice: $'.$col[$loop][9].'
Check out nowYour search for \''.$speechmarks.$search.$speechmarks.'\' was found in the following '.$count.' lines of the database:
(FROM TWO LINES DOWN) //CHANGE if ($found == 'yes') { echo 'Browsing table of '.$count.' '.$change2.' Items
This table is sortable, just click on any heading.
Code | Description | Condition | Notes | View | Buy |
---|
Your search for \''.$speechmarks.$search.$speechmarks.'\' was not found.
'; } echo '