Questions tagged as 'mysql'

Tagged questions
1
answer

Insertion in Mysql with radio button + option + input

How do I insert the value of <input> into the database as the radio button is selected? A template is attached: $funcionario=$this->funcionario->get_all_funcionario();if($funcionario->num_rows>0){$row=$funcionario->...
asked by 23.02.2015 / 21:36
2
answers

Jquery for follower insert

Good afternoon, And the following I have an area where users can follow other users need to know if using jquery when clicking next and it is possible to insert in the table the data and change the button to not follow and another color if an...
asked by 20.02.2015 / 18:28
1
answer

mysql - Query to convert columns into rows

I have my query: SELECT inscricao, assiduos_a1, assiduos_a2, max(data_inclusao) FROM cli_agendados_assiduos WHERE INSCRICAO = 10357410; That returns: inscricao assiduos_a1 assiduos_a2 max(data_inclusao) 10357410 337 508...
asked by 06.02.2015 / 12:54
1
answer

Subcategory listing according to selected category

I have the following code snippet: <?php foreach($categorias as $cat){ $id_cat = $cat['id']; $subcategorias = array(); $sqlsub = Comando::Executar("SELECT * FROM subcategoria WHERE cat_pai = '$id_cat' ");...
asked by 02.02.2015 / 22:26
1
answer

Problem with SESSION in php

Good people, I am developing a login for my page but I have a problem that you are not saving me the data I want to give you. Code require_once("../gtm/bd/funcoes.php"); ligarBd(); // Verifica se houve POST e se o usuário ou a senha é...
asked by 02.02.2015 / 23:48
1
answer

Correct way to write multiple records at once dbgrid and clientdataset

I have to write several records at once in the database, I am using the form below, however I think giving applyupdate to every interaction is not the correct way. Is there another way? procedure TFrm.Button1Click(Sender: TObject); Var i: Inte...
asked by 30.01.2015 / 23:45
1
answer

Search counting result

I search for a certain term and show the result, which is correct, now I need to show the quantity of each product by category, for example, search for the term "chair." COZINHA (10) DORMITÓRIO (05) My search for the term looks like this:...
asked by 01.02.2015 / 13:29
1
answer

SQL only in custom WordPress post for tag conversion

Let's say that a site using WordPress has half the posts of the standard type, and the other half uses a Custom Post Type "review" . But this type of post had no registered tags, so it shared those of the standard posts (post_tag). After...
asked by 31.12.2014 / 00:37
2
answers

Convert an integer from the database into an Array

I want to convert an integer from the DB into an Array, for example: I have the number of deliveries registered in the DB, let's assume that the 'x' production is completed in 5 deliveries. this number 5 is entered in the DB as a String, a...
asked by 26.12.2014 / 14:49
2
answers

How to insert into tables with many-to-many relationship?

I have a question about how I'm going to do the insert with relationship n:n My tables are: Recibo Analise Analise_Recibo (recibo_id, analise_id)     
asked by 20.12.2014 / 12:54