Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $tablenames = array("staging"/*,"clients","meters","tests","costs","workorders"*/);
- for($tableno = 0;$tableno < sizeof($tablenames);$tableno++){
- $q = "";
- $q2 = "";
- $q3 = "";
- $q4 = "";
- $q5 = "";
- $q6 = "";
- $col_list = '`'.str_replace(',','`,`',$table_cols[$tableno]).'`';
- $q .= "INSERT INTO ".$tablenames[$tableno]." (".$col_list.") VALUES (";
- $last_id = mysqli_insert_id($connect);
- $cols = explode(",",$table_cols[$tableno]);
- $data = array();
- foreach($cols as $key => $fldname) {
- $data[] = "'".$coldata[$fldname]."'";
- }
- /*INSERT INTO STAGING TABLE - INITAL CSV UPLOAD*/
- $q .= implode(",",$data).");";
- /*INSERT INTO CLIENTS TABLE FROM STAGING TABLE*/
- $q2 .= "INSERT INTO clients (orderNumber,place,workOrderNum,lowSideMIUNum,highSideMIUNum,accountNum,custName,address,locID,date,utility,serialNumber,serviceName,address2,servicePreformed)
- SELECT orderNumber,place,workOrderNum,lowSideMIUNum,highSideMIUNum,accountNum,custName,address,locID,date,utility,serialNumber,serviceName,address2,servicePreformed
- FROM staging
- WHERE StageID = (SELECT MAX(StageID)FROM staging);";
- <?php
- $host = '';
- $username = '';
- $password = '';
- $database = '';
- $conn = new mysqli($host,$username,$password,$database);
- $sql = "SELECT * FROM your_table";
- $result = $conn->query($sql);
- if(!$result) {
- echo "SQL Error : ".$sql."<br>Error : ".$conn->error."<br>";
- } else {
- echo '<table><tr><th>ID</th><th>VALUE</th><th>DATE</th></tr>';
- while($row = $result->fetch_assoc()) {
- echo '<tr><td>'.$row['id'].'</td><td>'.$row['value'].'</td><td>'.$row['date'].'</td></tr>';
- }
- echo '</table>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement