"Blank Code / Incorrect code",
2 => "Output error",
3 => "Execution error",
4 => "Missing example(s)",
6 => "Blank output",
7 => "Any other"
);
if (isset($_POST['type']) && isset($_POST['comment']))
{
$query = "insert into scilab_cloud_comment (type, comment, email,category,books,chapter,example) values(" . $_POST['type'] . ", '" . $_POST['comment'] . "', '" . $_POST['email'] . "', '" . $_POST['category'] . "', '" . $_POST['books'] . "', '" . $_POST['chapter'] . "', '" . $_POST['example'] . "')";
if (mysql_query($query))
{
echo "Thank you for your valuable feedback.
";
$query_details = "SELECT tcp.book as book, tcp.author as author, tcp.publisher as publisher,
tcp.year as year,tcp.category as category, tce.chapter_id, tcc.number AS chapter_no,
tcc.name AS chapter_name, tce.number AS example_no, tce.caption AS example_caption
FROM textbook_companion_preference tcp
LEFT JOIN textbook_companion_chapter tcc ON tcp.id = tcc.preference_id
LEFT JOIN textbook_companion_example tce ON tce.chapter_id = tcc.id
WHERE tce.id = '" . $_POST['example'] . "'";
$exmpale_id = $_POST['example'];
$result = mysql_query($query_details);
$row = mysql_fetch_object($result);
$category = _tbc_list_of_category($row->category);
$to = "email@email.in";
$subject = "New Cloud Comment";
$message = "
A new comment has been posted.
Type: {$types[$_POST['type']]}
Category: {$category}
Book: {$row->book} (Author: {$row->author}, Publisher: {$row->publisher})
Chapter: {$row->chapter_name} ({$row->chapter_no})
Example: {$row->example_caption} ({$row->example_no})
Comment: {$_POST['comment']}
Link: http://scilab.in/cloud_comments
";
$from = "email@email.in";
$headers = "From: " . $from . "\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
mail($to, $subject, $message, $headers);
}
else
{
echo "Sorry for the inconvience, please try again
";
}
}
else
{
?>
category_name;
return $category;
}
?>