what can I change, when loading an xlsx to excel and if a cell has: 'mark error

Navigation
0

good day. I already have the page created and I upload my excel files to mysql using php, all right up there but when cell has the sign of '

There is an error when inserting or updating the table. Excel files send them to me, I adapt them to my excel format to upload them. you can change something to the php library, to the code or just delete the '' '' to the cells.

this is what has a cell that gives me error: SAFETY CABLE 7.6MTS MOD STEELBRAID 25 '

and if I simply leave it like this: SAFETY CABLE 7.6MTS MOD STEELBRAID 25 it works. and send me the error in the next cell that has' ''

this is the error that comes out:

  

error when UPDATING dataYou have an error in your SQL syntax; check   the manual that corresponds to your MySQL server version for the right   syntax to use near 'padlock', existProd = '100', existMinim = '25 ',   priceComp = '267.12', priceMay = '274.' at line 1

    
asked by EngelDragoner 23.06.2018 в 05:39
source

1 answer

0

I already know why it marks error, it's because it's a SQL insert, and the way to remove that error is with 

$mysqli->real_escape_string( )

So everything simply reads it as innocuous characters

    
answered by 15.08.2018 в 19:06
Why is it null? Java heritage Formula concatenate excel in c #