Posts

Showing posts with the label MYSQL

How to fix "url /phpmyadmin was not found in this server" problem in Ubuntu (linux)?

Sometimes after installing LAMP, when you try to open the phpmyadmin in your browser you might get the error like this: "Not Found The requested URL /phpMyAdmin was not found on this server. Apache/2.2.12 (Ubuntu) Server at localhost Port 80" This is likely to be caused by not checking apache2 during installation. To reinstall you can use the following command:

How to install LAMP in Ubuntu (linux)

LAMP stands for Linux, Apache, MySQL and PHP/Python. Installing and configuring LAMP is not a very complicated thing in Ubuntu, its just a matter of few lines of commands via the command line. This post will show you how to install PHP5, Apache2, MySQL and phpMyAdmin in Ubuntu. Installing Apache 1. Open the terminal and type the following command.

SQL Injection and its prevention in PHP

What is SQL injection? SQL injection is one of the common attacks in web industry which uses SQL statements in the web form to execute a query in the wrong way and make attacks like making an unauthorised login or making wrong access to the data in the database. SQL injection usually occurs when users are asked for inputs through the HTML forms. Let us see a common example of SQL injection. Suppose we have a user login form that asks for their username and password. We use select statement for validating the username  which is stored in the database.