X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;ds=sidebyside;f=index.php;h=bf2249bfd14920d5550c47184bd62ba7bcd57499;hb=60e2ac52bbf649d4b04f91bc731672a94c4373a8;hp=a93e0950f9cbbbb34afa6cdd22d8c0f983d2b65f;hpb=2896368ff2e6a5dec69ab99a07491447825fc1d5;p=dylansserver.git
diff --git a/index.php b/index.php
index a93e095..bf2249b 100644
--- a/index.php
+++ b/index.php
@@ -13,10 +13,10 @@ abstract class cms {
public function __construct() {
$config = parse_ini_file($this->config_file, true);
$this->db = new mysqli(
- $config[database]['domain'],
- $config[database]['user'],
- $config[database]['password'],
- $config[database]['database']);
+ $config['database']['domain'],
+ $config['database']['user'],
+ $config['database']['password'],
+ $config['database']['database']);
if (mysqli_connect_errno()) {
echo "Problem connecting to database: ";
echo mysqli_connect_error();
@@ -163,7 +163,7 @@ class index extends cms {
";
- $sql = "SELECT text FROM projects";
+ $sql = "SELECT text FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo $entry->text;
@@ -201,7 +208,7 @@ OTHER_PROJECTS;
my projects:
HEREDOC;
- $sql = "SELECT title FROM projects";
+ $sql = "SELECT title FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo "
$entry->title ";
@@ -243,15 +250,17 @@ class page extends cms {
$this->scripts = "
-
-
+
+
@@ -344,22 +353,24 @@ class note extends cms {
$this->scripts = "
-
-
+
+
";
if (isset($_GET['comments'])) {
- $this->scripts += "
+ $this->scripts .= "
";
}
@@ -431,8 +442,8 @@ class note extends cms {
// and a default author needs to be set
// for no-javascript users.
$stmt->bind_param('sss',
- htmlspecialchars($_POST['name']),
- htmlspecialchars($_POST['text']),
+ $_POST['name'],
+ $_POST['text'],
$this->id);
$stmt->execute();
}
@@ -487,7 +498,7 @@ END_OF_NAVIGATION;
$date_posted = $entry['date_posted'];
$author = $entry['author'];
$text = htmlspecialchars($entry['text']);
- $head = "
$author ";
+ $head = "
" . htmlspecialchars($author) . " ";
echo <<