php - 'Connection failed: SQLSTATE[42000]: Syntax error or access violation: 1064 -


i working on xampp local server , coding php using netbeans, below code working fine.

 $sql = "insert enneagram (name,course,activity,type,peacemaker,loyalist,achiever,reformer,individualist,helper,challenger,investigator,enthusiast,instinctive,feeling,thinking,assertive,dutiful,withdrawn) values ('$answerdata[0]','$answerdata[1]','$answerdata[2]','$mytypes',$a,$b,$c,$d,$e,$f,$g,$h,$i,$instinctive,$feeling,$thinking,$assetive,$dutiful,$withdrawn)";

i uploaded file on online server , giving me error

'connection failed: sqlstate[42000]: syntax error or access violation: 1064 have error in sql syntax; check manual corresponds mariadb server version right syntax use near \'. values (\'karim bahsoun\',\'communication\',\'activity\',\'|loyalist|individualis\' @ line 1'

it's third day looking @ code , not realizing why worked offline , not online.

there . after withdrawn) should not there.

also note using post data directly sql leaves wide open sql injections. should use prepared statement


Comments

Post a Comment

Popular posts from this blog

resizing Telegram inline keyboard -

telegram's inline keyboard great feature lots of different use cases. inline buttons added list of items this: inline_keyboard = [[inlinekeyboardbutton(text="button", callback_data="button"), inlinekeyboardbutton(text="reset",callback_data="reset")]] inline_keyboard_markup = inlinekeyboardmarkup(inline_keyboard) update.message.reply_text("hi", reply_markup=inline_keyboard_markup) the above code adds 2 buttons each half width of chat screen. i know the normal keyboard button there resize_keyboard parameter somehow can used. my question is there way resize inline buttons ? example make full width or quarter width. unfortunately, can't now. :( you can suggest @botsupport , might add feature next version.
Read more

javascript - How to bind ViewModel Store to View? -

i'm pretty new ext js , trying embed multiselect inside panel . the viewmodel has stores property can see here: ext.define('test.view.controls.search.searchfiltermodel', { extend: 'ext.app.viewmodel', alias: 'viewmodel.filter', data: { title: '' }, stores: { test: { fields: [ 'id', 'name' ], proxy: { type: 'ajax', url: 'api/test', reader: 'array' }, autoload: true } } }); i bind in view this: viewmodel: { type: 'filter' }, layout: 'fit', border: 1, plain: true, scrollable: 'y', layout: 'fit', bind: { title: '{title}', }, items: { xtype: 'multiselect', scrollable: false, allowblank: true, ddreorder: true, bind: { store: '{test}' }, valuefield: 'id', displayfield: 'name' } ...
Read more

javascript - Solution fails to pass one test with large inputs? -

function birthdaycakecandles(n, ar) { // complete function ar.sort(); var biggestno = ar[(ar.length - 1)]; var total = 0; (var = 0; < ar.length; i++) { if (ar[i] === biggestno) total++; } return total; } here's problem - https://www.hackerrank.com/challenges/birthday-cake-candles/problem there no need sort array, can problem in o(n) times function birthdaycakecandles(arr, n) { var total = 0; var len = arr.length; (var = 0; < len; i++) { if (ar[i] === n) total++; } return total;
Read more