I have a table in a sample Database:
- id: 1
- smallest size: 23
- biggest size: 27
- id: 2
- smallest size: 37
- largest size: 43.
I want to display the data like this:
- id: 1
- size: 23 24 25 26 27 0 0
- id: 2
- size: 37 38 39 40 41 42 43
More specifically I want only 7 size units to be appeared, if there are less than 7 then it will display zeros(0).
$U = array();
$k=0;
for($i=$y['ukuran_terkecil']; $i <= $y['ukuran_terbesar'] ; $i++) {
$U[$k]= $i;
$k++;
}
//print_r($U);
//echo implode("", $U);
if(empty($U[0]))
{
$U[0]= 0;
}else {
$U[0] = $U[0];
}
if(empty($U[1]))
{
$U[1]= 0;
}else {
$U[1] = $U[1];
}
if(empty($U[2]))
{
$U[2]= 0;
}else {
$U[2] = $U[2];
}
if(empty($U[3]))
{
$U[3]= 0;
}else {
$U[3] = $U[3];
}
if(empty($U[4]))
{
$U[4]= 0;
}else {
$U[4] = $U[4];
}
if(empty($U[5]))
{
$U[5]= 0;
}else {
$U[5] = $U[5];
}
if(empty($U[6]))
{
$U[6]= 0;
}else {
$U[6] = $U[6];
}
echo “<tr><td>$U[0]<br>$U[1]<br>$U[2]<br>$U[3]<br>$U[4]<br>$U[5]<br>$U[6]</td></tr>”;
$y : query select
But output is:
- Id 1 : 23 24 25 26 27 0 0
- Id 2 : 23 24 25 26 27 37 38
Sample Data:
$data = array (
0 =>
array (
0 => '0C529E7D34AE7196',
'id' => '0C529E7D34AE7196',
1 => '0',
'stoksatu' => '0',
2 => '0',
'stokdua' => '0',
3 => '2',
'stoktiga' => '2',
4 => '2',
'stokempat' => '2',
5 => '2',
'stoklima' => '2',
6 => '1',
'stokenam' => '1',
7 => '2',
'stoktujuh' => '2',
8 => '2C2C243A1C7A',
'warna' => '2C2C243A1C7A',
9 => '37',
'ukuran_terkecil' => '37',
10 => '43',
'ukuran_terbesar' => '43',
11 => 'hugob026.png',
'foto' => 'hugob026.png',
12 => 'SpHu26Co.png',
'qrcode' => 'SpHu26Co.png',
13 => '3A340C6CF62780C7',
'nama_model' => '3A340C6CF62780C7',
14 => '0C52CCD7EDB3',
'nama_merk' => '0C52CCD7EDB3',
),
1 =>
array (
0 => '281E300870803B0E',
'id' => '281E300870803B0E',
1 => '2',
'stoksatu' => '2',
2 => '2',
'stokdua' => '2',
3 => '2',
'stoktiga' => '2',
4 => '1',
'stokempat' => '1',
5 => '0',
'stoklima' => '0',
6 => '0',
'stokenam' => '0',
7 => '0',
'stoktujuh' => '0',
8 => '3A0C5ADCC9',
'warna' => '3A0C5ADCC9',
9 => '24',
'ukuran_terkecil' => '24',
10 => '27',
'ukuran_terbesar' => '27',
11 => '3.PNG',
'foto' => '3.PNG',
12 => 'ArSaeeHi.png',
'qrcode' => 'ArSaeeHi.png',
13 => '0C70AE351850C0',
'nama_model' => '0C70AE351850C0',
14 => '281E5EC4FB9763',
'nama_merk' => '281E5EC4FB9763',
),
2 =>
array (
0 => '222C60825DE2FF870572',
'id' => '222C60825DE2FF870572',
1 => '1',
'stoksatu' => '1',
2 => '1',
'stokdua' => '1',
3 => '2',
'stoktiga' => '2',
4 => '1',
'stokempat' => '1',
5 => '2',
'stoklima' => '2',
6 => '0',
'stokenam' => '0',
7 => '0',
'stoktujuh' => '0',
8 => '3A0C5ADCC979F88965B6',
'warna' => '3A0C5ADCC979F88965B6',
9 => '40',
'ukuran_terkecil' => '40',
10 => '44',
'ukuran_terbesar' => '44',
11 => 'IMG-20190428-WA0018.jpg',
'foto' => 'IMG-20190428-WA0018.jpg',
12 => 'DaItyyHiPi.png',
'qrcode' => 'DaItyyHiPi.png',
13 => '38327AAC01',
'nama_model' => '38327AAC01',
14 => '222C2A262404',
'nama_merk' => '222C2A262404',
),
);
$t=mysqli_query($kns,"select
stok.id_stok as id,
stok.st_satu as stoksatu,
stok.st_dua as stokdua,
stok.st_tiga as stoktiga,
stok.st_empat as stokempat,
stok.st_lima as stoklima,
stok.st_enam as stokenam,
stok.st_tujuh as stoktujuh,
stok.warna as warna,
stok.ukuran_terkecil as ukuran_terkecil,
stok.ukuran_terbesar as ukuran_terbesar,
stok.foto as foto,
stok.qrcode as qrcode,
model.nama_model as nama_model,
merk.nama_merk as nama_merk
FROM stok INNER JOIN model ON stok.id_model=model.id_model INNER JOIN merk ON model.id_merk=merk.id_merk") or die(mysqli_error());
if(mysqli_num_rows($t)>0){
while ($y=mysqli_fetch_array($t)) {
$mrk = implode("", DekripCBC($y['nama_merk']));
$mdl = implode("", DekripCBC($y['nama_model']));
$wr = implode("", DekripCBC($y['warna']));
$no++;
echo "<tr>
<td>$no</td>
<td>$mrk $mdl $wr<br><br>
<img src=view/foto_sepatu/$y[foto] width=140px>
</td>
<td></td>
<td>$y[stoksatu]<br> $y[stokdua]<br>$y[stoktiga]<br>$y[stokempat]<br>$y[stoklima]<br>$y[stokenam]<br>$y[stoktujuh]</td>
</tr>
";
}
}
else{
echo "<tr>
<td colspan=5><center>Data Tidak Ada</center></td>
</tr>";
}
[
]
