File Manager

X7ROOT File Manager

Current Path: /home/u742491609/domains/apca.org.in/public_html/admin/convocation

home / u742491609 / domains / apca.org.in / public_html / admin / convocation /

?? ..
?? admin_panel.php(5.76 KB)
?? config.php(611 B)
?? create_database.php(1.32 KB)
?? delete_image.php(203 B)
?? delete_section.php(222 B)
?? edit_image.php(1.64 KB)
?? edit_section.php(4.23 KB)
?? gallery.php(2.34 KB)
?? sidebar.php(4.46 KB)
?? upload.php(1.88 KB)
?? upload_additional_images.php(1.24 KB)
?? uploads
?? uploads1746012611_DSC15.JPG(7.3 MB)
?? uploads1746012612_DSC11.JPG(6.15 MB)
?? uploads1746012612_DSC13.JPG(6.51 MB)
?? uploads1746012612_DSC14.JPG(7.1 MB)
?? uploads1746012613_DSC12.JPG(5.92 MB)
?? uploads1746012685_DSC11.JPG(6.15 MB)
?? uploads1746012685_DSC12.JPG(5.92 MB)
?? uploads1746012685_DSC13.JPG(6.51 MB)
?? uploads1746012685_DSC14.JPG(7.1 MB)
?? uploads1746012928_DSC11.JPG(6.15 MB)
?? uploads1746012978_DSC12.JPG(5.92 MB)
?? uploads1746012978_DSC13.JPG(6.51 MB)
?? uploads1746012978_DSC14.JPG(7.1 MB)
?? uploads1746013264_DSC4.JPG(6.11 MB)
?? uploads1746013264_DSC5.JPG(5.59 MB)
?? uploads1746013910_DSC2.JPG(6.51 MB)
?? uploads1746013936_DSC2.JPG(6.51 MB)
?? uploads1746013949_DSC1.JPG(6.41 MB)
?? uploads1746014085_DSC1.JPG(6.41 MB)
?? uploads1746014085_DSC2.JPG(6.51 MB)

Editing: create_database.php

<?php
$dsn = 'mysql:host=localhost';
$username = 'root';
$password = '';

try {
    // Connect to MySQL server
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Create and select the database
    $pdo->exec("CREATE DATABASE IF NOT EXISTS apca");
    $pdo->exec("USE apca");

// Create the 'inaugration' table with id, title, description, and image_path
    $inaugrationTable = "
    CREATE TABLE IF NOT EXISTS inaugration (
        id INT AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(255) NOT NULL,
        description TEXT NOT NULL,
        image_path VARCHAR(255) NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )";
    $pdo->exec($inaugrationTable);

// Create the 'convocation' table with id, title, description, and image_path

$convocationTable = "
    CREATE TABLE IF NOT EXISTS convocation (
        id INT AUTO_INCREMENT PRIMARY KEY,
        title VARCHAR(255) NOT NULL,
        description TEXT NOT NULL,
        image_path VARCHAR(255) NOT NULL,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
    )";
    $pdo->exec($convocationTable);

echo "Database and table created successfully!";
} catch (PDOException $e) {
    die('Database creation failed: ' . $e->getMessage());
}
?>

X7ROOT File Manager

Editing: create_database.php

Upload File

Create Folder