PHP: Hypertext Preprocessor (original) (raw)

mysqli::init

mysqli_init

(PHP 5, PHP 7, PHP 8)

mysqli::init -- mysqli_init — Initializes MySQLi and returns an object for use with mysqli_real_connect()

Parameters

This function has no parameters.

Return Values

mysqli::init() returns [null](reserved.constants.php#constant.null) on success, or [false](reserved.constants.php#constant.false) on failure.mysqli_init() returns an object on success, or [false](reserved.constants.php#constant.false) on failure.

Changelog

Version	Description
8.1.0	The object-oriented style mysqli::init() method has been deprecated. Replace calls to parent::init() withparent::__construct().

Found A Problem?

Kam.Dab ¶

1 year ago

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, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>u</mi></msub><mi>s</mi><mi>e</mi><mi>r</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_user, </annotation></semantics></math>dbuser,db_pass, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>n</mi></msub><mi>a</mi><mi>m</mi><mi>e</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_name, </annotation></semantics></math>dbname,port, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>p</mi><mi>e</mi><mi>r</mi><mi>s</mi><mi>i</mi><mi>s</mi><mi>t</mi><mi>e</mi><mi>n</mi><mi>t</mi><mo>=</mo><mi>t</mi><mi>r</mi><mi>u</mi><mi>e</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">persistent = true, </annotation></semantics></math>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:' : '') . <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>h</mi></msub><mi>o</mi><mi>s</mi><mi>t</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_host, </annotation></semantics></math>dbhost,db_user, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>p</mi></msub><mi>a</mi><mi>s</mi><mi>s</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_pass, </annotation></semantics></math>dbpass,db_name, $port, '', MYSQLI_CLIENT_SSL | MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT ); } else { parent::__construct($db_host, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>u</mi></msub><mi>s</mi><mi>e</mi><mi>r</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_user, </annotation></semantics></math>dbuser,db_pass, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>d</mi><msub><mi>b</mi><mi>n</mi></msub><mi>a</mi><mi>m</mi><mi>e</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">db_name, </annotation></semantics></math>dbname,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

evgen at sysmasters dot net ¶

3 years ago

`Correct way to connect db

mysqli=newmysqli("127.0.0.1","dbuser","dbpass","dbname",3306);mysqli = new mysqli("127.0.0.1", "db_user", "db_pass", "db_name",3306);mysqli=newmysqli("127.0.0.1","dbuser","dbpass","dbname",3306);result = $mysqli->query("SELECT somefield1, somefield2 FROM sometable ORDER BY ID LIMIT 3");/* Close the connection as soon as it becomes unnecessary */ $mysqli->close(); foreach ( resultasresult as resultasrow) { /* Processing data received from the database */ echo var_dump ($row); } `