File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/getLastGmpNoti.php
Back
<?php if(isset($_GET['type'])) { $type = $_GET['type']; require_once('Connection.php'); $sql = "SELECT `id` AS 'ID',`c_name` AS 'NAME',`emoji` AS 'EMOJI' FROM `ipo_post` WHERE `status` = 'PRESENT' && `TYPE` = '$type'"; $rows = $con->query($sql); while($row = $rows->fetch_assoc()) { $last = "select `gmp` AS 'GMP' from `gmp_data` WHERE `ipo_id` = '" . $row['ID'] . "' ORDER BY id DESC LIMIT 1;"; $lastRows = $con->query($last); $lastData = $lastRows->fetch_assoc(); $lastGMP = $lastData["GMP"]; $Secondlast = "SELECT `gmp` AS 'GMP' FROM (SELECT * FROM `gmp_data` WHERE `gmp_data`.`ipo_id` = '" . $row['ID'] . "' ORDER BY Id DESC LIMIT 2 ) `gmp_data` ORDER BY Id LIMIT 1;"; $SecondlastRows = $con->query($Secondlast); $SecondlastData = $SecondlastRows->fetch_assoc(); $SecondlastGMP = $SecondlastData["GMP"]; if($lastGMP > $SecondlastGMP) echo "👉🏻 " . $row["NAME"] . " " . $row["EMOJI"] . " [+]\n"; else if ($lastGMP < $SecondlastGMP) echo "👉🏻 " . $row["NAME"] . " " . $row["EMOJI"] . " [-]\n"; else if($lastGMP == $SecondlastGMP ) echo ""; else echo "👉🏻 " . $row["NAME"] . " " . $row["EMOJI"] . " [~]\n"; } } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.07 |
proxy
|
phpinfo
|
Settings