How To create input / output on sql server 2008 r2

Assalamualaikum....

Hello everybody. confused again with code programming? dont wory, because I have solution for you. taraaaa read this blog crackcoder.blogspot.com hohoho

before that, you should create file connection. save with name sqlconnection.php
if you was create file connection, we are now just call that file with...... include.....

dont worry, copy and paste code in the bellow.....

  <? include "sqlconnection.php";

$dsn="nama_database_sql"; //atau bebased name your DSN
$username="nama_user"; //atau bebased your username
$password="password"; //atau bebased your password
$koneksi= odbc_connect($dsn,$username,$password);
$sql="select * from nama_tabel"; //  basically sintaks sql and mysql is not different :)
$exec=odbc_exec($koneksi,$sql);
while(odbc_fetch_row($exec))
{
$id=odbc_result($exec,"id");
$employer=odbc_result($exec,"employer");
$majority=odbc_result($exec,"majority");
$gpa=odbc_result($exec,"gpa");
?>

design output, example I want design like this bellow, design as you wish... and this is just example :)

<table width="351" border="0">
   <tr>
    <td width="113">ID Calon Karyawan</td>
    <td width="21">:</td>
    <td width="203"><? echo $id_pelamar; ?></td>
  </tr>
  <tr>
    <td width="113">Nama Calon Karyawan</td>
    <td width="21">:</td>
    <td width="203"><? echo $calon_kar; ?></td>
  </tr>
   <tr>
    <td width="113">Jurusan Pelamar</td>
    <td width="21">:</td>
    <td width="203"><? echo $jurusan; ?></td>
  </tr>
   <tr>
    <td width="113">Lulusan Pelamar</td>
    <td width="21">:</td>
    <td width="203"><? echo $lulusan; ?></td>
  </tr>
   <tr>
    <td width="113">Ipk Pelamar</td>
    <td width="21">:</td>
    <td width="203"><? echo $ipk; ?></td>
  </tr>
</table><?
}
odbc_close($koneksi); ?>

save file with name, like "show.php then running that page in your browser localhost thennnnnnn yappp yapp yappp congratulation your sql now running. enjoy ngoding :)

Grettings crackcoder.blogspot.com