Install CakePHP TextMate bundle in E Texteditor

1 Comment »

This is a guide to manually installing the CakePHP TextMate bundle in the TextMate Windows equivalent E TextEditor.

Click to continue reading “Install CakePHP TextMate bundle in E Texteditor”

1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading ... Loading ...

HTML in MySQL via PHP (also prevention of SQL injection)

1 Comment »

Usually I insert data into a MySQL database through PHP using something like


$mysql_query = "INSERT INTO table SET name = '$name', age = '$age'"

etc.

However, if I want to insert something that contains the ‘ character, I will get a MySQL error. Instead of manually handling all this stuff, PHP offers the function mysql_real_escape_string() which solves this problem. It also prevents SQL-injections, and thus it is recommended that all user-input be handled by this function before the MySQL insert is done.

An example


$mysql_query = "INSERT INTO table SET name = '". mysql_real_escape_string($name) ."'";
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 1.00 out of 5)
Loading ... Loading ...

Install Eric Python IDE on Windows

No Comments »

I assume that you have installed Python.

  1. First of all, Eric needs a few prerequisites which are (fortunately) available from http://www.riverbankcomputing.co.uk/software/pyqt/download
  2. Download the binary packages for windows.
  3. Download Eric.
  4. Install the binary packages.
  5. Extract Eric to a place of your choosing.
  6. Run install.py
  7. Run [c:\ericdir]\eric\eric4.py and you’re off!
1 Star2 Stars3 Stars4 Stars5 Stars (10 votes, average: 4.90 out of 5)
Loading ... Loading ...