1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
| $Driver = "odbc:driver={MySQL ODBC 8.0 ANSI Driver};";
$Server = "server=localhost;";
$Database = "database=test";
$Cert = "sslcert=f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Client-cert.pem;";
$Key = "sslkey=f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Client-key.pem;";
$Ca = "sslca=f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Ca.pem;";
$Capath = "sslcapath=f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql;";
$Connexion = $Driver.$Server.$Database.$Ca.$Key.$Capath.$Cert;
$Utilisateur = "test";
$Mot_de_Passe = "test";
$Options = array(
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES latin1",
PDO::ATTR_CASE => PDO::CASE_LOWER,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_PERSISTENT => false,
PDO::MYSQL_ATTR_SSL_CA => 'f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Ca.pem',
PDO::MYSQL_ATTR_SSL_KEY => 'f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Client-key.pem',
PDO::MYSQL_ATTR_SSL_CERT => 'f:/Wamp/bin/apache/apache2.4.55/conf/certificat/Mysql/Client-cert.pem',
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => true
);
try {
$link = new PDO($Connexion, $Utilisateur, $Mot_de_Passe, $Options);
}
catch (PDOException $e)
{
echo "Connection à MySql impossible : ", htmlentities($e->getMessage());
die();
} |
