SQL GROUP BY and HAVING Tutorial: COUNT, SUM, AVG, ROLLUP and Pivot Reports in MySQL

Submitted by jaypabs on

Totals, averages and counts are the heart of almost every report: sales per branch, students per course, orders per day, the best-selling product this week. In SQL, all of these come from one clause: GROUP BY. Paired with aggregate functions like COUNT, SUM and AVG, and filtered with HAVING, it turns thousands of rows into a short summary you can show on a dashboard.

SQL Injection Explained: How to Prevent It in PHP, Python and Node.js with Prepared Statements

Submitted by jaypabs on
SQL injection is one of the oldest web security bugs, and it still shows up in student projects, freelance work and even production apps. The cause is almost always the same line of code: user input pasted directly into an SQL string. The fix is also almost always the same: prepared statements. In this guide you will see what SQL injection looks like, why escaping and "cleaning" input is not

Student Grading System with Report Card and GWA using PHP and MySQL with Source Code

Submitted by jaypabs on
Student Grading System with Report Card and GWA using PHP and MySQL with Source Code
The Student Grading System is a web application built with PHP and MySQL for schools, colleges and student capstone projects. Teachers encode Prelim, Midterm and Finals grades in one grade sheet, and the system computes each student's weighted average, the equivalent 1.00 to 5.00 grade, and the remarks (Passed, Failed or Incomplete). Admins manage students, subjects, classes and teacher accounts

GitHub Blocks pull_request_target, Forwarded Header Spoofing and Psalm 7: Developer News for November 8, 2026

Submitted by jaypabs on
It is the weekend, but a few things from the past week need your attention before Monday, especially if you keep projects on GitHub or run a web app behind a proxy. Here is a plain-English roundup for November 8, 2026, with links to the original announcements so you can check every detail yourself. All numbers and dates below come from the linked sources. Where a company is describing its own

Python JSON Tutorial: dumps, loads, dump, load, Pretty Print and Error Handling

Submitted by jaypabs on

JSON is everywhere in modern programming. REST APIs send it, JavaScript front ends expect it, configuration files are written in it, and many capstone projects store small amounts of data in a .json file before they move to a real database. If you write Python, sooner or later you will need to turn a dictionary into JSON or read a JSON response back into Python.

GPT-6 Cyber, Claude Code 2.1.319 and a Fake Extension Backdoor: Developer News for November 7, 2026

Submitted by jaypabs on
Friday and Saturday brought a mix of security-focused AI releases, a tooling update for Claude Code, and a reminder that extension marketplaces can be abused. Here is a plain-English roundup for November 7, 2026, with links to the coverage so you can verify each item yourself. None of the numbers below were invented here. Where a vendor published its own benchmark scores, that is labeled as the

JavaScript Array Methods Tutorial: map, filter, reduce, find, some and every with Examples

Submitted by jaypabs on

Arrays are the default list type in JavaScript, and most of the day-to-day work you do with them — transform items, keep only some of them, compute a total, find the first match — is easier with the built-in array methods than with handwritten for loops. Once you are comfortable with map, filter, reduce, find, some and every, reading other people's code (and writing your own API responses) gets much faster.

Clinic Appointment System using PHP and SQLite with Source Code

Submitted by jaypabs on
Clinic Appointment System using PHP and SQLite with Source Code
The Clinic Appointment System is a web application built with PHP and SQLite for small clinics, school clinics and student capstone projects. Reception staff can log in, manage patients and doctors, book appointments, prevent double-booking, and update status (Scheduled, Completed, Cancelled, No-Show) from a simple dashboard. Because it uses SQLite, there is no MySQL server or phpMyAdmin import

How to Write Clear Git Commit Messages for Capstone and Team Projects

Submitted by jaypabs on
A good commit message is a short note to your future self and to anyone who reviews your work. In a capstone or group project it also becomes the history of how the system grew: why the login page changed, when the appointment status was added, and which teammate fixed the double-booking bug. Vague messages like update, fix or asdf waste that history. This post is a practical guide to writing

Python pathlib Tutorial: Paths, Read/Write, glob, mkdir and Practical File Scripts

Submitted by jaypabs on

Working with files is one of the first things you do in almost every Python project: open a CSV for a grade list, create a folder for uploads, find every .py file in a project, or build a path that works on both Windows and Linux. For years the usual tools were os.path and plain strings. Today the cleaner option is the built-in pathlib module and its Path objects.

Subscribe to