How to added to an existing table on SQL server 2005 or above

You can do it by edit of table design, if you want do it with query see following.






Note: Use WITH VALUES to update existing null-able rows.






Note: WITH VALUES handles the NOT NULL part






try this for adding existing table


Cara mengatasi Boomb Click Iklan Adsense

Apa itu AdsShield? AdsShield adalah anti click/spam untuk Adsense. Cara kerja scriptnya bagaimana? Script ini bekerja dengan cara dengan mendeteksi klik dari pengunjung sehingga jika terjadi klik lebih dari nilai yang sudah di atur, iklan akan menghilang dari pengunjung tadi. Iklan menghilang karena iklan tersebut berada dalam area tag.

adsense tutorial

yang berisi class AdsShield. Jadi jika ada iklan di area tersebut di klik sebanyak pengaturan maksimal klik, area tersebut termasuk iklan di dalamnya akan menghilang dari pengunjung.

Namun, ada beberapa bug yang masih ada dalam script ini. Berikut daftar bugnya:
Jika pengunjung mengklik dengan cara CTRL + Click dan juga klik kanan lalu open link new tab, jumlah klik tidak akan terdeteksi.
Jika pengunjung menggunakan TAB untuk menuju link pada saat kursor mouse berada pada iklan, akan terhitung sebagai klik.
Hanya bekerja pada web browser terbaru seperti Chrome, Firefox, dan IE.
Untuk cara pakai, silahkan paste kode di bawah ini ke atas kode template anda.

<a href=""></a>

Jangan lupa pastikan sudah ada jQuery yang terinstall di website anda. Jika belum silahkan tambahkan kode berikut di atas kode juga.

<a href=""></a>

Jika sudah, pakai kode berikut ini setiap kali ingin menambahkan iklan.


Kode ini bukan hanya untuk Adsense, melainkan untuk semua jenis iklan.

Sekian artikel saya kali ini. Jika ada kurang atau salah mohon dimaklumi karena saya masih newbie.

martinsville race 2016 nascar race

MARTINSVILLE, Va. — Kyle Busch came to Martinsville Speedway this weekend with no grandfather clock trophies, the traditional award for winning at the shortest and tightest of the NASCAR Sprint Cup Series short tracks.

nascar 2016

He left with two such clocks after completing an unprecedented Martinsville sweep in Sunday’s STP 500, and, appropriately, coyly radioed a single question to his crew after his celebratory burnouts.

“What time is it?” crowed the reigning series champion, who a day earlier had won the NASCAR Camping World Truck Series at Martinsville in his own equipment.

MORE: Busch wins OT Truck race at Martinsville

Then, Busch answered his own question.

“Time to tell the haters to shut up!” Busch shouted in a reference to the rocky relationship the Joe Gibbs Racing driver sometimes enjoys with the NASCAR fan base.

Busch can be forgiven for his over-the-top exclamation. With the victory, he’s all but assured of defending his 2015 championship in this year’s Chase for the NASCAR Sprint Cup.

“I can’t say enough about this whole JGR team,” said Busch, who led the final 173 laps after passing teammate Matt Kenseth for the top spot. “The (No. 18) M&M’s Camry was awesome in practice (on Saturday). We had a really good car through practice, and (crew chief) Adam (Stevens) made some really good adjustments overnight to keep us where we needed to be, running up front all day.”

In fact, Busch led 352 of the 500 laps on the way to his first victory of the season and the 35th of his career. The 352 laps led were the most at Martinsville since Bobby Hamilton dominated the Apr. 20, 1998 Sprint Cup race at the .526-mile track, winning from the pole and leading 378 circuits.


nascar 2016 usa

For the final restart on Lap 489, after caution had slowed the race for the eighth time when Jamie McMurray shredded a tire and lost control in Turn 2, Busch pulled away to cross the finish line .663 seconds ahead of AJ Allmendinger.

