So I am updating my mysql database using php. Below is the end of the UPDATE, and if I have a string instead of echo $row[embedcode]"); it works fine, and this echo sets data on the page just fine retrieving the right value, but within this UPDATE it doesn't work.
...WHERE `embedcode` = echo $row[embedcode]");
I have tried using ". ." around it and adding its own php tag around it but I'm not sure what needs to be done.
Just use this:
...WHERE `embedcode` = " . $row[embedcode]);
There is no need for echo.
As a side note, you should probably parameterize or at least sanitize any strings that go into a MySQL query to prevent SQL injection and other bad things.
" ... WHERE `embedcode=` '" .$row[embedcode]. "';");
<a href="<?php echo $uv ?>">test</a> with uv being the update query. Because it's in the anchor tag, I thought it would only happen when clicked.
href attribute, it will be handled as a string of an url, either relative or a full url. so if you really want to use the a tag as a button, than you should do something like this in the php: $uv=$_GET['uv'] and the html part should look like this: <a href="/uv=<?=($uv+1);?>">button<a> but this will cause the page to reload every time you click on the button and i think -without seeing the whole code- that JS would be better to use...if(isset($_GET['uv'])) { .. UPDATE .. } than that could be a solution. post a bit more and then i can help more..http://yoururl.com/?uv=somenumberWHEREembedcode= . $row[embedcode]); will set the value.
There is not need for echo inside the sql statement. echo is used for displaying something from php to the webbrowser.
You don't use echo, perhaps it should be:
...WHERE `embedcode=` . $row[embedcode]");
Not that if $row[embedcode] is a string you have to put quotes around it.
Let say for example...
("UPDATE `tblProfile` SET `profilename` = 'abc' WHERE `embedcode` = '".$row['embedcode']."'");
to prevent SQL injection, you can pass that value as a parameter if you are using PDO or MySQLi.
For example,
$stmt = $dbConnection->prepare('...WHERE `embedcode` = :embedcode');
$stmt->execute(array(':embedcode' => $row[embedcode]));
See this for details.
