вместо падащо избиране, поле

  • Автор Автор Anonymous
  • Начална дата Начална дата
A

Anonymous

Guest
Ето какъв ми е проблема: http://prikachi.com/images/846/3164846f.png
Където е: "До потребител:" вместо да се избира до кой потребител да се прати съобщението чрез падащо избиране, да се избира чрез обикновено текстово поле.

Ето самият код:
Код:
<?php
session_start();
ob_start();
if($_SESSION['username'])
{
echo '<center><div align="center"><b><a href="?page=inbox">Кутия</a> | <a href="?page=write">Ново съобщение</a></b></div><br></center>';
$pmsesusername = $_SESSION['username'];
include "includes/pmconfig.php";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("site problem: unable to select the database");
mysql_select_db("$db", $db_conn) or die("site problem: unable to select the database");
switch($_GET[page])
{
default:
break;
case 'write':
if (!$_POST[send])
{
echo ("<center><form method='post' style='margin: 0px;'>До потребител:<br>
<select name='to'>
");
$getusers = mysql_query("SELECT * FROM users ORDER BY 'username' ASC");
while ($users = MySQL_Fetch_Array($getusers)) {
echo ("<center><option value='$users[username]'>$users[username]</option>");
}
echo ("<center>
</select>
<br>Заглавие:
<br><input type='text' name='subject' size='20'>
<br>Съобщение:
<br><textarea rows='7' name='message' cols='35'></textarea>
<br><input type='submit' value='Изпрати' name='send'>
</form>
");
}
if ($_POST[to])
{
$subject = htmlspecialchars(addslashes("$_POST[subject]"));
$message = htmlspecialchars(addslashes("$_POST[message]"));
$to = htmlspecialchars(addslashes("$_POST[to]"));
$send = mysql_query("INSERT INTO `messages` ( `title` , `message` ,
`touser` , `from` , `unread` ,
`date` ) VALUES ('$subject', '$message', '$to',
'$pmsesusername', 'unread', NOW())");
echo ("<center>Вашето съобщение беше изпратено успешно.");
}
break;
case 'delete':
if (!$_GET[msgid])
{
echo ("<center>Съобщението което се опитвате да отворите е невалидно.");
}
else
{
$getmsg = mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] != $pmsesusername)
{
echo ("<center>Това съобщение не беше изпратено до теб.");
}
else
{
$delete = mysql_query("delete from messages where id = '$_GET[msgid]'");
echo ("<center>Съобщението беше изтрито успешно.");
}
}
break;
case 'inbox':
$get = mysql_query("SELECT * from messages where touser = '$pmsesusername' order by id desc");
echo ("
<table bgcolor='#dddddd' border='0' width='100%' cellspacing='0'>
<tr>
<td align='center'>Заглавие</td>
<td align='center' width='125'>Подател</td>
<td align='center' width='97'>Дата</td>
<td width='25'>Премахване</td>
</tr>
</table>
");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Вие имате 0 съобщения.");
}
else
{
echo("<table border='0' width='100%' cellspacing='1'>");
while ($messages = mysql_fetch_array($get))
{
echo ("<center>
<tr>
<td><a href='?page=view&msgid=$messages[id]'>");
if ($messages[reply] == yes)
{
echo ("<center>Отговор до: ");
}
echo ("<center>$messages[title]</a></td>
<td width='125'>$messages[from]</td>
<td width='97'>$messages[date]</td>
<td width='25'><a href='?page=delete&msgid=$messages[id]'>Изтрий</a></td>
</tr>");
}
echo ("<center></table>");
}
break;
case 'view':
if (!$_GET[msgid])
{
echo ("<center>Невалидно съобщение.");
}
else
{
$getmsg= mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] == $pmsesusername)
{
if (!$_POST[message])
{
$markread = mysql_query("Update messages set unread = 'read' where id = '$_GET[msgid]'");
$msg[message] = nl2br(stripslashes("$msg[message]"));
echo ("<center>
<form method='post' style='margin: 0px;'>
<b>От: $msg[from]</b><br><b>Заглавие: $msg[title]</b>
<b><br>Съобщение:<br><u>$msg[message]</u></br></b>
<b>Отговор:<br></b>
<center><textarea rows='6' name='message' cols='45'></textarea></center>
<input type='submit' value='Изпрати' name='send'>
</form>");
}
if ($_POST[message])
{
$message = htmlspecialchars(addslashes("$_POST[message]"));
$do = mysql_query("INSERT INTO `messages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('$msg[title]', '$message', '$msg[from]', '$pmsesusername',
'unread', NOW(), 'yes')");
echo ("<center>Съобщението е изпратено.");
}
}
}
break;
}
}
else
{
echo "Моля, логнете се!";
}
?>
 
