Празно поле

cold_zero · 5 Март 2007

Код:

mysql_connect($dbhost, $dbusername, $dbpass);
mysql_select_db($dbname) or die( "Unable to select database");


$query2 = "update clips set viewed=viewed+1 where code='$play' and status='1'";
$result2 = mysql_query($query2) or die('Error, query failed');

$chars="SET CHARACTER SET cp1251";mysql_query($chars);
$query = " SELECT* FROM clips where code='$play' and status='1' ORDER BY id DESC ";
$result = mysql_query($query) or die('Error, query failed');

while($row = mysql_fetch_array($result))
{

$user = $row[uploaded];
$ip = $row[ip];
$file = $row[cod];
$fileid = $row[id];
$filename = $row[name];
$description = $row[description];
$description = str_replace(":)",'[img]/images/smilies/icon_smile.gif[/img]',$description);
$description = str_replace(":(",'[img]/images/smilies/icon_sad.gif[/img]',$description);
$description = str_replace(":D",'[img]/images/smilies/icon_biggrin.gif[/img]',$description);
$description = str_replace(":S",'[img]/images/smilies/icon_confused.gif[/img]',$description);
$description = str_replace("8)",'[img]/images/smilies/icon_cool.gif[/img]',$description);
$description = str_replace(";(",'[img]/images/smilies/icon_cry.gif[/img]',$description);
$description = str_replace("o_O",'[img]/images/smilies/icon_eek.gif[/img]',$description);
$description = str_replace(" >:D",'[img]/images/smilies/icon_evil.gif[/img]',$description);
$description = str_replace(":exclaim:",'[img]/images/smilies/icon_exclaim.gif[/img]',$description);
$description = str_replace(":idea:",'[img]/images/smilies/icon_idea.gif[/img]',$description);
$description = str_replace(":lol:",'[img]/images/smilies/icon_lol.gif[/img]',$description);
$description = str_replace(":x",'[img]/images/smilies/icon_mad.gif[/img]',$description);
$description = str_replace(":question:",'[img]/images/smilies/icon_question.gif[/img]',$description);
$description = str_replace(":P",'[img]/images/smilies/icon_razz.gif[/img]',$description);
$description = str_replace(":oops:",'[img]/images/smilies/icon_redface.gif[/img]',$description);
$description = str_replace(":roll:",'[img]/images/smilies/icon_rolleyes.gif[/img]',$description);
$description = str_replace(";)",'[img]/images/smilies/icon_wink.gif[/img]',$description);
$description = str_replace(":surprised:",'[img]/images/smilies/icon_surprised.gif[/img]',$description);
$description = str_replace(":twisted:",'[img]/images/smilies/icon_twisted.gif[/img]',$description);
$description = str_replace(":kiss:",'[img]/images/smilies/kiss3.gif[/img]',$description);
$description = str_replace(":taunt:",'[img]/images/smilies/taunt.gif[/img]',$description);
$description = str_replace(":}",'[img]/images/smilies/lol.gif[/img]',$description);
$description = str_replace(":mad:",'[img]/images/smilies/realmad.gif[/img]',$description);
$description = str_replace(":yee:",'[img]/images/smilies/yee.gif[/img]',$description);
$description = str_replace(":arrogance:",'[img]/images/smilies/arrogance.gif[/img]',$description);
$description = str_replace(":bang:",'[img]/images/smilies/bang.gif[/img]',$description);
$description = str_replace(":boxed:",'[img]/images/smilies/boxed.gif[/img]',$description);
$description = str_replace(":blaa:",'[img]/images/smilies/blaa.gif[/img]',$description);
$description = str_replace(":evil:",'[img]/images/smilies/evil.gif[/img]',$description);

$description1 = htmlspecialchars("$description", ENT_QUOTES);

//////////////////////////////////////////////////////////////////////
$post_no_html = $description;

$bbcode_regex = array(0 => '/\[b\](.+?)\[\/b\]/s',
1 => '/\[i\](.+?)\[\/i\]/s',
2 => '/\[u\](.+?)\[\/u\]/s',
3 => '/\[quote\](.+?)\[\/quote\]/s',
4 => '/\[quote\=(.+?)](.+?)\[\/quote\]/s',
5 => '/\[url\](.+?)\[\/url\]/s',
6 => '/\[url\=(.+?)\](.+?)\[\/url\]/s',
7 => '/\[img\](.+?)\[\/img\]/s',
8 => '/\[color\=(.+?)\](.+?)\[\/color\]/s',
9 => '/\[size\=(.+?)\](.+?)\[\/size\]/s',
10 => '/\[code\](.+?)\[\/code\]/s',
11 => '/\[font\=(.+?)\](.+?)\[\/font\]/s',
12 => '/\[center\](.+?)\[\/center\]/s',
13 => '/\[left\](.+?)\[\/left\]/s',
14 => '/\[right\](.+?)\[\/right\]/s');


$bbcode_replace = array( 0 => '<b>$1</b>',
1 => '<i>$1</i>',
2 => '<u>$1</u>',
3 => '<table class="quote" width="100%" border="0"><tr><td><font face="Tahoma" style="font-size: 8pt"><b>Цитат:</b></font></td></tr><tr><td bgcolor="#DFEAB5" width="100%" style="border:solid 1px black"><font face="Tahoma" style="font-size: 8pt">$1</font></td></tr></table>',
4 => '<table class="quote" width="100%" border="0"><tr><td><font face="Tahoma" style="font-size: 8pt"><b>$1 каза:</b></font></td></tr><tr><td bgcolor="#DFEAB5" width="100%" style="border:solid 1px black"><font face="Tahoma" style="font-size: 8pt">$2</font></td></tr></table>',
5 => '<a target="_blank" href="$1">$1</a>',
6 => '<a target="_blank" href="$1">$2</a>',
7 => '<img src="$1" alt="" title=""/>',
8 => '<span style="color:$1">$2</span>',
9 => '<span style="font-size:$1">$2</span>',
10 => '<table width="95%" border="0" align="center"><tr><td class="blue"><font size="2">Код:</font></td></tr><tr><td class="code" width="100%">$1</td></tr></table>',
11 => '<font face="$1">$2</font>',
12 => '<center>$1</center>',
13 => '<p align="left">$1</p>',
14 => '<p align="right">$1</p>');



ksort($bbcode_regex);
ksort($bbcode_replace);

//preg_replace to convert all remaining bbCode tags
$post_bbcode_treated = preg_replace($bbcode_regex, $bbcode_replace, $description1);
$description = nl2br($post_bbcode_treated); 

$view = $row[viewed];
$date = $row[date];
$array1=array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
$array2=array("Понеделник", "Вторник", "Сряда", "Четвъртък", "Петък", "Събота", "Неделя");
$array3=array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$array4=array("Януари", "Февруари", "Март", "Април", "Май", "Юни", "Юли", "Август", "Септември", "Октомври", "Ноември", "Декември");

$date1=str_replace($array1,$array2,$date);
$date2=str_replace($array3,$array4,$date1); 
$category = $row[category];
$array1=array("auto", "animation", "doc", "animals", "games", "music", "news", "politics", "fun", "sport", "technology", "tv", "other");
$array2=array("Авто-Мото", "Анимации", "Документални", "Животни", "Игри", "Музикални", "Новини", "Политика", "Смешни", "Спорт", "Технологии", "ТВ Шоу", "Други");

$category1=str_replace($array1,$array2,$category);

echo 'тук следва един дълъг код....  <tr>
    <td bgcolor="#F4F4F4" width="22%">
    <p align="center"><font color="#838383" face="Trebuchet MS" style="font-size: 9pt">Описание</font></td>
    <td bgcolor="#F4F4F4" width="78%"> <font face="Trebuchet MS" style="font-size: 9pt"><span lang="bg">'.$description.'</font></td>
  </tr> продължение на дългия код';
}

our · 5 Март 2007

Много ти е объркана заявката ... на пръв поглед май е така. Я сложи edno

Код:

if(empty(description)) 
{
$description = "Няма описание";
}

Я сложи това след

Код:

$user = $row[uploaded];
$ip = $row[ip];
$file = $row[cod];
$fileid = $row[id];
$filename = $row[name];
$description = $row[description];

cold_zero · 5 Март 2007

$user = $row[uploaded];
$ip = $row[ip];
$file = $row

Код:

;
$fileid = $row[id];
$filename = $row[name];
$description = $row[description];
if(empty(description))
{
$description = "Няма описание";
}

Parse error: syntax error, unexpected ')', expecting T_PAAMAYIM_NEKUDOTAYIM in d:\webdesign\site\www\clips\view.php on line 57

 :roll:

sizif · 5 Март 2007

if(empty(description))

Липсва стринга за променлива пред description! Добави го! Огледай и за други пропуски

Успех!

bafitu · 6 Март 2007

виж ти добре си го направил това за базата , но докато не направиш нова заявка т.е. да вкараш нови данни това дето си го показал като линк няма да се промени..

cold_zero · 6 Март 2007

Направих го при самия запис в базата данни още при взимането на стойността на description

Код:

$description=$_POST['text'];

да се проверява дали е попълнен input-а и ако не е въвежда в базата данни Няма описание

Празно поле

cold_zero

Registered

our

Registered

cold_zero

Registered

sizif

Registered

bafitu

Registered

cold_zero

Registered