<?
class serverActions extends sfActions
{
  /* symfony bringt doch Doctrine mit, wozu hier manuell DB-verbindungen herstellen...
  $dbhost = 'localhost';
  $dbuser = 'root';
  $dbpass = 'your password';

  $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  $dbname = 'chat_database';
  mysql_select_db($dbname);
  */

  public function executeIndex($request)
  {
    // vorher: $_POST['message']
    $message = $this->getRequestParameter('message');

    if ($message != "")
    {
      // vorher: $sql = "INSERT INTO `chat` VALUES('','$message')";
      $chatMessage = new Chat();
      $chatMessage->setText($message);
      $chatMessage->save();
    }


    /* vorher: $sql = "SELECT `Text` FROM `chat` ORDER BY `Id` DESC";
    $result = mysql_query($sql);
    while($row = mysql_fetch_array($result))
      echo $row['Text']."\n";
    */
    // das durchlaufen wir dann im template
    $this->chatMessages = Doctrine::getTable('Chat')
      ->createQuery('a')
      ->execute();

  }
}

// -- indexSuccess.php
// das war vorher "echo $row['Text']...

<?php foreach ($chatMessages as $chatMessage): ?>
<?php echo $chatMessage->getText() ?><br />
<?php endforeach; ?>
?>