note 128602 added to mysqli.init

From: 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

« previous php.notes (#220559) next »