Will mysql_connect itself?

[chan15]

I write one function use mysql_connect named a, if I executed a() in index.php three times at the same time, will it detect it's already connected above and skip the connect process when second and third execution?

[Jeroen]

No, it wont, if you call mysql_connect 3times, it connects 3times.

[chan15]

Can I use any code to detect it?

[seandisanti]

yes, just assign the connect to a variable, and then isset($connection) will determine if it's set.

[tkdbb84]

An alternative would be to create the connection in the script that calls a(); and pass it as an argument to a, then you can handle the connection in the parent structure.

Code: Select all

//do upper parent stuff
$pdo_handle = new PDO('my connection string',$arg1,$arg2);
//do more stuff
$my_important_stuff = a($lala,$pdo_handle);
//process
$my_other_stuff = a($lala2,$pdo_handle);
//blahblah

function a($args_i_need, &$pdo_connection){
   $my_prepared_statement = $pdo_connection->prepare("SELECT * FROM myTable;");
   //do stuff
   return $my_results;
}

seems an easier way to control connections.

[chan15]

Thanks you all guys