[Ask] Error mysql query & array

[Emily.Josan♫]

(08-17-2011 05:43 PM)t3k0 Wrote:  di file yourum.php nya belum di include kan file koneksinya om....

tambah fatal om...

klo script yg ini

Code:

`yazid`='$id' and `onay`='1' order by id desc");

di hilangin, yg connect dngn yorum.php malah bs.. tapi yorum.phpnya ttp error..

atau om t3ko bs kasih contoh

[mariachi]

(08-17-2011 05:57 PM)x_wungu Wrote:  

(08-17-2011 05:43 PM)t3k0 Wrote:  di file yourum.php nya belum di include kan file koneksinya om....

tambah fatal om...

kok tambah fatal, kalo gak di include kan file koneksinya gimana mau ada koneksi ke databasenya...

oke saya kasih contoh

file konek.php

Code:

<?

$host = "localhost";
$user = "root";
$pass = "toor";
$db = "conto";

mysql_connect("$host","$user","$pass") or die("tidak bisa koneksi ke server");
mysql_select_db("$db") or die ("tidak bisa koneksi ke database");
?>

file yorum.php

Code:

<?
include('konek.php'); //file konek.php harus satu direktori dengan file ini
$id=(int)$_GET['id'];

$sql=mysql_query("select * from contoh where id=$id");

while($result=mysql_fetch_array($sql)){
$judul = $result['judul'];
$isi = $result['isi_artikel'];
print "<center><b>$judul<br></b></center><font color=black>$isi...</font>";
}
?>

semacam itu kira2. silahkan dimodifikasi sendiri..... smoke

[Emily.Josan♫]

(08-17-2011 06:24 PM)t3k0 Wrote:  

(08-17-2011 05:57 PM)x_wungu Wrote:  

(08-17-2011 05:43 PM)t3k0 Wrote:  di file yourum.php nya belum di include kan file koneksinya om....

tambah fatal om...

kok tambah fatal, kalo gak di include kan file koneksinya gimana mau ada koneksi ke databasenya...

oke saya kasih contoh

file konek.php

Code:

<?

$host = "localhost";
$user = "root";
$pass = "toor";
$db = "conto";

mysql_connect("$host","$user","$pass") or die("tidak bisa koneksi ke server");
mysql_select_db("$db") or die ("tidak bisa koneksi ke database");
?>

file yorum.php

Code:

<?
include('konek.php'); //file konek.php harus satu direktori dengan file ini
$id=(int)$_GET['id'];

$sql=mysql_query("select * from contoh where id=$id");

while($result=mysql_fetch_array($sql)){
$judul = $result['judul'];
$isi = $result['isi_artikel'];
print "<center><b>$judul<br></b></center><font color=black>$isi...</font>";
}
?>

semacam itu kira2. silahkan dimodifikasi sendiri..... smoke

tadi fatal karna salah direktori om . ga satu direktory trnyata bs om.
yg jdi permasalhn slnjtnya mash kluar

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

apa slsh isinya ya om

---

ni om t3k0

Code:

<?
include('xxx/db.php');
$id=(int)$_GET['id'];

$sec=mysql_query("select * from yorumlar where 1 `yazid`='$id' and `onay`='1' order by id desc ");

while($yorum=mysql_fetch_array($sec)){

    
    echo'<hr size=1 color=red><br /><font color="black"><a href="mailto:'.$yorum['mail'].'"><font color=red size=2>'.$yorum['ad'].'</font></a> Adlý Kiþi ,   '.$yorum['tarih'].' Tarihinde Demiþ ki </font>;';

    echo'<br />';

    echo $yorum['mesaj'].'';

    echo'<br />';

    }

echo'<table height="12" width="100%"><tr><td background="images/x.gif"> </td></tr></table>';

?>
<br><br>
<style type="text/css">



input1{

background-color:#333333;

border:1px dashed #666666;

font-family:Tahoma;

font-size:11px;

color:#999999;

}

input1:hover{

border:1px dashed #666666;

}



textarea1{

background-color:#333333;

border:1px dashed #666666;

font-family:Trebuchet MS;

font-size:11px;

color:#999999;

}

textarea1:hover{

border:1px dashed #666666;

}

.mesaj1{

background-color:#333333;

font-size:11px;

color:#ffffff;

padding:4;}

</style>
<script language="JavaScript1.2">

function ClearError() {

return true;}

window.onerror = ClearError;

</script>



<script  language="JavaScript">        

function openWin(theURL,winName,features) {

      window.open(theURL,winName,features);}

</script>



<script  language="JavaScript">

function ForumJump(URL) {

    if (URL.options[URL.selectedIndex].value != "") self.location.href = URL.options[URL.selectedIndex].value;    

    return true;}

</Script>





<script language="JavaScript">

