Questions tagged as 'mysql'

Tagged questions
1
answer

Use FULL JOIN in MySQL

I needed to do a query that returns me in a line the data of a candidate plus the courses to which he applied, being that this data is in a relational table 'tblcandidatoCurso'. After some research I tried to use the FULL JOIN, but it always app...
asked by 14.04.2016 / 15:04
1
answer

Prevent duplication in DB due to FOR loop

I'm creating a multiple image upload system. The "move_uploaded_file" function works fine. The problem is that I included a $ grav insert for the DB, and as it can be seen in the code, it would only be sent if the IF conditions of the images wer...
asked by 06.04.2016 / 04:36
1
answer

Total SQL Records in all columns

I need to return the total records of the query in a column, repeated same, type this: However, the query is a bit annoying. A query of 106 rows, with multiple SUM () and with a mandatory ORDER BY. I can not use GROUP BY in this query beca...
asked by 05.04.2016 / 17:34
1
answer

Help with image upload and preview with $ _SESSION or $ _COOKIE

I need to ask the user to change the image without changing the database source file, that is, when the user terminates BROWSER after the exchange, he or any other user entering the Site again, you will find the same boot image as it is stored i...
asked by 20.05.2016 / 00:21
1
answer

Send a value to the modal

I have a table with several employees and it counts the plate of each hum.   I created a modal that when the manager clicks on the employee's name is called a modal where you can enter the number of the plate.   Reason: there are situations...
asked by 20.05.2016 / 23:44
2
answers

In the "while" method adds to the array

I'm trying to produce a script that when I query in mysql it returns an array, so far ok, but the goal is to have this query turn an edited json. Example: {"changelog":{"count":2,"news":{"ola":"testando1","ola2":"testando2"}}} And in C # I m...
asked by 26.04.2016 / 17:52
1
answer

Script to restart MYSQL automatically when dropped?

I wonder if there is any script that will restart mysql if it crashes. I'm having some problems with mysql on my site and eventually it crashes, kind of 3 in 3 days it crashes, I've already adjusted the memory to optimize the system but I'd like...
asked by 06.05.2016 / 12:38
1
answer

Retrieve an overall rating and display in a list

Good evening guys, I'm in the following situation, I have a table called cars, and each car can be evaluated by different users, so I have created a secondary table called ratings and each car can be evaluated by several different users. N...
asked by 07.05.2016 / 00:13
1
answer

Problem with ajax and cURL to receive mysql value and return to html

people I'm having a problem using html, ajax, cURL and mysql. the function is simple an html page where will receive a name and will send by ajax to cURL that will access the php that connects to mysql and takes 2 column of the table and returns...
asked by 05.05.2016 / 00:39
1
answer

Catch information from a foreach with another foreach

I have a mysql search that brings me the following array when using a foreach, I have another sql search that brings me all the fields of a table that in case they are the same field names that are below usr_tbl_ssid ... how do to display only t...
asked by 23.04.2016 / 12:10