phpProject/ini.php at master · aug-projects/phpProject · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<?php

/*
|--------------------------------------------------------------------------
| Header : URL links and title
|--------------------------------------------------------------------------
|
*/

$headerMenus = [
    [
        'title' => 'Personal Information',
        'url' => '/pages/home.php',
    ],
    [
        'title' => 'Courses Information',
        'url' => '/pages/viewCourses.php',
    ],
    [
        'title' => 'Experiences Information',
        'url' => '/pages/viewExperience.php',
    ],
    [
        'title' => 'Add Courses',
        'url' => '/pages/addCourse.php',
    ],
    [
        'title' => 'Add Experiences',
        'url' => '/pages/AddExperience.php',
    ],
];

/*
|--------------------------------------------------------------------------
| Pages
|--------------------------------------------------------------------------
|
*/

$pages = [
    'home'=>[
        'title' => 'Personal Information',
        'image' => '/assets/images/info.png',
    ],
    'course'=>[
        'title' => 'Courses Information',
    ],
    'courses'=>[
        'title' => 'All Courses Information',
        'image' => '/assets/images/info.png',
    ],
    'add-courses'=>[
        'title' => 'Add Courses',
        'image' => '/assets/images/add-course.png',
    ],
    'experience'=>[
        'title' => 'All Experiences Information',
    ],
    'add-experiences'=>[
        'title' => 'Add Experiences',
        'image' => '/assets/images/add-experience.png',
    ],
];


/*
|--------------------------------------------------------------------------
| Layout
|--------------------------------------------------------------------------
|
*/

$layout = [
    'head' => __DIR__.'/layout/head.php',
    'header' =>  __DIR__.'/layout/header.php',
    'home' =>  __DIR__.'/pages/home.php',
];


/*
|--------------------------------------------------------------------------
| Data and Sql
|--------------------------------------------------------------------------
|
*/


$categories = [
    'job',
    'training',
];


include "config.php";
// user
$properties = $connection->prepare("select * from properties");
$user = $connection->prepare("select * from users limit 1");
// experiences
$experiences = $connection->prepare("select * from experiences");
$addExperience = $connection->prepare("insert into experiences(category, title, start_month, end_month, institution, description) values ( ? ,? ,?,?,?,?)");
// courses
$courses = $connection->prepare("select * from courses");
$course = $connection->prepare("select * from courses where id=?");
$addCourse = $connection->prepare("insert into courses(title, total_hours, date_start, date_end, institution, attachment_type, attachment, note) values (?, ? ,? ,?,?,?,?,?)");