10
Nov 11

Using an HTTP tunnel to connect with a remote MySQL server

Most hosting providers won’t let you connect to MySQL remotely, if you feel like PHPMyAdmin is a slow method to manage your databases you can opt for a desktop manager like Navicat (Windows,Mac OS X,Linux) or EMS SQL Manager (Windows) and define an HTTP tunnel as a connection method. Continue reading →


09
Nov 11

Synchronize PHP Web Forms with MySQL table fields

I have writen this  PHP Class a couple of years ago, its very practical for small systems in order to speed up maintenance.

Can be used to:

  • Generate form to edit data stored in MySQL databases.
  • It can generate HTML forms with several types of fields, executing SQL queries to retrieve the default values of the MySQL database table fields.
  • The class can generate text or textarea form inputs depending on length of the database table text fields.
  • It can also generate checkbox, radio, and select inputs to edit enum or set database table fields.
  • The output can be customized with configurable CSS styles and Javascript code.
    Continue reading →

08
Nov 11

Installing Windows applications on Mac OS X Lion using wine

What is Wine?

Wine let you run Windows software  on Unix-like operating systems, Mac OS is one of them. With wine, you can install and run these applications just like you would in Windows.
Continue reading →