Обучение/Помощь новичкам | Картинка в базе
shtorm
Как в базе поставить картинку?например как вот поставить стоб она отображалась,скрин прилогаю.
------
69089_Screenshot.png (7.7 Kb)
Скачиваний: 59
Изображение
------
69089_Screenshot.png (7.7 Kb) Скачиваний: 59
RustamSadikov 
TheYaMus , Их можно ставить, но как?
Тоесть надо менять структуру таблицы?
Смотри вообщем в чем проблема есть магазин вещей но там в нем отображаеться только названия комплектов,а мне надо чтоб с названием отоброжались картинка комлекта,но в самом коде нету их,скрин и код кидаю,вод код
<?php
session_start();
include ('private/mysql.php');
include ('tmp/head.php');
switch($sd){
default:
echo "<center><b><font color=yellow> Покупка Снарежения</font></b><br></center><ul class='list_page'><div class='linem'></div>";
echo "<center><img src='https://avatars.mds.yandex.net/get-pdb/909209/1b0bfe25-7297-4e8a-aac0-92c74408d8e3/s1200?webp=false' width='250'></center>";
echo "Комплекты(Магазин) | <a href='/auction'>Аукцион</a><hr>";
$q = mysql_query("SELECT * FROM `complekt`");
echo "<ul class='list_page'><div class='linem'></div>";
While($w = mysql_fetch_assoc($q)){
echo "<li><a style='color:$w[sort]' href='?sd=view&id=$w[id]'>$w[name] <span style='float:right'>$w[level] ур.</span></a></li>";
}
echo "</ul><div class='linem2'></div>";
break;
case 'view':
$k = mysql_query("SELECT * FROM `complekt` WHERE `id`='$id' ORDER BY `level` DESC");
$ke = mysql_num_rows($k);
if($ke=='0'){
header('Location: complekt.php');
exit;
}
$n = mysql_fetch_assoc($k);
echo "<center><font color=$n[sort]>$n[name] $n[level] ур.</font></center><hr>";
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='weapon'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Урон: $w[min_u] - $w[max_u] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='weapon' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
$au = $w['min_u']+$w['max_u'];
$au1 = $sw['min_u']+$sw['max_u'];
if($au<$au1){
$ck = $au1-$au;
echo "(<font color=red>-$ck</font>)";
}
if($au1<$au){
$ck = $au-$au1;
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='shield'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='shield' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='helmet'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='helmet' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='amulet'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='amulet' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='ple4i'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[
------
69090_Screenshot2.png (3.1 Kb)
Скачиваний: 62
<?php
session_start();
include ('private/mysql.php');
include ('tmp/head.php');
switch($sd){
default:
echo "<center><b><font color=yellow> Покупка Снарежения</font></b><br></center><ul class='list_page'><div class='linem'></div>";
echo "<center><img src='https://avatars.mds.yandex.net/get-pdb/909209/1b0bfe25-7297-4e8a-aac0-92c74408d8e3/s1200?webp=false' width='250'></center>";
echo "Комплекты(Магазин) | <a href='/auction'>Аукцион</a><hr>";
$q = mysql_query("SELECT * FROM `complekt`");
echo "<ul class='list_page'><div class='linem'></div>";
While($w = mysql_fetch_assoc($q)){
echo "<li><a style='color:$w[sort]' href='?sd=view&id=$w[id]'>$w[name] <span style='float:right'>$w[level] ур.</span></a></li>";
}
echo "</ul><div class='linem2'></div>";
break;
case 'view':
$k = mysql_query("SELECT * FROM `complekt` WHERE `id`='$id' ORDER BY `level` DESC");
$ke = mysql_num_rows($k);
if($ke=='0'){
header('Location: complekt.php');
exit;
}
$n = mysql_fetch_assoc($k);
echo "<center><font color=$n[sort]>$n[name] $n[level] ур.</font></center><hr>";
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='weapon'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Урон: $w[min_u] - $w[max_u] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='weapon' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
$au = $w['min_u']+$w['max_u'];
$au1 = $sw['min_u']+$sw['max_u'];
if($au<$au1){
$ck = $au1-$au;
echo "(<font color=red>-$ck</font>)";
}
if($au1<$au){
$ck = $au-$au1;
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='shield'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='shield' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='helmet'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='helmet' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='amulet'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[img]' width='50'></span><small> $w[name] $w[level] ур.<br> Живучесть: $w[hp] ";
$s = mysql_query("SELECT * FROM `item` WHERE `user`='$uid' and `tip`='amulet' and `status`='odet'");
$se = mysql_num_rows($s);
if($se>='1'){
$sw = mysql_fetch_assoc($s);
if($w['hp']<$sw['hp']){
$ck = $sw['hp']-$w['hp'];
echo "(<font color=red>-$ck</font>)";
}
if($sw['hp']<$w['hp']){
$ck = $w['hp']-$sw['hp'];
echo "(<font color=lightgreen>+$ck</font>)";
}
}
echo "<br> [<a href='complekt.php?sd=buy&c=$id&id=$w[id]'>Купить <small><img src='img/silver.png'> $w[silver]</small></a>]</small><hr>";
}
$q = mysql_query("SELECT * FROM `shop` WHERE `complekt`='$id' and `tip`='ple4i'");
While($w = mysql_fetch_assoc($q)){
echo "<span style='float:left'><img src='/img/shmot/$w[
Изображение
------
69090_Screenshot2.png (3.1 Kb) Скачиваний: 62