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-ajax-user-search.php

21 lines ASCII Windows (CRLF)
<?php require('rpsmaininclude.php');

ob_clean();

    
$sKey $_GET['strInput'];

    
$sql "SELECT * FROM rpsusers WHERE username LIKE '$sKey%' ORDER BY username";
    
$stmt $dbconn->prepare($sql);
    
$stmt->execute();

    
$outputText "";
    while(
$res $stmt->fetch(PDO::FETCH_ASSOC)){
        
$name =  $res['username'];
        
$ratio $res['ratio'];
        if(
$name!=""){
            
$outputText .= '<a href="rpsaccount.php?user='.$name.'">'.$name.'</a>'."&nbsp".$ratio.'<br>';
        }
    }
    echo 
$outputText;

?>