Webbserverprogrammering 1

Show sourcecode

The following files exists in this folder. Click to view.

webbsrvprg/projects/

bacon-egg-pizza.php
cquiz.php
create-account.php
create-account111.php
create-quiz.php
create-quiz2.php
createaccount.php
delete-quiz.php
drop-rps-tables.php
legacy-code-rps.php
legacy-index.php
login.php
logincheck.php
newpassword-verify.php
newpassword.php
potential-code.txt
quiz-db-init.php
quizhub.php
quizhub2.php
results.php
rpsaccount-ajax-user-search.php
rpsaccount.php
rpsbetting-ajax-match-finder.php
rpsbetting.php
rpsbettingleaderboard.php
rpschangepassword.php
rpschangepassword.txt
rpsgame-ajax.php
rpsgame.php
rpsgameresults.php
rpshostnewgame.php
rpshub.php
rpsleaderboard.php
rpslib.php
rpslogin.php
rpsmaininclude.php
rpsproject/
rpsusersearch.php
table-init.php
verification.php

rpsaccount.php

33 lines UTF-8 Windows (CRLF)
<?php
    
require('rpsmaininclude.php');
    
updateWinLoss($dbconn);

    
//getUserInfo($_SESSION['user']);

    
function displayUserData($dbconn,$userdata){
        echo 
'vinster: '.$userdata[3]."<br>".'förluster: '.$userdata[4]."<br> vinst/förlust ratio: ".$userdata[5]."<br>bettingpoäng: ".$userdata[6];
    }

    
$user $_GET['user']; 
    
$userInfo=[];
    
$userinfocolumns = ['username','pass','email','wins','losses','ratio','bettingpoints'];
    
$sql "SELECT * FROM rpsusers WHERE username = ?";
    
$stmt $dbconn -> prepare($sql);
    
$stmt -> execute([$user]);
    while(
$res $stmt->fetch(PDO::FETCH_ASSOC)){
        foreach(
$userinfocolumns as $type){
            
array_push($userInfo,$res["$type"]);
        } 
    }


?>

<html>
<body>
    <h1><?php echo $userInfo[0]; ?></h1>
    <h2>Statistik</h2>
    <?php displayUserData($dbconn,$userInfo); ?>

</body>
</html>