HPR4649: What did I do at work today? Part 3 Section 2

This show has been flagged as Explicit by the host.

It is suggested reviewing the episode
What did I do at work today? Part 3 Section 1
prior to listening

Test driven development
- a way of writing code that involves writing an automated unit-level test case that fails, then writing just enough code to make the test pass, then refactoring both the test code and the production code, then repeating with another new test case. -
https://en.wikipedia.org/wiki/Test-driven_development

Joplin
- Joplin is an open source, cross platform note-taking app. -
https://joplinapp.org/

PHP
- A popular general-purpose scripting language that is especially suited to web development. Fast, flexible and pragmatic, PHP powers everything from your blog to the most popular websites in the world. -
https://www.php.net/

MySQL
- MySQL is an open-source relational database management system. MariaDB is a community developed fork of MySQL, often installing the MySQL package on a Linux distribution will actually install MariaDB. -
https://en.wikipedia.org/wiki/MySQL
-
https://mariadb.org/
-
https://www.mysql.com/

Sublime Text
- Cross platform text editor -
https://www.sublimetext.com/

Nmap
- Network Mapper is a free and open source utility for network discovery and security auditing -
https://nmap.org/

Markdown Fenced code blocks
- "A code fence is a sequence of at least three consecutive backtick characters (`) or tildes (~). (Tildes and backticks cannot be mixed.) A fenced code block begins with a code fence, preceded by up to three spaces of indentation. The line with the opening code fence may optionally contain some text following the code fence; this is trimmed of leading and trailing spaces or tabs and called the info string. ... Although this spec doesn’t mandate any particular treatment of the info string, the first word is typically used to specify the language of the code block."

```ruby

def foo(x)

 return 3

end

```

from CommonMark Spec at
https://commonmark.org/
(CommonMark is a standard, interoperable and testable version of Markdown.)

Writing to a Database with PHP

The following PHP method is implemented within a database access class:

function create_with_id($id, $name) {

  $born = time();

  $id = mysqli_real_escape_string($this->db, $id);

  $name = mysqli_real_escape_string($this->db, $name);

  $sql = "INSERT INTO object

      (object_id, display_name_text, born, died)

    VALUES

      ($id, '$name', $born, 0);

  ";

  db_run_sql($this->db, $sql);

}

Note




db_run_sql




is a helper function defined elsewhere, not a built in function, and the property




db




is a previously initialized




mysqli




object.

Provide feedback on this episode.