Monday, June 10, 2019

How To Make Syntax Highlighter

Have you ever found it difficult to insert code in your blog article? If so, you need the one called  syntax Highlighter

What is the Syntax highlighter?

How To Make Syntax Highlighter On Blogger

The Highlight Syntax is a kind of plugin that contains program code to make it easier to insert coding on blogger articles or other platforms.

Usually people who use syntax highlighter are people who are familiar with programming code because programming code is their daily food

But for those of you who are just learning programming code, don't worry, because this tutorial is easy for beginners to do

Here's the tutorial from Creating Highlight Syntax to bloggers.

Install Syntax highlighter CDN

First, please enter your blogger and enter the Menu >> Edit HTML

After that search for </ head> using ctrl + f and put the code below, on above </ head>

How To Make Syntax Highlighter On Blogger



<!-- 'SyntaxHighlighter' additions START -->
<link href='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/styles/shCore.css' rel='stylesheet' type='text/css'/>

<link href='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/styles/shThemeRDark.min.css' rel='stylesheet' type='text/css'/>

<script src='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/scripts/shCore.js' type='text/javascript'/>

<script src='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/scripts/shBrushPhp.js' type='text/javascript'/>
<script src='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/scripts/shBrushJScript.js' type='text/javascript'/>
<script src='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/scripts/shBrushCss.js' type='text/javascript'/>
<script src='https://cdnjs.cloudflare.com/ajax/libs/SyntaxHighlighter/3.0.83/scripts/shBrushXml.js' type='text/javascript'/>

<script language='javascript' type='text/javascript'>
    SyntaxHighlighter.config.bloggerMode = false;
    SyntaxHighlighter.all();
</script>
<!-- 'SyntaxHighlighter' additions END -->

How To Use Syntax Highlighter


Create a article and put the code below in html

How To Make Syntax Highlighter On Blogger


<pre class="brush: php">
code contains
</pre>

That's how to make a highlighter syntax, thank you

Reference: Motivasi Done

Thursday, April 26, 2018

How To Use INNER JOIN On PHPMYSQLI on 5 Tables:TUTORIAL

Hello...Come back with me at Dkrawn. In this tutorial, I will give you how to use INNER JOIN on PHPMYSQLI on 5 Tables. We know the Inner join itself is used to display data from many tables that have the same relationship.

Inner join is useful if we create comment tables, table orders or other table are connected to each other.

Okay then just follow this tutorial...

-First please see the table data used as below
Table1

Table2

Table3

Table4

Table5 

In the picture above you can know that I am using tabel1, tabel2, tabel3, tabel4 and tabel5 to connect everything using inner join.

After looking at the picture above, let's go directly to the coding show 5 tables using inner join


<table border="1px">
<tr>
                <td>Nilai Tabel 1</td>
                <td>Nilai Tabel 2</td>
                <td>Nilai Tabel 3</td>
                <td>Nilai Tabel 4</td>
               
</tr>
<?php
$koneksi=new mysqli("localhost","root","","inner_join");

$query="select * from tabel5
inner join tabel1 on tabel1.id_tabel1=tabel5.id_tabel1
inner join tabel2 on tabel2.id_tabel2=tabel5.id_tabel2
inner join tabel3 on tabel3.id_tabel3=tabel5.id_tabel3
inner join tabel4 on tabel4.id_tabel4=tabel5.id_tabel4";

$cek=mysqli_query($koneksi,$query);
while($tampil=mysqli_fetch_array($cek)){
?>
<tr>
                <td><?php echo $tampil['nama'];?></td>
                <td><?php echo $tampil['hobi'];?></td>
                <td><?php echo $tampil['kelas'];?></td>
                <td><?php echo $tampil['kelamin'];?></td>
               
</tr>
<?php
}
?>
</table>




-And this is the result



Explanation

$query="select * from tabel5
inner join tabel1 on tabel1.id_tabel1=tabel5.id_tabel1
inner join tabel2 on tabel2.id_tabel2=tabel5.id_tabel2
inner join tabel3 on tabel3.id_tabel3=tabel5.id_tabel3
inner join tabel4 on tabel4.id_tabel4=tabel5.id_tabel4";
-Use of inner join that format as below
select*from tabelpertama innerjoin tabeldua on tabeldua.id_tabeldua=tabelpertama.id_tabelpertama
that's how the use of inner join many tables in php mysqli, to better understand it you should try it directly.

You can look that is video for inner join in 5 table


If you want to download the file above, you can download file below



Download 

Saturday, November 25, 2017

9 Tips For Buying Used Cars,You Must Know It!

A car is a vehicle that is currently widely used by everyone, car can carry many people in it but also has facilities that make you feel comfortable.
To own a car, some people who have a lot of money definitely choose to buy a new car, but for people who do not have a lot of money then buying a used car is the best solution.

Here are tips to buy a used car, but quality so you will not regret in the future

1.Buy a car near your home


Buying a car near your home or where you live then this will make it easier to contact the seller if anyone wants to be asked about the car you buy.

2. Checking the car's exterior


If you already find a seller and get the desired car then the first thing you should check is the exterior of the car. Note that the body of the car that you buy it is still smooth and no scratches, pay attention to all things including glass, lights and so forth

3.Ask the car history


Asking car history is a part that is often overlooked by buyers, but this is an important part in the purchase of used cars. Asking the history of the car to buyers, then we can find out if this car ever flooded, how far this car used in a year or ask who the first owner of the car?

4.Check the car engine


The engine is a vital part for the car, if the car engine is bad, then forget it to buy the car and look for another car that is more promising.Here is the car engine that you should check:

a. Machine room

 

Open the hood and watch carefully the engine room has a new paint or not. Usually the engine room that had been painted indicates that the car engine was once derived and also can identify that the car had experienced a collision, flood or other causes

b.There is no oil seepage in the engine

 

A healthy car is a car that is free from leaks, check all parts of the engine and see if there are new or other bolts if any, then ask the seller as this may be the way the seller in covering the damage that is in the car.

c. Sounds smooth and does not stagnate when turned on

 

If the car is still in good condition, when turned on under cold engine conditions it will issue a smooth sound, immediately lit and not choked. If there is a problem here ,then there could be a problem with the car battery

d. RPM needle is stable

 

After turning on the car engine, try to step on the gas pedal and remove the gas pedal and then look at the car RPM. When the needle RPM stable up and down the condition of the car is still good

e. Exhaust gases on the exhaust

 

Take a look at where the exhaust gas or the exhaust is, if the black smoke indicates incomplete fuel combustion and if the white smoke indicates a mixture of oil in the engine combustion chamber. If you find water droplets in the exhaust, then it indicates the car engine is still good

5. Checking the Interior

Checking the interior of the car is an important part too, try to play window glass by pressing the up or down buttons, note the quality of the car seat, ac, dashboard or anything else that is part of the car. Try playing around whether it's pressing the sen light button, hazard or try to spray water to clean the windshield

6.Completeness of car letters

Of course in buying a car we have to inquire about the completeness of the car letters, by having the completeness of the original letter then it will facilitate us in the administration

7.Read Car Service Notes

A good car is a car that is often treated, this is seen from the car service record. By looking at car service records, then we can know what components have been changed to how often he car maintenance

8. Do a test drive carefully

Doing a test drive carefully here means no bad rush in doing a test drive. By doing a test drive you can feel how easy it is to turn the steering wheel, listen to the smooth sound of the car, feel comfortable when the car is on the road wavy and can test how fast this car can run. Do this test drive with the car salesman so you can ask him some questions about the car you want to buy

9. Insurance

Having insurance on the car you bought is a fortune because it indicates that the car is often used and the owner is very careful in driving it. You can also move the name of the owner of the insurance so this also allows you to have insurance on the car

