Posts in 'MySQL'
SQLite, MySQL, PHP: Ternary operator (IF() statement) in MySQL and SQLite
Posted on 03. Feb, 2010 by Dragos.
While working on a proxy checker tool for one of my projects, I was struggling on how to execute a conditional query on my SQLite database to update a column only if its value is greater than 0 (it would be pointless in my case to let the script update the column with negative values). [...]
Continue Reading
Coding:How to fetch user profile data with SSI.php from a SMF forum database
Posted on 20. Jul, 2009 by Dragos.
Even though SMF offers a way to integrate their forum into any website, they do not provide enough information on how to do some basic tasks, e.g. fetching a member’s profile details from the database. Fortunately, Netbeans has a very helpful feature, the code Navigator which shows an instant preview of all functions available in [...]
Continue Reading
WordPress: Easily Reset Your Account Password Using MySQL and PHP
Posted on 08. Jun, 2009 by Dragos.
I’ve just forgot my admin password on my local testing blog, and what is worse – my local machine is not configured to send external email. Oh yeah, got to reinstall wordpress again, what a pity. No way! There are two ways of resetting your password using two easy methods. You’ll need basic knowledge of [...]