jdimino Posted April 20, 2009 Share Posted April 20, 2009 Hello Need to write a program that will search all files in a directory/sub directories (SEArchive/a-z) in mysql database and echo the image. probably some sort of a loop code? can somone tell me what needs to be changed to make it wotk <?PHP $link = mysql_connect('localhost', 'XXXX_jdimino', 'XXXX'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db('XXXXXX'); // Fetch total number of records $result = mysql_query("SELECT COUNT(*) AS recordCount FROM ihsreg"); $row = mysql_fetch_assoc($result); $recordCount = $row['recordCount']; // Perform Search $results = array(); if(isset($_REQUEST['search'])){ $limit = 20; if($_GET['offset']){ $offset = $_GET['offset']; } else { $offset = 0; } $SQL = "SELECT * FROM ihsreg "; //$term = strtoupper(addslashes($_REQUEST['search'])); $term = strtoupper($_REQUEST['search']); if(stristr($term,"'") && !stristr($term,"\'")){ $term = addslashes($term); } if($_REQUEST['radiobutton']){ switch($_REQUEST['radiobutton']){ case '1': $SQL.=" WHERE Bloom_Name LIKE \"$term\""; break; case '2': $SQL.=" WHERE Pod_Name LIKE \"$term\""; break; case '3': $SQL.=" WHERE Pollen_Name LIKE \"$term\""; break; case '4': $SQL.=" WHERE Hybridiser LIKE \"$term\""; break; case '5': $SQL.=" WHERE Origin LIKE \"$term\""; break; case '6': $SQL.=" WHERE Grower LIKE \"$term\""; break; case '7': $SQL.=" WHERE Color_Group LIKE \"$term\""; break; case '8': $SQL.=" WHERE Bloom_Type LIKE \"$term\""; break; case '9': $SQL.=" WHERE Reg_Mini LIKE \"$term\""; break; case '10': $SQL.=" WHERE Size_Range LIKE \"$term\""; break; case '11': $SQL.=" WHERE Propagation LIKE \"$term\""; break; case '12': $SQL.=" WHERE Bloom_Color LIKE \"$term\""; break; case '13': $SQL.=" WHERE Bloom_Characteristics LIKE \"$term\""; break; case '14': $SQL.=" WHERE Leaf_Characteristics LIKE \"$term\""; break; case '15': $SQL.=" WHERE Bush_Characteristics LIKE \"$term\""; break; case '24': $SQL.=" WHERE Cross_Made LIKE \"$term\""; break; case '25': $SQL.=" WHERE date LIKE \"$term\""; break; default: $SQL.=" WHERE Bloom_Name LIKE \"$term\""; break; } // switch } else { // If they didnt' select a radio button... $SQL.=" WHERE Bloom_Name LIKE \"$term\""; } $result = mysql_query($SQL); $resultCount = mysql_num_rows($result); $SQL.= " LIMIT $offset, $limit"; $result = mysql_query($SQL); if($resultCount > 0){ while($row = mysql_fetch_assoc($result)){ $results[$row['id']] = $row; } // while } // if there are results } // if user performed a search ?> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html"> <script type="text/javascript"> Link to comment https://forums.phpfreaks.com/topic/154920-how-to-search-a-string-in-multiple-sub-directories/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.