| Re: why can`t close mysql_connect? [message #179636 is a reply to message #179631] |
Thu, 15 November 2012 12:46   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 11/15/2012 5:19 AM, cngrit0305(at)gmail(dot)com wrote:
> hi,
> I am a novice with php,today,I found can`t close mysql_connect.
>
> I have a object "db_config.php"
>
> class DbConfig{
> private $db_url = 'localhost:3333';
> private $db_user = 'root';
> private $db_pwd = 'root';
> private $db_name = 'xinxiwang';
> function __get($property_name){
> return $this->$property_name;
> }
>
> public function getConn(){
> $link = mysql_connect($this->db_url,$this->db_user,$this->db_pwd)
> or die("can not connect to Mysql server");
> mysql_select_db($this->db_name,$link)
> or die("can not found database " . $this->db_name );
> return $link;
> }
> }
>
> I will in a other php file include it "test.php"
>
> require (db_config.php);
>
> function fri_select($db,$pagenum,$counts){
> $sql = "call friendlink_select($pagenum,$counts)";
> $result = mysql_query($sql,$db);
> mysql_close($db);
> if($db){
> echo "in function, con is alive;<br>";
> }else{
> echo "in function , con is dead";
> }
> if(isset($db)){
> echo "in function,con is alive;<br>";
> }else{
> echo "in function , con is dead";
> }
> if(!empty($db)){
> echo "in function,con is alive;<br>";
> }else{
> echo "in function , con is dead";
> }
> return $result;
> }
>
> $db = new DbConfig();
> $dbs = $db->getConn();
>
> $result = fri_select($dbs,1,6);
> if($dbs){
> echo "out function, con is alive;<br>";
> }else{
> echo "out function , con is dead";
> }
> if(isset($dbs)){
> echo "out function,con is alive;<br>";
> }else{
> echo "out function , con is dead";
> }
> if(!empty($dbs)){
> echo "out function,con is alive;<br>";
> }else{
> echo "out function , con is dead";
> }
>
> it will out put
>
> in function,con is alive;
> in function,con is alive;
> in function,con is alive;
> out function, con is alive;
> out function,con is alive;
> out function,con is alive;
>
> why???I had close it in function!!!who can tell me??
> thanks very much!!!
>
$dbs is a resource, not a true/false value as to whether the connection
is alive or not. Even after closing the connection, the resource is
still there - but not the connection.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]