PHP - Displaying Company Name From .csv List For Web Search Results

Dear all,
I am new in this forum. This is my code

  $query = "
  SELECT webdb.id, webdb.writer, writer.picLoc, webdb.title FROM webdb, writer WHERE webdb.writer=writer.name and 
  category = 'Researchworks' and language = 'Farsi' ORDER BY writer DESC"; 
  $resultaat = mysql_query($query, $LinkID);
  $column_count = mysql_num_fields($resultaat) or die (mysql_error()."<br>Couldn't execute query: $SQLquery");
  
  $counter=1;
  echo "<table border=\"0\" width=\"700\" border color=white><tr>";
  while ($row = mysql_fetch_row($resultaat))
  {
  if ($author !== $row[1])
  {
  $author = $row[1];
  echo "<td align=right width=220 valign=top style=\"margin: 5px; float: right border-bottom-color:#000; border-left-color:#000;\">";
  echo "<img width=\"50\" height=\"80\" src=\"admin/writers/$row[2]\" border =\"0\"><br>".$row[1]."<br>";
  echo "<a href=\"poems.php?writer=$row[1]\">".$row[3]."</a><br>";
  echo "</td>";
  if($counter%3==0) 
  {
  echo"</tr><tr>";
  }
  $counter++;
}
  }
  echo"</tr></table>";


i have authors with different articles on a certain topic. What i want is, displaying the name of the author only once and all his titles under his name. I also want a dynamic table where i display three authors in each row and soon as there a fourth author a new row must start. My problem now is is the title is also being filtered and i can only display one title.

Thanks in advance

I'm trying to create a list that groups information by username. Only part of it is working. The first query ($get_item_sql) is grouping the information perfectly but the second query ($get_sold) is lumping the $item_price and $item_amount_due as one total for each one and outputting the same amounts into every username. I'm stuck on this and would appreciate your help.

For example:  Username   item fees   image fees item sales  item price  total due
                       Jim                   2               $0.40      $100.00        $3.00     $3.40
                       Kelly                 5               $1.00      $100.00        $3.00     $4.00

This example shows the columns in red as being the problem where Kelly didn't sell anything so her "item sales" and "item price" should be $0.00 but is carrying Jim's totals into hers.

Hope this helps!  Thank you!     

$get_item_sql = mysql_query("SELECT id, username, date, ROUND(price,2) AS price, SUM(item_fee) AS fee, item_fee, SUM(sold) AS sales, SUM(ROUND(price,2)) AS total FROM product WHERE MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username" )
or die(mysql_error());

if (mysql_num_rows($get_item_sql) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_info = mysql_fetch_array($get_item_sql)) {
   $item_username = $item_info['username'];
   $item_date = $item_info['date'];
   $item_price = $item_info['price'];
   
   $item_fee = $item_info['fee'];
   $image_fees = $item_fee * .20;
   $item_sold = $item_info['sales'];
   
  
 $get_sold = mysql_query("SELECT SUM(ROUND(price,2)) AS total, SUM(ROUND(sold,2)) AS sales, date, username FROM product WHERE sold = '1' AND MONTH(date) = MONTH(DATE_ADD(CURDATE(),INTERVAL -1 MONTH)) GROUP BY username")
or die(mysql_error());

if (mysql_num_rows($get_sold) < 1) {
   //invalid item
   $display_block .= "<p><em>Invalid item selection.</em></p>";

  } else {
   //valid item, get info
   while ($item_sold2 = mysql_fetch_array($get_sold)) {
   
   
   $item_sales = $item_sold2['total'];
   $item_price = ($item_sold2['total']) * .03;
  
$item_amount_due = $image_fees + $item_price; 

  
  

$content .= "<form action=\"add_artist.php\" method=\"post\"><table class=\"anotherfont\" width=\"670\" border=\"0\">

<tr><td width=\"201\">{$item_username}</td>
                    <td width=\"109\">{$item_fee}</td>
<td width=\"109\">{$image_fees}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_sales}</td>
<td width=\"109\">&nbsp;&nbsp;{$item_price}</td>
<td width=\"109\"><input name=\"balance_due\" type=\"text\" value=\"{$item_amount_due}\" /></td>
</tr><br /></table></form>"; 

   }
  }
  }
  }

I am trying to write a script that will allow me visitors to my site to search my database for items. I followed a tutorial that I had found and tweaked it to fit my needs. I am not getting any results it keeps telling that there was no search results found. Even though I have the items that I have been testing on in my database.

I have two files the main search.php file and the search_func.php file

Here is the search.php file
Code: [Select]
<form method='post' action='search.php'>
<fieldset>
<input type='text' name='search' id='search' value='type name here'/>
<input type='submit' name='search_submit' id='search_submit' value='search'/>
</fieldset>
</form>

<?php

include('includes/search_func.php');

if(isset($_POST['search'])) {
$keywords = mysql_real_escape_string(htmlentities(trim($_POST['search'])));

$errors = array ();

if (empty($keywords )){
$errors[] = 'Please enter a search term';
} else if (strlen($keywords ) < 3 ) {
$errors[] = 'Search term must be more then three characters long';
} else if (search_results($keywords  == false)) {
$errors[] = 'Your search for ' .$keywords . ' showed no results';
}

if (empty($errors)) {
$results = search_results($keywords );
$results_num = count($results);
$suffix = ($results_num != 1) ? 's' : '';
echo 'Your search for <strong>'. $keywords  .'</strong> returned <strong>' .$results_num.'</strong> result'.$suffix.'';

foreach($results as $result) {
echo $result['first'];
}

} else {
foreach($errors as $error){
echo $error;
}
}

}

?>
Here is the search_func.php file
Code: [Select]
<?php
include('includes/config.php');
connect();

function search_results($keywords ) {
$returned = array();
$where = "";

$keywords  = preg_split('/[\s+]/', $keywords );
$total = count($keywords );

foreach($keywords  as $key=>$keyword) {
$where .= "`l_name` LIKE '%$keyword%'";

if($key != ($total - 1)){
$where .= "OR";
}
}

$results  = "SELECT `l_name`,`f_name`,`image`,`item_return` FROM `ttmautos` WHERE $where";
$results_num = ($results = mysql_query($results)) ? mysql_num_rows($results): 0 ;

if ($results_num === 0) {
return false;
} else {
while($results_row = mysql_fetch_assoc($results)) {
$returned_results[] = array(
'last' => $results_row['l_name'],
'first' => $results_row['f_name'],
'image' => $results_row['image'],
'item' => $results_row['item_return']
);
}

return $returned_results;
}
}
?>

If anyone could give me an idea of what I am doing wrong I would appreciate it.

What I expect:
- The function to loop output all of the rows which match the search results.

The problems:
- Only 1 row is matched.
- Notice: Undefined index: id in G:\xampp\htdocs\xampp\dsa\search_func.php on line 57
- The image is not showing

Line 57:
Code: [Select]
$id = $_REQUEST['id'];
Entire Code:
Code: [Select]
<?php
/*  return the details of an employee
     parameter 
         empno - employee number
         
     eg empHTML.php?empno=7521
    This is  very basic  e.g no error checking      
*/

function search($dbc, $id) { 


if (isset($_GET['terms']) && ($_GET['terms'] != 'Search...') ) {

$terms = $_GET['terms'];
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die *('Error connecting to MySQL server');

    $query = "SELECT * FROM stick, location, identification WHERE make LIKE '%$terms%' AND stick.sid = location.lid AND identification.stickID = stick.sid
AND identification.stickID = $id";
   
$result=mysqli_query($dbc,$query);

    $num_rows = mysqli_num_rows($result);

$output = Array();
   
    $image = mysqli_fetch_object($result);

if ($num_rows > 0){ 
if($result=mysqli_query($dbc,$query)){

$output[] = '<ul>';
$output[] = '<li> Type: '.$image->make .'<br />Size: '.$image->size .$image->type .'<br />Colour: '.$image->colour .
'<br /> Street Missing in: ' .$image->street.'<br />Town missing in: '.$image->town .'<br />City missing in: '.$image->city.'</li>';
$output[] = '</ul>';

}

return join('',$output);
}
else {
echo "<h3>Sorry,</h3>";
echo "<p>your search: &quot;" .$terms. "&quot; returned zero results</p>";
}


}
else { 
// Tell them to use the search form.
echo '<p class="error">Please use the search form at the top of the window to search this site.</p>';
}
}
// connect
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

// get the id from the URL
$id = $_REQUEST['id'];

print search($dbc, $id);
print "<img src='getPhoto.php?id=$id'/>";

// close the database
mysqli_close($dbc);

hey guys, i have a search bar i am implementing into my navmenu but keeping getting errors returned and im not sure why

