Computers and Technology, 11.04.2020 04:47 sarahmckee69

You need to implement a web application that is split in three parts, namely, Webpage, PHP and MySQL. Each of them will be used accordingly to solve a simple problem described below. Remember to implement the logic in the most secure way of your knowledge.

PHP

Implement a PHP function that reads in input a string from the user and store it in a table (e. g., in a field called "Content Name").
The function should be able to read the content of the file and store it in a table (e. g., in a field called "File Content").
The web application should be able to implement a logic to log in and sign up users.
Each user will have exclusive access to her/his uploaded material.
When a user logs in, all her/his private content will be displayed on the web page.
If no user has logged in yet, no information from the database are printed on the webpage.

Webpage

The user must be able to upload a text file (and nothing more!).
The user must be able to input a string, using a text box.
The webpage allows users to input their credentials for both logging in and signing up.
After a user logs in, the webpage prints in output her/his personal material from the database, that is, the content of each file with the specified name.
If there is no material yet, nothing is showed for that specific user.

MySQL

You need to create a database that contains at least two tables. One to store the information in input to the webpage, the other to store the users credentials.
The "credentials table" should contain at least these fields: email, username and password.
SUBMISSION

You need to submit your web application in a .php file, no other formats is allowed.
You don't need to submit your 'login. php' file.
No details about the database need to be submitted.

Answers: 3

Show answers

Answers

Answer from: kimberlylove387

Check the explanation

Explanation:

index.php

<!DOCTYPE html>

<html lang="en">

<head>

</head>

<body>

<h1>Login Portal</h1>

</form>

</div>

</section>

</body>

</html>

<?php

session_start();

$con=mysqli_connect("localhost","root","","storage");

if(!$con)

{

die("connection failed" .mysqli_connect_error());

}

$e=$_POST["email"];

$p=$_POST["pwd"];

$sql="select * from `account` where `email`='$e' and `password`='$p'";

$res=mysqli_query($con,$sql);

if(mysqli_num_rows($res)>0)

{

$_SESSION["email"]=$e;

include 'profile.php';

}

else {

echo "no such username";

include 'admin.php';

}

mysqli_close($con);

admin_signup.php

<!DOCTYPE html>

<html lang="en">

<head>

</head>

<body>

<h1>Signup Portal</h1>

</form>

</div>

</section>

</body>

</html>

signup.php

<?php

session_start();

$con=mysqli_connect("localhost","root","","storage");

if(!$con)

{

die("connection failed" .mysqli_connect_error());

}

$u=$_POST["uname"];

$e=$_POST["email"];

$p=$_POST["pwd"];

$sql="INSERT INTO `account`(`email`, `username`, `password`) VALUES ('$e','$u','$p')";

mysqli_query($con,$sql);

mysqli_close($con);

include 'admin.php';

upload file (profile.php)

<!DOCTYPE html>

<html lang="en">

<head>

</head>

<body>

<h1>Login Portal</h1>

</form>

<p > <a href="view.php">to view your content , click here</a></p>

</div>

</section>

</body>

</html>

content.php

<?php

session_start();

$con=mysqli_connect("localhost","root","","storage");

if(!$con)

{

die("connection failed" .mysqli_connect_error());

}

$handle = $_FILES['filename']['tmp_name'];

echo $handle;

$d=$_POST["docname"];

$e=$_SESSION["email"];

$c=file_get_contents($handle);

$sql="INSERT INTO `info`(`email`, `docname`, `content`) VALUES ('$e','$d','$c')";

mysqli_query($con,$sql);

mysqli_close($con);

include 'admin.php';

to view content , view.php

<?php

session_start();

$con=mysqli_connect("localhost","root","","storage");

if(!$con)

{

die("connection failed" .mysqli_connect_error());

}

$e=$_SESSION["email"];

$sql="select * from `info` where `email`='$e' ";

$res=mysqli_query($con,$sql);

if(mysqli_num_rows($res)>0)

{

while($show=mysqli_fetch_assoc($res))

{

echo $show["docname"]."\n".$show["content"];

}

else {

echo "no content till now";

}

mysqli_close($con);

Answer from: Quest

The best way she can do it is by doing the mentioned expirement but explaining it as a volcano eruption

Answer from: Quest

Check with your teacher

Another question on Computers and Technology

Computers and Technology, 21.06.2019 15:30

Communication is the exchange of information. true or false?

Answers: 1

Answer

Computers and Technology, 22.06.2019 21:30

How do you take a green screen out of the video while editing?

Answers: 2

Answer

Computers and Technology, 23.06.2019 18:30

List 3 items that were on kens resume that should have been excluded

Answers: 1

Answer

Computers and Technology, 24.06.2019 08:30

Why might you choose to create a functional resume

Answers: 1

Answer

You know the right answer?

You need to implement a web application that is split in three parts, namely, Webpage, PHP and MySQL...

Questions

Mathematics, 08.04.2020 15:37

A bike wheel is shown. Chords I J and L K intersect at point M. The length of I M is 16 centimeters, the length of M J is 7 centimeters, the length of...

History, 08.04.2020 15:37

Why did the founders establish a confederate system upon declaring independence?...

Mathematics, 08.04.2020 15:37

Help me it the right side I didn’t mean to put the left side

History, 08.04.2020 15:37

Which term best describes the American Indians living in Georgia at the time of the year of European contact...

Mathematics, 08.04.2020 15:37

The probability that a pupil in a class has a calculator is 0.87. what is the probability that the pupil does not have a calculator? in a fraction?...

History, 08.04.2020 15:37

According to your graph, between 1790 and 1830, pig iron production What was the general trend in pig iron production between 1720 and 1860?

English, 08.04.2020 15:37

The dog] experienced a vague but menacing fear that subdued it and made it slink along at the man's heels, hoping that he would go into camp or seek s...

Biology, 08.04.2020 15:37

What do catalytic converters do?...

Computers and Technology, 08.04.2020 15:37

Kevin wants an application that will help him create a website as well as publish it. What application can he use? A. WordPress

Mathematics, 08.04.2020 15:37

Kenny uses 1/16 of the chocolate syrup bottle for every scoop of ice cream that he eats . How many scoops of ice cream has Kenny eaten if he has used...

Chemistry, 08.04.2020 15:37

Discuss the differences between the planetary model of atoms and the way that Thompson and Rutherford described them. What are the experiments which t...

Mathematics, 08.04.2020 15:37

Quadrilateral OPQR is inscribed inside a circle as shown below. what is the measure of angle O? you must show all work and calculations to receive cre...

Physics, 08.04.2020 15:38

You plunge a basketball beneath the surface of a swimming pool until half the volume of the basketball is submerged. if the basketball has a radius of...

Biology, 08.04.2020 15:38

When water condenses in clouds to then precipitate as rain, it changes state from...

Physics, 08.04.2020 15:38

Why do photons take so much longer than neutrinos to emerge from the sun?...

Engineering, 08.04.2020 15:38

Write a c++ program that reads the contents of a file containing integer numbers, then for each number calculate the sum of its digits and print...

Mathematics, 08.04.2020 15:38

A lunette is a semicircular window that is sometimes placed above a doorway or above a rectangular window. A certain lunette has a diameter of 40 in....

Mathematics, 08.04.2020 15:38

Kay scored above 90% on five of her math quizzes, 80% to 90% on fourteen of them, and 70% to 80% on two of them. What is the experimental probability...

Mathematics, 08.04.2020 15:38

Kimberly Family invested in a certificate of a deposit (CD)for her when she was born the interest is compounded quarterly. What will be th...

English, 08.04.2020 15:38

Lines 1–13: Who is Kennedy’s audience for this speech? What is Kennedy’s likely purpose? Which words hint at this purpose?...

More questions: Computers and Technology Another questions