Creating a hyperlink to a specific record

I have a php page which contains the code:

echo "";
echo "$JobNumber";
echo "$Description";
echo "$NSN";
echo "$Manufacturer";
echo "$PartNumber";
echo "";

This produces a web page listing all records in my database. I would now
like to be able to click on a job number in that page and open a different
output form (results.php) displaying only that record. I already have a
search form which accepts a Job Number and then transfers that to
results.php using the variable 'searchterm'. What I want is to create a
hyperlink for each record that will open results.php and display only the
job number I selected.

Any help will be greatly appreciated.

Re: Creating a hyperlink to a specific record

Bob Sanderson wrote:
> I have a php page which contains the code:
>
> echo "";
> echo "$JobNumber";
> echo "$Description";
> echo "$NSN";
> echo "$Manufacturer";
> echo "$PartNumber";
> echo "";
>
> This produces a web page listing all records in my database. I would now
> like to be able to click on a job number in that page and open a different
> output form (results.php) displaying only that record. I already have a
> search form which accepts a Job Number and then transfers that to
> results.php using the variable 'searchterm'. What I want is to create a
> hyperlink for each record that will open results.php and display only the
> job number I selected.
>
> Any help will be greatly appreciated.

Generate a hyperlink with the job number as parameter in the first page.



If you now access $_GET['jobnumber'] it shoudl hold the value from the
lionk you clickjed on and present the job details with a select query
from the database.

Jonathan

Re: Creating a hyperlink to a specific record

Jonathan wrote in
news:43c2e2cb$0$10084$ba620dc5@text.nova.planet.nl:

> If you now access $_GET['jobnumber'] it should hold the value from the
> lionk you clickjed on and present the job details with a select query
> from the database.

Thanks for the reply. I'm fairly new to PHP. The link makes sense, but I
don't understand the statement above. Can you please elaborate on how I
would implement that?

Re: Creating a hyperlink to a specific record

Among the wreckage we found a fragment on which Bob Sanderson had
scratched:

> Thanks for the reply. I'm fairly new to PHP. The link makes sense, but I
> don't understand the statement above. Can you please elaborate on how I
> would implement that?

If it's any consolation so am I. I was poring over a hot computer until
about 11 last night trying to learn PHP very quickly from the manual for a
one-off job.

In the end I produced these two scripts. They present my address book as
two web pages. The first is a simple list of all the names and addresses
in the book, which is a single table. The salutation (Mr., Mrs., etc.) is
a clickable link which brings up a full version of the address on another
page.

The first script (hello.php) puts up the summary page:





echo "

Re: Creating a hyperlink to a specific record

Bob Sanderson wrote:
> Jonathan wrote in
> news:43c2e2cb$0$10084$ba620dc5@text.nova.planet.nl:
>
>
>>If you now access $_GET['jobnumber'] it should hold the value from the
>>lionk you clickjed on and present the job details with a select query
>>from the database.
>
>
> Thanks for the reply. I'm fairly new to PHP. The link makes sense, but I
> don't understand the statement above. Can you please elaborate on how I
> would implement that?

Suppose we have a hyperlink that has jobnumber 123. I would look like this:



If you clikc on this hyperlink it will open the results.php page. In
this page you can access the value for the jobnumber you transmitted
with the hyperlink.

All values that are transmitted in the URL are transmitted as a GET
request you can access these values using the super global $_GET. This
is a special variabele that is an array of all the values passed to the
page.

You can now query the database with the specified number and then
display the result of the query, like with the code below.

// Check whether the value for jobnumber is transmitted
if (isset($_GET['jobnumber'])) {

// Put the value in a separate variable
$jobnumber = $_GET['jobnumber'];

// Query the database for the details of the chosen jobnumber
$result = mysql_query("select jobnumber, description, NSN,
manufacturer, partnumber from table where jobnumber = $jobnumber");

// Check result
// This shows the actual query sent to MySQL, and the error. Useful
for debugging.
if (!$result) {
$message = "Invalid query: " . mysql_error() . "\n";
$message .= "Whole query: " . $query;
die($message);
}

// Use result
// Attempting to print $result won't allow access to information in
the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(),
etc.
while ($row = mysql_fetch_assoc($result)) {
echo $row['jobnumber'] . "\n";
echo $row['description'] . "\n";
echo $row['NSN'] . "\n";
echo $row['manufacturer'] . "\n";
echo $row['partnumber'] . "\n";
}
} else {
die("No valid jobnumber specified!");
}
?>

I hope this might help you a little further.

Jonathan

Re: Creating a hyperlink to a specific record

Jonathan wrote in news:43c401f1$0$10080$ba620dc5
@text.nova.planet.nl:

> I hope this might help you a little further.

Sure did, thanks again.

Re: Creating a hyperlink to a specific record

>Suppose we have a hyperlink that has jobnumber 123. I would look like this:
>
>
>
>If you clikc on this hyperlink it will open the results.php page. In
>this page you can access the value for the jobnumber you transmitted
>with the hyperlink.
>
>All values that are transmitted in the URL are transmitted as a GET
>request you can access these values using the super global $_GET. This
>is a special variabele that is an array of all the values passed to the
>page.
>
>You can now query the database with the specified number and then
>display the result of the query, like with the code below.
>
> > // Check whether the value for jobnumber is transmitted
> if (isset($_GET['jobnumber'])) {
>
> // Put the value in a separate variable
> $jobnumber = $_GET['jobnumber'];

SQL injection attack alert!

I think you want something like:
$jobnumber = addslashes($_GET['jobnumber']);
OR
$jobnumber = mysql_real_escape_string($_GET['jobnumber']);

or you can verify that it is all digits before running the query.


>
> // Query the database for the details of the chosen jobnumber
> $result = mysql_query("select jobnumber, description, NSN,
>manufacturer, partnumber from table where jobnumber = '$jobnumber'");

Gordon L. Burditt

Re: Creating a hyperlink to a specific record

Gordon Burditt wrote:
>
>
> SQL injection attack alert!
>
> I think you want something like:
> $jobnumber = addslashes($_GET['jobnumber']);
> OR
> $jobnumber = mysql_real_escape_string($_GET['jobnumber']);
>
> or you can verify that it is all digits before running the query.
>
>
>
>
>
> Gordon L. Burditt

You are completely right... forgot about it! Most of the times I use
PEAR::HTML_QuickForm like classes and check the entries before after
submit but before committing the entries to the database.

Jonathan