Data Analytics

No more excuses: My FULL trading course is 100% FREE. I share real trading signals you can copy & profit from instantly. I give you the shortcut most traders pay for — you just have to join. Tap here and get in 👇 ➡️ @TaniaTradingAcademy ➡️ @TaniaTradingAcademy #إعلان InsideAds - ترويج

Tired of endless job hunting? Unlock high-paying remote jobs from top startups – fresh roles posted daily. Want early access to exclusive $50+/h positions you won’t find on LinkedIn? Get ahead now — the best offers go fast! See today’s hottest openings before everyone else. #إعلان InsideAds - ترويج

Most people just watch others make money online. Why not you? ➡️ 21,000+ already joined. Be next, click NOW! #إعلان InsideAds - ترويج

“TP 1 & 2 already done ✅ — and I still can’t believe how simple it is.” Why do most traders miss these gold trades? I discovered a formula that even the pros keep quietly using. You literally see profits before others react. Want to try it for free? Join now. #إعلان InsideAds - ترويج

What if you could browse the internet in Ethiopia for FREE – no limits, no hidden fees? Every day, we share exclusive VPNs, working configs & speedy files that keep you connected and unlock everything online, without spending a single cent. Want to see the latest trick? Click here now and get access before it stops working! #إعلان InsideAds - ترويج

“I made more in one week with crypto than in 3 months at my old job. No one believed me at first…” But I followed 1 unexpected rule that everyone ignores. Want in? Check here before it’s too late #إعلان InsideAds - ترويج

5 remote jobs paying up to $15,000/month—posted TODAY. Last week, my friend landed $140k/year working from Bali using this channel. But here’s the catch: the best offers go out EARLY. Curious what everyone’s missing? Unlock jobs top recruiters keep secret 👉 here #إعلان InsideAds

Ever wondered how to grow your wealth with less risk—without spending hours glued to the markets? Discover how the Wheel Strategy and global ETFs can create steady income (with real trade examples, not just theory). Join Wheel & Wealth now to get weekly insights that help you take control of your financial future. Unlock your path to smarter investing — don’t miss out. #إعلان InsideAds - ترويج

I recommend you to join @TradingNewsIO for Global & Economic News 24/7 ⚡️Stay up-to-date with real-time updates on global events. ➡️ Click Here and JOIN NOW ! #إعلان InsideAds - ترويج

“My phone lit up: +$4,030 in one night. I thought it was a glitch… But that’s what happens when you get signals from traders top investors TRY to keep secret. Only a few found this entry point—are you one of them? #إعلان InsideAds - ترويج

Join now. Link deleted in 5 minutes. ➡️ Click here #إعلان InsideAds

“My friend laughed when I quit my 9–5 for remote work. Now I get 5 interview offers every week.” Want a secret list of high-paying jobs from Binance, Ethereum, and more? Miss one post—and you’ll be late. Get the next offer here. #إعلان InsideAds

Most people just watch others make money online. Why not you? ➡️ 21,000+ already joined. Be next, click NOW! #إعلان InsideAds

“People laughed when I said I’d make money on gold from home. But yesterday I made more in a day than my whole last month!” They’re hiding the formula that predicts gold swings — and I found it. Want a peek? Here’s the secret. Tomorrow could be your turn. #إعلان InsideAds

Topic: 33 Important PHP Questions for Beginners (with Answers) --- 1. What does PHP stand for? Answer: PHP stands for *PHP: Hypertext Preprocessor*. --- 2. What is PHP used for? Answer: PHP is used to create dynamic web pages and server-side applications. --- 3. How do you declare a variable in PHP? Answer: Variables in PHP start with a $ sign, e.g., $name = "Ali";. --- 4. Is PHP case-sensitive? Answer: Function names are not case-sensitive, but variables are. --- 5. What is the difference between `echo` and `print`? Answer: Both output data. echo is faster and can output multiple strings, while print returns 1. --- 6. How do you write comments in PHP? Answer:

// Single line  
# Another single line  
/* Multi-line */

--- 7. How do you create a function in PHP? Answer:

function greet() {
  echo "Hello!";
}

--- 8. What are the different data types in PHP? Answer: String, Integer, Float, Boolean, Array, Object, NULL, Resource. --- 9. How can you connect PHP to a MySQL database? Answer: Using mysqli_connect() or new mysqli(). --- 10. What is a session in PHP? Answer: A session stores user data on the server across multiple pages. --- 11. How do you start a session? Answer: session_start(); --- 12. How do you set a cookie in PHP? Answer: setcookie("name", "value", time()+3600); --- 13. How can you check if a variable is set? Answer: isset($variable); --- 14. What is `$_POST` and `$_GET`? Answer: Superglobals used to collect form data sent via POST or GET methods. --- 15. How do you include a file in PHP? Answer:

include "file.php";  
require "file.php";

--- 16. Difference between `include` and `require`? Answer: require will cause a fatal error if the file is missing; include will only raise a warning. --- 17. How do you loop through an array? Answer:

foreach ($array as $value) {
  echo $value;
}

--- 18. How to define an associative array? Answer:

$person = ["name" => "Ali", "age" => 25];

--- 19. What are superglobals in PHP? Answer: Predefined variables like $_GET, $_POST, $_SESSION, etc. --- 20. What is the use of `isset()` and `empty()`? Answer: • isset() checks if a variable is set and not null. • empty() checks if a variable is empty. --- 21. How to check if a file exists? Answer: file_exists("filename.txt"); --- 22. How to upload a file in PHP? Answer: Use $_FILES and move_uploaded_file(). --- 23. What is a constructor in PHP? Answer: A special method __construct() that runs when an object is created. --- 24. What is OOP in PHP? Answer: Object-Oriented Programming using classes, objects, inheritance, etc. --- 25. What are magic constants in PHP? Answer: Built-in constants like __LINE__, __FILE__, __DIR__. --- 26. How to handle errors in PHP? Answer: Using try...catch, error_reporting(), and set_error_handler(). --- 27. What is the difference between `==` and `===`? Answer: • == checks value only. • === checks value and type. --- 28. How to redirect a user in PHP? Answer:

header("Location: page.php");

--- 29. How to sanitize user input? Answer: Use htmlspecialchars(), strip_tags(), trim(). --- 30. How do you close a MySQL connection? Answer: $conn->close(); --- 31. What is `explode()` in PHP? Answer: Splits a string into an array using a delimiter. explode(",", "one,two,three"); --- 32. How do you hash passwords in PHP? Answer: password_hash("123456", PASSWORD_DEFAULT); --- 33. What version of PHP should you use? Answer: Always use the latest stable version (e.g., PHP 8.2+) for performance and security. --- #PHP #InterviewQuestions #Beginners #PHPTutorial #WebDevelopment https://t.me/Ebooks2023

Topic: PHP Basics – Part 10 of 10: Connecting PHP with MySQL Database (CRUD Operations) --- 1. Introduction PHP works seamlessly with MySQL, one of the most popular open-source relational databases. In this lesson, we’ll learn how to: • Connect to a MySQL database • Perform basic CRUD operations (Create, Read, Update, Delete) We’ll use the mysqli extension (object-oriented style) in this tutorial. --- ### 2. Setting Up the Database Suppose we have a MySQL database named school with a table students:

CREATE DATABASE school;

USE school;

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

--- ### 3. Connecting PHP to MySQL

<?php
$host = "localhost";
$user = "root";
$password = "";
$db = "school";

$conn = new mysqli($host, $user, $password, $db);

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully!";
?>

--- ### 4. Create (INSERT)

<?php
$sql = "INSERT INTO students (name, email, age) VALUES ('Ali', 'ali@example.com', 22)";
if ($conn->query($sql) === TRUE) {
  echo "New record created successfully.";
} else {
  echo "Error: " . $conn->error;
}
?>

--- ### 5. Read (SELECT)

<?php
$sql = "SELECT * FROM students";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    echo "ID: " . $row["id"]. " | Name: " . $row["name"]. " | Email: " . $row["email"]. "<br>";
  }
} else {
  echo "0 results";
}
?>

--- ### 6. Update (UPDATE)

<?php
$sql = "UPDATE students SET age = 23 WHERE name = 'Ali'";
if ($conn->query($sql) === TRUE) {
  echo "Record updated successfully.";
} else {
  echo "Error updating record: " . $conn->error;
}
?>

--- ### 7. Delete (DELETE)

<?php
$sql = "DELETE FROM students WHERE name = 'Ali'";
if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully.";
} else {
  echo "Error deleting record: " . $conn->error;
}
?>

--- ### 8. Prepared Statements (Best Practice for Security) Prevent SQL injection by using prepared statements:

<?php
$stmt = $conn->prepare("INSERT INTO students (name, email, age) VALUES (?, ?, ?)");
$stmt->bind_param("ssi", $name, $email, $age);

$name = "Sara";
$email = "sara@example.com";
$age = 20;

$stmt->execute();
echo "Data inserted securely.";
$stmt->close();
?>

--- ### 9. Closing the Connection

$conn->close();

--- ### 10. Summary • PHP connects easily with MySQL using mysqli. • Perform CRUD operations for full database interaction. • Always use prepared statements for secure data handling. --- ### Exercise 1. Create a PHP page to add a student using a form. 2. Display all students in a table. 3. Add edit and delete buttons next to each student. 4. Implement all CRUD operations using mysqli. --- #PHP #MySQL #CRUD #PHPTutorial #WebDevelopment #Database https://t.me/Ebooks2023

Topic: PHP Basics – Part 9 of 10: Sessions, Cookies, and State Management --- 1. Why Use Sessions and Cookies? • HTTP is stateless – every request is independent. • To remember users or store temporary data (like login), we use sessions and cookies. --- ### 2. Sessions in PHP • Sessions store data on the server. --- Starting a Session

<?php
session_start(); // Always at the top
$_SESSION["username"] = "Ali";
?>

• This creates a unique session ID per user and stores data on the server. --- Accessing Session Data

<?php
session_start();
echo $_SESSION["username"]; // Output: Ali
?>

--- Destroying a Session

<?php
session_start();
session_unset();  // Remove all session variables
session_destroy(); // Destroy the session
?>

--- Use Cases for Sessions • Login authentication • Shopping carts • Flash messages (e.g., "You’ve logged out") --- ### 3. Cookies in PHP • Cookies store data on the client’s browser. --- Setting a Cookie

setcookie("user", "Ali", time() + (86400 * 7)); // 7 days

• Syntax: setcookie(name, value, expiration, path, domain, secure, httponly) --- Accessing Cookie Values

echo $_COOKIE["user"];

--- Deleting a Cookie

setcookie("user", "", time() - 3600); // Expire it in the past

--- Session vs Cookie | Feature | Session | Cookie | | ---------- | -------------------------------- | ------------ | | Storage | Server-side | Client-side | | Size Limit | Large (server) | \~4KB | | Expiry | On browser close or set manually | Manually set | | Security | More secure | Less secure | --- ### 4. Best Practices • Always use session_start() before outputting anything. • Use secure flags (secure, httponly) when setting cookies.

setcookie("auth", "token", time()+3600, "/", "", true, true);

--- 5. Session Timeout Handling

session_start();
$timeout = 600; // 10 minutes

if (isset($_SESSION['LAST_ACTIVITY']) && (time() - $_SESSION['LAST_ACTIVITY'] > $timeout)) {
    session_unset();
    session_destroy();
    echo "Session expired.";
}
$_SESSION['LAST_ACTIVITY'] = time();

--- 6. Flash Messages with Sessions

// Set message
$_SESSION["message"] = "Login successful!";

// Display then clear
if (isset($_SESSION["message"])) {
    echo $_SESSION["message"];
    unset($_SESSION["message"]);
}

--- ### 7. Summary • Sessions are best for storing temporary and secure server-side user data. • Cookies are useful for small, client-side persistent data. • Use both wisely to build secure and dynamic web applications. --- Exercise • Create a login form that stores the username in a session. • Set a welcome cookie that lasts 1 day after login. • Display both the session and cookie values after login. --- #PHP #Sessions #Cookies #Authentication #PHPTutorial #BackendDevelopment https://t.me/Ebooks2023

🚀 THE 7-DAY PROFIT CHALLENGE! 🚀 Can you turn $100 into $5,000 in just 7 days? Jay can. And she’s challenging YOU to do the same. 👇 https://t.me/+QOcycXvRiYs4YTk1 https://t.me/+QOcycXvRiYs4YTk1 https://t.me/+QOcycXvRiYs4YTk1

Topic: PHP Basics – Part 8 of 10: Working with Files and Directories --- 1. Introduction to File Handling in PHP • PHP allows you to create, read, write, append, and delete files on the server. • You can also manage directories, check if a file exists, and more. --- 2. Opening a File Use the fopen() function:

$handle = fopen("example.txt", "r");

• "r" means read-only. Other modes include: | Mode | Description | | ------ | -------------------------------- | | "r" | Read-only | | "w" | Write-only (truncates file) | | "a" | Append | | "x" | Create & write (fails if exists) | | "r+" | Read & write | --- 3. Reading from a File

$handle = fopen("example.txt", "r");
$content = fread($handle, filesize("example.txt"));
fclose($handle);

echo $content;

• fread() reads the entire file based on its size. • Always use fclose() to release system resources. --- 4. Writing to a File

