Kvnbbg.fr

Who loves creating apps.

Tag: php (Page 1 of 4)

Multi-hued clouds
Multi-hued clouds by NASA Johnson is licensed under CC-BY-NC 2.0

Vision Week !

29/05/2024 / / 0 Comments

A Revolutionary VR Zoo Experience

Project Overview

Vision Week is a mobile and web application built with Flutter, offering an interactive VR experience of visiting a zoo. The app allows users to explore various animal exhibits, follow guided tours, and access rich video content at each point of interest. The project is hosted on Atlassian platforms for collaboration and project management.

Key Features

  • Onboarding: Smooth user introduction and sign-up process.
  • Géolocalisation: Interactive map with points of interest.
  • Parcours Guidés: Detailed guided tours.
  • GPS Navigation: Step-by-step guidance.
  • Contenu Vidéo: Educational and exercise videos.
  • Interaction Sociale: Comments and social sharing.
  • Personnalisation: Profile customization.
  • Abonnement: In-app subscriptions.

Technology Stack

  • Frontend: Developed in Flutter for a seamless user experience across both mobile and web platforms.
  • Backend: Built with PHP and a relational database.
  • Deployment: Backend and database hosted on a private server, frontend deployed on Netlify for efficient delivery.

Project Management and Collaboration

The development of Vision Week follows an agile methodology with a light Scrum approach. We use Atlassian tools for project management and collaboration:

GitHub Repository

The Vision Week project is open-source, and you can follow our development journey on GitHub. Contributions and feedback are welcome! Explore our GitHub Repository

Script Code

Below is a script that outlines the basic structure of our Flutter application, focusing on the main features:

import 'package:flutter/material.dart';

void main() {
  runApp(VisionWeekApp());
}

class VisionWeekApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'Vision Week',
      theme: ThemeData(
        primarySwatch: Colors.blue,
      ),
      home: OnboardingScreen(),
    );
  }
}

class OnboardingScreen extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('Vision Week Onboarding'),
      ),
      body: Center(
        child: Text('Welcome to Vision Week!'),
      ),
    );
  }
}

// Additional screens and functionalities would be implemented similarly

Main Thinking for the App Engine

The Vision Week app engine is designed to be modular and scalable, ensuring that we can easily integrate new features and improvements. The main components include:

  • User Authentication: Secure sign-up and login processes.
  • Geolocation Services: Accurate tracking and display of user location.
  • Content Management: Efficient handling and display of video and other multimedia content.
  • Social Features: Enabling user interaction and content sharing.
  • Subscription Management: Streamlined in-app purchases and subscription handling.

Join Us on Slack

For real-time collaboration and updates, we are also on Slack. Join our workspace to stay connected and contribute to the project.

the Vision Week project

17/05/2024 / / 0 Comments

About Vision Week

Vision Week, formerly known as the Exploration Video Website, is designed to provide an immersive experience for exploration enthusiasts. With a user-friendly interface and a variety of features, Vision Week makes it easy to discover and learn about different types of explorations.

Features

  • Explore by Category: Discover videos organized by exploration type.
  • Search Functionality: Find specific videos using keywords or location.
  • Detailed Information: Learn more about each exploration with descriptions, source links, and additional resources.
  • Interactive Games: Engage with fun and educational games such as:
  • Game I: An object interaction game where users click on moving objects to score points.
  • Game II: A 3D visualization game that displays recorded data from Game I using Three.js.
  • Latest News Updates: Stay informed with the most recent articles and news updates fetched and displayed from the database.
  • User Data Management: Manage and view user data efficiently, including registration, login, and profile management.
  • Zoo Information: Explore detailed information about various animals and their habitats, perfect for animal lovers and those curious about wildlife.
  • Access Logs: Keep track of data access logs, providing transparency and security for user interactions with the app.

Upcoming Work

My next focus will be on incorporating unit testing into Vision Week using PHPUnit. Unit testing is crucial for ensuring the reliability and stability of the application, yet there are not many comprehensive videos explaining test case creation and execution. To fill this gap, I will create a detailed video tutorial on using PHPUnit with Vision Week.

Future Plans

  • Design Improvements: If time permits, I will work on enhancing the design of Vision Week using Figma. Design improvements will focus on making the user interface more intuitive and visually appealing.
  • Additional Features: Implementing user comments and ratings to foster a more interactive community experience.
  • Video Platform Integration: Expanding the video library by integrating with platforms like YouTube or Vimeo.

Technologies Used

  • Frontend: HTML, CSS, JavaScript
  • Backend: PHP (planned for future implementation)
  • Database: SQLite, with plans to migrate to MySQL in the future

How to Contribute

