19 replies to this topic

[iGuest]

can you please make it more clear ?
How To Make A Search Form And Php Code?

Replying to arcticsnpr
Hi artisncr..

I read your html code and php code.
I am looking for a site search also..In my php website

Could you please make 123 step for search.Php?
1. Where / which directory to upload this code.
2. Do I have to change database username etc ?

How can I see my database name ?

And could you please tell how to make a home page that have a dynamically change news from other side ?

Thank you artist

[iGuest]

Display DataHow To Make A Search Form And Php Code?

Hi There,

I found the above script very usefull. I want to go one step further though...

I want to display a table with data based on the query. How do I do that??

Thanks in advance

Gert

[iGuest]

Pls Help me......... This code work from our local machine... i can put server that canHow To Make A Search Form And Php Code?
this code source...

<?php/*set varibles from form */$searchterm = $_POST['searchterm'];Trim ($searchterm);/*check if search term was entered*/If (!$searchterm){    echo 'Please enter a search term.';}/*add slashes to search term*/If (!get_magic_quotes_gpc()){$searchterm = addslashes($searchterm);}/* connects to database */@ $dbconn = new mysqli('localhost', 'root', '', 'sample1');If (mysqli_connect_errno()){Echo 'Error: Could not connect to database.  Please try again later.';Exit;}/*query the database*/$query = "select * from sheet1 where IndexNo like '%".$searchterm."%'";$result = $dbconn->query($query);/*number of rows found*/$num_results = $result->num_rows;echo '<p>Found: '.$num_results.'</p>';/*loops through results*/For ($I=0; $I <$num_results; $I++){$num_found = $I + 1;$row = $result->fetch_assoc();Echo "$num_found. ".($row['IndexNo'])." <br />";Echo "<table border='1'><tr><th>IndexNo</th><th>Name</th><th>Marks</th><th>Rank</th></tr>";  echo "<tr>";  echo "<td>" . $row['IndexNo'] . "</td>";  echo "<td>" . $row['Name'] . "</td>";  echo "<td>" . $row['Marks'] . "</td>";  echo "<td>" . $row['Rank'] . "</td>";Echo "</tr>";}Echo "</table>";/*free database*/$result->free();$dbconn->close();?>
-reply by Prashanth

[iGuest]

Real Estate WebsiteHow To Make A Search Form And Php Code?

I am making a real estate website and I have a search box. I want the buyers/sellers to be able to search for a home and however many bedrooms and bathrooms they want but I want the homes to pop up on my page. Does anybody have a code or a site to help me???? Any help is greatly appreciated. Thanks!!1

[rpgsearcherz]

pooja, on 23 March 2012 - 03:42 PM, said:

hey how can we select only one row from the database dat matches with the entered text ?? plzz help...by writing this code m getting all d rows in the databse..plzz do the needfulll thankxxx..

<?php
$host="localhost";
$username="poojar";
$password="abc";
$database="allsites";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$result = mysql_query("SELECT websitename,result FROM searchresult");

while($row = mysql_fetch_array($result))
  {
  echo $row['websitename'] ." " . $row['result'];
  echo "<br />";
  }
mysql_close();

?>

Ah, your issue is that you have it set to "continue looping as long as there's more data." What you want to do is instead of have a while loop just erase the entire loop and output row 0 (which is really the first row).