PHP - How To Properly Search For Names

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

Hi guys,

I am currently stuck in a situation.

I have duplicated names in my form. View duplicated.jpg for a reference.

What exactly went wrong? Any help will be greatly appreciate! How do I eliminate the duplicated names. Thanks!!

And my $count is currently not working as well, it is supposed to be 5 columns per row.

Code: [Select]
<?php
/***Pre-School Level***/
echo '<input name="level[]" type="checkbox" id="level_1" value="1">';
echo '<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>';

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or die(mysqli_error($dbc));

$query = "SELECT sl.subject_level_id, sl.level_id, sl.subject_id, tl.level_name AS level_name, ts.subject_name AS subject_name " .
        "FROM tutor_subject_level AS sl " .
        "INNER JOIN tutor_level AS tl USING (level_id) " .
        "INNER JOIN tutor_subject AS ts USING (subject_id) " .
"ORDER BY subject_level_id ASC LIMIT 7";

    $sql = mysqli_query($dbc, $query)
or die(mysqli_error($dbc));


$query1 = "SELECT subject_level_id FROM tutor_overall_level_subject WHERE tutor_id = '" . $_GET['tutor_id'] . "'";

$sql1 = mysqli_query($dbc, $query1)
or die(mysqli_error($dbc));

$selected_subjects = array();
while ($row = mysqli_fetch_array($sql1)) {
array_push($selected_subjects, $row['subject_level_id']);
}