function Toggle( secid ){

    var sectionId = document.getElementById(secid);

    if (sectionId == null) return;

    if (sectionId.style.display == '')

    {

        sectionId.style.display = 'none';}

    else{

        sectionId.style.display = '';}}



function Hide( obj ){

    var oDiv = document.getElementById(obj);

    if(oDiv != null) oDiv.style.display = "none";}



function chkHide(id){

    var isPF = (typeof(IsPrinterFriendly) != "undefined");

    if(document.getElementById && !isPF){ Hide(id); }}

</script>

<script language="javascript">sID='3l1-ECBAA';writePM(sID)</script>

                  <script language="javascript">startA('s'+sID)</script>

                  &nbsp;

                    <a onClick="javascript:Toggle('s3l1-ECBAA')" name="Submit"><input type=submit name=vbulletin value='Yorum Yaz'></a><br><br>

                  <script language="javascript">endA()</script>

<div  id="s3l1-ECBAA">

                  <script language="javascript">chkHide('s'+sID);</script>

<form id="form1" name="form1" method="post" action="">

  <table width="355" border="0">

    <tr>

      <td><font size=1>Nick :</font></td>

      <td><label>

        <input name="ad" type="text" id="email" size="21" /></label>

<label><font size=1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Email :</font>

        <input name="email" type="text" id="ad" size="21" value="" />

      </label></td>

    </tr>

    <tr>

      <td><font size=1>Mesaj :</font>

     <td><label>

        <textarea name="mesaj" cols="51" rows="7" id="mesaj"></textarea>

</label></td></td>

    </tr>
<?php
$a = rand(1,9);
$b = rand(1,9);
$sifre = $a+$b; ?>        
                    
<input type="hidden" name="gkodumuz" value="123456">
<input type="hidden" name="zgkod" value="123456">
<input type="hidden" name="sunucu" value="<? echo $sifre; ?>">
<tr>

      <td><font size=1>Security :</font></td>

     <td><label>

<font color="red" size="3"><?  echo ''.$a.'+'.$b;''; ?></font> = <input type="text" maxlength="2" name="kod" class="yazi" size="47" />

</label></td>

    </tr>

    <tr>

      <td>&nbsp;</td>

      <td><input type="submit" name="Submit" value="Gönder" /></td>

    </tr>

  </table>

</form>

<br><b>Not:</b><font color=black>[br] ile Bir Alt Satýra Geçebilirsiniz..HTML Kodlarý Kapalýdýr ve Yorumlar Onaylanýnca Gösterilir..</font>

<?

$ad=htmlspecialchars(addslashes($_POST['ad']));

$email=htmlspecialchars(addslashes($_POST['email']));

$mesaj=htmlspecialchars(addslashes($_POST['mesaj']));

$tarih=date("d.m.Y - H:i:s");

$ip=$_SERVER['REMOTE_ADDR'];

$onay=0;

if($_POST['gkodumuz'] == "123456" && $_POST['zgkod'] == "123456"){ // güvenlik kontrol


if($id && $ad && $email && $mesaj){



if(! eregi('@',$email)){

    echo'<script>alert("Gecerli Bir Email Adres Giriniz..");</script>';

    }elseif(mysql_num_rows(mysql_query("select * from yorumlar where `yazid`='$id' and `mesaj`='$mesaj'"))){





            echo'<br /><div class="mesaj" align=center>&nbsp;&nbsp;Flood Yapma Evlat :) Bu Yorum Kayitli</div>';

        }elseif($_POST['kod'] != $_POST['sunucu']){
echo "<center><br><br>Sistem Onay Kodunuzu Dogrulayamadý!<br/><br/></center>";
}else{      

                $ekle=mysql_query("insert into yorumlar (`yazid`,`ad`,`mail`,`mesaj`,`tarih`,`ip`,`onay`) values ('$id','$ad','$email','$mesaj','$tarih','$ip','$onay')");

                    if($ekle){

                        echo'<script>alert("Yorumunuz Yönetici Tarafindan Incelendikten Sonra Gösterilecektir.."); </script>';

                        }else{

                            echo'<div class="mesaj">&nbsp;&nbsp;<b>sorun olustu.</div></b>';

                            }

            }    

    

    }else{

        } }



?>

</div><td></tr></table>

[anbu]

Quote:yg jdi permasalhn slnjtnya mash kluar

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

apa slsh isinya ya om

cona ecute perintah ini manual mau ga?
[codee]select * from yorumlar where 1 `yazid`='$id' and `onay`='1' order by id desc[/code]

[Emily.Josan♫]

Thanks semuanya uda bs ... ane apus aja ni script

Code:

`yazid`='$id' and `onay`='1' order by id desc

tapi ane test comment ,,, ga tau masuknya kommen ane kmn?
biarin dah yg pntng uda ga error

skli lagi thanks buat semuannya

[jomblo1991]

Sector Clear! smoke