Uroci.net - !
Adobe Photoshop Adobe Illustrator Adobe Flash Adobe Fireworks DreamWeaver CSS HTML Corel Draw Image Ready PHP
PHP
SEO CMS Microsoft Windows Microsoft Word Microsoft Excel PowerPoint Microsoft Access Microsoft Publisher Linux Visual basic JavaScript Ajax 3ds Max Maya 3D C++ Sound Forge Gimp SWiSH

PHP » PHP
HunteR   :    : 4805



. admin.php ( ). :

 

<?php
session_start();
include("config_poll.php");
$admin = $HTTP_SESSION_VARS['admin'];
if (isset($HTTP_SESSION_VARS['admin']) && $admin == 1) {
echo "<a href="?page=add"> </a><br><br>";
$page = $_GET['page'];
if ($page == "edit" && isset($_GET['id']) && is_numeric($_GET['id']))
{
$id = $_GET['id'];
$query_poll_exzit = mysql_query("SELECT * FROM poll WHERE id = '$id' LIMIT 1");
$dali_poll_exzit = mysql_num_rows($query_poll_exzit);
if ($dali_poll_exzit > 0) {
if (isset($_POST['submit'])) {
if ($_POST['vapros_edit'] != NULL && ($_POST['podrejdane_edit'] == 1 || $_POST['podrejdane_edit'] == 2) && ($_POST['off_poll'] == 0 || $_POST['off_poll'] == 1)) {
mysql_query("UPDATE poll SET vapros = '".$_POST['vapros_edit']."',podrejdane = '".$_POST['podrejdane_edit']."',status = '".$_POST['off_poll']."' WHERE id = '$id' LIMIT 1");

$query_otgovorite = mysql_query("SELECT * FROM otgovori WHERE id_poll = '$id' ORDER BY id ASC");
while ($otgovorite = mysql_fetch_array($query_otgovorite)) {
$idtoo = $otgovorite['id'];
mysql_query("UPDATE otgovori SET otgovor = '".$_POST["otgovor_$idtoo"]."' WHERE id = '".$otgovorite['id']."'");
}
echo "<META HTTP-EQUIV="refresh" CONTENT="3;URL=?" >";
echo "<b> !</b>";
}
} else {
$poll_exzit = mysql_fetch_array($query_poll_exzit);
$query_otgovorite = mysql_query("SELECT * FROM otgovori WHERE id_poll = '$id' ORDER BY id ASC");
?>
<form action="" method="post">
: <input type="text" name="vapros_edit" value="<?=$poll_exzit['vapros']?>" size="50"><br><br>
<?php
$nomer = 1;
while ($otgovorite = mysql_fetch_array($query_otgovorite)) {
?>
<?=$nomer?>: <input type="text" name="otgovor_<?=$otgovorite['id']?>" value="<?=$otgovorite['otgovor']?>" size="50"><br>
<?php
$nomer++;
}
?><br>
: <select name="podrejdane_edit">
<option value="1"<?php if ($poll_exzit['podrejdane'] == 1) { echo " selected="selected""; } ?>></option>
<option value="2"<?php if ($poll_exzit['podrejdane'] == 2) { echo " selected="selected""; } ?>> </option>
</select><br>
: <select name="off_poll">
<option value="1"<?php if ($poll_exzit['status'] == 1) { echo " selected="selected""; } ?>></option>
<option value="0"<?php if ($poll_exzit['status'] == 0) { echo " selected="selected""; } ?>></option>
</select><br>
<input type="submit" name="submit" value="">
</form>
<?php
}
} else {
echo " !";
}
?>
<?php
}
elseif ($page == "add")
{
if (isset($_POST['submit'])) {
$kolko_otgovora = 0;
for ($i=1;$i<=15;$i++) {
$otgovor4e = trim($_POST["otgovor_$i"]);
if ($otgovor4e != NULL) {
$otgovorite[] = $otgovor4e;
$kolko_otgovora++;
}
}

if ($kolko_otgovora >= 2 && $_POST['vapros'] != NULL && ($_POST['podrejdane'] == 1 || $_POST['podrejdane'] == 2)) {
$kolko_otgovori = count($otgovorite);
mysql_query("INSERT INTO poll (vapros,podrejdane) VALUES ('".$_POST['vapros']."','".$_POST['podrejdane']."')");

$posleden_id = mysql_fetch_array(mysql_query("SELECT * FROM poll ORDER BY id DESC LIMIT 1"));
$posleden_id = $posleden_id['id'];
for ($no=0;$no<$kolko_otgovori;$no++) {
if ($otgovorite[$no] != NULL) {
mysql_query("INSERT INTO otgovori (id_poll,otgovor) VALUES ('$posleden_id','$otgovorite[$no]')");
}
}
echo "<b> !</b>";
echo "<META HTTP-EQUIV="refresh" CONTENT="3;URL=?" >";
} else { echo " - 2 !"; }

} else {
?>
<form action="" method="post">
: <input type="text" name="vapros" size="50"><br><br>
<?php
for ($i=1;$i<=15;$i++) {
?>
<?=$i?>: <input type="text" name="otgovor_<?=$i?>" size="50"><br>
<?php
}
?>
<br>
: <select name="podrejdane">
<option value="1"></option>
<option value="2"> </option>
</select><br>
<input type="submit" name="submit" value="">
</form>
<?php
}
}
elseif ($page == "dell" && isset($_GET['id']) && is_numeric($_GET['id']))
{
$id = $_GET['id'];
mysql_query("DELETE FROM poll WHERE id = '$id'");
mysql_query("DELETE FROM otgovori WHERE id_poll = '$id'");
mysql_query("DELETE FROM ips WHERE id = '$id'");
echo " !";
echo "<META HTTP-EQUIV="refresh" CONTENT="3;URL=?" >";
}
else
{
$query_polls = mysql_query("SELECT * FROM poll ORDER BY id DESC");
?>
<table border="1">
<tr><td><b>ID:</b></td><td><b></b></td><td><b></b></td></tr>
<?php
while ($polls = mysql_fetch_array($query_polls)) {
?>
<tr><td><?=$polls['id']?></td><td><?=$polls['vapros']?></td><td>[<a href="?page=edit&id=<?=$polls['id']?>"></a>] [<a href="?page=dell&id=<?=$polls['id']?>"></a>]</td></tr>
<?php
}
?>
</table>
<?php
}
if ($page == "logout") { $HTTP_SESSION_VARS['admin'] = 0; echo "<META HTTP-EQUIV="refresh" CONTENT="1;URL=?" >"; }
echo "<br><br><a href="?page=logout"></a>";
} else {
if (isset($_POST['submit']) && $_POST['pass_admin'] == $pass_admin) {
$HTTP_SESSION_VARS['admin'] = 1;
echo "<META HTTP-EQUIV="refresh" CONTENT="1;URL=?" >";
} else {
?>
<form action="" method="post">
: <input type="password" name="pass_admin" size="10">
<input type="submit" name="submit" value="">
</form>
<?php
}
}
?>


