Ad:

PHP Discussion Thread
Marked Solved
Views: 1348

Mar 8th, 2008

Small catalog problem

Expand Post »

hi, i am trying to make a simple catalog website without checkout. the user clicks on a product he want and it's displaced on another page...simple. the first page (the one with the product list) has the following code...

PHP Syntax (Toggle Plain Text)
<?php
$sql = "SELECT * FROM products";
$result = mysql_query($sql);
if (!$result)
{
echo "Error - query: $sql - " . mysql_error();
exit;
}
 
while ($row = mysql_fetch_array($result)) {
echo "<p class='rc_textAreatext'><a href='viewprod.php?id=" . $row['prod_name']. "'>"
 . $row['prod_name'] . "</a> - " . $row['description'] . 
"&nbsp;&nbsp;&nbsp;$" .$row['price'] . "</p>";
}
?>
<?php
$sql = "SELECT * FROM products";
$result = mysql_query($sql);
if (!$result)
{
echo "Error - query: $sql - " . mysql_error();
exit;
}
						
while ($row = mysql_fetch_array($result)) {
echo "<p class='rc_textAreatext'><a href='viewprod.php?id=" . $row['prod_name']. "'>"
 . $row['prod_name'] . "</a> - " . $row['description'] . 
"&nbsp;&nbsp;&nbsp;$" .$row['price'] . "</p>";
}
?>

on the next page (viewprod.php) i have no idea what to put on the page to call up the product clicked. i know i read it in my books but i cant find it anywhere...can someone help?
Thanks

p.s. sorry if this is a dumb question

Similar Threads

Understanding ASP classes in ASP
Windows Update problem in Windows Vista and Windows 7
memory management in wndows 2000 in Windows NT / 2000 / XP
not-a-virusadware in Viruses, Spyware and other Nasties
more "home search assistent" fun... in Viruses, Spyware and other Nasties

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

Permalink

Mar 8th, 2008

Re: Small catalog problem

Place a hidden field in your script relating to the item in the record set that you are calling, and use something like this:

php Syntax (Toggle Plain Text)

<a href="viewprod.php?ID=<?php echo $rs['ID']; ?>"target="_blank"><strong>View</strong></a>

on your viewprod.php get the value of the item passed in the URL

php Syntax (Toggle Plain Text)
$colname_rs_ID = "-1";
if (isset($_GET['ID'])) {
  $colname_rs_ID = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database, $conn);
$query_rs_ID = sprintf("SELECT * FROM your_db_table WHERE ID = %s", $colname_rs_ID);
$rs_ID = mysql_query($query_rs_ID, $conn) or die(mysql_error());
$row_rs_ID = mysql_fetch_assoc($r_ID);
$totalRows_rs_ID = mysql_num_rows($rs_ID);
$colname_rs_ID = "-1";
if (isset($_GET['ID'])) {
  $colname_rs_ID = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database, $conn);
$query_rs_ID = sprintf("SELECT * FROM your_db_table WHERE ID = %s", $colname_rs_ID);
$rs_ID = mysql_query($query_rs_ID, $conn) or die(mysql_error());
$row_rs_ID = mysql_fetch_assoc($r_ID);
$totalRows_rs_ID = mysql_num_rows($rs_ID);

then show the values from the record set on the screen

php Syntax (Toggle Plain Text)
 <input type="hidden" name="ID" value="<?php echo $row_rs_ID['ID']; ?>" />
<?php echo $row_rs_ID['ID']; ?>
 <input type="hidden" name="ID" value="<?php echo $row_rs_ID['ID']; ?>" />
<?php echo $row_rs_ID['ID']; ?>

JeniF

Reputation Points: 10

Solved Threads: 5

Junior Poster in Training

Offline

52 posts
since Aug 2007

Permalink

Mar 9th, 2008

Re: Small catalog problem

ok thanks i'll go try it out

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

Permalink

Mar 11th, 2008

Re: Small catalog problem

i just got around to using the code. i sorry i dont really understand the code. first, why do you need $colname_rs_ID = "-1";, why is it -1? And second, arent hidden fields used to get data submitted from a form not to output it?

Thanks again.

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

Permalink

Mar 11th, 2008

Re: Small catalog problem

just use the get method to retrieve the info from the previous page;

php Syntax (Toggle Plain Text)
//I suppose you have the connection here....
$id=$_GET['id'];
$sql = "SELECT * FROM products
           WHERE id='$id'";
$result = mysql_query($sql);
if (!$result)
{
echo "Error - query: $sql - " . mysql_error();
exit;
}
 
$id=mysql_result($result,0,"id");
$name=mysql_result($result,0,"prod_name");
$desc=mysql_result($result,0,"description");
$price=mysql_result($result,0,"price");
 
echo "ID:".$id."<br>";
echo "NAME:".$name."<br>";
echo "DESCRIPTION:".$desc."<br>";
echo "PRICE:".$price."<br>";
//I suppose you have the connection here....
$id=$_GET['id'];
$sql = "SELECT * FROM products
           WHERE id='$id'";
$result = mysql_query($sql);
if (!$result)
{
echo "Error - query: $sql - " . mysql_error();
exit;
}

$id=mysql_result($result,0,"id");
$name=mysql_result($result,0,"prod_name");
$desc=mysql_result($result,0,"description");
$price=mysql_result($result,0,"price");

echo "ID:".$id."<br>";
echo "NAME:".$name."<br>";
echo "DESCRIPTION:".$desc."<br>";
echo "PRICE:".$price."<br>";

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

Permalink

Mar 12th, 2008

Re: Small catalog problem

Click to Expand / Collapse Quote originally posted by mikki2 ...

PHP Syntax (Toggle Plain Text)
while ($row = mysql_fetch_array($result)) {
echo "<a href='viewprod.php?id=" . $row['prod_name']. "'>"
 . $row['prod_name'] . "</a> - " . $row['description'] . 
"&nbsp;&nbsp;&nbsp;$" .$row['price'] . "";
}
while ($row = mysql_fetch_array($result)) { echo "<a href='viewprod.php?id=" . $row['prod_name']. "'>" . $row['prod_name'] . "</a> - " . $row['description'] . "   $" .$row['price'] . ""; }

when you build the link for your product detail page, use $row['prod_id'] (or how your id column is named in your DB) instead of $row['prod_name'].

after that, in your product page do:
if(isset($_GET['id']))
{
$id = $_GET['id'];
// show details for this ID
}
else
{
echo "Sorry!!! We don't have this product!"

}

silviuks

Reputation Points: 10

Solved Threads: 15

Junior Poster in Training

Offline

95 posts
since Apr 2006

Permalink

Mar 12th, 2008

Re: Small catalog problem

Click to Expand / Collapse Quote originally posted by ryan_vietnow ...

just use the get method to retrieve the info from the previous page;
php Syntax (Toggle Plain Text)
//I suppose you have the connection here....
$id=$_GET['id'];
$sql = "SELECT * FROM products
 WHERE id='$id'";
$result = mysql_query($sql);
if (!$result)
{
echo "Error - query: $sql - " . mysql_error();
exit;
}
 
$id=mysql_result($result,0,"id");
$name=mysql_result($result,0,"prod_name");
$desc=mysql_result($result,0,"description");
$price=mysql_result($result,0,"price");
 
echo "ID:".$id." ";
echo "NAME:".$name." ";
echo "DESCRIPTION:".$desc." ";
echo "PRICE:".$price." ";
//I suppose you have the connection here.... $id=$_GET['id']; $sql = "SELECT * FROM products WHERE id='$id'"; $result = mysql_query($sql); if (!$result) { echo "Error - query: $sql - " . mysql_error(); exit; } $id=mysql_result($result,0,"id"); $name=mysql_result($result,0,"prod_name"); $desc=mysql_result($result,0,"description"); $price=mysql_result($result,0,"price"); echo "ID:".$id." "; echo "NAME:".$name." "; echo "DESCRIPTION:".$desc." "; echo "PRICE:".$price." ";

Looks easy enough. I'm currently reading "Sam's Teach Yourself PHP and Mysql in 24 hour". i'll checkout your code soon. Thanks

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

Permalink

Mar 13th, 2008

Re: Small catalog problem

@ryan_vietnow
i have tried the code out but i have one question. Whats the point of adding the "0" to ($result,0,"id"); and the other lines? i erased the "0" when i was testing the code and there seemed to be no difference. when i changed the number to 5 or something else i get the folloting error:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 5 on MySQL result index 3 in D:\AppServ\www\Study_Practice\Test_Sites\Shopping Cart\showitem.php on line 22

i'm just wondering is all. from what i get, the point of the "0" is to tell mysql which row to start searching. if i'm mistaken pls correct me

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

Permalink

Mar 13th, 2008

Re: Small catalog problem

yes,that is correct,"0" is the row(which means first)
where the result of the query will be displaying.

if I put there 1,it means that the data from the 2nd row will be displayed.

ryan_vietnow

Reputation Points: 28

Solved Threads: 71

Posting Pro

Offline

578 posts
since Aug 2007

Permalink

Mar 13th, 2008

Re: Small catalog problem

ok thanks alot...i guess thats 41 solved threads for you

mikki2

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

68 posts
since May 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: problem solved sort of

Next Thread in PHP Forum Timeline: Dynamic content and printer pages

DaniWeb Message

Cancel Changes

User Name
Password