Hello, For this assignment I'm tasked with having a user input data into a registration form.(registration.html) Once they hit submit, a confirmation page will download (print view) with the user's...

cit647studentsconcertsprofiles.sql
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https:
www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Jul 06, 2021 at 04:48 AM
-- Server version: 5.7.23
-- PHP Version: 7.1.28
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
*!40101 SET NAMES utf8mb4 */;
--
-- Database: `cit647studentsconcertsprofiles`
--
-- --------------------------------------------------------
--
-- Table structure for table `cit647studentsconcertprofilestable`
--
CREATE TABLE `cit647studentsconcertprofilestable` (
`RowNum` varchar(250) NOT NULL,
`FirstName` varchar(250) NOT NULL,
`LastName` varchar(250) NOT NULL,
`PhoneNum` varchar(250) NOT NULL,
`Email` varchar(250) NOT NULL,
`EventDate` varchar(250) NOT NULL,
`CreatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `cit647studentsconcertprofilestable`
--
ALTER TABLE `cit647studentsconcertprofilestable`
ADD PRIMARY KEY (`RowNum`);
COMMIT;
*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Confirmation.php


        
Home

        
About/Details

        
Get Started

         Video Links

        
Contact Us

        
Register Now




home
|
about
|
registration
|
contact
|
For Further Support Email: Anurag Sinha
Confirmation_original.php
Registration
        Home
        About
        Contact
        
        
        
Search
        
Menu
        
Home
Go to the home page.
        
About
Get details about the concert series.
        
Contact
Reach out to us for additonal info.
Confirmation
home
|
about
|
egistration
|
contact
Index.html



        
Home
        
About/Details
        
Get Started
         Video Links
        
Contact Us
        
Register Now



"Mind Over Matter is The Key to Everlasting Peace- Maya J"
Welcome to Meditation Central




Hello! Let's Walk This Journey Together!
Welcome to Meditation Central! The ultimate guide to navigating through your spiritual journey.

We train you with the best methods to mediate at home, in the office, or on the go! Wether live or pre-recorded you can watch or re-watch videos from our instructors to help you find inner peace.

Please review our website and have fun!


home
|
about
|
registration
|
contact
|
For Further Support Email: Anurag Sinha
RegForm.php
?php
create connection
$con = mysqli_connect('localhost','root','123456');
check connection
if (!$con) {
die("Connection failed: " . mysqli_e
or($con));
}
echo "Connected successfully.";
select database
mysqli_select_db($con,"CIT647StudentsConcertsProfiles");
create random unique ID for RowNum field
$pattern = "1234567890";
$RowID = $pattern{rand(0,10)};
for($i = 1; $i < 10; $i++)
{
$RowID .= $pattern{rand(0,10)};
}
store form name in variables
$FirstName = $_POST["FirstName"];
$LastName = $_POST["LastName"];
$PhoneNum = $_POST["PhoneNum"];
$Email = $_POST["Email"];
$EventDate = $_POST["EventDate"];
sql to create test table
$sql = "INSERT INTO CIT647StudentsConcertProfilesTable (RowNum, FirstName, LastName, PhoneNum,Email,EventDate) VALUES ('$RowID', '$FirstName', '$LastName', '$PhoneNum','$Email','$EventDate')";
if (mysqli_query($con,$sql)) {

echo "Record add successfully.";
?
.container {
width: 795px;
margin: 0 auto;
}
section {
position: relative;
height: 280px;
width: 100%;
background-image:...