Questions tagged as 'mysql'

Tagged questions
1
answer

Activate and deactivate a button according to the selection in MS Visual Basic checklistbox?

Cordial greeting colleagues, it turns out that I have a CRUD in MS Visual Basic, connected to a database called quote, works perfectly, I use a checklistbox that is filled with the data of the bd and I also use it to select the records to those...
asked by 13.02.2018 / 20:02
2
answers

Delete data mysql php [closed]

I have a table made where it shows me records of a database in mysql.In the table for each record is created a button that is called delete and what I want to get is that by clicking this record is deleted. I have this code made in usuarios.p...
asked by 10.02.2018 / 17:18
1
answer

Query laravel 5.6

Hi, I'm doing what I tried to do something half complex that does not work out for me, it's the following: I have 3 tables: users: the table that comes by default in laravel payment_type: I show the types of payments payment_users: I get...
asked by 12.05.2018 / 22:52
1
answer

Codeigniter - transactions stored procedure

Is it possible ?, they work as they should? do transactions by invoking store procedure from query builder ?, that is, the changes are reversed with rollback in case of error ?, thanks. $this->db->trans_start(); $this->db->quer...
asked by 13.05.2018 / 05:44
2
answers

Search for a word within a php record

I do not know how to explain in the title what I need I'm trying to do SQL query to find a word within my table For example: An input where you put a word and look for it in the whole table. This is easy with this php if ($row['cli...
asked by 09.02.2018 / 12:51
1
answer

Store image in MySQL database [closed]

I find the situation that, I have to show through a query to a MySQL database in the cloud an image in an android tlf, through a PHP file. The doubt is that I do not know which is the best or easiest way to do it, if saving the image as a blo...
asked by 02.02.2018 / 11:17
1
answer

Error 1064 (42000) syntax sql error

I have the following line of code in a bash script. echo password | sudo -S su -l otrouser -c 'mysql -e "GRANT ALL ON wordpress.* to 'usuario'@'localhost' IDENTIFIED BY 'userpass';"' I want to execute the mysql statement as another...
asked by 06.02.2018 / 15:54
1
answer

Select certain MySQL table rows

Well, I have the following code: function dameTodosLosProyectos( $con, $cantidad = 0 ) { if( $cantidad > 0 ) { $query = "SELECT * FROM proyectos LIMIT $cantidad"; }else { $query = "SELECT * FROM proyectos";...
asked by 06.02.2018 / 11:49
3
answers

Record data "date" in Mysql + PHP

I am trying to save a date in DD-MM-YYYY format, but I can not get it to be added in the bbdd. In PHP code I have: $nid = $_POST['nid']; $first_name = $_POST['first_name']; $birthday = $_POST['birthday']; $query = "INSERT INTO users('nid','fi...
asked by 01.04.2018 / 17:08
2
answers

Error making an insert with an empty field mysql

I have a problem with inserting data into a table. The case is that when doing the insertion I do not take the field '' as a value null or 0 I just skip error. I have already checked the table and the field that in partic...
asked by 05.02.2018 / 11:54