passing data through url

Anon

Is this possible?

I have a database with peoples last names. I want to be able to create one page (names.php4) and embed a command as follows: (names.php4?alpha=a-c) or (names.php4?alpha=d-g). When this link would be clicked on it would pull from the database all last names beginning with d-g etc would come up. I've figured out a way already to do it be creating different pages for all letter segments, but I would like to do it by creating just 1 page. Hopefully this doesn't sound to confusing.

Is this possible to do?!

Thanks,

Chad

Anon

Hi,

What about using:

$letter = split("-", $alpha);

SELECT * FROM $your_table WHERE lastname LIKE '$letter[0]%' OR lastname LIKE '$letter[1]%'

Hopes this helps?

Kind regards,
Gerry

Anon

I'm consider myself a novice to php, so is there any way can expand on what your proposing?

Thanks

Anon

Use explode or split (explode might be a little faster, no regex) to separate the first and last letters as suggested by the other post and then query like this.

list($start, $end) = explode("-", $alpha);

select field1, field2 from mytable
where substr(lastname, 0, 1) >= '$start'
and substr(lastname, 0, 1) <= '$end'
order by lastname

Anon

Hi Chad,

$letter = split("-", $alpha); // this will "split" your a-d into an array of the 2 letters
$letter[0] // first letter (a)
$letter[1] // second letter (d)

Then you use these letters to search your database. (all on the same page)

$query = mysql_query("SELECT * FROM $your_table WHERE lastname LIKE '$letter[0]%' OR lastname LIKE '$letter[1]%'");

while($row = mysql_fetch_array($query)) {
echo $row["some_table_maybe_firstname"];
echo $row["another_table_maybe_lastename"];
}

Try this... if it doesn't work, post your script here, with the right table names etc...

Kind regards,
Gerry

Anon

Here's my code. I want to do a range. Like from A-D. This makes sense. I must just be missing something little.

$db = mysql_connect();

mysql_select_db("udllabs",$db);

$letter = explode("-", $alpha);

list($start, $end) = explode("-", $alpha);

$query= "select SELECT ndc,product_description,size,compare from products
where substr(product_description, 0, 1) >= '$start'
and substr(product_description, 0, 1) <= '$end'
order by product_description";

Anon

Here's my code. I want to do a range. Like from A-D. This makes sense. I must just be missing something little.

$db = mysql_connect();

mysql_select_db("udllabs",$db);

$letter = explode("-", $alpha);

list($start, $end) = explode("-", $alpha);

Anon

Did you try, what i've posted before ??

Anon

Make sure you can connect to your database without passing parameters to mysql_connect. Then you're calling mysql_query() with $query after that and then looping through the results with mysql_fetch_array() or similar?

See code samples at http://www.php.net/manual/en/ref.mysql.php

Anon

Gerry,

Here's my entire script. It's still erroring out and I can't seem to determine way.

Thanks

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR lastname LIKE '$letter[1]%'");

$letter = split("-", $alpha)

$letter[0] // first letter (a)
$letter[1] // second letter (d)

$result = mysql_query($query)
or die ("Query failed");

