myxotod / php-database-class

OUTDATED!!! This is a simple php class to handle MySQL queries.

👋🏼 私のGITHUBへようこそ

Welcome to my GitHub profile. Feel free to wander around but beware, there are a lot of useless and unmaintained projects flying around :) More to come, probably.

• 👨‍💻 Frontend-Developer
• ✍️ Read about me on makkusu.dev
• 🎲 Interested in speedcubing, magic and a lot of other things
• 🌃 I like watching nightskies
• 🎌 Learning Japanese since '20

🧩 My Eleventy Plugins

Name	Description	Package
eleventy-plugin-readingtime	Adds a filter to display average post reading time depending on the word count	npm
eleventy-plugin-furigana	Adds furigana to kanji	npm
eleventy-plugin-index	Adds a table of contents to your post	coming soon

🚀 Github Stats

php-database-class's Issues

[FIX] SQL CONNECTION CLOSE BUG

There's a small bug with closing connection (__destruct() function). When you close connection by $db -> __destruct();, you can get error like:

mysql_close(): 6 is not a valid MySQL-Link resource in

to fix it, replace this function:
public function __destruct() {
if ($this->connected) {
mysql_close($this->connection);
}
}

to this

public function __destruct() {
if ($this->connected) {
$this->connected = false;
mysql_close($this->connection);
}
}

way off topic but cannot find contact info for you anywhere

Sorry to create an issue on this project but I can't find a way to contact you. I would like the ajax from your codepen chat project.

thank you

[FIX]Query count

If you want to somewhere echo, how many queries is running in this page, then $query_counter should be public, not private. So, next fix from me:

This:
private $query_counter = 0;

edit as this:
public $query_counter = 0;

Now, you can echo, how many queries are running in the page by
echo $db->query_counter;

Otherwise, there aren't any necessary from counting queries.