whats wrong on this cod? update mysql with php

Question

This is part of my new script (PHP + MySQL). I can echo $price_exchange_update on output, so it's not empty or uncompilable data for MySQL (varchar-255).

this is worked cod:

mysqli_query($rate_db,"UPDATE rate_prices SET 
                       price_exchange_update = 'test 36'
                       WHERE ID='1'");

But if I use this:

mysqli_query($rate_db,"UPDATE rate_prices SET 
                       price_exchange_update = '$price_exchange_update'
                       WHERE ID='1'");

also this:

mysqli_query($rate_db,"UPDATE rate_prices SET 
                       price_exchange_update = ".$price_exchange_update."
                       WHERE ID='1'");

both of them not work. where am I wrong?

---- Update

I use simplehtmldom to grab date & time from other page. My variable is this:

$price_exchange_update = $html->find("span[id=updateTime]", 0);

echo $price_exchange_update;

and out put is: شنبه ۲۴ خرداد ۱۲:۳۸

I tested, if I use

mysqli_query($rate_db,"UPDATE rate_prices SET 
                       price_exchange_update = 'شنبه ۲۴ خرداد ۱۲:۳۸'
                       WHERE ID='1'");

It's worked. but when I try to update from the variable, it's not work.

one reason could be `$price_exchange_update` contains a single quote in the value. — Abhik Chakraborty, Jun 14 '14 at 16:22
Use prepared statements. See [How can I prevent SQL-injection in PHP?](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1) — p.s.w.g, Jun 14 '14 at 16:22
Thanks for attention, No.outputs somthing like this `شنبه ۲۴ خرداد ۱۲:۳۸ `. this is Persian time and date. — Milad Abooali, Jun 14 '14 at 16:26
Check your character encoding on MySQL. And from the sounds of it, you might want to use a `TIMESTAMP` field, and use numbers instead of VARCHAR — Noah, Jun 14 '14 at 16:33
before executing the query check whether you get the value in variable...echo it.. — Ezhil, Jun 14 '14 at 16:35
try like this $price_exchange_update2 = mysqli_real_escape_string($rate_db, $price_exchange_update); — Ezhil, Jun 14 '14 at 16:40
I echo `$price_exchange_update2`, it's not diffident with `$price_exchange_update`. But it's work ! so thanks. — Milad Abooali, Jun 14 '14 at 16:48

whats wrong on this cod? update mysql with php

0 Answers0