That's tips on buying a used car, hopefully by reading this article you can have a car what you want.

Reference: https://www.cermati.com/artikel/7-tips-memilih-mobil-bekas-yang-berkualitas , https://www.cermati.com/artikel/5-kesalahan-umum-saat-membeli-mobil-bekas , http://otospector.co.id/8-tips-jitu-mengecek-kondisi-mesin-mobil-bekas/

How to create easy an automated Sitemap in blogger

How to create easy an automated Sitemap in blogger-Creating a sitemap on bloggers will make it easier for blog visitors to find the articles they want,In addition with the sitemap, blog will look more professional and more presentable.

This is an example of an easy-to-create sitemap and make your blog more professional
How to create an automated Sitemap in blogger
If you want to create a sitemap as above then follow the step by step below

1.Pages>>New Pages
2.Click HTML in beside compose
3.Copy this is script and paste in your html pages
<div id="bp_toc">
Loading Sitemap. Please wait....</div>
<script src="https://cdn.rawgit.com/Arlina-Design/redvision/master/daftar-isi-simple.js" type="text/javascript"></script> <script src="/feeds/posts/summary?alt=json-in-script&amp;max-results=9999&amp;callback=loadtoc" type="text/javascript"></script>
<style scoped="" type="text/css">
#comments,#Label1,#FollowByEmail1 {display:none;}
#HTML3 {visibility:hidden;}
/* CSS Full Sitemap */
#bp_toc {background:#8B0000;color:#666;margin:0 auto;padding:5px;}
span.toc-note {padding:20px;margin:0 auto;display:block;text-align:center;color:#ffcfcc;font-weight:700;text-transform:uppercase;font-size:30px;line-height:normal;}
.toc-header-col1 {padding:10px;background-color:#f5f5f5;width:250px;}
.toc-header-col2 {padding:10px;background-color:#f5f5f5;width:75px;}
.toc-header-col3 {padding:10px;background-color:#f5f5f5;width:125px;}
.toc-header-col1 a:link, .toc-header-col1 a:visited, .toc-header-col2 a:link, .toc-header-col2 a:visited, .toc-header-col3 a:link, .toc-header-col3 a:visited {font-size:13px;
text-decoration:none;color:#aaa;font-family:&#39;Roboto&#39;;font-weight:700;letter-spacing: 0.5px;}
.toc-header-col1 a:hover, .toc-header-col2 a:hover, .toc-header-col3 a:hover {
text-decoration:none;}
.toc-entry-col1, .toc-entry-col2, .toc-entry-col3 {background:#fdfdfd;padding:5px;padding-left:5px;font-size:89%}
.toc-entry-col1 a, .toc-entry-col2 a, .toc-entry-col3 a{color:#666;font-size:13px;}
.toc-entry-col1 a:hover, .toc-entry-col2 a:hover, .toc-entry-col3 a:hover{color:#cdb280;}
#bp_toc table {width:100%;margin:0 auto;counter-reset:rowNumber;}
.toc-entry-col1 {counter-increment:rowNumber;}
#bp_toc table tr td.toc-entry-col1:first-child::before {content: counter(rowNumber);min-width:1em;margin-right:0.5em;}
td.toc-entry-col2 {background:#fafafa;}
#bp_toc a{text-align:left;float:none;font-size:90%;padding:0}
</style>
How to create an automated Sitemap in blogger
4.Click Save and you can see the result

That is How to create an automated Sitemap in blogger ,if you want change background color so you can change in Background-color

How To Add Post Views Counter To Blogger

How To Add Post Views Counter To Blogger- I've been looking for some articles about adding post views to bloggers and I find an easy way to do it. Example of the view counter on the blog as below or on the blog that I use this
Counter view is to display the number of views on articles. And counter view certainly has the benefit of making visitors know which articles are most viewed so they know that the article is really useful.

The following step by step in creating a view counter on blogger:

1.Go To HTML>>Template>>Edit HTML
2.Find .showAuthor in html or you can find it with CTRL+F and write . .showAuthor



3.paste the script above all .ShowAuthor as shown below
<a expr:name='data:post.id'/> <i class='fa fa-eye'/> <span id='postviews'/> Views
First .ShowAuthor


Second .ShowAuthor

Third .ShowAuthor
4.Paste This Script above </Body> in your html as shown below
<script src='https://cdn.firebase.com/v0/firebase.js' type='text/javascript'></script>
<script>
$.each($("a[name]"), function(i, e) {
var elem = $(e).parent().find("#postviews");
var blogStats = new Firebase("https://YOUR-APP-NAME.firebaseio.com/pages/id/" + $(e).attr("name"));
blogStats.once("value", function(snapshot) {
var data = snapshot.val();
var isnew = false;
if(data == null) {
data= {};
data.value = 0;
data.url = window.location.href;
data.id = $(e).attr("name");
isnew = true;
}
elem.text(data.value);
data.value++;
if(window.location.pathname!="/")
{
if(isnew)
blogStats.set(data);
else
blogStats.child("value").set(data.value);
}
});
});
</script>

5.Save the script and then you can see the result

This is demo of post views Counter

Demo


Reference:mybloggeraide

Sunday, November 19, 2017

10 Tips For Buying A Used iPhone


To buy a new iPhone, then we need more money to get it, but if you do not trouble with money, then you should buy a new one.

Then how do people who want to have an iPhone, but do not have much money? Buy a used iPhone so it can get it cheaper.

however not everyone dares to buy a secondhand iPhone for fear of counterfeit goods or fear of being deceived, however, before buying an iPhone you should first read this article and at least make it easier for you to get the iPhone you want.

Here are 10 Tips to Buy a Used iPhone

1. Find the iPhone There is still a packing box

 

How to get to know the iPhone is original and not a replica by entering the serial number here https://checkcoverage.apple.com/ or can also check it in accordance or not with the box packaging

2. Check physical condition, Home button, Power and Volume

 

Checking the physical condition of the mobile phone is one of the basic in buying used hand phone. Here are the physical conditions you should check

a.Check mobile network and internet by entering SIM card
 

b. Check the home button and its sensitivity, make sure the button is still soft and quick to respond when pressed

c.Check the Touchscreen, you can check the sensitivity or physical condition of the existing touchscreen crack or not


d. Check the power button, make sure it is still normal when pressed


e.Check the Earphone and speakers, Make sure the issued sound is not broken and still normal 

because if the sound broke, then there is the possibility of ever submerged in water

f.Check charger and USB, Make sure there is still a charger and the hole on the USB is not loose because if there is something strange here, then you will be bothered later.


g. Check Audio jack, make sure the sound is not choked up


h.Check connectivity such as Wifi, bluetooth, GPS


i.Check the camera, you can try to do photos with flash and without flash or try to tinker with other things


j.Check battery health, how to Setting> general> usage> battery usage


3. Check the market price

 

For people who do not have a lot of money of course we should often check the market price because if not do, then we can bid too low and will not be able to get it or offer too high and make us spend more money than usual.

Read this:26 Tips For Buying A Used Smartphone or Handphone

4.Find the existing warranty


Looking for an existing iPhone warranty is already a must and if the official warranty is up, then at least we get a guarantee from the seller for a month to ensure we will not have trouble with the iPhone we buy

If the iPhone still has an official warranty, then check the regional warranty is where the iPhone country is released, example code country for iPhone that you can see in the back of the box:

• MY / A: Malaysia
• LL / A: America
• X / A: Australia
• ZP / A: Singapore, Hongkong•PA / A: Indonesia

5. Operating System can Update

 

Make sure the iPhone you buy can still update the latest operating system, the problem if it cannot update the operating system, then this will hurt us because it will not get more application support.

6.iCloud in open status

 

You can check it by going to settings> iCloud and make sure it is empty if there is any, then ask directly to the seller and ask him to issue iCloud at once turn off the Find My iPhone feature so it can not be controlled remotely.

Do reset iCloud password in place when meeting the seller by setting> iCloud> Find My Phone (Will Request iCloud password) then Erase All Contents and Settings in settings

7.Support various SIM cards


iPhone there are two types of SU (Software Unlock) and FU (Factory Unlock), and choose the FU because this model can support all SIM cards in the world

8. Find a new type of iPhone for the long term


If you want to buy the iPhone, then make sure that you buy it is a new type and not old type because by choosing a new type, then we will receive many feature from apple and besides you can sell it so can buy a newer model again

9. Knowing the difference of iPhone every type


Some of the iPhone is almost similar even distinguish only hole plugs only. Do not want to buy a used iPhone 7 but you get iPhone 6 or iPhone 6s, their designs are the same, but the only difference is the shape of the camera and jack audio. So make sure you recognize the difference of the iPhone of each type

10.Do not buy a stolen IPhone


You can check the iPhone is a stolen item or not by going to https://getsupport.apple.com then choose iPhone> Select Battery, Power&Charging> choose Unable to Power On> select Send in for Repair> and select Enter the phone's IMEI / MEID number in the box

If the iPhone is not a stolen item, then IMEI / MEID will be the same as in the settings> general> about that in the iPhone

That's 10 tips to buy a used iPhone, After reading this article, hopefully you can get the desired iPhone. If this article is useful please leave a comment or share this article

Reference: http://www.panduanmac.com/2017/05/membeli-iphone-bekas.html , https://www.lifewire.com/buying-used-iphone-guide-1999296 , https://jalantikus.com/tips/tips-beli-iphone-bekas/

Friday, November 17, 2017

26 Tips For Buying A Used Smartphone or Handphone


In today's economy the needs associated with smartphone communications are grow up. Sometimes we want to buy a quality smartphone, but are plagued with money or do not want to save a lot of money to buy a new smartphone so we want to overcome it by buying a used smartphone.

To buy a used smartphone of course we will experience the name of hesitation for fear of being deceived, the smartphone is not in accordance with the desired or smartphone that can be sold very disappointing As a buyer we do not want to experience bad things when buying used smartphones, so read 26 tips to buy used and quality smartphones so you will not be disappointed when you buy them.

1. Check the price of the smartphone being your targeted

26 Tips For Buying A Used Smartphone or Handphone

First you have to know what smartphone you are looking for and after that, you make sure to check the price smartphone it, you can check it through google, ask the market price to friends, or monitor prices in groups buy and sell

2.Join the Smartphone Sale and Purchase Group in your area


If you have not determined what smartphone you are looking for then the best option is to enter the group selling and buying smartphones in your area on facebook or other social media, but you can also monitor the market of smartphones are often sold and the smartphone market is often purchased

3. Check the Smartphone Specifications you want


After knowing what smartphone you want to buy, then you should first check the specifications and if you can select the specifications according to the needs of smartphones today

4. Check the physical condition of the smartphone before buying

 
26 Tips For Buying A Used Smartphone or Handphone

Check the physical condition of the smartphone you want to buy already there is a scratch or not because with a scratch then you have reason to bid price lower than the market price.

5. Check IMEI Number


Check the IMEI number of your smartphone by typing * # 06 # because it proves the smartphone is genuine

6. Check the smartphone battery can be durable or not


Buy a smartphone, but it can only be used for less than an hour? So, you should first check how much power the smartphone you buy, preferably more than 2000 mAh and make sure the battery can be durable.

Read this:10 Tips For Buying A Used iPhone

7. Check signal reception on smartphone


The signal receiver is one of the most important components of the smartphone, so if the receiver signal is weak should not be bought because it is useless

8. Smartphone still has warranty


If the used smartphone that you buy there is still warranty then it is your lucky because this proves that the smartphone is still not long used

9. Smartphone checks still have paper seals on the bolt or not

26 Tips For Buying A Used Smartphone or Handphone

If the smartphone you bought was not sealed or the seal is lost then it can be ascertained that the item was badly damaged and you cannot trust it

10. Do not rush to buy


The rush is a mistake that is often done by secondhand smartphone buyers because if we hurry, then we will miss the chance of coming another smartphone better and cheaper or we will ignore all the tips to buy a used smartphone here

11. Investigate sellers


If you want to buy a used smartphone from a sale or other group then you should investigate the seller's reputation first if you do not investigate using a real or fake account because by investigating later if there is a problem with the smartphone you bought, then we can easily contact him

12. Invite the Seller to meet directly


Try to meet directly when buying a used smartphone because we can check the goods directly on the spot and we can see the expression of the seller

13. Buy a smartphone that has BNOB

26 Tips For Buying A Used Smartphone or Handphone

BNOB (Brand New Open Box), by buying a smartphone like this is easier to ensure the smartphone condition is fine, but can get it at a lower price.

14. Purchased the Old Stock smartphone


Almost the same as BNOB, the difference is this old stock smartphone is usually not sold out that sold so they will lower the price, but make sure the specifications match smartphones in general in the present day

15. Bid price with 2/3 price offered


Bid price is one of the tricks to get cheaper mobile phones in general and try to bargain with the price of 2/3 the price offered then usually you will get a cheaper price than the price offered

16. Check Smartphone Completeness

26 Tips For Buying A Used Smartphone or Handphone

When buying a used smartphone then you should first check the completeness, of the completeness like headset and charger is not there so you can bid cheaper than the market price

17. Make a Safe Transaction


Make a secure transaction here by meeting face-to-face and accompanied by your friends so your friends can check your smartphone want to buy

18. Do Factory Reset the smartphone with the seller

26 Tips For Buying A Used Smartphone or Handphone

When after buying a secondhand smartphone then you should ask the seller to do factory reset on the smartphone so that passwords and things that can harm us can be lost so that the state of the smartphone just as new same the condition of the factory

19. Check your smartphone's authenticity


This is an important part make sure the smartphone you bought is original and not a replica

20. Ask the reason that why he sold it


by asking the reason that why he sold the smartphone, then we can know that he sold the smartphone because it is not a condition of a bad smartphone or something else

21. Check with a secret code


Try checking the smartphone you bought with a secret code like this to know that the condition is still good and not have a problem, here is the secret code according to the brand Samsung galaxy * # 0 * #, xiaomi mi * # * # 64633 # * # *, Asus Zenfone * # * # 4636 # * # *, Oppo * # 801 #

22. Check Booting speed


By checking the speed of booting the faster the smartphone is booting then the better conditions

23. Make sure the smartphone can be in charge


Buying a smartphone, but can not be in the charger then it's useless, otherwise make sure when the charger smartphone is not hot or suddenly filled with fast

24. Find the seller Need money


By looking for sellers who need money, then we can get a cheaper price than usual then this can be called looking for opportunities in the narrowness

25. Ask your friends for help find the used smartphone


Ask your friends for help find the smartphone you want it will be more options in buying used smartphone for cheaper

26.Buy a smartphone that can be sold again

26 Tips For Buying A Used Smartphone or Handphone

Buy a smartphone that can still be sold at a high price because if you get bored with the smartphone, then you can sell it again with high price and buy another

That's 26 Tips to buy used smartphone or used mobile phone, but cheap and good quality, hopefully after reading this article you can get the goods accordingly and satisfy

Reference: https://www.shopback.co.id/blog/berencana-beli-handphone-bekas-ini-10-tips-membeli-handphone-second, https://jalantikus.com/tips/tips-beli-smartphone-bekas/ , http://www.heyriad.com/2016/06/cara-cek-hp-android-bekas-bagus-tidak.html