Question
Application utilizing MySQL, PHP, Javascript With the following information, develop a backend database, create the PHP to communicate with the database and enter & retrieve
Application utilizing MySQL, PHP, Javascript
With the following information, develop a backend database, create the PHP to communicate with the database and enter & retrieve information, and implement JavaScript front end capabilities such as captcha verification. App can be made using bootstrap or CSS code. Authentication will performed, but the username and password may be hardcoded. That is, the employee will call you to register, and you will email them a username and password.
Information to be utilized (employer):
Employer:
Text Box: Name of the Company, Name of the Manager, Address, Phone, Email
A company may post many positions. For each position, provide:
Text: Position Title
Text: Description
Drop Down: Location of the position (state)
Top 3 Skills: Skill (Pull Down), Experience: Pull Down - 0, 1-3, 3-5, 5-10, 10+
Need: Radio: Urgent (<1 month), Soon (1-3 months), Upcoming (3+ months)
Code so far:
$servername = "localhost";
$username = "root";
$password = "1234";
$dbname = "company";
$connection = mysqli_connect("localhost" , "root" , "1234" , "company"); //It will connect you to database
if($connection == false)
{
die("connection failed");
}
$insert = INSERT INTO company (company , managername , address , phone , email) VALUES ('ABC' , 'swati' , 'rubyt park pune' , 8877665544' , 'swati@abc.com')
if($connection -> query($insert) == true)
{
dei("record entered successfully");
}
$retrieve = SELECT * from company
if($connection -> query($retrieve) == true)
{
dei("record found successfully");
}
$conn->close();
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started