This is the code in my navmenu to display the search bar
Code: [Select]
echo '<form action="search.php" method="post">Search: <input type="text" name="term" /> <input type="submit" name="submit" value="Search"/>'; Code: [Select]
Here is the php file that query's the search
$term = $_POST['term'];
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$query = mysqli_query("select * from ob_listings where subject like '%$term%' or description like '%$term%' ");
while ($row = mysql_fetch_array($dbc, $query)){
echo 'Subject: '.$row['subject'];
echo '<br/> Date: '.$row['date'];
echo '<br/> Price: '.$row['price'];
echo '<br/> City: '.$row['city'];
echo '<br/><br/>';
}
any help is much appreciated

here are the errors being returned

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\vhosts\HeadFirst\ourbazzar\search.php on line 16
(line 16 is the $query)

Warning: mysql_fetch_array() expects parameter 1 to be resource, object given in C:\vhosts\HeadFirst\ourbazzar\search.php on line 17
(line 17 is the while loop)

Hi,
I have a problem if users search something which doesn't match the data in the table I'm selecting from.

At the moment I'm trying this code:
Code: [Select]
<?php 
require_once('inc/global.inc.php');

# search.inc.php

/* 
 * This is the search content module.
 * This page is included by index.php.
 * This page expects to receive $_GET['terms'].
 */

// Redirect if this page was accessed directly:
if (!defined('BASE_URL')) {

// Need the BASE_URL, defined in the config file:
require_once ('../includes/config.inc.php');

// Redirect to the index page:
$url = BASE_URL . 'index.php?p=search';

// Pass along search terms?
if (isset($_GET['terms'])) {
$url .= '&terms=' . urlencode($_GET['terms']);
}

header ("Location: $url");
exit;

} // End of defined() IF.

// Print a caption:
echo '<h2>Search Results</h2>';

// Display the search results if the form
// has been submitted.
if (isset($_GET['terms']) && ($_GET['terms'] != 'Search...') ) {

$terms = $_GET['terms'];
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die *('Error connecting to MySQL server');
// Query the database.
$query = "SELECT * FROM product WHERE title LIKE '%$terms%'";

// Fetch the results.
//$row = mysqli_fetch_array($result);

// Print the results:

$result=mysqli_query($dbc,$query);

if ($result == 0){
  echo "<h3>Sorry,</h3>";
  echo "<p>your search: &quot;" .$terms. "&quot; returned zero results</p>";
}

while($row=mysqli_fetch_assoc($result)) {

$output[] = '<ul>';
$output[] = '<li>'.$row['title'] .': &pound;'.$row['price'].'<br /><img src="'.$row['img'].'" alt="'.$row['title'].'" /></li>';
$output[] = '</ul>';
}
echo join('',$output);
}

else { // Tell them to use the search form.
echo '<p class="error">Please use the search form at the top of the window to search this site.</p>';
}



?>

But I'm getting this error:
Object of class mysqli_result could not be converted to int

So that little if statement here doesn't work:
Code: [Select]
if ($result == 0){
  echo "<h3>Sorry,</h3>";
  echo "<p>your search: &quot;" .$terms. "&quot; returned zero results</p>";
}

Is there another way I can display no search matched results?

Thank you for reading,
Andrew.

Hi, fairly new to PHP over the last couple weeks. Been having a problem with certain queries. I have a database with football results, games, teams etc. I can filter these using drop down and that's all well and good. The problem I'm having is displaying the data via gameweek. I've been asked to display the table like so - Gameweek1 will display week1 teams, results etc. Gameweek2 will display week2... and so on. I can manage to do this in a drop down. But I've been asked to display this using links like "Previous, 1, 2, 3 Next". I've tried pagination but I couldn't figure it out. Can anyone point me in the right direction? If I need a GET() method, how would I go about coding that so it will be used in a link(s)? Been searching and searching to find an answer but to no avail...

//Database connection etc...

$gameweek = "SELECT * FROM games WHERE gameweek= 1";
    
    //if(isset($_GET['gameweek']))
    //{
    //    $gameweek = $_GET['gameweek'];
    //    
    //}
    //....
    $result=mysqli_query($connection, "select * from games WHERE gameweek= 1");
 //Print table and table headings...
    
    mysqli_close($connection);
?>
<a href="http://weeks.php?gameweek=2">Week 2</a>
<a href="http://weeks.phpgameweek=3">Week 3</a>

