<?php
  require_once 'conn.php';
  require_once 'header.php';
  
  $sql\; =\; "SELECT\; name,\; email\; "\; .\; "FROM\; cms\_users\; "\; .\; "WHERE\; user\_id="\; .$_SESSION['user_id'];
  $result\; =\; mysql\_query($sql, $conn)\; or\; die(\text{'}Could\; not\; look\; up\; user\; data;\; \text{'}\; .\; mysql\_error());$user = mysql_fetch_array($result);\; ?>$<form method="post" action=<transact-user.php>>
  
  <p>Name:<br>
    <input type="text" id="name" name="name"
      value="<?php echo htmlspecialchars(user['name']); ?>"></p>
  
  <p>E-mail:<br>
    <input type="text" id="email" name="email"
      value="<?php echo htmlspecialchars($user[\text{'}email\text{'}]);\; ?>">$</p>
  
  <p><input type="submit" class="submit" name="action"
       value="Change my info"></p>
  
  </form>
  
  <h2>Pending Articles</h2>
  <div class="scroller">
    <table>
  <?php
  
  sql = "SELECT article_id, title, date_submitted " .
         "FROM cms_articles " .
         "WHERE is_published=0 " .
         "AND author_id=" . $\_SESSION[\text{'}user\_id\text{'}]\; .\; "\; "\; .\; "ORDER\; BY\; date\_submitted";$result = mysql_query($sql,$conn)
    or die('Could not get list of pending articles; ' . mysql_error());
  
  if (mysql_num_rows($result)\; ==\; 0)\; \{\; echo\; "$<em>No pending articles available</em>";
  } else {
    while (row = mysql_fetch_array($result))\; \{\; echo\; "$<tr>\n";
      echo '<td><a href="reviewarticle.php?article=' .
           row['article_id'] . '">' . htmlspecialchars($row[\text{'}title\text{'}])\; .\; "$</a> (submitted " .
           date("F j, Y", strtotime(row['date_submitted'])) .
           ")</td>\n";
      echo "</tr>\n";
    }
  }
  ?>
    </table>
  </div>
  <br>
  
  <h2>Published Articles</h2>
  <div class="scroller">
    <table>
  <?php
  
  $sql\; =\; "SELECT\; article\_id,\; title,\; date\_published\; "\; .\; "FROM\; cms\_articles\; "\; .\; "WHERE\; is\_published=1\; "\; .\; "AND\; author\_id="\; .$_SESSION['user_id'] . " " .
         "ORDER BY date_submitted";
  $result\; =\; mysql\_query($sql, $conn)\; or\; die(\text{'}Could\; not\; get\; list\; of\; pending\; articles;\; \text{'}\; .\; mysql\_error());\; if\; (mysql\_num\_rows($result) == 0) {
    echo "  <em>No published articles available</em>";
  } else {
    while ($row\; =\; mysql\_fetch\_array($result)) {
      echo "<tr>\n";
      echo '<td><a href="viewarticle.php?article=' .
           $row[\text{'}article\_id\text{'}]\; .\; \text{'}">\text{'}\; .\; htmlspecialchars($row['title']) .
           "</a> (published " .
           date("F j, Y", strtotime($row[\text{'}date\_published\text{'}]))\; .\; ")$</td>\n";
      echo "</tr>\n";
    }
  }
  ?>
    </table>
  </div>
  <br>
  <?php require_once 'footer.php'; ?>