Posts by Sergio Silva • 93 points
12 posts
-
1
votes1
answer84
viewsQ: Change login user status
Good morning, I am learning PHP and created a login system. I would like help with the code to change the status of logged in user. I have a list of users who are online and, when running this…
phpasked Sergio Silva 93 -
0
votes1
answer46
viewsQ: Update with foreingkey
I’m having trouble editing a key Foreign key. The code receives the id, but I can’t get past the id of Foreign key to the value using Inner Join. I receive this message: Cannot add or update a Child…
phpasked Sergio Silva 93 -
1
votes0
answers191
viewsQ: update table with Foreign key
I am trying to update a table with foreign keys, precisely in foreign keys I want to leave them with value NULL update but I’m not getting this is my query: $sql = 'UPDATE agenda SET…
-
1
votes3
answers816
viewsQ: Validate field of CPF
I’m having trouble validating the Cpf field. In my code he is inserting Cpf in the bank always with value number 1 and returning me false, but Cpf is real. How to fix it? code: <?php /* @autor:…
phpasked Sergio Silva 93 -
1
votes1
answer74
viewsQ: Select and display data from a position in the database table
I need to create two tables on the same page where in the first one will have only one client, in the case, the first of the list and in the second the other customers, the problem is that when I…
phpasked Sergio Silva 93 -
0
votes1
answer45
viewsQ: refresh
Good morning! I would like your help , because I need to refresh a page at a certain time , I got this script , but it is not working. If you can help me, thank you . <script…
phpasked Sergio Silva 93 -
0
votes3
answers270
viewsQ: variable interval php time
I would like to add this variable interval to this code but I am not getting it , if you can help me I will be very grateful. I found this code on the Internet and adapted it to my system, but I…
phpasked Sergio Silva 93 -
1
votes1
answer53
viewsQ: foreign key
I’m having trouble recording null value in foreign key. When I save to my phonebook with id_pessoa blank, it records 0 and not null. How can I fix it? This I my code and table : person: id_pessoa…
phpasked Sergio Silva 93 -
0
votes1
answer368
viewsQ: Schedule grid with PHP
I’m having a little problem with my code, which generates schedule, it’s not entering the last time. type 07:00 to 10:00 30 min interval but it only goes until 9:30 does not record the 10:00 This is…
phpasked Sergio Silva 93 -
0
votes1
answer108
viewsQ: Write multiple records from one table to another with php
I have two tables, a scale with schedules and a related one called agenda. tabela escala id_escala hr_inicio tabela agenda id_agenda id_escala hr_agendamento I want to record in the hr_schedule…
-
0
votes1
answer120
viewsQ: Left Join returning only certain fields
I have the following tables: tb_agenda id_agendaid_medicdatehour tb_patient id_patientpatient name tb_medic id_medicdoctor’s name tb_scheduling id_schedulingid_agendaid_patient I make the following…
sqlasked Sergio Silva 93 -
1
votes1
answer75
viewsQ: insert date sequence in sequence in the bank
I would like to enter the date in for it add + 1 day and insert again. I have this script but it returns me random date: date_default_timezone_set("Brazil/East"); $data = '2017-01-02';…
phpasked Sergio Silva 93