$host = "localhost";
$db_user = "";
//用户名
$db_pass = "";
//密码
$db_name = "";
//数据库名
$link = mysql_connect($host, $db_user, $db_pass);
mysql_select_db($db_name, $link);
mysql_query("SET names UTF8");
header("Content-Type: application/json; charset=utf-8");
$action = $_GET['action'];
$id = 1;
$ip = get_client_ip();
if ($action == 'add') {
likes($id, $ip);
} else {
if ($action == 'get') {
echo jsons($id);
} else {
exit;
}
}
function likes($id, $ip)
{
$ip_sql = mysql_query("select ip from votes_ip where vid='{$id}' and ip='{$ip}'");
$count = mysql_num_rows($ip_sql);
if ($count == 0) {
//还没有顶过
$sql = "update votes set likes=likes+1 where id=" . $id;
mysql_query($sql);
<?php
$conn = mysql_connect("localhost", "root", "");
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
mysql_query("set names utf8");
mysql_query("set global time_zone= '+08:00'");
mysql_select_db("xikingwenhua", $conn);
$id = $_GET['id'];
$ip = get_client_ip();
//获取ip
likes(1, $id, $ip);
function likes($type, $id, $ip)
{
$ip_sql = mysql_query("select ip from votes_ip where vid='{$id}' and ip='{$ip}'");
$count = mysql_num_rows($ip_sql);
if ($count == 0) {
//还没有顶过
if ($type == 1) {
//顶
$sql = "update competition set vote = vote+1 where id=" . $id;
}
mysql_query($sql);
$sql_in = "insert into votes_ip (vid,ip) values ('{$id}','{$ip}')";
mysql_query($sql_in);
if (mysql_insert_id() > 0) {
echo jsons($id);
} else {
$arr['success'] = 0;
$arr['msg'] = '操作失败，请重试';
//用户名
$db_pass = "";
//密码
$db_name = "";
//数据库名
header("Content-Type: application/json; charset=utf-8");
$action = $_GET['action'];
$id = 1;
$ip = get_client_ip();
$link = mysqli_connect($host, $db_user, $db_pass, $db_name);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
if ($action == 'add') {
likes($id, $ip, $link);
} else {
if ($action == 'get') {
echo jsons($id, $link);
} else {
exit;
}
}
function likes($id, $ip, $link)
{
$ip_sql = mysqli_query($link, "select ip from votes_ip where vid='{$id}' and ip='{$ip}'");
$count = mysqli_num_rows($ip_sql);
if ($count == 0) {
//还没有顶过
$sql = "update votes set likes=likes+1 where id=" . $id;
mysqli_query($link, $sql);
//Affichage du contenu
echo '<p class="article">' . $ligne[contene] . '</p><p class="rigth"> date : ' . $ligne[date] . '</p>';
if (check_ip($ligne['id'], get_real_ip()) == 0) {
?>
<a href="javascript:void();" class="like" id="<?php
echo $ligne['id'];
?>
">Like <span><?php
echo likes($ligne['id']);
?>
</span></a>
<?php
} else {
?>
<a href="javascript:void();" class="liked">Liked <span><?php
echo likes($ligne['id']);
?>
</span></a>
<?php
}
?>
<?php
echo $ligne['item'];
//Si l'utilisateur est connecter le bouton "Editer et Supprimer" s'affiche
session_start();
if (isset($_SESSION['session'])) {
echo '<a href="editerArticle.php?idArticle=' . $ligne[id] . '"><input type="button" class="btn btn-success" value="Editer"></a>';
echo '<a href="assets/deleteArticle.php?idArticle=' . $ligne[id] . '"><input type="button" class="btn btn-success" id="btnSuppr" value="Supprimer "></a></br>';
}
}
?>
<!-- like button-->
<?php
if (check_ip($idArray[$i], get_real_ip()) == 0) {
?>
<a href="javascript:void();" class="like" id="<?php
echo $idArray[$i];
?>
">Like <span><?php
echo likes($idArray[$i]);
?>
</span></a>
<?php
} else {
?>
<a href="javascript:void();" class="liked">Liked <span><?php
echo likes($idArray[$i]);
?>
</span></a>
<?php
}
?>
<!-- like button -->
<!-- collect button-->
<input type="button" value="Collect" class="btn btn-collect" id="btn-collect">
<!-- collect-->
