forked from vrexperts/jwasser
/
like.php
31 lines (29 loc) · 1 KB
/
like.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
require_once("includes/application-top.php");
$dbObj = new DB();
$dbObj->fun_db_connect();
?>
<?php
$sql_like = "SELECT * FROM ".TABLE_LIKE." where post_id=".$_REQUEST['post_id']." and user_id=".$_REQUEST['user_id'];
$rsResult_like = $dbObj->fun_db_query($sql_like);
$like = $dbObj->fun_db_get_num_rows($rsResult_like);
if($like=='')
{
$arr['post_id']= $_REQUEST['post_id'];
$arr['user_id']=$_REQUEST['user_id'];
$lastID = $dbObj->insert_data(TABLE_LIKE,$arr);
$sql_like1 = "SELECT * FROM ".TABLE_LIKE." where post_id=".$_REQUEST['post_id'];
$rsResult_like1 = $dbObj->fun_db_query($sql_like1);
$like1 = $dbObj->fun_db_get_num_rows($rsResult_like1);
$arr['total_like']=$like1;
$lastID = $dbObj->update_data(TABLE_POST,'id',$arr,md5($_REQUEST['post_id']));
echo $like1;
}
else
{
$sql_like1 = "SELECT * FROM ".TABLE_LIKE." where post_id=".$_REQUEST['post_id'];
$rsResult_like1 = $dbObj->fun_db_query($sql_like1);
$like1 = $dbObj->fun_db_get_num_rows($rsResult_like1);
echo $like1;
}
?>