Recently Updated Pages
Validating CSV Rows
Validate every row before storing it. if (count($row) !== 4) { $rowErrors[] = "Row $rowNumber...
Reading CSV Rows with fgetcsv
Use PHP’s CSV parser so quoted commas and escaped values are handled correctly. $handle = fopen($...
Validating an Uploaded CSV File
Validate the upload before reading its rows. $file = $_FILES["dataset"] ?? null; $errors = []; if...
Creating an Admin-Only CSV Upload Form
A CSV upload changes stored data and should be restricted to administrators. Apply session and ro...
Designing a MySQL Table from a CSV
Design the destination table from the meaning of the data, not merely its appearance in a spreads...
Understanding CSV Data
CSV means comma-separated values. Each line is a record and each position represents a field. mat...
Protecting an Admin-Only Data Import Page
A role-based system must enforce permissions on the server. Hiding a link is helpful navigation, ...
Updating Existing Records
An update changes an existing row. The application must identify the row, validate changes and pr...
Filtering and Sorting Records
Filters help users reduce a dataset to relevant records. Sorts place those records in a useful or...
Selecting and Displaying Records
A useful output begins with a query and ends with accessible, escaped HTML. Select only required ...
Inserting Validated Form Data
An insert should accept input, validate it, store it with a prepared statement and report a usefu...
Using Prepared Statements
Prepared statements keep user-supplied values separate from SQL instructions. Use them whenever a...
Connecting PHP to MySQL
A database connection allows PHP to send SQL to MySQL and receive results. Keep the connection in...
Checking a Project Before Development
A short environment check prevents installation, folder and service problems from consuming devel...
Creating a MySQL Database with phpMyAdmin
A database organises persistent information in related tables. This practice creates a small fict...
Creating Your First XAMPP PHP Project
A XAMPP project belongs inside the htdocs folder so Apache can serve it and process PHP. Create ...
Starting and Testing Apache and MySQL
Apache runs PHP pages and MySQL stores application data. Both services must be running while you ...
Task 4 - Cactus
We will expand on the skills we learnt in the previous tasks to create a more complex mesh that h...
2. Text as binary
Understanding how text is stored in computers.dotx ASCII Values.xlsx Binary Simulator Teacher Edi...
Welcome
MrNapper.au provides classroom-tested learning resources, worked examples, tutorials and interact...