Question

Instructions

Using Php and MySQL, database from Xampp

In this assignment, you will create an application using PHP and MySQL, incorporating all of the skills that you have learned throughout the course.

As you complete the project, be sure that you are using the correct format and syntax as well as the appropriate structure for your coding.

To move forward to the next module, you will need to demonstrate mastery by scoring an 80% or higher. If you score less than 80%, your instructor will provide you will feedback and additional resources so that you may adjust and resubmit your project.

Project Instructions

The last Chapter in our text book is titled “Putting It All Together”, this is where we create the complete Application.  This last project requires you to create an application which will include the following elements:

• Create a database
• Create a script to connect to the database
• Include script in the PHP pages that:
  • inserts data into the database
  • retrieves data in the database
  • deletes data from the database
  • updates data in the database
  • views data within the database
• You will need to build the application to connect to your database, establish a login and logout procedure, and create the other necessary components to complete the application (hint: security and cookies).
• The database can be the quotes database as referenced in the text book or you may create a database of your own choice. For example, instead of creating a quotes database you can create a database of tropical birds, or types of cars, or manufactures of computers/parts, or books recently read, etc. The database format for any of these ideas should not change, the character set size within the database should have a 100 character limit.    
• Be sure to include setting the character set and security.

Answer 1

Connect to the Database:

<?php
   $servername = "localhost";
   $username = "root";
   $password = "";
   $dbname = "databasename";

   // Create connection
   $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
   }
?>

Inserts data into the Database:

<?php

    $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
   }

    $sql="insert query'"; //ex: insert into user values('userid','username','age')
   $result=mysqli_query($conn,$sql);
   if ($result) {

        echo "row inserted successfully";
        }
   }else{
        echo "error while inserting row";
   }

?>

Retrieves data in the Database:

<?php

    $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
   }

    $sql="select query'"; //select *from user
   $result=mysqli_query($conn,$sql);
   if (mysqli_num_rows($result) > 0) {
       while($row=mysqli_fetch_assoc($result)){

            echo "$row['column1_name']";

            echo "$row['column2_name']";

            //...................

        }
   }else{
        echo "no rows found";
   }

?>

Deletes data from the Database:

<?php

    $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
   }

    $sql="delete query'"; //ex: delete from user where userid='HomeworkLib'
   $result=mysqli_query($conn,$sql);
   if ($result) {

        echo "row deleted successfully";
        }
   }else{
        echo "error while deleting row";
   }

?>

Updates data in the Database:

<?php

    $conn = mysqli_connect($servername, $username, $password, $dbname);
   if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
   }

    $sql="update query'"; //ex: update user set username='HomeworkLibstudy' where userid='HomeworkLib'
   $result=mysqli_query($conn,$sql);
   if ($result) {

        echo "row updated successfully";
        }
   }else{
        echo "error while updating row";
   }

?>