Author Topic: Dreamboard pretraga  (Read 29402 times)

0 Members and 1 Guest are viewing this topic.

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Dreamboard pretraga
« on: March 22, 2008, 07:41:27 PM »
Hteo bih da pitam u vezi Dreamboard_a dali je moguce nekako postaviti pretragu na forumu ?  :(
« Last Edit: April 19, 2008, 12:30:34 AM by milance »

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Dreamboard pretraga
« Reply #1 on: March 30, 2008, 10:46:02 AM »
cao milance,

kako mislis?
samo search box?
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Dreamboard pretraga
« Reply #2 on: March 30, 2008, 06:50:12 PM »
Da samo za forum ako moze, Pozdrav

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Dreamboard pretraga
« Reply #3 on: March 30, 2008, 08:27:50 PM »
je si li probao već ovako

Code: [Select]
<form method="post" action="./search.php">
<input type="text" name="search_keywords" size="15" />
<input type="submit" value="Pretraži" name="submit" />
</form>
?
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Dreamboard pretraga
« Reply #4 on: April 02, 2008, 05:48:45 PM »
 :( Izvini al gde da ga kopiram he he  :mrgreen: Pozdrav

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Dreamboard pretraga
« Reply #5 on: April 02, 2008, 07:33:35 PM »
probaj da ubaciš u neki templates od dreamboard-a
npr. dreamboardv21\templates\board.html
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Dreamboard pretraga
« Reply #6 on: April 02, 2008, 09:31:09 PM »
Ne radi probao sam mislim da negde treba nesto da se ubaci u vezi databaze sql i kljucnih reci ali to je za mene visa matematika he he a i ovde na forumu sam trazio i nishta. Ipak hvala  :wink:

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Dreamboard pretraga
« Reply #7 on: April 04, 2008, 06:42:42 PM »
daj da vidim kako to izgleda kada ubacis..
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Dreamboard pretraga
« Reply #8 on: May 23, 2008, 08:33:55 PM »
Izvini shto me duze vreme nema da odgovorim odustao sam od toga .
Pozdrav  :wink:

Offline milance

  • Newbie
  • *
  • Posts: 28
    • View Profile
Re: Dreamboard pretraga
« Reply #9 on: September 27, 2008, 02:27:09 PM »
Zdravo
Dali ova skripta moze da se prilagodi za Dreamboard pretragu ?.
Nije mi jasno ono" $query = "SELECT * FROM itd... field1...
hvala
Code: [Select]
<?php 

$hostname_logon 
"xxx" ;   
$database_logon "xxx" ;  
$username_logon "xxx" ;  
$password_logon "xxx" ;   
//open database connection
 
$connections mysql_connect($hostname_logon$username_logon$password_logon) or die ( "Unabale to connect to the database" );
 
//select database
 
mysql_select_db($database_logon) or die ( "Unable to select database!" );

//specify how many results to display per page
$limit 10;

// Get the search variable from URL
  
$var = @$_GET['q'] ;
//trim whitespace from the stored variable
  
$trimmed trim($var);  
//separate key-phrases into keywords
  
$trimmed_array explode(" ",$trimmed); 

// check for an empty string and display a message.
if ($trimmed == "") {
  
$resultmsg =  "<p>Search Error</p><p>Please enter a search...</p>" ;
  }

// check for a search parameter
if (!isset($var)){
  
$resultmsg =  "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;
  }
// Build SQL Query for each keyword entered 
foreach ($trimmed_array as $trimm){
      
// EDIT HERE and specify your table and field names for the SQL query
     
$query "SELECT * FROM tablename WHERE field1 LIKE '%$trimm%' OR field2 like '%$trimm%' OR field3 like '%$trimm%' ORDER BY field1  DESC" 
     
// Execute the query to  get number of rows that contain search kewords
     
$numresults=mysql_query ($query);
     
$row_num_links_main =mysql_num_rows ($numresults);

     
// next determine if 's' has been passed to script, if not use 0.
     // 's' is a variable that gets set as we navigate the search result pages.
     
if (empty($s)) {
         
$s=0;
     }

      
// now let's get results.
      
$query .= " LIMIT $s,$limit;
      
$numresults mysql_query ($query) or die ( "Couldn't execute query" );
      
$rowmysql_fetch_array ($numresults);

      
//store record id of every item that contains the keyword in the array we need to do this to avoid display of duplicate search result.
      
do{
          
$adid_array[] = $row'fieldid' ];
      }while( 
$rowmysql_fetch_array($numresults));
 } 
//end foreach

if($row_num_links_main == && $row_set_num == 0){
   
$resultmsg "<p>Search results for: "$trimmed."</p><p>Sorry, your search returned zero results</p>" ;
}
   
//delete duplicate record id's from the array. To do this we will use array_unique function
   
$tmparr array_unique($adid_array); 
   
$i=0
   foreach (
$tmparr as $v) { 
       
$newarr[$i] = $v
       
$i++; 
   } 

// now you can display the results returned. But first we will display the search form on the top of the page
?>


<form action="search.php" method="get" name="search">
  <div align="center">
      <input name="q" type="text" value=" <?php echo $q?> " size="15">
      <input name="search" type="submit" value="Search">
  </div>
</form>

<?php
// display what the person searched for.
 
if( isset ($resultmsg)){
  echo 
$resultmsg;
  exit();
 }else{
  echo 
"Search results for: " $var;
 }
 
foreach(
$newarr as $value){
 
// EDIT HERE and specify your table and field names for the SQL query
$query_value "SELECT * FROM tablename WHERE fieldid = '$value'";
 
$num_value=mysql_query ($query_value);
 
$row_linkcatmysql_fetch_array ($num_value);
 
$row_num_linksmysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function. 
//Replace field
  
$titlehigh preg_replace "'($var)'si" "<b> //1</b>" $row_linkcat'field1' ] );
  
$linkhigh preg_replace "'($var)'si" "<b> //1</b>" $row_linkcat'field2' ] );
  
$linkdesc preg_replace "'($var)'si" "<b> //1</b>" $row_linkcat'field3' ] );

foreach(
$trimmed_array as $trimm){
    if(
$trimm != 'b' ){
        
$titlehigh preg_replace"'($trimm)'si" ,  "<b> //1</b>" $titlehigh);
        
$linkhigh preg_replace"'($trimm)'si" "<b> //1</b>" $linkhigh);
        
$linkdesc preg_replace"'($trimm)'si" ,  "<b> //1</b>" $linkdesc); 
     }
//end highlight

?>

 <p>
<?php echo $titlehigh?><br>
<?php echo $linkhigh?><br>
<?php echo $linkhigh?>
</p>
 
<?php 
}   //end foreach $trimmed_array 
   
if($row_num_links_main $limit){
   
// next we need to do the links to other search result pages
      
if ($s>=1) { // do not display previous link if 's' is '0'
        
$prevs=($s-$limit);
         echo 
"<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit"</a></div>";
      }
     
// check to see if last page
     
$slimit =$s+$limit;
       if (!(
$slimit >= $row_num_links_main) && $row_num_links_main!=1) {
     
// not last page so display next link
          
$n=$s+$limit;
           echo 
"<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit"</a></div>";
        }
    }
}  
//end foreach $newarr
?>


Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Dreamboard pretraga
« Reply #10 on: September 30, 2008, 04:48:58 PM »
ћао миланче,

наравно да може да послужи.

само требаш да поставиш тачно како се твоја табела зове и наравно која поље треба бити претражено.

поздрав.
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi