Проблем с update на БД

kriss · 1 Август 2010

Имам един проблем с редактиране на поле 'text' в случая става въпрос за поле за текст на песни и имам текст от 2030 символа г/д и не иска да го добавя - прави си всичко но не добавя текста в БД и не дава никаква грешка...

Lam40 · 1 Август 2010

Здравей.
Пусни едно

Код:

<?php
echo mysql_error();
?>

след изпълнението на заявката и виж дали сега ще ти даде грешка ?
Иначе не би трябвало да има проблем щом правиш всичко както трябва :?

embaka · 1 Август 2010

в тоя текст съдържа ли се java script?

t0m3kk · 1 Август 2010

kriss каза:
Имам един проблем с редактиране на поле 'text' в случая става въпрос за поле за текст на песни и имам текст от 2030 символа г/д и не иска да го добавя - прави си всичко но не добавя текста в БД и не дава никаква грешка...

дай кода + няколко записа от базата данни, за да видим къде се спъва скрипта, все пак не сме врачки, за да гадаем

kriss · 1 Август 2010

embaka каза:
в тоя текст съдържа ли се java script?

не, няма js файл, просто една форма и
ето малко код, но не мисля че ви трябва:

Код:

$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen1 = htmlspecialchars($_POST['textnapesen']); 
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen1' WHERE `id` = '$id'"); 
header("Location: ?stranica=music&id=$id"); 
}

а формата:

Код:

<form method="POST" name='dd'><textarea id='ddtxt' style="border:0px;width:400px;height:500px;background:lightgray;text-align:center;" name="textnapesen" class="resizable"></textarea><br>Остават <span id="s"></span> символа<br><input type="submit" name="edittext" value="Добави!"></form>

t0m3kk · 1 Август 2010

я пробвай така...

Код:

$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen = htmlspecialchars($_POST['textnapesen']);
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen' WHERE `id` = '$id'");
header("Location: ?stranica=music&id=$id");
}

kriss · 1 Август 2010

същото, аз казвам че ако текста е кратък(200-300 символа) няма проблем, но ако е 1500-2000, тогава не става.. :?
едит: полето в бд е тип text ако не е ясно

cnoko · 1 Август 2010

влизаш в phpmyadmin -> таблицата
Намираш поле text
И му смени типа да не е varchar а text

kriss · 1 Август 2010

kriss каза:
...полето в бд е тип text

t0m3kk · 1 Август 2010

я сложи пробно това...

$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen = htmlspecialchars($_POST['textnapesen']);
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen' WHERE `id` = '$id'");
echo nl2br($textnapesen);
}

и кажи дали изкарва текста или не

kriss · 1 Август 2010

ммне..

t0m3kk · 1 Август 2010

$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen = htmlspecialchars($_POST['textnapesen']);
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen' WHERE `id` = '$id'") or die(mysql_error());
echo nl2br($textnapesen);
}

a така ?

kriss · 1 Август 2010

да визуализира се но махнах това or die.., че излиза грешка:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd you have to go-oh Away from home Me love. Uh uh uh uh oh ooh Why'd you h' at line 1

едит: ето направо целия код, че така май няма да стане:

<?php
$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen = htmlspecialchars($_POST['textnapesen']);
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen' WHERE `id` = '$id'");
echo nl2br($textnapesen);
}
else{
require "connect.php";
$row = mysql_fetch_array(mysql_query("SELECT `yes`,`no` FROM `votes` WHERE `id` = '$id'"));
$yess = (empty($row['yes'])) ? 0 : $row['yes'];
$noo = (empty($row['no'])) ? 0 : $row['no'];

$timestamp_vote = (is_numeric(TIMESTAMP_VOTE) && TIMESTAMP_VOTE > 0) ? time() - (TIMESTAMP_VOTE * 3600) : 0;

$query = mysql_query("SELECT `vote` FROM `ips` WHERE `id` = '$id' AND `ip` = '".$_SERVER['REMOTE_ADDR']."' AND `timestamp` > '$timestamp_vote' LIMIT 1");
$vote_ip = mysql_fetch_object($query);
$vote_yes = (($vote_ip -> vote) == 1) ? "vote_up" : "vote_up2";
$vote_no = (($vote_ip -> vote) == -1) ? "vote_down" : "vote_down2";

$procent_yes = @round(($yess / ($yess + $noo)) * 100);
$procent_no = @round(($noo / ($yess + $noo)) * 100);
if(!$id){echo"ГРЕШКА";}else{
mysql_query('SET NAMES utf8');
$qqg = mysql_query("SELECT * FROM music WHERE id = '$id'");
while($sd = mysql_fetch_array($qqg)){
$update_views = mysql_query("UPDATE music SET views=views+1 WHERE id='$id'");
$od = $sd['od']; // odobrena ili ne
$text = $sd['text'];
$idu = $sd['id'];
$ime = $sd['pesen'];
$dobavil = $sd['dobavil'];
$avtor = $sd['avtor'];
$views = $sd['views'];
$kat = $sd['kat'];
$link = $sd['link'];
$text2 = nl2br("$text");
if($od == "no"){
echo"Няма такъв урок";
}
elseif($od == "yes"){
echo "Музика -> <b>$kat</b><br><center><h2><b>$ime - $avtor</b></h2></center><br>"; if($dobavil == $user || $level = "2") { echo" <a href='?stranica=edit&edit=music&id=$id'><img src='$site/images/edit.png'>[Редактирай]</a>"; } else{ echo " ";}
if($link == null)
{
echo "Няма теглене и онлайн слушане";
}
else {
echo"<br><object type=\"application/x-shockwave-flash\" data=\"swf/dewplayer.swf\" width=\"200\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"swf/dewplayer.swf\" />
<param name=\"flashvars\" value=\"mp3=$link&showtime=1&volume=100\" />
</object>";
}
if($pic == null)
{
echo "";
}
else {
echo "<img src='$pic' width='150px' height='150px' alt='$ime'>";
}
echo "<br><img src='images/addtofv.png' width='16px'><a href='?stranica=addtofm&idu=$idu'>Добави в любими</a> | <a href='?stranica=delotfm&idu=$idu'><img src='images/rerror.gif' width='16px'>Изтрий от любими</a>";
echo"<br><center>- - - - - - - - - - - - - - - - - - - - -<br><h2>Текст:</h2><font color='black'><br>";if($text2!=null){echo"$text2";}else{echo"Няма текст";if($user != "guest"){echo" | <a href=\"#\" rel=\"toggle[dobavitekst]\">Добави текст</a>
<div id=\"dobavitekst\" style=\"width: 400px;display: none;\"><form method=\"POST\"><textarea style=\"border:0px;width:400px;height:500px;background:lightgray;text-align:center;\" name=\"textnapesen\" class=\"resizable\"></textarea><br>Остават <span id=\"s\"></span> символа<br><input type=\"submit\" name=\"edittext\" value=\"Добави!\"></form></div>";}}echo"<br></font><br>- - - - - - - - - - - - - - - - - - - - -<br><b>";
?>
<div id="txtHint"><?php if (!mysql_num_rows($query)) { ?><a href="javascript:void(null)" onclick="showHint('1','<?php echo $id; ?>')" onmouseover="movepic('pic1','vote_up.png');"
onmouseout="movepic('pic1','vote_up2.png');"><?php } ?><img name="pic1" src="<?php echo $vote_yes; ?>.png" border="0"><?php if (!mysql_num_rows($query)) { ?></a><?php } ?> <b><?php echo$yess; ?> (<?php echo $procent_yes; ?>%)</b>
<?php if (!mysql_num_rows($query)) { ?><a href="javascript:void(null)" onclick="showHint('-1','<?php echo$id; ?>')" onmouseover="movepic('pic2','vote_down.png');"
onmouseout="movepic('pic2','vote_down2.png');"><?php } ?><img name="pic2" src="<?php echo$vote_no; ?>.png" border="0"><?php if (!mysql_num_rows($query)) { ?></a><?php } ?> <b><?php echo$noo; ?> (<?php echo$procent_no; ?>%)</b><br />
Гласували: <b><?php echo ($yess + $noo); ?></b></div>
<?php
$qqri = mysql_query("SELECT * FROM users WHERE `user` = '$dobavil'");
while($redu = mysql_fetch_array($qqri)){$userrid = $redu['id'];}
echo"</center><hr><small>Добавена от : <a href='?stranica=viewprofile&id=$userrid'>$dobavil</a> | Прегледи: $views</small><hr>";
$update_views;
}
?>
<center>

<b><h4>Коментари:</h4></b><br>
<?php
if($user != "guest"){
?>
<a href="#" rel="toggle[komentari]"><b>Добави коментар:</b></a>
<div id="komentari" style="width: 400px; background: #BDF381;display: none;">
<form action="" method="post" name="komentar">
Коментар:<br>
<a href="javascript:emoticon(':biggrin:');"><img src="e/biggrin.gif" border="0" alt=":biggrin:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':clapping:');"><img src="e/clapping.gif" border="0" alt=":clapping:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':dull:');"><img src="e/dull.gif" border="0" alt=":dull:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':hi:');"><img src="e/hi.gif" border="0" alt=":hi:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':inlove:');"><img src="e/inlove.gif" border="0" alt=":inlove:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':itwasntme:');"><img src="e/itwasntme.gif" border="0" alt=":itwasntme:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':lipssealed:');"><img src="e/lipssealed.gif" border="0" alt=":lipssealed:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':lol:');"><img src="e/lol.gif" border="0" alt=":lol:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':mmm:');"><img src="e/mmm.gif" border="0" alt=":mmm:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':nerd:');"><img src="e/nerd.gif" border="0" alt=":nerd:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon('uke:');"><img src="e/puke.gif" border="0" alt="uke:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':smile:');"><img src="e/smile.gif" border="0" alt=":smile:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':wait:');"><img src="e/wait.gif" border="0" alt=":wait:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':whew:');"><img src="e/whew.gif" border="0" alt=":whew:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':wink:');"><img src="e/wink.gif" border="0" alt=":wink:" onClick="add_smile('mytext',this);"></a><br>
<textarea name="text" id="mytext" cols="35" rows="3" class="resizable" /></textarea><br>Остават <span id="simv"></span> символа<br>
<script type="text/javascript">

fieldlimiter.setup({
thefield: document.komentar.text,
maxlength: 200,
statusids: ["simv"],
onkeypress:function(maxlength, curlength){
}
})

</script>
<input name="submit" type="submit" class="btn" id="submit" value="Изпрати">
<input name="button2" type="reset" class="btn" id="button2" value="Изчисти"></form></div>
</center>
<?php
$ids = $_GET['id'];
if(isset($_POST['submit'])){
$date = date("d.m.Y \ч\а\с H:i:s");
$ime = $user;
$comment = htmlspecialchars($_POST['text']);
$sql = mysql_query("INSERT INTO commentsmusic (id, pesen, author, comment, date) VALUES (NULL, '$ids', '$ime', '$comment', '$date')") or die(mysql_error());
echo "<img src='loading.gif' width='25px'><font color='red' size='3pt'><b>Коментарът е записан успешно</b></font> <meta http-equiv=\"refresh\" content=\"0;url=?stranica=uroci&id=$ids\" />";
}
else {
echo "";
}
}
else{echo"Влез или се <a href='?stranica=register'>Регистрирай</a>";}
?>
<br> <hr /><hr />
<?php
$query = mysql_query("SELECT * FROM `commentsmusic` WHERE `pesen`='$ids' ORDER by id DESC") or die(mysql_error());
while($raw = mysql_fetch_array($query))
{
$raw[comment] =preg_replace("/\:biggrin:/s", '<img src="e/biggrin.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:clapping:/s", '<img src="e/clapping.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:dull:/s", '<img src="e/dull.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:hi:/s", '<img src="e/hi.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:inlove:/s", '<img src="e/inlove.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:itwasntme:/s", '<img src="e/itwasntme.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:lipssealed:/s", '<img src="e/lipssealed.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:lol:/s", '<img src="e/lol.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:mmm:/s", '<img src="e/mmm.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:nerd:/s", '<img src="e/nerd.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\uke:/s", '<img src="e/puke.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:smile:/s", '<img src="e/smile.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:wait:/s", '<img src="e/wait.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:whew:/s", '<img src="e/whew.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:wink:/s", '<img src="e/wink.gif">',$raw[comment]);
$comm = $raw[comment];
$cid = $raw['id'];
$comm2 = nl2br("$comm");
$p =mysql_query("SELECT * FROM `users` WHERE `user` = '$raw[author]'");
while($p2 = mysql_fetch_array($p)){
$userpic = $p2['pic'];
$potrid = $p2['id'];
echo "<div class='d3'><table border='0' width='100%' cellspacing='0'><tr><td border='1px' style=\"border: 1px solid gray\">Аватар:</td><td width='140px'>Дата: $raw[date] | Автор: <b><a href='?stranica=viewprofile&id=$potrid'>$raw[author]</a></b>";if($user==$raw['author'] ||$level=="2"){echo" | <a href=\"?stranica=editkom&id=$cid&from=$ids\" onMouseover=\"ddrivetip('<center><font color=green><b>Промени коментара</b></font></center>')\"; onMouseout=\"hideddrivetip()\"><img src='$site/images/edit.png'></a> | <a href=\"?stranica=delkom&id=$cid\" target='blank' onClick='javascript:location.reload(true)' onMouseover=\"ddrivetip('<center><font color=red><b>Изтрий коментара</b></font></center>')\"; onMouseout=\"hideddrivetip()\"><img src='$site/images/dlt.png'></a>";}echo"</td></tr>
<tr><td>";if($userpic != null){list($width, $height, $type, $attr) = getimagesize("$userpic")or die("Няма такава картинка!!!");if($width > "50" || $height > "50") {echo"<div class=\"d1\" style=\"width:50px;\"><img src='$userpic' width='50' height='50'></div>";}else{echo"<div class=\"d1\" style=\"width:50px;\"><img src='$pic'></div>";}}else{echo"<div class=\"d1\" style=\"width:50px;\"><img src=\"images/noavatar.png\" width='50' height='50'></div>";}echo"</td><td width='500px' style=\"width:100%;\" bgcolor='white'><div class=\"d3\" style=\"width:100%\"><font color=black><b>$comm2</b></font></div></td><tr></table></div>";
}
}
}
}
}
?>

