code-diesel
/* PHP & MySQL Journal */
Archive for the ‘tools’ Category
SchemaBank: Browser based SQL schema designer
24 Apr 2009Whether desktop or web based, there has recently been a proliferation of SQL design tools on the net. SchemaBank may look like one more in the box. But a detailed look at the features will show you more on offer. SchemaBank is a visual data modelling tool which can help you create ERD diagrams within [...]
- Comments Off
- Tags: mysql, PostgreSQL
Free Geolocation API tool
In: tools
12 Apr 2009NOTE: http://www.ip2location.com have done away with the free api access from their site. So the following sample code will no longer work. They now provide a free sample database on their site and also a complete paid version.
iplocationtools.com offers a free geolocation API that lets you query with an ip address and get the [...]
- (14) Comments
- Tags: curl, data
Detecting duplicate code in PHP files
6 Apr 2009Duplicated code in projects is a frequent thing and also the one ripe for factoring out in a new class or function. Cut/Paste coding is a common development practice among programmers, a lot of which can lead to code size increase and maintenance nightmares. PHPCPD (php copy paste detector) is a PEAR tool that makes [...]
- (8) Comments
- Tags: testing, tools
Checking coding standards with PHP_Codesniffer
In: tools
30 Mar 2009One of the important factors in developing a successful software product is the application of coding standards. And by successful I mean a product that is easy to develop, modify and maintain. Every developer likes to code in a particular style: in the way he declares variables or function blocks, the number of indentation spaces, [...]
- (2) Comments
- Tags: coding, standards, tools
6 essential cURL commands for daily use
In: tools
24 Mar 2009cURL is a command line tool for doing all sorts of interesting and essential URL manipulations and data transfers. The original goal of the program was to transfer files programmatically via protocols such as http, ftp, gopher, sftp, ftps, scp, tftp, and many others, via a command line interface. The main benefit of using the [...]
- (4) Comments
- Tags: curl
Transferring large PSD files quickly using Diff-Patch
In: tools
18 Mar 2009Recently for a small design work a creation of a Photoshop PSD document was required. Being a high resolution image the file size went up to something around 85MB. Zipping the document brought down the size to a manageable 35MB (but still quite large for my net connection) . As all designers know, frequent modifications [...]
- (1) Comment
- Tags: photoshop
6 excellent charting libraries for php
15 Mar 2009Charts are an indispensable part of any data visualization work. People can grok visual representation of data easily than a textual variety. Today there are a huge number of free chart libraries available to display visualizations on websites. Below is a small list of some of the libraries available for displaying charts using php.
- (28) Comments
- Tags: charts
Web scraping tutorial
7 Mar 2009There are three ways to access a website data. One is through a browser, the other is using a API (if the site provides one) and the last by parsing the web pages through code. The last one also known as Web Scraping is a technique of extracting information from websites using specially coded programs.
- (16) Comments
- Tags: scraping, tools
HeidiSQL – Lightweight MySQL IDE
18 Feb 2009HeidiSQL is an easy-to-use ide for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface. With a download size of less than 2Mb, it is quite lightweight and fast to load.
- (3) Comments
- Tags: mysql
In part 1 of this tutorial you have seen how to write a simple web test using Selenium. In this part we will see how to use the test generated using the IDE with Selenium RC and PHPUnit.
- (61) Comments
- Tags: selenium, testing
