Coding Skill Builder 💪📚(Full AI Based)
Open in Telegram
🌟 Welcome to Coding Skill Builder! Unlock your potential with quick tips and tutorials on personal development, professional skills, and creative pursuits. Join our community and start building your skills today! 💪📚✨ ⏩ https://t.me/+4hTMRVjnQ2oyMGQ1
Show more287
Subscribers
No data24 hours
No data7 days
-630 days
Posts Archive
Repost from Bot Nations 🚀
🚀 Exciting News: Swastik Hosting APK is Now Live!
We are thrilled to announce the launch of the Swastik Hosting APK, designed to make hosting your PHP bots easier than ever—completely hassle-free and at no cost! Now, you can manage your bots directly from your device, anytime and anywhere.
📥 Download it here: https://t.me/MultipleFileShareBot?start=67e280cf399c1
With our app, you’ll enjoy a fast, secure, and user-friendly experience. Say goodbye to complicated setups! Simply upload your bot files, set the webhook, and you’re ready to go!
We’re committed to continuously enhancing our platform. If you encounter any issues or have suggestions for improvements, please don’t hesitate to leave a comment below. Your feedback is invaluable in helping us make Swastik Hosting even better!
Thank you for being a part of our community! 🌟
Repost from Bot Nations 🚀
📅 Save the Date!🚀 We’re relaunching Swastik Hosting with more power and top-notch security!
🔥 Get ready for an even better experience.⏳ Check out the countdown and get ready for the big launch: https://swastikhosting.serv00.net/ 🔔 Be the first to know! Enable notifications and stay updated! #SwastikHosting #Relaunch #MorePower #BetterSecurity #StayTuned
Check out this link for completely free hosting! 🎉
👉 https://t.me/MultipleFileShareBot?start=679f9ffe786f6
▎Day 9: Securing Your API with API Key Authentication
Welcome to Day 9! Today, we’ll delve into the crucial topic of securing your API through the use of API Keys. This method ensures that only authorized users or applications can access your APIs, thereby safeguarding your services and data.
API keys are widely utilized across various web services to restrict access exclusively to trusted users, enhancing both security and control.
---
▎1. Understanding API Keys
An API Key is a unique identifier that is included in every request to authenticate the requester. It serves not only as a means of verification but also as a tool for monitoring and managing API usage, ensuring that only legitimate users can access specific resources.
---
▎2. Implementing API Key Authentication
In this section, we will set up a straightforward system that checks the API key provided in the request, allowing or denying access to designated API routes based on its validity.
---
▎PHP Code for API Key Authentication (auth_api.php)
1. Store a Predefined API Key: For security reasons, you should store this key in a configuration file or an environment variable rather than hardcoding it directly in your script.
2. Validate Incoming Requests: The following code snippet checks the API key in the header of incoming requests.
<?php
header('Content-Type: application/json');
// Predefined API Key (replace this with your own secure key)
define('API_KEY', 'your_api_key_here'); // Replace with your actual API key
// Retrieve the API key from the request header
$apiKey = isset($_SERVER['HTTP_X_API_KEY']) ? $_SERVER['HTTP_X_API_KEY'] : null;
// Validate the provided API key
if ($apiKey !== API_KEY) {
echo json_encode(["status" => "error", "message" => "Unauthorized: Invalid API Key"]);
exit; // Halt execution if the API key is invalid
}
// If the key is valid, proceed with the desired API functionality
echo json_encode(["status" => "success", "message" => "API Request Successful"]);
?>
http://yourdomain.com/auth_api.php
2. Method: GET
3. Headers:
• Key: X-API-KEY
• Value: your_api_key_here (use the predefined API key you set in the script)
4. Expected Success Response:
{
"status": "success",
"message": "API Request Successful"
}
{
"status": "error",
"message": "Unauthorized: Invalid API Key"
}
X-API-KEY to transmit the API key securely.
• Security Considerations: Emphasizes the importance of keeping API keys secure, such as storing them in a database for individual users or sessions.
---
▎Task for Day 9:
1. Implement the auth_api.php script on your server.
2. Test the API key authentication functionality using Postman.
3. Explore options for securely storing API keys in a database and consider generating unique keys for each user.
---
Join us tomorrow as we explore Error Handling and Custom Error Responses in APIs!▎Day 8: Deleting Data from MySQL (DELETE Request)
Welcome to Day 8! After learning how to retrieve and update user data, today we’ll dive into the process of deleting a user from the database using a DELETE request.
---
▎1. Understanding the DELETE Method
In the world of APIs, different HTTP methods serve distinct purposes:
• GET → Fetch data
• POST → Add new data
• PUT → Update existing data
• DELETE → Remove data
A DELETE request is specifically designed to permanently eliminate a record from the database.
---
▎2. Creating the Delete API (DELETE Method)
Today, we will create an API that allows us to delete a user based on their unique ID.
PHP Code (delete_user.php)
<?php
header('Content-Type: application/json');
// Database connection details
$host = 'localhost';
$dbname = 'api_example';
$username = 'root';
$password = '';
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Ensure that only DELETE requests are processed
if ($_SERVER['REQUEST_METHOD'] === 'DELETE') {
$deleteData = file_get_contents("php://input");
$data = json_decode($deleteData, true);
if (isset($data['id'])) {
$id = intval($data['id']);
$stmt = $pdo->prepare("DELETE FROM users WHERE id = ?");
$stmt->execute([$id]);
if ($stmt->rowCount() > 0) {
echo json_encode(["status" => "success", "message" => "User deleted successfully!"]);
} else {
echo json_encode(["status" => "error", "message" => "User not found or already deleted."]);
}
} else {
echo json_encode(["status" => "error", "message" => "User ID is required."]);
}
} else {
echo json_encode(["status" => "error", "message" => "Invalid request method. Please use DELETE."]);
}
} catch (PDOException $e) {
echo json_encode(["status" => "error", "message" => "Database error: " . $e->getMessage()]);
}
?>
http://yourdomain.com/delete_user.php
2. Method: DELETE
3. Body (JSON, raw format):
{
"id": 1
}
{
"status": "success",
"message": "User deleted successfully!"
}
{
"status": "error",
"message": "User not found or already deleted."
}
{
"status": "error",
"message": "User ID is required."
}
file_get_contents("php://input").
• SQL DELETE Query: The command DELETE FROM table_name WHERE condition effectively removes records from the database.
• Checking rowCount(): This function helps ensure that a record was actually deleted before sending a success message.
---
▎Task for Day 8:
• Implement the delete_user.php API on your server.
• Test the deletion of various users using Postman.
• Modify the API to support multiple deletions at once (e.g., allowing deletion of multiple user IDs in a single request).
Tomorrow, we’ll explore API Authentication using API Keys! Get ready to enhance your application's security!Stay tuned for tomorrow's lesson, where we will explore how to delete a user using a DELETE request!
Day 7: Updating Data in MySQL with a PUT Request
Welcome to Day 7! Today, we will delve into the process of updating user data within our database using a PUT request. This functionality is crucial for maintaining accurate user profiles, adjusting product details, or managing any other modifiable data within an API.
---
▎1. Understanding the PUT Method
To refresh your memory, here’s a quick overview of the HTTP methods we’ll be working with:
• GET → Retrieve data
• POST → Create new data
• PUT → Modify existing data
• DELETE → Remove data
The PUT request specifically allows us to update an existing record by sending new values for designated fields.
---
▎2. Creating an Update API (PUT Method)
In this section, we will develop an API that updates a user's name, email, or age based on their unique ID.
PHP Code (Update User API - update_user.php):
<?php
header('Content-Type: application/json');
// Database connection parameters
$host = 'localhost';
$dbname = 'api_example';
$username = 'root';
$password = '';
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Ensure only PUT requests are processed
if ($_SERVER['REQUEST_METHOD'] === 'PUT') {
$putData = file_get_contents("php://input");
$data = json_decode($putData, true);
// Validate input data
if (isset($data['id']) && isset($data['name']) && isset($data['email']) && isset($data['age'])) {
$sql = "UPDATE users SET name = ?, email = ?, age = ? WHERE id = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$data['name'], $data['email'], $data['age'], $data['id']]);
// Check if the update was successful
if ($stmt->rowCount() > 0) {
echo json_encode(["status" => "success", "message" => "User updated successfully!"]);
} else {
echo json_encode(["status" => "error", "message" => "User ID not found or no changes made."]);
}
} else {
echo json_encode(["status" => "error", "message" => "Invalid input. 'id', 'name', 'email', and 'age' are required."]);
}
} else {
echo json_encode(["status" => "error", "message" => "Invalid request method. Please use PUT."]);
}
} catch (PDOException $e) {
echo json_encode(["status" => "error", "message" => "Database error: " . $e->getMessage()]);
}
?>
http://yourdomain.com/update_user.php
2. Method: PUT
3. Body (Select JSON, raw format):
{
"id": 1,
"name": "Swastik Raj",
"email": "swastik.raj@example.com",
"age": 26
}
{
"status": "success",
"message": "User updated successfully!"
}
{
"status": "error",
"message": "User ID not found or no changes made."
}
{
"status": "error",
"message": "Invalid input. 'id', 'name', 'email', and 'age' are required."
}
file_get_contents("php://input") to read raw JSON input effectively.
• SQL UPDATE Query: Modifies existing records using the syntax UPDATE table_name SET column=value WHERE condition.
• Checking rowCount(): Verifies whether the update was successful before sending a success message.
---
▎Task for Day 7:
1. Implement the update_user.php API on your server.
2. Test updating various users using Postman.
3. Modify the API to allow updates for specific fields only (e.g., updating just the email without altering the name or age).▎Day 6: Retrieving Data from MySQL (GET Request)
Now that we can store user data in MySQL, let’s learn how to fetch that data from the database using a GET request.
---
▎1. Fetching All Users from the Database
We’ll create an API endpoint that retrieves all users stored in the database.
PHP Code (Get All Users):
<?php
// Set response type to JSON
header('Content-Type: application/json');
// Database connection parameters
$host = 'localhost';
$dbname = 'api_example';
$username = 'root'; // Replace with your MySQL username
$password = ''; // Replace with your MySQL password
try {
// Establish a new PDO connection
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Fetch all users from the database
$stmt = $pdo->query("SELECT * FROM users");
$users = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Return the users as a JSON response
echo json_encode($users);
} catch (PDOException $e) {
// Handle any errors that occur during the database operation
echo json_encode(["status" => "error", "message" => "Database error: " . $e->getMessage()]);
}
?><?php
header('Content-Type: application/json');
// Database connection parameters
$host = 'localhost';
$dbname = 'api_example';
$username = 'root';
$password = '';
try {
// Establish a new PDO connection
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Check if the user ID is provided in the query string
if (isset($_GET['id'])) {
$id = intval($_GET['id']);
// Prepare and execute the SQL statement
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$id]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
// Return the user data or an error message if not found
if ($user) {
echo json_encode($user);
} else {
echo json_encode(["status" => "error", "message" => "User not found"]);
}
} else {
echo json_encode(["status" => "error", "message" => "User ID is required"]);
}
} catch (PDOException $e) {
// Handle any errors that occur during the database operation
echo json_encode(["status" => "error", "message" => "Database error: " . $e->getMessage()]);
}
?>http://yourdomain.com/get_users.php
• Expected Response:
[
{"id":1, "name":"Swastik", "email":"swastik@example.com", "age":25},
{"id":2, "name":"John", "email":"john@example.com", "age":30}
]http://yourdomain.com/get_users.php?id=1
• Expected Response:
{
"id": 1,
"name": "Swastik",
"email": "swastik@example.com",
"age": 25
}query(): Executes a SQL query to fetch multiple records.
• prepare() and execute(): Securely fetches data with parameters to prevent SQL injection.
• PDO::FETCH_ASSOC: Fetches data as an associative array, allowing easy access to column values by their names.
---
▎Task for Day 6:
1. Create both get_users.php and get_user_by_id.php.
2. Test fetching all users and a specific user by ID.
3. Modify the API to return an error message if no users exist.
---
▎Looking Ahead
Tomorrow, we’ll implement UPDATE (PUT) requests to modify user data! Get ready to enhance your API further!Day 5: Working with Databases (MySQL) for Storing Data
Today marks an exciting milestone as we integrate MySQL into our API, enabling us to efficiently store and retrieve user data. We will develop an API that allows for the seamless addition of users to a database and facilitates their retrieval later on.
---
▎1. Setting Up Your MySQL Database
To begin, you will need to establish a MySQL database to hold the user information.
SQL Queries to Create the Database and Table:
CREATE DATABASE api_example;
USE api_example;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
age INT NOT NULL
);
api_example and a users table, which includes columns for user ID, name, email, and age.
---
▎2. PHP Code to Insert Data into the MySQL Database
Next, we will enhance our API to allow for the addition of new users to the database using a POST request.
PHP Code to Insert User into Database:
<?php
// Set response type to JSON
header('Content-Type: application/json');
// Database connection parameters
$host = 'localhost';
$dbname = 'api_example';
$username = 'root'; // Replace with your MySQL username
$password = ''; // Replace with your MySQL password
try {
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Retrieve raw POST data
$postData = file_get_contents("php://input");
$data = json_decode($postData, true);
if (isset($data['name']) && isset($data['email']) && isset($data['age'])) {
// Prepare SQL query to insert data
$sql = "INSERT INTO users (name, email, age) VALUES (?, ?, ?)";
$stmt = $pdo->prepare($sql);
$stmt->execute([$data['name'], $data['email'], $data['age']]);
$response = [
"status" => "success",
"message" => "User added successfully!",
"user_id" => $pdo->lastInsertId() // Return unique ID of the newly added user
];
} else {
$response = [
"status" => "error",
"message" => "Invalid input. 'name', 'email', and 'age' are required."
];
}
} catch (PDOException $e) {
$response = [
"status" => "error",
"message" => "Database error: " . $e->getMessage()
];
}
// Send response as JSON
echo json_encode($response);
?>
insert_user.php.
2. Use Postman or another API testing tool:
• URL: http://yourdomain.com/insert_user.php
• Method: POST
• Body (JSON):
{
"name": "Swastik",
"email": "swastik@example.com",
"age": 25
}
{
"status": "success",
"message": "User added successfully!",
"user_id": "<unique_id>"
}
Day 4: Handling POST Requests in Your API
Today, we’ll learn to handle POST requests to accept and process client data, used for creating new records.
1. GET vs. POST
• GET: Sends data via URL (query parameters). Used for fetching data.
• POST: Sends data in request body. Used for creating/submitting data securely.
2. Creating a POST API Endpoint
Let’s create an API to add a new user via a POST request.
PHP Code:
<?php
header('Content-Type: application/json');
$postData = file_get_contents("php://input");
$data = json_decode($postData, true);
if (isset($data['name']) && isset($data['email'])) {
$response = [
"status" => "success",
"message" => "User added successfully!",
"user" => [
"name" => $data['name'],
"email" => $data['email']
]
];
} else {
$response = [
"status" => "error",
"message" => "Invalid input. 'name' and 'email' are required."
];
}
echo json_encode($response);
?>
post_api.php.
Use Postman or a similar tool to test:
• URL: http://yourdomain.com/post_api.php
• Method: POST
• Body (JSON): { "name": "Swastik", "email": "swastik@example.com" }
{ "status": "success", "message": "User added successfully!", "user": { "name": "Swastik", "email": "swastik@example.com" } }
{ "status": "error", "message": "Invalid input. 'name' and 'email' are required." }
file_get_contents("php://input"): Reads raw POST data.
• json_decode(): Converts JSON to PHP array.
• Validation: Ensures required data is present.
Task for Day 4:
• Create this API.
• Test with valid and invalid JSON inputs.
• Modify the API to accept an additional field.
Tomorrow, we’ll work with databases to store data!Day 3: Building Your First API Endpoint
Welcome to Day 3! Today, we’re excited to guide you through the process of creating a fully functional REST API endpoint that will accept requests and return meaningful data.
---
▎1. Understanding API Endpoint Structure
An API endpoint is essentially a URL through which your API can be accessed. For example:
http://yourdomain.com/api/endpoint.php
In this session, we’ll construct an API that processes GET requests and responds with user data.
---
▎2. PHP Code for Your API
Let’s create an API that delivers user information in a structured format.
<?php
// Set the response type to JSON
header('Content-Type: application/json');
// Simulate user data (this can be replaced with a database connection later)
$users = [
["id" => 1, "name" => "Swastik", "email" => "swastik@example.com"],
["id" => 2, "name" => "John", "email" => "john@example.com"],
["id" => 3, "name" => "Jane", "email" => "jane@example.com"]
];
// Check if a 'user_id' parameter is provided in the URL
if (isset($_GET['user_id'])) {
$userId = intval($_GET['user_id']);
$user = array_filter($users, fn($u) => $u['id'] === $userId);
if (!empty($user)) {
echo json_encode(array_values($user)[0]); // Return the user data
} else {
echo json_encode(["error" => "User not found"]); // Return an error message
}
} else {
// If no 'user_id' is specified, return all users
echo json_encode($users);
}
?>
api.php in your server directory.
2. Access the API using your web browser or Postman:
• To retrieve all users:
http://yourdomain.com/api.php
• To retrieve a specific user:
http://yourdomain.com/api.php?user_id=2
---
▎4. Key Concepts Introduced
• Query Parameters: Information sent through the URL (e.g., user_id=2).
• JSON Encoding: Transforming PHP arrays into JSON format using json_encode().
• Condition Handling: Implementing checks for specific parameters in requests.
---
▎Task for Day 3:
1. Implement the API on your local server.
2. Test the functionality with and without the user_id parameter.
3. Enhance the script by adding more fields to the user data (e.g., age, city).
Tomorrow, we’ll take a deeper dive into handling POST requests, expanding our API's capabilities! Happy coding!Day 2: REST API Basics
1. What is REST?
REST means Representational State Transfer.
It is a way to design applications that communicate over the internet. REST uses simple HTTP methods to send and receive information.
REST APIs do not keep any information about previous requests. This means every time you ask for something, you need to include all the details needed to process your request.
2. REST API Methods:
• GET: Use this to get data from the server (like getting user details).
• POST: Use this to send new data to the server (like creating a new user).
• PUT: Use this to change existing data on the server (like updating user information).
• DELETE: Use this to remove data from the server (like deleting a user).
3. HTTP Status Codes:
• 200 OK: Your request was successful.
• 201 Created: A new item was successfully created.
• 400 Bad Request: There was something wrong with your request.
• 404 Not Found: The item you asked for could not be found.
• 500 Internal Server Error: The server had an error while processing your request.
4. Request and Response Structure:
Request: When you make a request, it usually includes:
• Method (GET, POST, etc.)
• URL (the address you are trying to reach)
• Headers (extra information, optional)
• Body (the data you send, for POST/PUT requests)
Response: When the server replies, it usually includes:
• Status Code (like 200 or 404)
• Headers (extra information, optional)
• Body (usually in JSON or XML format)
5. Creating Your First REST API Endpoint:
Make a simple PHP file that sends back some data in JSON format using the GET method.
Example Code:
<?php
header('Content-Type: application/json');
$response = array("message" => "Hello, World! This is your first API endpoint.");
echo json_encode($response);
?>
Day 1: Introduction to PHP and APIs
1. Basics of PHP:
PHP, which stands for Hypertext Preprocessor, is a powerful server-side scripting language designed for creating dynamic websites and web applications. With PHP, code is executed on the server, generating output that is sent to the browser as standard HTML.
Key Syntax in PHP:
• Begin a PHP script with
<?php and conclude with ?>.
• Variables in PHP are prefixed with a dollar sign ($). For instance: $name = "Swastik";
• To display output, you can use echo or print. Example: echo "Hello, World!";
• Ensure each statement ends with a semicolon (;).
Example Code:
<?php
$name = "Swastik";
echo "Welcome to the 30-day PHP API session, $name!";
?>