echo'<table><tr>'; // Start your table outside the loop... and your first row
$count = 0; // Start your counter
while($data = mysqli_fetch_array($sql)) {
/*  Check to see whether or not this is a *new* row
If it is, then end the previous and start the next and restart the counter.
*/
if ($count % 5 == 0) { 
echo "</tr><tr>"; $count = 0;
}
foreach($selected_subjects as $selected_subject) {
if ($data['subject_level_id'] == $selected_subject) {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
else {
echo '<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_'.$data['subject_level_id'].'" value="'.$data['subject_level_id'].'"/>';
echo '<label for="subject_level_'.$data['subject_level_id'].'" class="subject_1">'.$data['subject_name'].'</label></td>';
$count++; //Increment the count
}
}

} 
echo '</tr></table><br/>'; //Close your last row and your table, outside the loop
?>

This is the end result of the HTML code, through 'view page source' in web browser
Code: [Select]
<input name="level[]" type="checkbox" id="level_1" value="1">

<span class="zone_text_enlarge"><label for="level_1">Pre-School</label></span><br/>

<table><tr></tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_1" value="1"/>
<label for="subject_level_1" class="subject_1">Mathematics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_2" value="2"/>
<label for="subject_level_2" class="subject_1">English</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_3" value="3"/>
<label for="subject_level_3" class="subject_1">Chinese</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_4" value="4"/>
<label for="subject_level_4" class="subject_1">Tamil</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_5" value="5"/>
<label for="subject_level_5" class="subject_1">Malay</label></td>
</tr>

<tr>
<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" checked="checked" id="subject_level_6" value="6"/>
<label for="subject_level_6" class="subject_1">Phonics</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td>

<td><input name="subject_level[]" class="subject_a" type="checkbox" id="subject_level_7" value="7"/>
<label for="subject_level_7" class="subject_1">Creative Writing</label></td></tr>

</table><br/>

Hi php freaks

I've been learning php, but what confuses me are the arrays.
I have ini file, i want to get the data from file and add it to the database. Every section makes a new table and all they keys are added with their values. I figured out how to get the keys and how to see the values, but how can i get the name of the sections. Furthermore, how do i know what keys belong to what section.

I am really grateful for person who helps me to realize how to be a good friend with those complicated arrays.

Hey , I'm looking for functions names from the GD directory.

1.function that open image.
2.function that getting pixel color.
3.function that changing pixel color.

thanks.

Hi,

I have db table that records the days (Sunday, Monday...) when the employee login to the system. Say that the employee logged in on Monday then Logged in on Wednesday so this means he was absent on Tuesday. I calculated the number of days to get the answer 2 (between Wednesday and Monday before logging in on Wednesday) how to get the name of the missing day "Tuesday"?

code:

$curdate = date("Y-m-d");
$currday = date('l');
$lastdate = $row['indate'];
$lastdayin = $row['lastdayin'];
					
if ($lastdate !=Null)
{
						
	$misseddates = strtotime($curdate) - strtotime($lastdate);
	$misseddates = $misseddates / 86400;
	echo $misseddates;
						
	$misseddays = strtotime($lastdayin) - strtotime($currday);
	$misseddays = $misseddays / 86400;
	echo $misseddays;
}

I tried to get the name of day in the last step but it only calculates 5 in numbers how to get the name. I want the answer to be "Tuesday" as of the example.

Thanks.

I am developing a intranet forum in Php and MySQL and I am using ajax to display searched results on the same page but right now I am using query LIKE text% to search in database which is slower. but I want to make it fast search engin which can parse *,+ and show result.

Since I am using ajax i am not able to use free search engin,so if possible pls provide a complete solution

I have code to search a database of members, I can search by lastname but having a little problem. I want to be able to search by lastname starting with the first letter. (ie:  a or b or c or d and so on). As it is right now I can only search by first letter of last name if I add % to the search (ie: a% b% c%) will give me all members with the last names starting with the approiate letter designation. I'm not sure how to handle this, any help would be appreciated. Thanks.
Code: [Select]
<!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></title>
 
</head>
<body>
<center><table cellspacing="10" cellpadding="10" width="750" border="0">
<h4>Search</h4>
 
<form name="search" method="post" action="<?php $PHP_SELF?>">
Seach for: <input type="text" name="find" /> in <Select NAME="field">

<Option VALUE="lname">Last Name</option>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
 
<?php 
 
// check to see if anything is posted
if (isset($_POST['find'])) {$find = $_POST['find'];}
if (isset($_POST['searching'])) {$searching = $_POST['searching'];}
if (isset($_POST['field'])) {$field = $_POST['field'];}
 
//This is only displayed if they have submitted the form 
if (isset($searching) && $searching=="yes") {
echo "<h4>Results</h4><p>";
// If they did not enter a search term we give them an error
if (empty($find)) {
echo "<p>You forgot to enter a search term"; exit;
}
 
// Otherwise we connect to our Database 
mysql_connect("localhost", "root", "1910") or die(mysql_error());
mysql_select_db("cmc_member") or die(mysql_error());
 
// We preform a bit of filtering 
$find = strtoupper($find);
$find = strip_tags($find); $find = trim ($find); 
 
// Now we search for our search term, in the field the user specified 
$results = mysql_query("SELECT * FROM members WHERE upper($field) LIKE'$find'");
 
// And we display the results 
if($results && mysql_num_rows($results) > 0)
{
    $i = 0;
    $max_columns = 3;
    while($row = mysql_fetch_array($results))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)
          echo "<tr>";

       // make sure we have a valid product ALIGN='CENTER'

       if($fname != "" && $fname != null)
          echo "<td ALIGN='CENTER'><FONT COLOR='red'><b>$fname $lname</b></FONT><br> $address <br> $city $state $zip <br>$phone<br><a href=\"mailto: $email\">$email</a><br></td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
           }  // end if
   } // end while

} // end if results

// clean up table - makes your code valid!
if($i < $max_columns)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";

}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that 
$anymatches = mysql_num_rows($results);
 
if ($anymatches == 0) {
echo "Sorry, but we can not find an entry to match your query<br><br>"; }
 
//And we remind them what they searched for 
echo "<b>Searched For:</b> " .$find;
}
?>
</tr>
</table></center>
</body>
</html>

Hello. I am working on a php script for searching a database table. I am really new to this, so I used the this tutorial http://www.phpfreaks.com/tutorial/simple-sql-search

