Posts by Fernando • 311 points
10 posts
-
1
votes1
answer34
viewsA: 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…
-
1
votes1
answer80
viewsA: 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).…
-
4
votes2
answers189
viewsA: 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…
-
0
votes1
answer920
viewsA: 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…
-
1
votes1
answer225
views -
-2
votes3
answers5007
viewsA: 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,…
-
2
votes1
answer705
views -
1
votes1
answer99
viewsA: 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…
-
0
votes1
answer31
viewsA: 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…
-
3
votes2
answers181
viewsA: 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 =…