Ad:

PHP Discussion Thread
Marked Solved
Views: 995

Mar 30th, 2008

PHP Searching Problem...

Expand Post »

Hi All, I Have a PHP Searching Code it have some problem it only connet to database but does not show any result..........

PHP Code is :-
Search.php

php Syntax (Toggle Plain Text)
<HTML> 
<BODY> 
<FORM Action="/Search.php" Method="POST"> 
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bordercolor="#000000">
<p align="center">
<select name="metode" size="1">
<option value="name">Name</option>
<option value="telephone">Telephone</option>
<option value="birthday">Birthday</option>
</select> <input type="text" name="search" size="25"> &nbsp;<br>
Search database: <input type="submit" value="Go!!" name="Go"></p>
</td>
</tr>
</table>
</div>
</form>
 
 
<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>ID</b></td>
<td width="100"><b>Name</b></td>
<td width="70"><b>Telephone</b></td>
<td width="150"><b>Birthday</b></td>
</tr>
 
<?php
if ($_POST['Go'])//user clicks go..
{
$dbh=mysql_connect ("localhost", "kuchcity_hemant", "hemgoyal") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("kuchcity_example");
?> 
<?php
 
//error message (not found message)begins 
$XX = "No Record Found, to search again please try again"; 
//query details table begins
 
$query = mysql_query("SELECT * FROM details WHERE '$_POST[metode]' LIKE '$_POST[search]'% LIMIT 0, 50"); 
while ($row = @mysql_fetch_array($query)) 
{ 
$variable1=$row["ID"];
$variable2=$row["Name"]; 
$variable3=$row["Telephone"]; 
$variable4=$row["Birthday"];
//table layout for results 
 
print ("<tr>");
print ("<td>$variable1</td>"); 
print ("<td>$variable2</td>"); 
print ("<td>$variable3</td>"); 
print ("<td>$variable4</td>"); 
print ("</tr>"); 
}
//below this is the function for no record!!
if (!$variable1)
{ 
print ("$XX");
} 
//end 
}
?>
</table>
</center>
</BODY> 
</HTML>
<HTML> 
<BODY> 
<FORM Action="/Search.php" Method="POST"> 
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td bordercolor="#000000">
<p align="center">
<select name="metode" size="1">
<option value="name">Name</option>
<option value="telephone">Telephone</option>
<option value="birthday">Birthday</option>
</select> <input type="text" name="search" size="25"> &nbsp;<br>
Search database: <input type="submit" value="Go!!" name="Go"></p>
</td>
</tr>
</table>
</div>
</form>


<center>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="60"><b>ID</b></td>
<td width="100"><b>Name</b></td>
<td width="70"><b>Telephone</b></td>
<td width="150"><b>Birthday</b></td>
</tr>

<?php
if ($_POST['Go'])//user clicks go..
{
$dbh=mysql_connect ("localhost", "kuchcity_hemant", "hemgoyal") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("kuchcity_example");
?> 
<?php

//error message (not found message)begins 
$XX = "No Record Found, to search again please try again"; 
//query details table begins

$query = mysql_query("SELECT * FROM details WHERE '$_POST[metode]' LIKE '$_POST[search]'% LIMIT 0, 50"); 
while ($row = @mysql_fetch_array($query)) 
{ 
$variable1=$row["ID"];
$variable2=$row["Name"]; 
$variable3=$row["Telephone"]; 
$variable4=$row["Birthday"];
//table layout for results 

print ("<tr>");
print ("<td>$variable1</td>"); 
print ("<td>$variable2</td>"); 
print ("<td>$variable3</td>"); 
print ("<td>$variable4</td>"); 
print ("</tr>"); 
}
//below this is the function for no record!!
if (!$variable1)
{ 
print ("$XX");
} 
//end 
}
?>
</table>
</center>
</BODY> 
</HTML>

any one plz help me......

Last edited by peter_budo; Mar 30th, 2008 at 6:21 am. Reason: Keep It Organized - please use [code] tags

Similar Threads

IE6/IE7 unexpectedly drops the PHP Session ID cookie (PHPSESSID) in PHP
URL Rewrite in PHP in PHP
php header() redirect issues in PHP
I am New In MySQL. Problem With MySQL Database Plz Help. in MySQL
Filtering My sql through Php using drop down menu and text field in PHP

hemgoyal_1990

Reputation Points: 18

Solved Threads: 17

Junior Poster

Offline

175 posts
since Aug 2007

Permalink

Mar 30th, 2008

Re: PHP Searching Problem...

Hi
hemgoyal

you have this one in line 3 which i marked it in red move it to small litter and chick and let me know

Quote ...

<FORM Action="/Search.php" Method="POST">

BroKeN

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

25 posts
since Mar 2008

Permalink

Mar 30th, 2008

Re: PHP Searching Problem...

Dear i am Doing Your Tricx But my Problem doe's not solved yet.... Plz Dear Give me Solution of my problem.

hemgoyal_1990

Reputation Points: 18

Solved Threads: 17

Junior Poster

Offline

175 posts
since Aug 2007

Permalink

Mar 30th, 2008

Re: PHP Searching Problem...

Quote ...

SELECT * FROM details WHERE '$_POST[metode]' LIKE '$_POST[search]'% LIMIT 0, 50

I guess $_POST['metode'] is the column name ? Print out the query, execute it in phpmyadmin/ mysql console. Check the result. Oh, also, remove the @ symbol from

Quote ...

$row = @mysql_fetch_array($query)

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Mar 30th, 2008

Re: PHP Searching Problem...

Click to Expand / Collapse Quote originally posted by hemgoyal_1990 ...

Dear i am Doing Your Tricx But my Problem doe's not solved yet.... Plz Dear Give me Solution of my problem.

Sorry can't help more cuz i don't have the Database you use i just uploaded the "search.php" file to my site and got the issue of the first file reads "Search.php"
and when i typed a name it turned me to "search.php" but with a db error cuz there i cant call your database

if you can post it i think i can help and do try what nav33n said
still around you

brb

BroKeN

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

25 posts
since Mar 2008

Permalink

Mar 31st, 2008

Re: PHP Searching Problem...

No Dear, in this script line
SELECT * FROM details WHERE '$_POST[metode]' LIKE '$_POST[search]'% LIMIT 0, 50 there metode is not not any coloumn this is a POST METHOD.

hemgoyal_1990

Reputation Points: 18

Solved Threads: 17

Junior Poster

Offline

175 posts
since Aug 2007

Permalink

Mar 31st, 2008

Re: PHP Searching Problem...

Then your query is wrong. What exactly are you trying to do with that query ?

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Mar 31st, 2008

Re: PHP Searching Problem...

Dear i Want to Create a Search page so any one user can search data from this page. if u know right coading plz post here.

hemgoyal_1990

Reputation Points: 18

Solved Threads: 17

Junior Poster

Offline

175 posts
since Aug 2007

Permalink

Mar 31st, 2008

Re: PHP Searching Problem...

Your query should be SELECT * FROM details WHERE columnname LIKE '$_POST[search]'% LIMIT 0, 50

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Mar 31st, 2008

Re: PHP Searching Problem...

try printing the sql statement before executing it
that could help u

w_3rabi

Reputation Points: 18

Solved Threads: 9

Junior Poster

Offline

160 posts
since Dec 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: help in mail attachment

Next Thread in PHP Forum Timeline: php mail

DaniWeb Message

Cancel Changes

User Name
Password