/
home
/
efamember
/
domains
/
efa-member.com
/
public_html
/
backoffice
/
ajax
/
join
/
up file
home
<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); // $sql_member = "SELECT * FROM tbl_member_detail"; $sql_member = "SELECT * FROM `tbl_member_detail_worker` WHERE member_id NOT IN (SELECT member_id FROM tbl_member_document);"; $res_member = mysqli_query($connection, $sql_member); while ($row_member = mysqli_fetch_assoc($res_member)) { // echo $row_member['member_id']; // echo ','; echo $sql = "SELECT document_file1 ,document_file2 ,document_file3 ,document_file4 ,document_file5 ,document_import FROM `tbl_member_detail_worker` WHERE member_id ='{$row_member['member_id']}'"; $res = mysqli_query($connection, $sql); $row = mysqli_fetch_assoc($res); $document_id1 = getRandomID(10, 'tbl_member_document', 'document_id'); $document_id2 = getRandomID(10, 'tbl_member_document', 'document_id'); $document_id3 = getRandomID(10, 'tbl_member_document', 'document_id'); $document_id4 = getRandomID(10, 'tbl_member_document', 'document_id'); $document_id5 = getRandomID(10, 'tbl_member_document', 'document_id'); if ($row['document_file1'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id1' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_file1']}' , `document_list_order` = '1' "; $res_ins = mysqli_query($connection, $sql_ins); } if ($row['document_file2'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id2' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_file2']}' , `document_list_order` = '2' "; $res_ins = mysqli_query($connection, $sql_ins); } if ($row['document_file3'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id3' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_file3']}' , `document_list_order` = '3' "; $res_ins = mysqli_query($connection, $sql_ins); } if ($row['document_file4'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id4' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_file4']}' , `document_list_order` = '4' "; $res_ins = mysqli_query($connection, $sql_ins); } if ($row['document_file5'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id5' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_file5']}' , `document_list_order` = '5' "; $res_ins = mysqli_query($connection, $sql_ins); } if ($row['document_import'] != '') { echo $sql_ins = "INSERT INTO `tbl_member_document` SET `document_id` = '$document_id5' , `member_id` = '{$row_member['member_id']}' , `document_file_name` = '{$row['document_import']}' , `document_list_order` = '6' "; $res_ins = mysqli_query($connection, $sql_ins); } }