Frustrated beginner 1

beeg · Sep 6, 2002

PHP question; I know this is alot, but I'm desperate.
This script actually calls the whole table rather then meeting the search parameters. Can someone help with altering the php script to actually do what I want it to, find matches for searchtype and searchterm?

Thanks - Desperate

This is from form.htm

<form action="results.php" method="post">
<p>Search by:
<select name="searchtype">
<option value="name">Organization Name
<option value="denomination">Denomination
<option value="city">City
</select>
Keyword:
<input type="text" name="searchterm">
<input type="submit" value="Search">
</p>
</form>

This is from results.php

//feild names if you need them;
//name, pastor, denomination, address, city, state, zip, phone;
//If possible i would like 1st 3 in 1 TD and last 5 in 1 TD

<?php
trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo "<p align=center><b>You have not entered search details. Please go back and try again.</b></p>";
exit;
}
/* Connecting, selecting database */
@ $db = mysql_connect("db_host", "db_user", "db_pass&quot

or die("Could not connect&quot

;
mysql_select_db("churches&quot

or die("Could not select database&quot

;
/* Performing SQL query */
$query = "SELECT * FROM church order by 'name' asc";
$result = mysql_query($query) or die("Query failed&quot

;
$num_results = mysql_num_rows($result);
print "<p><b>Your search produced ".$num_results." matches.</b></p>";
/* Printing results in HTML */
print "<table border=1 cellspacing=0 cellpadding=2 width=750 align=center>\n";
print "<tr>\n";
print "<td bgcolor=#0099CC colspan=3><p><b>Organization</b></p></td>\n";
print "<td bgcolor=#0099CC colspan=5><p><b>Information</b></p></td>\n";
print "</tr>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
if ($searchterm = '%"nameof"%');
print "<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td height=30><p><font size=1>$col_value</font></p></td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($db);
?>

danielhozac · Sep 6, 2002

Change

Code:

   $query = &quot;SELECT * FROM church order by 'name' asc&quot;;

to

Code:

   $query = &quot;SELECT * FROM church WHERE &quot;.$searchtype.&quot; LIKE '%&quot;.$searchterm.&quot;%'order by 'name' asc&quot;;

This would only select the rows that matches the search criterias. //Daniel

beeg · Sep 6, 2002

Okay, tried that and got back query failed.
Thanks - Beeg

beeg · Sep 6, 2002

Oh!! it worked thank you so much!
Last thing do you know how to change it so name, pastor, denomination feilds will be in one TD and address, city, state, zip, phone will be in one TD.

Beeg

danielhozac · Sep 6, 2002

This should do it.

Code:

    while ($row = mysql_fetch_assoc($result)) {
        print &quot;<tr>\n&quot;;
        printf(&quot;<td colspan=\&quot;3\&quot;>%s, %s, %s</td><td colspan=\&quot;5\&quot;>%s, %s, %s, %s, %s</td>\n&quot;, $row['name'], $row['pastor'], $row['denomination'], $row['address'], $row['city'], $row['state'], $row['zip'], $row['phone']);
        print &quot;\t</tr>\n&quot;;
    }

You could also just use the concatentation operator to create the string. //Daniel

beeg · Sep 6, 2002

close table looks right, but have 3 ,,, in 1st TD and 5 ,,,,, in the next. Didn't put the information in.

Thanks - Beeg

beeg · Sep 6, 2002

Help; almost works but got 2 commas in first TD an 4 in second but don't get the information.
Beeg

danielhozac · Sep 6, 2002

What is the script you're using? Do you have a empty row in your database? //Daniel

beeg · Sep 6, 2002

Not that I'm aware of. what do you mean by script

danielhozac · Sep 6, 2002

Is it just the last row that doesn't work for you or is it all rows? //Daniel

beeg · Sep 6, 2002

all the rows, so for example is says there are 5 results blah blah
then the table starts top row has the headers i placed org and info. But all subsequent rows only have the commas

Beeg

beeg · Sep 6, 2002

You can see what it's doing here.

http://amplifyhim.com/community.htm

Beeg

beeg · Sep 6, 2002

Also I was going to vote for you to express my gratitude for your help thus far and can't find the voting spot??

Beeg

danielhozac · Sep 7, 2002

It's because you are a visitor. Visitors cannot vote.
Do what sleipnir214 told you to do in your other thread, which was adding a

Code:

print_r($row);

right after the

Code:

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

The whole while loop would then look like this:
[tt] while ($row = mysql_fetch_assoc($result)) {
print_r($row);
print "<tr>\n";
printf("<td colspan=\"3\">%s, %s, %s</td><td colspan=\"5\">%s, %s, %s, %s, %s</td>\n", $row['name'], $row['pastor'], $row['denomination'], $row['address'], $row['city'], $row['state'], $row['zip'], $row['phone']);
print "\t</tr>\n";
}[/tt]
Post the results of this here, it would help a lot. //Daniel

beeg · Sep 7, 2002

Signed up last night, so I see what you're talking about. Figured I would finish this thread as Beeg.
Anyway result was it printed everythin like this;

Array ( [Name] => Anchor Baptist Church [Pastor] => Pastor David Foster [Denomination] => Baptist [Address] => 3524 N.E. 95th Street [City] => Seattle [State] => WA [Zip] => 98115 [Phone] => 206-525-5646 )

This is one result, so if it said 7 I got seven of these. All printed above the table, not in it, table still has the commas though

Beeg

danielhozac · Sep 7, 2002

Since PHP variables are case sensitive, you should use

Code:

        printf(&quot;<td colspan=\&quot;3\&quot;>%s, %s, %s</td><td colspan=\&quot;5\&quot;>%s, %s, %s, %s, %s</td>\n&quot;, $row['Name'], $row['Pastor'], $row['Denomination'], $row['Address'], $row['City'], $row['State'], $row['Zip'], $row['Phone']);

//Daniel

KarveR · Sep 7, 2002

or don't use any row names and let the PHP make the table to fit.:
---------------------------------------------------------
<?php

trim($searchterm);

if (!$searchtype || !$searchterm) {

echo "<p align=center><b>You have not entered search details. Please go back and try again.</b></p>";

exit;

}

// connect to database

$db = mysql_connect("db_host", "db_user", "db_pass&quot

;

mysql_checkerror();

mysql_select_db("churches&quot

;

mysql_checkerror();

// do the query

$query = "SELECT * FROM church WHERE ".$searchtype." LIKE '%".$searchterm."%'order by 'name' asc";

$result = mysql_query($query);

mysql_checkerror();

// get number of results

$num_results = mysql_num_rows($result);

print "<p><b>Your search produced ".$num_results." matches.</b></p>";

// figure out how many columns are in it and do the table to fit.

$columns=@mysql_num_fields($result);

echo "<table align=\"center\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\">\n";

$row=0;

// display field names set to 0 for no field names

$display=1;

if($display == 1){
print "<th>row</th>";

for ($i = 0; $i < mysql_num_fields($result); $i++) {

print "<th>".preg_replace("/_/"," ",mysql_field_name($result,$i))."</th>\n";

}
}
while ($myrow = @mysql_fetch_array($result)){

// start the results display table, display alternate rows in different colors.

$row++;

if($row%2){

$color="#CCCCCC";

}else{

$color="#9FC6C4";

}

echo "<tr><td>$row</td>";

for ($i = 0; $i < ($columns); $i++) {

echo "<td bgcolor=\"$color\"> $myrow[$i] </td>\n";

}

echo "</tr>\n";

}

mysql_free_result($result);

echo "</table>\n";

// functions

function mysql_checkerror(){

$err_no=mysql_errno();

if ($err_no > 0 ){

echo "<h2> Error:</h1> " . mysql_errno() . ": " . mysql_error() . "<br>\n";

exit;

}
}

?> ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

beeg · Sep 7, 2002

Karver thanks for the input, part of the issue was that in output I wanted to combine certain fields, so we couldn't do that.

Daniel - Thanks for all your help and patience, that last one worked. I hadn't realized I capitalized the fields I almost never use upper case when coding.

Beeg

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Frustrated beginner 1

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

Programmer

MIS

Programmer

Similar threads

Log in

Part and Inventory Search

Sponsor