Bravo List - PDO addon

Bravo List (http://www.bvlist.com/index.php)

- Mods & Themes (http://www.bvlist.com/forumdisplay.php?f=87)

- - PDO addon (http://www.bvlist.com/showthread.php?t=11827)

BamBam0077

5th November 2018 20:54

PDO addon

PHP Code:


		
			
//PDO$hostname='localhost';$username='root';$password='';try {$pdo = new PDO("mysql:host=$hostname;dbname=torrentbeta",$username,$password);$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line//echo 'Connected to Database';$cache = $pdo->query("SELECT * FROM users");foreach ( $cache as $row) { echo $row["email"] ." - ". $row["ip"] ."<br/>"; }  echo "Access Connected"; $pdo = null;} catch(PDOException $e) {   echo $e->getMessage();}

PDO connection works remove the query once you see it working an update to PDO standards good luck

Napon

5th November 2018 22:06

lol

BamBam0077

19th November 2018 09:59

Code:



//PDO

  $hostname='localhost';   

  $username='root';

  $password='';

 try {

 $pdo = new PDO("mysql:host=$hostname;dbname=torrentbeta",$username,$password);

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line

//echo 'Connected to Database';

echo "Access Connected";

$pdo = null;

} catch(PDOException $e) {  

 echo $e->getMessage();

}

DND	19th November 2018 11:47

addon ?

BamBam0077

23rd November 2018 03:37

Code:

  function setupDatabase()

    {

        // put your database information mentioned above here

        $username = 'root';

        $password = 'root';

        $host = 'localhost';

        $dbname = 'verify';



        try {

            $pdo = new PDO("mysql:host=$host;dbname=$dbname",$username,$password);

            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);



        } catch(PDOException $e) {

            return 'ERROR: ' . $e->getMessage();

        }



        return $pdo;

    }

All times are GMT +2. The time now is 09:33.