CODEWITHSUNDEEP
phpmysqlsqlprepared-statementphp-5.3
TechChain
TechChain

Reputation: 8942

how to close connection using prepare statement in php?

I am using php to create the user accounts on server database.I have used prepare statement to create user account.I want to know how can i close my sql connection using prepare statement or i don't need to close the connections? Is it done automatically.

Here is my code

public function createUser($name, $email, $password,$file_path,$phone,$address,$profession,$language)
    {


        $response = array();

        // First check if user already existed in db
        if (!$this->isUserExists($email)) {

            // Generating API key
            $api_key = $this->generateApiKey();

            // insert query
            $stmt = $this->conn->prepare("INSERT INTO users(name, email, password, api_key,profile_pic,phone,address,profession,language,date) values(?, ?, ?, ?, ?, ?, ?, ?,?,now())");
            $stmt->bind_param("sssssssss", $name, $email, $password, $api_key,$file_path,$phone,$address,$profession,$language);

            $result = $stmt->execute();

            $stmt->close();

            // Check for successful insertion
            if ($result)
            {
                // User successfully inserted
                return USER_CREATED_SUCCESSFULLY;
            }
            else
            {
                // Failed to create user
                return USER_CREATE_FAILED;
            }
        }
        else
        {
            // User with same email already existed in the db
            return USER_ALREADY_EXISTED;
        }

        return $response;
    }

I am new to php so i don't have any idea about this.

Upvotes: 2

Views: 2427

Answers (2)

Malik Naik
Malik Naik

Reputation: 1502

$stmt->close(); // Closes the prepared statement

$this->conn->close(); // Closes the mysql connection

Upvotes: 0

Manu Varghese
Manu Varghese

Reputation: 811

$stmt->close();

is enough .

check this http://www.w3schools.com/php/php_mysql_prepared_statements.asp

Upvotes: 2

Related Questions