Singapura - Sekitar 80 perusahaan asal Guangxi, dan lebih dari 400 pembeli profesional asal
1
/*php
$hari_ini=date("Ymd");
$sebelum=mktime(0, 0, 0, date("m"), date("d") - 3, date("Y"));
$tgl_sebelumnya=date("Ymd", $sebelum);
$terkini=mysqli_query($conn, "SELECT distinct trim(SUBSTRING_INDEX(SUBSTRING_INDEX(t.tag, ',', n.n),',', -1)) as tag FROM berita t CROSS JOIN
(SELECT a.N + b.N * 10 + 1 n FROM (SELECT 0 AS N UNION ALL SELECT 1 AS N UNION ALL SELECT 2 AS N UNION ALL SELECT 3 AS N UNION ALL SELECT 4 AS N UNION ALL
SELECT 5 AS N UNION ALL SELECT 6 AS N UNION ALL SELECT 7 AS N UNION ALL SELECT 8 AS N UNION ALL SELECT 9)a ,(SELECT 0 AS N UNION ALL SELECT 1 AS N UNION ALL
SELECT 2 AS N UNION ALL SELECT 3 AS N UNION ALL SELECT 4 AS N UNION ALL SELECT 5 AS N UNION ALL SELECT 6 AS N UNION ALL SELECT 7 AS N UNION ALL
SELECT 8 AS N UNION ALL SELECT 9)b ORDER BY n ) n WHERE n.n <= 1 + (LENGTH(t.tag) - LENGTH(REPLACE(t.tag, ',', ''))) AND tag !=''
AND tanggal BETWEEN '$tgl_sebelumnya' AND '$hari_ini' ORDER BY dibaca DESC LIMIT 5;");
while($t=mysqli_fetch_array($terkini)){
$tag = explode(",",$t['tag']);
foreach($tag as $kata){
$tag_seo = seo_tag_balik($kata);
$tag_url = seo_tag($kata);
$r=mysqli_query($conn, "SELECT * FROM tag WHERE tag_seo='$t[tag]' ");
echo "