<?php
mysql_connect('', '', '') or die("MySQL Error!<br>(".mysql_error().")<br>Could not proceed");
mysql_select_db(''); 
 
if(isset($_POST['submit'])){
  if(empty($_POST['name']) || empty($_POST['comment'])) {
    die("Forget to fill something in?");
  }
  $_POST['comment'] = addslashes($_POST['comment']);
  mysql_query("INSERT INTO `testimonials`
  (`name`,`text`,`norp`,`date`) VALUES ('".$_POST['name']."', '".$_POST['comment']."', '".$_POST['norp']."', '".time()."')")or die("MySQL Error!<br>(".mysql_error().")<br>Could not proceed");
  header("Location: ".$_SERVER['PHP_SELF']);
}
 
$query = mysql_query("SELECT * FROM `testimonials` ORDER BY `id`");
$i = 0;
echo "<h3>Atsiliepimai</h3><div style='width: 500px'>";
while($row = mysql_fetch_assoc($query)){
  $i = ($i == 2) ? 0 : 1;
  $bg = ($i == 1) ? "background-color: lightgrey;" : "background-color: #FFF;";
  echo "
  <p style='".$bg." margin: 0; padding: 5px 0 0 0; height: 100px; font-family: arial; border-bottom: 1px solid black'>
  &nbsp;&nbsp;&nbsp;&nbsp;<b>".$row['name']." </b><br /><br />
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;".$row['text']."
  </p>";
}
?>