Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
AceXe каза:Аз нещо не схващам ква е тая система. Искаш да има форма за пускане на линкове и гласуване за тях ли ?
CREATE TABLE IF NOT EXISTS `links` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`link` varchar(60) NOT NULL,
`author` varchar(60) NOT NULL,
`added` varchar(60) NOT NULL,
`pluses` varchar(60) NOT NULL,
PRIMARY KEY (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
<?php
include("config.php");
if(!$_POST['post']) {
echo '<form action="addlink.php" enctype="multipart/form-data" method="post">
Име на линка <input type="text" size="38" name="name"><br>
Линк <input type="text" size="38" name="link"><br>
Автор <input type="text" size="38" name="author"><br>
<input type="submit" name="post" value="Добави"></form>'
$time = time();
$query = "INSERT INTO links VALUES('', '$_POST[name]', '$_POST[link]', '$_POST[author', '$time')"
if(mysql_query($query)) { echo 'Линка е качен успешно'; } else { echo 'Грешка.'; } ?>
<?php
include("config.php");
$query = mysql_query("SELECT * FROM links ORDER BY id DESC");
while($links = mysql_fetch_array($query)) {
$links[id] = $lid;
$links[name] = $lname;
$links[link] = $llink;
$links[author] = $lauthor;
date("d.m.Y", $links[added]) = $ladded;
echo "<table>
<tr><td>Линк</td><td>Качен от</td><td>Качен на</td><td>Гласувай</td></tr>
<tr><td><a href='$llink'>$lname</a></td><td>$lauthor</td><td>$ladded</td><td><a href='give_plus.php?id=$lid'<span style='color: green;'>препоръчай</span></td></tr>"; } ?>
<?php
include("config.php");
$some = mysql_query("SELECT * FROM links WHERE id = '".$_GET['id']."'");
$link = mysql_fetch_array($some);
$plus = $link[plus] +1;
mysql_query("UPDATE links SET pluses = '$plus' WHERE id = '$_GET[id]'");
if(mysql_query($query)) { echo "Вие успешно препоръчахте линка.";
} else { echo "Грешка."; } ?>
<?php
$link = mysql_connect('localhost', 'user', 'pass');
$db_selected = mysql_select_db('db_name', $link) or die(mysql_error());
?>