Posts by Erico • 715 points
11 posts
-
5
votes1
answer1214
viewsA: By clicking a php run button
It’s possible, but not like that. You have to create an ajax function and call another PHP script when the button is clicked, the way you made the PHP code always runs when the page is visited, no…
-
3
votes3
answers632
viewsA: Can apache rewrite to external url?
You can use the module mod_rewrite. Add the block below inside <VirtualHost><Directory> in your configuration file or .htaccess if your website is allowed to change Apache settings.…
-
2
votes4
answers352
viewsA: Error inserting json in Mysql with PHP
Stop using all functions starting with mysql_* and ban them in your code. These functions are discontinued and have been removed in the latest version of PHP (PHP 7). Using INSERT the way you are…
-
5
votes2
answers888
viewsA: Free access in Wordpress directory to print images? . htaccess
If showing page not found, it is because the file does not exist, wordpress does not restrict access to folders unless you explicitly configure this in . htaccess, this default wordpress setting…
-
3
votes1
answer670
viewsA: Problems with paging in Wordpress
If the page you are using this code is used as Static front page you have to check the parameter page also. if ( get_query_var('paged') ) { $paged = get_query_var('paged'); } elseif (…
-
8
votes2
answers2105
viewsA: timediff() limited to 838:59:59, how to resolve?
When the function SEC_TO_TIME() is used the value returned is of type TEAM, and restrictions on this type of data are applied (Minimum: '-838:59:59' and maximum: '838:59:59'). As in your case there…
-
7
votes3
answers7057
viewsA: System of infinite categories and subcategories/children
In database this type of result you are searching for is with a type of query that is better known as Hierarchical query (Hierarchical query or recursive query) com adjacency list. There is a lot of…
-
13
votes2
answers6430
viewsA: Increase number of rows returned by select group in Mysql
Mysql "no" has no default settings to limit SELECT queries. You’re probably using it Mysql Workbench which automatically puts LIMIT 0.1000 in all your Selects (Default settings). To disregard this…
-
5
votes2
answers18687
viewsA: How to add values of a field grouped by date?
I would change the design of this table. The way data is stored now you can’t bring any basic information regarding the reviews. An example of a new structure: date smallint NOT NULL id…
-
2
votes2
answers2445
viewsA: Json is not getting the data
Actually it’s not passing a JSON object, it’s simply passing a string. You are calling an attribute of the JSON object called product_preco, the attribute does not exist and neither the object. You…
-
1
votes1
answer428
viewsA: Mysql temporary table
Unable to create triggers with temporary tables. Taken from mysql manual You cannot associate a Trigger with a TEMPORARY table or a view.…