I managed to get all the things working the way I wanted, except one important and crucial thing.
Let me explain.
My table consist of three columns, like this:

ID(bigint20)    title(text)        link (varchar255)
=============================
ID1                title1                link-1
ID2                title2                link-2
etc...

Like I said, I managed to make the script display results for a search query based on the title. Want I want it to do more, but I can't seem to find the right resource to learn how, is to place a "Download" button under each search result with its corresponding link from the table.

Here is the code I used.

<?php

$dbHost = 'localhost'; // localhost will be used in most cases
// set these to your mysql database username and password.
$dbUser = 'user'; 
$dbPass = 'pass';
$dbDatabase = 'db'; // the database you put the table into.
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());
// Set up our error check and result check array
$error = array();
$results = array();
// First check if a form was submitted. 
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT title, link FROM db WHERE title LIKE '%{$searchTermDB}%'";

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
      
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

       

   
         }
      
      }
   }
}

function removeEmpty($var) {
   return (!empty($var)); 


}
?>

      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="search?" name="searchForm">
         Search for title: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" />
        
         <input type="submit" name="submit" value="Search" />
      </form>

    <?php echo (count($results) > 0)?"Rezultate lucrari de licenta sau disertatie pentru {$searchTerms} :<br /><br />" . implode("", $results):""; ?>




 $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$row['title']}<br /> Download - this is the button I want to link to the title results - and maybe other links too - <br /> ";

    $i++;

 
I would like the results to be displayed like this

Results for SearchItem:

Result 1
Download | Other link
Result 2
Download | Other link
etc.... or something like this.

So, how do I add the data from the link row into a text(Dowload), within an <a href> tag (well, at least I guess it would go this way) ?
My first tries (fueled by my lack of knowledge) where things like

$results[] = "{$row['title']}<br /> <a href="{$row['link']}">Download</a> <br /> ";

but I keep getting lots of errors, and then I don't know much about arrays and stuff (except basic notions);
So there it is. I am really stuck and can't seem to find any workaround for this.
Any suggestions? (examples, documentation, anything would do, really)
Thanks,
Radu

Hello,

I'm developing a website that asks the user to submit a keyword for a search. The results should display matches for this keyword, but also show matches for related keywords (in order of relevenace!).

I'm planning on building up a library of which search terms users use in the same sessions (e.g. if someone searches for "it jobs" and "php jobs", I'll know the terms are correlated), and I'll also measure the click-through rates of the items on the results list.

I've been spending all weekend trying to map out the design for this but it's proving incredibly complicated and I think the solution is likely to be on the internet somewhere already?!

Please could someone point me in the right direction if you've come accross this problem before?

Thanks a million,

Stu

Hi all

How do I modify the below code to search multiple tables in mySQL database?

$query = "select * from store_items where description like \"%$trimmed%\"  or title like \"%$trimmed%\" or dimensions like \"%$trimmed%\" order by id ASC";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

It is for a search function and I need it to search another table called 'about_text' and 'faq_text'

Thanks
Pete

Friends,

I want to extract the Search Keyword from the URL, a visitor came from. I am using a PHP CMS and want to show the Keyword on my Blog.

So if they search "abcd" from google, i want to extract "abcd" and echo on my blog.

Here is the coding i could got hold of, but its not working, not echoing anything

<?php

function pk_stt2_function_get_delimiter($ref) {
    $search_engines = array('google.com' => 'q',
'go.google.com' => 'q',
'images.google.com' => 'q',
'video.google.com' => 'q',
'news.google.com' => 'q',
'blogsearch.google.com' => 'q',
'maps.google.com' => 'q',
'local.google.com' => 'q',
'search.yahoo.com' => 'p',
'search.msn.com' => 'q',
'bing.com' => 'q',
'msxml.excite.com' => 'qkw',
'search.lycos.com' => 'query',
'alltheweb.com' => 'q',
'search.aol.com' => 'query',
'search.iwon.com' => 'searchfor',
'ask.com' => 'q',
'ask.co.uk' => 'ask',
'search.cometsystems.com' => 'qry',
'hotbot.com' => 'query',
'overture.com' => 'Keywords',
'metacrawler.com' => 'qkw',
'search.netscape.com' => 'query',
'looksmart.com' => 'key',
'dpxml.webcrawler.com' => 'qkw',
'search.earthlink.net' => 'q',
'search.viewpoint.com' => 'k',
'mamma.com' => 'query');
    $delim = false;
    if (isset($search_engines[$ref])) {
        $delim = $search_engines[$ref];
    } else {
        if (strpos('ref:'.$ref,'google'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.atomz.'))
            $delim = "sp-q";
elseif (strpos('ref:'.$ref,'search.msn.'))
            $delim = "q";
elseif (strpos('ref:'.$ref,'search.yahoo.'))
            $delim = "p";
        elseif (preg_match('/home\.bellsouth\.net\/s\/s\.dll/i', $ref))
            $delim = "bellsouth";
    }
    return $delim;
}

/**
 * retrieve the search terms from search engine query
 * */ 
function pk_stt2_function_get_terms($d) {
    $terms       = null;
    $query_array = array();
    $query_terms = null;
    $query = explode($d.'=', $_SERVER['HTTP_REFERER']);
    $query = explode('&', $query[1]);
    $query = urldecode($query[0]);
    $query = str_replace("'", '', $query);
    $query = str_replace('"', '', $query);
    $query_array = preg_split('/[\s,\+\.]+/',$query);
    $query_terms = implode(' ', $query_array);
    $terms = htmlspecialchars(urldecode(trim($query_terms)));
    return $terms;
}

/**
 * get the referer
 * */ 
function pk_stt2_function_get_referer() {
    if (!isset($_SERVER['HTTP_REFERER']) || ($_SERVER['HTTP_REFERER'] == '')) return false;
    $referer_info = parse_url($_SERVER['HTTP_REFERER']);
    $referer = $referer_info['host'];
    if(substr($referer, 0, 4) == 'www.')
        $referer = substr($referer, 4);
    return $referer;
}



$referer = pk_stt2_function_get_referer();
if (!$referer) return false;
$delimiter = pk_stt2_function_get_delimiter($referer);
if( $delimiter ){
$term = pk_stt2_function_get_terms($delimiter);
}
echo $term;
?>


May someone help?

Natasha T

The default PHP Session name on my webspace server is PHPSESSID.

Does that mean that the session cookie will be called PHPSESSID?

The reason i ask is that in a couple of places i can't use PHP to update the information in the session cookie (because PHP is parsed before the webpage loads) and so i need to use Javascript to update a cookie which i would prefer to be the session cookie used by PHP.

I guess i'm asking what the name of the cookie is, how i would refer to it in Javascript (if that is even possible) so that i can update it and whether this would cause any issues with the info already stored in the session cookie by PHP.

Cheers

NM

How do I get directory names to display with spaces. My script sticks them into arrays just fine, but when trying to echo from a checkbox selection, it only displays the first word. How would I fix this?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=348587.0

Hi Guys,

I use this function to generate seo friendly names for my products once pulled from the database:


function generate_seo_friendly_links($pNM, $pID)
{
    $replacedNM = str_replace(" ", "-", $pNM);  
    $replacedNM = rtrim($replacedNM);  
    $brandNewSEOFriendlyURL = "<a href='$replacedNM-$pID.html'>$pNM</a>";    
    return $brandNewSEOFriendlyURL;
}


This works great, the only thing is say a product is stored in the database like:

product name it would then be converted to: product-name.html

if for example theres 2 spaces:

product  name it would then be converted to: product--name.html

with the 2 "--" so for every space it finds we replace with a "-" etc

is there a way i could ignore more than 1 space and always have it like product-name-here.html so the names are more uniformed, i can't think of a way to do it.

any help would be appreciated

thanks guys

Graham