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


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


Fixing Google Geo chart PHP + MYSQLi or XML parser complete tutorials

Fixing Google Geo chart PHP + MYSQLi or XML parser complete tutorials


Please Subscribe my Chanel on Youtube:


google geo chart

Mysqltable is bellow:

google chart mysql


<?php $con = mysqli_connect('localhost','root','','test') or Die(); ?>
   <script type="text/javascript" src=""></script>
  <script type="text/javascript">
      google.load("visualization", "1", {packages:["geochart"]});

      function drawRegionsMap() {

        var data = google.visualization.arrayToDataTable([

          ['Country', 'Visits'],
           <?php $query = "SELECT count(ip) AS count, country FROM visitors GROUP BY country"; $exec = mysqli_query($con,$query); while($row = mysqli_fetch_array($exec)){ echo "['".$row['country']."',".$row['count']."],"; } ?>

        var options = {

        var chart = new google.visualization.GeoChart(document.getElementById('geochartsatu'));

        chart.draw(data, options);


<h3>Geo Chart</h3>

<div id="geochartsatu" style="width: 900px; height: 500px;"></div>



Comparison JSON and XML parsing with PHP it’s easy


Comparison JSON and XML parsing with PHP it’s easy.

PHP SimpleXML Introduction

SimpleXML is an extension that allows us to easily manipulate and get XML data.


As of PHP 5, the SimpleXML functions are part of the PHP core. No installation is required to use these functions.

SimpleXML provides an easy way of getting an element’s name, attributes and textual content if you know the XML document’s structure or layout.


SimpleXML turns an XML document into a data structure you can iterate through like a collection of arrays and objects.

  $url = "";
  $sUrl = file_get_contents($url, False);
  $xml = simplexml_load_string($sUrl);

for ($i=0; $i<sizeof($xml->Isi->Row); $i++) { 
	 $row = $xml->Isi->Row[$i];

<a href="detailcuaca.php?detail=<?php echo $row->Kota; ?>"><?php echo $row->Kota; ?></a>
<?php echo "

Data Cuaca : ".$row->Cuaca." 

"; ?>

<?php }?>

Google chart 2016 PHP + MYSQLi Connection

Google chart 2016 PHP + MYSQLi Connection theme case is Populer startup in Indonesia (data is Fiktif)




<?php //open connection to mysql db $connection = mysqli_connect("localhost","root","","test") or die("Error " . mysqli_error($connection)); //fetch table rows from mysql db $sql = "select * from populer_startup"; $result = mysqli_query($connection, $sql) or die("Error in Selecting " . mysqli_error($connection)); //create an array $rows = array(); //flag is not needed $flag = true; $table = array(); $table['cols'] = array( // Labels for your chart, these represent the column titles // Note that one column is in "string" format and another one is in "number" format as pie chart only required "numbers" for calculating percentage and string will be used for column title array('label' => 'Startup', 'type' => 'string'),
    array('label' => 'Users', 'type' => 'number')

	$rows = array();
    while($r =mysqli_fetch_assoc($result))
    $temp = array();
    // the following line will be used to slice the Pie chart
    $temp[] = array('v' => (string) $r['name']); 
    // Values of each slice
    $temp[] = array('v' => (int) $r['custommer']);
    $rows[] = array('c' => $temp);
  $table['rows'] = $rows;
   $jsonTable = json_encode($table);


    <!--Load the Ajax API-->
    <script type="text/javascript" src=""></script>
    <script type="text/javascript" src=""></script>
    <script type="text/javascript">
    // Load the Visualization API and the piechart package.
    google.load('visualization', '1', {'packages':['corechart']});
    // Set a callback to run when the Google Visualization API is loaded.
    function drawChart() {
      // Create our data table out of JSON data loaded from server.
      var data = new google.visualization.DataTable(<?=$jsonTable?>);
      var options = {
           title: 'Populer startup in Indonesia. ',
          is3D: 'true',
          width: 800,
          height: 600
      // Instantiate and draw our chart, passing in some options.
      // Do not forget to check your div ID
      var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
      chart.draw(data, options);
    <!--this is the div that will hold the pie chart-->

<div id="chart_div"></div>


Kursus Android di Jakarta

Buka Kelas Berseri : Kelas Kursus Berseri Android Di DKI Jakarta (Jakarta Selatan)

  1. Pengenalan Pemrograman Android dengan Android Studio

2. Pemrograman User interface (UI) Android untuk pemula berbasis Android studio













ruangguru pemrograman-android









kelas android kelas kelompok android