Top
Phpuniverset logo
 

INDHOLD

Forside

Script libary

Job annoncer

Tips og Tricks

Konkurrence

Downloads

Dokumenter

PHP bog shop

Forum

Online udviklere


ARTIKLER

CSS

Diverse

E-handel / annoncer

Grafik

Html

Internet

Javascript

Linux

PHP/MySQL

Programmer

Flash

Søgemaskiner

Windows

C / C++


INFO

Information

Annoncering

Kontakt

Forside Forum PHP, mysql Vil ikke udskrive fra databasen

Vil ikke udskrive fra databasen


 

Vil ikke udskrive fra databasen

Stefan H  

Heysan...

jeg har dette tagwall script herinde fra "tror" jeg...

men nu vil den ikke skrive fra databasen, men kan se den har skreven teksten i databasen.

her er kode:
<?
session_start
();
include(
"inc/config.php");
if(
$_POST["opret"]){
if(empty(
$_POST["navn"]) OR empty($_POST["email"]) OR empty($_POST["besked"])){
header("location: tagwall.php?error=tom");
} else {
if(
$_SESSION["admin"]){
$admin "ja";
}else{
$admin "nej";
}
$navn htmlspecialchars($_POST["navn"]);
$email htmlspecialchars($_POST["email"]);
$www htmlspecialchars($_POST["www"]);
$besked htmlspecialchars($_POST["besked"]);
$dato date("d/m/Y - H:i");
$ip $_SERVER["REMOTE_ADDR"];
mysql_query("INSERT INTO tagwall (navn, email, www, besked, dato, ip, admin) VALUES
('"
.$navn."', '".$email."', '".$www."', '".$besked."', '".$dato."', '".$ip."',
'"
.$admin."')") or die (mysql_error());
header("location: tagwall.php");
}
}
if(
$_GET["section"] == "logud"){
echo 
"<br><center><font color=\"#FF0000\"><b>du er nu loggede ud af
systemet</b></font></center><br>"
;
unset(
$_SESSION["admin"]);
session_destroy();
header("location: tagwall.php");
}
if(
$_GET["section"] == "toem"){
if(!
$_SESSION["admin"]){
header("location: http://google.dk");
}else{
mysql_query("TRUNCATE tagwall") or die (mysql_error());
header("location: tagwall.php");
}
}
if(
$_POST["ret"]){
if(!
$_SESSION["admin"]){
header("location: http://google.dk");
}else{
$navn htmlspecialchars($_POST["navn"]);
$email htmlspecialchars($_POST["email"]);
$www htmlspecialchars($_POST["www"]);
$besked htmlspecialchars($_POST["besked"]);
mysql_query("UPDATE tagwall SET navn = '".$navn."', email = '".$email."', www =
'"
.$www."', besked = '".$besked."' WHERE id = '".$_POST["id"]."'") or die
(
mysql_error());
header("location: tagwall.php");
}
}
if(
$_GET["section"] == "ban"){
if(!
$_SESSION["admin"]){
header("location: http://google.dk");
}else{
mysql_query("INSERT INTO banned (ip) VALUES ('".$_GET["ip"]."')") or die (mysql_error());
header("location: tagwall.php");
}
}
if(
$_GET["section"] == "unban"){
if(!
$_SESSION["admin"]){
header("location: http://google.dk");
}else{
mysql_query("DELETE FROM banned WHERE ip = '".$_GET["ip"]."'") or die (mysql_error());
header("location: tagwall.php");
}
}
if(
$_GET["section"] == "slet"){
if(!
$_SESSION["admin"]){
header("location: http://google.dk");
}else{
mysql_query("DELETE FROM tagwall WHERE id = '".$_GET["id"]."'") or die (mysql_error());
header("location: tagwall.php");
}
}
if(
$_POST["l"]){
if(empty(
$_POST["b"]) OR empty($_POST["p"])){
header("location: tagwall.php?section=admin&error=tomt");
} else {
if(
md5($_POST["p"]) == md5($pass) && $_POST["b"] == $user){
$_SESSION["admin"] = $user;
header("location: tagwall.php");
} else{
header("location: tagwall.php?section=admin&error=skrid");
}
}
}
?>
<? 
include ("inc/online.php"?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>AliasFM - We play day and night</title>
<link rel="stylesheet" href="style/style.css" type="text/css">
</head>

<body>
  <div align="center">
    <table width="930" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="15" height="74" rowspan="5"
background="images/side_left.jpg">&nbsp;</td>
        <td colspan="3"><img src="images/top.jpg" width="900" height="45"></td>
        <td width="15" rowspan="5" background="images/side_right.jpg">&nbsp;</td>
      </tr>
      
      <tr>
        <td height="1" background="images/pixel.jpg"></td>
      </tr>
      <tr>
        <td width="1" height="54" align="center" valign="top"
background="images/pixel.jpg"><br><br></td>
        <td width="863" align="center" valign="top" background="images/bg.jpg"><div
align="right"><br />
            <table width="893" border="0">
              <tr>
                <td width="785"><table width="564" border="0" align="left" cellpadding="0"
cellspacing="0">
                  <tr>
                    <td colspan="3"><img src="images/content_smssystem.jpg" width="724"
height="18" /></td>
                  </tr>
                  <tr>
                    <td width="1" background="images/pixel.jpg"></td>
                    <td width: 564px;background: FFFFFF"><iframe width="100%" height="60"
allowTransparency src="http://tools.comsms.dk/smsbox3.php?id=8392" scrolling="no"
frameborder="0" align="top"></iframe></td>
                    <td width="1" background="images/pixel.jpg"></td>
                  </tr>
                  <tr>
                    <td colspan="3"><img src="images/content_bottom.jpg" width="724"
height="12" /></td>
                  </tr>
                </table></td>
                <td width="30"><a target="_blank"
href="http://stream.aliasfm.net:9352/listen.pls"><img src="images/winamp.gif" width="26"
height="26" border="0"/></a></td>
                <td width="28"><a target="_blank"
href="http://aliasfm.net/108/layorange/aliasfm.asx"><img src="images/wmp2.gif" width="26"
height="26" border="0"/></a></td>
                <td width="32"><a target="_blank"
href="http://aliasfm.net/108/layorange/webplayer/index.php"><img src="images/wmp.gif"
width="26" height="26"  border="0"/></a></td>
              </tr>
            </table>
            <iframe src="http://193.164.133.198/inc/radio2.php" scrolling="no" name="I1"
border="0" frameborder="0" align="center" width="157" height="25"></iframe>
          </div>
        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="19%" align="center" valign="top">
<?php include ("menu/mainmenu.php"); ?>
              <br>
<?php include ("menu/pollsystem.php"); ?>
              <br>
<?php include ("menu/partner.php"); ?>
              <br>
<?php include ("menu/stats.php"?>
              <br /></td>
            <td width="81%" align="center" valign="top"><table width="564" border="0"
align="left" cellpadding="0" cellspacing="0">
              <tr>
                <td colspan="3"><img src="images/content_tagwall.jpg" width="564"
height="18"></td>
              </tr>
              <tr>
                <td width="1" background="images/pixel.jpg"></td>
                <td width: 560px;background: FFFFFF">

<html>
<head>
</head>
</html>
<a href="tagwall.php">tagwall</a>
<?
if($_SESSION["admin"]){
echo 
" # <a href=\"tagwall.php?section=logud\">logud</a><br><br>";
echo 
"<b>ADMIN</b><br>";
echo 
"<a href=\"tagwall.php?section=toem\">Tøm tagwall</a>";
}else{
?> 
# <a href="tagwall.php?section=admin">Admin</a>
# <a href="javascript:winop();">Smileys</a>
<?
}
?><br><br>
<script type="text/javascript">
function winop()
{
windop =
window.open("moresmiles.php","mywin","height=400,width=450,resizable=yes,scrollbars=yes");

}

function addSmilie(text) {
text=''+text+'';
if ( document.getElementById('txt').createTextRange &&
document.getElementById('txt').caretPos) {
var caretPos=document.getElementById('txt').caretPos;
caretPos.text=caretPos.text.charAt(caretPos.text.length-1)==''?text+'':text;
document.getElementById('txt').focus();
} else {
document.getElementById('txt').value+=text;
document.getElementById('txt').focus();
}
}</script>
<?
if($_GET["section"] == "admin"){
?>
<?
if($_GET["error"] == "tomt"){
echo 
"<font color=\"red\">Udfyld alle felter!<br><br></font>";
} elseif(
$_GET["error"] == "skrid"){
echo 
"<font color=\"red\">Skrid!</font><br><br>";
}
?>
<form action="tagwall.php" method="post">
Brugernavn:<br>
<input type="text" name="b"><br>
Password:<br>
<input type="password" name="p"><br>
<input type="submit" value="login" name="l"></form>
<?
}
?>
<?
if($_GET["section"] == "ret") {
if(!
$_SESSION["admin"]){
echo 
"DOH!";
}else{
$tag mysql_query("SELECT * FROM tagwall WHERE id = '".$_GET["id"]."'") or die
(
mysql_error());
$ro mysql_fetch_array($tag);
?>
<form action="tagwall.php" method="post">
<input type="hidden" value="<?=$_GET["id"];?>" name="id">
&nbsp;Navn: *<br>
&nbsp;<input type="text" name="navn" value="<?=$row["navn"];?>"><br>
&nbsp;Email: *<br />
&nbsp;<input type="text" name="email" value="<?=$row["email"];?>"><br>
&nbsp;Http:// (husk <font color="#FF0000"><b>http://</b></font>)<br />
&nbsp;<input type="text" name="www" value="<?=$row["www"];?>"><br>
&nbsp;<input type="button" value="B" style="font-weight:bold;"
onclick="addSmilie('[b][/b]');">
<input type="button" value="I" style="font-style:italic;"
onclick="addSmilie('[i][/i]');">
<input type="button" value="U" style="text-decoration:underline;"
onclick="addSmilie('[u][/u]');">
<input type="button" value="Email" onclick="addSmilie('[email][/email]');">
<input type="button" value="Link" onclick="addSmilie('[link][/link]');">
<input type="button" value="Kode" onclick="addSmilie('[kode][/kode]');">
<br>
&nbsp;<textarea name="besked" rows="9" cols="30"
id="txt"><?=$row["besked"];?></textarea><br>
&nbsp;<input type="submit" value="Ret besked" name="ret"></form>
<?
}
}
?>
<?
if(!$_GET["section"]){
?>
<form action="tagwall.php" method="post">
<?
if($_GET["error"] == "tom"){
echo 
"<font color=\"red\">Du skal udfylde felterne med *</font><br><br>";
}
?>
<?
if($_SESSION["admin"]){
?>
<input type="hidden" name="navn" value="<?=$navn;?>">
<input type="hidden" name="email" value="<?=$email;?>">
<input type="hidden" name="www" value="<?=$www;?>">
&nbsp;<input type="button" value="B" style="font-weight:bold;"
onclick="addSmilie('[b][/b]');">
<input type="button" value="I" style="font-style:italic;"
onclick="addSmilie('[i][/i]');">
<input type="button" value="U" style="text-decoration:underline;"
onclick="addSmilie('[u][/u]');">
<input type="button" value="Email" onclick="addSmilie('[email][/email]');">
<input type="button" value="Link" onclick="addSmilie('[link][/link]');">
<input type="button" value="Kode" onclick="addSmilie('[kode][/kode]');">
<br>
&nbsp;<textarea name="besked" rows="9" cols="30" id="txt"></textarea><br>
&nbsp;<input type="submit" value="Opret besked" name="opret"></form>
<?
}else{
?>
&nbsp;Navn: *<br>
&nbsp;<input type="text" name="navn"><br>
&nbsp;Email: *<br />
&nbsp;<input type="text" name="email"><br>
&nbsp;Http:// (husk <font color="#FF0000"><b>http://</b></font>)<br />
&nbsp;<input type="text" name="www"><br>
&nbsp;<input type="button" value="B" style="font-weight:bold;"
onclick="addSmilie('[b][/b]');">
<input type="button" value="I" style="font-style:italic;"
onclick="addSmilie('[i][/i]');">
<input type="button" value="U" style="text-decoration:underline;"
onclick="addSmilie('[u][/u]');">
<input type="button" value="Email" onclick="addSmilie('[email][/email]');">
<input type="button" value="Link" onclick="addSmilie('[link][/link]');">
<input type="button" value="Kode" onclick="addSmilie('[kode][/kode]');">
<br>
&nbsp;<textarea name="besked" rows="9" cols="37" id="txt"></textarea><br>
&nbsp;<input type="submit" value="Opret besked" name="opret"></form>
<?
}
?>
<hr class="linje">
<?
$t 
mysql_query("SELECT * FROM tagwall") or die (mysql_error());
$antal mysql_num_rows($t);
$vis_fra = (isset($_GET["offset"]) AND is_numeric($_GET["offset"]) AND $antal >
$_GET["offset"]) ? $_GET["offset"] : 0;
$tags mysql_query ("SELECT * FROM tagwall ORDER BY id ".$rakke." LIMIT ".$vis_fra.",
"
.$per_side."") or die(mysql_error());
if(
mysql_num_rows($tags) == 0){
echo 
"&nbsp;Ingen beskeder!";
} else {
while(
$row=mysql_fetch_array($tags)){
echo 
"&nbsp;<b><a href=\"mailto: ".$row["email"]."\">";
if(
$row["admin"] == "ja"){
echo 
"<span id=\"admin\">".$row["navn"]." (admin)</span>";
} else {
echo 
"".$row["navn"]."";
}
echo 
"</a></b>";
if(empty(
$row["www"])){
echo
" <br>";
}else{
echo 
" <b># <a href=\"".$row["www"]."\" target=\"_blank\">www</a></b><br />";
}
echo 
"<center";
echo 
nl2br(smilies(bb($row["besked"])));
echo 
"</center>";
echo 
"<br><br>";
echo 
"&nbsp;Skrevet den ".$row["dato"]."";
if(
$_SESSION["admin"]){
echo 
" <a href=\"tagwall.php?section=slet&id=".$row["id"]."\"><font
color=\"red\">[slet]</font></a> "
;
if(
$row["admin"] == "ja"){
echo 
"";
} else{
 
$ban mysql_query("SELECT * FROM banned WHERE ip = '".$row["ip"]."'") or die
(
mysql_error());
 if(
mysql_num_rows($ban) == 1) {
 echo 
" | <a href=\"tagwall.php?section=unban&ip=".$row["ip"]."\"><font
color=\"black\">[unban]</font></a> "
;
 }else{
 echo 
" | <a href=\"tagwall.php?section=ban&ip=".$row["ip"]."\"><font
color=\"blue\">[ban]</font></a> "
;
 }
}
 echo 
" | <a href=\"tagwall.php?section=ret&id=".$row["id"]."\"><font
color=\"green\">[ret]</font></a> "
;
}else{
echo
"";
}
echo 
"<hr class=\"linje\">";

if(
$vis_fra 0){
$back $vis_fra $per_side;
echo 
" <a href=\"".$_SERVER["PHP_SELF"]."?offset=".$back."\">Forrige</a> ";
}else{
echo
"";
}
if(
$vis_fra $antal $per_side){
$next $vis_fra $per_side;
echo 
" <a href=\"".$_SERVER["PHP_SELF"]."?offset=".$next."\">Næste</a> ";
}else{
echo
"";
}

}
}
?>
<?
}
?>
<br></td>
                <td width="1" background="images/pixel.jpg"></td>
              </tr>
              <tr>
                <td colspan="3"><img src="images/content_bottom.jpg" width="564"
height="12"></td>
              </tr>
              </table>
<?php include ("menu/top5.php"); ?>               
           <br><br><br><p><p>
<?php include ("menu/sponsore.php"); ?>               
           <br><br><br><p><p>
<?php include ("menu/needs.php"); ?>
          </tr>
          </table>
        <br></td>
      <tr>
        <td height="34" colspan="3"><img src="images/bottom.jpg" width="900"
height="34"></td>
      </tr>
      </tr>
      </table>
  </div>
<?php
echo '<center>';
echo 
'Copyright AliasFM ';
$year date("Y"); //defines the year
echo("© $year "); //the echoing
echo("<br>");
putenv("TZ=America/Los_Angeles");
echo 
"Last modified: " date"F d Y."getlastmod() );
echo 
'<br>This Station is authorized by: STIM/NCB';
echo 
'</center>';
?>



Dato : 19.02.2008, 16:06

Visninger : 1793

Points : 100

 

men tror ikke jeg har den rette database.sql til tagwallen, er der mon ikke en der her
sqlen... liggende...


Dato : 19.02.2008, 16:07

Kommentar af : Stefan H  




Login for at skrive et indlæg :



   Brugernavn

Password
 

+ Opret en ny Bruger, Klik her

+ Glemt brugernavn/password

 

Send Artikel/anmeldelse til: phpuni@phpuniverset.dk

Tilbage til oversigt

© Copyright 2000 Propelcom Phpuniverset's politik om personlige oplysninger, artikler & Koder Phpuniverset er optimeret til Mozilla 1024 * 768 Phpuniverset version: 3.0 beta
Webhost : Ignesco.dk

Bund