Review : Crystal Database Wrapper for PHP

Crystal Database Wrapper for PHP
One of the sites i keep an eye on is greepit.com to know about some of the latest and coolest tools in web development. I came across this new Database Library or wrapper called Crystal database wrapper. The library really looks promising and in fact appears to be minimalistic as they claim. They also have a data validation module and manipulation module which is all you need to create basic to intermediate apps. From the user guide i looked at some of the examples of CRUD and i just felt it’s Active Record from Codeigniter. As i did a lot of Codeigniter sites so far, it just looked so comfortable to me. Just for an example.

 

Read More

Sorting table columns in mysql by adminer

Sorting columns in a mysql table has always been a nasty way to deal with. It can be done some sql commands of course but this is not what we do more often. Even the most popular DB admin package – phpmyadmin doesn’t provide such utility to sort or re-arrange fields in mysql. It occurred to me a lot of times that i had to bring some filed to a different position for convenience after i first created it. But i had to run some queries which i never liked, to do this task.

So ADMINER (formerly phpminadmin) comes up with a nifty utility in their one file standalone package.

If you haven’t heard of Adminer yet (you must have missed a great tool), download from http://www.adminer.org/en/

And run it from your web server from any location. After entering credentials and selecting database, just select a table from the left which appears like this.

adminer_table_select

Now you get some options like – Alter table   |   Default values  |   Select table  |  New item

Select Alter Table and you get a screen like this

adminer

Alright, you pretty know what to do with those up and down arrows now. Don’t forget to save the changes 🙂

PhpMinAdmin – nearest alternative to phpMyAdmin

I can’t possibly tell how many times i’ve been seriously irritated  navigating to phpmyadmin option of my hosting or hostings of the projects i have worked with. Most of the cases you’ll have to click many times. And in Plesk ? It simply sucks when it comes to use phpMyAdmin from there. I’ve always used phpminiadmin as a quick alternative solution because it needs no configuration and no install. But it’s very basic and needs too much typing to get things done. Today I found phpminadmin. It’s just the name without the i in php phpminiadmin. It simply rocks!! It has nearly every option that you’d normally expect from a db admin tool. And to me, it’s a substitute to phpmyadmin for ongoing operations.

phpminadmin screenshot

It has select, search, edit, index , create — almost everything u need. The best part is that it needs no install and it’s a single file weighing about 167KB.

But of course, i’m not saying it’s a fully alternative to phpmyadmin. No way. They have been developing this mighty tool for over nine years.  But phpminadmin surely is a very very good altenative of that for quick solutions. Check it out here.

http://phpminadmin.sourceforge.net/

Why didn’t I find it earlier ?  🙁

UPDATE : THE PROJECT HAS BEEN RENAMED TO “adminer” AND IS AVAILABLE at http://www.adminer.org/en/

Partners Section:

depfile password Depfile Premium Account Depfile Premium Depfile Premium Account Depfile Premium Depfile Premium Account Depfile Premium Account dep file Dep file dep file dep file dep file dep file Depfile Premium Account Depfile Premium yify torrent empire torrent yify vikings season 4 auto clicker autoclicker slender the eight pages he gift torrent walking dead torrent the walking dead torrent fl studio 12 torrent