Questions tagged as 'mysql'

Tagged questions
1
answer

Adding hierarchy points

My goal is to create a multi-level marketing system, with two teams. Left and Right Team I'm having trouble counting points. My table looks like this:   id_user | sponsor | leg (0 left, 1 right) | points Remembering that the ne...
asked by 26.04.2017 / 04:09
2
answers

Return primary key after insertion in MySQL

I need to insert two tables into my database, one of the tables has a primary key and the other one will use that value as a foreign key. My question is: How can I return the value of this primary key at the time of insertion? Or how can I do...
asked by 28.04.2017 / 05:29
1
answer

How can I pass the COUNT attribute on my sql string, since "COUNT" is a reserved php word?

Follow the select string: $resultado = mysqli_query($conn, "SELECT COUNT(*) FROM conta WHERE username:usuario AND userpassword:senha";     
asked by 28.04.2017 / 18:54
1
answer

Mysql - Searching using like does not correctly return unicode characters

I have a text editor in my application that writes html formatting to a longtext field. It turns out that when I use the like to return the data it can not find because of the unicode characters generated. I have this value in the bank (Past...
asked by 24.04.2017 / 05:06
0
answers

PHP form data does not enter the database

Hello, I'm new to PHP and I'm doing a small scheduling page but I've stuck in the data insertion part of the database, below my codes: Index.php <html> <head> <title> Controle de Coleta </title> <link rel="st...
asked by 24.04.2017 / 18:31
2
answers

The form is not being saved in the DB

Controller public function cadastro() { return View('/cadastro'); } public function novo() { $user = \App\User::where('User',"=", Input::get("User"))->first(); $user->name = Input::get('name'); $...
asked by 24.04.2017 / 19:18
0
answers

How to update a table with several fields

Next, I have a form, inside this Multiple Form Input with vectors, example <tr> <td style="vertical-align:middle"> <input type="checkbox" name="Checks[]" value="<?=$id_extrato?>"></td> <td style="verti...
asked by 23.04.2017 / 20:20
1
answer

PHP does not publish data in MySQL table

Hello! I'm a beginner in PHP, I'm trying to build an HTML form that should use PHP code to send the data to a MySQL table. It turns out that PHP code simply does nothing ... it does not publish data and does not return any error ... Cou...
asked by 09.05.2017 / 22:24
2
answers

Read TXT file in Rails

I have an application in Ruby on Rails and need to read a particular txt file that will be sent by the user. After sending the file, the data of the file will be displayed to the user so that it confirms if the file is correct, and if yes, t...
asked by 09.05.2017 / 13:51
0
answers

Question How to recover data in blob format and display in jsp

I'm not sure how to do this, but I'd like to know how to do this. even some example so that I can address myself, I'm using mysql as a database.     
asked by 09.05.2017 / 19:53