mySQLI not updating, can anyone help?

Question

0.00/5 (No votes)

See more:

can anyone help me with this iv looked on lots of websites and tryed it many diffrent ways but i cant get it to work can anyone see a problem ?

mysqli_query($link, "UPDATE AlertPack SET Type = $type, Message = $msg WHERE Key = $uuid");

Posted 6-Mar-15 13:29pm

Member 11472678

Add a Solution

Comments

Peter Leow 7-Mar-15 0:55am

Too little information. Any error message?

Member 11472678 7-Mar-15 1:11am

no error message at all i cant get my head around it iv check that all the names for the tables and columns are correct

Member 11472678 7-Mar-15 1:16am

$uuid = $_REQUEST['uuid'];
$type = $_REQUEST['type'];
$msg = $_REQUEST['message'];
$name = $_REQUEST['name'];
$time = $_REQUEST['time'];
mysqli_query($link, "UPDATE AlertPack SET Type = '$type', Message = '$msg', Time = '$time', Sender = '$name' WHERE Key = '$uuid'") or (mysqli_error($link));
?>

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

anand vemuri · Answer 1 · 2015-03-06T18:12:00

Solution 1

PHP

//try this
mysqli_query($link, "UPDATE AlertPack SET Type ='$type', Message = '$msg'  WHERE Key = '$uuid'");

Posted 6-Mar-15 18:12pm

anand vemuri

Comments

Member 11472678 7-Mar-15 0:30am

i'm afrade this hasn't worked ether and im not getting a error message as i have added

mysqli_query($link, "UPDATE AlertPack SET Type = '$type', Message = '$msg', Time = '$time', Sender = '$name' WHERE Key = '$uuid'" or mysqli_error()

im baffled

Mohibur Rashid 7-Mar-15 10:12am

well, even the above query is still bad enough. your query still can fail if your type or msg or uuid contains invalid character. use mysqli_real_escape_string to escape all the illigal characters.

Member 11472678 8-Mar-15 10:56am

Thanks i have made the following changes

$uuid = $_REQUEST['uuid'];
$type = $_REQUEST['type'];
$msg = $_REQUEST['message'];
$name = $_REQUEST['name'];
$time = $_REQUEST['time'];
$uuid = mysqli_real_escape_string($link, $uuid);
$type = mysqli_real_escape_string($link, $type);
$msg = mysqli_real_escape_string($link, $msg);
$name = mysqli_real_escape_string($link, $name);
$time = mysqli_real_escape_string($link, $time);
mysqli_query($link, "UPDATE AlertPack SET Type = '$type', Message = '$msg', Time = '$time', Sender = '$name' WHERE Key = '$uuid'") or (mysqli_error($link));
?>

did you mean like this ?

by the way this also did not work