mySQL Question

Question

Quick question using mySQL.

My Code:

<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "oopdb";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM boxes";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
     //output data of each row
   while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"] . " "  . $row['firstname'] . '<br />';
    }
} else {
    echo "0 results";
}

// Here is where I delete a row with the id of 2
$deleteJohn = "DELETE FROM boxes WHERE id = 2";
if ($conn->query($deleteJohn) === TRUE) {
    echo "row deleted successfully";
} else {
    echo "Error deleting row: " . $conn->error;
}

$conn->close();
?>

Question:

Where you see me delete a row from my boxes table do I need to keep the actual code in my files because it seems that when I save the row with the id of 2 gets deleted and even if I remove my code the row is still deleted meaning whats the point in keeping that in your code rite?

Also another quick question on the matter of organizing mySQL code. If I wanted to do multiple SQL calls like delete then add a row then delete another then change a row would I do it all in the same block of code where I establish the connection to my database before the $conn->close(); or would I open another php tag and separate all of those SQL Queries with new database connections?

If someone with experience can explain id really appreciate it. Thank you!

Answer 1 · 2015-03-09T12:40:31Z

March 9, 2015 12:40pm

No, if you've deleted what you want you don't need to keep the code. Unless you want to keep checking and deleting a query every time you load. Actually, for one time deletes like this, it's better to use phpmyadmin or via the terminal. If they do it like this in the lesson, it's probably just so you know how.

I would connect to the database once, as connecting/disconnecting will probably slow things down a bit.

Welcome to the Treehouse Community

Looking to learn something new?

Lucas Santos

Lucas Santos

mySQL Question

1 Answer

John Breslin

John Breslin

Lucas Santos

Lucas Santos