Php Veritabanı Bağlantısı (Php Mysql Bağlantısı)

Burada yazıla php kodlarıyla bir anket çalışması yapılmış veriler mysql veritabanı üzerinde bulunan tablolara yazılmıştır. Dört sayfadan oluşan projede birinci aşamada php ile mysql veritabanının bağlantısı sağlanmıştır. İkinci aşamadan yapılacak anketi seçeceğiniz arayüz olan index.php bulunmaktadır. Üçüncü sayfada oy verme işlemi bulunmaktadır. Dördüncü sayfada ise seçtiğiniz ankete göre uygun sonuçlar uygun bir grafikle size gösterilmiştir.

Önemli Not: Projeyi çalıştırmak için baglanti.php dosyasını açıp;

veritabani_kullanici_adi

veritabani_kullanici_sifresi

veritabani_ismi

yerlerine uygun değerleri girmeniz gerekmektedir.

index.php Sayfası

<html>
<head>
<title>Php İle Veritabanı Bağlantısı</title>
<meta http-equiv=”Content-Type” content=”text/html” charset=”iso-8859-9″ />
<head>
<body>
<?php
include_once(“baglanti.php”);
baglan();
switch($_REQUEST[‘ope’]){
case “view”:
view($_GET[‘surveyno’]);
print “<a href=’index.php’><< Geri Dön</a>”;
break;
case “vote”:
if (!isset($_POST[‘answer’])){
print “<font color=’red’>Lütfen Bir Yanıt Seçin!</font>
\n”;
print “<a href=’index.php’><< Geri Dön</a>”;
exit;
}
print “Oy Verdiğiniz İçin Teşekkürler.
\n”;
print “
\nDaha Fazla Yanıt Vermek İçin.
\nDevam Edin.
\n”;
if(isset($_POST[‘answer’]) AND isset($_POST[‘surveyno’])){
$sql=”SELECT count(*) as sayi FROM answer WHERE answer='{$_POST[‘answer’]}’ AND sid={$_POST[‘surveyno’]} AND date='”.date(“Y-m-d”).”‘;”;
$result=mysql_query($sql) OR die(“Cannot query answers and dates”);
$value=mysql_result($result,0,0);
if($value==”0″)
{
$sql=”INSERT INTO answer(sid,answer,votes,date) VALUES({$_POST[‘surveyno’]},'{$_POST[‘answer’]}’,1,'”.date(“Y-m-d”).”‘)”;
$result=mysql_query($sql) OR die(“Cannot insert.”);
}
else
{
$sql=”UPDATE answer SET votes=votes+1 WHERE answer='{$_POST[‘answer’]}’ AND sid={$_POST[‘surveyno’]} AND date='”.date(“Y-m-d”).”‘;”;
$result=mysql_query($sql) OR die(“Cannot update.”);
}
}
viewList();
break;
default:
print ” “;
viewList();
break;
}
function viewList(){
$sql=”SELECT * FROM survey”;
$result=mysql_query($sql) or die(“Cannot select l:50”);
print “<ol>\n”;
while( $res=mysql_fetch_array($result) ){
$a[]=$res;
print “<li><a href=’?ope=view&surveyno={$res[‘sid’]} ‘>{$res[‘question’]}</a></li>\n”;
}
print “</ol>\n\n”;
}
function view($surveyno){
$sql=”SELECT * FROM survey WHERE sid=$surveyno”;
$result=mysql_query($sql) or die(“Cannot select l:62”);
$sqlAnswer=”SELECT DISTINCT sid,answer FROM answer WHERE sid=$surveyno”;
$resultAnswer=mysql_query($sqlAnswer) or die(“Cannot select l:65.\n”);
$res=mysql_fetch_array($result);
print “<form method=’POST’ action=’index.php’>\n”;
print “<table border=’1′>\n”;
print “<tr><td colspan=3>{$res[‘question’]}</td></tr>\n”;
print ” <input type=’hidden’ name=’ope’ value=’vote’></td>\n”;
print ” <input type=’hidden’ name=’surveyno’ value='{$res[‘sid’]}’></td>\n”;
while( $resAnswer=mysql_fetch_array($resultAnswer) ){
print “<tr>\n”;
print ” <td weigth=’10’><input type=’radio’ name=’answer’ value='{$resAnswer[‘answer’]}’>\n”;
print ” <td>{$resAnswer[‘answer’]}</td>\n”;
// print ” <td>{$resAnswer[‘vote’]}</td>\n”;
print “</tr>\n”;
}
print “<tr>\n”;
print ” <td colspan=3>\n”;
print ” <table border=’0′>\n”;
print “<tr>\n”;
print “<td><input type=’submit’ value=’Oy Ver’></td>\n”;
print “</form>\n”;
print “<form method=’POST’ action=’vote.php’>\n”;
print “<input type=’hidden’ name=’surveyno’ value='{$res[0]}’>\n”;
print “<input type=’hidden’ name=’question’ value='{$res[‘question’]}’>\n”;
print “<td width=’%100′ align=’right’><input type=’submit’ value=’Sonuclar’></td>\n”;
print “</tr>\n”;
print “</form>\n”;
print “</table>”;
print “</td>”;
print “</tr>\n”;
print “</table>\n”;
print “
\n\n”;
}
?>
</body>
</html>

