Advertisement
Guest User

Untitled

a guest
Apr 4th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. $tablenames = array("staging"/*,"clients","meters","tests","costs","workorders"*/);
  2.  
  3. for($tableno = 0;$tableno < sizeof($tablenames);$tableno++){
  4. $q = "";
  5. $q2 = "";
  6. $q3 = "";
  7. $q4 = "";
  8. $q5 = "";
  9. $q6 = "";
  10. $col_list = '`'.str_replace(',','`,`',$table_cols[$tableno]).'`';
  11. $q .= "INSERT INTO ".$tablenames[$tableno]." (".$col_list.") VALUES (";
  12. $last_id = mysqli_insert_id($connect);
  13. $cols = explode(",",$table_cols[$tableno]);
  14. $data = array();
  15. foreach($cols as $key => $fldname) {
  16. $data[] = "'".$coldata[$fldname]."'";
  17. }
  18.  
  19. /*INSERT INTO STAGING TABLE - INITAL CSV UPLOAD*/
  20. $q .= implode(",",$data).");";
  21.  
  22. /*INSERT INTO CLIENTS TABLE FROM STAGING TABLE*/
  23. $q2 .= "INSERT INTO clients (orderNumber,place,workOrderNum,lowSideMIUNum,highSideMIUNum,accountNum,custName,address,locID,date,utility,serialNumber,serviceName,address2,servicePreformed)
  24. SELECT orderNumber,place,workOrderNum,lowSideMIUNum,highSideMIUNum,accountNum,custName,address,locID,date,utility,serialNumber,serviceName,address2,servicePreformed
  25. FROM staging
  26. WHERE StageID = (SELECT MAX(StageID)FROM staging);";
  27.  
  28. <?php
  29. $host = '';
  30. $username = '';
  31. $password = '';
  32. $database = '';
  33. $conn = new mysqli($host,$username,$password,$database);
  34. $sql = "SELECT * FROM your_table";
  35. $result = $conn->query($sql);
  36. if(!$result) {
  37. echo "SQL Error : ".$sql."<br>Error : ".$conn->error."<br>";
  38. } else {
  39. echo '<table><tr><th>ID</th><th>VALUE</th><th>DATE</th></tr>';
  40. while($row = $result->fetch_assoc()) {
  41. echo '<tr><td>'.$row['id'].'</td><td>'.$row['value'].'</td><td>'.$row['date'].'</td></tr>';
  42. }
  43. echo '</table>';
  44. }
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement