PHP, SQL : Apache (ports 80 & 443) and MySQL (port 3306)

Need to add functionality to edit and delete review

Example:

$query="DELETE FROM entries WHERE id={$_POST['id']} LIMIT 1";

$r=mysqli_query($conn,$query);

if (mysqli_affected_rows($conn)==1) {

//it worked!

}

$query="UPDATE entries SET name='$name', review='$review' WHERE id={$_POST['id']}";

$r=mysqli_query($conn,$query);

if (mysqli_affected_rows($conn)==1) {

//it worked!

}

Settings for creating MySQL Account:

creds.php

$username = "reviews_system";

$password = "foobar";

$host = "localhost";

$database = "reviews";

$conn = @mysqli_connect($host, $username, $password, $database);

?>

read_reviews.php

Reviews

require("creds.php");

$query = 'SELECT * FROM entries ORDER BY date_entered DESC';

if($r = mysqli_query($conn, $query)) {

while($row = mysqli_fetch_array($r)) {

print "

{$row['name']}

{$row['review']}

Edit

Delete

---

";

}

}

mysqli_close($conn);

?>

 

Transcribed Image Text:

Create a user with the following information: Username: reviews_system Hostname: localhost Password: foobar Add user account Login Information User name: Host name: Password: Re-type: Authentication Plugin Generate password: Use text field: Local Use text field: Generate reviews_system localhost Strength: Native MySQL authentication ✓ Extremely weak Create a user with the following information: Username: reviews_system Hostname: localhost Password: foobar Add user account Login Information User name: Host name: Password: Re-type: Authentication Plugin Generate password: Use text field: Local Use text field: Generate reviews_system localhost Strength: Native MySQL authentication ✓ Extremely weak

Answer rating: 100% (QA)

Question General Guidance The answer provided below has been developed in a clear step by step mann... View the full answer