Advertisement
Guest User

Untitled

a guest
May 6th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.34 KB | None | 0 0
  1. function getReporsData($mysqli)
  2. {
  3. $certifiedarray=array();
  4. $ethniciesdarray=array();
  5. $experience=array();
  6. $language=array();
  7. $working_in=array();
  8.  
  9. $query= "SELECT SD.id,PI.emp_id ,PI.fname,PI.lname,PI.website,PI.phone,PI.sec_phone,PI.address,PI.apt_unit,PI.city , PI.state , PI.zip , PI.ec_contact , PI.gender,PI.dob,PI.driver_license,PI.reliable_vehicle, PI.will_travel,PI.currently_working,PI.did_hear, A.`hair_color`, A.`eye_color`, A.`height`, A.`shirt_size`, A.`jacket_size`, A.`pant_size`, A.`dress_size`, A.`chest_size`, A.`waist_size`, A.`hips_size`, A.`men_inseam`, A.`men_sleeve`, A.`men_neck`, A.`shoe_size`, A.`piercing_ear`, A.`tattoos`,SD.username,SD.email, UD.resume, UD.photo FROM signup_details SD
  10. JOIN personal_info PI ON SD.id = PI.emp_id
  11. JOIN uploaded_details UD ON SD.id = UD.emp_id
  12. JOIN appearance A ON SD.id = A.emp_id";
  13.  
  14. $stmt = $mysqli->prepare($query);
  15. $stmt->execute();
  16. $stmt->bind_result($id,$emp_id,$fname,$lname,$website,$phone,$sec_phone,$address,$apt_unit,$city , $state , $zip , $ec_contact , $gender,$dob,$driver_license,$reliable_vehicle, $will_travel,$currently_working,$did_hear, $hair_color, $eye_color, $height, $shirt_size, $jacket_size, $pant_size, $dress_size, $chest_size, $waist_size, $hips_size, $men_inseam, $men_sleeve, $men_neck, $shoe_size, $piercing_ear, $tattoos, $username,$email, $resume, $photo);
  17. $result = "";
  18. $i=1;
  19.  
  20. while($stmt->fetch())
  21. {
  22. $query2= "SELECT certified_in from certification_mul where emp_id=$id";
  23. $fetch_certi = $mysqli->prepare($query2);
  24. ***if(false===$fetch_certi){
  25. die('prepare() failed '.htmlspecialchars($mysqli->error));
  26. }*** // Getting Error here..
  27. $fetch_certi->execute();
  28. $fetch_certi->bind_result($certified_in);
  29.  
  30. while($fetch_certi->fetch())
  31. {
  32.  
  33. array_push($certifiedarray,$certified_in);
  34.  
  35. }
  36.  
  37. $fetch_certi->close();
  38.  
  39. echo $certify_combine = implode(",", $certifiedarray);
  40.  
  41.  
  42. $query3= "SELECT ethnicies from ethnicity_mul where emp_id=$id";
  43. $fetch_ethnic = $mysqli->prepare($query3);
  44. $fetch_ethnic->execute();
  45. $fetch_ethnic->bind_result($ethnics);
  46. while($fetch_ethnic->fetch())
  47. {
  48. array_push($ethniciesdarray,$ethnics);
  49. }
  50. $fetch_ethnic->close();
  51. echo $ethnics_combine = implode(",", $ethniciesdarray);
  52.  
  53. $query4= "SELECT experience_in from experience_in_mul where emp_id=$id";
  54. $fetch_exp = $mysqli->prepare($query4);
  55. $fetch_exp->execute();
  56. $fetch_exp->bind_result($experience_in);
  57. while($fetch_exp->fetch())
  58. {
  59. array_push($experience,$experience_in);
  60. }
  61. $fetch_exp->close();
  62. echo $exp_combine = implode(",", $experience);
  63.  
  64. $query5= "SELECT languages from lang_mul where emp_id=$id";
  65. $fetch_lang = $mysqli->prepare($query5);
  66. $fetch_lang->execute();
  67. $fetch_lang->bind_result($languages);
  68. while($fetch_lang->fetch())
  69. {
  70. array_push($language,$languages);
  71. }
  72. $fetch_lang->close();
  73. echo $lang_combine = implode(",", $language);
  74.  
  75. $query6= "SELECT workin_markets from working_market_mul where emp_id=$id";
  76. $fetch_working = $mysqli->prepare($query6);
  77. $fetch_working->execute();
  78. $fetch_working->bind_result($workin_markets);
  79. while($fetch_working->fetch())
  80. {
  81. array_push($working_in,$workin_markets);
  82. }
  83. $fetch_working->close();
  84. echo $working_combine = implode(",", $working_in);
  85. $result.="<tr><td>$i</td><td style=width:55px;>$emp_id</td><td>$fname</td><td>$lname</td><td>$username</td><td>$gender</td><td>$email</td><td>$dob</td><td>$website</td><td>$phone</td><td>$sec_phone</td><td>$address</td><td>$apt_unit</td><td>$city</td><td>$state</td><td>$zip</td><td>$ec_contact</td><td>$driver_license</td><td>$reliable_vehicle</td><td>$will_travel</td><td>$did_hear</td><td>$hair_color</td><td>$eye_color</td><td>$height</td><td>$shirt_size</td><td>$jacket_size</td><td>$pant_size</td><td>$dress_size</td><td>$chest_size</td><td>$waist_size</td><td>$hips_size</td><td>$men_inseam</td><td>$men_sleeve</td><td>$men_neck</td><td>$shoe_size</td><td>$piercing_ear</td><td>$tattoos</td><td>$currently_working</td>";
  86. $resume = $resume=="" ? "#" : "href=$resume download";
  87. $photo = $photo=="" ? "#" : "href=$photo download";
  88. /* $photo2 = $photo2=="" ? "#" : "href=$photo2 download"; */
  89. $result.="<td><a class='btn btn-primary waves-effect waves-light' $resume>Download</a></td><td><a class='btn btn-primary waves-effect waves-light' $photo>Download</a></td></td></tr>";
  90. $i++;
  91. }
  92.  
  93. $stmt->close();
  94. return $result;
  95. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement