rahele83
چهارشنبه 05 اسفند 1388, 19:26 عصر
$dbc = mysqli_connect ('',
'root', '','ecommerce') OR die ('Could not connect to MySQL: ' .mysqli_connect_error() );
// Connect
$q = "SELECT artists.artist_id,
CONCAT_WS(' ', first_name, middle_name,
last_name) AS artist, print_name, price,
description, print_id FROM artists, prints
WHERE artists.artist_id = prints.artist_id
ORDER BY artists.last_name ASC,
prints.print_name ASC";
if(isset($_GET['aid'])&& is_numeric($_GET['aid']))
{
$aid=(int)$_GET['aid'];
if($aid>0)
{
$q = "SELECT artists.artist_id,
CONCAT_WS('', first_name,
middle_name, last_name) AS artist,
print_name, price, description,
print_id FROM artists, prints WHERE
artists.artist_id = prints.artist_id
AND prints.artist_id = $aid ORDER BY
prints.print_name";
}
}
echo '<table border=1 width=90% cellpaddin="0" cellspacing="0" align="center">
<tr>
<td align=left width=20%><b> Artist</b></td>
<td align=left width=20%><b> Pritn Name</b></td>
<td align=left width=20%><b> Description</b></td>
<td align=left width=20%><b> Price</b></td>
</tr>';
$r = mysqli_query ($dbc, $q);
if (mysqli_num_rows($r) > 0) {
$row = mysqli_fetch_array ($r);
// Display each record:
echo "\t<tr>
<td align=\"left\"><a
href=\"browse_prints.php?aid={$row
['artist_id']}\">{$row['artist']}</a></td>
<td align=\"left\"><a
href=\"view_print.php?pid={$row['print_id']}\">{$row['print_name']}</td>
<td align=\"left\">{$row['description']}</td>
<tdalign=\"right\">\${$row['price']}</td>
</tr>\n";
}
echo '</table>';
?>