Table Help/PHP

[Blasteh]

So, I'm making a different type banlist in my housekeeping. I want the id (of the user) and username to display.

Where it says "rank" I am am going to make it say "Banned?" I want it echo 0/1 or No/Yes.

You must be registered for see images attach

It's multiple tables, so I'm pretty confused.. Any help possible is great.

Here's the code:

                            <div class="module-body">
                            <table class="table table-striped">
                            <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>Username</th>
                                            <th>Rank</th>
                                        </tr>
                                    </thead>
<?php
$getUsers = mysql_query("SELECT id,username,rank FROM users");
 
while(($users = mysql_fetch_array($getUsers)))
{
echo "<tr><td>" . $users['id'] ."</td><td>" . $users['username'] . "</td><td>" . $users['rank'];
}
?>

 

[Benden]

Well, I don't know your database structure but I'm assuming

$getUsers = mysql_query("SELECT id,username,rank FROM users");

to

$getUsers = mysql_query("SELECT id,username,banned FROM users");

and

echo "<tr><td>" . $users['id'] ."</td><td>" . $users['username'] . "</td><td>" . $users['rank'];

to

echo "<tr><td>" . $users['id'] ."</td><td>" . $users['username'] . "</td><td>" . $users['banned'];

and that'll echo a 0 or 1, to make it say yes or no use a boolean

 

[Blasteh]

Well, I don't know your database structure but I'm assuming

$getUsers = mysql_query("SELECT id,username,rank FROM users");

to

$getUsers = mysql_query("SELECT id,username,banned FROM users");

and

echo "<tr><td>" . $users['id'] ."</td><td>" . $users['username'] . "</td><td>" . $users['rank'];

to

echo "<tr><td>" . $users['id'] ."</td><td>" . $users['username'] . "</td><td>" . $users['banned'];

and that'll echo a 0 or 1, to make it say yes or no use a boolean

PlusEMU doesn't have a "banned" column in users (I don't think)

 

[MayoMayn]

PlusEMU doesn't have a "banned" column in users (I don't think)

It has a 'bans' table. Check if the user exists or his IP exists in that table, and then simply echo "Yes" or "No"?

Sent from my SM-G928F using Tapatalk

 

[griimnak]

Did a sketch pdo because idek how to use regular mysql anymore

<?php
class PdoConnection {
    public static function dbConnect() {

            try {

                $dbh = ''
                $dbu = ''
                $dbp = ''
                $dbd = ''

                $conn = new pdo("mysql:host=$dbh;dbname=$dbd;", $dbu, $dbp);
                $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                return $conn;
            } catch(PDOException $e) {
                die('fucking shit', $e);

            }
        }
}
?>


<?php
$query = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM users');
$query->execute();
$data = $query->fetchAll();
foreach ($data as $row) {
            echo "<tr><td>" . $row['id'] ."</td><td>" . $row['username'] . "</td><td>" . $row['rank'];
}


//now for the bans, do you have a ban table in the db?
$query2 = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM banned_users WHERE id < 6'); //replace banned users with your table and the rank, because idk.
$query->execute();
$data2 = $query2->fetchAll();
foreach ($data2 as $row) {
    echo "staf member banned: " . $row['username'];

}
?>

god that code block style is ugly^^

 

[MayoMayn]

Did a sketch pdo because idek how to use regular mysql anymore

<?php
class PdoConnection {
    public static function dbConnect() {

            try {

                $dbh = ''
                $dbu = ''
                $dbp = ''
                $dbd = ''

                $conn = new pdo("mysql:host=$dbh;dbname=$dbd;", $dbu, $dbp);
                $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                return $conn;
            } catch(PDOException $e) {
                die('fucking shit', $e);

            }
        }
}
?>


<?php
$query = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM users');
$data = $query->fetchAll();
foreach ($data as $row) {
            echo "<tr><td>" . $row['id'] ."</td><td>" . $row['username'] . "</td><td>" . $row['rank'];
}


//now for the bans, do you have a ban table in the db?
$query2 = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM banned_users WHERE id < 6'); //replace banned users with your table and the rank, because idk.
$data2 = $query2->fetchAll();
foreach ($data2 as $row) {
    echo "staf member banned: " . $row['username'];

}
?>

god that code block style is ugly^^

Easier just to make a join tables query, instead of doing different 2 queries.
fetchAll then a foreach, you're not even executing the query? Normally you would do a $stmt->execute and then a foreach($stmt as $blabla){ } damn you're making this way more complicated than it actually is. But I feel ya, can't even do regular mysql_ anymore, its too complicated compared to OOP and way too shit that I bother help out people using mysql_

Sent from my SM-G928F using Tapatalk

 

[griimnak]

Easier just to make a join tables query, instead of doing different 2 queries.
fetchAll then a foreach, you're not even executing the query? Normally you would do a $stmt->execute and then a foreach($stmt as $blabla){ } damn you're making this way more complicated than it actually is. But I feel ya, can't even do regular mysql_ anymore, its too complicated compared to OOP and way too shit that I bother help out people using mysql_

Sent from my SM-G928F using Tapatalk

Yeah i got confused when i started writing the second query because i have no idea how the db is structured, however if op plans on doing the query in pdo i suppose you could use mine as a base.

And oh i know, very messy and inefficient. But fix it up boios.

oh and i just forgot to execute, fixed it now. See what python does to you?

 

[Core]

Did a sketch pdo because idek how to use regular mysql anymore

<?php
class PdoConnection {
    public static function dbConnect() {

            try {

                $dbh = ''
                $dbu = ''
                $dbp = ''
                $dbd = ''

                $conn = new pdo("mysql:host=$dbh;dbname=$dbd;", $dbu, $dbp);
                $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                return $conn;
            } catch(PDOException $e) {
                die('fucking shit', $e);

            }
        }
}
?>


<?php
$query = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM users');
$query->execute();
$data = $query->fetchAll();
foreach ($data as $row) {
            echo "<tr><td>" . $row['id'] ."</td><td>" . $row['username'] . "</td><td>" . $row['rank'];
}


//now for the bans, do you have a ban table in the db?
$query2 = PdoConnection::dbConnect()->prepare('SELECT id,username,rank FROM banned_users WHERE id < 6'); //replace banned users with your table and the rank, because idk.
$query->execute();
$data2 = $query2->fetchAll();
foreach ($data2 as $row) {
    echo "staf member banned: " . $row['username'];

}
?>

god that code block style is ugly^^

Why would you want to open another connect if you already have an existing connection open? rip

 

[griimnak]

Why would you want to open another connect if you already have an existing connection open? rip

The pdo connection? It's basically just to simulate what he wants to do in this instance, I wouldn't recommend using pdo & mysql together(obviously lol)

 

[Core]

The pdo connection? It's basically just to simulate what he wants to do in this instance, I wouldn't recommend using pdo & mysql together(obviously lol)

I know but should of gave him example in the old deprived mysql xD
- if your php still supports it (which is unlikely lol)

 

[griimnak]

I know but should of gave him example in the old deprived mysql xD
- if your php still supports it (which is unlikely lol)

Honestly bro i don't remember how to use the regular mysql xD that's why i did this in pdo.
Haven't touched php in a long while, i've been on the python grind. So clean, so simple.
But when I did use php, i always used PDO. gotta have those prepared statements and object oriented binds

 

[Weasel]

My SQL is rusty, and as I'm not 100% sure how PlusEMU works (database wise), but you can give this a shot:

<div class="module-body">
    <table class="table table-striped">
        <thead>
            <tr>
                <th>ID</th>
                <th>Username</th>
                <th>Banned</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $getUsers = mysql_query("SELECT `users`.`id`, `users`.`username`, `bans`.`id` AS `ban_id` FROM `users` LEFT JOIN `bans` ON `bans`.`value` = `users`.`id` WHERE `bans`.`bantype` = 'user' AND `bans`.`expire` > UNIX_TIMESTAMP(NOW())");
          
            while (($users = mysql_fetch_array($getUsers))) {
                ?>
                    <tr>
                        <td><?= $users['id'] ?></td>
                        <td><?= $users['username'] ?></td>
                        <td><?= !is_null($users['ban_id']) ? "Yes" : "No" ?></td>
                    </tr>
                <?php
            }
            ?>
        </tbody>
    </table>
</div>