We welcome contributions to improve Vision Week! Feel free to fork the repository and submit pull requests with your enhancements. Read our CONTRIBUTING guidelines for more details.

Support Vision Week

Your support helps cover expenses such as hosting fees, domain registration, and development tools, allowing us to continue improving and expanding Vision Week for the community. Read more about SPONSORING Vision Week. Thank you for your support!

Useful Links

Side Project for Fun

Check out my side project, TurboZoo:

<?php
require_once 'config.php';
session_start();

function getDatabaseConnection($dbFile) {
    try {
        $db = new PDO('sqlite:' . $dbFile);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $db;
    } catch (PDOException $e) {
        error_log($e->getMessage());
        return null;
    }
}

function fetchFromDatabase($db, $query) {
    try {
        $stmt = $db->query($query);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    } catch (PDOException $e) {
        error_log($e->getMessage());
        return [];
    }
}

$db = getDatabaseConnection(DB_FILE);
$usersDb = getDatabaseConnection('sql/users.db');
$zooDb = getDatabaseConnection('sql/zoo.db');
$dataDb = getDatabaseConnection('sql/data.db');

$articles = fetchFromDatabase($db, "SELECT title, content, published_at FROM news ORDER BY published_at DESC LIMIT 3");
$users = fetchFromDatabase($usersDb, "SELECT * FROM Users");
$zoo = fetchFromDatabase($zooDb, "SELECT * FROM Zoo");
$logs = fetchFromDatabase($dataDb, "SELECT * FROM DataAccessLog");

$welcomeMessage = isset($_SESSION['user']) ? "Welcome back, " . htmlspecialchars($_SESSION['user']['username']) . "!" : "Welcome to our website!";
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Vision Week, a virtual exploration!</title>
    <link rel="stylesheet" href="styles.css">
