note 128602 added to mysqli.init
| From: | Kam dot Dab at main dot php dot net | Date: | Sun, 11 Jun 2023 02:14:27 +0000 |
| Subject: | note 128602 added to mysqli.init | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-220559@lists.php.net to get a copy of this message | ||
I wrote support ssl mysqli you don't need change anymore mysqli connect exchange to your own
mysqli . Overwrite __construct mysqli with support ssl can be like that:
<?php class myssl_mysqli extends \mysqli {
public function __construct($db_host, $db_user, $db_pass, $db_name, $port, $persistent =
true, $ssl = false, $certpublic = "") {
if($ssl) {
parent::init();
parent::options(MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, false);
parent::ssl_set(NULL, NULL, $certpublic, NULL, NULL);
parent::real_connect(($persistent ? 'p:' : '') . $db_host, $db_user,
$db_pass, $db_name, $port, '', MYSQLI_CLIENT_SSL |
MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT );
} else {
parent::__construct($db_host, $db_user, $db_pass, $db_name, $port);
}
}
$db = new myssl_mysqli('localhost','user', 'pass','db',
'3306', true, true, '/home/mypublicowncert.pem');
?>
in this example i off the verificate cert by authority ssl, due it own cery created
----
Server IP: 45.112.84.4
Probable Submitter: 80.90.13.130 (proxied: 2001:268:c20f:b3d6:40a:f303:9b94:bac5)
----
Manual Page -- https://php.net/manual/en/mysqli.init.php
Edit -- https://main.php.net/note/edit/128602
Del: integrated -- https://main.php.net/note/delete/128602/integrated
Del: useless -- https://main.php.net/note/delete/128602/useless
Del: bad code -- https://main.php.net/note/delete/128602/bad+code
Del: spam -- https://main.php.net/note/delete/128602/spam
Del: non-english -- https://main.php.net/note/delete/128602/non-english
Del: in docs -- https://main.php.net/note/delete/128602/in+docs
Del: other reasons-- https://main.php.net/note/delete/128602
Reject -- https://main.php.net/note/reject/128602
Search -- https://main.php.net/manage/user-notes.php