Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getReporsData($mysqli)
- {
- $certifiedarray=array();
- $ethniciesdarray=array();
- $experience=array();
- $language=array();
- $working_in=array();
- $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
- JOIN personal_info PI ON SD.id = PI.emp_id
- JOIN uploaded_details UD ON SD.id = UD.emp_id
- JOIN appearance A ON SD.id = A.emp_id";
- $stmt = $mysqli->prepare($query);
- $stmt->execute();
- $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);
- $result = "";
- $i=1;
- while($stmt->fetch())
- {
- $query2= "SELECT certified_in from certification_mul where emp_id=$id";
- $fetch_certi = $mysqli->prepare($query2);
- ***if(false===$fetch_certi){
- die('prepare() failed '.htmlspecialchars($mysqli->error));
- }*** // Getting Error here..
- $fetch_certi->execute();
- $fetch_certi->bind_result($certified_in);
- while($fetch_certi->fetch())
- {
- array_push($certifiedarray,$certified_in);
- }
- $fetch_certi->close();
- echo $certify_combine = implode(",", $certifiedarray);
- $query3= "SELECT ethnicies from ethnicity_mul where emp_id=$id";
- $fetch_ethnic = $mysqli->prepare($query3);
- $fetch_ethnic->execute();
- $fetch_ethnic->bind_result($ethnics);
- while($fetch_ethnic->fetch())
- {
- array_push($ethniciesdarray,$ethnics);
- }
- $fetch_ethnic->close();
- echo $ethnics_combine = implode(",", $ethniciesdarray);
- $query4= "SELECT experience_in from experience_in_mul where emp_id=$id";
- $fetch_exp = $mysqli->prepare($query4);
- $fetch_exp->execute();
- $fetch_exp->bind_result($experience_in);
- while($fetch_exp->fetch())
- {
- array_push($experience,$experience_in);
- }
- $fetch_exp->close();
- echo $exp_combine = implode(",", $experience);
- $query5= "SELECT languages from lang_mul where emp_id=$id";
- $fetch_lang = $mysqli->prepare($query5);
- $fetch_lang->execute();
- $fetch_lang->bind_result($languages);
- while($fetch_lang->fetch())
- {
- array_push($language,$languages);
- }
- $fetch_lang->close();
- echo $lang_combine = implode(",", $language);
- $query6= "SELECT workin_markets from working_market_mul where emp_id=$id";
- $fetch_working = $mysqli->prepare($query6);
- $fetch_working->execute();
- $fetch_working->bind_result($workin_markets);
- while($fetch_working->fetch())
- {
- array_push($working_in,$workin_markets);
- }
- $fetch_working->close();
- echo $working_combine = implode(",", $working_in);
- $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>";
- $resume = $resume=="" ? "#" : "href=$resume download";
- $photo = $photo=="" ? "#" : "href=$photo download";
- /* $photo2 = $photo2=="" ? "#" : "href=$photo2 download"; */
- $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>";
- $i++;
- }
- $stmt->close();
- return $result;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement