code-diesel
/* PHP & MySQL Journal */
Archive for the ‘mysql’ Category
Browser based SQL schema designer
3 Feb 2009WWW SQL Designer is a free database designer. It allows developers to create database schemas using a graphical interface. The designs can be further saved/loaded and exported to SQL scripts. The software supports a number of databases and languages.
- (2) Comments
- Tags: mysql, sql, tools
Sidu – a Free MySQL client
6 Nov 2008MySQL Sidu is a FREE MySQL client which works via a web browser. Written in php (on surprise there!), MySQL Sidu is a simple and easy to use database tool. Sidu stands for Select Insert Delete Update. Of course Sidu can do more jobs than these. Many of you may already be using other MySQL [...]
- Comments Off
- Tags: mysql
converting MySQL queries to xml
5 Aug 2008There frequently arises a need to return mySQL query results in xml. Maybe you need to send the xml data to the browser or you want to use it as a xml request to a web service; whatever the application, the following function will return the result of a sql query in xml format.
The [...]
- (3) Comments
- Tags: mysql, php
Sorting MySQL rows using column values
In: mysql
25 Jul 2008In MySQL it is easy to sort rows by using the ORDER BY clause on the column name. Recently on a client request the sort had to be done using the column values rather than the name. Since I had never come across sorting using values, a couple of minutes of searching was in order; [...]
- (1) Comment
- Tags: mysql
6 books to master PHP
21 Apr 2008PHP is a wonderful dynamic language, and the addition of Unicode support, namespaces in the upcoming version 6 will make it even better.
If you are new to PHP or are thinking of moving to PHP form other language then the following list of books will provide you with the required knowledge to become a seasoned [...]
- (11) Comments
- Tags: php, software
