PHP - Anket Sorunu

ErkanPur

ErkanPur

Asistan
Katılım
6 Haziran 2008
Mesajlar
121
Reaksiyon puanı
3
Puanları
18
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...

Kod: 
[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]
 
0nur

0nur

Asistan
Katılım
6 Temmuz 2010
Mesajlar
154
Reaksiyon puanı
2
Puanları
0
$biroyyuzde = ( $biroy / $oysayisi) * 100;

gibi?
 
ErkanPur

ErkanPur

Asistan
Katılım
6 Haziran 2008
Mesajlar
121
Reaksiyon puanı
3
Puanları
18
teşekkürler 0nur oldu halletim :)
 
Cevap yazmak için kayıt ol veya giriş yap

Benzer konular

murat zorluu
Rehber Afyonkarahisar ve Karahisar Kalesi…
Cevaplar
0
Görüntüleme
704
murat zorluu
murat zorluu
S
php ile mysqlden kişilerin puanlarının toplamını güne göre listeleme
Cevaplar
0
Görüntüleme
508
SerhatCelikel
S
023
MyBB Aylık İstatistikler Tablosu Ekleme
Cevaplar
0
Görüntüleme
1K
023
023
The Judge
  • Sabit
[PC] Dev Oyun Tavsiyesi - 1 (4 GB RAM)
2 3
Cevaplar
69
Görüntüleme
131K
BehzatAmirim
BehzatAmirim
E
PHP farklı browser sorunu
Cevaplar
0
Görüntüleme
1K
emre_csk
E

SDN Haberleri

Son mesajlar

Üst