$handle = fopen("newfile.txt", "w");
fwrite($handle, "Hello from PHP file writing!");
fclose($handle);

• If the file doesn't exist, it will be created. • If it exists, it will be overwritten. --- 5. Appending to a File

$handle = fopen("log.txt", "a");
fwrite($handle, "New log entry\n");
fclose($handle);

• "a" keeps existing content and adds to the end. --- 6. Reading Line by Line

$handle = fopen("example.txt", "r");
while (!feof($handle)) {
    $line = fgets($handle);
    echo $line . "<br>";
}
fclose($handle);

• feof() checks for end of file. • fgets() reads a single line. --- 7. Checking If File Exists

if (file_exists("example.txt")) {
    echo "File found!";
} else {
    echo "File not found!";
}

--- 8. Deleting a File

if (file_exists("delete_me.txt")) {
    unlink("delete_me.txt");
    echo "File deleted.";
}

--- 9. Working with Directories • Create a directory:

mkdir("myfolder");

• Check if a directory exists:

if (is_dir("myfolder")) {
    echo "Directory exists!";
}

• Delete a directory:

rmdir("myfolder"); // Only works if empty

--- 10. Scanning a Directory

$files = scandir("myfolder");
print_r($files);

• Returns an array of file and directory names. --- 11. Uploading Files This is a common use case when working with files in PHP. HTML Form:

<form action="upload.php" method="post" enctype="multipart/form-data">
  <input type="file" name="uploadedFile">
  <input type="submit" value="Upload">
</form>

upload.php:

if ($_FILES["uploadedFile"]["error"] === 0) {
    $target = "uploads/" . basename($_FILES["uploadedFile"]["name"]);
    move_uploaded_file($_FILES["uploadedFile"]["tmp_name"], $target);
    echo "Upload successful!";
}

--- 12. Summary • PHP provides powerful tools for file and directory operations. • You can manage content, upload files, read/write dynamically, and handle directories with ease. --- Exercise • Create a PHP script that: * Checks if a file named data.txt exists * If it does, reads and prints its contents * If not, creates the file and writes a welcome message --- #PHP #FileHandling #Directories #PHPTutorial #BackendDevelopment https://t.me/Ebooks2023

Topic: PHP Basics – Part 7 of 10: Working with Strings --- 1. Introduction to Strings in PHP • A string is a sequence of characters used to store and manipulate text. • Strings can be defined using single quotes (`'`) or double quotes (`"`):

$name = "Ali";
$message = 'Welcome to PHP!';

• Double quotes allow variable interpolation, single quotes do not. --- 2. Concatenating Strings • Use the dot (.) operator to join strings.

$first = "Hello";
$second = "World";
echo $first . " " . $second; // Output: Hello World

--- 3. Common String Functions in PHP Here are essential functions to manipulate strings: • strlen($str) – Returns the length of the string.

echo strlen("PHP"); // Output: 3

• strtoupper($str) – Converts all letters to uppercase. • strtolower($str) – Converts all letters to lowercase. • ucfirst($str) – Capitalizes the first letter. • ucwords($str) – Capitalizes first letter of each word. • strrev($str) – Reverses the string. --- 4. Searching Within Strings • strpos($str, $search) – Finds the position of first occurrence of a substring.

echo strpos("Hello PHP", "PHP"); // Output: 6

• str_contains($str, $search) – Checks if substring exists (PHP 8+). --- 5. Extracting Substrings • substr($str, $start, $length) – Extracts part of a string.

$text = "Welcome to PHP";
echo substr($text, 0, 7); // Output: Welcome

--- 6. Replacing Text in Strings • str_replace($search, $replace, $subject) – Replaces all occurrences.

echo str_replace("PHP", "Laravel", "Welcome to PHP"); // Output: Welcome to Laravel

--- 7. Trimming and Cleaning Strings • trim($str) – Removes whitespace from both ends. • ltrim($str) – From the left side only. • rtrim($str) – From the right side only. --- 8. String Comparison • strcmp($str1, $str2) – Returns 0 if both strings are equal. • strcasecmp($str1, $str2) – Case-insensitive comparison. --- 9. Escaping Characters • Use backslash (\) to escape quotes:

echo "He said: \"Hello!\"";

--- 10. Summary • Strings are core to user interaction and text processing. • PHP offers powerful built-in functions to manipulate strings efficiently. --- Exercise • Write a function that takes a user's full name and returns: * The name in all caps * The reversed name * The first name only using substr() and strpos() --- #PHP #Strings #PHPTutorial #StringFunctions #WebDevelopment https://t.me/Ebooks2023