Questions tagged as 'mysql'

Tagged questions
0
answers

Display query on the same form page

I'm doing a web application for a "Shared Racing" service (Uber type), where I want a CPF query to appear on the green card. I want when I check the CPF, present on the green card, without leaving the page. Formscript:<formid="cons_motoca...
asked by 11.05.2018 / 20:40
1
answer

Query zeroing column when applying order by - Mysql

I have a query that when sorting it in ASC it zeroes a column of my table, however if I command in DESC it displays values normally. This is a query: SELECT 'tab_medicamentos'.'id', 'tab_medicamentos'.'classe_terapeutica', 'tab_medicamento...
asked by 11.05.2018 / 21:08
0
answers

Transform column row MYSQL

I made the code below, and I would need to group by client, and I have week1, week2, week3, week4, and week5 but the information is on the same line, but this query is on separate lines separated by weeks. / p> Follow code and print for better...
asked by 18.05.2018 / 19:52
0
answers

Bookmarks are not appearing in google Map loaded by XML

I have the following file that connects to the database, returns the markers and adds them to an XML: <?php // Start XML file, create parent node $dom = new DOMDocument("1.0"); $node = $dom->createElement("markers"); $parnode = $dom...
asked by 11.05.2018 / 04:58
0
answers

Laravel Routes 5.6

Gentlemen, I'm having trouble setting the wheels and I get the following error: protected function methodNotAllowed(array $others) { throw new MethodNotAllowedHttpException($others); } I'm doing them as follows: route / web.php $th...
asked by 21.05.2018 / 21:16
2
answers

Number of "bound variables" does not match the number of tokens - connection

Fatal error: Uncaught PDOException: SQLSTATE [HY093]: Invalid parameter number: number of bound variables does not match number of tokens in C: \ xampp \ htdocs \ page-access \ function \ database.php: 48 Stack trace: # 0 C: \ xampp \ htdocs \ p...
asked by 10.05.2018 / 16:52
0
answers

MongoDB and MySQL connection problem

Recently I formatted my computer with a dual boot of win10 + ubuntu. When trying to reinstall the environment in ubuntu I had problems installing mongodb and decided to install the environment on windows. Initially everything went well and mysql...
asked by 10.05.2018 / 17:41
0
answers

How to create function to "change" and "delete"?

I have a table which displays the "data" already registered, and for each data has the "edit" and "delete". Now I am in doubt as to how I delete and change the data chosen. Need a specific page to "change"? The code for "inserting" data lo...
asked by 14.05.2018 / 12:54
0
answers

Return image from MySQL database

Currently I am trying to return an image from a database. Using java, I tried this command: pi.setImagem((File) rs.getBlob("imagem")); The variable that will receive the image is as "File", and in the database it is "BLOB". It was passed to...
asked by 14.05.2018 / 16:09
2
answers

Check if the same value is in any of the two fields

In a login system, I want the user to type the "user" or "email" that is contained in the DB. This works perfectly: DBRead('usuarios', "WHERE usuario = '$user' OR email ='$user' AND senha = '$password'"); However, I hate repeating code...
asked by 06.11.2016 / 15:25