File manager - Edit - /home/autoph/public_html/api/aha/update_reels.php
Back
<?php include '../../../cfg/ahaconn.php'; $mykey = $_GET['keyID']; if($mykey =="6e59e008b5348b452b615a3033729daae383-myREELS"){ $userID = $_GET['userID']; $reelsID = $_GET['reelsID']; $chkL = "SELECT * FROM `aha_reel_likes` WHERE `aha_user_id`='$userID' AND `reel_id`='$reelsID'"; $qChk = mysqli_query($conn,$chkL); $qCount =0; while($qCnt = mysqli_fetch_array($qChk)){ $qCount = $qCount + 1; } if($qCount > 0){ echo "Like Exists :".$reelsID; }else{ echo "Like Not Exists :".$reelsID; $sql = "UPDATE `aha_slider_content` SET `likes`= (`likes` + 1) WHERE `id`='$reelsID'"; if ($conn->query($sql) === TRUE) { $qReel ="SELECT `likes` FROM aha_slider_content WHERE id='$reelsID'"; $queR = mysqli_query($conn,$qReel); while($cnt = mysqli_fetch_array($queR)){ $totalLikes=$cnt['likes']; } $adL = "INSERT INTO aha_reel_likes(`aha_user_id`,`reel_id`,`date`,`time`) VALUES('$userID','$reelsID','$curDate','$curTime')"; if ($conn->query($adL) === TRUE) { } echo json_encode(["likesCount" => "$totalLikes"]); } } } $conn->close(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings