Questions tagged as 'mysql'

Tagged questions
1
answer

Optimize HTML table load

I have an HTML table in a PHP project which is filled with data from MYSQL, the Select with which the table is filled, among other things, by 3 INNER JOIN, when executing the query from Workbenck this delay approximately 0.428 seconds in perform...
asked by 22.07.2018 / 13:14
1
answer

Add values of a select within a while

What I am trying to do is to add the values that are selected in the select, I do not know if my method is correct, but if it can be solved I would appreciate it, and if it is better to do it in another way please I hope of an idea of how to fix...
asked by 23.07.2018 / 01:22
1
answer

Show Check saved in Database

I am saving the values of a checkbox in mysql but I need that when I show it if I keep 1 it appears activated but if it keeps 0 it does not appear checked So I keep it $id = $_POST['mod_id']; $name = $_POST["mod_name"]; $code = $_PO...
asked by 20.07.2018 / 17:34
0
answers

Can I format a string in a Django queryset?

I'm trying to simulate this stringformat "% s03d"% (name.upper (), number), in a Django query. It is not as easy as doing the field query in the model because it is not stored in the database. DummyModel.objects.all().annotate( format_str=...
asked by 20.07.2018 / 07:18
1
answer

Insert form to database

I have no experience in design, but I have this little problem I am putting a bad data, please help. This is the form or just part of the error <div class="col-md-6 col-sm-6 col-xs-12 xdisplay_inputx form-group has-feedback"> <inpu...
asked by 19.07.2018 / 18:34
0
answers

How to group records from a parent record?

I'm doing the list of pages to be able to add permissions to that user, but I have some inconveniences regarding the listing. What I want to do is list the pages according to the parent record and separate them by a space. Here I have the...
asked by 18.07.2018 / 14:39
0
answers

Repeat the fields by pressing add 2 or 3 times or more

private void btnAgregarActionPerformed(java.awt.event.ActionEvent evt) { this.proveedor = new Proveedor(); proveedor.setPresente(txtpresente.getText()); proveedor.setEquipo(txt...
asked by 21.07.2018 / 01:44
1
answer

Place boundary in relation one to many php laravel

I'm doing an app in laravel, but I get to a situation where the DB relationship is one to many users - articles, so my problem is that I want to place a limit that users can only add max 5 articles, I've been looking for, but nothing I try to tr...
asked by 25.07.2018 / 16:10
1
answer

I have a db and the table I have it in phpmyadmin does not insert data

CONNECTION.PHP <?php $conexion = new mysqli("localhost", "fran","123","frankliber"); ?> FORMULARIO.PHP <!DOCTYPE html>- <html> <head> <title>Guardar</title> <meta charset="utf-8">...
asked by 18.07.2018 / 13:56
1
answer

Remove Line Jump in a Textarea php mysql javascript

I have this problem, that when entering text with line break to the textarea of my field Description product remains the same as the following image. Well, when I give it to record or save in this way with line break when showing in my...
asked by 19.07.2018 / 06:59