<?php require_once "../config.php"; require_once "../lib/connDB.php"; $DB = new dbquery($DB_HOST, $DB_USER, $DB_PASSWORD, $DB_NAME); $DB->connent(); $sql = "SELECT * FROM jk_account "; $result = mysql_query($sql); $num = mysql_num_rows($result); echo " Num Row Total:" . $num . "<br>"; $i = 0; while ($row = mysql_fetch_array($result)) { echo $i . ". " . $row['username'] . "<br>"; echo $i . ". " . $row['email'] . "<br>"; $i++; } mysql_close();
<?php if (isset($_SESSION["DB"]) || $_SESSION["DB"] == '') { $DB = new dbquery(); $DB->username = $DB_USER; $DB->password = $DB_PASSWORD; $DB->dbhost = $DB_HOST; $DB->dbname = $DB_NAME; $DB->connect(); $_SESSION["DB"] = $DB; } else { echo "No Session"; exit; }