#1 · Zasláno:
8. 10. 2006, 15:31:51 · Upravil/a: viliam22
Potreboval by som jeden skript prerobit na sql ale najde mi to urcite som spravil niekde chybu prosim poradte mi skript sa sklada z 3 suborov:
1. index.php - vypis poctu hlasov
<?php
include ("conect.php"); // pripojenie na MySql
$vypis = mysql_query("SELECT * FROM `galeria`");
$riadok = mysql_fetch_array($vypis);
?>
<title>Galeria s hlasovanim</title>
<center><h1>Galeria s hlasovanim</h1></center>
<table width="321" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td> <a href="zapis.php?hlasuj=1" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/01.gif" alt="" style="border:1px solid #00E0FF";></a></td>
<td> <a href="zapis.php?hlasuj=2" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/02.gif" alt="" style="border:1px solid #00E0FF";></a></td>
</tr>
<tr>
<td>Pocet hlasov: <? echo $riadok['1']; ?></td>
<td>Pocet hlasov: <? echo $riadok['2']; ?></td>
</tr>
<tr>
<td><a href="zapis.php?hlasuj=3" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/03.gif" alt="" style="border:1px solid #00E0FF";></a></td>
<td><a href="zapis.php?hlasuj=4" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/04.gif" alt="" style="border:1px solid #00E0FF";></a></td>
</tr>
<tr>
<td>Pocet hlasov: <? echo $riadok['3'] ?></td>
<td>Pocet hlasov: <? echo $riadok['4'] ?></td>
</tr>
<tr>
<td><a href="zapis.php?hlasuj=5" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/05.gif" alt="" style="border:1px solid #00E0FF";></a></td>
<td><a href="zapis.php?hlasuj=6" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/06.gif" alt="" style="border:1px solid #00E0FF";></a></td>
</tr>
<tr>
<td>Pocet hlasov: <? echo $riadok['5'] ?></td>
<td>Pocet hlasov: <? echo $riadok['6'] ?></td>
</tr>
<tr>
<td><a href="zapis.php?hlasuj=7" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/07.gif" alt="" style="border:1px solid #00E0FF";></a></td>
<td><a href="zapis.php?hlasuj=8" target="moje-okno" onclick="this.target = '';return !open(this.href, this.target, 'width=225,height=20')"><img src="img/08.gif" alt="" style="border:1px solid #00E0FF";></a></td>
</tr>
<tr>
<td>Pocet hlasov: <? echo $riadok['7'] ?></td>
<td>Pocet hlasov: <? echo $riadok['8'] ?></td>
</tr>
</table>
<br><center><i>hlasovat mozete kliknutim na obrazok</i></center>
2. zapis.php - ten je este tak spraveny ze zapisuje do suboru ale ja by som potreboval vediet ako to mam spravit tak aby zapisoval do databazy a to tak ze si vitiahne subor z daneho riadku a zvisiho o jednu a zapise a samozrejme s overovanim cookies a zabezpecenim
<?php
$id = $_GET['hlasuj'];
if ($_GET['hlasuj'] == "1" || $_GET['hlasuj'] == "2" || $_GET['hlasuj'] == "3" || $_GET['hlasuj'] == "4" || $_GET['hlasuj'] == "5" || $_GET['hlasuj'] == "6" || $_GET['hlasuj'] == "7" || $_GET['hlasuj'] == "8") {
if(empty($_COOKIE["galeria"])) {
$filename = "data/$id.txt";
$handle = fopen ($filename, "r");
$contents = fread ($handle, filesize ($filename));
fclose ($handle);
$contents++;
$handle = fopen ($filename, "w");
fputs($handle, $contents);
fclose ($handle);
setcookie("galeria","ano", time() + 60); // cas cookies
echo "Dakujeme za hlas";
}
else {
echo "Uz ste hlasovaly";
}
echo "<br><br><input type=\"button\" value=\"Zavriet okno\" onclick=\"window.close();\" style=\"background:#00E0FF\">";
}
else {
echo "ERROR";
}
?>
<title>Galeria s hlasovanim</title>
3. conect.php - pripojenie do databazy
<?php
mysql_pconnect("localhost", "meno", "heslo");
mysql_select_db("databaza");
?>
a tu je SQL vytvorenie tabuliek
CREATE TABLE `galeria` (
`1` varchar(10) NOT NULL default '',
`2` varchar(10) NOT NULL default '',
`3` varchar(10) NOT NULL default '',
`4` varchar(10) NOT NULL default '',
`5` varchar(10) NOT NULL default '',
`6` varchar(10) NOT NULL default '',
`7` varchar(10) NOT NULL default '',
`8` varchar(10) NOT NULL default ''
) TYPE=MyISAM;
uz pri tom vypise mi to robilo problemi vypisovalo mi to veci ktore som vobec namal v databazy
DIKY VSETKYM ZA POMOC