</head>
<body>
    <?php if (file_exists('header.php')) include 'header.php'; ?>
    <?php if (file_exists('navigation.php')) include 'navigation.php'; ?>

    <main>
        <button onclick="openDesignThinkingQuiz()">Take the Design Thinking Quiz</button>

        <h1><?php echo htmlspecialchars($welcomeMessage); ?></h1>

        <section>
            <?php if (!empty($articles)): ?>
                <h2>Latest News</h2>
                <ul>
                    <?php foreach ($articles as $article): ?>
                        <li>
                            <h3><?php echo htmlspecialchars($article['title']); ?></h3>
                            <p><?php echo htmlspecialchars($article['content']); ?></p>
                            <p class="published-date">Published: <?php echo htmlspecialchars($article['published_at']); ?></p>
                        </li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No recent news articles found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>User Data</h2>
            <?php if (!empty($users)): ?>
                <ul>
                    <?php foreach ($users as $user): ?>
                        <li><?php echo htmlspecialchars($user['username']); ?> - <?php echo htmlspecialchars($user['email']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No user data found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>Zoo Data</h2>
            <?php if (!empty($zoo)): ?>
                <ul>
                    <?php foreach ($zoo as $animal): ?>
                        <li><?php echo htmlspecialchars($animal['animal_name']); ?> (<?php echo htmlspecialchars($animal['animal_type']); ?>) - <?php echo htmlspecialchars($animal['country_name']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No zoo data found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>Access Logs</h2>
            <?php if (!empty($logs)): ?>
                <ul>
                    <?php foreach ($logs as $log): ?>
                        <li>User ID: <?php echo htmlspecialchars($log['user_id']); ?> accessed Data ID: <?php echo htmlspecialchars($log['data_id']); ?> at <?php echo htmlspecialchars($log['access_time']); ?> for action: <?php echo htmlspecialchars($log['action']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No access logs found.</p>
            <?php endif; ?>
        </section>
    </main>

    <?php if (file_exists('footer.php')) include 'footer.php'; ?>

    <script src="/assets/script.js"></script>
    <script src="/conception/receuil-des-besoins/design_thinking.js"></script>
</body>
</html>

Feel free to reach out if you have any questions or suggestions !

two red-and-white dices

Introducing Vision Week

14/05/2024 / / 0 Comments

Your Gateway to a Virtual Exploration!

Are you ready to dive into an innovative virtual exploration experience? Meet Vision Week, an app designed to offer a comprehensive and interactive platform for users to engage with various forms of content including news, user data, zoo information, and more. This application not only enhances your digital experience but also brings a wealth of information right at your fingertips, making it useful for your daily life.

Features and Functionality

Vision Week is built to cater to a wide range of needs with features such as:

  1. Latest News Updates:
    Stay informed with the most recent articles and news updates. Our app fetches and displays the latest news, ensuring you never miss out on important events.
  2. User Data Management:
    Manage and view user data efficiently. The app allows users to register, log in, and access their profiles seamlessly.
  3. Zoo Information:
    Explore detailed information about various animals and their habitats. This feature is perfect for animal lovers and those curious about wildlife.
  4. Access Logs:
    Keep track of data access logs, providing transparency and security for user interactions with the app.
  5. Design Thinking Quiz:
    Engage in interactive quizzes that challenge your creativity and problem-solving skills.

Technical Overview

Our app is developed using PHP and SQLite, ensuring a lightweight yet powerful backend. Here’s a glimpse of the code that powers Vision Week:

<?php
require_once 'config.php';

session_start();

function getDatabaseConnection($dbFile) {
    try {
        $db = new PDO('sqlite:' . $dbFile);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        return $db;
    } catch (PDOException $e) {
        error_log($e->getMessage());
        return null;
    }
}

function fetchFromDatabase($db, $query) {
    try {
        $stmt = $db->query($query);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    } catch (PDOException $e) {
        error_log($e->getMessage());
        return [];
    }
}

$db = getDatabaseConnection(DB_FILE);
$usersDb = getDatabaseConnection('sql/users.db');
$zooDb = getDatabaseConnection('sql/zoo.db');
$dataDb = getDatabaseConnection('sql/data.db');

$articles = fetchFromDatabase($db, "SELECT title, content, published_at FROM news ORDER BY published_at DESC LIMIT 3");
$users = fetchFromDatabase($usersDb, "SELECT * FROM Users");
$zoo = fetchFromDatabase($zooDb, "SELECT * FROM Zoo");
$logs = fetchFromDatabase($dataDb, "SELECT * FROM DataAccessLog");

$welcomeMessage = isset($_SESSION['user']) ? "Welcome back, " . htmlspecialchars($_SESSION['user']['username']) . "!" : "Welcome to our website!";
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Vision Week, a virtual exploration!</title>
    <link rel="stylesheet" href="styles.css">
</head>
<body>
    <?php if (file_exists('header.php')) include 'header.php'; ?>
    <?php if (file_exists('navigation.php')) include 'navigation.php'; ?>

    <main>
        <button onclick="openDesignThinkingQuiz()">Take the Design Thinking Quiz</button>

        <h1><?php echo htmlspecialchars($welcomeMessage); ?></h1>

        <section>
            <?php if (!empty($articles)): ?>
                <h2>Latest News</h2>
                <ul>
                    <?php foreach ($articles as $article): ?>
                        <li>
                            <h3><?php echo htmlspecialchars($article['title']); ?></h3>
                            <p><?php echo htmlspecialchars($article['content']); ?></p>
                            <p class="published-date">Published: <?php echo htmlspecialchars($article['published_at']); ?></p>
                        </li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No recent news articles found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>User Data</h2>
            <?php if (!empty($users)): ?>
                <ul>
                    <?php foreach ($users as $user): ?>
                        <li><?php echo htmlspecialchars($user['username']); ?> - <?php echo htmlspecialchars($user['email']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No user data found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>Zoo Data</h2>
            <?php if (!empty($zoo)): ?>
                <ul>
                    <?php foreach ($zoo as $animal): ?>
                        <li><?php echo htmlspecialchars($animal['animal_name']); ?> (<?php echo htmlspecialchars($animal['animal_type']); ?>) - <?php echo htmlspecialchars($animal['country_name']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No zoo data found.</p>
            <?php endif; ?>
        </section>

        <section>
            <h2>Access Logs</h2>
            <?php if (!empty($logs)): ?>
                <ul>
                    <?php foreach ($logs as $log): ?>
                        <li>User ID: <?php echo htmlspecialchars($log['user_id']); ?> accessed Data ID: <?php echo htmlspecialchars($log['data_id']); ?> at <?php echo htmlspecialchars($log['access_time']); ?> for action: <?php echo htmlspecialchars($log['action']); ?></li>
                    <?php endforeach; ?>
                </ul>
            <?php else: ?>
                <p>No access logs found.</p>
            <?php endif; ?>
        </section>
    </main>

    <?php if (file_exists('footer.php')) include 'footer.php'; ?>

    <script src="/assets/script.js"></script>
    <script src="/conception/receuil-des-besoins/design_thinking.js"></script>
</body>
</html>

User Interface and Daily Usefulness

Vision Week is designed with a user-friendly interface that ensures ease of use and accessibility. The layout is clean and intuitive, making navigation a breeze. Here are a few ideas for the UI and how the app can be useful in daily life:

  1. Dashboard:
    A central hub displaying personalized news feeds, user activity, and quick access to different sections of the app. This makes it easier to stay updated and manage your activities efficiently.
  2. User Profile:
    A dedicated section for managing user profiles, viewing personal data, and updating information. This promotes user engagement and personalizes the experience.
  3. Interactive Zoo Map:
    An engaging and educational feature where users can explore animals through an interactive map, learn about different species, and their habitats. This can be a fun activity for both kids and adults.
  4. Notifications and Alerts:
    Real-time notifications to alert users about important news updates, upcoming quizzes, and more. This keeps users engaged and informed.

Useful Links

Screenshots and Visuals

Here’s a sneak peek at our user interface design:

Dashboard
Caption: The Vision Week Dashboard provides an overview of your activities.

man wearing grey shirt beside green wall
Caption: Manage your profile and view your personal data with ease.


Caption: Explore the zoo interactively and learn about different animals.

Conclusion

Vision Week is not just an app; it’s a comprehensive platform designed to enhance your daily life with its rich features and intuitive design. Stay informed, manage your data, and explore the world around you with Vision Week. We are committed to providing you with the best virtual experience possible.

Stay tuned for more updates and features. Happy exploring!

In conclusion, Vision Week has been an inspiring journey, not only for setting personal goals but also for fostering collaboration and community engagement. As I pursue my side project, TurboZoo, I invite you to join me in this exciting venture.

Whether you’re interested in contributing to the code, sharing ideas, or simply having fun, there’s a place for you. 😁

Check out the project on GitHub or Replit, and don’t miss the video of the first version here.

Our Discord community !

A MacBook with lines of code on its screen on a busy desk

Fetch data with auto-incremented ID

28/03/2024 / / 0 Comments

Angular and PHP: A Formidable Duo

Angular, a platform and framework for building single-page client applications using HTML and TypeScript, offers developers a way to create high-performance web applications that are easy to maintain. On the server side, PHP stands as a widely-used scripting language that is especially suited for web development. When combined, Angular and PHP can serve as the foundation for creating dynamic, data-driven web applications that are both efficient and scalable.

Angular Service (TypeScript)

import { Injectable } from '@angular/core';
import { HttpClient } from '@angular/common/http';
import { Observable } from 'rxjs';

@Injectable({
  providedIn: 'root'
})
export class DataService {
  constructor(private http: HttpClient) { }

  fetchData(): Observable<any> {
    return this.http.get('api/fetchData.php');
  }
}

PHP Backend (fetchData.php)

<?php
header('Content-Type: application/json');

// Database connection
$host = 'your_database_host';
$dbname = 'your_database_name';
$user = 'your_database_user';
$pass = 'your_database_password';
$dsn = "mysql:host=$host;dbname=$dbname";
$conn = new PDO($dsn, $user, $pass);

// Fetch data with auto-incremented ID
$stmt = $conn->prepare("SELECT * FROM your_table_name ORDER BY id DESC");
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($results);
?>

Emphasizing Database Reliability and Efficiency

Reliable database systems are the backbone of any web application. They ensure data integrity, security, and accessibility. The level of information a database manages and its structuring significantly impact the application’s performance. Using auto-increment keys in databases simplifies record tracking and eliminates the need for manual ID management, enhancing data consistency and integrity.

Spotlight on Essential Database Tools

Exploring the landscape of database management, several tools stand out for their utility, versatility, and support in enhancing database reliability:

  • Alwaysdata Admin Interface: Provides a comprehensive web hosting platform with a user-friendly interface for database management, making it easier for developers to deploy and manage their web applications and databases.
  • DBeaver: An open-source universal database tool that supports all major databases, offering a sophisticated interface for database administrators and developers to manage and analyze databases.
  • DataGrip by JetBrains: A professional database management tool that offers context-aware code completion, code inspections, and version control integration, tailored for database development.
  • VSCode MySQL Client2: An extension for Visual Studio Code that turns it into a powerful MySQL client, supporting database management directly from the IDE.

Conclusion

The combination of Angular and PHP for web development, coupled with the strategic use of advanced database management tools, can significantly elevate the quality and performance of web applications.

black flat screen computer monitor

the integration of backend technologies like PHP and MariaDB with front-end libraries such as Three.js

28/03/2024 / / 0 Comments

Hosting a PHP and Three.js Application on Fly.io

1. Introduction to Fly.io Deployment

Fly.io is a modern platform that enables developers to run their applications close to users worldwide, leveraging the benefits of containers. It supports a wide array of languages and frameworks, including PHP, making it an excellent choice for deploying web applications that require global distribution.

2. Containerization with Docker

The first step involves containerizing your PHP application using Docker. This process ensures your application runs consistently across different environments. Here’s a basic Dockerfile for setting up a PHP environment:

FROM php:8.0-apache
WORKDIR /var/www/html
COPY . .
EXPOSE 80
CMD ["apache2-foreground"]

3. Deploying on Fly.io

Once your application is containerized, deploying it on Fly.io involves a few commands using the Fly.io CLI. Ensure you’ve logged in (fly auth login) and created an app (fly apps create). Then, deploy your application using fly deploy. The CLI tool handles the rest, ensuring your app is deployed globally.

Building the Educational App

Algorithm Overview

The core of our educational app revolves around explaining database technologies through interactive examples and tutorials. Users can select a topic (MariaDB vs. MySQL), and the app dynamically presents relevant information, tutorials, and visualizations using Three.js.

Sample Algorithm Block: Display Database Comparison

<?php
// Sample PHP code to fetch and display database information
function fetchDatabaseInfo($dbType) {
    // Placeholder for fetching data. Assume $databaseInfo is fetched here.
    $databaseInfo = [
        'description' => 'Description of ' . $dbType,
        'links' => [
            'official' => 'https://officialsite.com/' . $dbType,
            'tutorial' => 'https://tutorialsite.com/' . $dbType,
        ],
        'primaryKeys' => 'Explanation of primary keys in ' . $dbType,
        'robustness' => 'How ' . $dbType . ' ensures robustness',
        'commonBugs' => 'Common bugs found in ' . $dbType . ' and how to avoid them',
    ];
    return $databaseInfo;
}

// Example usage
$dbType = 'MariaDB';
$databaseInfo = fetchDatabaseInfo($dbType);
echo json_encode($databaseInfo);

Integrating Three.js

Three.js is utilized to create interactive 3D visualizations for each database concept. For instance, showing a 3D model of database tables and relationships can help explain primary keys and data integrity visually.

<!DOCTYPE html>
<html>
<head>
    <title>3D Database Concepts</title>
    <script src="https://threejs.org/build/three.js"></script>
</head>
<body>
    <script>
        // Three.js script to visualize database concepts
        // Placeholder for Three.js code to render 3D models
    </script>
</body>
</html>

Enriching the App with Resources

Educational Content and Links

  • MariaDB: Explore the features and advantages of MariaDB, a fork of MySQL, offering enhanced performance, security, and open-source freedom. MariaDB Official
  • Transact-SQL: Learn about Microsoft’s extension to SQL, Transact-SQL (T-SQL), used in SQL Server. T-SQL adds procedural programming, local variables, and support for error handling. T-SQL Documentation
  • Oracle Database: Dive into the world of Oracle Database, a multi-model database management system known for its scalability, reliability, and comprehensive features. Oracle Documentation
  • NoSQL: Understand the principles behind NoSQL databases, designed for specific data models and have flexible schemas for building modern applications. NoSQL Database Explained
  • MySQL: Get started with MySQL, the world’s most popular open-source database, known for its reliability, ease of use, and performance. MySQL Official
  • SQL Server: Explore SQL Server, Microsoft’s enterprise database solution, offering robust data management and business intelligence capabilities. SQL Server Documentation
  • Complex SQL Queries: Enhance your skills in understanding complex SQL queries with step-by-step explanations and examples. Complex SQL Tutorial
  • Primary Keys (Clé Primaire): Learn about the importance of primary keys in database design and how they ensure data uniqueness and integrity. Primary Keys Explained
  • Building Robust Applications: Tips and best practices for developing robust database applications that are secure, efficient, and reliable. Database Design Best Practices
  • Common Database Bugs: Identify common bugs in database applications and learn how to avoid them, enhancing the stability and performance of your applications. Common Database Errors

Conclusion

Creating an application that marries PHP and Three.js for educational purposes serves as a potent tool for junior developers eager to learn about database technologies. Hosting it on Fly.io ensures global reach and performance.

technology, conversation, talking

PHP 8 features, thorough algorithms, comparison and insights for full-stack development

28/03/2024 / / 0 Comments

PHP in 2024

PHP, a cornerstone of web development for over two decades, has continually evolved to meet the challenges of modern web applications. With the release of PHP 8, developers have access to a suite of powerful features designed to enhance code readability, maintainability, and performance.

The Strategic Shift to Fly.io from Heroku

The hosting environment is a critical factor in the performance and scalability of web applications. While Heroku has been a long-standing favorite for its simplicity and developer-friendly approach, the advent of Fly.io offers a compelling alternative. Fly.io’s emphasis on global application deployment, closer proximity to users, and a cost-effective pricing model based on actual resource consumption presents a paradigm shift for PHP applications aiming for global reach and optimal performance.

Advanced PHP : Syntax, Features, and Full-Stack Integration

PHP 8 introduces several features that significantly impact full-stack development. Attributes allow for metadata to be declarative (specified directly in the code) facilitating cleaner architecture and reducing boilerplate code. Union types introduce type safety for function parameters enhancing code reliability. JIT compilation promises substantial performance improvements for CPU-intensive applications, making PHP a strong contender for high-performance computing tasks.

<?php

class Article {
    public function __construct(
        public string $title,
        public array $tags,
        public DateTime $publishedDate,
    ) {}
}

function recommendArticles(array $articles, array $userPreferences): array {
    return array_filter($articles, fn($article) => !empty(array_intersect($article->tags, $userPreferences)))
                  ->usort(fn($a, $b) => $b->publishedDate <=> $a->publishedDate);
}

$articles = [
    new Article('PHP 8: New Features', ['PHP', 'Backend'], new DateTime('2024-01-01')),
    // Add more articles
];

$userPreferences = ['PHP', 'Web Development'];

$recommendedArticles = recommendArticles($articles, $userPreferences);

print_r($recommendedArticles);

how to set up a simple PHP environment

A Dockerfile is a text document that contains all the commands a user could call on the command line to assemble an image. Docker can build images automatically by reading the instructions from a Dockerfile. It’s an essential component for Dockerized applications because it specifies the environment, dependencies, and setup steps your application needs to run consistently and reliably across different environments.

# Use an official PHP runtime as a parent image
FROM php:8.0-apache

# Set the working directory in the container
WORKDIR /var/www/html

# Copy the current directory contents into the container at /var/www/html
COPY . .

# Install any needed packages specified in requirements
# This is just an example line to show how you might install dependencies
# RUN apt-get update && apt-get install -y package-name

# Inform Docker the container is listening on port 80 at runtime
EXPOSE 80

# Use the default command for the base image (starting Apache in this case)
CMD ["apache2-foreground"]

Hosting PHP on Fly.io

Choosing Fly.io for PHP applications involves understanding its container-based architecture, which allows for the deployment of applications encapsulated in Docker containers.

  • Global Reach : Deploy applications closer to your users to minimize latency.
  • Scalability : Dynamically adjust resources based on demand.
  • Cost Efficiency : Pay for actual usage rather than allocated resources.

To deploy a PHP application on Fly.io, with an approach ensure scale globally with minimal latency and optimized costs, you would typically proceed as follows :

  1. Containerize your PHP application with Docker.
  2. Deploy using Fly.io’s CLI, specifying regions and scaling options.
  3. Monitor performance and adjust resources as needed.
# Step 1: Log in to Fly.io
# Opens a web browser for you to log in to Fly.io
fly auth login

# Step 2: Create a Fly.io Application
# Navigate to your project directory and create a new Fly.io application

# The above command generates a fly.toml configuration file in your project directory

# Step 3: Set Deployment Region
# Specify the primary region for your deployment
# Replace <region> with your preferred region code ('iad' for France, California)
fly regions set <region>

# You can list available regions with the command below:
fly regions list

# Step 4: Deploy Your Application
# Deploys your Dockerized application to Fly.io
fly deploy

# This command builds your Docker container based on your Dockerfile and deploys it to Fly.io

# Step 5: Scaling Your Application
# To scale your application by changing the number of VM instances, use:
# Replace <count> with the desired number of instances
fly scale count <count>

# To add additional regions for geographical scaling, add regions like so:
# Replace <additional-region> with the code of the region you want to add
fly regions add <additional-region>

# Then, to distribute your application instances across regions, specify the total count and max per region:
# Replace <count> with the total number of instances and <max-per-region> with the max number of instances per region
fly scale count <count> --max-per-region=<max-per-region>

# Step 6: Verify Deployment
# Check the status of your deployment to ensure your instances are running as expected
fly status

# This command gives you information about your application's instances, their health, and more

# Note: For any advanced configurations or adjustments, you might need to edit the fly.toml file directly or consult the Fly.io documentation for more commands and options.

Conclusion

For full-stack developers, PHP’s evolution offers new opportunities to integrate with JavaScript frameworks like React or Vue for the frontend while maintaining PHP for the backend. This synergy allows developers to build highly interactive applications leveraging PHP 8’s backend capabilities and modern JavaScript frameworks’ dynamic interfaces (with three.js ?). By embracing these advancements, PHP developers can build robust, scalable, and efficient web applications ready to meet the demands of modern web development.

Resources and Further Reading

  • PHP.net – Official PHP Documentation
  • Fly.io – Innovative Hosting for Global Applications
  • Heroku – Platform as a Service (PaaS) for easy deployment
  • Stitcher.io on PHP 8 – Insights into PHP 8 features and best practices

connects to a MySQL database using PHP.

27/03/2024 / / 0 Comments

Step 1: Database Setup

First, we’ll set up a MySQL database named my_app and a table named users to store user information.

SQL to create database and table:

CREATE DATABASE my_app;

USE my_app;

CREATE TABLE users (
id INT(11) AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(50),
age INT(11)
);

Step 2: PHP Code to Connect to the Database

Create a file named db.php to handle the database connection.

<?php
$host = ‘localhost’;
$dbname = ‘my_app’;
$username = ‘root’; // default username for localhost
$password = ”; // default password for localhost

try {
$pdo = new PDO(“mysql:host=$host;dbname=$dbname”, $username, $password);
// Set the PDO error mode to exception
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo “Connected successfully”;
} catch(PDOException $e) {
echo “Connection failed: ” . $e->getMessage();
}
?>

Step 3: Create a New User

To insert a new user into the database, create a PHP script named

<?php
require ‘db.php’;

$name = “John Doe”;
$email = “john@example.com”;
$age = 30;

$sql = “INSERT INTO users (name, email, age) VALUES (:name, :email, :age)”;
$stmt = $pdo->prepare($sql);
$stmt->execute([‘name’ => $name, ’email’ => $email, ‘age’ => $age]);

echo “New user created successfully”;
?>

Step 4: Read Users

To fetch and display all users, create

<?php
require ‘db.php’;

$sql = “SELECT id, name, email, age FROM users”;
$stmt = $pdo->query($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo $row[‘name’] . “, ” . $row[’email’] . “, ” . $row[‘age’] . “<br>”;
}
?>

Step 5: Update a User

To update a user’s details, use

<?php
require ‘db.php’;

$id = 1; // Example user ID
$newEmail = “jane@example.com”;

$sql = “UPDATE users SET email = :email WHERE id = :id”;
$stmt = $pdo->prepare($sql);
$stmt->execute([’email’ => $newEmail, ‘id’ => $id]);

echo “User updated successfully”;
?>

Step 6: Delete a User

For deleting a user, create

<?php
require ‘db.php’;

$id = 1; // Example user ID to delete

$sql = “DELETE FROM users WHERE id = :id”;
$stmt = $pdo->prepare($sql);
$stmt->execute([‘id’ => $id]);

echo “User deleted successfully”;
?>

wordpress, joomla, drupal

Php $Search and $Craft Function

25/03/2024 / / 0 Comments

Object-Oriented PHP (OOP)

Object-Oriented PHP (OOP) offers a robust paradigm for developing scalable and maintainable applications. By encapsulating data and behavior into objects and utilizing principles like inheritance and polymorphism, developers can create complex applications with ease. PHP’s support for OOP has matured significantly, allowing for the creation of advanced web applications that are both powerful and efficient.

Namespaces and Composer

Namespaces are essential in PHP for organizing code and avoiding name conflicts, especially in large applications or when using third-party libraries. Composer, the dependency management tool, further enhances PHP’s capabilities by managing libraries and their dependencies, making it easier to maintain and update the codebase.

RESTful APIs with PHP

PHP’s ability to create RESTful APIs opens up the possibility for applications to communicate over the web, sharing data in popular formats like JSON and XML. By adhering to HTTP standards and employing authentication mechanisms such as OAuth or JWT, PHP developers can secure and optimize their API endpoints.

Security Practices

Security is paramount in web development. PHP offers various ways to secure applications, such as using HTTPS, sanitizing user inputs, and implementing hashing algorithms for password storage. By following best practices, developers can protect their applications from common vulnerabilities like SQL injection and XSS attacks.

Testing and Debugging

Testing and debugging are critical for ensuring the reliability of PHP applications. Tools like PHPUnit for unit testing and Xdebug for debugging provide developers with the means to test their code thoroughly and identify bugs efficiently.

CI/CD

Embracing Continuous Integration and Deployment (CI/CD) practices allows for automated testing and deployment, improving the development workflow and reducing the time to market for new features and fixes.

Prepared Statements

<?php

$servername = "localhost";
$username = "username"; // Update with your username
$password = "password"; // Update with your password
$dbname = "musicDB";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $searchNote = 'D4'; // The note we're searching for
    $newFrequency = 294.00; // New frequency or frequency to insert if the note doesn't exist

    // Search for the note in the database
    $stmt = $conn->prepare("SELECT * FROM c_major_scale WHERE note = :note");
    $stmt->execute(['note' => $searchNote]);

    if ($stmt->rowCount() > 0) {
        // Note exists, update its frequency
        $updateStmt = $conn->prepare("UPDATE c_major_scale SET frequency = :frequency WHERE note = :note");
        $updateStmt->execute(['frequency' => $newFrequency, 'note' => $searchNote]);
        echo "Note '$searchNote' updated with new frequency $newFrequency Hz.\n";
    } else {
        // Note doesn't exist, insert new note and frequency
        $insertStmt = $conn->prepare("INSERT INTO c_major_scale (note, frequency) VALUES (:note, :frequency)");
        $insertStmt->execute(['note' => $searchNote, 'frequency' => $newFrequency]);
        echo "Note '$searchNote' inserted with frequency $newFrequency Hz.\n";
    }
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}

$conn = null;

?>

Prepared statements in PHP are crucial for database security and performance. By separating SQL logic from data values, they prevent SQL injection attacks and optimize database interactions. The MySQLi and PDO extensions offer robust support for prepared statements, catering to different database management needs.

Conclusion

Object-Oriented PHP, combined with modern development tools and practices, equips developers with a comprehensive toolkit for building sophisticated web applications. As PHP continues to evolve, leveraging these advanced techniques will ensure your projects are secure, efficient, and scalable.

computer, laptop, tech

Let’s begin our coding quest

25/03/2024 / / 0 Comments

Overview

  1. Frontend Journey with Angular: Angular acts as our herald, dynamically presenting error messages to the user. It’s flexible enough to communicate with the backend, fetching the specifics of the error encountered.
  2. Backend Quest with PHP: The PHP backend serves as the keeper of knowledge, providing details about the errors through an API endpoint that our Angular front-end can consult.

Step 1: Setting Up the Angular Environment

The first step in our quest is to prepare our Angular environment:

ng new error-handling-app
cd error-handling-app
ng serve

Step 2: Enchanting the Angular AppComponent

To capture and display errors, we modify the src/app/app.component.ts:

import { Component } from '@angular/core';
import { HttpClient } from '@angular/common/http';

@Component({
  selector: 'app-root',
  templateUrl: './app.component.html',
  styleUrls: ['./app.component.css']
})
export class AppComponent {
  title = 'Error Handling App';
  errorMessage: string = '';

  constructor(private http: HttpClient) {}

  ngOnInit() {
    this.fetchError();
  }

  fetchError() {
    this.http.get<{error: string}>('/api/error')
      .subscribe(
        response => this.errorMessage = response.error,
        error => this.errorMessage = 'Failed to fetch error details.'
      );
  }
}

And within the src/app/app.component.html, we conjure the error message into visibility:

<div class="container">
  <h1>Error Occurred</h1>
  <p>{{ errorMessage }}</p>
  <a href="/">Go Back to Home</a>
</div>

Step 3: Crafting the Backend (PHP) API Endpoint

On the PHP side, we establish an API endpoint that our Angular front-end will consult to glean error details:

<?php
header('Content-Type: application/json');

$response = ['error' => 'An unexpected error occurred. Please try again later.'];

echo json_encode($response);
?>

Step 4: Uniting Frontend and Backend

  • Angular App: After building the Angular app (ng build), it can be served through a web server or intertwined within your PHP application.
  • PHP Backend: Make sure the PHP backend is accessible to the Angular app, especially considering CORS if they’re hosted separately.

Screenshot 1

Screenshot 2

Screenshot 3

Screenshot 4

Screenshot 5

PHP, Python, and AJAX

22/03/2024 / / 0 Comments

In the development of web applications, particularly those requiring dynamic user interactions without reloading the page, AJAX (Asynchronous JavaScript and XML) plays a pivotal role.

📖 Backend Powerhouses

PHP and Python are two of the most popular server-side scripting languages, each with its unique strengths in web development. PHP is widely known for its ease of use and deep integration with HTML, making it a go-to for web developers looking to quickly deploy dynamic web applications. On the other hand, Python’s simplicity, readability, and the powerful Django and Flask frameworks make it a formidable choice for building robust web applications.

🛠 Database Management systems

When it comes to database operations, both PHP and Python offer extensive support for various database management systems (DBMS) that make interactions more secure, efficient, and less prone to SQL injection.

  • PHP’s PDO (PHP Data Objects)
  • Python’s ORM (Object-Relational Mapping) tools like Django’s

💻 Implementing

AJAX allows web applications to send and retrieve data from a server asynchronously, without interfering with the display and behavior of the existing page. By using AJAX, a Task Application can perform CRUD (Create, Read, Update, Delete) operations seamlessly.

This JavaScript function could interact with a PHP script that updates a task’s status in the database. Similarly, a Python backend using Flask or Django can be set up to handle such requests.

🎨 Semantic HTML and Bootstrap:

Semantic HTML tags like <header>, <footer>, <nav>, and <article> improve the structure and readability of web content, making it more accessible and SEO-friendly. In a Task Application, using these tags can help define the structure of the app, making it easier for users and search engines to understand the content.

Conclusion

Integrating PHP or Python with AJAX for database operations in a Task Application not only enhances functionality but also improves user experience by making the application more interactive and responsive.

« Older posts

© 2024 Kvnbbg.fr

Theme by Anders Norén — Up ↑

Verified by MonsterInsights