PHP:
<?php
session_start();
ob_start();
if($_SESSION['username'])
{
echo '<center><div align="center"><b><a href="?page=inbox">Кутия</a> | <a href="?page=write">Ново съобщение</a></b></div><br></center>';
$pmsesusername = $_SESSION['username'];
include "includes/pmconfig.php";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("site problem: unable to select the database");
mysql_select_db("$db", $db_conn) or die("site problem: unable to select the database");
switch($_GET[page])
{
default:
break;
case 'write':
if (!$_POST[send])
{
echo ("<center><form method='post' style='margin: 0px;'>До потребител:<br>
<select name='to'>
");
$getusers = mysql_query("SELECT * FROM users ORDER BY 'username' ASC");
while ($users = MySQL_Fetch_Array($getusers)) {
echo ("<option value='$users[username]'>$users[username]</option>");
}
echo ("
</select>
<br>Заглавие:
<br><input type='text' name='subject' size='20'>
<br>Съобщение:
<br><textarea rows='7' name='message' cols='35'></textarea>
<br><input type='submit' value='Изпрати' name='send'>
</form>
</center>
");
}
if ($_POST[to])
{
$subject = htmlspecialchars(addslashes("$_POST[subject]"));
$message = htmlspecialchars(addslashes("$_POST[message]"));
$to = htmlspecialchars(addslashes("$_POST[to]"));
$send = mysql_query("INSERT INTO `messages` ( `title` , `message` ,
`touser` , `from` , `unread` ,
`date` ) VALUES ('$subject', '$message', '$to',
'$pmsesusername', 'unread', NOW())");
echo ("<center>Вашето съобщение беше изпратено успешно.");
}
break;
case 'delete':
if (!$_GET[msgid])
{
echo ("<center>Съобщението което се опитвате да отворите е невалидно.");
}
else
{
$getmsg = mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] != $pmsesusername)
{
echo ("<center>Това съобщение не беше изпратено до теб.");
}
else
{
$delete = mysql_query("delete from messages where id = '$_GET[msgid]'");
echo ("<center>Съобщението беше изтрито успешно.");
}
}
break;
case 'inbox':
$get = mysql_query("SELECT * from messages where touser = '$pmsesusername' order by id desc");
echo ("
<table bgcolor='#dddddd' border='0' width='100%' cellspacing='0'>
<tr>
<td align='center'>Заглавие</td>
<td align='center' width='125'>Подател</td>
<td align='center' width='97'>Дата</td>
<td width='25'>Премахване</td>
</tr>
</table>
");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Вие имате 0 съобщения.");
}
else
{
echo("<table border='0' width='100%' cellspacing='1'>");
while ($messages = mysql_fetch_array($get))
{
echo ("<center>
<tr>
<td><a href='?page=view&msgid=$messages[id]'>");
if ($messages[reply] == yes)
{
echo ("<center>Отговор до: ");
}
echo ("<center>$messages[title]</a></td>
<td width='125'>$messages[from]</td>
<td width='97'>$messages[date]</td>
<td width='25'><a href='?page=delete&msgid=$messages[id]'>Изтрий</a></td>
</tr>");
}
echo ("<center></table>");
}
break;
case 'view':
if (!$_GET[msgid])
{
echo ("<center>Невалидно съобщение.");
}
else
{
$getmsg= mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] == $pmsesusername)
{
if (!$_POST[message])
{
$markread = mysql_query("Update messages set unread = 'read' where id = '$_GET[msgid]'");
$msg[message] = nl2br(stripslashes("$msg[message]"));
echo ("<center>
<form method='post' style='margin: 0px;'>
<b>От: $msg[from]</b><br><b>Заглавие: $msg[title]</b>
<b><br>Съобщение:<br><u>$msg[message]</u></br></b>
<b>Отговор:<br></b>
<center><textarea rows='6' name='message' cols='45'></textarea></center>
<input type='submit' value='Изпрати' name='send'>
</form>");
}
if ($_POST[message])
{
$message = htmlspecialchars(addslashes("$_POST[message]"));
$do = mysql_query("INSERT INTO `messages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('$msg[title]', '$message', '$msg[from]', '$pmsesusername',
'unread', NOW(), 'yes')");
echo ("<center>Съобщението е изпратено.");
}
}
}
break;
}
}
else
{
echo "Моля, логнете се!";
}
?>
 
