TechContent Planner

TechContent Planner is a web application created to organise ideas and plan technical content for LinkedIn.

The project was developed as a practical learning exercise connecting database design, SQL, PHP, Git, web development, and secure data management.

Features

• Create and save post ideas
• Record topics and technologies
• Describe challenges and lessons learned
• Assign a status to each post
• Schedule a publication date
• Generate content from predefined suggestions
• Display all saved posts
• Delete posts with confirmation
• Protect deletion requests with a CSRF token
• Validate user input
• Store information in a MySQL database

Technologies

• PHP
• MySQL
• SQL
• HTML
• CSS
• JavaScript
• Git and GitHub
• Laragon

Project structure

techcontent-planner/
├── db.php
├── index.php
├── new_post.php
├── posts.php
├── post.sql
└── README.md

Requirements

To run the project locally, you need:

• PHP
• MySQL
• Apache
• Laragon, XAMPP, or a similar local development environment

Installation

Clone the repository:

git clone https://github.com/IzabellaPass/techcontent-planner.git

Move the project into the local web server directory.

For Laragon:

C:\laragon\www\techcontent-planner

Start Apache and MySQL.

Open post.sql in HeidiSQL, phpMyAdmin, or another MySQL client and execute the script to create the database and the posts table.

The default local database configuration in db.php is:

Host: 127.0.0.1
Database: techcontent_planner
User: root
Password: empty

Open the application in the browser:

http://localhost/techcontent-planner/

Security practices

The project currently uses:

• PDO prepared statements
• Server-side input validation
• HTML output escaping
• CSRF protection for deletion requests
• POST requests for destructive actions
• Confirmation before deleting content

The default database credentials are intended only for a local Laragon environment. Production credentials should not be committed to a public repository.

Future improvements

Planned improvements include:

• Editing saved posts
• Filtering posts by topic and status
• Searching saved content
• A visual publication calendar
• Improved draft generation
• User authentication
• Environment-based database configuration

Author

Izabella Pascon Toledo

GitHub: https://github.com/IzabellaPass