File: /home/dh_ncpy7d/beitarbeersheva.com/CampaignView/index.php
<?php
$servername = "mysql.beitarbeersheva.com";
$username = "beitarbeershevac";
$password = "-j93pzZ6";
$dbname = "beitarbeersheva_com";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Campaign View</title>
<!-- Bootstrap Core CSS -->
<link href="css/bootstrap.min.css" rel="stylesheet">
<!-- Custom CSS -->
<link href="css/small-business.css" rel="stylesheet">
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
<!-- Page styles -->
<link type='text/css' href='css/demo.css' rel='stylesheet' media='screen' />
<!-- Contact Form CSS files -->
<link type='text/css' href='css/basic.css' rel='stylesheet' media='screen' />
<!-- IE6 "fix" for the close png image -->
<!--[if lt IE 7]>
<link type='text/css' href='css/basic_ie.css' rel='stylesheet' media='screen' />
<![endif]-->
<!-- JS files are loaded at the bottom of the page -->
</head>
<body dir="rtl">
<form action="index.php" method="post">
<!-- Navigation -->
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<div class="container">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
</ul>
</div>
<!-- /.navbar-collapse -->
</div>
<!-- /.container -->
</nav>
<!-- Page Content -->
<div class="container">
<!-- Heading Row -->
<div class="row">
<!-- /.col-md-8 -->
<div>
<form action="index.php" method="post">
<h1>
<select name="tableName">
<?php
//Table List
mysql_connect($servername, $username, $password);
$result = mysql_list_tables($dbname);
$num_rows = mysql_num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
if(mysql_tablename($result, $i) == $_POST['tableName'])
echo "<option value='", mysql_tablename($result, $i), "' selected>", mysql_tablename($result, $i), "</option>";
else
echo "<option value='", mysql_tablename($result, $i), "'>", mysql_tablename($result, $i), "</option>";
}
mysql_free_result($result);
/*
if(isset($_POST['tableName']))
{
echo "<input type='hidden' name='tableName' id='tableName' value='" . $_POST['tableName'] . "'>";
}
*/
?>
</select>
<input class="basic btn btn-primary btn-lg" id="table" type="Submit" name="table" value="בחירה" onclick="hide()" style="margin: -7px 30px 0px 0px;"/>
<!--<input class="basic btn btn-primary btn-lg" id="export" type="Submit" name="export" value="יצוא לאקסל" onclick="hide()" style="margin: -7px 30px 0px 0px;"/>-->
<?php
if(isset($_POST['tableName']))
{
$tableName = $_POST['tableName'];
?>
<h1><a href="http://www.beitarbeersheva.com/campaign/?src=Link" target="_blank">לינק לדף נחיתה</a></h1>
<?php
}
?>
<br/>
<br/>
</h1>
</form>
<br/>
<br/>
<div class="row">
<div class="col-lg-12">
<div class="well text-center">
<h4>
<?php
if(isset($_POST['tableName']))
{
if(isset($_POST['export']))
{
$servername = "mysql.beitarbeersheva.com";
$username = "beitarbeershevac";
$password = "-j93pzZ6";
$dbname = "beitarbeersheva_com";
/* vars for export */
// database record to be exported
$db_record = $_POST['tableName'];
// optional where query
$where = ""; // 'WHERE 1 ORDER BY 1';
// filename for export
$csv_filename = 'db_export_'.$db_record.'_'.date('Y-m-d').'.csv';
// Database connecten voor alle services
mysql_connect($servername, $username, $password)
or die('Could not connect: ' . mysql_error());
mysql_select_db($dbname)
or die ('Could not select database ' . mysql_error());
// create empty variable to be filled with export data
$csv_export = '';
// query to get data from database
$query = mysql_query("SELECT * FROM ".$db_record." ".$where);
$field = mysql_num_fields($query);
// create line with field names
for($i = 0; $i < $field; $i++) {
$csv_export.= mysql_field_name($query,$i).';';
}
// newline (seems to work both on Linux & Windows servers)
$csv_export.= '
';
// loop through database query and fill export variable
while($row = mysql_fetch_array($query)) {
// create line with field values
for($i = 0; $i < $field; $i++) {
$csv_export.= '"'.$row[mysql_field_name($query,$i)].'";';
}
$csv_export.= '
';
}
// Export the data and prompt a csv file for download
header("Content-type: text/x-csv");
header("Content-Disposition: attachment; filename=".$csv_filename."");
echo($csv_export);
}
$tableName = $_POST['tableName'];
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
mysqli_set_charset($conn,"utf8");
$sql = "SELECT * FROM " . $tableName . " ORDER BY `leedIndex` DESC";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
echo "<table border='1' style='width:100%'><tr><td>אינדקס</td><td>IP</td><td>תאריך ושעה</td><td>שם</td><td>נייד</td><td>אימייל</td><td>מאשר דיוור</td><td>גלישה מהנייד</td><td>מקור הליד</td><td>מקור הליד מהשרת</td><td>נתונים נוספים</td></tr>";
while($row = $result->fetch_assoc())
{
$allowMailingImage = "images/redX.png";
if($row["allowMailing"] == "כן")
{
$allowMailingImage = "images/greenV.png";
}
$isMobileImage = "images/redX.png";
if($row["isMobile"] == "כן")
{
$isMobileImage = "images/greenV.png";
}
echo "<tr><td>" . $row["leedIndex"] . "</td><td>" . $row["ip"] . "</td><td>" . $row["dateTime"] . "</td><td>" . $row["leadName"] . "</td><td>" . $row["leadPhone"] . "</td><td>" . $row["leadEmail"] . "</td><td><img src='" . $allowMailingImage . "' height='42' width='42'></td><td><img src='" . $isMobileImage . "' height='42' width='42'></td><td>" . $row["visitorFrom"] . "</td><td>" . $row["ServerReference"] . "</td><td>" . $row["moreDetails"] . "</td></tr>";
}
echo "</table>";
}
else
{
$message = "אין משתמשים";
echo "<script type='text/javascript'> alert('$message'); </script>";
}
$conn->close();
}
?>
</h4>
</div>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
</div>
<!-- /.col-md-8 -->
</div>
<!-- /.row -->
<!-- Footer -->
<footer>
<div class="row">
<div class="col-lg-12">
<center><a href="http://bmedia.co.il/" target="_blank"><div style="background-size: 41px 10px; margin:auto; position:relative; width:41px; height:10px; background-image:url('images/blackBmedia.png'); background-repeat: no-repeat;"></div></a></center>
</div>
</div>
</footer>
</div>
<!-- /.container -->
<!-- jQuery
<script src="js/jquery.js"></script>
<!-- Bootstrap Core JavaScript
<script src="js/bootstrap.min.js"></script>
<!-- Load jQuery, SimpleModal and Basic JS files
<script type='text/javascript' src='js/jqueryx.js'></script>
<script type='text/javascript' src='js/jquery.simplemodal.js'></script>
<script type='text/javascript' src='js/basic.js'></script>
-->
</form>
</body>
</html>