ad=isim
soya=sofyisim gibi variablelara atadım diyelim
select isim, soyisim from tablex where isim=ad and soyisim=soya
yazınca ve şayet variablelara mantıklı değerler koyarsam yani bunlar tabloda varsa buluyor peki ama kullanıcı filtreyi sadece ada göre veya soyisime göre arayacaksa ne olacak? bu durumda bana adı ne olursa olsun soyadı=ahmet oloanları sql de nasıl tanımlayacağım?
Kod: Tümünü seç
global $database;
// Get data from filter page
$_teamname=$_POST['teamname'];
$q= "SELECT teamname FROM teamletter WHERE id=\"$_teamname\" ";
$result = $database->query($q);
$num_rows= mysql_result($result);
$teamname = mysql_result($result,"teamname");
$_tailname=$_POST['tailname'];
$tname=$_tailname;
$_reportdate1=$_POST['reportdate'];
$_reportdate2=$_POST['reportdate2'];
$_partnumber=$_POST['partnumber'];
$_snoff=$_POST['snoff'];
$_snon=$_POST['snon'];
$q = "SELECT tailname.tailname as ucakad , faultyreporter.ekipno, faultyreporter.reportdate, faultyreporter.recorddate, faultyreporter.report, faultyreporter.time, faultyreporter.process, faultyreporter.partnumber, faultyreporter.serialnumberoff, faultyreporter.serialnumberon, faultyreporter.recorderuserid FROM faultyreporter INNER JOIN tailname ON tailname.id = faultyreporter.tailid WHERE faultyreporter.ekipno=\"$teamname\" AND faultyreporter.tailname=\"$tname\" ";
$result = $database->query($q);
/* Error occurred, return given name by default */
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows < 0))
{
echo "Error displaying info";
return;
}
if($num_rows == 0)
{
echo "Database table empty";
return;
}
echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
echo "<tr><td><b>tailid</b></td><td><b>ekipno</b></td><td><b>reportdate</b></td><td><b>recorddate</b></td><td><b>report</b></td><td><b>time</b></td><td><b>process</b></td><td><b>partnumber</b></td><td><b>serialnumberoff</b></td><td><b>serialnumberon</b></td><td><b>recorderuserid</b></td></tr>\n";
for($i=0; $i<$num_rows; $i++)
{
$tailid = mysql_result($result,$i,"ucakad");
$ekipno = mysql_result($result,$i,"ekipno");
$reportdate = mysql_result($result,$i,"reportdate");
$recorddate = mysql_result($result,$i,"recorddate");
$report = mysql_result($result,$i,"report");
$time = mysql_result($result,$i,"time");
$process = mysql_result($result,$i,"process");
$partnumber = mysql_result($result,$i,"partnumber");
$serialnumberoff = mysql_result($result,$i,"serialnumberoff");
$serialnumberon = mysql_result($result,$i,"serialnumberon");
$recorderuserid = mysql_result($result,$i,"recorderuserid");
echo "<tr><td>$tailid</td><td>$ekipno</td><td>$reportdate</td><td>$recorddate</td><td>$report</td><td>$time</td><td>$process</td><td>$partnumber</td><td>$serialnumberoff</td><td>$serialnumberon</td><td>$recorderuserid</td></tr>\n";
}
echo "</table><br>\n";
}