ExtraDRM : Design Ressource Management

Web content and data design solutions

Browsing Posts in Databases engines

Shell Mongo : > mongo Once you are in terminal/command line, access the database/collection you want to use as follows: show dbs use <db name> show collections choose your collection and type the following to see all contents of that collection: db.collectionName.find() for a query below some samples : db.products.find({ “_id”: “apples”, “qty”: 5 } [...]

Introduction Since PHP 5.4, the original MySQL extension is obsolete and will generate alerts E_DEPRECATED level when connecting to a database. Instead, we can use the MySQLi extension or PDO_MySQL extension. If like me, you have sites with the MySQL extension, here are some small examples to switch to MySQL MySQLi (which I find easier [...]

This is more of personnal notes/code braindump to remember how to do. I will expose you two methods for using javascript calls via DOM and Ajax/Jquery to process mysql queries … Before starting, I like to recall how Jquery works : Create an example.php document prepare a bloc div like : <div id=”avatarsavediv”></div> The XMLHttpRequest [...]