t0m3kk · 1 Август 2010

като го махнеш "това" or die(mysql_error()); няма как да видиш къде ти е грешката

П.п. -> Довечера като се прибера ако ми остане време ще погледна целият скрипт, за да видя къде се "чупи"

slideR · 1 Август 2010

<?php
$id = $_GET['id'];
if(isset($_POST['edittext']) && $_POST['textnapesen'] != null){
$textnapesen = addslashes(htmlspecialchars($_POST['textnapesen']));
$updt = mysql_query("UPDATE `music` SET `text` = '$textnapesen' WHERE `id` = '$id'");
echo nl2br($textnapesen);
}
else{
require "connect.php";
$row = mysql_fetch_array(mysql_query("SELECT `yes`,`no` FROM `votes` WHERE `id` = '$id'"));
$yess = (empty($row['yes'])) ? 0 : $row['yes'];
$noo = (empty($row['no'])) ? 0 : $row['no'];

$timestamp_vote = (is_numeric(TIMESTAMP_VOTE) && TIMESTAMP_VOTE > 0) ? time() - (TIMESTAMP_VOTE * 3600) : 0;

$query = mysql_query("SELECT `vote` FROM `ips` WHERE `id` = '$id' AND `ip` = '".$_SERVER['REMOTE_ADDR']."' AND `timestamp` > '$timestamp_vote' LIMIT 1");
$vote_ip = mysql_fetch_object($query);
$vote_yes = (($vote_ip -> vote) == 1) ? "vote_up" : "vote_up2";
$vote_no = (($vote_ip -> vote) == -1) ? "vote_down" : "vote_down2";

$procent_yes = @round(($yess / ($yess + $noo)) * 100);
$procent_no = @round(($noo / ($yess + $noo)) * 100);
if(!$id){echo"ГРЕШКА";}else{
mysql_query('SET NAMES utf8');
$qqg = mysql_query("SELECT * FROM music WHERE id = '$id'");
while($sd = mysql_fetch_array($qqg)){
$update_views = mysql_query("UPDATE music SET views=views+1 WHERE id='$id'");
$od = $sd['od']; // odobrena ili ne
$text = $sd['text'];
$idu = $sd['id'];
$ime = $sd['pesen'];
$dobavil = $sd['dobavil'];
$avtor = $sd['avtor'];
$views = $sd['views'];
$kat = $sd['kat'];
$link = $sd['link'];
$text2 = nl2br("$text");
if($od == "no"){
echo"Няма такъв урок";
}
elseif($od == "yes"){
echo "Музика -> <b>$kat</b><br><center><h2><b>$ime - $avtor</b></h2></center><br>"; if($dobavil == $user || $level = "2") { echo" <a href='?stranica=edit&edit=music&id=$id'><img src='$site/images/edit.png'>[Редактирай]</a>"; } else{ echo " ";}
if($link == null)
{
echo "Няма теглене и онлайн слушане";
}
else {
echo"<br><object type=\"application/x-shockwave-flash\" data=\"swf/dewplayer.swf\" width=\"200\" height=\"20\" id=\"dewplayer\" name=\"dewplayer\">
<param name=\"wmode\" value=\"transparent\" />
<param name=\"movie\" value=\"swf/dewplayer.swf\" />
<param name=\"flashvars\" value=\"mp3=$link&showtime=1&volume=100\" />
</object>";
}
if($pic == null)
{
echo "";
}
else {
echo "<img src='$pic' width='150px' height='150px' alt='$ime'>";
}
echo "<br><img src='images/addtofv.png' width='16px'><a href='?stranica=addtofm&idu=$idu'>Добави в любими</a> | <a href='?stranica=delotfm&idu=$idu'><img src='images/rerror.gif' width='16px'>Изтрий от любими</a>";
echo"<br><center>- - - - - - - - - - - - - - - - - - - - -<br><h2>Текст:</h2><font color='black'><br>";if($text2!=null){echo"$text2";}else{echo"Няма текст";if($user != "guest"){echo" | <a href=\"#\" rel=\"toggle[dobavitekst]\">Добави текст</a>
<div id=\"dobavitekst\" style=\"width: 400px;display: none;\"><form method=\"POST\"><textarea style=\"border:0px;width:400px;height:500px;background:lightgray;text-align:center;\" name=\"textnapesen\" class=\"resizable\"></textarea><br>Остават <span id=\"s\"></span> символа<br><input type=\"submit\" name=\"edittext\" value=\"Добави!\"></form></div>";}}echo"<br></font><br>- - - - - - - - - - - - - - - - - - - - -<br><b>";
?>
<div id="txtHint"><?php if (!mysql_num_rows($query)) { ?><a href="javascript:void(null)" onclick="showHint('1','<?php echo $id; ?>')" onmouseover="movepic('pic1','vote_up.png');"
onmouseout="movepic('pic1','vote_up2.png');"><?php } ?><img name="pic1" src="<?php echo $vote_yes; ?>.png" border="0"><?php if (!mysql_num_rows($query)) { ?></a><?php } ?> <b><?php echo$yess; ?> (<?php echo $procent_yes; ?>%)</b>
<?php if (!mysql_num_rows($query)) { ?><a href="javascript:void(null)" onclick="showHint('-1','<?php echo$id; ?>')" onmouseover="movepic('pic2','vote_down.png');"
onmouseout="movepic('pic2','vote_down2.png');"><?php } ?><img name="pic2" src="<?php echo$vote_no; ?>.png" border="0"><?php if (!mysql_num_rows($query)) { ?></a><?php } ?> <b><?php echo$noo; ?> (<?php echo$procent_no; ?>%)</b><br />
Гласували: <b><?php echo ($yess + $noo); ?></b></div>
<?php
$qqri = mysql_query("SELECT * FROM users WHERE `user` = '$dobavil'");
while($redu = mysql_fetch_array($qqri)){$userrid = $redu['id'];}
echo"</center><hr><small>Добавена от : <a href='?stranica=viewprofile&id=$userrid'>$dobavil</a> | Прегледи: $views</small><hr>";
$update_views;
}
?>
<center>

<b><h4>Коментари:</h4></b><br>
<?php
if($user != "guest"){
?>
<a href="#" rel="toggle[komentari]"><b>Добави коментар:</b></a>
<div id="komentari" style="width: 400px; background: #BDF381;display: none;">
<form action="" method="post" name="komentar">
Коментар:<br>
<a href="javascript:emoticon(':biggrin:');"><img src="e/biggrin.gif" border="0" alt=":biggrin:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':clapping:');"><img src="e/clapping.gif" border="0" alt=":clapping:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':dull:');"><img src="e/dull.gif" border="0" alt=":dull:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':hi:');"><img src="e/hi.gif" border="0" alt=":hi:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':inlove:');"><img src="e/inlove.gif" border="0" alt=":inlove:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':itwasntme:');"><img src="e/itwasntme.gif" border="0" alt=":itwasntme:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':lipssealed:');"><img src="e/lipssealed.gif" border="0" alt=":lipssealed:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon('Laughing');"><img src="e/lol.gif" border="0" alt="Laughing" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':mmm:');"><img src="e/mmm.gif" border="0" alt=":mmm:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':nerd:');"><img src="e/nerd.gif" border="0" alt=":nerd:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon('

uke:');"><img src="e/puke.gif" border="0" alt="

uke:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon('Smile');"><img src="e/smile.gif" border="0" alt="Smile" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':wait:');"><img src="e/wait.gif" border="0" alt=":wait:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon(':whew:');"><img src="e/whew.gif" border="0" alt=":whew:" onClick="add_smile('mytext',this);"></a>
<a href="javascript:emoticon('Wink');"><img src="e/wink.gif" border="0" alt="Wink" onClick="add_smile('mytext',this);"></a><br>
<textarea name="text" id="mytext" cols="35" rows="3" class="resizable" /></textarea><br>Остават <span id="simv"></span> символа<br>
<script type="text/javascript">

fieldlimiter.setup({
thefield: document.komentar.text,
maxlength: 200,
statusids: ["simv"],
onkeypress:function(maxlength, curlength){
}
})

</script>
<input name="submit" type="submit" class="btn" id="submit" value="Изпрати">
<input name="button2" type="reset" class="btn" id="button2" value="Изчисти"></form></div>
</center>
<?php
$ids = $_GET['id'];
if(isset($_POST['submit'])){
$date = date("d.m.Y \ч\а\с H:i:s");
$ime = $user;
$comment = htmlspecialchars($_POST['text']);
$sql = mysql_query("INSERT INTO commentsmusic (id, pesen, author, comment, date) VALUES (NULL, '$ids', '$ime', '$comment', '$date')") or die(mysql_error());
echo "<img src='loading.gif' width='25px'><font color='red' size='3pt'><b>Коментарът е записан успешно</b></font> <meta http-equiv=\"refresh\" content=\"0;url=?stranica=uroci&id=$ids\" />";
}
else {
echo "";
}
}
else{echo"Влез или се <a href='?stranica=register'>Регистрирай</a>";}
?>
<br> <hr /><hr />
<?php
$query = mysql_query("SELECT * FROM `commentsmusic` WHERE `pesen`='$ids' ORDER by id DESC") or die(mysql_error());
while($raw = mysql_fetch_array($query))
{
$raw[comment] =preg_replace("/\:biggrin:/s", '<img src="e/biggrin.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:clapping:/s", '<img src="e/clapping.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:dull:/s", '<img src="e/dull.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:hi:/s", '<img src="e/hi.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:inlove:/s", '<img src="e/inlove.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:itwasntme:/s", '<img src="e/itwasntme.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:lipssealed:/s", '<img src="e/lipssealed.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\Laughing/s", '<img src="e/lol.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:mmm:/s", '<img src="e/mmm.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:nerd:/s", '<img src="e/nerd.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\

uke:/s", '<img src="e/puke.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\Smile/s", '<img src="e/smile.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:wait:/s", '<img src="e/wait.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\:whew:/s", '<img src="e/whew.gif">',$raw[comment]);
$raw[comment] =preg_replace("/\Wink/s", '<img src="e/wink.gif">',$raw[comment]);
$comm = $raw[comment];
$cid = $raw['id'];
$comm2 = nl2br("$comm");
$p =mysql_query("SELECT * FROM `users` WHERE `user` = '$raw[author]'");
while($p2 = mysql_fetch_array($p)){
$userpic = $p2['pic'];
$potrid = $p2['id'];
echo "<div class='d3'><table border='0' width='100%' cellspacing='0'><tr><td border='1px' style=\"border: 1px solid gray\">Аватар:</td><td width='140px'>Дата: $raw[date] | Автор: <b><a href='?stranica=viewprofile&id=$potrid'>$raw[author]</a></b>";if($user==$raw['author'] ||$level=="2"){echo" | <a href=\"?stranica=editkom&id=$cid&from=$ids\" onMouseover=\"ddrivetip('<center><font color=green><b>Промени коментара</b></font></center>')\"; onMouseout=\"hideddrivetip()\"><img src='$site/images/edit.png'></a> | <a href=\"?stranica=delkom&id=$cid\" target='blank' onClick='javascript:location.reload(true)' onMouseover=\"ddrivetip('<center><font color=red><b>Изтрий коментара</b></font></center>')\"; onMouseout=\"hideddrivetip()\"><img src='$site/images/dlt.png'></a>";}echo"</td></tr>
<tr><td>";if($userpic != null){list($width, $height, $type, $attr) = getimagesize("$userpic")or die("Няма такава картинка!!!");if($width > "50" || $height > "50") {echo"<div class=\"d1\" style=\"width:50px;\"><img src='$userpic' width='50' height='50'></div>";}else{echo"<div class=\"d1\" style=\"width:50px;\"><img src='$pic'></div>";}}else{echo"<div class=\"d1\" style=\"width:50px;\"><img src=\"images/noavatar.png\" width='50' height='50'></div>";}echo"</td><td width='500px' style=\"width:100%;\" bgcolor='white'><div class=\"d3\" style=\"width:100%\"><font color=black><b>$comm2</b></font></div></td><tr></table></div>";
}
}
}
}
}
?>

kriss · 1 Август 2010

slideR, кода работи, мерси много и +1 :?:

Проблем с update на БД

kriss

Registered

Lam40

Registered

embaka

Registered

t0m3kk

Registered

kriss

Registered

t0m3kk

Registered

kriss

Registered

cnoko

Registered

kriss

Registered

t0m3kk

Registered

kriss

Registered

t0m3kk

Registered

kriss

Registered

t0m3kk

Registered

slideR

Registered

kriss

Registered