Kodum aşağıdaki gibidir.
<?php
/*
Veri Tabanına Bağlan
*/
$sunucu = "localhost"; //sunucu
$kullanici = "root"; //veritabani kullanici adi
$parola = ""; // veritabani sifresi
$veritabani = "murat";// veritabani ismi
$baglanti = mysql_connect($sunucu, $kullanici, $parola);
mysql_query("SET NAMES = ''utf8");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_turkish_ci'");
if(!$baglanti) die("MySQL sunucusuna baglanti saglanamadi!");
mysql_select_db($veritabani, $baglanti) or die ("Veritabanina baglanti saglanamadi!");
?>
<html>
<body>
<form method="post" action="deneme.php">
<input type="date" name="bas_tarih" size="25" maxlength="25">
<input type="date" name="bit_tarih" size="25" maxlength="25">
<input type="Submit" name="Submit" value="Submit">
</form>
<?php
$bas_tarih = @$_POST['bas_tarih'];
$bit_tarih = @$_POST['bit_tarih'];
if(!empty($bas_tarih) && !empty($bit_tarih)) {
$search = mysql_query("SELECT * FROM siparis WHERE sip_tarihi BETWEEN '$bas_tarih' AND '$bit_tarih' ORDER by id DESC");
$sorgu = mysql_query($search);
while($yaz=mysql_fetch_object($sorgu)){
echo $yaz->sip_no ." - ".$yaz->dos_no ."<br />";
}
} else {
echo 'Alanları boş bırakmayın!';
}
?>
</body>
</html>verdiği hata
( ! ) Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\murat\deneme.php on line 33
Call Stack
# Time Memory Function Location
1 0.0008 377824 {main}( ) ..\deneme.php:0
2 1.0952 388776 mysql_query ( ) ..\deneme.php:33
( ! ) Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\wamp\www\murat\deneme.php on line 35
Call Stack
# Time Memory Function Location
1 0.0008 377824 {main}( ) ..\deneme.php:0
2 1.0953 389024 mysql_fetch_object ( ) ..\deneme.php:35
33 satır : $sorgu = mysql_query($search);
35. satır : while($yaz=mysql_fetch_object($sorgu)){