Questions tagged as 'mysql'

Tagged questions
1
answer

What's the difference between a documented function and a list-only argument?

I was reading through the PHP documentation and came across this note when I was passing through the function str_getcsv And I was left wondering what the difference would be, someone willing to explain or say where it would be t...
asked by 06.09.2018 / 16:07
1
answer

"NOT IN" behavior affecting column display with NULL value

I have a table where I record the purchases made by the site. I use a field called status_plataforma to receive the transaction status of the SecurePage. This field, besides being able to receive an integer, by default it is NULL...
asked by 20.08.2018 / 14:34
1
answer

Inner join repeating data

I use a query using the inner join, but the problem is that it duplicates the results I have a table in mysql that is called produtos_destaque where id_produtoDestaque is a foreign key in the benefits table. My problem is that a pr...
asked by 12.01.2017 / 06:43
2
answers

Application does not save data and only saves code

I'm developing software for an MVC (model-view-controller) design video store and the problem of not saving people is occurring. It only saves the code of the people and I do not even know why it is happening not to save the clients because my s...
asked by 22.10.2015 / 19:01
2
answers

Error sending some photos

I made a script that uploads a photo to the server and saves the name in MySQL, but some photos it does not send, some 3 mega pixels type JPEG is not sent and gives error. index.php: <form action="upload.php" method="POST" enctype="multi...
asked by 02.07.2018 / 20:34
1
answer

Show all products in an order Mysql

Good morning! Home I created an online store , this is a shopping cart. After the user chooses all the products, a page "payment.php" will appear, before that he inserts in the database the order , and all the products associated with such ord...
asked by 28.06.2018 / 12:41
2
answers

How to loop with input select PHP?

I have an array with $ c name that I made through a precise explode to do the count with for to see if it is selected. The problem is that it does the echo of option 2 or how many times there are records. Does anyone have a solution for this?...
asked by 28.07.2015 / 22:25
2
answers

How to create a REST service with PHP and MySQL and .htaccess

I am developing a small project, where some information should be stored in a MySQL database that is hosted in a PHP hosting, I wanted to know if I have a way to develop a REST service to insert the data into a MySQL database.     
asked by 06.07.2015 / 22:58
2
answers

MySQL: Windows or Linux? [closed]

Which one performs best for dedicated server with MySQL considering several complex calculations in Stored Procedure and Functions?     
asked by 02.07.2015 / 22:04
1
answer

SQL with empty join

I need to do this query with MySQL returning according to year. But for those with no working hours, the field must be NULL For example: year 2017 SELECT 'turmas_has_estudantes'.'id', 'turmas_has_estudantes'.'numero'...
asked by 25.06.2018 / 16:39