baglanti.php kodu:

<?php
function baglan(){
if ($_SERVER[“SERVER_ADDR”] == “*******”){
$my = mysql_connect(“localhost”, “********”, “********”);
$mysqli = mysql_select_db(“********”) or die (“Unable to select!”);
}
else{
mysql_connect(“localhost”,”veritabani_kullanici_adi”,”veritabani_kullanici_sifresi”) or die(“Cannot connect to database.\n”);
mysql_select_db(“veritabani_ismi”);
}
}
?>

vote.php kodu:

<?
session_start();
if (!isset($_SESSION[‘vote’]) || isset($_POST[‘surveyno’])){
$_SESSION[‘vote’] = $_POST[‘surveyno’];
$_SESSION[‘title’] = $_POST[‘question’];
}
?>
<html>
<head>
<title><?=$_SESSION[‘title’]?></title>
<meta http-equiv=”Content-Type” content=”text/html” charset=”utf-8″ />
<head>
<body>
<a href=”vote.php”><img src=”grafik.php” border=0/></a>
<a href=”index.php”><< Geri Don</a>
</body>
<html>

grafik.php kodu:

<?php
session_start();
$vote = $_SESSION[‘vote’];
include_once(“baglanti.php”);
baglan();
$sql=”SELECT DISTINCT date FROM answer WHERE sid=$vote ORDER BY date”;
$result=mysql_query($sql) or die(“Cannot query answers”);
while($dates[]=mysql_fetch_array($result));
unset($dates[count($dates)-1]);
$sql=”SELECT DISTINCT answer FROM answer WHERE sid=$vote”;
$result=mysql_query($sql) or die(“Cannot query answers”);
while($answers[]=mysql_fetch_array($result));
unset($answers[count($answers)-1]);
$sql=”SELECT * FROM answer WHERE sid=$vote”;
$result=mysql_query($sql) or die(“Cannot query answers”);
while($row=mysql_fetch_assoc($result))
{
$data[$row[‘answer’]][$row[‘date’]]=$row[‘votes’];
}
$sql=”SELECT MAX(votes) FROM answer WHERE sid=$vote”;
$result=mysql_query($sql) or die(“Cannot query answers”);
//print “dsadas”;
$votesmax=mysql_result($result,0,0);
draw(300,300);
function draw($height, $width){
//global $result, $array,$resultQuestion;
global $answers,$dates,$data,$votesmax;
$hmargin=40;
header (“Content-type: image/png”);
$myImage = ImageCreate($width+40,$height+(count($data)*15)+60);
$backGround = ImageColorAllocate ($myImage, rand(0, 255), rand(0, 255), rand(0, 255) );
$white = ImageColorAllocate ($myImage, 255, 255, 255);
$red = ImageColorAllocate ($myImage, 255, 0, 0);
$green = ImageColorAllocate ($myImage, 0, 255, 0);
$blue = ImageColorAllocate ($myImage, 0, 0, 255);
$grey = ImageColorAllocate ($myImage, 136,136,136);
imagestring($myImage, 5, 5, $height+15, $resultQuestion[‘question’], $white);
$counter=1;
$xaralik=$width/count($dates);
$yaralik=$height/$votesmax;
imageline($myImage,$hmargin,0,$hmargin,$height,$white);
imageline($myImage,$hmargin,$height,$width,$height,$white);
for($i=0;$i<10;$i++)
imagestring($myImage,3,0,$height-$height/10*$i,$votesmax/10*$i,$white);
for($a=0;$a<count($answers);$a++)
{
$color = ImageColorAllocate ($myImage, rand(0, 255), rand(0, 255), rand(0, 255));
for($d=0;$d<count($dates)-1;$d++)
{
$v1=$data[$answers[$a][0]][$dates[$d][0]];
$v2=$data[$answers[$a][0]][$dates[$d+1][0]];
imageline($myImage,$hmargin+$xaralik*$d,$height-$yaralik*$v1,$hmargin+$xaralik*($d+1),$height-$yaralik*$v2,$color);
imagestring($myImage,3,$hmargin+$xaralik*$d,$height+5,$dates[$d][0],$white);
imagestring($myImage,3,$hmargin+$xaralik*($d+1),$height+5,$dates[$d+1][0],$white);
}
imagestring($myImage,3,$hmargin,20+$height+15*$a,$answers[$a][0],$color);
}
imagestring($myImage, 5, $centerX, $height+($counter+2)*15, “”, $white);
ImagePNG($myImage);
ImageDestroy($myImage);
}
function calculateAngle(){
global $row;
$num = $row;
$result = 360 / $num;
return $result;
}
function aciCizgi($image,$x1,$y1,$length,$aci,$color){
$x2 = $x1 + sin( deg2rad($aci) ) * $length;
$y2 = $y1 + cos( deg2rad($aci+180) ) * $length;
imageline($image,$x1,$y1,$x2,$y2,$color);
}
function aciString($image,$font,$x1,$y1,$length,$aci,$string,$color){
$x2 = $x1 + sin( deg2rad($aci) ) * $length;
$y2 = $y1 + cos( deg2rad($aci+180) ) * $length;
imagestring($image, $font, $x2,$y2, $string, $color);
}
?>