DEV Community: Julian

How to delete a file uploaded in database

Julian — Sat, 02 May 2020 21:07:31 +0000

To delete a file loaded on a server, we must enter the following code in our program:

// We proceed to delete
if (! unlink ('uploads /'.$ file)) {
// print error when deleting
echo 'Error deleting';
} else {
// File deleted
echo 'File deleted';
}

How to get the date in Spanish, with the format name of the month, day and year

Julian — Fri, 01 May 2020 20:57:15 +0000

It's normal that on a web page we want to print the date showing the name of the month, because normally what we do is print a date style 01/05/2020 and it is not ideal, since to view events in a program, blogs, among others the ideal format is to have the name of the month and in Spanish, since by default in Mysql the date appears in us format.

The following code was implemented within PHP and can be implemented for your programs:

$ res = mysqli_query ($ link, "SET lc_time_names = 'es_ES';");
$ res = mysqli_query ($ link, "SELECT id, title, DATE_FORMAT (date, '% M% d% Y') as date FROM table order by id desc limit 3");

How to Convert date format to PHP with MYSQLI, using secure queries to avoid SQL injection

Julian — Tue, 28 Apr 2020 14:19:54 +0000

There are cases in which we need to send a date format in Spanish to a sql query, for example the format of (Abril 28 2020) and for this we must do the following:

$ query = mysqli_query ($ conn, "SET lc_time_names = 'es_ES';");

$ query = $ conn-> prepare ('SELECT id, DATE_FORMAT (date, "% M% d% Y") ,, text FROM table WHERE id =?');

Keep in mind that these queries are what we should do in our developments to avoid sql injection.