PHP - Anket Sorunu

2008'den beri121 mesaj
#1
29.06.2011 11:49
ben bir anket yaptım ancak bu oyları nasıl yüzde olarak yazdıracağımı yapamadım yarımcı olursanız sevinirim...
şimdiden teşekkürler...

[COLOR=#000000][COLOR=#0000BB]<?php
	[/COLOR][COLOR=#0000BB]	include([/COLOR][COLOR=#DD0000]"admin/db_ayar.php"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	@[/COLOR][COLOR=#0000BB]$oy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$_POST[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'anket'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ip [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$_SERVER[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'REMOTE_ADDR'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$sor [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ekle [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"INSERT INTO anket(oy,ip) VALUES ('$oy','$ip')"[/COLOR][COLOR=#007700]) or die([/COLOR][COLOR=#DD0000]"Ekleme Hatası"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	while( [/COLOR][COLOR=#0000BB]$cek [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sor[/COLOR][COLOR=#007700])){
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$id [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$cek[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'id'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$doy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$cek[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'oy'[/COLOR][COLOR=#007700]];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$oysayisi [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_num_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$sor[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$sorbes [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket where oy=5"[/COLOR][COLOR=#007700]);{
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$besoy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_affected_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$baglanti[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$besoyyuzde [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000BB]$oysayisi [/COLOR][COLOR=#007700]/[/COLOR][COLOR=#0000BB]100 [/COLOR][COLOR=#007700])*[/COLOR][COLOR=#0000BB]$besoy[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$sordort [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket where oy=4"[/COLOR][COLOR=#007700]);{
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$dortoy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_affected_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$baglanti[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$dortoyyuzde [/COLOR][COLOR=#007700]= ([/COLOR][COLOR=#0000BB]$oysayisi [/COLOR][COLOR=#007700]/ [/COLOR][COLOR=#0000BB]100[/COLOR][COLOR=#007700])*[/COLOR][COLOR=#0000BB]$dortoy[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$soruc [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket where oy=3"[/COLOR][COLOR=#007700]);{
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ucoy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_affected_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$baglanti[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ucoyyuzde [/COLOR][COLOR=#007700]= ( [/COLOR][COLOR=#0000BB]$oysayisi [/COLOR][COLOR=#007700]/ [/COLOR][COLOR=#0000BB]100[/COLOR][COLOR=#007700])*[/COLOR][COLOR=#0000BB]$ucoy[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$soriki [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket where oy=2"[/COLOR][COLOR=#007700]);{
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ikioy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_affected_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$baglanti[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$ikioyyuzde [/COLOR][COLOR=#007700]=( [/COLOR][COLOR=#0000BB]$oysayisi  [/COLOR][COLOR=#007700]/ [/COLOR][COLOR=#0000BB]100 [/COLOR][COLOR=#007700])*[/COLOR][COLOR=#0000BB]$ikioy[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$sorbes [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM anket where oy=1"[/COLOR][COLOR=#007700]);{
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$biroy [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_affected_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$baglanti[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$biroyyuzde [/COLOR][COLOR=#007700]= ( [/COLOR][COLOR=#0000BB]$oysayisi [/COLOR][COLOR=#007700]/[/COLOR][COLOR=#0000BB]100[/COLOR][COLOR=#007700])*[/COLOR][COLOR=#0000BB]$biroy[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	}
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]$toplam [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$biroyyuzde [/COLOR][COLOR=#007700]+ [/COLOR][COLOR=#0000BB]$ikioyyuzde  [/COLOR][COLOR=#007700]+ [/COLOR][COLOR=#0000BB]$ucoyyuzde [/COLOR][COLOR=#007700]+ [/COLOR][COLOR=#0000BB]$dortoyyuzde [/COLOR][COLOR=#007700]+ [/COLOR][COLOR=#0000BB]$besoyyuzde[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]	echo[/COLOR][COLOR=#DD0000]"
<table width='642' border='1'>
  <tr>
    <td colspan='5' align='center'>Sonuçlar</td>
  </tr>
  <tr>
    <td width='187'>Güzel</td>
    <td width='3' align='center'>:</td>
    <td width='259'>&nbsp;</td>
    <td width='53'>$besoy</td>
    <td width='106'>%$besoyyuzde </td>
  </tr>
  <tr>
    <td>İyi</td>
    <td align='center'>:</td>
    <td>&nbsp;</td>
    <td>$dortoy</td>
    <td>%$dortoyyuzde </td>
  </tr>
  <tr>
    <td>İdare Eder</td>
    <td align='center'>:</td>
    <td>&nbsp;</td>
    <td>$ucoy</td>
    <td>%$ucoyyuzde </td>
  </tr>
  <tr>
    <td>Devam Et Daha Güzel Olacak</td>
    <td align='center'>:</td>
    <td>&nbsp;</td>
    <td>$ikioy</td>
    <td>%$ikioyyuzde </td>
  </tr>
  <tr>
    <td>Kötü</td>
    <td align='center'>:</td>
    <td>&nbsp;</td>
    <td>$biroy</td>
    <td>%$biroyyuzde </td>
  </tr>
  <tr>
    <td colspan='4' align='center'>Toplam Kullanılan Oy Sayısı $oysayisi</td>
	<td>$toplam</td>
  </tr>
</table>
<p>&nbsp;</p>
"[/COLOR][COLOR=#007700];
[/COLOR][COLOR=#0000BB]	
[/COLOR][COLOR=#0000BB]	[/COLOR][COLOR=#0000BB]?>[/COLOR][/COLOR]