Mysql query with PHP

Question

I’m making an appointment at Mysql to return the quantity of orders that were not delivered.

To see what was delivered I do:

$result = mysql_query("SELECT operacional FROM `pedidos` WHERE `status` = 'ENTREGA REALIZADA'");

However, there are some requests that status is: DELIVERY HELD ON 20/10/2017 or even DELIVERY HELD ON 20/11/2017 - that is, the dates vary.

And besides, I need to take the ones that were not delivered. How can I receive only the items that do not have this text of "DELIVERY PERFORMED"? Because this space never goes blank, there will always be something like OUTING or UNIT ENTRY, among others...

There is something like:

$result = mysql_query("SELECT operacional FROM `pedidos` WHERE `status` != 'ENTREGA REALIZADA'");

Answer 1

Friend a tip I give you is never use text in fields like status. Instead, you could solve this easily using the field status as INT. Doing something like that:

0 = Não Realizado
1 = Entrega Realizada
2 = Saída para Lista
3 = Entrada na únidade

And in the question of the delivered date, you could create one more field in the table called (for example) from data_status and whenever the status is 1 you update this column and put the date.

If you want you could also create a separate table only with status for consultation, something with the structure like this:

id
id_status
nome_status

So you can avoid future problems.

With your case above

I could test the following command and see which one fits best:

$result = mysql_query("SELECT operacional FROM `pedidos` WHERE `status` LIKE '%ENTREGA REALIZADA'");

$result = mysql_query("SELECT operacional FROM `pedidos` WHERE `status` LIKE '%ENTREGA REALIZADA%'"); //Talvez dê problemas no futuro caso tenha frases muito parecida no campo status

$result = mysql_query("SELECT operacional FROM `pedidos` WHERE `status` LIKE 'ENTREGA REALIZADA%'");

But do as I said at the beginning of the post, it is better, you will avoid problems and future headaches.

Remembering how the Anderson Carlos Woss quoted, use the function mysqli_ for all mysql_ are obsolete in new versions of PHP.

Answer 2

Thank you all! I confess that I solved my problem and learned a function that I did not yet know.

For this problem I decided to create an "Active" table to know whether or not the order enters the operation (which is to receive the data update):

If it is 0 he gets the update when the routine happens, if it is 1 he skips this request.

If the order that received the information has as Status -> DELIVERY PERFORMED the asset changes to 1:

I think that makes it safer! Strong hug and thanks for the information, were of great importance!