mamali-mohammad
دوشنبه 08 فروردین 1390, 17:16 عصر
این از نحوه نمایش :
<?php
error_reporting(E_ALL ^ E_NOTICE);
include "storescript/connect_to_mysql.php";
$dynamicList="";
$sql=mysql_query("SELECT * FROM products ORDER BY id DESC LIMIT 6");
$productCount=mysql_num_rows($sql);
if ($productCount > 0){
while ($row=mysql_fetch_array($sql)){
$id=$row["id"];
$category=$row["category"];
$price=$row["price"];
$product_name=$row["product_name"];
$date_added=strftime("%b,%d,%Y",strtotime($row["date_added"]));
$dynamicList .='<table width="500" border="1">
<tr>
<td width="126"><a href="product.php?id='. $id .'"><img src="inventory_images/'. $id .'.jpg" alt='. $product_name .' width="100%" height="100%" border="1" /></a></td>
<td width="300"><p>'. $product_name .'</p>
<p>$ '. $price .'</p>
<p><a href="product.php?id='. $id .'">view</a></p></td>
</tr>
</table>';
}
} else {
$dynamicList ="Not Product In Home";
}
mysql_close();
?>
که با کد زیر در htm نشون میده :
<?php echo $dynamicList; ?>
من کد شمارو با این تغییر در index.php گذاشتم :
<?php
if( isset( $_GET['page'] ) ) {
switch( $_GET['page'] ) {
case 1:
$data = mysql_query("SELECT '$product_name','$price','$details','$category','$ subcategory' FROM 'products' ORDER BY id DESC LIMIT 6,12");
echo( '<div id="content">' );
while( $show = mysql_fetch_array( $data ) ) {
echo( $show['product_name'] . " - <a href=\"index.php?id={$show['id']}\" target=\"_blank\">" . $show['price'] . "</a>" );
}
echo( '</div>' );
break;
}
}
if( isset( $_GET['id'] ) ){
$query = mysql_query( "SELECT `category` FROM `category` WHERE `id` = '" . $_GET['id'] . "'" );
echo( '<div id="content">' );
while( $show2 = mysql_fetch_array( $query ) ) {
echo( $show2['product_name'] );
}
echo( '</div>' );
}
elseif( !isset( $_GET['page'] ) && !isset( $_GET['id'] ) ){
$data = mysql_query( "SELECT `product_name`, `id`, `category` FROM `content` LIMIT 6" );
echo( '<div id="content">' );
while( $show = mysql_fetch_array( $data ) ) {
echo( $show['artist'] . " - <a href=\"index.php?id={$show['id']}\" target=\"_blank\">" . $show['song'] . "</a>" );
}
echo( '</div>' );
}
echo( '<a href="index.php?page=1" target="_blank">1</a>' );
?>
این ارور میده :
Warning: mysql_query() [function.mysql-query (http://127.0.0.1/store/function.mysql-query)]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306) in C:\Program Files\EasyPHP-5.3.3\www\store\index.php on line 53
Warning: mysql_query() [function.mysql-query (http://127.0.0.1/store/function.mysql-query)]: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\Program Files\EasyPHP-5.3.3\www\store\index.php on line 53
Warning: mysql_query() [function.mysql-query (http://127.0.0.1/store/function.mysql-query)]: A link to the server could not be established in C:\Program Files\EasyPHP-5.3.3\www\store\index.php on line 53
Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files\EasyPHP-5.3.3\www\store\index.php on line 53