SystemWebTech Online
School Login Upload Fetch Project
=============== Register========================
<html>
<body>
<form action="uploads.php" method="post" >
<p>First Name:<input type="text" name="fname" required= "required">Last Name:<input type="text" name="lname" required= "required"></p>
<p>Email:<input type="email" name="email" required= "required"></p>
<p>Password:<input type="password" name="password" required= "required" >
<p>Date of Birth:<input type="date" name="dob" required= "required" >
<p><input type="submit" name="submit"></p>
</form>
</body>
</html>
================================Connect===================
<?php
$connection = mysqli_connect('localhost', 'devika', 'devika');
if (!$connection){
die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'school');
if (!$select_db){
die("Database Selection Failed" . mysqli_error($connection));
}
?>
<html>
<body>
<form action="uploads.php" method="post" >
<p>First Name:<input type="text" name="fname" required= "required">Last Name:<input type="text" name="lname" required= "required"></p>
<p>Email:<input type="email" name="email" required= "required"></p>
<p>Password:<input type="password" name="password" required= "required" >
<p>Date of Birth:<input type="date" name="dob" required= "required" >
<p><input type="submit" name="submit"></p>
</form>
</body>
</html>
================================Connect===================
<?php
$connection = mysqli_connect('localhost', 'devika', 'devika');
if (!$connection){
die("Database Connection Failed" . mysqli_error($connection));
}
$select_db = mysqli_select_db($connection, 'school');
if (!$select_db){
die("Database Selection Failed" . mysqli_error($connection));
}
?>
===============================Login===================
<html>
<body>
<form action="session.php" method="post" >
<p>Email:<input type="email" name="email" required= "required"></p>
<p>Password:<input type="password" name="password" required= "required" >
<p><input type="submit" name="submit"></p>
</form>
<p><u><a href="http://localhost/school/register.php">Create an Account</a></u></p>
</body>
</html>
===================Session===============================
<?php //Start the Session
session_start();
require('connect.php');
//3. If the form is submitted or not.
//3.1 If the form is submitted
if (isset($_POST['email']) and isset($_POST['password'])){
//3.1.1 Assigning posted values to variables.
$username = $_POST['email'];
$password = $_POST['password'];
//3.1.2 Checking the values are existing in the database or not
$query = "SELECT * FROM `register` WHERE email='$username' and password='$password'";
$result = mysqli_query($connection, $query) or die(mysqli_error($connection));
$count = mysqli_num_rows($result);
//$row = mysql_fetch_array($result);
$count =1;
//3.1.2 If the posted values are equal to the database values, then session will be created for the user.
if ($count == 1){
$_SESSION['username'] = $username;
}else{
//3.1.3 If the login credentials doesn't match, he will be shown with an error message.
$fmsg = "Invalid Login Credentials.";
echo $fmsg;
}
}
//3.1.4 if the user is logged in Greets the user with message
if (isset($_SESSION['username']))
{
$username = $_SESSION['username'];
echo "Hai " . $username . "";
echo "This is the Members Area";
echo "<a href='logout.php'>Logout</a>";
include 'studentform.php';
}else{}
//3.2 When the user visits the page first time, simple login form will be displayed.
?>
=============================StudentForm=======================
<html>
<body>
<form action="uploads.php" method="post" enctype="multipart/form-data" >
<p>First Name:<input type="text" name="fname" required= "required">Last Name:<input type="text" name="lname" required= "required"></p>
<p>Roll No:<input type="text" name="roll" required= "required"></p>
<p>Class:<input type="text" name="class" required= "required" >
<p>Date of Birth:<input type="date" name="dob" required= "required" >
<p>Father Name:<input type="text" name="faname" required= "required">Mother Name:<input type="text" name="moname" required= "required"></p>
<p>Address:<input type="text" name="address" required= "required" >
<p>Phone:<input type="text" name="phone" required= "required" >
<p>Marks:<input type="text" name="marks" required= "required" >
<p>Status:<input type="text" name="status" required= "required" >
<p><input type="file" name="fileToUpload" value="Upload Image" id="fileToUpload">
<p><input type="submit" name="submit"></p>
</form>
</body>
</html>
=========================Uploads==========================
<?php
$firstname = $_POST['fname'];
$lastname = $_POST['lname'];
$rollno = $_POST['roll'];
$class = $_POST['class'];
$dob = $_POST['dob'];
$fathername = $_POST['faname'];
$mothername = $_POST['moname'];
$houseadd = $_POST['address'];
$contact = $_POST['phone'];
$marksheet = $_POST['marks'];
$status = $_POST['status'];
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
if($check !== false) {
echo "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
echo "File is not an image.";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
echo "Sorry, file already exists.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
$servername = "localhost";
$username = "devika";
$password = "devika";
$dbname = "school";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO studentdata (firstname, lastname, rollno,class,dateofbirth,fathername,mothername,address,phone,marks,status,image)
VALUES ('$firstname', '$lastname', '$rollno','$class','$dob','$fathername','$mothername','$houseadd','$contact','$marksheet','$status','$target_file')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
} else {
echo "Sorry, there was an error uploading your file.";
}
}
include 'fetch.php';
?>
===============================Fetch======================
<?php
$con= mysqli_connect("localhost","devika","devika","school");
if(mysqli_connect_errno())
{
echo "Failed to connect " . mysqli_connect_error();
}
$sql="SELECT * FROM studentdata";
if ($result = mysqli_query($con,$sql))
{
?>
<table border= '1'>
<tr><td>First Name</td><td>Last Name</td><td>Roll No</td><td>Class</td><td>Date of Birth</td><td>Father Name</td><td>Mother Name</td><td>Address</td><td>Phone</td><td>Marks</td><td>Status</td><td>Image</td></tr>
<?php
while ($row=mysqli_fetch_row($result))
{
$firstname=$row[0];
$lastname=$row[1];
$rollno=$row[2];
$class=$row[3];
$dateofbirth=$row[4];
$fathername=$row[5];
$mothername=$row[6];
$address=$row[7];
$phone=$row[8];
$email=$row[9];
$password=$row[10];
$image_path=$row[11];
$image_path=$row[12];
?>
<tr>
<td><?php echo $firstname;?></td>
<td><?php echo $lastname;?></td>
<td><?php echo $rollno;?></td>
<td><?php echo $class;?></td>
<td><?php echo $dateofbirth;?></td>
<td><?php echo $fathername;?></td>
<td><?php echo $mothername;?></td>
<td><?php echo $address;?></td>
<td><?php echo $phone;?></td>
<td><?php echo $marks;?></td>
<td><?php echo $status;?></td>
<td><img src = '<?php echo $image_path;?>' width='100' height= '100'/></td>
</tr></br>
<?php
}
// Free result set
mysqli_free_result($result);
?>
</table>
<?php
}
mysqli_close($con);
?>
<html>
<body>
<form action="" method="post" >
<p>Enter Roll No:<input type="text" name="roll" required= "required"></p>
</form>
</body>
</html>
==============================Logout=======================
<?php
session_start();
session_destroy();
header('Location: login.php');
?>
Google SignIn App Code
<!Doctype html>
<head><title>Google SignIn</title>
<meta name="google-signin-client_id" content="428136239793-
<script src="https://apis.google.com/
<script src="https://ajax.googleapis.
<script src=" "></script>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.
<Style>
.g-signin2{
margin-left:500px;
margin-top:200px;
}
.data{display:none;}
</style></head>
<body>
<div class="g-signin2" data-onsuccess="onSignIn"></
<div class="data">
<p>Profile Details</p>
<img id="pic" class="img-circle" width="100" height="100"/>
<p>Email Address</p><p id="email" class="alert alert-danger"</p>
<button onclick="signOut()" class="btn btn-danger">SignOut</button></
</body>
</html>
=========================
function onSignIn(googleUser)
{
var profile= googleUser.getBasicProfile();
$(".g-signin2").css("display",
$(".data").css("display","
$("#pic").attr('src',profile.
$("#email").text(profile.
}
function signOut(){
var auth2 = gapi.auth2.getAuthInstance();
auth2.signOut().then(function(
alert ("You have successfully signed out");
$(".g-signin2").css("display",
$(".data").css("display","
});
}
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: "arial"; font-size: 14px; padding-top: 4px; width: 30%;">Choose <span style="color: red;">*</span></label> <br />
<div style="color: black; float: left; font-family: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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);
?>
<?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: "arial"; font-size: 14px; padding-top: 4px; width: 30%;">Choose <span style="color: red;">*</span></label> <br />
<div style="color: black; float: left; font-family: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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 & Barbuda"){echo "selected";} ?> value="Antigua & Barbuda">Antigua & 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 & McDonald Islands"){echo "selected";} ?> value="Heard & McDonald Islands">Heard & 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 & Principe"){echo "selected";} ?> value="Sao Tome & Principe">Sao Tome & 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 & Miquelon"){echo "selected";} ?> value="St. Pierre & Miquelon">St. Pierre & Miquelon</option>
<option <?php if($q5=="St. Vincent & the Grenadines"){echo "selected";} ?> value="St. Vincent & the Grenadines">St. Vincent & 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 & Jan Mayen Islands"){echo "selected";} ?> value="Svalbard & Jan Mayen Islands">Svalbard & 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 & Tobago"){echo "selected";} ?> value="Trinidad & Tobago">Trinidad & 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 & Caicos Islands"){echo "selected";} ?> value="Turks & Caicos Islands">Turks & 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 & Futuna Islands"){echo "selected";} ?> value="Wallis & Futuna Islands">Wallis & 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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>
<?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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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 & Barbuda"){echo "selected";} ?> value="Antigua & Barbuda">Antigua & 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 & McDonald Islands"){echo "selected";} ?> value="Heard & McDonald Islands">Heard & 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 & Principe"){echo "selected";} ?> value="Sao Tome & Principe">Sao Tome & 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 & Miquelon"){echo "selected";} ?> value="St. Pierre & Miquelon">St. Pierre & Miquelon</option>
<option <?php if($q5=="St. Vincent & the Grenadines"){echo "selected";} ?> value="St. Vincent & the Grenadines">St. Vincent & 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 & Jan Mayen Islands"){echo "selected";} ?> value="Svalbard & Jan Mayen Islands">Svalbard & 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 & Tobago"){echo "selected";} ?> value="Trinidad & Tobago">Trinidad & 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 & Caicos Islands"){echo "selected";} ?> value="Turks & Caicos Islands">Turks & 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 & Futuna Islands"){echo "selected";} ?> value="Wallis & Futuna Islands">Wallis & 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: "arial"; 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: "arial"; 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: "arial"; 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: "arial"; 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>
Subscribe to:
Posts (Atom)