phpTutorial/databases.php at master · JohnnySimple/phpTutorial · 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
<!DOCTYPE html>
<html>
<head>
    <title>PHP Databases</title>
</head>

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "myDB";

    $conn = new mysqli($servername, $username, $password, $dbname);

    if($conn->connect_error) {
        die("Connection faild: " . $conn->connect_error);
    }

    // create databae myDB
    // $sql = "CREATE DATABASE testDB";
    // if($conn->query($sql) === TRUE) {
    //     echo "Database 'testDB' created successfully!";
    // } else {
    //     echo "Error creating database:" . $conn->error;
    // }

    // sql to create table
    // $sql = "CREATE TABLE MyGuests(
    //     id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    //     firstname VARCHAR(30) NOT NULL,
    //     lastname VARCHAR(30) NOT NULL,
    //     email VARCHAR(50),
    //     reg_date TIMESTAMP
    // )";

    $sql = "CREATE TABLE LostItems(
        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        item_name VARCHAR(30) NOT NULL,
        img_name VARCHAR(30) NOT NULL,
        reg_date TIMESTAMP
    )";

    if($conn->query($sql) === TRUE ){
        echo "New table 'Items' created successfully!";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error ;
    }

    // insert into database
    // $sql = "INSERT INTO MyGuests(firstname, lastname, email)
    // VALUES ('Johnny', 'Simple', 'jsimple@gmail.com')";

    // if($conn->query($sql) === TRUE) {
    //     echo "New record created successfully!";
    // } else {
    //     echo "Error: " . $sql . "<br>" . $conn->error ;
    // }

    // preparing and binding
    // $stmt = $conn->prepare("INSERT INTO MyGuests(firstname, lastname, email) VALUES (?,?,?)");
    // $stmt->bind_param("sss", $firstname, $lastname, $email);

    // // set parameters and execute
    // $firstname = "Charles";
    // $lastname = "Obeng";
    // $email = "cobeng@gmail.com";
    // $stmt->execute();

    // $firstname = "Jefferson";
    // $lastname = "Obeng";
    // $email = "jeffersonobeng@gmail.com";
    // $stmt->execute();

    // echo "New records created successfully!";

    // $stmt->close();

    // $sql = "SELECT id, firstname, lastname FROM MyGuests";
    // $results = $conn->query($sql);
    // if($results->num_rows > 0) {
    //     while($row = $results->fetch_assoc()) {
    //         echo "id: " . $row["id"] . " Name: " . $row["firstname"] . " " . $row["lastname"] . "<br>";
    //     }
    // } else {
    //     echo "0 results";
    // }

    // deleting data
    // $delData = "DELETE FROM MyGuests WHERE id=2";
    // $conn->query($delData);

    // $conn->close();

?>

<body>

</body>
</html>