我的代码出了什么问题？ [英] what is wrong on my codes?

问题描述

//We check if the user is logged
if(isset($_SESSION['username']))
{
$form = true;
$otitle = '';
$orecip = '';
$omessage = '';
//We check if the form has been sent
if(isset($_POST['title'], $_POST['recip'], $_POST['message']))
{
  $otitle = $_POST['title'];
  $orecip = $_POST['recip'];
  $omessage = $_POST['message'];
  //We remove slashes depending on the configuration
  if(get_magic_quotes_gpc())
  {
    $otitle = stripslashes($otitle);
    $orecip = stripslashes($orecip);
    $omessage = stripslashes($omessage);
  }
  //We check if all the fields are filled
  if($_POST['title']!='' and $_POST['recip']!='' and $_POST['message']!='')
  {
    //We protect the variables
    $title = mysql_real_escape_string($otitle);
    $recip = mysql_real_escape_string($orecip);
    $message = mysql_real_escape_string(nl2br(htmlentities($omessage, ENT_QUOTES, 'UTF-8')));
    //We check if the recipient exists
    $dn1 = mysql_fetch_array(mysql_query('select count(id) as recip, id as recipid, (select count(*) from pm) as npm from users where username="'.$recip.'"'));
    if($dn1['recip']==1)
    {
      //We check if the recipient is not the actual user
      if($dn1['recipid']!=$_SESSION['userid'])
      {
        $id = $dn1['npm']+1;
        //We send the message
        if(mysql_query('insert into pm (id, id2, title, user1, user2, message, timestamp, user1read, user2read, status)values("'.$id.'", "1", "'.$title.'", "'.$_SESSION['userid'].'", "'.$dn1['recipid'].'", "'.$message.'", "'.time().'", "yes", "no", "Waiting for Approval")'))
        {


//malaking problema need to fix pa!!!!!!!!

          //dropdown ajax or php method


?>
<div class="message">The message has successfully been sent.<br />
<a href="list_pm.php">List of my personnal messages</a></div>
          $form = false;
        }
        else
        {
          //Otherwise, we say that an error occured
          $error = 'An error occurred while sending the message';
        }
      }
      else
      {
        //Otherwise, we say the user cannot send a message to himself
        $error = 'You cannot send a message to yourself.';
      }
    }
    else
    {
      //Otherwise, we say the recipient does not exists
      $error = 'The recipient does not exists.';
    }
  }
  


  else
  {
    //Otherwise, we say a field is empty
    $error = 'A field is empty. Please fill of the fields.';
  }
}
elseif(isset($_GET['recip']))
{
  //We get the username for the recipient if available
  $orecip = $_GET['recip'];
}
if($form)
{
//We display a message if necessary
if(isset($error))
{
  echo '<div class="message">'.$error.'</div>';
}
//We display the form
?>




function query2() {
  $myData = mysql_query("SELECT * FROM users WHERE approver");
  while($record = mysql_fetch_array($myData)){
    echo '<option value="' . $record['approver'] . '">' . $record['approver'] . '</option>';
  
  }
}
?>

i还希望数据库表中的'approver'表自动显示在我的表单上，如用户名。

i want also the 'approver' table from database table automatically shown on my form like the username.

推荐答案

_SESSION [ ' 用户名']））
{

_SESSION['username'])) {

form = true;

form = true;

otitle = ' ';

otitle = '';

这篇关于我的代码出了什么问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！