<?php
switch($_GET['mode']){
case 'addfr':
if(!$_POST['addfr']){
?>
<form action="" method="post">
Добави приятел <input type="text" name="friend"><br />
<input type="submit" name="addfr" value="Добави"></form>
<?php
}
else{
$friend=htmlspecialchars($_POST['friend']);
if(!empty($friend)){
mysql_connect("localhost","root","3scap3r")or die(mysql_error());
mysql_select_db("test")or die(mysql_error());
mysql_query("INSERT INTO users (`id`,`friend`,`user`) VALUES ('NULL','$friend','Replace')")or die(mysql_error());
echo"Добавихте $friend в списъка с приятели <meta http-equiv='refresh' content='2; url=friend.php'>";
}
else{echo"Не сте избрали приятел";}
}
break;
default :
mysql_connect("localhost","root","3scap3r")or die(mysql_error());
mysql_select_db("test")or die(mysql_error());
$sql=mysql_query("SELECT * FROM users WHERE user='Replace'");
echo"<table border='1'><tr><td>Номер</td><td>Приятели</td></tr>";
$i='1';
while($row = mysql_fetch_array($sql)){
echo"<tr><td>$i</td><td>$row[friend]</td></tr>";
$i++;
}
$obshto=mysql_num_rows(mysql_query("SELECT id FROM users WHERE user='Replace'"));
echo"</table>Вие имате общо $obshto приятели";
break;
}
?>
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`friend` varchar(255) NOT NULL,
`user` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
id 1 friend 2 user k0kytak
<?php
switch($_GET['mode']){
case 'addfr':
if(!$_POST['addfr']){
?>
<form action="" method="post">
Добави приятел <input type="text" name="friend"><br />
<input type="submit" name="addfr" value="Добави"></form>
<?php
}
else{
$friend=htmlspecialchars($_POST['friend']);
if(!empty($friend)){
mysql_connect("localhost","root","Parolata")or die(mysql_error());
mysql_select_db("database")or die(mysql_error());
mysql_query("INSERT INTO frends (`id`,`friend`,`user`) VALUES ('NULL','$friend','Replace')")or die(mysql_error());
echo"Добавихте $friend в списъка с приятели <meta http-equiv='refresh' content='2; url=friend.php'>";
}
else{echo"Не сте избрали приятел";}
}
break;
default :
mysql_connect("localhost","root","Parolata")or die(mysql_error());
mysql_select_db("database")or die(mysql_error());
$sql=mysql_query("SELECT * FROM frends WHERE user='Replace'");
echo"<center><table border='5'><tr><td>Номер</td><td>Приятели</td></tr></center>";
$i='1';
while($row = mysql_fetch_array($sql)){
echo"<tr><td>$i</td><td>$row[friend]</td></tr>";
$i++;
}
$obshto=mysql_num_rows(mysql_query("SELECT id FROM frends WHERE user='Replace'"));
echo"</table><br>Вие имате общо $obshto приятели</br>";
break;
}
?>
camerb каза:Код:mysql_connect("localhost","root","Parolata")or die(mysql_error()); mysql_select_db("database")or die(mysql_error());
<?php
include ('conf.php');
$select = mysql_query("SELECT * FROM links ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$link = mysql_result($select, $i, "link");
echo '<meta http-equiv="Content-Type" content="text/html"; charset="windows-1251" />';
echo '<li><a href="' . $link . '" target="_blank">' . $name . '</a></li>';
}
mysql_close();
?>
<?php
if (isset($_POST["submit"])) {
include ('conf.php');
if (!empty($_POST["name"])) $name = htmlspecialchars($_POST["name"]);
else $errMsg = "<b>Не сте въвели име!</b><br />";
if (!empty($_POST["link"])) $link = htmlspecialchars($_POST["link"]);
else $errMsg = "<b>Не сте въвели линк!</b><br />";
if (empty($errMsg)) {
$insert = mysql_query("INSERT INTO links(name, link) VALUES('$name', '$link')")or die(mysql_error());
echo '<b>Успешно добавихте линк!</b>';
echo "<meta http-equiv=\"refresh\" content=\"1; url=../admin/admin_friends_links.php\">";
} else echo $errMsg;
mysql_close();
}
?>
<?php
include ('conf.php');
$back = $_SERVER['HTTP_REFERER'];
mysql_query('SET NAMES cp1251');
$id = $_GET['id'];
if(isset($id)){
$query1 = "delete from links where id=$id";
$result = mysql_query($query1);
}
$ok = mysql_query($query1);
if($ok){
echo "<meta http-equiv=\"refresh\" content=\"1; url=../admin/admin_friends_links.php\">Линка е изтрит успешно!";
}else{
echo "<b>Възникна грешка!</b>";
};
?>
<?php
include('conf.php');
$id = $_GET['id'];
if (!$_POST['links'])
{
$our = mysql_query("SELECT name, link FROM links where id='$id' ");
while($r=mysql_fetch_array($our)){
?>
<form method="POST">
<b>Име:</b> <input type="text" name="name" maxlength="30" class="textbox" value="<?PHP echo"$r[name]"; ?>"/><br />
<b>Линк:</b> <input type="text" value="<?PHP echo"$r[link]"; ?>" name="link" class="textbox"><br />
<input name="links" type="submit" value="Промени!" class="button">
</form>
<?
<?php
include ('conf.php');
$select = mysql_query("SELECT * FROM links ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$link = mysql_result($select, $i, "link");
$id = mysql_result($select, $i, "id");
echo '<a href="' . $link . '" target="_blank"><b><u>' . $name . '</u></b></a> - <a href="admin_friends_edit.php?id=' . $id . '">Промени</a> | <a href="admin_friends_del.php?id=' . $id . '">Изтрий</a><br />';
}
mysql_close();
?>
<?
$hostname = "Хост";
$user = " Потребител";
$pass = "Парола ";
$database = "Име на базата дани";
$conn = @mysql_connect("$hostname","$user","$pass");
$chars="SET CHARACTER SET UTF-8"; mysql_query($chars);
@mysql_select_db($database);
$pass_admin = "123";
?>
CREATE TABLE IF NOT EXISTS `links` (
`id` int(8) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`link` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;