OK, As we now know how to connect to amazon EC2 instance remotely, it's time for us to go ahead one step ahead to install LAMP stack on Ubuntu EC2 server instance. We will install Apache, PHP and MySQL separately and will bind them together and get working by ourselves. Those who need help installing LAMP Stack on CentOS 7 may use the guide found on this page … [Read more...] about How To Install LAMP Stack On Ubuntu Server
mysql
Basics On Doctrine CRUD Operations
Some developers don't start using doctrine in their application just because they find it a little difficult to get started(I listened so from some of my own friends too). And unluckily, I also faced some similar issues as well. I tried to start it at a very early time when I was new in LAMP(Linux, Apache, MySQL And PHP Environment) and found it a little difficult to understand … [Read more...] about Basics On Doctrine CRUD Operations
Beginning With MySQL Stored Procedure Programming
While doing database programming, we mainly focus on SQL statements that do 'select','insert','update','delete' operations with some conditions 'where','like' and some orders 'group by', 'order by'. For a little complex goal, use join operations. MYSQL database is a very popular name in web applications development, specially for small and medium scale applications. Moreover, … [Read more...] about Beginning With MySQL Stored Procedure Programming
Primary/Foreign Key Constraints On MySQL
We, software developers, sometimes take the headache to solve such problems which actually has very easy/integrated solutions, we just don't know that it does exist and don't know how to use the solution. In this tutorial, I will try to discuss such an issue on database management. For small/medium scale applications, developers usually take care of the database part also, … [Read more...] about Primary/Foreign Key Constraints On MySQL
Basic MySQL Best Practices
Software developers, now a days, usually use to work in various fields of programming and development. Such as UI design, server-side programming(even in various languages like PHP, Asp.NET etc) and database management as well. In each area, if we use and follow some traditional best practices. Then they always be organized and easy for keeping track time to time among other … [Read more...] about Basic MySQL Best Practices