Allmendinger matched his career-best Sprint Cup finish on an oval track, with his previous second place coming at Martinsville in 2012. Moreover, it was Allmendinger’s first top five since he won at the Watkins Glen International road course in August 2014 and qualified for the Chase for the only time in his career.

“God, I wish we had one more spot,” said Allmendinger, who restarted third with 12 laps left, forced his way past Kenseth and spent the final 10 laps in an all-out — albeit futile — attempt to run down Busch before the finish.

“We got our car really, really good on the long runs,” he continued. “That’s kind of where I thought we shined. We didn’t have great short-run speed, but after about 30, 40 laps we could really get rolling there. I was kind of hoping we’d stay green the last 120 laps. I figured that wasn’t going to happen, but I was praying we had a shot at that, because I felt like if that happened, we had a great chance to win the race.”

Kyle Larson, who, like Busch, competed in Saturday’s truck race, used the extra track time to full benefit in finishing third in the Cup race, one spot ahead of Austin Dillon, who stayed out on old tires for the final restart (as did Busch, Kenseth and Allmendinger).

Brad Keselowski recovered from a Lap 93 pit road-speeding penalty to run fifth. Carl Edwards, who started 25th and spent much of the race a lap down, fought back to finish sixth. Brian Vickers, Paul Menard, Jimmie Johnson and Ryan Newman completed the top 10.

Polesitter Joey Logano struggled with the handling of his car from the outset. Busch put him a lap down on Lap 76, but Logano recovered to finish 11th, despite so much damage to the nose of the No. 22 Ford that he finished the race with his hood flapping above the engine compartment.

MORE: Martinsville brings out angry old men in Penske cars

Denny Hamlin, who was a pre-race favorite, wheel-hopped his No. 11 Toyota into the Turn 1 wall on Lap 220 and retired from the race in 39th place.

MORE: Hamlin hits wall, ends day

Dale Earnhardt Jr. and Kevin Harvick were shuffled back during the final restart and finished 14th and 17th, respectively. Harvick retained the series lead by four points over Johnson and five points over Busch.

Hung on the outside on the final restart, Kenseth dropped to 15th after Allmendinger passed him. Danica Patrick came home 16th, her best result so far this season.

Leak boosts Panama’s image

[PANAMA] A huge data leak from a law firm in Panama suggesting it hid billions of dollars in assets of global politicians, sports stars and entertainers threatened Sunday to dramatically boost the country’s reputation as an offshore haven for money laundering.

panama video

Panama, a small nation of just four million people, has a booming financial services sector that, including revenue from its famous canal, accounts for nearly 80 per cent of gross domestic product.

It has one of the best sustained economic growth rates in Latin America, low inflation, and uses the US dollar as its currency.

Successive governments have strenuously sought to portray the country as a business-friendly financial hub akin to Singapore that actively encourages banking and investment.

But they have found it hard to shake a widely held image of Panama as a place where shady deals are done in secret to hide money from tax authorities and launder the proceeds of the rich, the powerful and the criminal.

After coming under heavy scrutiny in recent years from other countries, especially the United States, Panama has cleaned up its act somewhat, enough to get off an international “blacklist” of suspected money-laundering states.

In February, Panama was also taken off a “gray list” of nations with lax financial laws, but still flagged as having deficiencies in fighting money laundering.

Sunday’s revelations, published under the title “The Panama Papers,” could put the progress it has made at risk.

Although the media investigation into the data leak notes that many of the transactions may not in themselves be illegal, they were often politically unpalatable – and were facilitated by Panama’s tardiness in fully applying international transparency rules.

Despite foreign pressure Panama has dragged it feet on exchanging financial information with other countries and lifting its banking secrecy.

“Panama has become the most opaque place on earth,” the director of the Center for Tax Policy in the Organisation for Economic Cooperation and Development (OECD), Pascal Saint-Amans, told France’s iTele network on Sunday.

The Tax Justice Network, an advocacy group, in December said: “Panama thumbs its nose at transparency.”

