 |
 |
 |
|
 |
 |
 |
|
 |
| |
 |
 |
 |
 |
 |
 |
|
 |
 |
SPAUSDINTUVAI |
 |
 |
 |
|
SKAIČIUOTUVAI
| Tipas: |
include("prisijungimas.php");
$cidd = mysql_connect($host,$usr,$pwd);
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $cid);
mysql_select_db($db);
echo " |
if($_GET[n] == "") { $_GET[n] = 1; }
$newsPerPage = 5;
$newsFrom = ($_GET[n] - 1) * $newsPerPage;
?>
$cid = mysql_connect($host,$usr,$pwd);
mysql_select_db($db);
if (mysql_error()) { print "Database ERROR: " . mysql_error(); }
if($id_model2!="")
{
$sql = "SELECT c.*, cm.* FROM e_calc as c, e_calc_model as cm
WHERE c.id_model=cm.id AND id_model='".$id_model2."' ORDER BY price ASC LIMIT $newsFrom, $newsPerPage";
$pagingSession = mysql_query("SELECT c.*, cm.* FROM e_calc as c, e_calc_model as cm
WHERE c.id_model=cm.id AND id_model='".$id_model2."' ORDER BY price ASC LIMIT $newsFrom, $newsPerPage") or die (mysql_error());
}else {
$sql = "SELECT c.*, cm.* FROM e_calc as c, e_calc_model as cm
WHERE c.id_model=cm.id ORDER BY price ASC LIMIT $newsFrom, $newsPerPage";
$pagingSession = mysql_query("SELECT c.*, cm.* FROM e_calc as c, e_calc_model as cm
WHERE c.id_model=cm.id ORDER BY price ASC") or die (mysql_error());
}
$rs = mysql_query($sql, $cid) or die(mysql_error());
if (mysql_error()) { print "Database Error: $sql " . mysql_error(); }
?>
|
Nuotrauka
|
Tipas
|
Aprašymas
|
Kaina
|
if(mysql_num_rows($rs) == "") { echo "Nieko nerasta. ";
} else {
?>
while ( $row = mysql_fetch_array($rs) )
{
$id_model = $row["model"];
$id_modelis = $row["id_model"];
$foto = $row["foto"];
$ff=str_replace(" ","%20",$foto);
$text = $row["text"];
$price = $row["price"];
?>
|
//foto spausdinu
if(!empty($ff)) {
echo " ";
}else echo "-";
?>
|
print "$id_model" ?> |
print "$text" ?> |
print "$price" ?> Lt. |
} //ciklo pabaiga
?>
Puslapiai
$totalNews = mysql_num_rows($pagingSession);
$number = "1";
while($next < $totalNews) {
$next = $number * $newsPerPage;
if($_GET[n] == $number) { echo "
$number, ";
} else {
echo "
$number, ";
}
$number++;
}
}
?>