. . , :


index.php. - :


<?php include("function_poll.php"); ?>


.


-. :

 

<?php @poll(); ?>

 

. :

 

<?php @poll(1); ?>

 

1. ? ID . admin , ID- - ID .

 

. .

 

!

 


: «1 2

(11)

HunteR 19.06 2008 14:57.
.
:
http://tapotiichici.hit.bg/bar_left.bmp
http://tapotiichici.hit.bg/bar_right.bmp
http://tapotiichici.hit.bg/vote.bmp

3- , !
HunteR 21.06 2008 12:31.
:
ips:
CREATE TABLE `ips` (
`id` int(10) NOT NULL,
`ip` varchar(25) COLLATE utf8_general_ci NOT NULL default '',
PRIMARY KEY (`id`)
);


:
CREATE TABLE `ips` (
`id` int(10) NOT NULL,
`ip` varchar(25) COLLATE utf8_general_ci NOT NULL default ''
);
HunteR 14.07 2008 11:45.
- : http://tapotiichici.hit.bg/Polls.rar
PsycXo 14.07 2008 17:39.
- BD? index.php, " BD!" ?
GainWard 17.07 2008 07:30.
trqbva da e DB = Datebase ;)
justifyyy 17.07 2008 11:27.
BD -. " " . DB Database, Datebase :D
embata 23.07 2008 14:48.
5 5 checkbox ?
gamer345 07.09 2008 11:16.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/csfrags.freehostia.com/admin.php on line 131 ? config_poll-a ?????
gamer345 07.09 2008 11:18.
:
! ( Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/csfrags.freehostia.com/admin.php on line 131 )
alore 08.09 2008 15:17.
, index.php admin.php " ." ?
HunteR 10.09 2008 13:16.
@gamer345 .
: http://hunter.bg2.info/test/poll/

@alore .
config_poll.php

,


© . 2006-2008. Created by: Site.bg
: IT | | . | Paparak.bg | | uchenik.com | TRAVEL | | AmAm.bg | . | | AnimeS-bg.com | | | | IT Light | Spodeli.net | - | IDG.BG | Teenproblem.net | - | Fresh-BG.com | Hanovete.com | Bulfleet.com | Mythlands.com | Ohoboho.com | .Com | News24 | Setcom.bg | Atol.bg | Elmaz.com | MobileBulgaria.com