dk01 — Sat, 05 Oct 2002 12:47:19 +0000

About Peter's response to your first question.
You could have another column named 'catagory' with the catagory that each item is placed in and then do:
$catagory='monitors';
$query = mysql_query("SELECT * FROM `catalog` WHERE catagory='$catagory'");
instead of:
$query = mysql_query("SELECT id,item,description,price,rating FROM `catalog`");

-dk

Peter J. Boettcher — Fri, 04 Oct 2002 15:01:26 +0000

1. You would have to design your database to allow different categories. Probably by adding another table that holds these items along with what category they're in.

2. You would use an INSERT to put data into your database.

You might want to take a second to read up on mySQL so you really understand what you're doing, take a look at the docs at: mysql.com

club-art.net — Fri, 04 Oct 2002 04:40:04 +0000

necrotic, thanks for helping me

I have 2 questions :

1. Because I would like to use this database for a computer store,
I would like to display different categoryes of catalog. How can I display for example just monitors or CPU or Ram data?

2. How can I fill database with all product data?

necrotic — Fri, 04 Oct 2002 00:49:06 +0000

Okay, first you need a MySQL database. Make sure it's set up and running. When you're sure it's up and running you need to make a table, I'll call it `catalog`. In PHP the syntax for creating a table is:

<?php
CREATE TABLE `catalog` (
`id` TINYINT(6) NULL AUTO_INCREMENT PRIMARY KEY, 
// This makes a column called `id` for your item ID number. It's set to increase automatically with each insertion.
`item` VARCHAR(255) NOT NULL, 
// This makes a column for your item name. It's set for a max length of 255 characters.
`description` TEXT NOT NULL, 
// This makes a column for your items description.
`price` VARCHAR(10) NOT NULL, 
// This makes a colum for your items cost.
`rating` TINYINT(5) NOT NULL 
// This makes a column for your items ratings. People can vote a value of 1-10 and it will contain the average.
);
?>

That's probably not the best way to make it. But it's how I would. To grab an item(s) from the database you would need something like this:

<?php
$connect = mysql_connect('localhost','USERNAME','PASSWORD'); 
// Replace USERNAME and PASSWORD with their respective items.
$db_con = mysql_select_db('DBNAME',$connect); 
// Replace DBNAME with the name of your database.

// The following line declares the query to be done.
$query = mysql_query(\"SELECT id,item,description,price,rating FROM `catalog`\");

// Next we need to use the query. The while() function keeps the results flowing.
while($result = mysql_fetch_assoc($query)) {
  $id = $result[\"id\"];
  $item = $result[\"item\"];
  $description = $result[\"description\"];
  $price = $result[\"price\"];
  $rating = $result[\"rating\"];

  echo (\"ID: $id<BR>\n\");
  echo (\"Item: $item<BR>\n\");
  echo (\"Description: $description<BR>\n\");
  echo (\"Price: \$ $price<BR>\n\");
  echo (\"Rating: $rating<BR><BR>\n\n\");
}

exit($db_con);
?>

People more fluent in PHP/MySQL should be able to help you more, but I hope I helped some

club-art.net — Thu, 03 Oct 2002 08:24:59 +0000

Can someone help me to do this with MySQL.

Please.

Busy — Wed, 02 Oct 2002 23:11:10 +0000

information drawen from a database would be easier, but you can do what you want to do I think with flat file.

productlist.inc

$item_1 = ("the details .....");
$item_2 = ("the details .....");
$item_3 = ("the details .....");
$item_4 = ("the details .....");
$item_5 = ("the details .....");
etc

then call this page from the page you want it on:
include ("productlist.inc");

then make your tables

<?php
 echo("$item_1"); 
?>

<?php
 echo("$item_2"); 
?>

...

This is a very basic example, but in the $item_1 description could be product number table tags product name table tags ... to make the layout the same.
If your going to a lot of these pages I would reccomend learning MySQL, would be so much easier and faster.