php-sql-mysql/links-list-solution.php at main · codeadamca/php-sql-mysql · 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
<?php

// Connect to the MySQL database
$connect = mysqli_connect('<DB_HOST>', '<DB_USER>', '<DB_PASSWORD>', '<DB_DATABASE>');

// If the connection did not work, display an error message
if (!$connect)
{
    echo 'Error Code: ' . mysqli_connect_errno() . '<br>';
    echo 'Error Message: ' . mysqli_connect_error() . '<br>';
    exit;
}

?>
<!doctype html>
<html>
    <head>
        <title>PHP amd MySQL</title>
    </head>
    <body>

        <h1>PHP and MySQL</h1>

        <?php

        // Create a query
        $query = 'SELECT id,name,url,image,description
            FROM links
            ORDER BY name';

        // Execute the query
        $result = mysqli_query($connect, $query);

        // If there is no result, display an error message
        if (!$result)
        {
            echo 'Error Message: ' . mysqli_error($connect) . '<br>';
            exit;
        }

        // Display the number of recirds found
        echo '<p>The query found ' . mysqli_num_rows($result) . ' rows:</p>';

        // Loop through the records found
        while ($record = mysqli_fetch_assoc($result))
        {

            // Output the record using if statements and echo
            echo '<hr>';

            if ($record['name'])
            {
                echo '<h2>' . $record['name'] . '</h2>';
            }
            else
            {
                echo '<h2>' . $record['url'] . '</h2>';
            }

            if ($record['description'])
            {
                echo '<p>' . $record['description'] . '</p>';
            }

            if ($record['image'])
            {
                echo '<img src="' . $record['image'] . '" width="100">';
            }


            if ($record['url'])
            {

                echo '<br>';

                echo '<a href="' . $record['url'] . '">';

                if ($record['name'])
                {
                    echo 'Visit ' . $record['name'];
                }
                else
                {
                    echo $record['url'];
                }

                echo '</a>';
            }

            // This code will help with debugging
            echo '<pre>';
            print_r($record);
            echo '</pre>';

        }

        ?>


    </body>
</html>