PHP:
<?php
session_start();
ob_start();
if($_SESSION['username'])
{
echo '<center><div align="center"><b><a href="?page=inbox">Кутия</a> | <a href="?page=write">Ново съобщение</a></b></div><br></center>';
$pmsesusername = $_SESSION['username'];
include "includes/pmconfig.php";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("site problem: unable to select the database");
mysql_select_db("$db", $db_conn) or die("site problem: unable to select the database");
switch($_GET[page])
{
default:
break;
case 'write':
if (!$_POST[send])
{
echo ("<center><form method='post' style='margin: 0px;'>До потребител:<br>
<select name='to'>
");
$getusers = mysql_query("SELECT * FROM users ORDER BY 'username' ASC");
echo ("<input type='text' name='username'>");
echo ("
</select>
<br>Заглавие:
<br><input type='text' name='subject' size='20'>
<br>Съобщение:
<br><textarea rows='7' name='message' cols='35'></textarea>
<br><input type='submit' value='Изпрати' name='send'>
</form>
</center>
");
}
if ($_POST[to])
{
$subject = htmlspecialchars(addslashes("$_POST[subject]"));
$message = htmlspecialchars(addslashes("$_POST[message]"));
$to = htmlspecialchars(addslashes("$_POST[to]"));
$send = mysql_query("INSERT INTO `messages` ( `title` , `message` ,
`touser` , `from` , `unread` ,
`date` ) VALUES ('$subject', '$message', '$to',
'$pmsesusername', 'unread', NOW())");
echo ("<center>Вашето съобщение беше изпратено успешно.");
}
break;
case 'delete':
if (!$_GET[msgid])
{
echo ("<center>Съобщението което се опитвате да отворите е невалидно.");
}
else
{
$getmsg = mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] != $pmsesusername)
{
echo ("<center>Това съобщение не беше изпратено до теб.");
}
else
{
$delete = mysql_query("delete from messages where id = '$_GET[msgid]'");
echo ("<center>Съобщението беше изтрито успешно.");
}
}
break;
case 'inbox':
$get = mysql_query("SELECT * from messages where touser = '$pmsesusername' order by id desc");
echo ("
<table bgcolor='#dddddd' border='0' width='100%' cellspacing='0'>
<tr>
<td align='center'>Заглавие</td>
<td align='center' width='125'>Подател</td>
<td align='center' width='97'>Дата</td>
<td width='25'>Премахване</td>
</tr>
</table>
");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Вие имате 0 съобщения.");
}
else
{
echo("<table border='0' width='100%' cellspacing='1'>");
while ($messages = mysql_fetch_array($get))
{
echo ("<center>
<tr>
<td><a href='?page=view&msgid=$messages[id]'>");
if ($messages[reply] == yes)
{
echo ("<center>Отговор до: ");
}
echo ("<center>$messages[title]</a></td>
<td width='125'>$messages[from]</td>
<td width='97'>$messages[date]</td>
<td width='25'><a href='?page=delete&msgid=$messages[id]'>Изтрий</a></td>
</tr>");
}
echo ("<center></table>");
}
break;
case 'view':
if (!$_GET[msgid])
{
echo ("<center>Невалидно съобщение.");
}
else
{
$getmsg= mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] == $pmsesusername)
{
if (!$_POST[message])
{
$markread = mysql_query("Update messages set unread = 'read' where id = '$_GET[msgid]'");
$msg[message] = nl2br(stripslashes("$msg[message]"));
echo ("<center>
<form method='post' style='margin: 0px;'>
<b>От: $msg[from]</b><br><b>Заглавие: $msg[title]</b>
<b><br>Съобщение:<br><u>$msg[message]</u></br></b>
<b>Отговор:<br></b>
<center><textarea rows='6' name='message' cols='45'></textarea></center>
<input type='submit' value='Изпрати' name='send'>
</form>");
}
if ($_POST[message])
{
$message = htmlspecialchars(addslashes("$_POST[message]"));
$do = mysql_query("INSERT INTO `messages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('$msg[title]', '$message', '$msg[from]', '$pmsesusername',
'unread', NOW(), 'yes')");
echo ("<center>Съобщението е изпратено.");
}
}
}
break;
}
}
else
{
echo "Моля, логнете се!";
}
?>
 
не се изпраща съобщението, и освен това: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /users/bob4eco/public_html/messages.php on line 79
 
Добре ето...
PHP:
<?php
session_start();
ob_start();
if($_SESSION['username'])
{
echo '<center><div align="center"><b><a href="?page=inbox">Кутия</a> | <a href="?page=write">Ново съобщение</a></b></div><br></center>';
$pmsesusername = $_SESSION['username'];
include "includes/pmconfig.php";
$db_conn = mysql_connect("$host", "$dbusername", "$dbpassword")
or die("site problem: unable to select the database");
mysql_select_db("$db", $db_conn) or die("site problem: unable to select the database");
switch($_GET[page])
{
default:
break;
case 'write':
if (!$_POST[send])
{
echo ("<center><form method='post' style='margin: 0px;'>До потребител:<br>
<select name='to'>
");
$getusers = mysql_query("SELECT * FROM users ORDER BY 'username' ASC");
while ($users = MySQL_Fetch_Array($getusers)) {
echo ("<input type='text' name='to'>");
}
echo ("
</select>
<br>Заглавие:
<br><input type='text' name='subject' size='20'>
<br>Съобщение:
<br><textarea rows='7' name='message' cols='35'></textarea>
<br><input type='submit' value='Изпрати' name='send'>
</form>
</center>
");
}
if ($_POST[to])
{
$subject = htmlspecialchars(addslashes("$_POST[subject]"));
$message = htmlspecialchars(addslashes("$_POST[message]"));
$to = htmlspecialchars(addslashes("$_POST[to]"));
$send = mysql_query("INSERT INTO `messages` ( `title` , `message` ,
`touser` , `from` , `unread` ,
`date` ) VALUES ('$subject', '$message', '$to',
'$pmsesusername', 'unread', NOW())");
echo ("<center>Вашето съобщение беше изпратено успешно.");
}
break;
case 'delete':
if (!$_GET[msgid])
{
echo ("<center>Съобщението което се опитвате да отворите е невалидно.");
}
else
{
$getmsg = mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] != $pmsesusername)
{
echo ("<center>Това съобщение не беше изпратено до теб.");
}
else
{
$delete = mysql_query("delete from messages where id = '$_GET[msgid]'");
echo ("<center>Съобщението беше изтрито успешно.");
}
}
break;
case 'inbox':
$get = mysql_query("SELECT * from messages where touser = '$pmsesusername' order by id desc");
echo ("
<table bgcolor='#dddddd' border='0' width='100%' cellspacing='0'>
<tr>
<td align='center'>Заглавие</td>
<td align='center' width='125'>Подател</td>
<td align='center' width='97'>Дата</td>
<td width='25'>Премахване</td>
</tr>
</table>
");
$nummessages = mysql_num_rows($get);
if ($nummessages == 0)
{
echo ("<center>Вие имате 0 съобщения.");
}
else
{
echo("<table border='0' width='100%' cellspacing='1'>");
while ($messages = mysql_fetch_array($get))
{
echo ("<center>
<tr>
<td><a href='?page=view&msgid=$messages[id]'>");
if ($messages[reply] == yes)
{
echo ("<center>Отговор до: ");
}
echo ("<center>$messages[title]</a></td>
<td width='125'>$messages[from]</td>
<td width='97'>$messages[date]</td>
<td width='25'><a href='?page=delete&msgid=$messages[id]'>Изтрий</a></td>
</tr>");
}
echo ("<center></table>");
}
break;
case 'view':
if (!$_GET[msgid])
{
echo ("<center>Невалидно съобщение.");
}
else
{
$getmsg= mysql_query("SELECT * from messages where id = '$_GET[msgid]'");
$msg = mysql_fetch_array($getmsg);
if ($msg[touser] == $pmsesusername)
{
if (!$_POST[message])
{
$markread = mysql_query("Update messages set unread = 'read' where id = '$_GET[msgid]'");
$msg[message] = nl2br(stripslashes("$msg[message]"));
echo ("<center>
<form method='post' style='margin: 0px;'>
<b>От: $msg[from]</b><br><b>Заглавие: $msg[title]</b>
<b><br>Съобщение:<br><u>$msg[message]</u></br></b>
<b>Отговор:<br></b>
<center><textarea rows='6' name='message' cols='45'></textarea></center>
<input type='submit' value='Изпрати' name='send'>
</form>");
}
if ($_POST[message])
{
$message = htmlspecialchars(addslashes("$_POST[message]"));
$do = mysql_query("INSERT INTO `messages` ( `title` , `message` , `touser` , `from` , `unread` ,
`date`, `reply`) VALUES
('$msg[title]', '$message', '$msg[from]', '$pmsesusername',
'unread', NOW(), 'yes')");
echo ("<center>Съобщението е изпратено.");
}
}
}
break;
}
}
else
{
echo "Моля, логнете се!";
}
?>
Много ясно, че няма да се изпраща съобщението. Ти трябва да си промениш и на долу кода, за да се прати....
 

Back
Горе