Posts by Fernando • 311 points

10 posts

1
votes

1
answer

34
views

A: PHP One Table Calls Another Dynamic Table

If you do not have many records you can do as I put below. Otherwise you will have to make a form with dynamic combobox using Ajax or something similar. <script> function pais_onchange(){ var…

php
answered 6 years, 7 months ago Fernando 311
1
votes

1
answer

80
views

A: Running time (Calculating dates)

Timestamp creation is wrong because it expects a date in specific format (as per manual), I made the change to use getTimestamp() after creating a Datetime from a specific format (createFromFormat).…

php
answered 6 years, 7 months ago Fernando 311
4
votes

2
answers

189
views

A: Is dynamic HTML via BD bad practice in PHP?

There is not a single way to develop in PHP and we always have to evaluate the context to define the best form of coding. A good practice is to use a software architecture standard that is…

php html database
answered 6 years, 7 months ago Fernando 311
0
votes

1
answer

920
views

A: It takes a long time to query in mysql

If the table has many records and this query is very recurrent or important to return quickly create an index containing all the fields used in the WHERE clause. Review BETWEEN clauses that receive…

sql query select
answered 6 years, 8 months ago Fernando 311
1
votes

1
answer

225
views

A: How to validate higher value received in mysql?

Try the comparison on WHERE as directed by @Ricardo Pontual SELECT u.id, concat(u.firstname,' ',u.lastname) as nome, from_unixtime(MAX(l.time)), DATEDIFF(now(),from_unixtime(MAX(l.time))) as Dias…

mysql sql select moodle
answered 6 years, 8 months ago Fernando 311
-2
votes

3
answers

5007
views

A: Accent error in mysql

All tables are with DEFAULT CHARSET=utf8 but no COLLATE set, as provided in the dump (example below). CREATE TABLE `adsense` ( `id` int(11) NOT NULL DEFAULT '0', `codigo` mediumtext NOT NULL,…

mysql asp character-encoding accentuation
answered 6 years, 8 months ago Fernando 311
2
votes

1
answer

705
views

A: reCaptcha Google

Your code only checks the name, which is a flaw: if (isset($_POST[nome])){ Your verification should follow this way: if(isset($_POST['g-recaptcha-response']) &&…

php html post recaptcha
answered 6 years, 8 months ago Fernando 311
1
votes

1
answer

99
views

A: Order taking only the last registered product

To solve this problem you should review the logic of creating your form. In this code he makes a while printing several times fields with same ID, which causes the field to be duplicated and in…

php mysql pdo
answered 6 years, 8 months ago Fernando 311
0
votes

1
answer

31
views

A: how to configure the SMTP Mailer in wordpress?

There is no additional information about the SMTP server but assuming "gsmtp" is Gmail, it follows information: For security reasons, Gmail blocks any incoming connection to your SMTP server. To…

php wordpress smtp
answered 6 years, 8 months ago Fernando 311
3
votes

2
answers

181
views

A: check if the day exists or not with the if

You have a problem using variables. Check for example that within a while you make an assignment of values in a variable: while($rows_cursos = mysqli_fetch_array($r1)) { $id_do_registro =…

php mysql
answered 6 years, 8 months ago Fernando 311