Ravi Success

/home/agrawaaldevika/public_html/socialjersey/success.php

<?php
include('config.php');
session_start();
$q2 = $_SESSION['q2'];

$q4 = $_SESSION['q4'];
$q5 = $_SESSION['q5'];
$q6 = $_SESSION['q6'];
$q7 = $_SESSION['q7'];
$q8 = $_SESSION['q8'];
$q10 = $_SESSION['q10'];
$q9 = $_SESSION['q9'];


$email = $_SESSION['email'] ;
$user = $_SESSION['user'];
$formid = $_SESSION['formid'] ;
$subject= $_SESSION['subject'] ;

$item_no            = $_REQUEST['item_number'];
$item_transaction   = $_REQUEST['tx']; // Paypal transaction ID
$item_price         = $_REQUEST['amt']; // Paypal received amount
$item_currency      = $_REQUEST['cc']; // Paypal received currency type
if( $_REQUEST['PHPSESSID']){
$payment = "6.95 USD";
$pdate = date('Y-m-d');
$query = "INSERT INTO `payment_info`(`name`, `email`, `type`, `title`, `url`, `keywords`, `category`, `payment`, `description`, `payment_status`,`payment_date`,`form_type`)
 VALUES ('$q9','$email','$q2','$q4','$q5','$q7','$q8','$payment','$q6','success','$pdate','Directory')";
$sql = mysqli_query($con,$query);

}

?>

<body onload="submitForm1();" style="display:none;";>
<form action="http://www.socialjersey.com/p/thank-you.html?m=1" id="sdateForm"  name="sdateForm" style="background-color: white; border: 0px solid #000000; margin: 0; padding: 0; width: 100%;">

<table cellpadding="0" cellspacing="0" style="width: 100%px;" summary="This table contains contact form fields.">
 <tbody>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q2" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Choose <span style="color: red;">*</span></label> <br />
<div style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px;">
<input id="q2" name="q2" required="required" type="radio" value="Regular links with reciprocal free"
 <?php if($q2 == "Regular links with reciprocal free"){ echo "checked";} ?>

 />Regular links with reciprocal free<br />
<input id="q2" name="q2" required="required" type="radio" value="Regular links free"
<?php if($q2 == "Regular links free"){ echo "checked";} ?>
 />Regular links free<br />
<input id="q2" name="q2" required="required" type="radio" value="Featured (Fee for our editors Urgent Manual review) $6.95 - 1 Year"
<?php if($q2 == "Featured (Fee for our editors Urgent Manual review) $6.95 - 1 Year"){ echo "checked";} ?>
 />Featured (Fee for our editors Urgent Manual review) $6.95 - 1 Year</div>
<div style="clear: both;">
</div>
</td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q4" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Title: <span style="color: red;">*</span></label> <input id="q4" maxlength="60" name="q4" required="required" size="20" type="text" value="<?php echo $q4; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q5" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Url: <span style="color: red;">*</span></label> <input id="q5" maxlength="60" name="q5" required="required" size="20" type="text" value="<?php echo $q5; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q6" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Description:</label> <textarea cols="30" id="q6" name="q6" rows="4"><?php echo $q6; ?></textarea>
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q7" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Keywords:<span style="color: red;">*</span> </label> <input id="q7" maxlength="100" name="q7" required="required" size="20" type="text" value="<?php echo $q7; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">a
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q8" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Category: <span style="color: red;">*</span></label> <select id="q8" name="q8" required="required">
    <option <?php if($q8 == "Arts and Humanities"){echo "selected";} ?> value="Arts and Humanities">Arts and Humanities</option>
    <option <?php if($q8 == "Blogs"){echo "selected";} ?> value="Blogs">Blogs</option>
    <option <?php if($q8 == "Business and Economy"){echo "selected";} ?> value="Business and Economy">Business and Economy</option>
    <option <?php if($q8 == "Computers and Internet"){echo "selected";} ?> value="Computers and Internet">Computers and Internet</option>
    <option <?php if($q8 == "Education"){echo "selected";} ?> value="Education">Education</option>
    <option <?php if($q8 == "Entertainment"){echo "selected";} ?> value="Entertainment">Entertainment</option>
    <option <?php if($q8 == "Health"){echo "selected";} ?> value="Health">Health</option>
    <option <?php if($q8 == "News and Media"){echo "selected";} ?> value="News and Media">News and Media</option>
    <option <?php if($q8 == "Recreation and Sports"){echo "selected";} ?> value="Recreation and Sports">Recreation and Sports</option>
    <option <?php if($q8 == "Reference"){echo "selected";} ?> value="Reference">Reference</option>
    <option <?php if($q8 == "Science and Technology"){echo "selected";} ?> value="Science and Technology">Science and Technology</option>
    <option <?php if($q8 == "Shopping"){echo "selected";} ?> value="Shopping">Shopping</option>
    <option <?php if($q8 == "Society"){echo "selected";} ?> value="Society">Society</option>
  </select>
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q10" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Reciprocal Link: </label> <input id="q10" maxlength="" name="q10" size="20" type="text" value="<?php echo $q10; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q9" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Your Name: <span style="color: red;">*</span></label> <input id="q9" maxlength="" name="q9" required="required" size="20" type="text" value="<?php echo $q9; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="email" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">E-mail Address: <span style="color: red;">*</span></label>
  <input id="email" maxlength="100" name="email" required="required" value="<?php echo $email; ?>" size="20" type="email" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; clear: left; margin: 0; padding: 5px;"><hr style="background-color: #d8d8d8; color: #d8d8d8; height: 1px;" />
</td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; clear: left; margin: 0; padding: 5px;">
<input id="user" name="user" type="hidden" value="agrawaaldevika" />
   <input id="formid" name="formid" type="hidden" value="437282" />By Clicking on Submit you are ensuring to agree Terms and Conditions<br />
   <input id="subject" name="subject" type="hidden" value="Directory Submission Request" />
   <input name="smybtnSubmit" type="submit" value="Submit" />
 </td>
 </tr>
</tbody></table>
</form>
<script type="text/javascript">
 function submitForm1() {
    document.getElementById('sdateForm').submit(); // SUBMIT FORM
    }
</script>

</body>


/home/agrawaaldevika/public_html/socialjersey/form_process.php


<?php
session_start();
require_once('dbconnect.php');



$_SESSION['q2'] = $_POST['q2'];
$_SESSION['q4'] = $_POST['q4'];
$_SESSION['q5'] = $_POST['q5'];
$_SESSION['q6'] = $_POST['q6'];
$_SESSION['q7'] = $_POST['q7'];
$_SESSION['q8'] = $_POST['q8'];
$_SESSION['q10'] = $_POST['q10'];
$_SESSION['q9'] = $_POST['q9'];
$_SESSION['email'] = $_POST['email'];
$_SESSION['user'] = $_POST['user'];
$_SESSION['formid'] = $_POST['formid'];
$_SESSION['subject'] = $_POST['subject'];
$_SESSION['SUBMIT'] = "TAB1";
extract($_POST);

