syphoxy/0-mixed.phtml

## 0-mixed.phtml
<!-- Your mixed HTML+PHP page script (pseudo-code) -->
<?php mysql_connect(/* database details */) ?>
<?php $result = mysql_query(/* get current page from db */) ?>
<?php $page = mysql_fetch_assoc($result) ?>
<html>
  <head>
    <title><?php echo htmlentities($page['title']) ?></title>
  </head>
  <body>
    <h1><?php echo htmlentities($page['title']) ?></h1>
    <ul>
      <?php $result = mysql_query(/* SQL Query */) ?>
      <?php while($row = mysql_fetch_assoc($result)): ?>
      <li><?php echo htmlentities($row['title']) ?></li>
      <?php end ?>
    </ul>
  </body>
</html>

## 1-1-model.php
<?php // Your Post Model Class (pseudo-code)
class PostModel extends ModelAbstract
{
    // model specific code here
}


## 1-2-controller.php
<?php // Your Index Controller Class (pseudo-code)
class IndexController extends ControllerAbstract
{
    public function showAction($request)
    {
        // call on Post model to get by ID
        $post = new PostModel($request->id);

        // expost post to view script
        $this->view->post = $post;
    }
}

## 1-3-view.phtml
<!-- Your controller action template (pseudo-code) -->
<html>
  <head>
    <title><?php echo htmlentities($this->post->title) ?></title>
  </head>
  <body>
    <h1><?php echo htmlentities($this->post->title) ?></h1>
    <p><?php echo $this->post->content ?></p>
  </body>
</html>

## 2-0-module.xml
<?xml version="1.0"?>
<config>
  <modules>
    <NAMESPACE_Twitter>
      <active>true</active>
      <codePool>local</codePool>
    </NAMESPACE_Twitter>
  </modules>
</config>

## 2-1-config.xml
<?xml version="1.0"?>
<config>
  <modules>
    <NAMESPACE_Twitter>
      <version>0.0.1</version>
    </NAMESPACE_Twitter>
  </modules>
  <global>
    <blocks>
      <twitter>
        <class>NAMESPACE_Twitter_Block</class>
      </twitter>
    </blocks>
  </global>
</config>

## 2-2-timeline.php
<?php
class NAMESPACE_Twitter_Block_Timeline extends Mage_Core_Block_Template
{
     public function getTimeline($username, $limit)
     {
          $tweets = array();
          // code to get tweets here
          return $tweets;
     }
}

## 2-3-local.xml
<!-- let's add a block to our layout that defines
     where to inject our twitter widget -->
<catalog_product_view>
     <reference name='product.info'>
          <block type='twitter/timeline' name='product.info.twitter.timeline' as='product.view.twitter.timeline' template='catalog/product/view/twitter/timeline.phtml' />
     </reference>
</catalog_product_view>

## 2-4-timeline.phtml
<div id='twitter-timeline'>
  <?php foreach ($this->getTimeline('demacmedia', 2) as $tweet): ?>
    <div class='tweet'><?php echo $tweet['text'] ?></div>
  <?php end ?>
</div>

## 2-5-embed.phtml
<?php echo $this->getChildHtml('product.info.twitter.timeline') ?>
	<!-- Your mixed HTML+PHP page script (pseudo-code) -->
	<?php mysql_connect(/* database details */) ?>
	<?php $result = mysql_query(/* get current page from db */) ?>
	<?php $page = mysql_fetch_assoc($result) ?>
	<html>
	<head>
	<title><?php echo htmlentities($page['title']) ?></title>
	</head>
	<body>
	<h1><?php echo htmlentities($page['title']) ?></h1>
	<ul>
	<?php $result = mysql_query(/* SQL Query */) ?>
	<?php while($row = mysql_fetch_assoc($result)): ?>
	<li><?php echo htmlentities($row['title']) ?></li>
	<?php end ?>
	</ul>
	</body>
	</html>
	<?php // Your Post Model Class (pseudo-code)
	class PostModel extends ModelAbstract
	{
	// model specific code here
	}
	<?php // Your Index Controller Class (pseudo-code)
	class IndexController extends ControllerAbstract
	{
	public function showAction($request)
	{
	// call on Post model to get by ID
	$post = new PostModel($request->id);

	// expost post to view script
	$this->view->post = $post;
	}
	}
	<!-- Your controller action template (pseudo-code) -->
	<html>
	<head>
	<title><?php echo htmlentities($this->post->title) ?></title>
	</head>
	<body>
	<h1><?php echo htmlentities($this->post->title) ?></h1>
	<p><?php echo $this->post->content ?></p>
	</body>
	</html>
	<?xml version="1.0"?>
	<config>
	<modules>
	<NAMESPACE_Twitter>
	<active>true</active>
	<codePool>local</codePool>
	</NAMESPACE_Twitter>
	</modules>
	</config>
	<?php
	class NAMESPACE_Twitter_Block_Timeline extends Mage_Core_Block_Template
	{
	public function getTimeline($username, $limit)
	{
	$tweets = array();
	// code to get tweets here
	return $tweets;
	}
	}
	<!-- let's add a block to our layout that defines
	where to inject our twitter widget -->
	<catalog_product_view>
	<reference name='product.info'>
	<block type='twitter/timeline' name='product.info.twitter.timeline' as='product.view.twitter.timeline' template='catalog/product/view/twitter/timeline.phtml' />
	</reference>
	</catalog_product_view>
	<div id='twitter-timeline'>
	<?php foreach ($this->getTimeline('demacmedia', 2) as $tweet): ?>
	<div class='tweet'><?php echo $tweet['text'] ?></div>
	<?php end ?>
	</div>