options(MYSQLI_INIT_COMMAND, ‘SET AUTOCOMMIT = 0’); $mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5); $mysqli->real_connect(‘localhost’, ‘my_user’, ‘my_password’, ‘my_db’, null, null, MYSQLI_CLIENT_COMPRESS|MYSQLI_CLIENT_FOUND_ROWS); echo ‘Success… ‘ . $mysqli->host_info . “n”;
Object-oriented style when extending mysqli class
host_info . “n”; <?php mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); $link = mysqli_init(); mysqli_options($link, MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0'); mysqli_options($link, MYSQLI_OPT_CONNECT_TIMEOUT, 5); mysqli_real_connect($link, 'localhost', 'my_user', 'my_password', 'my_db', null, null, MYSQLI_CLIENT_COMPRESS|MYSQLI_CLIENT_FOUND_ROWS); echo 'Success… ' . mysqli_get_host_info($link) . "n";
The above examples will output:
Success… MySQL host info: localhost via TCP/IP