Transparency International, a corruption watchdog, ranks the country 72 out of 168 in the world (168 being the least transparent), with a pretty secretive financial system put at 14 out of 71 jurisdictions.

Last month, Panama’s Foreign Minister and Vice President Isabel De Saint Malo told BBC radio her country was “completely committed” to exchanging financial information.

But she said Panama was “concerned about the cost to our financial institutions” under proposed reporting guidelines.

She was also asked specifically about the Panama-based law firm at the centre of the data leak scandal, Mossack Fonseca, and its role in a huge bribery case unfolding in Brazil involving the state oil company Petrobras.

“I think that needs to be cleared up,” she admitted in the March 7 interview.

She stated, however: “Our financial sector abides by the highest standards internationally.”

The Washington-based International Consortium of Investigative Journalism said the extensive investigation detailed the offshore holdings of a dozen current and former world leaders, as well as businessmen, criminals, celebrities and sports stars.

panama2 video

The allegations were published by more than 100 news organisations around the world, and the German newspaper Sueddeutsche Zeitung, which first received the data more than a year ago, said it was confident the material was genuine.

The Munich-based daily was offered the data through an encrypted channel by an anonymous source who requested no monetary compensation, said Bastian Obermayer, a reporter for the paper.

The data concerned internal documents from a Panama-based law firm, Mossack Fonseca. Founded by German-born Juergen Mossack, the company has offices across the globe and is among the world’s biggest creators of shell companies, the newspaper said.

Ramon Fonseca of Mossack Fonseca said the firm had no control of how its clients might use offshore vehicles created for them.

“We are not responsible for the actions of a corporation that we set up,” he told Panama’s Channel 2.

ICIJ said the law firm’s internal files contain information on 214,488 offshore entities connected to people in more than 200 countries and territories, and it thought it was the biggest leak journalists had ever worked on.

Among the countries with past or present political figures named in the reports are Iceland, Ukraine, Pakistan, Saudi Arabia, Russia and Argentina.

The Guardian newspaper, which took part in the investigation, published a video on its website showing an interview with Iceland’s prime minister, Sigmundur David Gunnlaugsson conducted by Sweden’s SVT television.

He is asked about a company called Wintris, and responds by insisting that its affairs are above board and calling the question “completely inappropriate” before breaking off the interview.

In Russia, the Kremlin last week said it was anticipating what it called an upcoming “information attack”.

Vladimir Putin’s spokesman, Dmitry Peskov, told reporters the Kremlin had received “a series of questions in a rude manner” from an organisation that he said was trying to smear the Russian president.

“Journalists and members of other organisations have been actively trying to discredit Putin and this country’s leadership,” Mr Peskov said.

The office of Argentina’s president, Mauricio Macri, confirmed the business group owned by his family set up Fleg Trading, an offshore company based in the Bahamas.

But it said Mr Macri himself had no shares in Fleg and never received income from it.

The ICIJ said the documents included emails, financial spreadsheets, passports and corporate records detailing how powerful figures used banks, law firms and offshore shell companies to hide their assets. The data spanned nearly 40 years, from 1977 through to the end of 2015.

According to the media group’s website, global banks including HSBC, UBS, Credit Suisse, Deutsche Bank and others have worked with Mossack Fonseca to create offshore accounts.

“The allegations are historical, in some cases dating back 20 years, pre-dating our significant, well-publicised reforms implemented over the last few years,” HSBC spokesman Rob Sherman said.

“We work closely with the authorities to fight financial crime and implement sanctions.”

Panama’s president said his government will co-operate “vigorously” with any judicial investigation arising from the leak.

President Juan Carlos Varela said the revelations should not detract from his government’s “zero tolerance” for any illicit activities in Panama’s finance industry.

WPAP art tutorials point by scratch

Amazing collection of WPAP (Wedha’s Pop Art Portrait) portrait Illustrations, by best WPAP artists and designers. WPAP Art is made using straight lines and sharp, vibrant, contrasting fills. The inspiring wpap art illustrations will surely mesmerize you and stir your imagination. I hope you will enjoy the WPAP examples and WPAP tutorials will helpful to create Geometric, WPAP Art Portrait in Illustrator and Photoshop.

wpap tutorial1

What is WPAP Art?
Wedha Abdul Rashid has worked as an illustrator for the press industry since the 1970s, developing portraits of important figures from all backgrounds: politicians, musicians, artists, and fictional characters.

In the early 90’s, Wedha started to illustrate faces formed by single lines and strong colors, inspired by the cubist style. He then proceeded to draw these faces according to true dimensions, using a mosaic of colors. (by talenthouse)

wpap tutorial 2


Wedha, originally from Indonesia, created his art work in traditional mediums early in the 1990s, which later in early 2000, crossed over into the digital world. Vector being the natural choice for such a colorful, geometric style.

Since then, it has gained major popularity in Indonesia, with several communities dedicated to the creation and showcasing of portraits in a WPAP style, with members in their thousands! With the resurgence of the geometric trend, it’s fair to say that WPAP may venture out of Indonesia and into more aspects of design.

The following is a tutorial on how to create a WPAP (Wedha’s Pop Art Portrait) portrait in Adobe Illustrator, by the WPAP master himself!

By the way, although there’s no shortcut to creating Wedha’s exact WPAP style, you can apply some wonderful effects to portraits in a single click with Geometric Pop Art,

WPAP’s main goal is to represent the faces that are already familiar to us, with a new and different style, but it still must be easily recognizable. Different in a sense of being more unique, more dynamic, more striking and of course, more visually pleasing to see, I hope.

With that in mind, the WPAP creative process is based on two main processes; the faceting process and the coloring process. I do these two processes simultaneously when creating a new portrait.

In the faceting process, by tracing the image, I divide the human face into facets. Every facet (plane) is formed based on the different degrees of dark and bright areas seen on the original photo. Every facet is formed by straight lines, instead of curved lines. This is because facets that are formed by straight lines will appear stronger than a facet formed by curved lines.

Before we start the process, we should begin to see and assume the face of a human being as a shape that consists of many flat surfaces on a sphere, just like the ball in the below image. This is how best to describe the faceting process.


In coloring, to show something stronger, I only use flat colors, instead of a gradual colors. Although the colors look as if they collide with each other, effort should be made to make it look three-dimensional.

Creative experts will classify colors in groups. You have groups of hot colors, warm colors, cold colors. Think of them in terms of dark and light colors, ignoring the actual hue. Think more of colors in highlights, mid-tones and shadow. The differences in these groups make it possible for us to make a dimensional composition. No matter what color you choose, as long as you pick it from the right group, the result should work well in this format. Therefore it is important to experiment with color.

The faceting process is based on photo tracing. So the photo selection is important because a good photo in quality, image sharpness, lighting and resolution, will help you to create a good final rendering of a WPAP piece.

Aim for a photo that has even lighting and does not hit extremes, either in light or shadow. Also make sure that the image is sharp and in focus. For this tutorial I’m going to be creating a portrait of my beloved Grand Daughter, Ola


I usually start the tracing process by selecting an area with a definite boundary between the dark and bright areas. This is so I can easily do the tracing. And the smallest part usually becomes my first choice. In this case, the eyes and the surrounding areas.

Using the Rectangle Tool (M), I trace the highlight in the iris, that still seems vague in the photo. This shape has a fill with no stroke. All shapes created will be in this style.




Jual Video tutorial membuat Social network dengan Codeigniter studi kasus twitter


membuat jejaring sosial fitur follower dan follo wingdengan codeigniter

Saya merilis Video tutorial membuat Social network dengan Codeigniter harga Rp. 120.000,- bisa dipesan di Bukalapak dan Tokopedia.

