| Server IP : 64.202.187.69 / Your IP : 216.73.216.17 Web Server : Apache System : Linux 69.187.202.64.host.secureserver.net 3.10.0-1160.144.1.el7.tuxcare.els6.x86_64 #1 SMP Fri May 29 16:22:24 UTC 2026 x86_64 User : transmarket ( 1001) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/transmarket/testtranslator/ |
Upload File : |
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include 'connection.php';
$sql1 = 'SELECT * FROM tbl_translators';
$result1 = $mysqli->query($sql1);
if ($result1->num_rows > 0) {
$data['status'] = 200;
while ($row1 = $result1->fetch_object()) {
$user_id = $row1->id;
$sql = 'SELECT * FROM tbl_user_suggestion_marketing_mapping WHERE user_id ="'.$user_id.'"';
$result = $mysqli->query($sql);
echo "<br>===".$user_id."===".$result->num_rows;
// Lock the sentence for other users
/*$sqlUpdate = 'UPDATE `tbl_translators` SET total_suggestions_marketing = "'.$result->num_rows.'" where id = ' . $user_id;
$resultUpdate = $mysqli->query($sqlUpdate);*/
}
}