Database

Dari Wiki PHP Indonesia

Daftar isi 1 Pertanyaan 2 Solusi 2.1 Database MySQL tidak bisa connect? 2.2 Query tidak menghasilkan Output? 2.2.1 Contoh

Pertanyaan

1. Database MySQL tidak bisa connect?
2. Query tidak menghasilkan Output?

Solusi

Database MySQL tidak bisa connect?

Untuk dapat connect ke Database MySQL Minimal harus mengetahui

  - Alamat Server
  - Username
  - Password

Pastikan nilai-nilai diatas benar. untuk pengecekan

  <?php
     $host="localhost"; //alamat server
     $user_db="root";   //user database
     $pws="1";          //password
     mysql_connect($host, $user_db, $pws) or die ("Koneksi Gagal");
  ?>

Query tidak menghasilkan Output?

Pastikan Query anda benar!!

Untuk mengambil data dapat menggunakan:

• mysql_fetch_row
• mysql_fetch_assoc
• mysql_fetch_array: Mengambil baris result sebagai array assosiatif, numerik atau keduanya.
• mysql_fetch_object: Mengambil data dalam bentuk object.

Contoh

Contoh menggunakan mysql_fetch_row

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_row($result)) {
      printf ("ID: %s  Name: %s", $row[0], $row[1]);
   }
   mysql_free_result($result);
  ?>

Contoh menggunakan mysql_fetch_assoc

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_assoc($result)) {
      printf ("ID: %s  Name: %s", $row['id'], $row['name']);
   }
   mysql_free_result($result);
  ?>

Contoh menggunakan mysql_fetch_array numeric (MYSQL_NUM):

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
      printf("ID: %s  Name: %s", $row[0], $row[1]);  
   }
   mysql_free_result($result);
  ?>

Contoh menggunakan mysql_fetch_array asosiatif (MYSQL_ASSOC):

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
       printf("ID: %s  Name: %s", $row["id"], $row["name"]); 
   }
   mysql_free_result($result);
  ?> 

Contoh menggunakan mysql_fetch_array asosiatif dan numeric bersamaan (MYSQL_BOTH):

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
      printf ("ID: %s  Name: %s", $row[0], $row["name"]);
   }
   mysql_free_result($result);
  ?>

Contoh menggunakan mysql_fetch_object

  <?php
   mysql_connect("localhost", "mysql_user", "mysql_password") or
     die("Could not connect: " . mysql_error());
   mysql_select_db("mydb"); 
   $result = mysql_query("SELECT `id`, `name` FROM `mytable`");
   while ($row = mysql_fetch_object($result)) {
      printf ("ID: %s  Name: %s", $row->id, $row->name);
   }
   mysql_free_result($result);
  ?>