Questions tagged as 'mysql'

0
answers

Validate registration of a teacher in a course and a PHP section

I have a question that is giving me some headaches. I'm doing a system where I register courses (violin, guitar, flute ...) and each course will have a section (section A, section B, section C ...). Each course will have a day and a schedule of...
asked by 17.08.2017 / 02:35
1
answer

canvas and MySQL DB

I am trying to develop a small application for the management of users of a clinic, and I am faced with a problem and it is as follows. This clinic has to make its patients sign a sheet of paper, which is the data protection law in Spain and to...
asked by 17.08.2017 / 10:35
1
answer

how to remove options from a combo when selecting options from another combobox

I am doing a PHP project of registration, I have a combobox called schedule that contains the hours of 08:00 am-12:00pm and 03:00 pm-05:00pm to fill that combo I use the following <div class="form-group" style="padding: 20px">...
asked by 17.08.2017 / 16:24
1
answer

Error closing session with token

I explain I'm doing a login with 3 profiles and I managed to identify what profile I enter and be sent to your module until there is everything right the problem arises when I close session is blank screen and does not return to the index where...
asked by 17.08.2017 / 15:34
0
answers

can a trigger be created in mysql insert for two tables at a time with inner join?

I'm doing a project in PHP and MySql where I'm working the audit part with trigger, I would like to know if it can be done in the same insert trigger for two tables .. append here the code I was testing from phpmyadmin CREATE TRIGGER Perso...
asked by 16.08.2017 / 23:16
1
answer

How can I make this inquiry?

I need to count the number of spreadsheets in a range in table A , and I require that only count the number of spreadsheets that are TIPO CORRECTIVO , which is find in table B , I have the following query but I get a r...
asked by 23.08.2017 / 12:40
0
answers

Problem connecting mysql with web java (GlassFish)

I am making a connection with java web and MySQL, with GlassFish server, but when making the configuration in http://localhost:4848/common/index.jsf in JDBC Connection Pools I get the following error: HTTP Status 500 - Internal Server E...
asked by 16.08.2017 / 21:32
2
answers

Compare the fields of the same column

I have the following table: create table cumpleanios( Id_cumpleanios pk ai, Id_user mediumint, cumpleanios varchar(12) ); What I want to do is compare the field cumpleanios to know if a user has already inserted the birthda...
asked by 23.08.2017 / 10:28
1
answer

Empty PHP and MySql Array

I am learning how to program in php, and I found a problem when bringing data from MySql. The error, or problem, is that it does not bring any data from the "measurement" table. I am using WAMP, and the code is as follows: <?php $enlace...
asked by 22.08.2017 / 13:53
1
answer

How can I save a table and have the result displayed in another form?

I'm not that good with php and I want to understand it. How can I save a table and have the result saved in the main table? In the first image, this part of the main table when clicking Add sends another screen, at the time of entering the dat...
asked by 22.08.2017 / 16:21