Pytanko ... Opcje

[pagolik]

Yo ! Mam (chyba banalne) pytanie:
Mam skrypt w php na Sonde, jest oparta o baze mysql, instaluje, tworze pytanie i w dokumentacji pisze zeby wstawic w miejsce gdzie chce ta sonde taki kod:
[php:1:0776a5a4c2]
<?
include('poll/config.php');
poll_form();
?>

[/php:1:0776a5a4c2]

Wstawiam to i nie mam sondy w tym miejscu gdzie wstawilem te kod ...
Moze dlatego ze strone mam w HTML`u a skrypt jest w php i format rozszezenie pliku strony powinno byc php (index.php) ? Prosze o pomoc !

[patrycjusz]

.... dział wróżb i domysłów 8) otwarty tylko w dni powszednie dzisiaj jak zapewne zauważyłeś jest niedziela więc dorzuć choć trochę kodu :wink: ...
a co do problemu to się domyślam że serwer twój nie parsuje plików .html
pozdrawiam patS

[PMadej]

jesli plik ma rozszerzenie html to parser php go nawet nie rusza zmien na phtml albo php i zobacz co wtedy bedzie sie dzialo

[pagolik]

Jak zmieniam na php to cala stronka sie rozjezdza a i tak nie chodzi i na phtml to samo

[PMadej]

Jak zmieniam na php to cala stronka sie rozjezdza a i tak nie chodzi i na phtml to samo

to daj tu troche wiecej kodu ... moze cos znajdziemy (czy to jest temat na hydepark??)

[pagolik]

Skrypt jest w paru plikach. Ponizej macie kod kazdego z plikow ...
poll.php
[php:1:8e045a6c43]<?
include('poll/config.php');
if($cmd=='count') count_poll($pollID, $voteVALUE);
?>
<?



if($cmd=='old') {


echo 'Wyniki głosowania'.$poll_err;


echo '<br>';
poll_result();
echo '<br>';
old_poll();


} else {


echo 'Wyniki głosowania'.$poll_err;

echo '<br>';
poll_result();
echo '<br><br><div align="right"><a href="poll.php?cmd=old">stare sondy >></a></div><br>';



}


?>
[/php:1:8e045a6c43]
poll_adm.php
[php:1:8e045a6c43]<?

$nick_ = 'login'; // login
$pass_ = 'haslo'; // haslo

?>
<?
session_register("nick");
session_register("pass");

include('poll/config.php');
include("poll/01.adm.php");
include("poll/adm.php");

?>
<?

echo '<br>';


if(is_login()=='yes') {

switch($action) {


case poll_add:

if(!$step) poll_add_form();
if($step=='2') add_poll();
break;

case poll_del:

if(!$step) ready_del_poll();
if($step=='2') del_poll();
break;

case poll_edit:

if(!$step) poll_for_edit();
if($step=='2') poll_editform();
if($step=='3') update_poll();
break;


////////////////////

case logout:

session_unset();
login_form();

break;

default:

options();

break;

}

} elseif($action=='login') {

if(login_user()==5)
options();

} else {

login_form();

}

echo '<br><br>';

?>

[/php:1:8e045a6c43]
Folder poll plik 01.adm.php
[php:1:8e045a6c43]<?


function is_login() {

global $nick, $pass, $nick_, $pass_;


if($nick==$nick_ AND $pass==$pass_) {

return 'yes';

}


}



function login_user() {

global $a10, $b10, $login, $nick, $pass, $nick_, $pass_;


if($a10<>'' AND $b10<>'') {




if($nick_==$a10 AND $pass_==$b10) {


$nick = "$nick_";
$pass = "$pass_";



return 5;

} else {

login_form();
echo 'Podane dane sa błędne! Sprubuj ponownie';
echo mysql_error();

}


} else {
login_form();
echo 'Aby sie zalogować musisz podać nick i hasło.';

}
}


function login_form() {

global $a10, $PHP_SELF;

?>

<br>
<form name="logowanie" method="post" action="<? echo $PHP_SELF; ?>">
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="menu" align="right"> nick:</td>
<td class="menu">
<input type="text" name="a10" value="<? echo $a10; ?>">
</td>
</tr>
<tr>
<td class="menu" align="right">hasło: </td>
<td class="menu">
<input type="password" name="b10">
<input type="hidden" name="action" value="login">
</td>
</tr>
<tr>
<td class="menu">&nbsp;</td>
<td class="menu">
<input type="submit" name="ok" value="zaloguj">
</td>
</tr>
</table>
</form>
<br>

<?

}


function options() {

global $PHP_SELF;

echo '

::<b> <a href="'.$PHP_SELF.'?action=poll_add">dodaj ankiete</a></b><br>
::<b> <a href="'.$PHP_SELF.'?action=poll_edit">zarządzaj ankietami</a></b><br>
';

}

?>


[/php:1:8e045a6c43]
adm.php
[php:1:8e045a6c43]<?

function poll_add_form() {

global $PHP_SELF, $action;


echo '<form name="form_1" method="post" action="'.$PHP_SELF.'?action='.$action.'">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td align="right" valign="top" class="menu">pytanie</td>
<td class="next">
<input type="text" name="title" size="22">
</td>
</tr>';

$a = 0;
$b = 10;

while($a<>$ {
$a++;

echo '<tr>
<td align="right" valign="top" class="menu">odpowiedź '.$a.'</td>
<td class="next">
<input type="text" name="odp['.$a.']" size="22">
</td>
</tr>';

}

echo '<tr>
<td align="right" valign="top" class="menu">&nbsp;</td>
<td class="next">
<input type="reset" name="Reset" value="od nowa">
<input type="submit" name="ok" value="dalej&gt;&gt;&gt;">
<input type="hidden" name="step" value="2">
</td>
</tr>
<tr>
<td align="right" valign="top" class="menu">&nbsp;</td>
<td class="menu"><br><b><a href="'.$PHP_SELF.'">REZYGNUJ</a></b>
</td>
</tr>
</table>
</form>
';

}


function add_poll() {

global $title, $odp, $acc;
global $nick, $PHP_SELF, $a_tbl, $b_tbl;


$query = "INSERT INTO $a_tbl VALUES(NULL, '$title', now(), '$nick', 0)";
$result = mysql_query($query);

$vid = mysql_insert_id();

$a = 0;
$b = 10;

while($a<>$ {
$a++;

$title = $odp[$a];


$query = "INSERT INTO $b_tbl VALUES(NULL, '$title', '$vid', 0, '$a')";
$result = mysql_query($query);


}


echo "
<script langue="JavaScript" type="text/javascript">
<!--
window.location.href='$PHP_SELF'
//-->
</script>
";


}

////////////////////////////////////////////////////////////////


function ready_del_poll() {

global $PHP_SELF, $nick, $action, $id, $nick, $access, $a_tbl, $acc;


$query = "SELECT * FROM $a_tbl WHERE id=$id";
$result = mysql_query($query);

$r = mysql_fetch_array($result);

$title = $r['title'];
$data = $r['date'];

$title = stripslashes($title);


echo "Czy jestes pewien, że chcesz usunac ankiete "<b>$title</b> ($data)"?<br>";
echo "<h3><a href="$PHP_SELF?action=$action&step=2&id=$id">TAK</h3>";

echo "<br><br><a href="$PHP_SELF"><b>REZYGNUJ</b></a>";


}


function del_poll() {

global $PHP_SELF, $nick, $action, $id, $nick, $access, $a_tbl, $b_tbl, $acc;



$query = "DELETE FROM $a_tbl WHERE id='$id'";
$result = mysql_query($query);

$query = "DELETE FROM $b_tbl WHERE vid='$id'";
$result = mysql_query($query);

echo "
<script langue="JavaScript" type="text/javascript">
<!--
window.location.href='$PHP_SELF'
//-->
</script>
";


}

////////////////////////////////////////////////////////////////
//============================================================//


function poll_for_edit() {

global $PHP_SELF, $nick, $action, $id, $nick, $access, $color;
global $nick, $PHP_SELF, $a_tbl, $b_tbl, $acc;



$query = "SELECT * FROM $a_tbl ORDER BY id DESC";
$result = mysql_query($query);

echo '<table width="97%" align="center" border="0">
<tr>
<td bgcolor=black><font color="#ffffff"><b>pytanie</td>
<td bgcolor=black><font color="#ffffff"><b>głosów</td>
<td bgcolor=black><font color="#ffffff"><b>dodano</td>
<td bgcolor=black><font color="#ffffff"><b>uwagi</td>
<td bgcolor=black><font color="#ffffff"><b>akcje</td>
</tr>';

$p = 0;

while($r = mysql_fetch_array($result)) {

$id = $r['id'];
$title = $r['title'];
$votes = $r['votes'];
$author = $r['author'];
$date = $r['date'];

$title = stripslashes($title);

if($a==5) {
$bg = '#EEEEEE';
$a = 0;
} else {
$bg = '#FFFFFF';
$a = 5;
}

if($p==0) $uwagi = 'aktualna'; else $uwagi = '';
$p++;

$akcje = '[ <a href="'.$PHP_SELF.'?id='.$id.'&step=2&action=poll_edit">edytuj</a>
| <a href="'.$PHP_SELF.'?id='.$id.'&action=poll_del">usuń</a> ]';

echo '<tr>
<td bgcolor="'.$bg.'" class="menu">'.$title.'</td>
<td bgcolor="'.$bg.'" class="menu">'.$votes.'</td>
<td bgcolor="'.$bg.'" class="menu">'.$date.'</td>
<td bgcolor="'.$bg.'" class="menu">'.$uwagi.'</td>
<td bgcolor="'.$bg.'" class="menu">'.$akcje.'</td>
</tr>
';

}

echo "</table>
<br><br><a href="$PHP_SELF"><b>REZYGNUJ</b></a>";
}



function poll_editform() {

global $PHP_SELF, $a_tbl, $b_tbl, $id, $access, $nick, $action, $acc;


$query = "SELECT * FROM $a_tbl WHERE id=$id";
$result = mysql_query($query);
$r = mysql_fetch_array($result);

$title = $r['title'];
$title = stripslashes($title);



echo '<form name="form_1" method="post" action="'.$PHP_SELF.'?action='.$action.'">
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td align="right" valign="top" class="menu">pytanie</td>
<td class="next">
<input type="text" name="title" size="22" value="'.$title.'">
</td>
</tr>';

$a = 0;

$query = "SELECT * FROM $b_tbl WHERE vid=$id ORDER BY value";
$result = mysql_query($query);



while($r = mysql_fetch_array($result)) {
$a++;

$title = $r['title'];
$count = $r['count'];

echo '<tr>
<td align="right" valign="top" class="menu">odpowiedź '.$a.'</td>
<td class="menu">
<input type="text" name="odp['.$a.']" size="22" value="'.$title.'"> głosów: <b>'.$count.'</b>
</td>
</tr>';

}

echo '<tr>
<td align="right" valign="top" class="menu">&nbsp;</td>
<td class="next">
<input type="reset" name="Reset" value="od nowa">
<input type="submit" name="ok" value="dalej&gt;&gt;&gt;">
<input type="hidden" name="step" value="3">
<input type="hidden" name="id" value="'.$id.'">
</td>
</tr>
<tr>
<td align="right" valign="top" class="menu">&nbsp;</td>
<td class="menu"><br>
Notka: <i> nie usuwaj odpowiedzi, <br>na które już oddano głosy!!!</i>
<br><br><b><a href="'.$PHP_SELF.'">REZYGNUJ</a></b>
</td>
</tr>
</table>
</form>
';


}


function update_poll() {

global $PHP_SELF, $a_tbl, $b_tbl, $id, $odp, $title, $acc;


$query = "UPDATE $a_tbl SET title='$title' WHERE id='$id'";
$result = mysql_query($query);

echo mysql_error();
$a = 0;
$b = 10;

while($a<>$ {
$a++;

$title = $odp[$a];


$query = "UPDATE $b_tbl SET title='$title' WHERE vid='$id' AND value='$a'";
$result = mysql_query($query);

echo mysql_error();
}



echo "
<script langue="JavaScript" type="text/javascript">
<!--
window.location.href='$PHP_SELF'
//-->
</script>
";

}

?>

[/php:1:8e045a6c43]
config.php
[php:1:8e045a6c43]<?

#=======================================
# ustawienia polaczenia z baza danych
#=======================================
$db_host = 'localhost';
$db_user = 'user';
$db_pass = 'pass';
$db_name = 'name';
#=======================================


#=======================================
# nazwy tabel w bazie
#=======================================
$a_tbl = 'poll_desc';
$b_tbl = 'poll_data';
#=======================================



mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);

include('poll/inc.php');

?>
[/php:1:8e045a6c43]
inc.php
[php:1:8e045a6c43]<?

# === === === === === === === ===

# autor: Paweł Jaczewski #
# email: jaco@g3.pl #
# strona: http://phparea.xu.pl #

# === === === === === === === ===


function poll_form() {

global $a_tbl, $b_tbl;


$query = "SELECT * FROM $a_tbl ORDER BY id DESC";
$result = mysql_query($query);

$r = mysql_fetch_array($result);

$id = $r['id'];
$votes = $r['votes'];
$title = $r['title'];


// =======================================
// zmiana wygladu formularza
// =======================================

echo '<form method="post" name="vote" action="poll.php">';
echo '<table border="0" align="center" width="100%">';
echo '<tr>
<td colspan="2">: '.$title.'<br></td>
</tr>';

$qu_ = "SELECT * FROM $b_tbl WHERE vid='$id' ORDER BY id";
$re_ = mysql_query($qu_);

while($r_ = mysql_fetch_array($re_)) {

$value = $r_['value'];
$title = $r_['title'];

if($title<>'')

echo '<tr>
<td valign="top"><input type="radio" name="voteVALUE" value="'.$value.'"></td>
<td class="menu" width="90%">'.$title.'</td>
</tr>';


}

echo '
<tr>
<td colspan="2" class="menu">
<center><input type="submit" name="ok" value="głosuj!"><br>
[<a href="poll.php">wyniki</a> | <a href="poll.php?cmd=old">ankiety</a>]</td>
</tr>
</table>
<input type="hidden" name="cmd" value="count">
<input type="hidden" name="pollID" value="'.$id.'">
</form>';

}




function count_poll($id, $val) {

global $a_tbl, $b_tbl, $poll_cookie, $poll_err;

if($poll_cookie<>10) {
setcookie("poll_cookie", "10", time()+3600);
}

if($poll_cookie<>10) {

// ===========================================

$query = "SELECT * FROM $a_tbl WHERE id='$id'";
$result = mysql_query($query);
$r = mysql_fetch_array($result);


$votes = $r['votes'];
$votes++;

$query = "UPDATE $a_tbl SET votes='$votes' WHERE id='$id'";
$result = mysql_query($query);

// ============================================

$query = "SELECT * FROM $b_tbl WHERE vid='$id' AND value='$val'";
$result = mysql_query($query);
$r = mysql_fetch_array($result);

$count = $r['count'];
$count++;


$query = "UPDATE $b_tbl SET count='$count' WHERE vid='$id' AND value='$val'";
$result = mysql_query($query);

$poll_err = ' - <b>Dzięki za oddanie głosu!</b>';

} else {

$poll_err = ' - <b>Nie możesz 2 razy głosować!</b>';


}

}


function poll_result($id='no') {

global $a_tbl, $b_tbl, $theme;

if($id<>'no') {

$query = "SELECT * FROM $a_tbl WHERE id='$id'";

} else {

$query = "SELECT * FROM $a_tbl ORDER BY id DESC LIMIT 1";

}

$result = mysql_query($query);
$r = mysql_fetch_array($result);

$id = $r['id'];
$votes = $r['votes'];
$title = $r['title'];


echo '<table width="99%" border="0" align="center">
<tr>
<td class="menu" colspan="2"><center><b>'.$title.'</b><br><br></td>
</tr>';

$query = "SELECT * FROM $b_tbl WHERE vid='$id' ORDER BY value";
$result = mysql_query($query);

while($r = mysql_fetch_array($result)) {

$title = $r['title'];
$count = $r['count'];

if($title<>'') {

if($votes<>0) {
$a = $count / $votes;
$a = $a * 100;
$a = round($a);
$b = $a * 2;
} else {
$a = 0;
$b = 0;
}

echo '<tr>
<td class="menu" width="30%">- '.$title.'</td>
<td class="menu"><img src="poll/poll.gif" height="10" width="'.$b.'"> '.$a.'% ('.$count.')</td>
</tr>';


}

}

echo '<table width="90%" border="0" align="center">
<tr>
<td class="menu" colspan="2"><br><br><center>łącznie głosów oddano: <b>'.$votes.'</b></td>
</tr>';
echo '</table>';

}


function old_poll() {

global $a_tbl, $b_tbl, $theme;


$query = "SELECT * FROM $a_tbl ORDER BY id DESC";
$result = mysql_query($query);
$num = mysql_num_rows($result);

$s = 0;

if($num>1) {

echo '<hr size="1" noshade><center><b>Stare sondy</b></center><hr size="1" noshade><br>';

}

while($r = mysql_fetch_array($result)) {

$pollID = $r['id'];

if($s<>0) {
poll_result($pollID);
echo '<hr size="1" noshade><br>';
}

$s++;
}








}


?>


[/php:1:8e045a6c43]

To wszystko ... A wiec ?