</body>
</html>

I'm trying to pull results from a database based on where the user is located based upon the variables $usr_lat & $usr_lng, and search for by a radius of x amount of miles/km (need to make it optional). I can't seem to find exactly what I'm looking for on google so I thought I'd asked here. Any help would be appreciated.

Code: [Select]
<?php 
$result = mysql_query("SELECT * 
FROM FamilyTbl
INNER JOIN PeopleTbl ON (FamilyTbl.Name_ID = PeopleTbl.NameID) 
WHERE FamilyTbl.House_ID = '$address'
ORDER BY NameLast, NameFirst
") OR die(mysql_error());

WHILE ($row = mysql_fetch_array($result) )  { 

   echo $row[NameLast]. ", ". $row[NamePrefix]. " ". $row[NameFirst]. " ". $row[NameMiddle]. $row[NameSuffix]. " "; 
}
?>

OK, some of these queries return A LOT of names.  I'd like to be able to display them in columns in a table like so:
Code: [Select]
Charne, Mr. Michael   Glanger, Mrs. Karin      Kling, Mr. Wayne 
Charne, Mrs. Suzette  Glanger, Mr. Trevor      Lazarow, Mrs. Fiona 
Charney, Mrs. Linda   Jochelson, Mrs. Barbara  Lazarow, Mr. Mark 
Charney, Mr. Norman   Jochelson, Mr. Neil      Norton, Mr. Charles 
Cohen, Mr. Brendan    Karlan, Mr. Dennis       Norton, Mrs. Jodi 
Cohen, Mrs. Joanna    Karlan, Mrs. Helen       Roy, Mr. Michael 
Flekser, Mrs. Jean    Kling, Mrs. Danielle     Roy, Mrs. Nicki 
Frysh, Dr. Howard     Kling, Mrs. Melanie      Tsafrir, Mrs. Lauren 
Frysh, Mrs. Sandra    Kling, Mr. Nevil         Tsafrir, Mr. Thomer 

That way it reads top to bottom THEN left to right.

math-wise, it's simple to set up:
Code: [Select]
$num_results = number_of_$results;
$numcols = 3;
$numrows = trunc($numresults/numcols);
<table>
for row_loop=1 to numrows
<tr>
for col_loop = 1 to numcols
<td>
echo result(col_loop-1)*(numrows)+row_loop
</td>
next col_loop
</tr>
next row_loop
</table>

Anyone want to give this a shot?

Revraz already directed me to http://www.phpfreaks.com/forums/index.php/topic,95426.0.html but that displayed the data from left to right then up to down like so:
Code: [Select]
Charne, Mr. Michael   Charne, Mrs. Suzette  Charney, Mrs. Linda 
Charney, Mr. Norman   Cohen, Mr. Brendan    Cohen, Mrs. Joanna 
Flekser, Mrs. Jean    Frysh, Dr. Howard     Frysh, Mrs. Sandra 
Glanger, Mrs. Karin   Glanger, Mr. Trevor   Jochelson, Mrs. Barbara 
Jochelson, Mr. Neil   Karlan, Mr. Dennis    Karlan, Mrs. Helen 
Kling, Mrs. Danielle  Kling, Mrs. Melanie   Kling, Mr. Nevil 
Kling, Mr. Wayne      Lazarow, Mrs. Fiona   Lazarow, Mr. Mark 
Norton, Mr. Charles   Norton, Mrs. Jodi     Roy, Mr. Michael 
Roy, Mrs. Nicki       Tsafrir, Mrs. Lauren  Tsafrir, Mr. Thomer 

It's a good temp solution, but if anyone is good with for loops, I'd appreciate the help, thanks!

-Dave

Hello Everyone was wondering if I could get some help with the following code? I am querying a database for results of listings that are in a database these listings are displayed on the page in a form. I am wanting each listing to be on a different page. Below is my code.
Code: [Select]


$lim=1;
if (!isset($s) || $s < 1 || !is_numeric($s)) {
            $s = 1;
        }


    $start = ($s - 1) * $lim;
     $sql = "select id,bussimg,imagewidth,imageheight,email,usridm,company,businesscategory,address1,address2,state,city,zip,website,email,repname,description,phonenumber,country,status from $approvecheckbusinesses where usridm='$user_id'";
    $result=db_query($sql);
     



        $countpages = $sql;
        $sql = $sql . " order by id asc limit $start, $lim";
       $result=db_query($sql);
        $pages = ceil(mysql_num_rows(mysql_query($countpages)) / $lim);
     
   


$result=db_query($sql);
for ($i = 0; $i < mysql_num_rows($result); $i++) {
$Listid= mysql_result($result, $i, "id");

$usridm= mysql_result($result, $i, "usridm");
$CompanyName= mysql_result($result, $i, "company");
$realname= mysql_result($result, $i, "repname");
$email= mysql_result($result, $i, "email");
$BusinessCategory= mysql_result($result, $i, "businesscategory");
$status= mysql_result($result, $i, "status");
   



echo ("FORM IS TO BE DISPLAYED HERE");

}

if ($pages > 1) {
            echo("<p align=left style='font-size: 85% color=white'>");
            for ($i = 1; $i <= $pages; $i++) {
                echo("[");
                if ($i == $s) {echo("<b>");}
                else {echo("<a id=home_offerLink href='index.html?EditMemberListing&user_id=$user_id&s=$i'>");}
                echo("Page $i");
                if ($i == $s) {echo("</b>");}
                else {echo("</a>");}
                echo("]  ");
            }
            echo("</p>")


Page Numbers here using the above code.. The problem I seem to be running into is that it only displats the first record. The page numbers show up page 1 page 3
page 2 and three are blank there is no mysql error or anything for some reason I only get that first result out of three

Hi everyone.

I'm stuck on the following query. I need to display all the fields listed below on a page, but linked via communications.CommID.  I'd appreciate any assistance you can provide. thank you.

Code: [Select]

<?php
 $result = mysql_query("SELECT records.NameFirst_1, records.NameLast_1, records.CompanyName, records.CompanyBranch, records.CompanyReferenceNumber, records.CaseOwnerSelect, communications.ConversionType, communications.Contact, communications.ContactFrom, communications.CommID, communications.ContactPosition, communications.ContactTelephone, communications.ContactEmail, communications.ContactFax, communications.CallDate, communications.CallTime, communications.ActionTextField
FROM records INNER JOIN communications ON records.IDNumber = '$IDNumber'")

 or die(mysql_error()); 
 $row = mysql_fetch_array($result);
?>

Hi

I have got results being displayed after clicking the search button in a form on my home page but it brings up all the results which is ok but how do I get onlt the results a user searches for for example a location or property type etc as its for a property website

The coding is below for the results page

Also sorry how do I add a background image to the php page, I tried using css but wouldn't work

Code: [Select]
<style type="text/css">
body {background-image:url('images/greybgone.png');}
</style>

<?php
 
mysql_connect ("2up2downhomes.com.mysql", "2up2downhomes_c","mD8GsJKQ")  or die (mysql_error());
mysql_select_db ("2up2downhomes_c");

echo $_POST['term'];

$sql = mysql_query("select * from properties where typeProperty like '%$term%' or location like '%$term%'");

while ($row = mysql_fetch_array($sql)){
    echo 'Type of Property: '.$row['typeProperty'];
    echo '<br/> Number of Bedrooms: '.$row['bedrooms'];
    echo '<br/> Number of Bathrooms: '.$row['bathrooms'];
echo '<br/> Garden: '.$row['garden'];
echo '<br/> Description: '.$row['description'];
echo '<br/> Price: '.$row['price'];
echo '<br/> Location: '.$row['location'];
echo '<br/> Image: '.$row['image'];
    echo '<br/><br/>';
    }
 
?>

Hi, I have search form which works apart from 1 part, I have set the results limit to 10 per page with a next link if there are more than 10 results, however when the next link is clicked, i get the error 'you do not have a search parameter' which comes from this code:

Code: [Select]
if (!isset($var))
          {
          echo "<p>We dont seem to have a search parameter!</p>";
          exit;
          }
The next link is defined by the code below:

Code: [Select]
// check to see if last page
          if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
       
          // not last page so give NEXT link
          $news=$s+$limit;
       
          echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
          }
Can anyone see where I have gone wrong with this code without me sending the whole search form? Any help would be very much appreciated. Thanks

Hi guys,

A beginner at php/mysql here...

For a project I'm doing, I would like to display search results with an image, small description, then a 'read more' link.
After googling this issue, I can't find much information on it, which surprised me.  Someone did mention blobs for images... (whatever they are!)
I'm wondering if anyone knows of any tutorials, or has any code to do this?

Your help is much appreciated.

Thanks.