[phpwebapp-commits] CVS: top10/templates/proj_details/comments new_comment.html,NONE,1.1 comments.php,NONE,1.1 comments.html,NONE,1.1 comments.db,NONE,1.1

[Dashamir H. <das...@us...>]

Update of /cvsroot/phpwebapp/top10/templates/proj_details/comments
In directory sc8-pr-cvs1:/tmp/cvs-serv24571/templates/proj_details/comments

Added Files:
	new_comment.html comments.php comments.html comments.db 
Log Message:


--- NEW FILE: new_comment.html ---
<table width="100%">
  <tr>
    <td colspan="2">Submit a new comment:</td>
  </tr>
  <form>
  <tr>
    <td>Username:</td>
    <td>
      <input type="text" size="20" value="{{username}}">
    </td>
  </tr>
  <tr>
    <td>Subject:</td>
    <td>
      <input type="text" size="80">
    </td>
  </tr>
  <tr>
    <td valign="top">Comment:</td>
    <td>
      <textarea rows="10" cols="70"></textarea>
    </td>
  </tr>
  <tr>
    <td></td>
    <td>
      <a class="button" href="">Submit</a>
    </td>
  </tr>
  </form>
</table>

--- NEW FILE: comments.php ---
<?php
class comments extends WebObject
{
  function onRender()
    {
    }
}
?>
--- NEW FILE: comments.html ---
<WebBox ID="comments"
<Repeat rs="comment_list">
  <IfEmpty>
    No comments submitted yet.<br>
  </IfEmpty>
  Username: {{username}}, Date: {{date}} <br>
  Comment: <br>
  {{comment}}
  <hr>
</Repeat>
<br>

<Include SRC="{{./}}new_comment.html" />
</WebBox>

--- NEW FILE: comments.db ---
<!--# -*-SQL-*- #tell emacs to use SQL mode #-->

<Recordset ID="comment_list">
  <Query>
    SELECT comment_id, username, date, comment 
    FROM comments
    WHERE proj_id = '{{proj_id}}'
  </Query>
</Recordset>