Display Records (brief summary and full details)

#1 (**permalink**) 07-24-2003

Hello All,

I am trying to create a small MySQL application using PHP. I have a
table of contacts with each record having over 30 fields. I have a
search page where a logged-in admin can search for a particular record
on the basis of certain parameters.

This is a sample code:

$sql1 = "SELECT * from `contacts` WHERE $where";\0\0

while ($row = mysql_fetch_array($result1)) {

// Alternate the bgcolor of each row for visibility
($even % 2) == 0 ? $bgcolor = "#EFEFEF" : $bgcolor =
"#eeffff";
$even = $even + 1;

// print the actual row
echo "<TR BGCOLOR=$bgcolor>
<TD align=\"left\">$row[company]</TD>
<TD align=\"left\">$row[name_1]</TD>
<TD align=\"left\">$row[phone_1]</TD>
<TD align=\"left\">$row[city]</TD>
<TD align=\"left\">$row[url]</TD>
<TD align=\"left\">$row[email_1]</TD>
<TD align=\"center\"><a
href=\"profile.php\">Link</a></TD>
</TR>";

// try to register the variable
$_SESSION['link'] = $row[company];
} // end while
// print the end of the table
echo "</TABLE></body></html>";

The above tables displays the results of the query in a table form
with only the main fields of the record. The last column of the table
contains a link to view the full-contents of the record. when the user
clicks this link, he will go to another script called
"profile.php" which will display all the contents of the record. In
order to do this I will need to store all the primary keys (in this
case the name of the company) of each record from the result set and
then use it to retrieve all the contents. I have been successful in
trying to do this for a single row (record) of the result by
registering it as an session variable called ['link']

I am at a loss to figure out how to store the names of the first column
of the result set i.e. the company name. Is it possible to create an
array of the session variable ['link'] ?? Another approach would be
to get the names of the companies as a separate query and register them
as an array of session variables.

any suggestions will be welcome. Thanks in advance.

--Pushpinder

#2 (**permalink**) 07-25-2003

Hi,

Friday, July 25, 2003, 7:13:27 AM, you wrote:
PSG> Hello All,

PSG> I am trying to create a small MySQL application using PHP. I have a
PSG> table of contacts with each record having over 30 fields. I have a
PSG> search page where a logged-in admin can search for a particular record
PSG> on the basis of certain parameters.

PSG> This is a sample code:

PSG> $sql1 = "SELECT * from `contacts` WHERE $where";

PSG> while ($row = mysql_fetch_array($result1)) {

PSG> // Alternate the bgcolor of each row for visibility
PSG> ($even % 2) == 0 ? $bgcolor = "#EFEFEF" : $bgcolor =
PSG> "#eeffff";
PSG> $even = $even + 1;

PSG> // print the actual row
PSG> echo "<TR BGCOLOR=$bgcolor>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[company]</TD>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[name_1]</TD>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[phone_1]</TD>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[city]</TD>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[url]</TD>
PSG> <TD align=\"left\"> face=\"Verdana, Arial, Helvetica, sans-serif\">$row[email_1]</TD>
PSG> <TD align=\"center\"> face=\"Verdana, Arial, Helvetica, sans-serif\"><a
PSG> href=\"profile.php\">Link</a></TD>
PSG> </TR>";

PSG> // try to register the variable
PSG> $_SESSION['link'] = $row[company];
PSG> } // end while
PSG> // print the end of the table
PSG> echo "</TABLE></body></html>";

PSG> The above tables displays the results of the query in a table form
PSG> with only the main fields of the record. The last column of the table
PSG> contains a link to view the full-contents of the record. when the user
PSG> clicks this link, he will go to another script called
PSG> "profile.php" which will display all the contents of the record. In
PSG> order to do this I will need to store all the primary keys (in this
PSG> case the name of the company) of each record from the result set and
PSG> then use it to retrieve all the contents. I have been successful in
PSG> trying to do this for a single row (record) of the result by
PSG> registering it as an session variable called ['link']

PSG> I am at a loss to figure out how to store the names of the first column
PSG> of the result set i.e. the company name. Is it possible to create an
PSG> array of the session variable ['link'] ?? Another approach would be
PSG> to get the names of the companies as a separate query and register them
PSG> as an array of session variables.

PSG> any suggestions will be welcome. Thanks in advance.

PSG> --Pushpinder

in the href put

....<a href=\"profile.php?name=".$row['name']."\">...

Make a seperate array as you loop

$companies[$row['name']] = $row;

in your session store it as

$_SESSION['link'] = $companies;

You can then access it in profile php as

