Questions tagged as 'mysql'

Tagged questions
0
answers

Error creating a procedure: Cursor declaration after handler declaration

I'm trying to create a procedure But I'm getting this message: Cursor declaration after handler declaration I'm trying to do 3 loops DROP PROCEDURE IF EXISTS 'sp_curso_aprovados'; DELIMITER $$ CREATE PROCEDURE 'sp_curso_aprovado...
asked by 16.08.2018 / 16:21
0
answers

Report iReport does not include the fields in the Summary tab

In the management system I'm working on, I generate a PDF non-fiscal thermal printer voucher made in iReport using the PHPJasperXML library. In this voucher, when you have only one product (one row) in the Detail tab, the Summary fields are blan...
asked by 16.08.2018 / 14:47
0
answers

Three dynamic comboboxes

I have these 3 dynamic comboboxes: <fieldset class="grupo"> <table class="campo" cellspacing="10"> <tr> <td> <strong><label for="Valência">Valência</label></strong>...
asked by 17.08.2018 / 12:37
1
answer

Take record in the bank and if duplicated, show only one

I have a table in the bank called orders, where the number of the control can be duplicated, since the customer in the same order can buy 2 items, ie each line will insert a purchased product but with the same control number, and I wanted to sho...
asked by 13.08.2018 / 19:53
0
answers

Registration (Log) of visits to a Website through IP and guradar in a DB

After a search I still have not found what I wanted. I wonder if you can help me with the reasoning for this feature. With PHP and MySql is it possible to save visits to a website in a database, and in this, save the IP of who accessed the page?...
asked by 06.08.2018 / 11:00
1
answer

How to access mysql base from an external network

I have an application, on Android with MySQL database, that works perfectly within a specific network. But when trying to access this same base in an external network I get the following message:    28000Acess Denied for user 'root' @ 'my ip'...
asked by 03.08.2018 / 19:22
0
answers

Connect my pc's database to the hosting

I want to connect the hosting to the local database of my PC I'm using linux. I have the doors 1604 and 8080 open. When I access my ip: port on an external network, I can access my website. But when I go to the hosting, it does not connect to th...
asked by 05.08.2018 / 09:30
1
answer

How to retrieve date field (mysql + php)?

I have a field of type date in mysql, the problem is that I can not retrieve it, by selecting it and printing only the name of it appears (date). $dados = mysqli_query($conexao, "SELECT 'data' FROM tabela"); $res_data = mysqli_fetch_array($da...
asked by 12.08.2018 / 12:29
2
answers

MySQL query error - Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, object given in [duplicate]

Hello, I am doing a query with PHP and I am connecting to the normal database, but when I return the query and mount in the table it is returning the error: Warning: mysqli_fetch_array () expects parameter 1 to be mysqli_result, object given...
asked by 03.08.2018 / 16:48
1
answer

How to print multiple textarea (used with TinyMCE), which are recorded in BLOB, in a single PDF?

I have several textarea (over 20) on different pages of PHP and I use TinyMCE as the editor for all of these textarea. All are written in MySQL as BLOB, since all textarea allow text and image, and many characters in each. My problem: I can not...
asked by 03.08.2018 / 04:37