mysqli_connect vs mysqli_real_connect

Question

I read the doumentation But I don't understand the difference exactly.

What difference does the connection object make in this? I didn't find any posts.

I misunderstood it. Flags are not present in both. Why didn't they add flags as part of mysqli_connect? Any specific reasons? Which one should I use?

"flags are present in both". Are you sure? – Nanne Jul 21 '15 at 14:31 — Nanne, Jul 21 '15 at 14:31
@Nanne - Sorry. Please see the edits – Gibbs Jul 21 '15 at 14:34 — Gibbs, Jul 21 '15 at 14:34

score 7 · Answer 1 · answered Dec 01 '18 at 10:08

mysqli_real_connect() and mysqli_connect is different in way that

mysqli_real_connect() accepts a lot more options than mysqli_connect

For example I am building a health-check script for my Loadbalancer and I want set the very low connection timeout.

Now the connection timeout has to be set using:

mysqli_options() with the option name MYSQLI_OPT_CONNECT_TIMEOUT

Now the thing with mysqli_options() is that this should be called after mysqli_init() and before mysqli_real_connect().

mysqli_connect cannot be used for this purpose.

Hope this explanation helps.

<?php
//create the object
$connection = mysqli_init();

//specify the connection timeout
$connection->options(MYSQLI_OPT_CONNECT_TIMEOUT, 3);

//specify the read timeout
$connection->options(MYSQLI_OPT_READ_TIMEOUT, 3);

//initiate the connection to the server, using both previously specified timeouts
$connection->real_connect('server', 'user', 'pass', 'database');
?>

score 6 · Answer 2 · edited Aug 12 '19 at 11:13

6

This function differs from mysqli_connect():

mysqli_real_connect() needs a valid object which has to be created by function mysqli_init().

With the mysqli_options() function you can set various options for connection.

There is a flags parameter.

edited Aug 12 '19 at 11:13

RiggsFolly

93,638
21
103
149

answered Jul 21 '15 at 14:34

Ehab Eldeeb

722
4
12

And mysqli_connect vs mysqli_init? – Pacerier Nov 12 '17 at 19:16
mysqli_real_connect() needs a valid object which has to be created by function mysqli_init(). – Ehab Eldeeb Nov 16 '17 at 23:57

score 4 · Answer 3 · answered Jul 21 '15 at 14:33

4

With mysqli_real_connect you can test if the initialization of the mysqli object was successful and set any mysqli_options before connecting.

answered Jul 21 '15 at 14:33

HenryTK

1,287
8
11

1

Then why do we need mysqli_connect – Gibbs Jul 21 '15 at 14:35
Please explain a bit more – Gibbs Jul 21 '15 at 15:30
1

Most of the time you won't need to test whether the mysqli object initialized properly, and most people are happy with the default options, so you just use mysqli_connect. – HenryTK Jul 21 '15 at 15:38

mysqli_connect vs mysqli_real_connect

3 Answers3