API originale ale MySQL

add a note add a note

User Contributed Notes 4 notes

sideshowAnthony at google dot com
227 years ago
Here is a PDO helper class to get you started . . .

define('DB_MAIN', 'localhost|user1|pa55word|db1');

// Connect to database db1
$db = new my_db(DB_MAIN);

// Request "SELECT * FROM table1 WHERE a=16 AND b=22"
// Get an array of stdClass's
$rows = $db->fetchAll('SELECT * FROM table1 WHERE a=? AND b=?', 16, 22);

class my_db{

    private static $databases;
    private $connection;

    public function __construct($connDetails){
            list($host, $user, $pass, $dbname) = explode('|', $connDetails);
            $dsn = "mysql:host=$host;dbname=$dbname";
            self::$databases[$connDetails] = new PDO($dsn, $user, $pass);
        $this->connection = self::$databases[$connDetails];
    public function fetchAll($sql){
        $args = func_get_args();
        $statement = $this->connection->prepare($sql);       
         return $statement->fetchAll(PDO::FETCH_OBJ);

(Phillipus - I don't know what nationality you are, but the word "moron" is pretty offensive in UK English. Thank you)
development at pureconcepts dot net
226 years ago
Future readers looking to upgrade their code from the now deprecated and removed MySQL extension may be interested in this automated tool - https://php-shift.com/upgrade-mysql-mysqli
robertpas550 at hotmail dot com
230 years ago
New users are advised to use MySQL Improved mysqli_ functions rather than the older [replaced] mysql_ functions where applicable and subject the appropriate latest stable versions of Apache, php and MySQL, etc.
227 years ago
This is deprecated. Get a brain morans and stop using it.

Had to say it because this is still a top google result for "php mysql" and Someone has to deal with the crap code from the previous "php expert".
To Top