Ejemplos de código de DataBaseMysql en PHP

Ejemplo n.º 1

0

Mostrar archivo

Archivo: db.class.php Proyecto: serg-smirnoff/autobroker

 function &SelectSet($sqlString, $idTable = '')
 {
     $resourseId = DataBaseMysql::Query($sqlString);
     $row = array();
     while ($rowOne =& mysql_fetch_assoc($resourseId)) {
         if ($idTable) {
             $row[$rowOne[$idTable]] = $rowOne;
         } else {
             $row[] = $rowOne;
         }
     }
     @mysql_free_result($resourseId);
     return $row;
 }

Ejemplo n.º 2

0

Mostrar archivo

Archivo: project_edit.php Proyecto: serg-smirnoff/stats

?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Статистика позиций сайтов. Проекты</title>
	<link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
	<?php 
if (isset($_GET["project_id"])) {
    $project_id = $_GET["project_id"];
}
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$project = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1 AND id = {$project_id}");
$project = $project["0"];
$keywords = $dbID->SelectSet("SELECT * from keywords WHERE is_active = 1 AND project_id = {$project_id}");
if (sizeof($keywords) > 0) {
    $keywords = $keywords["0"];
}
?>
	<?php 
$current_reg_id = $project['region'];
?>
	<script type="text/javascript">
	jQuery(document).ready(function() {
		jQuery('#<?php 
echo $current_reg_id;

Ejemplo n.º 3

0

Mostrar archivo

Archivo: project_view.php Proyecto: serg-smirnoff/stats

	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
	<script type="text/javascript" src="http://stat.onlysites.ru/assets/js/jquery.tablesorter.js"></script>
	<script type="text/javascript" src="http://stat.onlysites.ru/assets/js/jquery.colorbox-min.js"></script>
	<script type="text/javascript">
	$(document).ready(function(){
        $("#maintable").tablesorter();
		$(".inline").colorbox();
	});
	</script>
</head>
<body>
<?php 
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$projects = $dbID->SelectSet("SELECT * from projects WHERE id = '{$_GET['project_id']}' AND is_active = '1'");
$project = $projects[0]["name"];
$region = $projects[0]["region"];
$keywords = $dbID->SelectSet("SELECT * from keywords WHERE project_id = '{$_GET['project_id']}' AND is_active = '1'");
$keywords = $keywords[0];
$current_date = date('Y-m-d');
//current_date
$yesterday_date = date("Y-m-d", time() - 60 * 60 * 24);
//yesterday_date
$positions = $dbID->SelectSet("SELECT * from positions WHERE project_id = '{$_GET['project_id']}' AND is_active = '1' AND date = '{$current_date}'");
$positions = $positions[0];
$positions_2 = $dbID->SelectSet("SELECT * from positions WHERE project_id = '{$_GET['project_id']}' AND is_active = '1' AND date = '{$yesterday_date}'");
$positions_2 = $positions_2[0];
$keys = $keywords["phrase"];

Ejemplo n.º 4

0

Mostrar archivo

Archivo: projects_edit_save.php Proyecto: serg-smirnoff/stats

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Статистика позиций сайтов. Проекты</title>
	<link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
</head>
<body style="padding: 12px;">
<?php 
if (isset($_POST)) {
    $data = $_POST;
}
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$project_id = $dbID->SelectSet("SELECT project_id from keywords WHERE is_active = 1 AND project_id = '{$data['project_id']}'");
if (sizeof($project_id) > 0) {
    $dbID->Query("UPDATE projects SET name = '{$data['name']}' WHERE is_active = '1' AND id = '{$data['project_id']}'");
    $dbID->Query("UPDATE projects SET url = '{$data['url']}' WHERE is_active = '1' AND id = '{$data['project_id']}'");
    $dbID->Query("UPDATE projects SET region = '{$data['region']}' WHERE is_active = '1' AND id = '{$data['project_id']}'");
    $str = $data["keys"];
    $keys = str_replace("\r\n", ";", $str);
    $dbID->Query("UPDATE keywords SET phrase = '{$keys}' WHERE is_active = '1' AND project_id = '{$data['project_id']}'");
} else {
    $str = $data["keys"];
    $keys = str_replace("\r\n", ";", $str);
    $dbID->Query("INSERT INTO keywords VALUES ('','{$data['project_id']}', '2013-07-01', '{$keys}', '1')");
}
$dbID->Destroy();

Ejemplo n.º 5

0

Mostrar archivo

Archivo: index.php Proyecto: serg-smirnoff/stats

require_once 'lib/yandex.xml/Yandex.php';
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Статистика позиций сайтов. Проекты</title>
	<link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
</head>
<body>
<?php 
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$res = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1");
/* include external php scripts */
include_once "project_get_tic.php";
include_once "project_get_pr.php";
include_once "project_pages_in_google.php";
include_once "project_pages_in_yandex.php";
echo "<table width='100%' id='maintable'>";
echo "<tr>\r\n\t\t\t<th>id</th>\r\n\t\t\t<th>Проект</th>\r\n\t\t\t<th>Запросы (шт)</th>\r\n\t\t\t<th>Рост ↑ (шт)</th>\r\n\t\t\t<th>Падение ↓ (шт)</th>\r\n\t\t\t<th>ТИЦ</th>\r\n\t\t\t<th>PR</th>\r\n\t\t\t<th>индекс Yandex</th>\r\n\t\t\t<th>индекс Google (основной)</th>\r\n\t\t\t<th>индекс Google (supplemental)</th>\r\n\t\t\t<th>Статистика</th>\t\r\n\t\t\t<th>Редактировать</th>\r\n\t\t</tr>";
foreach ($res as $key => $value) {
    $keys = $dbID->SelectValue("SELECT phrase from keywords WHERE is_active = 1 AND project_id = {$value['id']}");
    $keys = explode(";", $keys);
    $num_keys = sizeof($keys);
    $num_keys_up = 0;
    $num_keys_down = 0;

Ejemplo n.º 6

0

Mostrar archivo

Archivo: project_create_save.php Proyecto: serg-smirnoff/stats

<?php 
require_once 'config.php';
require_once 'lib/db/db.class.php';
require_once 'lib/yandex.xml/Yandex.php';
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Статистика позиций сайтов. Проекты</title>
	<link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
</head>
<body style="padding: 12px;">
<?php 
if (isset($_POST)) {
    $data = $_POST;
}
$current_date = date('Y-m-d');
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$dbID->Query("INSERT INTO projects VALUES ('','{$data['name']}','{$data['url']}','{$current_date}','','','','',{$data['region']},'1')");
$dbID->Destroy();
header('Location: http://stat.onlysites.ru/index.php');
?>
</body>
</html>

Ejemplo n.º 7

0

Mostrar archivo

Archivo: project_create.php Proyecto: serg-smirnoff/stats

?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Статистика позиций сайтов. Создание нового проекта.</title>
	<link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" />
	<link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" />
	<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
</head>
<body>
<div class="header_line"><a href="index.php">К списку проектов</a></div>
<?php 
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
?>
<div style="padding: 12px;">
<form name="project_create" method="post" action="project_create_save.php">
<table width="100%">
<tr>
<td valign="top" width="50%" align="left">
<h1>Свойства проекта</h1>
<br />
<table class="table_edit">
	<tr><td>Имя проекта:</td><td><input type="text" name="name" value="" /></td></tr>
	<tr><td>URL проекта:</td><td><input type="text" name="url" value="" /></td></tr>
	<tr><td>Регион проекта:</td><td><?php 
require_once 'regions.php';
?>

Ejemplo n.º 8

0

Mostrar archivo

Archivo: check_positions.php Proyecto: serg-smirnoff/stats

<?php

require_once 'config.php';
require_once 'lib/db/db.class.php';
require_once 'lib/yandex.xml/Yandex.php';
/*
	Проекты из таблицы projects пробиваем на ключи из таблицы keywords, результат пишем в positions с учетом даты пробивки.
*/
header("Content-Type: text/html;charset=utf-8");
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$projects = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1");
$i = 0;
foreach ($projects as $key => $value) {
    $keys = $dbID->SelectSet("SELECT * from keywords WHERE project_id = '{$value['id']}' AND is_active = 1");
    $keys = $keys["0"];
    $projects[$i]["keys"] = $keys;
    $i++;
}
foreach ($projects as $key => $project) {
    $host = $project["url"];
    $host_esc = htmlspecialchars($host);
    $host = preg_replace("[^http://|www\\.]", '', $host);
    $phrase = $project["keys"]["phrase"];
    $phrases = explode(";", $phrase);
    $reg = $region = $project["region"];
    $reg_esc = htmlspecialchars($reg);
    $page = 0;
    $pages = 3;
    $error = false;

Ejemplos de DataBaseMysql en PHP