Phoenix - Your AI AssistantSQL PHP fix
- Posted:
- Proposals: 7
- Remote
- #2723409
- Awarded
Ahmedabad 
Description
Experience Level: Entry
I need to fix these code.
It seems to be something to do with commas and passed in variables
$newColor = $jsonData->newBgColor;
$originalColor = $jsonData->originalColor;
$bundle = $jsonData->bundle_id;
$query = $writeDB->prepare('UPDATE tbltasks SET bgColour = REPLACE('.$newColor.','','') where bundle_id = '".$bundle."' and bgColour = '".$originalColor."' or color = '".$originalColor."' or textBgColour = '".$originalColor."' or textColour = '".$originalColor."'');
It seems to be something to do with commas and passed in variables
$newColor = $jsonData->newBgColor;
$originalColor = $jsonData->originalColor;
$bundle = $jsonData->bundle_id;
$query = $writeDB->prepare('UPDATE tbltasks SET bgColour = REPLACE('.$newColor.','','') where bundle_id = '".$bundle."' and bgColour = '".$originalColor."' or color = '".$originalColor."' or textBgColour = '".$originalColor."' or textColour = '".$originalColor."'');
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.