22

✏️ Editing: api-backup.php

<?php
// Start the session
session_start();
?>
<?php
//Connection Detail
$dbhost = 'localhost';
$dbuser = 'coreagen_nationaldaydraw';
$db = 'coreagen_nationaldaydraw';
$dbpass = 'BGCjeddah@69';
//$id = $_GET['id'];

$link = mysqli_connect($dbhost, $dbuser, $dbpass, $db);
$GLOBALS["link"] = mysqli_connect($dbhost, $dbuser, $dbpass, $db);
$link->set_charset("utf8");
if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

<?php

function register_user($data){

$name = $data['name'];
$mbl = $data['mbl'];
$empid = $data['empid'];

$codequery = "insert into xx_hr_national_day_draw 
(name,
empid,
mbl,
register_date
) 
value 
('$name',
'$empid',
'$mbl',
now()
)";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
return '1';    
}else{
return 'error';    
}
    
}

function is_existing_user($data){

$codequery = "select count(id) cnt from xx_hr_national_day_draw where empid = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row['cnt'];
}

return $id;
    
}

function get_draw_users($data){

$codequery = "select * from xx_hr_national_day_draw where is_win = 'N'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id[] = $row;
}

foreach($id as $idv) {
$drawusn[] = $idv['name']."|".$idv['empid'];	
}

//$drawusn[] = '123';

//$arr = array('Hello','World!','Beautiful','Day!');
return '"'.implode('","',$drawusn).'"';

//return $id;
    
}

function add_winner($name,$empid,$mobile){

$codequery = "insert into xx_winners 
(name,
emp_id,
mobile,
winning_date
) 
value 
('$name',
'$empid',
'$mobile',
now()
)";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
return '1';    
}else{
return 'error';    
}
    
}

function remove_winner_from_draw($data){

$codequery = "update xx_hr_national_day_draw set
is_win = 'Y'
where empid = '$data'
";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
return '1';    
}else{
return 'error';    
}
    
}

MR SKB