Изпращане на съобщения

R

racemaster

Registered
Защо като пращам съобщение до някол потребител моето име не се записва в бд плс хелп оправете ми кода ето го и него
Код: 
 <font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="sdasda" style="position:absolute;width:616px;background-image:url(images/img2.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="sdasda"> <br>
<?
if ($_POST['newmessage'] != ""){
$to = $_POST['to'];

$from = $user_class->id;

$timesent = time();
$subject = strip_tags($_POST['subject']);
$msgtext = strip_tags($_POST['msgtext']);
$checkuser = mysql_query("SELECT `username` FROM `streetracing_users` WHERE `username`='".$to."'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
$result= mysql_query("INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`)".
"VALUES ('$to', '$from', '$timesent', '$subject', '$msgtext')");
echo Message(" <center> Съобщението е изпратено до $to ! <center> ");
} else {
echo Message(' <center> Името не съществува! <center> ');
}
}
?>
<?
$result = mysql_query("SELECT * from `streetracing_msg` ORDER BY `timesent` DESC");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (strtoupper($row['to']) == strtoupper($user_class->username)) {
$from_user_class = new User($row['from']);
$subject = ($row['subject'] == "") ? "Няма заглавие" : $row['subject'];
if ($row['viewed']=="1"){
$viewed="Не";
}else{
$viewed="Да";
}
echo "
";
}
}
if ($_GET['reply'] != ""){
$result2 = mysql_query("SELECT * from `streetracing_msg` WHERE `id`='".$_GET['reply']."'");
$worked2 = mysql_fetch_array($result2);
$from_user_class = new User($worked2['from']);
}
?>
<form method='post'>
<center> Потребител <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="to" 
value="<?php echo $_GET['to'] . $from_user_class->username; ?>" maxlength="15">
<br>
<center> Заглавие <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="subject" 
value="<? echo ($_GET['reply'] != "") ? "Re: ".$worked2['subject'] : "";  ?>">
<br>
<center> Съобщение <center>
<textarea name="msgtext" style="position:absolute;left:175px;width:261px;height:130px;border:1px 
#FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" rows="7" 
cols="53"><? echo ($_GET['reply'] != "") ? " \n -------- \n ".$worked2['msgtext'] : "";  ?></textarea>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<input type="submit" name="newmessage" value="Изпрати" style="position:absolute;left:175px; top:275px; width:261px;height:27px;
border:1px #FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:2">
</form>
</td>
</tr>
</table>
 
Код: 
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="sdasda" style="position:absolute;width:616px;background-image:url(images/img2.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="sdasda"> <br>
<?
if ($_POST['newmessage'] != ""){
$to = $_POST['to'];

$from = $user_class->username;

$timesent = time();
$subject = strip_tags($_POST['subject']);
$msgtext = strip_tags($_POST['msgtext']);
$checkuser = mysql_query("SELECT `username` FROM `streetracing_users` WHERE `username`='".$to."'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
$result= mysql_query("INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`) VALUES ('$to', '$from', '$timesent', '$subject', '$msgtext')");
echo Message(" <center> Съобщението е изпратено до $to ! <center> ");
} else {
echo Message(' <center> Името не съществува! <center> ');
}
}
?>
<?
$result = mysql_query("SELECT * from `streetracing_msg` ORDER BY `timesent` DESC");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (strtoupper($row['to']) == strtoupper($user_class->username)) {
$from_user_class = new User($row['from']);
$subject = ($row['subject'] == "") ? "Няма заглавие" : $row['subject'];
if ($row['viewed']=="1"){
$viewed="Не";
}else{
$viewed="Да";
}
echo "
";
}
}
if ($_GET['reply'] != ""){
$result2 = mysql_query("SELECT * from `streetracing_msg` WHERE `id`='".$_GET['reply']."'");
$worked2 = mysql_fetch_array($result2);
$from_user_class = new User($worked2['from']);
}
?>
<form method='post'>
<center> Потребител <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="to"
value="<?php echo $_GET['to'] . $from_user_class->username; ?>" maxlength="15">
<br>
<center> Заглавие <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="subject"
value="<? echo ($_GET['reply'] != "") ? "Re: ".$worked2['subject'] : "";  ?>">
<br>
<center> Съобщение <center>
<textarea name="msgtext" style="position:absolute;left:175px;width:261px;height:130px;border:1px
#FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" rows="7"
cols="53"><? echo ($_GET['reply'] != "") ? " \n -------- \n ".$worked2['msgtext'] : "";  ?></textarea>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<input type="submit" name="newmessage" value="Изпрати" style="position:absolute;left:175px; top:275px; width:261px;height:27px;
border:1px #FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:2">
</form>
</td>
</tr>
</table>
 
<?
session_start();
include "config.php";
$sesuser = $_SESSION['username'];
?>
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="sdasda" style="position:absolute;width:616px;background-image:url(images/img2.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="sdasda"> <br>
<?
if ($_POST['newmessage'] != ""){
$to = $_POST['to'];

$from = $user_class->id;

$timesent = time();
$subject = strip_tags($_POST['subject']);
$msgtext = strip_tags($_POST['msgtext']);
$from = $sesuser;
$checkuser = mysql_query("SELECT `username` FROM `streetracing_users` WHERE `username`='".$to."'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
$result= mysql_query("INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`)".
"VALUES ('$to', '$sesuser', '$timesent', '$subject', '$msgtext')");
echo Message(" <center> Съобщението е изпратено до $to ! <center> ");
} else {
echo Message(' <center> Името не съществува! <center> ');
}
}
?>
<?
$result = mysql_query("SELECT * from `streetracing_msg` ORDER BY `timesent` DESC");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (strtoupper($row['to']) == strtoupper($user_class->username)) {
$from_user_class = new User($row['from']);
$subject = ($row['subject'] == "") ? "Няма заглавие" : $row['subject'];
if ($row['viewed']=="1"){
$viewed="Не";
}else{
$viewed="Да";
}
echo "
";
}
}
if ($_GET['reply'] != ""){
$result2 = mysql_query("SELECT * from `streetracing_msg` WHERE `id`='".$_GET['reply']."'");
$worked2 = mysql_fetch_array($result2);
$from_user_class = new User($worked2['from']);
}
?>
<form method='post'>
<center> Потребител <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="to"
value="<?php echo $_GET['to'] . $from_user_class->username; ?>" maxlength="15">
<br>
<center> Заглавие <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="subject"
value="<? echo ($_GET['reply'] != "") ? "Re: ".$worked2['subject'] : ""; ?>">
<br>
<center> Съобщение <center>
<textarea name="msgtext" style="position:absolute;left:175px;width:261px;height:130px;border:1px
#FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" rows="7"
cols="53"><? echo ($_GET['reply'] != "") ? " \n -------- \n ".$worked2['msgtext'] : ""; ?></textarea>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<input type="submit" name="newmessage" value="Изпрати" style="position:absolute;left:175px; top:275px; width:261px;height:27px;
border:1px #FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:2">
</form>
</td>
</tr>
</table>
Увеличете...

Така ?
 
FreeStylerz пак не изпраща името и това $sesuser = $_SESSION['username']; го смених с id и сега ми изпраща $sesuser = $_SESSION['id']; id номера на мен ми трябва да показва потребителското име плс помогнете ми ако трябва да ви дам логин системата
Увеличете...
 
<?
session_start();
include "config.php";
$sesuser = $_SESSION['username'];
?>
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="sdasda" style="position:absolute;width:616px;background-image:url(images/img2.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="sdasda"> <br>
<?
$q = mysql_query("SELECT * FROM users WHERE username='$sesuser'");
$r = mysql_fetch_assoc($q);
if ($_POST['newmessage'] != ""){
$to = $_POST['to'];

$timesent = time();
$subject = strip_tags($_POST['subject']);
$msgtext = strip_tags($_POST['msgtext']);
$from = $r[id];
$checkuser = mysql_query("SELECT `username` FROM `streetracing_users` WHERE `username`='".$to."'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
$result= mysql_query("INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`)".
"VALUES ('$to', '$sesuser', '$timesent', '$subject', '$msgtext')");
echo Message(" <center> Съобщението е изпратено до $to ! <center> ");
} else {
echo Message(' <center> Името не съществува! <center> ');
}
}
?>
<?
$result = mysql_query("SELECT * from `streetracing_msg` ORDER BY `timesent` DESC");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (strtoupper($row['to']) == strtoupper($user_class->username)) {
$from_user_class = new User($row['from']);
$subject = ($row['subject'] == "") ? "Няма заглавие" : $row['subject'];
if ($row['viewed']=="1"){
$viewed="Не";
}else{
$viewed="Да";
}
echo "
";
}
}
if ($_GET['reply'] != ""){
$result2 = mysql_query("SELECT * from `streetracing_msg` WHERE `id`='".$_GET['reply']."'");
$worked2 = mysql_fetch_array($result2);
$from_user_class = new User($worked2['from']);
}
?>
<form method='post'>
<center> Потребител <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="to"
value="<?php echo $_GET['to'] . $from_user_class->username; ?>" maxlength="15">
<br>
<center> Заглавие <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="subject"
value="<? echo ($_GET['reply'] != "") ? "Re: ".$worked2['subject'] : ""; ?>">
<br>
<center> Съобщение <center>
<textarea name="msgtext" style="position:absolute;left:175px;width:261px;height:130px;border:1px
#FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" rows="7"
cols="53"><? echo ($_GET['reply'] != "") ? " \n -------- \n ".$worked2['msgtext'] : ""; ?></textarea>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<input type="submit" name="newmessage" value="Изпрати" style="position:absolute;left:175px; top:275px; width:261px;height:27px;
border:1px #FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:2">
</form>
</td>
</tr>
</table>
Увеличете...
Така ?
 
