}
}
if ($orderID == '0') {
echo "<h5><img src='images/claimedProj.png'</h5>\n <h2>No claimed projects!</h2>";
} else {
$orderSpecification = "SELECT orders, noOfPosts, topic, industry_of_experience, goal, style_of_writing, sample_blog, point_of_view, blog_structure, target_audience, key_points, things_to_avoid, keywords, special_instructions FROM businesshomepage WHERE txnid='" . $orderID . "'";
$con1 = mysqli_fetch_object(mysqli_query($conn, $orderSpecification));
$orderName = $con1->orders;
$noOfPosts = $con1->noOfPosts;
$topicName = $con1->topic;
$industry_of_experience = $con1->industry_of_experience;
$goal = $con1->goal;
$writingStyle = $con1->style_of_writing;
$sampleBlog = $con1->sample_blog;
$pointsOfView = $con1->point_of_view;
$blogStructure = $con1->blog_structure;
$targetAudience = $con1->target_audience;
$keyPoints = $con1->key_points;
$thingsToAvoid = $con1->things_to_avoid;
$keywords = $con1->keywords;
$specialInstruct = $con1->special_instructions;
echo "\n <h1><span><u>Topic</u></span><br>" . $topicName . "</h1> <br/><br/>\n <table>\n <tr>\n <td>Catagory:</td>\n <td>" . $orderName . "</td>\n </tr>\n <tr>\n <td>No. of Posts:</td>\n <td>" . $noOfPosts . "</td>\n </tr>\n <tr>\n <td>Industry of experience:</td>\n <td>" . $industry_of_experience . "</td>\n </tr>\n <tr>\n <td>Goal:</td>\n <td>" . emptycheck($goal) . "</td>\n </tr>\n <tr>\n <td>Style of writing:</td>\n <td>" . emptycheck($writingStyle) . "</td>\n </tr>\n <tr>\n <td>Content Sample:</td>\n <td>" . emptycheck($sampleBlog) . "</td>\n </tr>\n <tr>\n <td>Point Of View:</td>\n <td>" . emptycheck($pointsOfView) . "</td>\n </tr>\n <tr>\n <td>Content Structure:</td>\n <td>" . emptycheck($blogStructure) . "</td>\n </tr>\n <tr>\n <td>Type of targeted audience:</td>\n <td>" . emptycheck($targetAudience) . "</td>\n </tr>\n <tr>\n <td>Keypoints:</td>\n <td>" . emptycheck($keyPoints) . "</td>\n </tr>\n <tr>\n <td>Things to avoid:</td>\n <td>" . emptycheck($thingsToAvoid) . "</td>\n </tr>\n <tr>\n <td>Keywords:</td>\n <td>" . emptycheck($keywords) . "</td>\n </tr>\n <tr>\n <td>Special Instructions:</td>\n <td>" . emptycheck($specialInstruct) . "</td>\n </tr>\n </table>";
echo '<hr>
<h2>Upload your file here:</h2>
<form action="php/uploadCode/upload.php" method="POST" enctype="multipart/form-data">
<input type="file" name="doc" value="Choose File" />
<input type="submit" name="upload" value="Upload" class="samp_but"/>
<input type="hidden" name="orderID" value="' . $orderID . '"/>
<input type="hidden" name="username" value="' . $Username . '"/>
</form>';
}
date_default_timezone_set('Asia/Calcutta');
$date = date("Y-m-d H:i:s");
//$sql = "UPDATE businesshomepage SET confirmed='1' WHERE txnid = '".$txnid."' ";
$sql = "INSERT INTO businesshomepage (email, txnid, orders, quality, noOfPosts, deliveryTime, topic, industry_of_experience, goal, style_of_writing, sample_blog, point_of_view, blog_structure, target_audience, key_points, things_to_avoid, keywords, special_instructions, amountPaid, dateOrder) VALUES ('{$email}', '{$txnid}', '{$dataEntry3}', '{$quality}', '{$dataEntry1}', '{$dataEntry2}', '{$topic}', '{$industry}', '{$goal}', '{$styleOfWriting}', '{$sampleBlog}', '{$pointOfView}', '{$blogStructure}', '{$targetAudience}', '{$keyPoints}', '{$avoid}', '{$keywords}', '{$specialInstructions}', '{$quality}', '{$date}')";
function emptycheck($myvalue)
{
if ($myvalue != '' || $myvalue != 0) {
return $myvalue;
} else {
return '---';
}
}
if ($conn->query($sql) === TRUE) {
$to = $email;
$subject = "Order review";
$message = "Dear " . $firstname . ",<br><br>\nYou have placed an order of " . $dataEntry3 . " on Whitepanda. Your order id is " . $txnid . ". Please find the details of the content you have ordered below.<br><br><br>\n\n\n\n<div style='max-width:600px;margin-left:auto;margin-right:auto;background-color:#1295c9;color:white;padding:5px'>\n <div style='text-align:center;padding:5px 0; font-size:26px;'><b>Your Content Details</b></div>\n <div style='background-color:#f4f4f4;padding:10px;margin-top:6px'>\n \n <table style='width:100%; color:black;'>\n <thead>\n <tr style='font-size:19px;'>\n <td>Topic: " . $topic . "</td>\n <td></td>\n \n </tr> \n \n </thead> \n \n <tbody style='background:#D9EDF7; border:solid;'>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Catagory</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . $dataEntry3 . "</td>\n </tr>\n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>No. of Posts</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . $dataEntry1 . "</td>\n </tr>\n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Industry of experience</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . $industry . "</td>\n </tr>\n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Amount</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Rs. " . $quality . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Goal</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($goal) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Style of writing</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($styleOfWriting) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Content Sample</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($sampleBlog) . "</td>\n </tr>\n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Point of view</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($pointOfView) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Content Structure</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($blogStructure) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Type of Target Audience</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($targetAudience) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Keypoints</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($keyPoints) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Things to avoid</td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($avoid) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Keywords </td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($keywords) . "</td>\n </tr>\n \n <tr>\n <td style='background:#D9EDF7; border:none; padding:20px;'>Special Instructions </td>\n <td style='background:#D9EDF7; border:none; padding:20px;'>" . emptycheck($specialInstructions) . "</td>\n </tr>\n \n </tbody>\n </table>\n \n </div>\n </div>\n\n\n\n\n\n\n\n\n\n<br><br>\nIf you feel some changes need to be made to your order, feel free to mail us on support@whitepanda.in<br><br><br><br>\nRegards,<br>\nTeam White Panda";
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: White Panda <*****@*****.**>' . "\r\n";
mail($to, $subject, $message, $headers);
$to = "ashimrajkonwar@gmail.com, aditya.ganesh@iitgn.ac.in, roshan.agarwal@iitgn.ac.in, bhaskar.jyoti@iitgn.ac.in";
$subject = "New client";
$message = "Dear Admins,<br>\n<br> A new client named " . $firstname . " with email id " . $email . " has placed an order of an amount of Rs." . $quality . ".<br><br><br>\n\n\n\n\n\n\nCheer up<br>\nTeam White Panda";
// Always set content-type when sending HTML email
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
// More headers
$headers .= 'From: White Panda <*****@*****.**>' . "\r\n";
<td><?php
echo emptycheck($thingsToAvoid);
?>
</td>
</tr>
<tr>
<td>Keywords:</td>
<td><?php
echo emptycheck($keywords);
?>
</td>
</tr>
<tr>
<td>Special Instructions:</td>
<td><?php
echo emptycheck($specialInstruct);
?>
</td>
</tr>
</table>
<form method="post" action="php/databaseCall/claimProject.php" >
<input type="hidden" name="orderID" value="<?php
echo $orderID;
?>
"/>
<input type="hidden" name="username" value="<?php
echo $Username;
