Skip to content

Tag: mysql

Laravel : Upload 64base image instead of normal

I have an application using React and Laravel where I’m uploading images. I’m using Laravel Image Intervention package. When testing my API, the upload for a normal image works perfectly. Using React, the user can select an image from his pc and crop it, then he sees the preview as a generated cro…

select all records and the rest

here is a simple mysqli query to select specific records from my mysql database: The question is: How can I get (best practices) all the other records, which will not be selected with this query filter? Answer Running successive, more or less identical, queries in a loop is fundamentally a bad way to do thing…

utf8_encode difference between result in SQL and PHP

I’m using utf8_encode to make sure that the input from my users is transforming the special characters to a character where my MYSQL can do a search on. (My database is set in latin1_swedish.ci). When I echo my query, I get a perfect query that I can run against my MYSQL (and I get an result). But when …