PHP fsl Database Examples

Example #1

File: FairsharePie.php Project: BYUHPC/slurm-fairshare-pie

<?php

requireLogin();
$username = $_SESSION['userdata']['username'];
$pdo = \Fsl\Database::connect();
$query = <<<EOT
        select user, shares from slurm.fsl_assoc_table where acct=? and user != "" and not deleted; 
EOT;
$statement = $pdo->prepare($query);
$statement->execute(array($username));
$result = $statement->fetchAll();
header('Content-Type: application/json');
echo json_encode(array("rows" => $result));

Example #2

File: limits.php Project: BYUHPC/slurm-limits-web

<?php

requireLogin();
$username = $_SESSION['userdata']['username'];
$pdo = \Fsl\Database::connect("slurm");
$query = <<<EOT
            SELECT user, acct, grp_submit_jobs, grp_tres, grp_wall, grp_tres_run_mins
            FROM fsl_assoc_table
            WHERE (acct=? OR parent_acct=?) AND NOT deleted AND parent_acct != 'root'
            ORDER BY user='', user;
EOT;
$statement = $pdo->prepare($query);
$statement->execute(array($username, $username));
$result = $statement->fetchAll();
header('Content-Type: application/json');
echo json_encode(array("rows" => $result));