Skip to content

About

Tech Blog is a basic website for blogging, developed on PHP. The content management system at the backend enables the user to add or delete blog contents.

Topics

Resources

Stars

1 star

Watchers

1 watching

Forks

Latest commit

 

History

8 Commits

Folders and files

Repository files navigation

TheTechBlog

This a website developed on PHP and has a content management system

Live site: TheTechBlog

SQL Server setup

The application uses PDO with the Microsoft SQL Server PDO driver (pdo_sqlsrv). Create an empty SQL Server database and run cms.sql against it before starting the application. This SQL Server script creates all three tables, their constraints, and inserts the migrated seed data (4 articles, 4 authors, and 2 users). It preserves the IDs and photo data from the original MariaDB dump. Run it only once per empty database.

Copy .env.example to .env and fill in the SQL Server connection settings. The local .env file is ignored by Git. Values supplied directly in the PHP process environment take precedence over values in .env.

  • SQLSERVER_HOST — SQL Server host, optionally including a port (for example, localhost,1433)
  • SQLSERVER_DATABASE — database name
  • SQLSERVER_USERNAME — login name
  • SQLSERVER_PASSWORD — login password

Quote values in .env if they contain leading/trailing whitespace or a #. The SQL Server PDO driver and PHP GD extension must be enabled. GD is required to resize and serve article and author photos. If GD lacks WebP support, WebP photos are served without resizing. Connections require encryption and validate the server certificate.

Data cache

Public article details and the latest-posts list are cached on the server for 30 days (2,592,000 seconds). Article and author changes made through the CMS clear this cache immediately. Admin pages and health checks still query the database directly. Images are not cached by this data cache.

Cache files live in an installation-specific directory under PHP's system temporary directory, outside the website root. PHP needs write access to that directory; if it is unavailable, requests fall back to the database. The cache is local to each server instance and may be cleared by temporary-file cleanup or restarts. Direct database changes require clearing the cache or waiting for expiration; multiple server instances need shared invalidation before scaling.

Azure App Service deployment

The site is hosted on Azure App Service as a Linux Web App using Publish: Code and the PHP 8.5 runtime stack. Deploy the repository's PHP files with the Azure App Service extension for Visual Studio Code or your preferred App Service deployment method. The app is served from the repository root; no custom startup command or container port setting is required.

In the Web App's Environment variables settings, add SQLSERVER_HOST, SQLSERVER_DATABASE, SQLSERVER_USERNAME, and SQLSERVER_PASSWORD. Use the Azure SQL endpoint such as tcp:<server>.database.windows.net,1433, the database name, and SQL login. App Service injects these settings into PHP's process environment, which takes precedence over the local .env file. Store the password in an App Service setting or Key Vault reference. Do not deploy .env or commit production credentials.

Allow the Web App's outbound IP addresses in the Azure SQL firewall, or configure private networking. Enabling Allow Azure services and resources to access this server is a simpler but broader firewall alternative; it allows Azure resources beyond this Web App. Enable App Service Health check with the path /health.php; it returns success only when a database query succeeds. The deployed site has been verified to render the homepage and article/author images. Its image endpoint recognizes WebP by its file signature and serves WebP directly if GD lacks WebP support.

The built-in PHP 8.5 runtime must provide pdo_sqlsrv and GD. Check available extensions in the deployed runtime (for example, through SSH/Kudu); if either is unavailable, use a custom container deployment instead.

About

Tech Blog is a basic website for blogging, developed on PHP. The content management system at the backend enables the user to add or delete blog contents.

Topics

Resources

Stars

1 star

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages