function getPowerArrayForLens($lensID) { $sql = "\n\tSELECT *\n\tFROM pn_lenses_powers\n\tWHERE lensID = {$lensID} \n\t"; $results = doQuery($sql); //print_r($results); //$returnArray = array(); if ($results['head']['status'] == 1) { $powerLists = makeLists($results['body']); //print_r($powerLists); if ($powerLists) { $returnArray = array('head' => array('status' => '1', 'error_number' => '', 'error_message' => ''), 'body' => $powerLists[$lensID]); } } if (!isset($returnArray)) { $returnArray = array('head' => array('status' => '0', 'error_number' => '404', 'error_message' => 'Data not found'), 'body' => array()); } // print_r($returnArray); return $returnArray; }
</div> </div> <div class="demo-options mdl-shadow--2dp mdl-color--white mdl-cell mdl-cell--6-col"> <div> <label>Continents</label> <select id="continents"> <option value="" disabled selected>Choose your option</option> <?php makeLists($result3); ?> </select> </div> <div id="spinner" class="mdl-spinner mdl-js-spinner is-active"></div> <table id="table" class="mdl-data-table mdl-js-data-table"> <thead> <tr> <th class="mdl-data-table__cell--non-numeric">City</th> <th>Visits</th> </tr> </thead> <tbody id="tbody">
function updatePowerListsTable($lensID) { //return; $mysqli = DBAccess::getConnection(); //$mysqli = new mysqli('mysql.eyedock.com', 'eyedockdatauser', 'kvBS^VQR', 'eyedock_data'); //$mysqli = new mysqli('mysql.eyedock.com', 'eyedockdatauser', 'kvBS^VQR', 'eyedock_data'); //get the rows from lenses_powers table for this lens (these values are listed in ranges) $sql = "SELECT * FROM pn_lenses_powers WHERE lensID = {$lensID} "; $result = $mysqli->selectQuery($sql); $resultArr[] = $result->fetch_array(MYSQLI_ASSOC); $powerArray = makeLists($resultArr); foreach ($powerArray[$lensID] as $row) { //create the data to insert into the power_lists table $id = $row['id']; $lensID = $row['lensID']; $variation = $row['variation']; $baseCurve = implode(",", $row['baseCurve']); $diameter = implode(",", $row['diameter']); $sphere = implode(",", $row['sphere']); if ($row['cylinder'] != "") { $cylinder = implode(",", $row['cylinder']); } if ($row['axis'] != "") { $axis = implode(",", $row['axis']); } if ($row['addPwr'] != "") { $addPwr = implode(",", $row['addPwr']); } if ($row['colors_enh'] != "") { $colors_enh = implode(",", $row['colors_enh']); } if ($row['colors_opq'] != "") { $colors_opq = implode(",", $row['colors_opq']); } //check to see if the rows already exist in the power_lists table $sql = "SELECT 1 FROM pn_lenses_power_lists WHERE id =" . $row['id']; $result = $mysqli->selectQuery($sql); $count = $result->num_rows; //echo "<p>sql: " . $sql . "</p>"; //echo "<p>count: " . $count . "</p>"; if ($count < 1) { $insertSQL = "INSERT INTO pn_lenses_power_lists (id, lensID, variation, baseCurve, diameter, sphere, cylinder, axis, addPwr, colors_enh, colors_opq) \n\t\tVALUES (\n\t\t\n\t\t\t" . $id . " , \n\t\t\t" . $lensID . ",\n\t\t\t'" . $variation . "', \n\t\t\t'" . $baseCurve . "',\n\t\t\t'" . $diameter . "', \n\t\t\t'" . $sphere . "', \n\t\t\t'" . $cylinder . "', \n\t\t\t'" . $axis . "', \n\t\t\t'" . $addPwr . "', \n\t\t\t'" . $colors_enh . "', \n\t\t\t'" . $colors_opq . "'\n\t\t)"; } else { //if the row did exist we'll update it $insertSQL = "UPDATE pn_lenses_power_lists SET \n\t\t\tid = " . $id . ", \n\t\t\tlensID = " . $lensID . ", \n\t\t\tvariation = '" . $variation . "', \n\t\t\tbaseCurve = '" . $baseCurve . "', \n\t\t\tdiameter = '" . $diameter . "', \n\t\t\tsphere = '" . $sphere . "',\n\t\t\tcylinder = '" . $cylinder . "', \n\t\t\taxis = '" . $axis . "', \n\t\t\taddPwr = '" . $addPwr . "', \n\t\t\tcolors_enh = '" . $colors_enh . "', \n\t\t\tcolors_opq = '" . $colors_opq . "' \n\t\t\t WHERE id = " . $id . "\n\t\t\t"; } //echo ($insertSQL); $resultarr[] = $mysqli->selectQuery($insertSQL); } // go to the next row . . . return $resultarr; }