Quote (Riolu)
Видеоуроки от Евгения Попова =)

и научат они VipCat плохому коду.

public function Up ()
{
if ($this->v != null && !empty($this->id) && !empty($this->id2) && $this->id != 0 && $this->id2 != 0)
{
$qq = mysql_query("SELECT v,id FROM `users` WHERE id='$this->id'");
$arr = mysql_fetch_assoc($qq);
$i = $arr[v] - $this->v;

$qq2 = mysql_query("SELECT v,id FROM `users` WHERE id='$this->id2'");
$arr2 = mysql_fetch_assoc($qq2);
$i2 = $arr2[v] + $this->v;

if ($i2 <= 0 || $i <= 0)
{
echo "Предметов мало"; //лог
}
else
{
$q = mysql_query("UPDATE `users` SET v = '$i' WHERE id='$this->id'");
$q2 = mysql_query("UPDATE `users` SET v = '$i2' WHERE id='$this->id2'");
echo "ок $this->v, $this->id, $this->id2, $arr[v], $arr2[v], $i, $i2"; //лог
}
}
else
{
echo "Пустые поля!"; //лог
}
}

function __construct()
{
$this->Get();
$this->Mysql();
$this->Up();
}

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

<?php
class NewBarter
{
var $id; //от
var $id2; //кому
var $v; //вещь
public function Get ()
{
$this->id = isset($_POST['id']) && !empty($_POST['id']) ? $_POST['id'] : null;

$this->id2 = isset($_POST['id2']) && !empty($_POST['id2']) ? $_POST['id2'] : null;

$this->v = isset($_POST['v']) && !empty($_POST['v']) ? $_POST['v'] : null;
}
public function Mysql ()
{
$lnk = mysql_connect('хост', 'юзер', 'пароль')
or die ('Not connected : ' . mysql_error());

// сделать текущей базой данных
mysql_select_db('бд', $lnk) or die ('Can\'t use db : ' . mysql_error());
}
public function Up ()
{
if ($this->v != null && !empty($this->id) && !empty($this->id2) && $this->id != 0 && $this->id2 != 0)
{
$qq = mysql_query("SELECT v,id FROM `users` WHERE id='$this->id'");
$arr = mysql_fetch_assoc($qq);
$i = $arr[v] - $this->v;

$qq2 = mysql_query("SELECT v,id FROM `users` WHERE id='$this->id2'");
$arr2 = mysql_fetch_assoc($qq2);
$i2 = $arr2[v] + $this->v;

if ($i2 <= 0 || $i <= 0)
{
echo "Предметов мало"; //лог
}
else
{
$q = mysql_query("UPDATE `users` SET v = '$i' WHERE id='$this->id'");
$q2 = mysql_query("UPDATE `users` SET v = '$i2' WHERE id='$this->id2'");
echo "ок $this->v, $this->id, $this->id2, $arr[v], $arr2[v], $i, $i2"; //лог
}
}
else
{
echo "Пустые поля!"; //лог
}
}

function __construct()
{
$this->Get();
$this->Mysql();
$this->Up();
}

}

$o = new NewBarter;
?>

html (test1.html):

?
1
2
3
4
5
6

<form action='test1.php' method='POST'>
id <input type='text' name='id'><br />
id2 <input type='text' name='id2'><br />
v <input type='text' name='v'><br />
<input type='submit'>
</form>