Преобразуване на дата

vasilev5

Registered
Как да превърна датата 2013-08-01, която излиза от БД в 01.08.2013. кодът, който ползвам е:
<?php
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$query="SELECT news,date FROM news ORDER BY id DESC LIMIT 3";
$result=mysql_query($query, $db_conn);
while ($row=mysql_fetch_row($result)) {
$news = $row['0'];
$date = $row['1'];
echo "<center>$date : $news</center>";
}
?>
 
не въвеждам дата, тя автоматично се генерира в хоста, а кода, с който качвам новините е
<?php
session_start();
if($_SESSION['username'])
{
?>
<script language="javascript" type="text/javascript">

</script>
<?php
$sesusername = $_SESSION['username'];
$modadm = "SELECT * FROM users WHERE username='$sesusername'";
$modadm=mysql_query($modadm);
$modadm=mysql_fetch_array($modadm);
$level=$modadm['level'];
if($modadm)
{
if($level==9){
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$sesusername = $_SESSION['username'];
echo("<table border='0' width='100%' cellspacing='1' align='center'>");
echo ("<form method='POST' name='comment'>");
echo '<td align="center">';
?>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">BOLD</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><u>Underline</u></font></a>
<a href="javascript:areatext('[color=]Text[/color]');"><font face="verdana" color="#666" size="2">Color</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">Size</font></a>
<a href="javascript:areatext('
');"><font face="verdana" color="#666" size="2">Img</font></a>
<a href="javascript:areatext('Name');"><font face="#666" color="#666" size="2">Link</font></a>
</td>
</tr>
<tr>
<td align="center">
<a href="javascript:areatext(':)');"><img src="images/smilies/icon_smile.gif" alt="Smile" border="0"></a>
<a href="javascript:areatext(':(');"><img src="images/smilies/icon_sad.gif" alt="Sad" border="0"></a>
<a href="javascript:areatext(':arrow:');"><img src="images/smilies/icon_arrow.gif" alt="Arrow" border="0"></a>
<a href="javascript:areatext(':D');"><img src="images/smilies/icon_biggrin.gif" alt="Biggrin" border="0"></a>
<a href="javascript:areatext(':?');"><img src="images/smilies/icon_confused.gif" alt="Confused" border="0"></a>
<a href="javascript:areatext('8)');"><img src="images/smilies/icon_cool.gif" alt="Cool" border="0"></a>
<a href="javascript:areatext(';(');"><img src="images/smilies/icon_cry.gif" alt="Cry" border="0"></a>
<a href="javascript:areatext('Shocked');"><img src="images/smilies/icon_eek.gif" alt="Eek" border="0"></a>
<a href="javascript:areatext(':evil:');"><img src="images/smilies/icon_evil.gif" alt="Evil" border="0"></a>
<a href="javascript:areatext('Exclamation');"><img src="images/smilies/icon_exclaim.gif" alt="Exclaim" border="0"></a>
<a href="javascript:areatext('Idea');"><img src="images/smilies/icon_idea.gif" alt="Idea" border="0"></a>
<a href="javascript:areatext('Laughing');"><img src="images/smilies/icon_lol.gif" alt="Lol" border="0"></a>
<a href="javascript:areatext(':x');"><img src="images/smilies/icon_mad.gif" alt="Mad" border="0"></a>
<a href="javascript:areatext('Question');"><img src="images/smilies/icon_question.gif" alt="Question" border="0"></a>
<a href="javascript:areatext(':P');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a>
<a href="javascript:areatext(':oops:');"><img src="images/smilies/icon_redface.gif" alt="Redface" border="0"></a>
<a href="javascript:areatext(':roll:');"><img src="images/smilies/icon_rolleyes.gif" alt="Rolleyes" border="0"></a>
<a href="javascript:areatext(':o');"><img src="images/smilies/icon_surprised.gif" alt="Surprised" border="0"></a>
<a href="javascript:areatext(':wink:');"><img src="images/smilies/icon_wink.gif" alt="Wink" border="0"></a>
<?php
echo ("
</td>
</tr>
<tr><td align='center' class=\"names\">Íîâèíà:</td></tr>
<tr><td align='center'>
<textarea rows='7' name='news' cols='35'></textarea></td></tr>
<tr><td align='center'>
<input type='submit' value='Èçïðàòè' name='send'></td></tr>
</form>
</td></tr></table>");
$news = $_POST['news'];
if($news)
{
if($news!="")
{
$query = "INSERT INTO news (news, date) VALUES ('$news', NOW())";
$result = @mysql_query($query);
}
}
}
elseif($level==9){
$news = $_POST['news'];
if($news)
{
if($news!="")
{
$query = "INSERT INTO news (news, date) VALUES ('$news', NOW())";
$result = @mysql_query($query);
}
}
echo("<table border='0' width='100%' cellspacing='1' align='center'>");
echo ("<form method='POST' name='comment'>");
echo '<td align="center">';
?>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">BOLD</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><i>Italic</i></font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2"><u>Underline</u></font></a>
<a href="javascript:areatext('[color=]Text[/color]');"><font face="verdana" color="#666" size="2">Color</font></a>
<a href="javascript:areatext('Text');"><font face="verdana" color="#666" size="2">Size</font></a>
<a href="javascript:areatext('
');"><font face="verdana" color="#666" size="2">Img</font></a>
<a href="javascript:areatext('Name');"><font face="#666" color="#666" size="2">Link</font></a>
</td>
</tr>
<tr>
<td align="center">
<a href="javascript:areatext(':)');"><img src="images/smilies/icon_smile.gif" alt="Smile" border="0"></a>
<a href="javascript:areatext(':(');"><img src="images/smilies/icon_sad.gif" alt="Sad" border="0"></a>
<a href="javascript:areatext(':arrow:');"><img src="images/smilies/icon_arrow.gif" alt="Arrow" border="0"></a>
<a href="javascript:areatext(':D');"><img src="images/smilies/icon_biggrin.gif" alt="Biggrin" border="0"></a>
<a href="javascript:areatext(':?');"><img src="images/smilies/icon_confused.gif" alt="Confused" border="0"></a>
<a href="javascript:areatext('8)');"><img src="images/smilies/icon_cool.gif" alt="Cool" border="0"></a>
<a href="javascript:areatext(';(');"><img src="images/smilies/icon_cry.gif" alt="Cry" border="0"></a>
<a href="javascript:areatext('Shocked');"><img src="images/smilies/icon_eek.gif" alt="Eek" border="0"></a>
<a href="javascript:areatext(':evil:');"><img src="images/smilies/icon_evil.gif" alt="Evil" border="0"></a>
<a href="javascript:areatext('Exclamation');"><img src="images/smilies/icon_exclaim.gif" alt="Exclaim" border="0"></a>
<a href="javascript:areatext('Idea');"><img src="images/smilies/icon_idea.gif" alt="Idea" border="0"></a>
<a href="javascript:areatext('Laughing');"><img src="images/smilies/icon_lol.gif" alt="Lol" border="0"></a>
<a href="javascript:areatext(':x');"><img src="images/smilies/icon_mad.gif" alt="Mad" border="0"></a>
<a href="javascript:areatext('Question');"><img src="images/smilies/icon_question.gif" alt="Question" border="0"></a>
<a href="javascript:areatext(':P');"><img src="images/smilies/icon_razz.gif" alt="Razz" border="0"></a>
<a href="javascript:areatext(':oops:');"><img src="images/smilies/icon_redface.gif" alt="Redface" border="0"></a>
<a href="javascript:areatext(':roll:');"><img src="images/smilies/icon_rolleyes.gif" alt="Rolleyes" border="0"></a>
<a href="javascript:areatext(':o');"><img src="images/smilies/icon_surprised.gif" alt="Surprised" border="0"></a>
<a href="javascript:areatext(':wink:');"><img src="images/smilies/icon_wink.gif" alt="Wink" border="0"></a>
<?php
echo ("
</td>
</tr>
<tr><td align='center' class=\"names\">Íîâèíà:</td></tr>
<tr><td align='center'>
<textarea rows='7' name='news' cols='35'></textarea></td></tr>
<tr><td align='center'>
<input type='submit' value='Èçïðàòè' name='send'></td></tr>
</form>
</td></tr></table>");
}
elseif($level==1)
{
echo "<center>Äîñòúï, îòêàçàí.Ñàìî àäìèíèñòðàòîðè è ìîäåðàòîðè èìàò äîñòúï äî òîçè ìîäóë</center>";
}
}
}
else
{
echo '<table align="center"><tr><td align="center">Äîñòúï, îòêàçàí ìîëÿ <a href="?d=dir&c=login&p=hlogin">âëåçòå</a></td></tr></table>';
}
?>
 

Back
Горе