update.php

<?php
include './config/connect.php';
//i don't know what i am writing tho, i hope it works sha
    $first ="UPDATE `user` SET `score` = '0' WHERE `score` > 0";
    $reset = mysqli_query($conn, $first);
    $sql = "SELECT email FROM user";
    $result = mysqli_query($conn, $sql);
    $count = mysqli_num_rows($result);
    if ($count > 0) {
        while($row = mysqli_fetch_assoc($result)) {
            $particular_user = $row['email'];
            $up = total_score($particular_user);
            update_total($particular_user, $up);
        }
    }


    function total_score($email){   
        global $conn;
        $queryURL = "SELECT `points` FROM submissions WHERE `user` = '$email' ";
        $resultURL = mysqli_query($conn, $queryURL);
        $countURL = mysqli_num_rows($resultURL);
        $total = 0;
        if ($countURL > 0) {
            while($row = mysqli_fetch_assoc($resultURL)) {
                $total += $row['points'];
            }
            return $total;
        }else{
            return $total;
        }
    }
    function update_total($email, $total){
        global $conn;
        $query = "UPDATE user SET score = $total WHERE `email` = '$email' ";
        $result = mysqli_query($conn, $query);
        if($conn->query($query)){
            return 1;
        }else{
            return 0;
        }
    }
   
?>