<div class="span6">
    <form action="" method="POST">
        <div class="block-fluid without-head">
            <div class="toolbar clearfix">
                <div class="right">
                    <div class="btn-group">
                        <button type="submit" class="btn btn-small btn-warning tip" data-original-title="Submit Aritcle">
                            <span class="icon-ok icon-white"></span>
                        </button>
                        <button type="button" class="btn btn-small btn-danger tip" data-original-title="Delete Article">
                            <span class="icon-remove icon-white"></span>
                        </button>
                    </div>
                </div>
                <div class="left">
                    <div style="font-size: 11pt; font-family: -webkit-body; font-weight: bolder;">Article Exchange Request</div>
                </div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Title</div>
                <div class="span9"><input type="text" name="title" value="" placeholder="main subject title"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">First Sentence</div>
                <div class="span9"><input type="text" name="s1" value="" placeholder="Sentence with max of 200 characters"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Second Sentence</div>
                <div class="span9"><input type="text" name="s2" value="" placeholder="Optional sentence with max of 200 characters"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Third Sentence</div>
                <div class="span9"><input type="text" name="s3" value="" placeholder="Optional Sentence with max of 200 characters"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Website Url</div>
                <div class="span9"><input type="text" name="link" value="" placeholder="Url to be included in articles"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Website Url Title</div>
                <div class="span9"><input type="text" name="link_text" value="" placeholder="Url text to be included in articles limit 150 characters"></div>
            </div>

            <div class="row-form clearfix">
                <div class="span3">Credit Offer</div>
                <div class="span9"><input type="text" name="cost_value" value="" placeholder="Example: 100"></div>
            </div>
        </div>
    </form>
</div>

<?

if (isset($_POST[cost_value])) {
    $stmt = $db->prepare("SELECT credits from member_credits WHERE username = :username");
    $stmt->bindParam(':username', $username);
    $stmt->execute();
    $row = $stmt->fetch();
    $count = $row[credits];
    if ($count > $_POST[cost_value]) {
        $stmt = $db->prepare('INSERT INTO article_requests (title, s1, s2, s3, link, link_text, offer, username) VALUES (:title, :s1, :s2, :s3, :link, :link_text, :offer, :username)');
        $stmt->bindValue(':title', $_POST[title]);
        $stmt->bindValue(':s1', $_POST[s1]);
        $stmt->bindValue(':s2', $_POST[s2]);
        $stmt->bindValue(':s3', $_POST[s3]);
        $stmt->bindValue(':link', $_POST[link]);
        $stmt->bindValue(':link_text', $_POST[link_text]);
        $stmt->bindValue(':offer', $_POST[cost_value]);
        $stmt->bindValue(':username', $username);
        $stmt->execute();
    }
}
?>