Posts

How to create a full fetched crud web application using php and mysql

Image
Step 0: Approach Let's think about what to expect from my web application. Suppose I am going to create a complete note/crud page, where I can add, read, update and delete my notes. For this I need a database and some sorts of tables, we will think about what tables are required later, but let's select the database named as " notes ".  Note : WE ARE GOING TO USE LOCALHOST AS USERNAME AND BLANK("") AS PASSWORD FIELD.  Step 1:  Creating a connection <?php $server = "localhost" ; $username = "root" ; $password = "" ; $database = "notes" ; $conn = mysqli_connect ( $server , $username , $password , $database ); if (! $conn ){     echo "Failed to connect to DB" ; } ? > Creating a connection is the easiest way to start with while making any PHP application. We are going to use mysqli extensions to communicate with database. First of all create a folder named as your preferred choice name and open it with