"Linux" in Ubuntu development environment for graphical lamp

In accordance with the "Linux" layout lamp environment in Ubuntu (click to open the link) to do a good job in the lamp environment, you can use the Gredit text editor to write PHP, and then use the terminal to query the contents of MySQL, but this environment is very rough, no development of the IDE , query the database also to enter a lot of commands, not suitable for PHP development.

At this point you can install Aptana as IDE for PHP development, this tool has been introduced in "HTML" a good front-end development of Ide--aptana Studio (click the Open link) has been described. Using MySQL Workbeach as a graphical version of MySQL in Ubuntu, because MySQL Gui tools in Ubuntu because the versions are too old, Ubuntu 12.04 below has been unable to start MySQL administrator with MySQL The query browser. Moreover, MySQL Workbeach is actually more useful than MySQL Gui tools.

First, Phpide--aptana download, installation, use

1. Open Aptana Studio's official website http://www.aptana.com/products/studio3/download (click the Open link), select the appropriate version of the Linux operation Aptana click Download. This site is not a wall, just if your Internet connection is not good, it is difficult to open.

2, 32-bit Linux For example, after downloading to get aptana_studio_3_setup_linux_x86_3.6.1.zip, put in Pc/home is your main file, directly extracted.

3, after the proposed to get a Aptana Studio 3 actually can be used here. This is the same green version as Eclipse. At the same time, the original downloaded compressed files, right-click, throw into the trash and empty.

4, after, and "Android" using Adt-bundle under Linux easy to build Android development environment and Hello World (click Open Link), for the inside of the Aptanastudio first create a link, do not directly copied to the desktop, As with Windows, you must first create a shortcut for the. exe and not just drag it to the desktop.

5, to be dragged is a shortcut

6. After that, to rename the shortcut on the desktop, change its icon. Change the selection properties of the icon.

7. In the Open Properties window, click the icon

8, find just Aptana was extracted target, select its inside the icon file icon.xpm

9, open Apatan do not configure what, directly right-click Var/www such as New file, choose New from template->php->php Template to write

10, debugging, directly open the Ubuntu self-brought wild Fox Zen Browser, input http://127.0.0.1/xx.php can access

Second, using MySQL workbeach to make MySQL graphical

1, this thing with sudo apt-get install command installation is very troublesome, and the installation of MySQL Workbeach is not the latest version, the best is their own MySQL Workbeach official website http://dev.mysql.com/ downloads/workbench/(click the Open link) to download, this is also the MySQL official own works. Select looking for previous GA versions, because the latest version already does not support Ubuntu12.04, find the 6.0.9 version, choose Ubuntu Linux 12.04 32-bit or 64-bit download.

This website if the network speed is not good, this drop-down menu is out of the, after all, this site some JS loading, resulting in the Web page looks complete, but the actual is not complete.

2, after downloading, get mysql-workbench-community-6.1.7-1ubu1204-i386.deb, directly double-click the installation, let you enter the system's password directly input. When the Ubuntu Software Center appears, click Install to install it automatically.

3, after successful installation, open usr/share/applications This folder, find the MySQL workbench this shortcut, directly copied to the desktop. Usr/share/applications This folder directly stores a bunch of shortcuts to existing programs.

4, double-click the desktop shortcut to open, select the existing link, in the pop-up window directly select Connect

5, after entering the database password root, it is best to save the password to the Linux password chain.

6, for the system's password chain to read and write must enter the Ubuntu System Password Admin, and the above database password is different, pay attention to the difference do not confuse.

7, open MySQL, such as, close some of the things not. What really works is the following schemas, which is a bunch of our database, also called strategy. If the key is not good, point to point to the button did not respond, restart Ubuntu is normal, although very funny, but it is so strange.

8. You can create a new database by right-clicking in the policy area or in the blank area of the database.

9, enter the name of the database, the key is to choose a good database encoding, directly select Utf-8, lest you do anything to change the code, annoying!

10, click OK, will display the corresponding SQL statement, directly select Apply, then complete the creation.

11. Right-click the tables under the corresponding database to create a table

12, after the same as in Windows old MySQL Gui tools, PK for the primary key, nn for non-null, AI representatives automatically incremented.

13. After selecting OK, the corresponding SQL statement is displayed. Select Apply to complete the creation.

14. After that, you can enter the SQL statement in the blank area at the top right to complete the query.

"Linux" in Ubuntu development environment for graphical lamp