[ASK] mysql_real_escape_string

julian123 · July 18, 2011, 7:47am

Halo para master… lagi2 sy bertanya

untuk mysql_real_escape_string() … kenapa pada saat penggunaannya ada error

seperti ini kira2: access denied…using password: no

bagaimana cara mengatasi nya…,

makasih banyak…

yiippy · July 18, 2011, 9:15am

Mungkin bisa diperjelas gan pesan errornya. atau bisa diperlihatkan script querynya gmn

julian123 · July 19, 2011, 3:07am

Klo misalnya gini gan… di controller…

if (isset($_POST["edit"])) {

        &#036;fullname = mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars(&#036;_POST[&quot;fullname&quot;], ENT_QUOTES))));


        &#036;contact1 = mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars(&#036;_POST[&quot;contact1&quot;], ENT_QUOTES))));


        &#036;contact2 = mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars(&#036;_POST[&quot;contact2&quot;], ENT_QUOTES))));








        &#036;user = User::model()-&gt;findByPk(Yii::app()-&gt;user-&gt;id);





        if (&#33;empty(&#036;_POST[&quot;password&quot;]) &amp;&amp; &#33;empty(&#036;_POST[&quot;password_confirm&quot;])) {


            &#036;pass = md5(mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars(&#036;_POST[&quot;password&quot;], ENT_QUOTES)))));


        } else {


            &#036;pass = &#036;user-&gt;password;


        }





        &#036;user-&gt;saveAttributes(array('password' =&gt; &#036;pass, 'fullname' =&gt; &#036;fullname, 'contact1' =&gt; &#036;contact1, 'contact2' =&gt; &#036;contact2));





        &#036;this-&gt;refresh();


    }

kok ga bisa yach… pasti keluar error Access denied…

mohon pencerahannya…