- Автор темы
- #1
Собственно нужна помощь при преобразования из мускула в файлы
вот собственно код index.php
<?php
session_start();
function getrate($id)
{
$result = mysql_query("select sum(rate) as sm, count(*) as cnt from rating where id='$id'");
$row = mysql_fetch_object($result);
if($row && $row->cnt != 0) $rate = (float)($row->sm/$row->cnt);
else $rate = 0;
return $rate;
}
function showrating($id,$disabled=false)
{
echo "<div id=\"rating_$id\">";
$rate = isset($_SESSION["rate_$id"]) ? $_SESSION["rate_$id"] : 0;
$result = mysql_query("select * from rating where id='$id' and ip='".$_SERVER["REMOTE_ADDR"]."'");
$row = mysql_fetch_object($result);
/*if($row) $rate = $row->rate;
else $rate = 0; */
$have_rated = $row ? true : false;
$result = mysql_query("select sum(rate) as sm, count(*) as cnt from rating where id='$id'");
$row = mysql_fetch_object($result);
if($row && $row->cnt != 0) $rate = (float)($row->sm/$row->cnt);
else $rate = 0;//echo $rate;
for($i = 1; $i <= 5;$i++)
{
if($i <= $rate)
$star_img = "rating_on.gif";
else
$star_img = "rating_off.gif";
if($rate != ceil($rate) && $i == ceil($rate)) $star_img = "rating_half.gif";
if($disabled || $have_rated)
{
?>
<img src="stars/<?php echo $star_img?>" border="0" id="star_<?php echo $id?>_<?php echo $i?>" title="<?php echo $row->cnt ?> votes, <?php echo round($rate,2)?>/5" style="border: 0px; padding: 0px; margin: 0px;" />
<?php
}
else
{
?>
<a href="index.php?act=rate&rateid=<?php echo $id?>&rate=<?php echo $i?>" onclick="rate(<?php echo $id?>,<?php echo $i?>);return false;" ><img src="stars/<?php echo $star_img?>" border="0" id="star_<?php echo $id?>_<?php echo $i?>" onmouseover="highlight(<?php echo $id?>,<?php echo $i?>,true);" onmouseout="highlight(<?php echo $id?>,<?php echo $i?>,false);" title="<?php echo $i?>/5" style="border: 0px; padding: 0px; margin: 0px;" /></a>
<?php
}
}
echo "</div>";
}
extract($_GET);
extract($_POST);
if(isset($_GET["act"]) && $act =="rate")
{
echo "You rating is: $rate<br />\n";
$_SESSION["rate_$rateid"] = $rate;
mysql_query("insert into rating set id='$rateid',rate='$rate',ip='".$_SERVER["REMOTE_ADDR"]."'") or die(mysql_error());
showrating($rateid,true);
exit;
}
?>
<html>
<head>
<title></title>
<script src="ajax.js"></script>
<script src="main.js"></script>
</head>
<body>
<?php
echo "Рейтинг 1";
showrating(1);
echo "Рейтинг 2";
showrating(2);
echo "Рейтинг 3";
showrating(3);
?>
</body>
</html>
А вот база sql
CREATE TABLE IF NOT EXISTS `rating` (
`id` bigint(20) NOT NULL,
`rate` int(11) NOT NULL,
`ip` varchar(16) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
как можно преобразовать в файлы?
вот собственно код index.php
<?php
session_start();
function getrate($id)
{
$result = mysql_query("select sum(rate) as sm, count(*) as cnt from rating where id='$id'");
$row = mysql_fetch_object($result);
if($row && $row->cnt != 0) $rate = (float)($row->sm/$row->cnt);
else $rate = 0;
return $rate;
}
function showrating($id,$disabled=false)
{
echo "<div id=\"rating_$id\">";
$rate = isset($_SESSION["rate_$id"]) ? $_SESSION["rate_$id"] : 0;
$result = mysql_query("select * from rating where id='$id' and ip='".$_SERVER["REMOTE_ADDR"]."'");
$row = mysql_fetch_object($result);
/*if($row) $rate = $row->rate;
else $rate = 0; */
$have_rated = $row ? true : false;
$result = mysql_query("select sum(rate) as sm, count(*) as cnt from rating where id='$id'");
$row = mysql_fetch_object($result);
if($row && $row->cnt != 0) $rate = (float)($row->sm/$row->cnt);
else $rate = 0;//echo $rate;
for($i = 1; $i <= 5;$i++)
{
if($i <= $rate)
$star_img = "rating_on.gif";
else
$star_img = "rating_off.gif";
if($rate != ceil($rate) && $i == ceil($rate)) $star_img = "rating_half.gif";
if($disabled || $have_rated)
{
?>
<img src="stars/<?php echo $star_img?>" border="0" id="star_<?php echo $id?>_<?php echo $i?>" title="<?php echo $row->cnt ?> votes, <?php echo round($rate,2)?>/5" style="border: 0px; padding: 0px; margin: 0px;" />
<?php
}
else
{
?>
<a href="index.php?act=rate&rateid=<?php echo $id?>&rate=<?php echo $i?>" onclick="rate(<?php echo $id?>,<?php echo $i?>);return false;" ><img src="stars/<?php echo $star_img?>" border="0" id="star_<?php echo $id?>_<?php echo $i?>" onmouseover="highlight(<?php echo $id?>,<?php echo $i?>,true);" onmouseout="highlight(<?php echo $id?>,<?php echo $i?>,false);" title="<?php echo $i?>/5" style="border: 0px; padding: 0px; margin: 0px;" /></a>
<?php
}
}
echo "</div>";
}
extract($_GET);
extract($_POST);
if(isset($_GET["act"]) && $act =="rate")
{
echo "You rating is: $rate<br />\n";
$_SESSION["rate_$rateid"] = $rate;
mysql_query("insert into rating set id='$rateid',rate='$rate',ip='".$_SERVER["REMOTE_ADDR"]."'") or die(mysql_error());
showrating($rateid,true);
exit;
}
?>
<html>
<head>
<title></title>
<script src="ajax.js"></script>
<script src="main.js"></script>
</head>
<body>
<?php
echo "Рейтинг 1";
showrating(1);
echo "Рейтинг 2";
showrating(2);
echo "Рейтинг 3";
showrating(3);
?>
</body>
</html>
А вот база sql
CREATE TABLE IF NOT EXISTS `rating` (
`id` bigint(20) NOT NULL,
`rate` int(11) NOT NULL,
`ip` varchar(16) collate latin1_general_ci NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
как можно преобразовать в файлы?
