Posts by Eduardo • 147 points
13 posts
-
2
votes1
answer39
viewsQ: Optimizing columns of Mysql tables that receive only two different values
I have a Mysql table with 30 columns, and 25 can receive only one of the following values: Not or Yes. Currently they are defined as char(3). In case I convert these char columns to tinyint,…
-
-1
votes1
answer50
viewsQ: Query with Left Join considering the most recent records from the auxiliary table
I have two tables: curriculo (cur_codigo,cur_nome) lembrete_envios (lem_codigo,lem_curriculo,lem_data,lem_tipo) The table resume stores candidate ID and candidate name The table reminete_shipments…
-
0
votes2
answers37
viewsQ: Generating sequential Ids for each user in the same Mysql table
I have always used the primary key itself as the default identification code for each record in a database table. Once the table has been used by several users, and each one has its own registered…
-
2
votes2
answers1148
viewsQ: Block user access with foreign IP’s
It is possible to restrict access to a particular website or Web system, so that only IP’s in Brazil can access it? I have a mini-system in PHP, and to further increase its security, I would like to…
-
0
votes1
answer39
viewsQ: Listing all categories with total number of products
I need to mount a query that displays the name of all categories, and in front of each name the total number of products. The tables are: Categorias (cat_codigo, cat_nome) Produtos (pro_codigo,…
-
2
votes1
answer791
viewsQ: Function to allow only one vote per piece of equipment
I set up a simple polling system in which it is possible to vote only once per IP. However, it records the network IP and not the user’s computer, making it impossible for other equipment on the…
-
0
votes2
answers87
viewsA: Div disabling jquery find next element
Try using it as follows: var proximo = $(this).parents('.caixa-dependentes2').find('.bb').eq(0).val();
-
1
votes2
answers179
viewsQ: Enabling fields (array) with Jquery when checking checkbox
Good afternoon guys, once again I need your help for the following problem: Imagine the following form records below: <input id="check[1]" name="check[1]" type="checkbox" value=""> <input…
-
1
votes1
answer51
viewsQ: Unread array with index set in input
see below the following code: <input type="text" id="task" name="task[]" value="100" /> <input type="text" id="task" name="task[]" value="110" /> <input type="text" id="task"…
-
0
votes1
answer59
viewsQ: Doubt with htaccess file
Hello, everybody! I have a question regarding my HTACCESS file. I happen to have a site in two versions, common and mobile. In the folder of the mobile file, there is the file . htaccess that…
-
1
votes0
answers21
viewsQ: Doubt with htaccess files
I have a question regarding a configuration in my file . htaccess. I have a page with the following name: gastronomia.php Hence in my file includes the following line to make it friendly:…
-
0
votes2
answers713
viewsA: Question about data loading via Modal Bootstrap
See below for a good example: <p>Link 1</p> <a data-toggle="modal" data-id="ISBN564541" title="Add this item" class="open-AddBookDialog btn btn-primary"…
-
2
votes2
answers2246
viewsQ: Delete record from Modal Bootstrap window
I’m trying to delete a record from the Bootstrap modal window, but it’s not working. Look how I did: By clicking the delete button of a particular record <a class="btn btn-primary delete"…