SQL PHP fix
- or -
Post a project like this1506
£10(approx. $13)
- Posted:
- Proposals: 8
- Remote
- #2723409
- Awarded
Web Design & Development | Ecommerce | Html | CSS | javascript | React | PHP | PSD to Responsive | Mysql | Software Development
Dhaka
Web developer | Graphics designer | Mobile Apps Developer | Server administrator AWS, Digital Ocean
Karachi
406802121301016636901750695198863125510973598383546927
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."'');
Ben S.
100% (36)Projects Completed
23
Freelancers worked with
23
Projects awarded
28%
Last project
7 Feb 2021
United Kingdom
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.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies