Posts by Diego Vieira • 1,807 points
111 posts
-
1
votes1
answer1107
viewsQ: Registration in more than one table with Laravel
So, I have 3 tables (doctors, addresses and phones), first I do the insertion in the medical table using the store method that is in its own controller, and I take the id created for it and insert…
-
0
votes1
answer548
viewsQ: Style autocomplete background
The bottom of input is transparent, but when the browser automatically completes, it gets this color shown in the second image, is there any way to leave completed, but that remains transparent?…
-
1
votes1
answer119
viewsQ: List each user’s last message
Does anyone know how I could list each user’s last message? I was able to do that, but it lists the last message from just one user, and I wanted it to list everyone who sent a message to the user…
-
2
votes1
answer142
viewsA: List last logged in users (GROUP BY AND ORDER BY)
To list the last ones (decreasing), simply add the clause ORDER BY DESC, where: DESC: Descending ASC: Ascendant By default, the language SQL uses the ASC (ascending/ascending form). SQL: SELECT…
-
3
votes1
answer142
viewsQ: List last logged in users (GROUP BY AND ORDER BY)
I have two tables (user and log), and would like to list users ordering by last logged in. I am using the GROUP BY to join the logs (since a user may own more than one). The problem occurs when I…
-
2
votes0
answers115
viewsQ: POO list records
Hey, guys, which of these ways is best to list the bank records? The first is the structured way and the second is the object oriented is not? Thanks. First: $sql = $usuario -> listar();…
-
1
votes0
answers134
viewsQ: E-mail with Phpmailer and Cron (Ubuntu)
To schedule email submissions, do you need to do something other than put the file inside the /etc/cron.Aily folder (for daily submissions)? This code works when I run directly on the server, you…
-
0
votes1
answer91
viewsQ: Dotted effect on select and button in Firefox
Is there any way to remove this stippling that appears when you click on a select or button in firefox?…
-
0
votes1
answer64
viewsQ: List the post owner and the last user you commented on. Mysql
Eai guys, I have the following query below, where I list all posts, amount of comments and the user who created it, but also wanted to list the last user who commented each post, will be able to do…
-
0
votes6
answers393
viewsA: If it doesn’t work
Make these changes and see if you’re dropping into the IF. Under the $data_password, enter: $resultado_data = mysqli_query($conexao, $data_senha); $linha= mysqli_fetch_assoc($resultado_data); And…
-
3
votes2
answers141
viewsQ: Sort Mysql results using two tables
is the following, I have two tables, a so-called topical and other comments(which has a foreign key from the topical table), I wanted to list the topics by sorting them by the amount of comments…