Application utilizing MySQL, PHP With the following information, develop a backe

Question

Application utilizing MySQL, PHP

With the following information, develop a backend database and then create the PHP to communicate with the database and enter & retrieve information. App can be made using bootstrap or CSS code.

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)

Explanation / Answer

$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();

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.