I am just learning about php and mysql and i set up a test mysql database with a couple of tables. I created a php file last night to test that I could connect to the database. It worked. I left the page open and went to bed.
However, when I looked at the mysql usage report this morning it said I had 93 connects and 642 queries. How can that be? I haven’t done anything since last night. Is it because the connection is still open after leaving the page open overnight.
Sorry if this is a stupid question…just curious.
Here is my php:
$conn = new PDO(“mysql:host=$servername;dbname=mytest”, $username, $password);
// set the PDO error mode to exception
echo “Connected successfully”;
echo "Connection failed: " . $e->getMessage();
Thanks in advance…Nesto