Just a rather simple question with regards to PDO compared to MySQLi.
With MySQLi, to close the connection you could do:
$this->connection->close();
However with PDO it states you open the connection using:
$this->connection = new PDO();
but to close the connection you set it to null.
$this->connection = null;
Is this correct and will this actually free the PDO connection? (I know it does as it is set to null.) I mean with MySQLi you have to call a function (close) to close the connection. Is PDO as easy as = null to disconnect? Or is there a function to close the connection?
Related Posts:
- PDOException SQLSTATE[HY000] [2002] No such file or directory
- PDOException SQLSTATE[HY000] [2002] No such file or directory
- PDO with INSERT INTO through prepared statements
- PDO bindParam() with prepared statement isn’t working
- pdo – Call to a member function prepare() on a non-object
- Are PDO prepared statements sufficient to prevent SQL injection?
- SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
- Call to a member function on null?
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- What is the advantage of using try {} catch {} versus if {} else {}
- Deprecated: mysql_query() [duplicate]
- Replace ' and similar html codes with their correspondent character?
- Google Calendar API event update always return 404 “not found” error
- How to prevent the “Confirm Form Resubmission” dialog?
- navigate back with PHP form submission
- How to set 777 permission on a particular folder? [closed]
- How do I make a redirect in PHP?
- List of All Locales and Their Short Codes?
- Difference between “as $key => $value” and “as $value” in PHP foreach
- How do I get a YouTube video thumbnail from the YouTube API?
- What is a slug?
- Visual list of all installed fonts with respective pangram phrase?
- How to avoid Request Entity Too Large 413 error
- How to log in to phpMyAdmin with WAMP, what is the username and password?
- Array to String PHP?
- Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
- count() parameter must be an array or an object that implements countable in laravel
- regex match any whitespace
- What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
- How to fix “Headers already sent” error in PHP
- currently unable to handle this request HTTP ERROR 500
- PHP page redirect
- Whoops, looks like something went wrong. Laravel 5.0
- PHP “or” Syntax
- Fatal error: Call to undefined function mysql_connect()
- How to fix “Headers already sent” error in PHP
- “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
- What are namespaces?
- Get the full URL in PHP
- http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
- Mysql query- How to use contains?
- How do I get PHP errors to display?
- S_SESSION variable (user role) not recognised
- What are the main differences between PHPExcel and PhpSpreadsheet?
- Is SAJAX dead? What to replace with?
- How do I resolve a HTTP 414 “Request URI too long” error?
- Get the full URL in PHP
- How do I check if a string contains a specific word?
- PDOException: SQLSTATE[HY000] [2002] No such file or directory
- xajax expanding list query
- How to force file download with PHP
- How do I get a file extension in PHP?
- How to Set Category Page as Home Page in Prestashop
- Get the full URL in PHP
- Data source name not found, and no default driver specified
- mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
- Invalid column count in CSV input on line 1 Error
- Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
- How to copy a file from one directory to another using PHP?
- How to check if a string starts with a specified string?
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- what does PHP die() return
- Invalid column count in CSV input on line 1 Error
- how to replace quotation marks with \”
- Getting an error when I visit http://localhost
- How do I redirect a page in jQuery?
- PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
- mcrypt is deprecated, what is the alternative?
- How can I find my php.ini on wordpress?
- mysqli_real_connect(): (HY000/2002): No such file or directory
- Convert a PHP object to an associative array
- XAMPP Port 80 in use by “Unable to open process” with PID 4
- PHP + curl, HTTP POST sample code?
- PHP random string generator
- How to echo or print an array in PHP?
- Fatal error: Call to undefined function mysqli_connect()
- What are the differences in die() and exit() in PHP?
- How to parse a CSV file using PHP
- How to call a JavaScript function from PHP?
- Cannot use object of type stdClass as array?
- Is a new line = \n OR \r\n?
- What is difference between PHP cli and PHP cgi?
- Resize image in PHP
- Error 500: Premature end of script headers
- Cookies vs. sessions
- Expected status code 200 but received 500
- Regex to check for new line
- $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
- How to replace “if” statement with a ternary operator ( ? : )?
- Illegal string offset Warning PHP
- Why use $_SERVER[‘PHP_SELF’] instead of “”
- phpMyAdmin: secret passphrase?
- Elegant way to search for UTF-8 files with BOM?
- What’s the purpose of ini_set() in php? (especially for error reporting)
- Can you “compile” PHP code and upload a binary-ish file, which will just be run by the byte code interpreter?
- How to get the file extension in PHP?
- Are there dictionaries in php?
- why use 0xffff over 65535
- Email Not Sending from Byethost Hosting
- Is SAJAX dead? What to replace with?