{"id":738,"date":"2011-11-29T05:55:41","date_gmt":"2011-11-29T05:55:41","guid":{"rendered":"http:\/\/dwijim.wordpress.com\/?p=738"},"modified":"2011-11-29T05:55:41","modified_gmt":"2011-11-29T05:55:41","slug":"script-php-untuk-menghitung-jumlah-sms-yang-masuk","status":"publish","type":"post","link":"https:\/\/dosen.unila.ac.id\/0011066803\/2011\/11\/29\/script-php-untuk-menghitung-jumlah-sms-yang-masuk\/","title":{"rendered":"Script PHP untuk menghitung jumlah SMS yang masuk &#8230;"},"content":{"rendered":"<pre>\n&lt;?php\n\/* ----------------------------------------------------------\n   program untuk menghitung banyaknya SMS yang masuk\n   dengan isi SMS yang sama, ini terkait dengan tugas\n   untuk mengirim SMS sebanyak 212 kali dengan isi SMS\n   yang sama.\n   nama berkas  : rekap__sms.php\n   last editing : 29 november 2011\n   program ini memerlukan tabel inbox sesuai standar gammu\n   dan tabel jumlah_sms\n   +---------+-----------+------+-----+---------+-------+\n   | Field   | Type      | Null | Key | Default | Extra |\n   +---------+-----------+------+-----+---------+-------+\n   | isi_sms | char(160) | NO   | PRI | NULL    |       |\n   | jumlah  | int(3)    | YES  |     | NULL    |       |\n   +---------+-----------+------+-----+---------+-------+\n   ---------------------------------------------------------- *\/\nmysql_connect(&#039;localhost&#039;,&#039;root&#039;,&#039;&#039;);\n\/\/ koneksi ke server basis data\n\nmysql_select_db(&#039;bisnis_sms&#039;);\n\/\/ memilih basis data yang akan digunakan\n\nmysql_query(&quot;truncate table jumlah_sms&quot;);\n\/\/ menghapus isi tabek rekap supaya diawalai dari posisi netral\n\n$kueri = &quot;select TextDecoded,SenderNumber from inbox\n          where day(ReceivingDateTime)=23 or\n                day(ReceivingDateTime)=24 &quot;;\n\/\/ kueri untuk membaca isi sms pada tabel inbox\n\/\/ pada sms yang masuk tanggal 23 atau 24\n\n$hasil_kueri = mysql_query($kueri);\n\/\/ hasil kueri disimpan ke suatu variabel\n\nwhile ($isi_sms = mysql_fetch_row($hasil_kueri))\n\/\/ memotong-motong hasil kueri dan diloop\n\/\/ dari data pertama sampai data terakhir\n\n   {\n\/\/      echo &quot;$isi_sms[0] - $isi_sms[1] <br>\";\n\t  \n\t  $ada = 0;\n\t  \/\/ untuk penanda isi sms sudah ada atau belum\n\t  \n\t  $kueri_cari = \"select isi_sms from jumlah_sms\n\t                  where isi_sms = '$isi_sms[0]'\n\t                \";\n\t  \/\/ mencari isi SMS yang sama\n\t  \n\t  $hasil_cari = mysql_query($kueri_cari);\n      while ($cari = mysql_fetch_row($hasil_cari))\n        { $ada = 1; }\n\t\t\/\/ jika ada, masuk looping, $ada diganti nilainya\n\t\t\n      if ($ada==0)\n         {\n           $kueri_simpan = \"insert into jumlah_sms(isi_sms,jumlah)\n\t\t                    values ('$isi_sms[0]',1)\";\n\t\t\tmysql_query($kueri_simpan);\t\t\t\t \n\t\t\t\/\/ dari baru maka insert into dan nilainya awal 1\n         }\t\t \n\t   else\t \n         {\n           $kueri_simpan = \"update jumlah_sms set jumlah=jumlah+1\n\t\t                    where isi_sms ='$isi_sms[0]'\";\n\t\t\tmysql_query($kueri_simpan);\t\t\t\t \n\t\t\t\/\/ data sudah ada maka jumlahnya ditambah dengan 1\n         }\t\t \n   }\n?&gt;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&lt;?php \/* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- program untuk menghitung banyaknya SMS yang masuk dengan isi SMS yang sama, ini terkait dengan tugas untuk mengirim SMS sebanyak 212 kali dengan isi SMS yang sama. &hellip; <a class=\"readmore\" href=\"https:\/\/dosen.unila.ac.id\/0011066803\/2011\/11\/29\/script-php-untuk-menghitung-jumlah-sms-yang-masuk\/\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-738","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/posts\/738"}],"collection":[{"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/comments?post=738"}],"version-history":[{"count":0,"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/posts\/738\/revisions"}],"wp:attachment":[{"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/media?parent=738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/categories?post=738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dosen.unila.ac.id\/0011066803\/wp-json\/wp\/v2\/tags?post=738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}