Tutorial ini membahas tentang pembuatan fitur follower dan following, tombol follow dan unfollow, yang menarik di turorial ini adalah pembahasan  perancangan relationship table, bagaimana cara unik untuk mendesain database dari NOL BESAR sampai teknik Peng KODING an aplikasi dengan PHP Codeigniter Framework,

Link Bukalapak:

Link Tokopedia:



berisi Video :

  1. Memulai Proyek: membuat basis data dan table users
  2. Membuat Tabel users
  3. Membuat User  Register
  4. Membuat User Home untuk dashboard
  5. Membuat User login
  6. Membuar User detail
  7. Membuat User Logout
  8. Membuat Daftar User
  9. Teori dan konsep Relasi tabel
  10. Membuat tabel Follows dan Membuat Model follows
  11. Perancangan Logika Follow.
  12. perancangan logika Unfollow.
  13. Authentikasi User.
  14. Cek Authentikasi User.
  15. membuat tombol follow
  16. Menghilangkan Tombol follow pad Id  Login Sendiri
  17. Membuat Tombol follow dan Unfollow
  18. Proteksi follow dengan Session
  19. Halaman user follower
  20. halaman user following


proyek social network

Halaman user All

video tutorial codeigniter 5

halaman user Follower


video tutorial codeigniter 6




Halaman User Following

video tutorial codeigniter 7

Tampilan debgab Css Bootstrap 3:
user  all

preview 1

User detailpreview 2


User Home dashboard

preview 3


user login

preview 4






ini adalah contoh web saya pernah saya implementasikan sebuah fitur followind dan follower.


Pre Order dibuka untuk mendapatkan harga Rp. 100.000 melalui kontak facebook saya atau watsap 089636283068,  dikirim dari jakarta

Hormat saya,

Slamet Nurhadi


Multiple Google geo charts on One Page

multiple geo

Fixing Multiple google geo charts on One page, this tutorial is [solved] your problem.


A geomap is a map of a country, continent, or region map, with colors and values assigned to specific regions. Values are displayed as a color scale, and you can specify optional hovertext for regions. The map is rendered in the browser using an embedded Flash player. Note that the map is not scrollable or draggable, but can be configured to allow zooming.
tutorial geo chart php mysqli xml

Tutorial  available on Youtube

Data Format

Two address formats are supported, each of which supports a different number of columns, and different data types for each column. All addresses in the table must use one or the other; you cannot mix types.

  • Format 1: Latitude/Longitude locations. This format works only when the dataMode option is ‘markers’. If this format is used, you do not need to include the Google Map Javascript. The location is entered in two columns, plus two optional columns:
    1. [Number, Required] A latitude. Positive numbers are north, negative numbers are south.
    2. [Number, Required] A longitude. Positive numbers are east, negative numbers are west.
    3. [Number, Optional] A numeric value displayed when the user hovers over this region. If column 4 is used, this column is required.
    4. [String, Optional] Additional string text displayed when the user hovers over this region.
  • Format 2: Address, country name, region name locations, or US metropolitan area codes. This format works with the dataMode option set to either ‘markers’ or ‘regions’. The location is entered in one column, plus two optional columns:
    1. [String, Required] A map location. The following formats are accepted:
      • A specific address (for example, “1600 Pennsylvania Ave”).
      • A country name as a string (for example, “England”), or an uppercase ISO-3166 code or its English text equivalent (for example, “GB” or “United Kingdom”).
      • An uppercase ISO-3166-2 region code name or its English text equivalent (for example, “US-NJ” or “New Jersey”). Note: Regions can only be specified when the dataMode option is set to ‘regions’.
      • A metropolitan area code. These are three-digit metro codes used to designate various regions; US codes only supported. Note that these are not the same as telephone area codes.
    2. [Number, Optional] A numeric value displayed when the user hovers over this region. If column 3 is used, this column is required.
    3. [String, Optional] Additional string text displayed when the user hovers over this region.

Tutorial  available on Youtube