php array on pdo and mysql select and display records to html table

Steps :
1) Left Join 2 tables in database to retrieve hidden setting_name and stores all of them to an php array.
2) Create full setting_name php array.
3) (left setting name) = (full setting_name) - (hidden setting_name).
4) Join elements of array with needed syntax for sql select query.
5) Join elements of array with needed syntax for header of html table.
6) Join elements of array of sql in while loop with needed syntax for displaying records to body of html table.

Codes :
$setting_name = array(); $sql = "SELECT setting_2.setting_name FROM setting_2 LEFT JOIN setting_2_of_user on setting_2.setting_id = setting_2_of_user.setting_id WHERE user_id=?"; $q = $conn->prepare($sql); $result = $q->execute(array($user_id3)); if(!$result){ die("Error Select setting_name join setting_2 table query : ". implode(" : ", $q->errorInfo())); } $i=0; while($r = $q->fetch(PDO::FETCH_ASSOC)){ $setting_name[$i] = $r[setting_name]; $i++; } $setting_name_full = array("courier", "tracking_number", "posting_date", "payment_date", "price", "product", "customer_name", "phone_number", "address", "bank", "order_from", "remarks"); $setting_name_left=array_diff($setting_name_full,$setting_name); $setting_name_left_with_sign = join(, , $setting_name_left); $setting_name_left_for_table = join(</td><td> , $setting_name_left); $sql = "SELECT " . $setting_name_left_with_sign . " FROM sale WHERE seller_id=?"; $q = $conn->prepare($sql); $result = $q->execute(array($user_id3)); if(!$result){ die("Error Select user table query : ". implode(" : ", $q->errorInfo())); //if dont use implode, output of errorInfo() will be "Array". } echo "<table id="tblContent1" class="table-with-border" style="text-align:center;"> <tr><td>No</td><td>" . $setting_name_left_for_table . "</td></tr>"; $count = $q->rowCount(); if ($count == 0){ echo "<script type="text/javascript"> document.getElementById(no-record-msg).style.display = inline; </script>"; echo "<script type="text/javascript"> document.getElementById(tblContent1).style.display = none;</script>"; } else { $no_count=0; while($r = $q->fetch(PDO::FETCH_ASSOC)){ foreach ($r as $name => $value) { if ($name == "price"){ $r[$name] = "usd" . $value; } } $gg = join(</td><td>, $r); echo "<tr><td>" . $no_count . "</td><td>" . $gg . "</td></tr>"; $no_count = $no_count + 1; } echo "</table>"; }

Related Posts by Categories