if($_POST['q2']=="Featured (Fee for our editors Urgent Manual review) $6.95 - 1 Year"){
$paypalURL = 'https://www.sandbox.paypal.com/cgi-bin/webscr'; //Test PayPal API URL
$paypalID = 'client@testbuyer.com'; //Business Email
//echo "<pre>";
//print_r($_POST); die;
 


$query = "SELECT BUTTON_ID,URL FROM PAYPAL_INFO WHERE IS_ACTIVE=1 AND TAB_ID=1";
$result = mysqli_query($conn,$query) or trigger_error("SQL", E_USER_ERROR);

while(($row = mysqli_fetch_array($result)) ) {
   $buttonId = $row["BUTTON_ID"];
   $url = $row["URL"];
}
?>

<html>
<head>
<body  >

<form name="postForm" action="<?php echo  $url; ?>" method="post" >

<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="<?php echo $buttonId; ?>">
</form>

   
<script>
   
   
   
      var postForm = document.forms.postForm;
      postForm.submit();
 
</script>
</body>
</head>
</html>

<?php
}
else{

     $query = "SELECT email FROM payment_info WHERE  type like \"%Regular Links%\" AND email='$email'";
    $result = mysqli_query($conn,$query) or trigger_error("SQL", E_USER_ERROR);
    $numRows =  $rowcount=mysqli_num_rows($result);

/*$payment = "6.95 USD";
$pdate = date('Y-m-d');
$query = "INSERT INTO `payment_info`(`name`, `email`, `type`, `title`, `url`, `keywords`, `category`, `payment`, `description`, `payment_status`,`payment_date`,`form_type`)
 VALUES ('$q9','$email','$q2','$q4','$q5','$q7','$q8','$payment','$q6','success','$pdate','Directory')";
$sql = mysqli_query($con,$query);*/

if($numRows!=0){
 
      echo "You have exhausted your free limit";
}else{
      $payment = "Free";
      $pdate = date('Y-m-d');
      $query = "INSERT INTO `payment_info`(`name`, `email`, `type`, `title`, `url`, `keywords`, `category`, `payment`, `description`, `payment_status`,`payment_date`,`form_type`)
      VALUES ('$q9','$email','$q2','$q4','$q5','$q7','$q8','$payment','$q6','success','$pdate','Directory')";
      echo $query;
      $sql = mysqli_query($conn,$query);
      header("Location:http://www.socialjersey.com/p/thank-you.html?m=1");
      die();
}

}
//print_r($_SESSION);
?>


Ravi Success4

/home/agrawaaldevika/public_html/socialjersey/success4.php



<?php
include('config.php');
session_start();
$q1 = $_SESSION['q1'];
$q2 = $_SESSION['q2'];
$q3 = $_SESSION['q3'];
$q4 = $_SESSION['q4'];
$q5 = $_SESSION['q5'];
$q6 = $_SESSION['q6'];
$q7 = $_SESSION['q7'];
$q8 = $_SESSION['q8'];



$email = $_SESSION['email'] ;
$user = $_SESSION['user'];
$formid = $_SESSION['formid'] ;
$subject= $_SESSION['subject'] ;

$item_no            = $_REQUEST['item_number'];
$item_transaction   = $_REQUEST['tx']; // Paypal transaction ID
$item_price         = $_REQUEST['amt']; // Paypal received amount
$item_currency      = $_REQUEST['cc']; // Paypal received currency type
if( $_REQUEST['PHPSESSID']){
$payment = "1 USD";
$pdate = date('Y-m-d');
$query = "INSERT INTO `payment_info`(`company_name`, `email`, `category`, `payment`, `payment_status`, `payment_date`, `form_type`, `postal_code`, `country`, `website`, `complain_about`, `complain`, `complain_city`) VALUES ('$q1','$email','$q4','$payment','success','$pdate','complaint','$q6','$q5','$q8','$q2','$q3','$q7')";
$sql = mysqli_query($con,$query);

}

?>

<body onload="submitForm1();" style="display:none;";>
<form action="http://www.socialjersey.com/p/thank-you.html?m=1" id="sdateForm4"  name="sdateForm4" style="background-color: white; border: 0px solid #000000; margin: 0; padding: 0; width: 100%;">
<table cellpadding="0" cellspacing="0" style="width: 100%px;" summary="This table contains contact form fields.">
 <tbody>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q1" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Company name <span style="color: red;">*</span></label> <input id="q1" maxlength="" name="q1" required="required" size="40" type="text" value="<?php echo $q1; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q2" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Product/Service I am complaining about <span style="color: red;">*</span></label>  <textarea cols="30" id="q2" maxlength="" name="q2" required="required" rows="3"><?php echo $q2; ?></textarea>
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q3" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 100%;">Please provide as much as information as possible <span style="color: red;">*</span></label><br />
<textarea cols="60" id="q3" name="q3" required="required" rows="10"><?php echo $q3; ?></textarea></td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q4" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Category <span style="color: red;">*</span></label> <select id="q4" name="q4" required="required">
    <option <?php if($q4=="Computers and Internet"){echo "selected";} ?> value="Computers and Internet">Computers and Internet</option>
    <option <?php if($q4=="Shopping"){echo "selected";} ?> value="Shopping">Shopping</option>
    <option <?php if($q4=="Science and Technology"){echo "selected";} ?> value="Science and Technology">Science and Technology</option>
    <option <?php if($q4=="Education"){echo "selected";} ?> value="Education">Education</option>
    <option <?php if($q4=="Blogs"){echo "selected";} ?> value="Blogs">Blogs</option>
  </select>
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q5" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Country </label> <select id="q5" name="q5">
<option <?php if($q5=="Afghanistan"){echo "selected";} ?> value="Afghanistan">Afghanistan</option>
<option <?php if($q5=="Albania"){echo "selected";} ?> value="Albania">Albania</option>
<option <?php if($q5=="Algeria"){echo "selected";} ?> value="Algeria">Algeria</option>
<option <?php if($q5=="American Samoa"){echo "selected";} ?> value="American Samoa">American Samoa</option>
<option <?php if($q5=="Andorra"){echo "selected";} ?> value="Andorra">Andorra</option>
<option <?php if($q5=="Angola"){echo "selected";} ?> value="Angola">Angola</option>
<option <?php if($q5=="Anguilla"){echo "selected";} ?> value="Anguilla">Anguilla</option>
<option <?php if($q5=="Antarctica"){echo "selected";} ?> value="Antarctica">Antarctica</option>
<option <?php if($q5=="Antigua &amp; Barbuda"){echo "selected";} ?> value="Antigua &amp; Barbuda">Antigua &amp; Barbuda</option>
<option <?php if($q5=="Argentina"){echo "selected";} ?> value="Argentina">Argentina</option>
<option <?php if($q5=="Armenia"){echo "selected";} ?> value="Armenia">Armenia</option>
<option <?php if($q5=="Aruba"){echo "selected";} ?> value="Aruba">Aruba</option>
<option <?php if($q5=="Australia"){echo "selected";} ?> value="Australia">Australia</option>
<option <?php if($q5=="Austria"){echo "selected";} ?> value="Austria">Austria</option>
<option <?php if($q5=="Azerbaijan"){echo "selected";} ?> value="Azerbaijan">Azerbaijan</option>
<option <?php if($q5=="Bahama"){echo "selected";} ?> value="Bahama">Bahama</option>
<option <?php if($q5=="Bahrain"){echo "selected";} ?> value="Bahrain">Bahrain</option>
<option <?php if($q5=="Bangladesh"){echo "selected";} ?> value="Bangladesh">Bangladesh</option>
<option <?php if($q5=="Barbados"){echo "selected";} ?> value="Barbados">Barbados</option>
<option <?php if($q5=="Belarus"){echo "selected";} ?> value="Belarus">Belarus</option>
<option <?php if($q5=="Belgium"){echo "selected";} ?> value="Belgium">Belgium</option>
<option <?php if($q5=="Belize"){echo "selected";} ?> value="Belize">Belize</option>
<option <?php if($q5=="Benin"){echo "selected";} ?> value="Benin">Benin</option>
<option <?php if($q5=="Bermuda"){echo "selected";} ?> value="Bermuda">Bermuda</option>
<option <?php if($q5=="Bhutan"){echo "selected";} ?> value="Bhutan">Bhutan</option>
<option <?php if($q5=="Bolivia"){echo "selected";} ?> value="Bolivia">Bolivia</option>
<option <?php if($q5=="Bosnia and Herzegovina"){echo "selected";} ?> value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
<option <?php if($q5=="Botswana"){echo "selected";} ?> value="Botswana">Botswana</option>
<option <?php if($q5=="Bouvet Island"){echo "selected";} ?> value="Bouvet Island">Bouvet Island</option>
<option <?php if($q5=="Brazil"){echo "selected";} ?> value="Brazil">Brazil</option>
<option <?php if($q5=="British Indian Ocean Territory"){echo "selected";} ?> value="British Indian Ocean Territory">British Indian Ocean Territory</option>
<option <?php if($q5=="British Virgin Islands"){echo "selected";} ?> value="British Virgin Islands">British Virgin Islands</option>
<option <?php if($q5=="Brunei Darussalam"){echo "selected";} ?> value="Brunei Darussalam">Brunei Darussalam</option>
<option <?php if($q5=="Bulgaria"){echo "selected";} ?> value="Bulgaria">Bulgaria</option>
<option <?php if($q5=="Burkina Faso"){echo "selected";} ?> value="Burkina Faso">Burkina Faso</option>
<option <?php if($q5=="Burundi"){echo "selected";} ?> value="Burundi">Burundi</option>
<option <?php if($q5=="Cambodia"){echo "selected";} ?> value="Cambodia">Cambodia</option>
<option <?php if($q5=="Cameroon"){echo "selected";} ?> value="Cameroon">Cameroon</option>
<option <?php if($q5=="Canada"){echo "selected";} ?> value="Canada">Canada</option>
<option <?php if($q5=="Cape Verde"){echo "selected";} ?> value="Cape Verde">Cape Verde</option>
<option <?php if($q5=="Cayman Islands"){echo "selected";} ?> value="Cayman Islands">Cayman Islands</option>
<option <?php if($q5=="Central African Republic"){echo "selected";} ?> value="Central African Republic">Central African Republic</option>
<option <?php if($q5=="Chad"){echo "selected";} ?> value="Chad">Chad</option>
<option <?php if($q5=="Chile"){echo "selected";} ?> value="Chile">Chile</option>
<option <?php if($q5=="China"){echo "selected";} ?> value="China">China</option>
<option <?php if($q5=="Christmas Island"){echo "selected";} ?> value="Christmas Island">Christmas Island</option>
<option <?php if($q5=="Cocos (Keeling) Islands"){echo "selected";} ?> value="Cocos (Keeling) Islands">Cocos (Keeling) Islands</option>
<option <?php if($q5=="Colombia"){echo "selected";} ?> value="Colombia">Colombia</option>
<option <?php if($q5=="Comoros"){echo "selected";} ?> value="Comoros">Comoros</option>
<option <?php if($q5=="Congo"){echo "selected";} ?> value="Congo">Congo</option>
<option <?php if($q5=="Cook Iislands"){echo "selected";} ?> value="Cook Iislands">Cook Iislands</option>
<option <?php if($q5=="Costa Rica"){echo "selected";} ?> value="Costa Rica">Costa Rica</option>
<option <?php if($q5=="Cote D\'ivoire (Ivory Coast)"){echo "selected";} ?> value="Cote D\'ivoire (Ivory Coast)">Cote D'ivoire (Ivory Coast)</option>
<option <?php if($q5=="Croatia"){echo "selected";} ?> value="Croatia">Croatia</option>
<option <?php if($q5=="Cuba"){echo "selected";} ?> value="Cuba">Cuba</option>
<option <?php if($q5=="Cyprus"){echo "selected";} ?> value="Cyprus">Cyprus</option>
<option <?php if($q5=="Czech Republic"){echo "selected";} ?> value="Czech Republic">Czech Republic</option>
<option <?php if($q5=="Denmark"){echo "selected";} ?> value="Denmark">Denmark</option>
<option <?php if($q5=="Djibouti"){echo "selected";} ?> value="Djibouti">Djibouti</option>
<option <?php if($q5=="Dominica"){echo "selected";} ?> value="Dominica">Dominica</option>
<option <?php if($q5=="Dominican Republic"){echo "selected";} ?> value="Dominican Republic">Dominican Republic</option>
<option <?php if($q5=="East Timor"){echo "selected";} ?> value="East Timor">East Timor</option>
<option <?php if($q5=="Ecuador"){echo "selected";} ?> value="Ecuador">Ecuador</option>
<option <?php if($q5=="Egypt"){echo "selected";} ?> value="Egypt">Egypt</option>
<option <?php if($q5=="El Salvador"){echo "selected";} ?> value="El Salvador">El Salvador</option>
<option <?php if($q5=="Equatorial Guinea"){echo "selected";} ?> value="Equatorial Guinea">Equatorial Guinea</option>
<option <?php if($q5=="Eritrea"){echo "selected";} ?> value="Eritrea">Eritrea</option>
<option <?php if($q5=="Estonia"){echo "selected";} ?> value="Estonia">Estonia</option>
<option <?php if($q5=="Ethiopia"){echo "selected";} ?> value="Ethiopia">Ethiopia</option>
<option <?php if($q5=="Falkland Islands (Malvinas)"){echo "selected";} ?> value="Falkland Islands (Malvinas)">Falkland Islands (Malvinas)</option>
<option <?php if($q5=="Faroe Islands"){echo "selected";} ?> value="Faroe Islands">Faroe Islands</option>
<option <?php if($q5=="Fiji"){echo "selected";} ?> value="Fiji">Fiji</option>
<option <?php if($q5=="Finland"){echo "selected";} ?> value="Finland">Finland</option>
<option <?php if($q5=="France"){echo "selected";} ?> value="France">France</option>
<option <?php if($q5=="French Guiana"){echo "selected";} ?> value="French Guiana">French Guiana</option>
<option <?php if($q5=="French Polynesia"){echo "selected";} ?> value="French Polynesia">French Polynesia</option>
<option <?php if($q5=="French Southern Territories"){echo "selected";} ?> value="French Southern Territories">French Southern Territories</option>
<option <?php if($q5=="Gabon"){echo "selected";} ?> value="Gabon">Gabon</option>
<option <?php if($q5=="Gambia"){echo "selected";} ?> value="Gambia">Gambia</option>
<option <?php if($q5=="Georgia"){echo "selected";} ?> value="Georgia">Georgia</option>
<option <?php if($q5=="Germany"){echo "selected";} ?> value="Germany">Germany</option>
<option <?php if($q5=="Ghana"){echo "selected";} ?> value="Ghana">Ghana</option>
<option <?php if($q5=="Gibraltar"){echo "selected";} ?> value="Gibraltar">Gibraltar</option>
<option <?php if($q5=="Greece"){echo "selected";} ?> value="Greece">Greece</option>
<option <?php if($q5=="Greenland"){echo "selected";} ?> value="Greenland">Greenland</option>
<option <?php if($q5=="Grenada"){echo "selected";} ?> value="Grenada">Grenada</option>
<option <?php if($q5=="Guadeloupe"){echo "selected";} ?> value="Guadeloupe">Guadeloupe</option>
<option <?php if($q5=="Guam"){echo "selected";} ?> value="Guam">Guam</option>
<option <?php if($q5=="Guatemala"){echo "selected";} ?> value="Guatemala">Guatemala</option>
<option <?php if($q5=="Guinea"){echo "selected";} ?> value="Guinea">Guinea</option>
<option <?php if($q5=="Guinea-Bissau"){echo "selected";} ?> value="Guinea-Bissau">Guinea-Bissau</option>
<option <?php if($q5=="Guyana"){echo "selected";} ?> value="Guyana">Guyana</option>
<option <?php if($q5=="Haiti"){echo "selected";} ?> value="Haiti">Haiti</option>
<option <?php if($q5=="Heard &amp; McDonald Islands"){echo "selected";} ?> value="Heard &amp; McDonald Islands">Heard &amp; McDonald Islands</option>
<option <?php if($q5=="Honduras"){echo "selected";} ?> value="Honduras">Honduras</option>
<option <?php if($q5=="Hong Kong"){echo "selected";} ?> value="Hong Kong">Hong Kong</option>
<option <?php if($q5=="Hungary"){echo "selected";} ?> value="Hungary">Hungary</option>
<option <?php if($q5=="Iceland"){echo "selected";} ?> value="Iceland">Iceland</option>
<option <?php if($q5=="India"){echo "selected";} ?> value="India">India</option>
<option <?php if($q5=="Indonesia"){echo "selected";} ?> value="Indonesia">Indonesia</option>
<option <?php if($q5=="Iraq"){echo "selected";} ?> value="Iraq">Iraq</option>
<option <?php if($q5=="Ireland"){echo "selected";} ?> value="Ireland">Ireland</option>
<option <?php if($q5=="Islamic Republic of Iran"){echo "selected";} ?> value="Islamic Republic of Iran">Islamic Republic of Iran</option>
<option <?php if($q5=="Israel"){echo "selected";} ?> value="Israel">Israel</option>
<option <?php if($q5=="Italy"){echo "selected";} ?> value="Italy">Italy</option>
<option <?php if($q5=="Jamaica"){echo "selected";} ?> value="Jamaica">Jamaica</option>
<option <?php if($q5=="Japan"){echo "selected";} ?> value="Japan">Japan</option>
<option <?php if($q5=="Jordan"){echo "selected";} ?> value="Jordan">Jordan</option>
<option <?php if($q5=="Kazakhstan"){echo "selected";} ?> value="Kazakhstan">Kazakhstan</option>
<option <?php if($q5=="Kenya"){echo "selected";} ?> value="Kenya">Kenya</option>
<option <?php if($q5=="Kiribati"){echo "selected";} ?> value="Kiribati">Kiribati</option>
<option <?php if($q5=="Korea, Democratic People's Republic of"){echo "selected";} ?> value="Korea, Democratic People's Republic of">Korea, Democratic People's Republic of</option>
<option <?php if($q5=="Korea, Republic of"){echo "selected";} ?> value="Korea, Republic of">Korea, Republic of</option>
<option <?php if($q5=="Kuwait"){echo "selected";} ?>  value="Kuwait">Kuwait</option>
<option <?php if($q5=="Kyrgyzstan"){echo "selected";} ?> value="Kyrgyzstan">Kyrgyzstan</option>
<option <?php if($q5=="Lao People's Democratic Republic"){echo "selected";} ?> value="Lao People's Democratic Republic">Lao People's Democratic Republic</option>
<option <?php if($q5=="Latvia"){echo "selected";} ?> value="Latvia">Latvia</option>
<option <?php if($q5=="Lebanon"){echo "selected";} ?> value="Lebanon">Lebanon</option>
<option <?php if($q5=="Lesotho"){echo "selected";} ?> value="Lesotho">Lesotho</option>
<option <?php if($q5=="Liberia"){echo "selected";} ?> value="Liberia">Liberia</option>
<option <?php if($q5=="Libyan Arab Jamahiriya"){echo "selected";} ?> value="Libyan Arab Jamahiriya">Libyan Arab Jamahiriya</option>
<option <?php if($q5=="Liechtenstein"){echo "selected";} ?> value="Liechtenstein">Liechtenstein</option>
<option <?php if($q5=="Lithuania"){echo "selected";} ?> value="Lithuania">Lithuania</option>
<option <?php if($q5=="Luxembourg"){echo "selected";} ?> value="Luxembourg">Luxembourg</option>
<option <?php if($q5=="Macau"){echo "selected";} ?> value="Macau">Macau</option>
<option <?php if($q5=="Madagascar"){echo "selected";} ?> value="Madagascar">Madagascar</option>
<option <?php if($q5=="Malawi"){echo "selected";} ?> value="Malawi">Malawi</option>
<option <?php if($q5=="Malaysia"){echo "selected";} ?> value="Malaysia">Malaysia</option>
<option <?php if($q5=="Maldives"){echo "selected";} ?> value="Maldives">Maldives</option>
<option <?php if($q5=="Mali"){echo "selected";} ?> value="Mali">Mali</option>
<option <?php if($q5=="Malta"){echo "selected";} ?> value="Malta">Malta</option>
<option <?php if($q5=="Marshall Island"){echo "selected";} ?> value="Marshall Islands">Marshall Islands</option>
<option <?php if($q5=="Martinique"){echo "selected";} ?> value="Martinique">Martinique</option>
<option <?php if($q5=="Mauritani"){echo "selected";} ?> value="Mauritania">Mauritania</option>
<option <?php if($q5=="Mauritius"){echo "selected";} ?> value="Mauritius">Mauritius</option>
<option <?php if($q5=="Mayotte"){echo "selected";} ?> value="Mayotte">Mayotte</option>
<option <?php if($q5=="Mexico"){echo "selected";} ?> value="Mexico">Mexico</option>
<option <?php if($q5=="Micronesia"){echo "selected";} ?> value="Micronesia">Micronesia</option>
<option <?php if($q5=="Moldova, Republic of"){echo "selected";} ?> value="Moldova, Republic of">Moldova, Republic of</option>
<option <?php if($q5=="Monaco"){echo "selected";} ?> value="Monaco">Monaco</option>
<option <?php if($q5=="Mongolia"){echo "selected";} ?> value="Mongolia">Mongolia</option>
<option <?php if($q5=="Monserrat"){echo "selected";} ?> value="Monserrat">Monserrat</option>
<option <?php if($q5=="Morocco"){echo "selected";} ?> value="Morocco">Morocco</option>
<option <?php if($q5=="Mozambique"){echo "selected";} ?> value="Mozambique">Mozambique</option>
<option <?php if($q5=="Myanmar"){echo "selected";} ?> value="Myanmar">Myanmar</option>
<option <?php if($q5=="Namibia"){echo "selected";} ?> value="Namibia">Namibia</option>
<option <?php if($q5=="Nauru"){echo "selected";} ?> value="Nauru">Nauru</option>
<option <?php if($q5=="Nepal"){echo "selected";} ?> value="Nepal">Nepal</option>
<option <?php if($q5=="Netherlands"){echo "selected";} ?> value="Netherlands">Netherlands</option>
<option <?php if($q5=="Netherlands Antilles"){echo "selected";} ?> value="Netherlands Antilles">Netherlands Antilles</option>
<option <?php if($q5=="New Caledonia"){echo "selected";} ?> value="New Caledonia">New Caledonia</option>
<option <?php if($q5=="New Zealand"){echo "selected";} ?> value="New Zealand">New Zealand</option>
<option <?php if($q5=="Nicaragua"){echo "selected";} ?> value="Nicaragua">Nicaragua</option>
<option <?php if($q5=="Niger"){echo "selected";} ?> value="Niger">Niger</option>
<option <?php if($q5=="Nigeria"){echo "selected";} ?> value="Nigeria">Nigeria</option>
<option <?php if($q5=="Niue"){echo "selected";} ?> value="Niue">Niue</option>
<option <?php if($q5=="Norfolk Island"){echo "selected";} ?> value="Norfolk Island">Norfolk Island</option>
<option <?php if($q5=="Northern Mariana Islands"){echo "selected";} ?> value="Northern Mariana Islands">Northern Mariana Islands</option>
<option <?php if($q5=="Norway"){echo "selected";} ?> value="Norway">Norway</option>
<option <?php if($q5=="Oman"){echo "selected";} ?> value="Oman">Oman</option>
<option <?php if($q5=="Pakistan"){echo "selected";} ?> value="Pakistan">Pakistan</option>
<option <?php if($q5=="Palau"){echo "selected";} ?> value="Palau">Palau</option>
<option <?php if($q5=="Panama"){echo "selected";} ?> value="Panama">Panama</option>
<option <?php if($q5=="Papua New Guinea"){echo "selected";} ?> value="Papua New Guinea">Papua New Guinea</option>
<option <?php if($q5=="Paraguay"){echo "selected";} ?> value="Paraguay">Paraguay</option>
<option <?php if($q5=="Peru"){echo "selected";} ?> value="Peru">Peru</option>
<option <?php if($q5=="Philippines"){echo "selected";} ?> value="Philippines">Philippines</option>
<option <?php if($q5=="Pitcairn"){echo "selected";} ?> value="Pitcairn">Pitcairn</option>
<option <?php if($q5=="Poland"){echo "selected";} ?> value="Poland">Poland</option>
<option <?php if($q5=="Portugal"){echo "selected";} ?> value="Portugal">Portugal</option>
<option <?php if($q5=="Puerto Rico"){echo "selected";} ?> value="Puerto Rico">Puerto Rico</option>
<option <?php if($q5=="Qatar"){echo "selected";} ?> value="Qatar">Qatar</option>
<option <?php if($q5=="Reunion"){echo "selected";} ?> value="Reunion">Reunion</option>
<option <?php if($q5=="Romania"){echo "selected";} ?> value="Romania">Romania</option>
<option <?php if($q5=="Russian Federation"){echo "selected";} ?> value="Russian Federation">Russian Federation</option>
<option <?php if($q5=="Rwanda"){echo "selected";} ?> value="Rwanda">Rwanda</option>
<option <?php if($q5=="Saint Lucia"){echo "selected";} ?> value="Saint Lucia">Saint Lucia</option>
<option <?php if($q5=="Samoa"){echo "selected";} ?> value="Samoa">Samoa</option>
<option <?php if($q5=="San Marino"){echo "selected";} ?> value="San Marino">San Marino</option>
<option <?php if($q5=="Sao Tome &amp; Principe"){echo "selected";} ?> value="Sao Tome &amp; Principe">Sao Tome &amp; Principe</option>
<option <?php if($q5=="Saudi Arabia"){echo "selected";} ?> value="Saudi Arabia">Saudi Arabia</option>
<option <?php if($q5=="Senegal"){echo "selected";} ?> value="Senegal">Senegal</option>
<option <?php if($q5=="Seychelles"){echo "selected";} ?> value="Seychelles">Seychelles</option>
<option <?php if($q5=="Sierra Leone"){echo "selected";} ?> value="Sierra Leone">Sierra Leone</option>
<option <?php if($q5=="Singapore"){echo "selected";} ?> value="Singapore">Singapore</option>
<option <?php if($q5=="Slovakia"){echo "selected";} ?> value="Slovakia">Slovakia</option>
<option <?php if($q5=="Slovenia"){echo "selected";} ?> value="Slovenia">Slovenia</option>
<option <?php if($q5=="Solomon Islands"){echo "selected";} ?> value="Solomon Islands">Solomon Islands</option>
<option <?php if($q5=="Somalia"){echo "selected";} ?> value="Somalia">Somalia</option>
<option <?php if($q5=="South Africa"){echo "selected";} ?> value="South Africa">South Africa</option>
<option <?php if($q5=="South Georgia and the South Sandwich Islands"){echo "selected";} ?> value="South Georgia and the South Sandwich Islands">South Georgia and the South Sandwich Islands</option>
<option <?php if($q5=="Spain"){echo "selected";} ?> value="Spain">Spain</option>
<option <?php if($q5=="Sri Lanka"){echo "selected";} ?> value="Sri Lanka">Sri Lanka</option>
<option <?php if($q5=="St. Helena"){echo "selected";} ?> value="St. Helena">St. Helena</option>
<option <?php if($q5=="St. Kitts and Nevis"){echo "selected";} ?> value="St. Kitts and Nevis">St. Kitts and Nevis</option>
<option <?php if($q5=="St. Pierre &amp; Miquelon"){echo "selected";} ?> value="St. Pierre &amp; Miquelon">St. Pierre &amp; Miquelon</option>
<option <?php if($q5=="St. Vincent &amp; the Grenadines"){echo "selected";} ?> value="St. Vincent &amp; the Grenadines">St. Vincent &amp; the Grenadines</option>
<option <?php if($q5=="Sudan"){echo "selected";} ?> value="Sudan">Sudan</option>
<option <?php if($q5=="Suriname"){echo "selected";} ?> value="Suriname">Suriname</option>
<option <?php if($q5=="Svalbard &amp; Jan Mayen Islands"){echo "selected";} ?> value="Svalbard &amp; Jan Mayen Islands">Svalbard &amp; Jan Mayen Islands</option>
<option <?php if($q5=="Swaziland"){echo "selected";} ?> value="Swaziland">Swaziland</option>
<option <?php if($q5=="Sweden"){echo "selected";} ?> value="Sweden">Sweden</option>
<option <?php if($q5=="Switzerland"){echo "selected";} ?> value="Switzerland">Switzerland</option>
<option <?php if($q5=="Syrian Arab Republic"){echo "selected";} ?> value="Syrian Arab Republic">Syrian Arab Republic</option>
<option <?php if($q5=="Taiwan, Province of China"){echo "selected";} ?> value="Taiwan, Province of China">Taiwan, Province of China</option>
<option <?php if($q5=="Tajikistan"){echo "selected";} ?> value="Tajikistan">Tajikistan</option>
<option <?php if($q5=="Tanzania, United Republic of"){echo "selected";} ?> value="Tanzania, United Republic of">Tanzania, United Republic of</option>
<option <?php if($q5=="Thailand"){echo "selected";} ?> value="Thailand">Thailand</option>
<option <?php if($q5=="Togo"){echo "selected";} ?> value="Togo">Togo</option>
<option <?php if($q5=="Tokelau"){echo "selected";} ?> value="Tokelau">Tokelau</option>
<option <?php if($q5=="Tonga"){echo "selected";} ?> value="Tonga">Tonga</option>
<option <?php if($q5=="Trinidad &amp; Tobago"){echo "selected";} ?> value="Trinidad &amp; Tobago">Trinidad &amp; Tobago</option>
<option <?php if($q5=="Tunisia"){echo "selected";} ?> value="Tunisia">Tunisia</option>
<option <?php if($q5=="Turkey"){echo "selected";} ?> value="Turkey">Turkey</option>
<option <?php if($q5=="Turkmenistan"){echo "selected";} ?> value="Turkmenistan">Turkmenistan</option>
<option <?php if($q5=="Turks &amp; Caicos Islands"){echo "selected";} ?> value="Turks &amp; Caicos Islands">Turks &amp; Caicos Islands</option>
<option <?php if($q5=="Tuvalu"){echo "selected";} ?> value="Tuvalu">Tuvalu</option>
<option <?php if($q5=="Uganda"){echo "selected";} ?> value="Uganda">Uganda</option>
<option <?php if($q5=="Ukraine"){echo "selected";} ?> value="Ukraine">Ukraine</option>
<option <?php if($q5=="United Arab Emirates"){echo "selected";} ?> value="United Arab Emirates">United Arab Emirates</option>
<option <?php if($q5=="United Kingdom (Great Britain)"){echo "selected";} ?> value="United Kingdom (Great Britain)">United Kingdom (Great Britain)</option>
<option <?php if($q5=="United States Minor Outlying Islands"){echo "selected";} ?> value="United States Minor Outlying Islands">United States Minor Outlying Islands</option>
<option <?php if($q5=="United States of America"){echo "selected";} ?> value="United States of America">United States of America</option>
<option <?php if($q5=="United States Virgin Islands"){echo "selected";} ?> value="United States Virgin Islands">United States Virgin Islands</option>
<option <?php if($q5=="Uruguay"){echo "selected";} ?> value="Uruguay">Uruguay</option>
<option <?php if($q5=="Uzbekistan"){echo "selected";} ?> value="Uzbekistan">Uzbekistan</option>
<option <?php if($q5=="Vanuatu"){echo "selected";} ?> value="Vanuatu">Vanuatu</option>
<option <?php if($q5=="Vatican City State"){echo "selected";} ?> value="Vatican City State">Vatican City State</option>
<option <?php if($q5=="Venezuela"){echo "selected";} ?> value="Venezuela">Venezuela</option>
<option <?php if($q5=="Vietnam"){echo "selected";} ?> value="Vietnam">Vietnam</option>
<option <?php if($q5=="Wallis &amp; Futuna Islands"){echo "selected";} ?> value="Wallis &amp; Futuna Islands">Wallis &amp; Futuna Islands</option>
<option <?php if($q5=="Western Sahara"){echo "selected";} ?> value="Western Sahara">Western Sahara</option>
<option <?php if($q5=="Yemen"){echo "selected";} ?> value="Yemen">Yemen</option>
<option <?php if($q5=="Yugoslavia"){echo "selected";} ?> value="Yugoslavia">Yugoslavia</option>
<option <?php if($q5=="Zaire"){echo "selected";} ?> value="Zaire">Zaire</option>
<option <?php if($q5=="Zambia"){echo "selected";} ?> value="Zambia">Zambia</option>
<option <?php if($q5=="Zimbabwe"){echo "selected";} ?> value="Zimbabwe">Zimbabwe</option>
</select>
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q6" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">Postal code </label> <input id="q6" maxlength="" name="q6" size="40" type="text" value="<?php echo $q6; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q7" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">City where company is located </label> <input id="q7" maxlength="" name="q7" size="40" type="text" value="<?php echo $q7; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: #efefef; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="q8" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">company's website </label> <input id="q8" maxlength="" name="q8" size="40" type="text" value="<?php echo $q8; ?>" />
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; border-bottom: 0px solid #d8d8d8; clear: left; margin: 0; padding: 5px;"><label for="email" style="color: black; float: left; font-family: &quot;arial&quot;; font-size: 14px; padding-top: 4px; width: 30%;">E-mail Address: <span style="color: red;">*</span></label>
  <input id="email" maxlength="100" name="email" required="required" size="40" type="email" value="<?php echo $email; ?>" /><br />
