How do I setup php+My sql development environment

Question

How do I setup php + My sql development environment in Ubuntu ?

Solution 1

http://www.iasptk.com/ubuntu/20463-apache2-with-php5-and-mysql-support-on-ubuntu-server

Apache2 With PHP5 And MySQL Support On Ubuntu Server

LAMP is short for Linux, Apache, MySQL, PHP.

Install an Apache2 webserver on an Ubuntu Server with PHP5 support (mod_php) and MySQL support.

Installing MySQL 5

sudo apt-get install mysql-server mysql-client

Installing Apache2

sudo apt-get install apache2

Apache's default document root is /var/www on Ubuntu, and the configuration file is /etc/apache2/apache2.conf. Additional configurations are stored in subdirectories of the /etc/apache2 directory such as /etc/apache2/mods-enabled (for Apache modules), /etc/apache2/sites-enabled (for virtual hosts), and /etc/apache2/conf.d.

Installing PHP5

sudo apt-get install php5 libapache2-mod-php5

We must restart Apache afterwards:

sudo /etc/init.d/apache2 restart OR sudo service apache2 restart

Getting MySQL Support In PHP5

To get MySQL support in PHP, we can install the php5-mysql package. It's a good idea to install some other PHP5 modules as well as you might need them for your applications. You can search for available PHP5 modules like this:

apt-cache search php5

Pick the ones you need and install them like this:

sudo apt-get install php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl

Now restart Apache2:

sudo /etc/init.d/apache2 restart OR sudo service apache2 restart

Xcache is a free and open PHP opcode cacher for caching and optimizing PHP intermediate code. It's similar to other PHP opcode cachers, such as eAccelerator and APC. It is strongly recommended to have one of these installed to speed up your PHP page.

Xcache can be installed as follows:

sudo apt-get install php5-xcache

Now restart Apache:

sudo /etc/init.d/apache2 restart OR sudo service apache2 restart

phpMyAdmin

phpMyAdmin is a web interface through which you can manage your MySQL databases.

sudo apt-get install phpmyadmin

Solution 2

sudo apt-get install tasksel
sudo tasksel

• select LAMP

Comments

[Sanam Patel]

Someone flagged this for closure as 'not a real question', probably based on the second sentence. This answer may help with the first part, and you might edit out that second part and try it on one of the other SE sites? I'm choosing 'Leave open' based just on the first part.

[Tachyons]

@Tom Brossman: Rollbacked, BTW I can't see any close votes on this question

[Nanne]

Its way to broad, isn't it? do you mean how you install LAMP? Or eclipse with PDT? Debugger? What have you tried/where are you stuck, what do you want exactly?

[Sanam Patel]

There are some good answers below. Are you not interested in the web server part and wanting to focus only on PHP and MySQL?

[Tachyons]

Thanks for the answer, BTW How to run my first php script?. I am an absoulte noob in webdevelopment :)

[Tachyons]

Thanks for the answer, BTW How to run my first php script?. I am an absoulte noob in webdevelopment :)

[Simon Hoare]

Open up Gedit. Type <?php phpinfo(); ?>. Save the file as info.php and put it in your /var/www directory. Then go to localhost/info.php in your browser and you will see your PHP details. Basically every PHP file works in the same way. However, a very smart cookie by the name of Alex has done a load of videos on Youtube as PHPacademy and for The New Boston. I suggest you start there and just ignore all the stuff about XAMPP. You have your server.

[Vidyadhar]

you can do the same with the single command "sudo apt-get install lamp-server^"

[Simon Hoare]

even better, Vidyadhar

[storm]

OP's question is not about installing xdebug php module.

[Siraj]

I know, you are right. But this post kept showing up when I was searching on how to do this. Since it was a little bit of a pain, I posted here. Sorry if there was any confusion.

[Siraj]

Also, OP was how to setup development environment. Debugging is a very important part of the development environment and should also be explained. If it is prudent, I can add the mysql setup process into this post as well.

[Muhammad Omer Aslam]

sudo apt-get install phpmyadmin get the php8.0 extensions along i have 7.3 installed how to install phpmyadmin specific to PHP 7.3