<style>
body{
font-size: 10px;
}
table{
margin: 0 auto;
font-size: 10px;
}
thead tr{
font-weight: bold;
}
</style>
<?php
header('Content-Type: text/html; Charset=UTF-8');
date_default_timezone_set('Europe/Istanbul');

$dbhost = "localhost";
$dbuser = "root";
$dbname = "odev";
$dbpass = "12345678";

$baglanti = @mysql_connect($dbhost, $dbuser, $dbpass);
if($baglanti){
@mysql_select_db($dbname, $baglanti);
}
?>
<form action="" method="post">
<textarea name="sorgu" rows="10" cols="50"></textarea><br /><br />
<input type="hidden" name="islem" value="1" />
<input type="submit" value="Çalıştır" />
</form>
<?php
if($_POST['islem'] == 1){
$sorgu = $_POST['sorgu'];
?>
<table border="1" style="width: 100%;">
<thead>
<tr>
<td>Öğrenci No</td>
<td>Ad</td>
<td>Soyad</td>
<td>Cinsiyet</td>
<td>Doğum Yeri</td>
<td>Doğum Tarihi</td>
<td>Fakülte</td>
<td>Bölüm</td>
<td>Sınıf</td>
</tr>
</thead>
<tbody>
<?php
$calis = @mysql_query($sorgu);
$sayac = @mysql_num_rows($calis);
while($yaz = @mysql_fetch_assoc($calis)){
?>
<tr>
<td><?php echo $yaz['ogrenciNO']; ?></td>
<td><?php echo $yaz['ad']; ?></td>
<td><?php echo $yaz['soyad']; ?></td>
<td><?php echo $yaz['cinsiyet'] == 1 ? "Bay" : "Bayan"; ?></td>
<td><?php echo $yaz['dogumyeri']; ?></td>
<td><?php echo date('d.m.Y', $yaz['dogumtarihi']); ?></td>
<td><?php echo $yaz['fakulte']; ?></td>
<td><?php echo $yaz['bolum']; ?></td>
<td><?php echo $yaz['sinif']; ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<pre>İşleme alınan sorgu başarıyla çalıştı ve <?php echo $sayac; ?> satır sonuç döndürdü</pre>
<?php
}
?>