Email Address will not be published
  </td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; clear: left; margin: 0; padding: 5px;"><hr style="background-color: #d8d8d8; color: #d8d8d8; height: 1px;" />
</td>
 </tr>
<tr style="margin: 0; padding: 0;">
  <td style="background-color: white; clear: left; margin: 0; padding: 5px;"><input id="user" name="user" type="hidden" value="socialjersey" />
   <input id="formid" name="formid" type="hidden" value="438516" />
   <input id="subject" name="subject" type="hidden" value="Submit Complaint" />
   <input name="btnsubmittab45" type="submit" value="Submit" />
 </td>
 </tr>
</tbody></table>
</form>
<script type="text/javascript">
 function submitForm1() {
    document.getElementById('sdateForm4').submit(); // SUBMIT FORM
    }
</script>

</body>


/home/agrawaaldevika/public_html/socialjersey/form_process4.php


<?php
session_start();
require_once('dbconnect.php');
$_SESSION['q1'] = $_POST['q1'];
$_SESSION['q2'] = $_POST['q2'];
$_SESSION['q3'] = $_POST['q3'];
$_SESSION['q4'] = $_POST['q4'];
$_SESSION['q5'] = $_POST['q5'];
$_SESSION['q6'] = $_POST['q6'];
$_SESSION['q7'] = $_POST['q7'];
$_SESSION['q8'] = $_POST['q8'];

