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

answered: 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);

answered: Guest

The bad fee is 12 dollars

answered: Guest

the printer can be used in a both wired and wireless network, only one of the connection methods can be used at one time when the wireless setting is enabled, the wired (ethernet) setting is disabled.

but first you need to

`connect the cord to your computer

`open settings app from the start menu

`click devices

`than click add printer or scanner

and than you should be able to do it from there, if not let me know i can you! : )

Questions in other subjects:

Mathematics, 19.11.2020 22:00

Help pls mark brainlest ...

Biology, 19.11.2020 22:00

A person develops an elevated body temperature from a bacterial infection the fever is response from the body to help...

Arts, 19.11.2020 22:00

FREE PONTS 20 pontes what character is my profile pitcher and what anima is it from right in comments and I'll tell you if u got it right than you can answer

Mathematics, 19.11.2020 22:00

PLEASE HELP WILL MAKE BRAINLIEST ...

Social Studies, 19.11.2020 22:00

What does the word analogy mean as it might be used in an informational text? A .a substitution between two equivalent concepts or things B .a comparison that an author uses...

Mathematics, 19.11.2020 22:00

The profit earned by the sales division of a company each year can be modeled by the polynomial x - x2 + 2x - 100, where x is the number of units sold. The profit earned by...

Business, 19.11.2020 22:00

Direct deposits and automatic bill payments are known as ....

Chemistry, 19.11.2020 22:00

2 red and 2 overlapping balls in the center are surrounded by a green, fuzzy, circular cloud with a white line running through it. 2 green balls sit on the white line, and a line l...

Spanish, 19.11.2020 22:00

Spanish go group verbs please help ...

English, 19.11.2020 22:00

Such as To make an inference, the reader should combine background knowledge with facts, examples, and descriptions. Albe...

Other tasks in the category: Computers and Technology More task

Answers

Other questions on the subject: Computers and Technology

Questions in other subjects: