Solution
Anurag answered on
Jul 06 2021
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:...