Łączenie z bazą:
<?php
$db_config = array(
'host' => 'localhost',
'port' => '3306',
'user' => 'root',
'pass' => '',
'db' => 'baza',
'db_type' => 'mysql',
'encoding' => 'utf-8'
);
try {
$dsn = $db_config['db_type'] . ':host=' . $db_config['host'] . ';port=' . $db_config['port'] . ';encoding=' . $db_config['encoding'] . ';dbname=' . $db_config['db'];
$user = $db_config['user'];
$pass = $db_config['pass'];
$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
$conn = new PDO($dsn, $user, $pass, $options);
} catch(PDOException $e) {
die('Nie można połączyć z bazą danych: ' . $e->getMessage().'</br></br>');
}
Wstawianie wartości:
$result = $conn->prepare('SELECT * FROM tabelka WHERE login = :login');
$result->bindParam(':login', $login, PDO::PARAM_STR);
$result->execute();
Pozdrawiam!