Prepared Statements and CRUD

Database access should be explicit and parameterized. This lesson focuses on `mysqli_prepare()`, binding parameters, and mapping CRUD operations to small functions instead of string-building SQL inline.

Use the lesson to reinforce the pattern already used in the blog codebase.

Edit the panels below and press Run to preview. Nothing you type here is saved — refreshing the page restores the original starter code.

<section class="table-shell">\n  <h2>Records</h2>\n  <table>\n    <thead>\n      <tr><th>Name</th><th>Status</th></tr>\n    </thead>\n    <tbody>\n      <tr><td>Example</td><td>Published</td></tr>\n    </tbody>\n  </table>\n</section>

table {\n  width: 100%;\n  border-collapse: collapse;\n}\n\nth, td {\n  text-align: left;\n  padding: 0.75rem;\n  border-bottom: 1px solid #e5e5e5;\n}

// The database work happens in PHP on the server.\nconsole.log("Prepared statements lesson loaded");