[Resolved] Field from first column as link in another column in table...

Garry2004

Hello,

I am almost positive that this is a very simple question (I say, as I wait for my "SQL for Dummies" and "PHP for the absolute beginner" books).

I have a table of parts. I then have a query results page.

<?php
$conn=pg_pconnect("dbname=foo user=foofoo password=foobar");
$sql="SELECT * FROM parts WHERE part_number ~~* '%$_POST[partnum]%'";
$result=pg_exec($conn, $sql);

if($result) {
    echo "\n";
} else {
    echo "Error, you need to enter a part number to search for.\n";
}
?>
<TABLE border="1" frame="border" summary="This table gives the results from a parts lookup query." ALIGN="left">
<?php    

 {

echo '<tr><th>Part Number</th><th>Description</th><th>Details</th>';

while($row = pg_fetch_array($result))

echo '<tr><td>'.$row['part_number'].'</td><td>'.$row['part_desc'].'</td><td><a href="partdetail.php?part_number">View</a> 
</td>
    </tr>';
    echo '</table>';
?   

}
?>

Right now if I type in a partial part number for the query it returns a list of like parts, which is what I want it to do.

Results:

Part Number -- Description -- Details
35A-50000 -- Nose Wheel Assembly -- View

35-24000 -- Water Rudder Assembly -- View

I want to be able to pull up the "partdetail.php" by clicking on the "view" link and have it bring up the details from the first column part number.

Currently, when I click on the "view" link, I always have the details for ALL the part numbers in the table returned. I think it is because I am referencing "part_number" instead of the first column in the specific row. This is my problem, I don't know how to point to the first column in a specific row.

Does anyone have an example or point to a tute or link that can help me, if it is even (dare I say) possible?

Thanks,
G

travelbuff

You are on the right track. The problem is that you are not telling partdetail.php what part number to look up. You have to include a variable name AND a value in the url to accomplish that.

Example: $_SERVER['document_root']/script.php?variable_name=value

In the code you posted, you initialized the part number variable but did not assign it a value. So your URL should look like this instead:

'<a href="partdetail.php?part_number='.$row['part_number'].'">View</a>'

Then you use a where clause in partdetail.php to only pull records that match the provided part number.

Just a thought - what you are doing there is a bit....sub-optimal, IMHO. I would consider using heredoc (http://us2.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc ) to build the whole table and results into a variable and then echo the variable. Would be a lot cleaner....

HTH

Garry2004

Okay,

Here is what I have in partdetail.php, I tried to change the "WHERE" parameters every which way from Sunday to pull only the part whose "View" link was selected. I reverted this back to the original code when I was using this as a result form for the submit form. I am now trying to use it for the detailed profile of the part.

I tried putting

part_number='.$row['part_number'].'

instead of what you see below in the WHERE clause but I get parse errors.

Please help, thanks. G

<?php
$conn=pg_pconnect("dbname=blah user=blah1 password=blah2");
$sql="SELECT * FROM parts WHERE part_number= '$_POST[part_number]'";
$result=pg_exec($conn, $sql);

if($result) {
    echo "\n";
} else {
    echo "Error, you need to click view on the parts query results page.\n";
}
?>
<TABLE border="1" frame="border" summary="This table is linked to the submitsearch.php form" ALIGN="left">
<?php    

 {
    while($row = pg_fetch_array($result))
    echo '<tr><th>Part Number</th><td>'.$row['part_number'].'</td>
    <tr><th>Description</th><td>'.$row['part_desc'].'</td>
    <tr><th>Lot# (P.O./W.O.)</th><td>'.$row['lot_number'].'</td>
    <tr><th>Qty. Onhand</th><td>'.$row['part_qty_onhand'].'</td>
    <tr><th>Min. Qty.</th><td>'.$row['part_qty_min'].'</td>
    <tr><th>Target Qty.</th><td>'.$row['part_qty_target'].'</td>
    <tr><th>List Price</th><td>'.$row['part_listprice'].'</td>
    <tr><th>Cost Price</th><td>'.$row['part_costprice'].'</td>
    <tr><th>Alternate Part #</th><td>'.$row['alt_part_num'].'</td>
    <tr><th>Location</th><td>'.$row['loc'].'</td>
    <tr><th>First Level Discount</th><td>'.$row['discount1'].'</td>
    <tr><th>Second Level Discount</th><td>'.$row['discount2'].'</td>
    <tr><th>Third Level Discount</th><td>'.$row['discount3'].'</td>
    <tr><th>Taxable Item?</th><td>'.$row['taxable'].'</td>
    <tr><th>Serialized Item?</th><td>'.$row['serialized'].'</td>
    <tr><th>Serial Number</th><td>'.$row['serial_num'].'</td>
    <tr><th>Non-Depleting Item?</th><td>'.$row['nondeplete'].'</td>
    <tr><th>Weight</th><td>'.$row['weight'].'</td>
    <tr><th>Qty. On Order</th><td>'.$row['onorder'].'</td>
    <tr><th>Qty. Allocated </th><td>'.$row['image_name'].'</td>
    <tr><td ROWSPAN="1" COLSPAN="2" BGCOLOR="#FFFF00"> </td></tr>
    </tr>';

}
?>

🆒

Garry2004

Mark,

Also, thanks for the suggestion on heredoc, I have read through the link you gave me and I will probably use that. Right now I want to just get this functional and then go back to heredoc.

I can really see how that would be useful.

Regards,
G

travelbuff

Ok, I am a bit confused - are you passing the variable data through the url? If so, you have to use $GET not $POST.

Try doing this:

$part_number = $_GET['part_number'];
echo $part_number; //for debugging purposes
$sql="SELECT * FROM parts WHERE part_number= '$part_number' ";

Garry2004

Hi Mark,

That did it. Till next time, many thanks.

G😃