$_SESSION['q3'] = $_POST['q3'];
$_SESSION['email'] = $_POST['email'];
$_SESSION['user'] = $_POST['user'];
$_SESSION['formid'] = $_POST['formid'];
$_SESSION['subject'] = $_POST['subject'];
$_SESSION['SUBMIT'] = "TAB5";

$query = "SELECT BUTTON_ID,URL FROM PAYPAL_INFO WHERE IS_ACTIVE=1 AND TAB_ID=4";
$result = mysqli_query($conn,$query) or trigger_error("SQL", E_USER_ERROR);

while(($row = mysqli_fetch_array($result)) ) {
   $buttonId = $row["BUTTON_ID"];
   $url = $row["URL"];
}
?>


<body  >

     <form name="postForm" action="<?php echo $url; ?>" method="post" >
        <input type="hidden" name="cmd" value="_s-xclick">
        <input type="hidden" name="hosted_button_id" value="<?php echo $buttonId; ?>">
     
    </form>
   
<script>
   
   
   
      var postForm = document.forms.postForm;
      postForm.submit();
 
</script>
</body>



set timeout code

<script>
setTimeout(function () {
   window.location.href= 'http://www.socialjersey.com/'; // the redirect goes here

},4000); // 4 seconds
</script>

socialjersey/css/main.css

socialjersey/css/main.css


@charset "utf-8";
/* CSS Document */

body
{
margin:0px auto;
padding:0px;
font-family:Century Gothic;
color:white;
line-height:1.7;
font-size:14px;

}
div.view_status
{
text-align: center;
}
div.view_status table
{
position:relative;
top: 10%;
width: 100%;
text-align: center;

}
div.view_status th
{
background-color: beige;
color:black;
}
div.view_status td{
text-align: center;
}
div.profileimg img
{
position:relative;
align-items:right;
float:right;
right:4%;
size:absolute;
height:150px;
width:150px;
margin-top:0%;
margin-bottom:-15%;
}


div.form{
position:relative;
top:0%;
text-align:right;
right:10%;
}
div.desc{
width:40%;
position:absolute;
text-align:center;
top:35%;
left:10%;
}



div.date
{ text-align:right;
postition:relative;

width:100%;
font-size:85%;
}

h2
{ position:relative;
top:2%;
text-align:center;
left:1%;
padding:0px;
}

h3
{ position:relative;
top:2%;
text-align:right;
right:13%;
padding:10px;
}

div.header
position:relative;
left:10%;
size:relative;
top:1%;

width:80%;
height:auto;
background-color:#334455;

}

div.header1
position:absolute;
left:10%;
size:absolute;
top:1%;

width:80%;
height:95%;
background-color:#334455;

}


div.banner
{
position:relative;
top:1%;
width:100%;
}
div.user
{
position:relative;
top:2%;
width:100%;
right:2%;
text-align:right;
font-size:85%;


}

div.tab
{

position:relative;
left:1%;
top:0%;
width:95%;
text-align:center;
height:auto:
color:#FFE4C4;}

div.tab th {background-color:#088A08;

}
div.tab td {background-color:#01DF74;

text-align:left;
color:#000000;
}

div.tab1{
position:relative;
left:1%;
top:1%;

text-align:center;
width:95%;
height:auto:
color:#000000;}

div.tab1 th {background-color:#FF8000;

}
div.tab1 td {background-color:#F7BE81;

text-align:left;

color:#000000;
}

div.tab1 td a{
text-decoration:none;
background-position: center;
background-image: url(receive.png);
  background-size: 40px 28px;
background-repeat:no-repeat;
padding:0.25em 3em;
;
}

div.tab2{ 
position:relative;
left:1%;
top:1%;

text-align:center;
width:95%;
height:auto:}

div.tab2 th {background-color:#BDBDBD;
color:#000000;


}
div.tab2 td {background-color:#E6E6E6;

text-align:left;
color:#000000;
}
div.sent{ 
position:relative;
left:1%;
top:1%;
text-align:left;
width:95%;
height:auto:
}

div.sent th {background-color:#FCF927;
text-align:center;
color:#000000;

}
div.sent td {background-color:#F2F5A9;
color:#000000;
}




div.tab4{ 
position:relative;
top:1%;
width:100%;
height:auto;
text-align:center;
}


div.tab4 th {background-color:#DDDDDD;
text-align:center;
color:#000000;

}

div.tab8{ 
position:relative;
top:1%;
width:100%;
height:auto;
text-align:center;
}
div.tab8 table
{
width:98%;
}


div.tab8 th {background-color:#DDDDDD;
text-align:center;
color:#000000;

}



ul
{
    /*width:500px;margin:0 auto;*//*Uncomment this line to make the menu center-aligned.*/
position:relative;
top:2%;
    text-align:center;
    background:#332E28;
    border:1px solid black;
    font-size:0;
    padding:1px;
}

div.menu5 a
{
    display: inline-block;
    padding: 0 20px;
    background:#3A332C;
    border:1px solid #5E544A;
    color:#C4B09C;
    text-decoration:none;
    font: bold 12px Arial;
    line-height: 27px;
    margin-right:1px;
}

ul a:hover, ul a.current
{
    
background:#484037;
    color:#FFFFFF;
}
ul a.home1:hover
{
background:#045FB4;
display:inline;
color:#C4B09C;
text-decoration:none;
color:white;
background-position: center;
background-image: url(home.png);
  background-size: 30px 28px;
background-repeat:no-repeat;
padding:0.6em 1.3em;
}
ul a.log:hover

{
display:inline;
color:#C4B09C;
text-decoration:none;
background:#045FB4;
background-position: center;
background-image: url(logout.png);
  background-size: 30px 28px;
background-repeat:no-repeat;
padding:0.6em 1.3em;
}
li
{
display:inline;
}

a.home1
{
display:inline;
background:#484037;
text-decoration:none;
color:white;
background-position: center;
background-image: url(home.png);
  background-size: 30px 28px;
background-repeat:no-repeat;
padding:0.6em 1.3em;
}
ul a
{
    display: inline-block;
    padding: 0 20px;
    background:#045FB4;
    border:1px solid #5E544A;
    color:#FFFFFF;
   
    text-decoration:none;
    font: bold 12px Arial;
    line-height: 27px;
    margin-right:1px;
}
a.log
{
display:inline;
color:white;
text-decoration:none;
background:#484037;
background-position: center;
background-image: url(logout.png);
  background-size: 30px 28px;
background-repeat:no-repeat;
padding:0.6em 1.3em;
}
.captcha
{
position: relative;
top: 90%;
}

.login
{
position: relative;
top: 90%;
right:5%;
}

.forgot
{
position: relative;
top: 0%;
right:1%;
}


#txthint{
position:relative;
align:center;
}
==================================================================

/socialjersey/css/style1.css


* {
margin: 0;
padding: 0;
border: 0;
outline: none;
text-decoration: none;
list-style: none;
line-height: 24px;
font-family: segoe ui, helvetica neue, helvetica, arial, sans-serif;
-webkit-font-smoothing: antialiased;
}
body{
font-family: 'Open Sans', sans-serif;
margin:0;
background-clip: border-box;
    background-color: #31302b;
}
a.search1{
border-left-color: #d0d1d2;
    border-left-style: solid;
    border-left-width: 1px;
    line-height: 23px;
    padding-left: 16px;
}
.logo{
   float: left;
    height: 46px;
    left: 0;
margin-top:23px;
margin-left:40px;
    position: absolute;
    width: 160px;
    z-index: 10;
}

.top-header{
box-shadow: 0 1px 3px #888;
       background-attachment: scroll;
    background-clip: border-box;
    background-color: #f4f6f5;
    background-image: none;
    background-origin: padding-box;
    background-position-x: 0;
    background-position-y: 0;
    background-repeat: repeat;
    background-size: auto auto;
    border-bottom-color: #cac3b4;
    border-bottom-style: solid;
    border-bottom-width: 1px;
    height: 106px;
    position: fixed;
    top: 0;
    width: 100%;
    z-index: 100;
}
.container{
margin-bottom: 0;
    margin-left: auto;
    margin-right: auto;
    margin-top: 0;
    max-width: 1400px;
    position: relative;
}
.search, a{
color:#7b756b;
margin:0;
font-size: 14.5px;
text-decoration:none;
text-align:right;
padding-right:20px;
padding-top:20px;
}

.nav {
  overflow: hidden;
  width: 500px;
  margin: 20px auto;
}

.nav > li {
  float: left;
  background: transparent;
  width: 25%;
}

.nav > li > a, .nav li ul li a {
  display: block;
  padding: 10px 20px 10px 20px;
  color: #626366;
  text-align: center;
}

.nav li ul li a:hover {
  background: #fff;
}

.nav > li:hover {
  background: #FFF;
}

.dropdown {
  display: none;
      background-attachment: scroll;
    background-clip: border-box;
    background-color: #323334;
    background-image: none;
    background-origin: padding-box;
    background-position-x: 0;
    background-position-y: 0;
    background-repeat: repeat;
    background-size: auto auto;
    color: #fff;
    left: calc(-50vw + 50%);
    margin-bottom: 0;
    margin-left: auto;
    margin-right: auto;
    margin-top: 0;
    padding-bottom: 23px;
    padding-left: 0;
    padding-right: 0;
    padding-top: 23px;
    position: absolute;
    width: 100vw;
    z-index: 100;
}
.box{
background-color: lightgrey;
    width: 200px;
    border: 10px solid grey;
    padding: 15px;
margin:10px;
}
.first{
width:44%;
margin-left:4%;
}

.second{
width:44%;
margin-left:4%;
}
.dropdown-inner {
display:inline-flex;
    margin-bottom: 0;
    margin-left: auto;
    margin-right: auto;
    margin-top: 0;
width:95%;
    max-width: 1170px;
}
.nav > li:hover .dropdown{
  display: block;
}

footer {
   background-attachment: scroll;
    background-clip: border-box;
    background-color: transparent;
    background-image: none;
    background-origin: padding-box;
    background-position-x: 0;
    background-position-y: 0;
    background-repeat: repeat;
    background-size: auto auto;
    padding-bottom: 50px;
    padding-left: 0;
    padding-right: 0;
    padding-top: 70px;
}
footer .container{
   width: 1170px;
   margin-left: auto;
    margin-right: auto;
}

php_pagination/perpage.php

php_pagination/perpage.php


<?php

define("PERPAGE_LIMIT",2);
function connectDB(){
$servername="localhost";
    $username = "root";
$password = "";
$dbname = "article";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
return $conn;
}
function getFAQ() {
$sql = "SELECT * FROM articleinfo";
$conn=connectDB();
// getting parameters required for pagination
$currentPage = 1;
if(isset($_GET['pageNumber'])){
$currentPage = $_GET['pageNumber'];
}
$startPage = ($currentPage-1)*PERPAGE_LIMIT;
if($startPage < 0) $startPage = 0;
$href = "/perpage.php?";

//adding limits to select query
$query =  $sql . " limit " . $startPage . "," . PERPAGE_LIMIT; 
$result = mysqli_query($conn,$query);

while($row=mysqli_fetch_array($result)) {
$questions[] = $row;
}

if(is_array($questions)){
$questions["page_links"] = paginateResults($sql,$href);
return $questions;
}
}

//function creates page links
function pagination($count, $href) {
$output = '';
if(!isset($_REQUEST["pageNumber"])) $_REQUEST["pageNumber"] = 1;
if(PERPAGE_LIMIT != 0)
$pages  = ceil($count/PERPAGE_LIMIT);

//if pages exists after loop's lower limit
if($pages>1) {
if(($_REQUEST["pageNumber"]-3)>0) {
$output = $output . "<a href='{$_SERVER['PHP_SELF']}?pageNumber=1' class='page'> 1</a>";
}
if(($_REQUEST["pageNumber"]-3)>1) {
$output = $output . '...';
}

//Loop for provides links for 2 pages before and after current page
for($i=($_REQUEST["pageNumber"]-2); $i<=($_REQUEST["pageNumber"]+2); $i++) {
if($i<1) continue;
if($i>$pages) break;
if($_REQUEST["pageNumber"] == $i)
$output = $output . '<span id='.$i.' class="current">'.$i.'</span>';
else
$output = $output . "<a href='{$_SERVER['PHP_SELF']}?pageNumber=" .($i) ."' class='page'>" . ($i) .'</a>';
}

//if pages exists after loop's upper limit
if(($pages-($_REQUEST["pageNumber"]+2))>1) {
$output = $output . '...';
}
if(($pages-($_REQUEST["pageNumber"]+2))>0) {
if($_REQUEST["pageNumber"] == $pages)
$output = $output . '<span id=' . ($pages) .' class="current">' . ($pages) .'</span>';
else
$output = $output . "<a href='{$_SERVER['PHP_SELF']}?pageNumber=" .($pages) ."' class='page'>" . ($pages) .'</a>';
}

}
return $output;
}

//function calculate total records count and trigger pagination function
function paginateResults($sql, $href) {$conn=connectDB();
$result  = mysqli_query($conn,$sql);
$count   = mysqli_num_rows($result);
$page_links = pagination($count, $href);
return $page_links;
}
?>
<html>
<head>
<title>PHP Pagination</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
<head>
<body>
<table border="0" cellpadding="10" cellspacing="1" width="500" align="center">
<tr class="tableheader">
<td>Frequently Asked Questions</td>
</tr>
<?php
connectDB();
$questions = getFAQ();
if(is_array($questions)) {
for($i=0;$i<count($questions)-1;$i++) {
?>
<tr class="tablerow">
<td><h2><?php echo $questions[$i]["title"]; ?></h2><br/>
<span class="date">Added Date: <?php echo $questions[$i]["date_created"]; ?></span></td>
</tr>
<?php
}
?>
<tr class="tableheader">
<td colspan="2"><?php echo $questions["page_links"]; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>

===================================================================

/php_pagination/styles.css


.tableheader {
background-color: #95BEE6;
font-weight:bold;
text-align: center;
}
.tablerow {
background-color: #A7D6F1;
color:white;
}
.message {
color: #FF0000;
font-weight: bold;
text-align: center;
width: 100%;
}
a{
text-decoration:none;
margin: 5px;
padding: 3px 5px;
color: #FFFFFF;
background-color: #07A6F1;
border: #A7D6F1 1px solid;
}
.current {
margin: 5px;
padding: 3px 5px;
color:#07A6F1;
background-color: #CCCCCC;
border: #07A6F1 1px solid;
}
.date {
color: #999;
}

search code

socialjersey/dbconnect.php


<?PHP


$servername="localhost";
    $username = "USERNAME";
$password = "PASSWORD";
$dbname = "DATABASE";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
 ?>

================================================================

search code



<html>
    <head>
        <title>PR Article Directory Business Listing</title>
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE= edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <title>Bootstrap 3 Fixed Layout Example</title>
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
        <meta name="viewport" content="width=device-width, initial-scale=1.0">

    </head>
    <body>
   
<div class="searchBar">
<div>
<form action="http://127.0.0.1:8080/article/search.php" method="GET">
<div class="col-lg-6 form-group " style="margin-left:10%;margin-top:2%;" >                

<?php

require_once('dbconnect.php');
echo "<input class=\"form-control\" id=\"search\" value =\"".$_GET['q']."\" name=\"q\" type=\"text\"/></div><button type=\"submit\" style=\"margin-top:2%;\" class=\"btn btn-default\">Search</button></div></form></div><div class=\"searchResult\">";
if (isset($_GET['pageno'])) {
   $pageno = $_GET['pageno'];
} else {
   $pageno = 1;
} // if
if(isset($_GET['q']) ||isset($_GET['link']))

{
$q=trim($_GET['q']);

$condition = explode(" ",$q);
$GLOBALS['a'] ;
$GLOBALS['x'] ;

for($x=0;$x<count($condition);$x++){
if($x==0){
$GLOBALS['a'] = "keywords like '%".$condition[$x]."%'";
}else{
$GLOBALS['a'] = $GLOBALS['a']." and keywords like '%".$condition[$x]."%'";
}
}
for($l=0;$l<count($condition);$l++){
if($l==0){
$GLOBALS['m'] = "name like '%".$condition[$l]."%'";
}else{
$GLOBALS['m'] = $GLOBALS['m']." and name like '%".$condition[$l]."%'";
}
}
$query = "SELECT count(*) FROM articleinfo WHERE 1=1 and (".$GLOBALS['a'].") or url like '%$q%' or title  like '%$q%' or (".$GLOBALS['m'].")";
$result = mysqli_query( $conn,$query) or trigger_error("SQL", E_USER_ERROR);
$query_data = mysqli_fetch_row($result);
$numrows = $query_data[0];
$rows_per_page = 10;
$lastpage      = ceil($numrows/$rows_per_page);
$pageno = (int)$pageno;
if ($pageno > $lastpage) {
   $pageno = $lastpage;
} // if
if ($pageno < 1) {
   $pageno = 1;
} // if

$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;

$query = "SELECT * FROM articleinfo WHERE 1=1 and (".$GLOBALS['a'].") or url like '%$q%' or title  like '%$q%' or (".$GLOBALS['m'].") $limit";
$result = mysqli_query($conn,$query) or trigger_error("SQL", E_USER_ERROR);

$GLOBALS['b']=0 ;
while(($row = mysqli_fetch_array($result)) ) {
   if($GLOBALS['b']==0){
    echo "<div style=\"font-size: 25; margin-top:-40px;\"><u><b>Search</b></u></div>";
    $GLOBALS['b']++;
   }
   echo "<div class='linkText'><a href=".$row['url'].">".$row['title']."</a></div>";
}
if($result->num_rows==0){
echo "<div class='linkText'>No records found. Please try with another keyword(s)</div>";
}
echo "</div>";

//  Paging starts
echo "<div class=\"pagging pagination\"> Page $pageno of $lastpage <div style=\"margin-left:25%;margin-right:25%\">";
$i=0;
while($i<$lastpage){
$i++;
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$i&q=$q'>$i</a> ";

}
}

?>
</div>
</div>
    </body>
<style>

.linkText{
padding:2px;
font-size: 20px;
    text-decoration-color: blueviolet;
}
.searchBar{
background-color:#fafafa;
height:15%;
width:100%;
border-bottom-style: solid;
        border-bottom-width: 2px;
        border-bottom-color: rgba(0, 128, 93, 0.77);
}
.searchResult{
height:70%;
width:70%;
margin-left:10%;
padding-top:4%;
padding-left:6%;

}

.pagging{
height:10%;
width:100%;
background-color:#fafafa;
border-top-style: solid;
        border-top-width: 2px;
        border-top-color: rgba(0, 128, 93, 0.77);
}
}
.pagination {
    display: inline-block;
}

.pagination a {
    color: black;
    float: left;
    padding: 8px 16px;
    text-decoration: none;
}

.pagination a.active {
    background-color: red;
    color: blue;
    border-radius: 5px;
}

.pagination a:hover:not(.active) {
    background-color:rgba(51, 51, 51, 0.38);;
    border-radius: 5px;
}


</style>


</html>