if ($myrow = mysql_fetch_array($result))
{
echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
echo "<tr>\n";
echo "<td style=\"background-color: #000;\"><table cellpadding=\"2\" cellspacing=\"1\" border=\"0\">\n";
echo "<tr>\n";
echo "<th>NDC#</th>\n";
echo "<th>Product Description</th>\n";
echo "<th>Package Size</th>\n";
echo "<th>Compare To</th>\n";
echo "</tr>\n";

do {	printf("
<tr valign=\"top\">
 <td class=\"data\" nowrap>%s</td>
 <td class=\"data\">%s</td>
 <td class=\"data\">%s</td>
 <td class=\"data\">%s</td>
</tr>\n", $myrow["ndc"], $myrow["product_description"], $myrow["size"], $myrow["compare"]);} 
	while ($myrow = mysql_fetch_array($result));	
echo "</table></td>\n";

echo "</tr>\n";
echo "</table>\n";}

else { echo "Sorry, no records were found!"; }

//?>

Anon

I looked at the page you sent and made some modifications. Still getting errors, but does this look any better?

Thanks

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR lastname LIKE '$letter[1]%'");

$letter = split("-", $alpha)

$letter[0] // first letter (a)
$letter[1] // second letter (d)

$result = mysql_query($query)
or die ("Query failed");

do { printf("
<tr valign=\"top\">
<td class=\"data\" nowrap>%s</td>
<td class=\"data\">%s</td>
<td class=\"data\">%s</td>
<td class=\"data\">%s</td>
</tr>\n", $myrow["ndc"], $myrow["product_description"], $myrow["size"], $myrow["compare"]);}
while ($myrow = mysql_fetch_array($result));
echo "</table></td>\n";
echo "</tr>\n";
echo "</table>\n";}

else { echo "Sorry, no records were found!"; }

//?>

Anon

The code below doesn't give me any errors. It just outputs the exact letters in the url (A and D) rather than (A thru D).

test.php?alpha=a-d

Is there something i'm missing?

Thanks so much.

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$letter = split("-", $alpha);

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR product_description LIKE '$letter[1]%'");

$letter[0]; // first letter (a)
$letter[1]; // second letter (d)

while($row = mysql_fetch_array($query)) {
echo $row [ printf("
<table>
<tr>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>
</table>\n", $row["ndc"], $row["product_description"], $row["size"], $row["compare"])];

}

//?>

mediamind

Try this please...

<?php

$db_name = "YOUR_DB";
$table_name = "udllabs";

$connection = mysql_connect("LOCALHOST", "USER", "PASSWORD")
or die("Could not connect.");

$db = mysql_select_db($db_name, $connection)
or die("Could not select database.");

$letter = split("-", $alpha); // <-- this has to be before the query !!

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR lastname LIKE '$letter[1]%'");
$result = mysql_query($query) or die ("Query failed");
$num = mysql_num_rows($result);

if ($num != 0) {

echo "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
echo "<tr>\n";
echo "<td style=\"background-color: #000;\"><table cellpadding=\"2\" cellspacing=\"1\" border=\"0\">\n";
echo "<tr>\n";
echo "<th>NDC#</th>\n";
echo "<th>Product Description</th>\n";
echo "<th>Package Size</th>\n";
echo "<th>Compare To</th>\n";
echo "</tr>\n";

while ($myrow = mysql_fetch_array($result)) {
echo "<tr valign=\"top\">\n<td class=\"data\" nowrap>".$myrow["ndc"]."</td>\n<td class=\"data\">".$myrow["product_description"]."</td>\n<td class=\"data\">".$myrow["size"]."</td>\n<td class=\"data\">".$myrow["compare"]."</td>\n</tr>\n";
}
echo "</table></td>\n";
echo "</tr>\n";
echo "</table>\n";

} else {
echo "Sorry, no records were found!";
}

Anon

That query fails.

Back to the code I sent previously. Could it be something with the 'OR'. It works well except that it query A or C rather than A thru C.

Another person posted to try this but I'm lost on the below info:

(Use explode or split (explode might be a little faster, no regex) to separate the first and last letters as suggested by the other post and then query like this.

list($start, $end) = explode("-", $alpha);

select field1, field2 from mytable
where substr(lastname, 0, 1) >= '$start'
and substr(lastname, 0, 1) <= '$end'
order by lastname)

Original Code:

//<?php

$db = mysql_connect()
or die ("Could not connect");

mysql_select_db("udllabs")
or die ("Could not select database");

$letter = split("-", $alpha);

$query = mysql_query("SELECT * FROM products WHERE product_description LIKE '$letter[0]%' OR product_description LIKE '$letter[1]%'");

$letter[0]; // first letter (a)
$letter[1]; // second letter (d)

}

//?>