PHP & MYSQL Questions

[artisticre]

I am making a website for a t-shirt company. I am trying to learn MYSQL & PHP for my own knowledge and thought this would be a great opportunity to use it. I am struggling with something. I have a page with probably 70 images of tshirts. I want to only create a template and then pull the tshirt information from the database. How is this done? I also have the code for the shopping cart on this page. Is this going to be a problem?

thanks

[PyroX]

Its not that I doubt your competence, but if you do not know how to layout a database / page interaction, how are you doing an e-commerce shopping cart?

It is my opinion that you should never start 'learning' something when working on someone else's product or project.

Just my 2 cents worth.

[BeastRider]

You want to do something like my website of photos, only fill it full of T shirts?

http://www.herbhost.com/seasia/

Have you created a database before?

Why not just use one of any number of free shopping carts that are already written? You get catalogs with them, and often built in code for connecting to a variety of payment processors.

[artisticre]

I am using an already written ecommerce package. Just need to know how to use a template

[batman]

What you will need to do is give each t-shirt image on start page a link like:
<a href="view_product.php?shirt_id=1">T-Shirt 1</a>
<a href="view_product.php?shirt_id=2">T-Shirt 2</a>

In the code below you will need to change the following: change the table name in the query, and change all the field names in the query to the desired.

Then for the view_product.php page do something like this:

<?
$shirt = $_GET["shirt_id"];

// make sure product exists/has been selected
if(empty($shirt))
{
echo "<div align='center'><br>No product has been selected to view!</div>";
}

else
{
$select_prod = mysql_query( "SELECT * FROM your table name here WHERE shirt='$shirt'");
$totalrows = mysql_num_rows($select_prod);

if($totalrows==0){echo"<br><br><p align=\"center\">The product you are trying to view no longer exists in our database!</p>";}

// build page for product

if($totalrows!==0){
	  while ($row = mysql_fetch_array($select_prod))
      {
          $title = $row["title"];
          $image = $row["image"];
          $description = $row["description"];
          $quantity = $row["quantity"];
          $price = $row["price"];
          //And so on
	   }

//Then print info however you want. Example:

echo"<table width=\"443\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
  <tr> 
    <td width=\"98\" height=\"20\" valign=\"top\"><b>Image:</b></td>
    <td width=\"69\" valign=\"top\"><b>Title:</b></td>
    <td width=\"160\" valign=\"top\"><b>Description:</b></td>
    <td width=\"116\" valign=\"top\"><b>Price:</b></td>
  </tr>
  <tr> 
    <td valign=\"top\" height=\"88\">
      $image
    </td>
    <td valign=\"top\"> 
      $title
    </td>
    <td valign=\"top\"> 
      $description
    </td>
    <td valign=\"top\"> 
      $price
    </td>
  </tr>
  <tr> 
    <td height=\"28\" colspan=\"4\" valign=\"top\"> 
      <div align=\"right\"> 
"; 
        <?if($quantity == "0") {echo "<font color=\"red\"><b>(Out of Stock)</b></font>";} else {echo "<font color=\"red\"><b>(In Stock)</b></font>";}?>  echo"
        &nbsp;&nbsp;&nbsp;<b>Quantity:</b> 
        <input type=\"text\" name=\"qty\" size=\"5\" value=\"1\">
        <input type=\"submit\" name=\"Submit\" value=\"Add To Cart\">
      </div>
    </td>
  </tr>
</table>
";
?>

Then it is up to you to do the form part of that table.

You can also try changing to a shopping cart that already has a catalog built in.

-Blake