$details = $_SESSION['link']['$_GET['name']]

--
regards,
Tom

#3 (**permalink**) 07-25-2003

Thanks Tom,

I appreciate your help ! however I have a 2 quick questions...

1.) should we not save the names of the companies as $companies[$row]
= $row['company']; \0\0
2.) the approach of accessing the variable as $details =
$_SESSION['link']['$_GET['name']] is not
working , when I try to echo the $details is get something else.
I am not sure how we use the
$_SESSION[ ] [ ] with 2 variables as shown.

any help will be appreciated.

regards
--Pushpinder

On Thursday, July 24, 2003, at 08:10 PM, Tom Rogers wrote:

> Hi,
>
> Friday, July 25, 2003, 7:13:27 AM, you wrote:
> PSG> Hello All,
>
> PSG> I am trying to create a small MySQL application using PHP. I
> have a
> PSG> table of contacts with each record having over 30 fields. I have a
> PSG> search page where a logged-in admin can search for a particular
> record
> PSG> on the basis of certain parameters.
>
> PSG> This is a sample code:
>
>
> PSG> $sql1 = "SELECT * from `contacts` WHERE $where";
>
> PSG> while ($row = mysql_fetch_array($result1)) {
>
> PSG> // Alternate the bgcolor of each row for visibility
> PSG> ($even % 2) == 0 ? $bgcolor = "#EFEFEF" : $bgcolor =
> PSG> "#eeffff";
> PSG> $even = $even + 1;
>
> PSG> // print the actual row
> PSG> echo "<TR BGCOLOR=$bgcolor>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[company]</TD>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[name_1]</TD>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[phone_1]</TD>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[city]</TD>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[url]</TD>
> PSG> <TD align=\"left\"> PSG> face=\"Verdana, Arial, Helvetica,
> sans-serif\">$row[email_1]</TD>
> PSG> <TD align=\"center\"> PSG> face=\"Verdana, Arial, Helvetica, sans-serif\"><a
> PSG> href=\"profile.php\">Link</a></TD>
> PSG> </TR>";
>
> PSG> // try to register the variable
> PSG> $_SESSION['link'] = $row[company];
> PSG> } // end while
> PSG> // print the end of the table
> PSG> echo "</TABLE></body></html>";
>
>
> PSG> The above tables displays the results of the query in a table form
> PSG> with only the main fields of the record. The last column of the
> table
> PSG> contains a link to view the full-contents of the record. when the
> user
> PSG> clicks this link, he will go to another script called
> PSG> "profile.php" which will display all the contents of the record.
> In
> PSG> order to do this I will need to store all the primary keys (in
> this
> PSG> case the name of the company) of each record from the result set
> and
> PSG> then use it to retrieve all the contents. I have been successful
> in
> PSG> trying to do this for a single row (record) of the result by
> PSG> registering it as an session variable called ['link']
>
>
> PSG> I am at a loss to figure out how to store the names of the first
> column
> PSG> of the result set i.e. the company name. Is it possible to create
> an
> PSG> array of the session variable ['link'] ?? Another approach
> would be
> PSG> to get the names of the companies as a separate query and
> register them
> PSG> as an array of session variables.
>
>
> PSG> any suggestions will be welcome. Thanks in advance.
>
> PSG> --Pushpinder
>
> in the href put
>
> ...<a href=\"profile.php?name=".$row['name']."\">...
>
> Make a seperate array as you loop
>
> $companies[$row['name']] = $row;
>
> in your session store it as
>
> $_SESSION['link'] = $companies;
>
> You can then access it in profile php as
>
>
> $details = $_SESSION['link']['$_GET['name']]
>
>
> --
> regards,
> Tom
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

#4 (**permalink**) 07-26-2003

* Thus wrote Pushpinder Singh Garcha (pgarcha@adelphia.net):
> Thanks Tom,
>
> I appreciate your help ! however I have a 2 quick questions...
>
> 1.) should we not save the names of the companies as $companies[$row]
> = w['company'];
I'm not sure in what context or what purpose you wish to do so.
There is, in general, nothing wrong with storing your information
like that.

> 2.) the approach of accessing the variable as $details =
> $_SESSION['link']['$_GET['name']] is not
> working , when I try to echo the $details is get something else.
> I am not sure how we use the
> $_SESSION[ ] [ ] with 2 variables as shown.
>

I assume you mean:
$_SESSION['link'][$_GET['name']];

If you could provide an example on how you set the array that would
be easier to let you know why your output is not comming back
right.

Please Compose a new message and type a subject when starting a new
topic.

Curt
--
"I used to think I was indecisive, but now I'm not so sure."

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode