Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- CLASS DB_Class {
- var $db;
- ///////////////////////////
- FUNCTION DB_Class($hostname, $dbname, $username, $password) {
- $this->db = MYSQL_CONNECT ($hostname, $username, $password)
- or DIE ("Unable to connect to Database Server");
- MYSQL_SELECT_DB ($dbname, $this->db) or DIE ("Could not select database");
- }
- FUNCTION query($sql) {
- $result = MYSQL_QUERY ($sql, $this->db) or DIE ("Invalid query: " . MYSQL_ERROR());
- RETURN $result;
- }
- ///////////////////////////
- FUNCTION getone($sql) {
- $result = $this->query($sql);
- IF(MYSQL_NUM_ROWS($result) == 0)
- $value = FALSE;
- ELSE
- $value = MYSQL_RESULT($result, 0);
- RETURN $value;
- }
- ///////////////////////////
- }
- ?>
- <?PHP
- $hostname=$_POST['host'];
- $db=$_POST['db'];
- $user=$_POST['user'];
- $password=$_POST['password'];
- $dbconnect = NEW DB_Class($hostname, $db, $user, $password);
- $query = "SELECT * FROM users";
- $result = mysql_query($query);
- while($line=mysql_fetch_array($result)){
- echo $line;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement