PHP Code

From MWCSWiki

<?php /**

• connects to the database.
• Return false if connection failed.
• Be sure to change the $database_name. $database_username , and
• $database_password values to reflect your database settings.
• /

function db_connect() {

 $database_name = '470S_achap5dk'; // Set this to your Database Name
 $database_username = 'achap5dk'; // Set this to your MySQL username
 $database_password = 'Acha123p5dk'; // Set this to your MySQL password
 $result = mysql_pconnect('localhost',$database_username, $database_password);
 if (!$result) return false;
 if (!mysql_select_db($database_name)) return false;
 return $result;

} $conn = db_connect(); // Connect to database if ($conn) {

 $names = explode(",",$_GET['param']); // The parameter passed to us
 $first_name = $names[0];
 $last_name = $names[1];
 $isstudent = $names[2];

 if ($isstudent == 1){

 if ((strlen($first_name) < 2 ) && (strlen($last_name) < 2)){
         $first_name = "";
         $last_name = "";
         $email = "";
         $return_value = $first_name . "~" . $last_name . "~" . $email;
 }
 else{
 $query = "select * from students where First_Name like '%$first_name%' and Last_Name like '%$last_name%' and Faculty is false";
 $result = mysql_query($query,$conn);
 $count = mysql_num_rows($result);
 $inc = 0;
 if ($count > 0){
         $first_name = mysql_result($result,$inc,'First_Name');
         $last_name = mysql_result($result,$inc,'Last_Name');
         $email = mysql_result($result,$inc,'E-mail');
         $return_value = $first_name . "~" . $last_name . "~" . $email;
         $inc++;
 while ($inc < $count) {
   $first_name = mysql_result($result,$inc,'First_Name');
   $last_name = mysql_result($result,$inc,'Last_Name');
   $email = mysql_result($result,$inc,'E-mail');
   $return_value = $return_value . "~" . $first_name . "~" . $last_name . "~" . $email;
   $inc++;
 }
 }
 else {
   $first_name = "";
   $last_name = "";
   $email = "";
   $return_value = $first_name . "~" . $last_name . "~" . $email;
 }
 }
 }
 else{

if ((strlen($first_name) < 2 ) && (strlen($last_name) < 2)){
         $first_name = "";
         $last_name = "";
         $email = "";
         $position = "";
       $department = "";
       $phone = "";
       $location = "";
         $return_value = $first_name . "~" . $last_name . "~" . $email . "~" . $position . "~" . $department . "~" . $phone . "~" . $location;
 }
 else{
 $query = "select * from students where First_Name like '%$first_name%' and Last_Name like '%$last_name%' and Faculty is true";
 $result = mysql_query($query,$conn);
 $count = mysql_num_rows($result);
 $inc = 0;
 if ($count > 0){
         $first_name = mysql_result($result,$inc,'First_Name');
         $last_name = mysql_result($result,$inc,'Last_Name');
         $email = mysql_result($result,$inc,'E-mail');
         $position = mysql_result($result,$inc,'Position');
         $department = mysql_result($result,$inc,'Department');
         $phone = mysql_result($result,$inc,'Phone');
         $location = mysql_result($result,$inc,'Location');
         $return_value = $first_name . "~" . $last_name . "~" . $email . "~" . $position . "~" . $department . "~" . $phone . "~" . $location;
         $inc++;
 while ($inc < $count) {
   $first_name = mysql_result($result,$inc,'First_Name');
   $last_name = mysql_result($result,$inc,'Last_Name');
   $email = mysql_result($result,$inc,'E-mail');
   $position = mysql_result($result,$inc,'Position');
         $department = mysql_result($result,$inc,'Department');
         $phone = mysql_result($result,$inc,'Phone');
         $location = mysql_result($result,$inc,'Location');
         $return_value = $return_value . "~" . $first_name . "~" . $last_name . "~" . $email . "~" . $position . "~" . $department . "~" . $phone . "~" . $location;
         $inc++;
 }
 }
 else {
   $first_name = "";
   $last_name = "";
   $email = "";
   $position = "";
       $department = "";
       $phone = "";
       $location = "";
         $return_value = $first_name . "~" . $last_name . "~" . $email . "~" . $position . "~" . $department . "~" . $phone . "~" . $location;
 }
 }
 }
 }

echo $return_value; // This will become the response value for the XMLHttpRequest object ?>