FreeStylerz каза:
<?
session_start();
include "config.php";
$sesuser = $_SESSION['username'];
?>
<font style="font-size:16px" color="#FFFFFF" face="Comic Sans MS">
<div id="sdasda" style="position:absolute;width:616px;background-image:url(images/img2.png);z-index:0;">
<table width="100%" cellpadding="0" cellspacing="0" id="sdasda"> <br>
<?
$q = mysql_query("SELECT * FROM users WHERE username='$sesuser'");
$r = mysql_fetch_assoc($q);
if ($_POST['newmessage'] != ""){
$to = $_POST['to'];

$timesent = time();
$subject = strip_tags($_POST['subject']);
$msgtext = strip_tags($_POST['msgtext']);
$from = $r[id];
$checkuser = mysql_query("SELECT `username` FROM `streetracing_users` WHERE `username`='".$to."'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist > 0){
$result= mysql_query("INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`)".
"VALUES ('$to', '$sesuser', '$timesent', '$subject', '$msgtext')");
echo Message(" <center> Съобщението е изпратено до $to ! <center> ");
} else {
echo Message(' <center> Името не съществува! <center> ');
}
}
?>
<?
$result = mysql_query("SELECT * from `streetracing_msg` ORDER BY `timesent` DESC");
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (strtoupper($row['to']) == strtoupper($user_class->username)) {
$from_user_class = new User($row['from']);
$subject = ($row['subject'] == "") ? "Няма заглавие" : $row['subject'];
if ($row['viewed']=="1"){
$viewed="Не";
}else{
$viewed="Да";
}
echo "
";
}
}
if ($_GET['reply'] != ""){
$result2 = mysql_query("SELECT * from `streetracing_msg` WHERE `id`='".$_GET['reply']."'");
$worked2 = mysql_fetch_array($result2);
$from_user_class = new User($worked2['from']);
}
?>
<form method='post'>
<center> Потребител <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="to"
value="<?php echo $_GET['to'] . $from_user_class->username; ?>" maxlength="15">
<br>
<center> Заглавие <center>
<input type="text" style="position:absolute;left:175px;width:261px;border:1px #FFFF00 dashed;background-color:
transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" name="subject"
value="<? echo ($_GET['reply'] != "") ? "Re: ".$worked2['subject'] : ""; ?>">
<br>
<center> Съобщение <center>
<textarea name="msgtext" style="position:absolute;left:175px;width:261px;height:130px;border:1px
#FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:0" rows="7"
cols="53"><? echo ($_GET['reply'] != "") ? " \n -------- \n ".$worked2['msgtext'] : ""; ?></textarea>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<input type="submit" name="newmessage" value="Изпрати" style="position:absolute;left:175px; top:275px; width:261px;height:27px;
border:1px #FFFF00 dashed;background-color:transparent;color:#FFFFFF;font-family:Comic Sans MS;font-size:16px;z-index:2">
</form>
</td>
</tr>
</table>
Увеличете...
Така ?
Увеличете...
не праща потребителско име
 
А бе човече ти пр*ст ли си е ?
Горното го промени "ТАБЛИЦАТА" - "users" с твойта таблица само долното замести...
 
FreeStylerz каза:
А бе човече ти пр*ст ли си е ?
Горното го промени "ТАБЛИЦАТА" - "users" с твойта таблица само долното замести...
Увеличете...
промених таблицата но не стана
 
FreeStylerz каза:
$result = "INSERT INTO `streetracing_msg` (`to`, `from`, `timesent`, `subject`, `msgtext`) VALUES ('$to', '$from', '$timesent', '$subject', '$msgtext');
mysql_query($result) or die (mysql_error());
Увеличете...
Увеличете...
бях объркал една буква от таблицата на база данни сори са ще ти дам точка
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе