Searching for a name in a database when I only know part of the name

[rajeshmishra]

I want to know the php code to make an telephone diary..i mean exactly
.,suppose the in database the name stored is " Manoj mishra ",but in the form by typing only"manoj" we can see the details of manoj mishra..how could we do it..?pls giv an example for clear understanding..

[debasisdas]

Question moved to PHP forum.

[Markus]

I want to know the php code to make an telephone diary..i mean exactly
.,suppose the in database the name stored is " Manoj mishra ",but in the form by typing only"manoj" we can see the details of manoj mishra..how could we do it..?pls giv an example for clear understanding..

What database?

MySQL?

[Markus]

I want to know the php code to make an telephone diary..i mean exactly
.,suppose the in database the name stored is " Manoj mishra ",but in the form by typing only"manoj" we can see the details of manoj mishra..how could we do it..?pls giv an example for clear understanding..

Supposing you're using MySQL

Try something like this

$name = $_POST['name']; //from a form the user filled in?
 
$query = "SELECT * from `insert your table name` WHERE `table cell you want to check` like '%$name'"; 
/*this selects everything from the table you want where user input is something like a name you pulled out of table
 
The % is a wildcard - that means it'll pull soemthing that's like what you want in relation to where you put the %
 
e.g. mark % would get: mark skilbeck, mark jameson etc. % mark would get: john mark, chris mark etc. % mark % would (i think) get: something mark something etc. You get the picture :)*/
 
$checkQuery = mysql_query($query); //run a mysql_query
 
$numRows = mysql_numrows($checkQuery); /*gets numbers of rows from table where data in $query is true*/
 
echo "
<table>
 <tr><th>name</th><th>age</th><th>email</th></tr>";
if($numRows => 1){ // if number of rows is equal-to or greater-than: run script
 while($row = mysql_fetch_array($query)){
/* will keep fetching data until it returns false (reaches end) */
  echo "<tr><td>$row['name']</td><td>$row['age']</td><td>$row['email']</td></tr>";
 }
} else {
echo "<tr><td colspan=\"3\">Your search returned no results</td></tr>";
}
echo "</table>";
/*the bit above creates a table. The $row is what you will use to access your data in the MySQL table. Just change the ['name'] etc. to reflect the names of the cells in your MySQL table.*/
 

That should work but i haven't tested it and i am only 17 and i had a heavy night last night.

Less of the excuses - hope this helped :)

[Markus]

I'm going to test it ¬_¬

[Markus]

$name = $_GET['name']; //from a form the user filled in?
 
$query = "SELECT * from `example` WHERE `name` like '%$name'"; 
/*this selects everything from the table you want where user input is something like a name you pulled out of table
 
The % is a wildcard - that means it'll pull soemthing that's like what you want in relation to where you put the %
 
e.g. mark % would get: mark skilbeck, mark jameson etc. % mark would get: john mark, chris mark etc. % mark % would (i think) 
 
get: something mark something etc. You get the picture :)*/
 
$checkQuery = mysql_query($query); //run a mysql_query
 
$numRows = mysql_numrows($checkQuery); //gets numbers of rows from table where data in $query is true
?>
<table><tr><th>name</th><th>age</th><th>email</th></tr>
<?php
if($numRows >= 1){ // if number of rows is equal-to or greater-than: run script
 while($row = mysql_fetch_array($checkQuery)){
/* will keep fetching data until it returns false (reaches end) */
  echo "<tr><td>".$row['name']."</td><td>".$row['email']."</td><td>".$row['age']."</td></tr>";
 }
} else {
echo "<tr><td colspan=\"3\">Your search returned no results</td></tr>";
}
echo "</table>";
/*the bit above creates a table. The $row is what you will use to access your data in the MySQL table. Just change the 
 
['name'] etc. to reflect the names of the cells in your MySQL table.*/
?>
 

There was a few typos in there ;)

But it works just fine :)

[pbmods]

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).