anyquestions.inc

<?php
class AnyQuestions {


function __construct(){
         
         global $connection;
         global $uid;
         global $booking;


                      
// Has this user asked any questions?
$qryFindQuestions = "SELECT * FROM questions WHERE user_id = '$uid'";
$resFindQuestions = mysql_query($qryFindQuestions,$connection) or die(mysql_error());

 if(mysql_num_rows($resFindQuestions) > 0){
                      
     //show the questions

     echo '<div id="messages">
     <div class="message_center">Questions ('.mysql_num_rows($resFindQuestions).')</div>
     <table style="text-align:left">
     ';

            for($i = 0; $i < mysql_num_rows($resFindQuestions); $i++){

                   $question_id    = mysql_result($resFindQuestions, $i, "question_id");
                   $question       = mysql_result($resFindQuestions, $i, "question");
                   $date_added     = mysql_result($resFindQuestions, $i, "date_added");

                   //get the start of the message to display
                   $short = substr($question, 0, 80);

                   //alternate message background colour
                   if($i/2){
                            $bgcolor = "#ececec";
                   } else {
                          $bgcolor = "#d4d0c8";
                   }

                   //add etc
                   if(strlen($question) > 25){
                                             $short .= "...";
                   }


echo '
     <tr bgcolor="'.$bgcolor.'">
     <td><b>'.$short.'</b></td><td>'.reformat_dt($date_added).'</td>
     <td><form action="'.$_SERVER["PHP_SELF"].'" method="get">
     <input type="hidden" name="question_id" value="'.$question_id.'" />
     <input type="hidden" name="uid" value="'.$uid.'" />';

    if(isset($booking)){
    echo '<input type="hidden" name="bk_id" value="'.$booking.'" />';
    }

     echo '<input type="submit" value="Read" />
     </form></td>
     </tr>';


     }
         

echo '</table>';


                      }

                     // } else {
                     //  echo "No Questions";

              }

                function view_question($question_id){
                      global $connection;
                      global $uid;
                      global $booking;
                
                      $query = "SELECT question, date_added FROM questions WHERE question_id = '$question_id'";
                      $result  = mysql_query($query,$connection) or die(mysql_error());
                     
                      //check that there actually is a question - or die
                                  if(mysql_num_rows($result) == 0){
                                    die("Sorry. There is no question that corresponds to that reference. <br /> Please check your email for your reference number.");
                                  }
                      
                      $quest =  mysql_result($result, 0, "question");
                      $date_added =  mysql_result($result, 0, "date_added");
                      




                      echo "<b>Q: ".nl2br($quest)."</b>";
                      echo ' <br /><span class="small_text">('.reformat_dt_tim($date_added).')</span><br /><hr noshade />';
                 
                   
                   // Check if there have been any responses to this question

                   $qryCheckForResponses = "SELECT * FROM question_answers WHERE question_id = '$question_id';";
                   $resCheckForResponses = mysql_query($qryCheckForResponses,$connection) or die(mysql_error());

                   for($i = 0; $i < mysql_num_rows($resCheckForResponses); $i++){

                    $response           = mysql_result($resCheckForResponses, $i, "response");
                    $date_added         = mysql_result($resCheckForResponses, $i, "date_added");
                    $staff_or_customer  = mysql_result($resCheckForResponses, $i, "staff_or_customer");



                    echo '<br /><br />';
 
                    switch($staff_or_customer){
                    case "Staff" : echo '<b>A</b>: ';
                    break;
                    case "Customer" : echo '<b>Q</b>: ';
                    break;
                    }

 
                    echo $response;
                     
                     switch($staff_or_customer){
                    case "Staff" : echo '<br /><br /><span class="small_text">Regards,<br /><span style="color:#cc0001">Valenciaworld&trade;</span></span> ';
                    break;
                    case "Customer" : echo '<br /><br /><span class="small_text">(Customer)</span>';
                    break;
                    }

                    echo ' <br /><span class="small_text">('.reformat_dt_tim($date_added).')</span><br /><hr noshade />';


                    }
                    echo '<!-- Create the input form -->
                    <br /><br />
                    <div align="left">
                    <form action="'.$_SERVER['PHP_SELF'].'" method="post">
                    <textarea name="question_response" rows="4" cols="40"></textarea>
                    <input type="hidden" name="question_id" value="'.$question_id.'" />
                    <input type="hidden" name="uid" value="'.$uid.'" /> ';
                    if(isset($booking)){
                    echo '<input type="hidden" name="booking" value="'.$booking.'" />';
                    }
                    
                    echo '<input type="submit" value="Post Response" />
                    </form>
                    </div>';
                } //end function
                
                
                

                


function add_response($question_response,$question_id){
      global $connection;
                  
// add stripslashes to the text

if(!get_magic_quotes_gpc()){
      $question_response      =    addslashes($question_response);
}

//IS THE USER STAFF OR CUSTOMER?
   if($_SESSION['authenticated']){
      $s_or_c = "Staff";
   } else {
        $s_or_c = "Customer";
   }

//Insert into question_responses table
  
$qryInsertQuestionResponse = "INSERT INTO question_answers (question_id,response,date_added,staff_or_customer)
                              VALUES ('$question_id','$question_response',NOW(),'$s_or_c')";
mysql_query($qryInsertQuestionResponse,$connection) or die(mysql_error());



// set status to closed
  if($s_or_c == "Staff") {
  
  $qryCloseTicket = "UPDATE questions SET status='Closed' WHERE question_id='$question_id'";
  mysql_query($qryCloseTicket,$connection) or die(mysql_error());
  
  } elseif($s_or_c == "Customer") {
  
  $qryCloseTicket = "UPDATE questions SET status='Open' WHERE question_id='$question_id'";
  mysql_query($qryCloseTicket,$connection) or die(mysql_error());

  }



//==========================
                  
                  
                  
                  
                  
                  
                }













}
?>

Paul's Code Library

Categories

Home

AJAX

classes

database_functions

date_functions

file_functions

googlevideo_and_youtube_api

htaccess

image_functions

string_functions