iono | Arduino libraries for Iono Arduino and Iono MKR

Your two rules "were" in the wrong order. Your external redirect (HTTP to HTTPS) needs to be before the internal rewrite. Your first rule (rewrite) would have still applied, but it would have resulted in an external redirect to index.php?action=... (exposing your internal file/URL structure).

However, you are also missing L flags on both these rules.

You're creating $products_arr multiple times in a loop but you are only ever ending up with one element in the array.

Instead of $products_array = array(...) (which will replace the contents of $products_array every time with one single element), you need to use $products_array[] = array(...), which will push an element to the end of the $products_array:

This should give you an array of elements:

this works for me in settings.py:

I got it!

Base on the error thrown by the server, the function encode() can't find/doesn't exist which returns a 500 error code. I assume you mistype the json_encode().

So it should be:

$fields_json = json_encode($fields);

From the docs. https://www.php.net/manual/en/function.json-encode.php

Since Email.send is working, I assume your MAIL_URL is set correctly, but your Accounts.emailTemplates is not. From https://docs.meteor.com/api/passwords.html:

In addition to configuring the email package’s MAIL_URL, it is critical that you set proper values (specifically the from address) in Accounts.emailTemplates to ensure proper delivery of e-mails!

Ok, sooo thanks @MrWhite for basically telling me about VirtualHost. I never saw about it in any topics so I was searching maybe in the wrong direction. Everything is working fine, now. So in case in the future someone gets through it, I will explain what I did to make it work in localhost. What I will tell is translated from a website I've found in my native language ( How to configure VirtualHost (French) ).

STEP 1 : edit Apache's config in Wamp

In the 'httpd-vhosts.conf' file located in 'C:/wamp64/bin/apache/apache2.4.46/conf/extra/httpd-vhosts.conf' (in my case), I had to add these virtual host lines :

ServerAdmin webmaster@dummy-host.localhost
DocumentRoot "${INSTALL_DIR}/www/projets/projets_persos/tests/template1/public"
ServerName template1.local
ServerAlias template1.local
ErrorLog "logs/template1.local-error.log"
CustomLog "logs/template1.local-access.log" common


Then I had to modify Apache's main config file called 'httpd.conf' located in 'C:/wamp/bin/apache/apache2.4.46/conf/httpd.conf' (in my case) and uncomment the following line :

#Include conf/extra/httpd-vhosts.conf (in my case, it was already uncommented)

After that, the website says to restart Wamp's services before step 2, which I did after step 2 below and it stills work without any trouble. So anyway, I guess it will be same for you, do it now or after step 2.

STEP 2 : edit Windows' hosts file

At bottom of the 'hosts' file located in 'C:/Windows/System32/drivers/etc/hosts' I added the following line at bottom of the file to override the previous rule :

127.0.0.1 template1.local

Aaand, that's all.

=-=-=-=-=

As a proof it's working well, here's a screenshot of my project :


Here you can see on the picture I exploded my route in an array. I do this for personal purposes, to be able to route according to whatever bit of string I want. If you want to get rid of the 'public' value in the route, just type $_GET['route'] = str_replace('public/', '', $_GET['route']); before putting each of its fields in the array. Then, it will look like this :



Also, of course, I used .htaccess to be able to do URL Rewriting, here's my .htaccess file :

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !(\.png|\.jpg|\.gif|\.jpeg|\.zip|\.pdf|\.css|\.svg|\.js)$
RewriteRule ^(.*)$ /index.php?route=$1 [L,QSA]

It's a bit off topic but in case you'd need to know, the RewriteCond lines allow to type in the true URL of assets that have these extensions and it won't rewrite as they are true URLs.

=-=-=-=-=

Anyway, this is the end of my solution, thanks again for helping me and all's well that ends well. The End.

Problem solved, I had not added the intermediate certificate in production. Interesting to see that it is not necessary on a browser but is necessary to make API calls.

You mentioned in the comments above that your database is hosted by IONOS, and your code is running externally from there.

Unfortunately, IONOS appears to block connections to their database products from external sources. Heroku is most definitely an external source. This fact is clearly documented on their help site:

Access to your IONOS MySQL database from your desktop computer or any other non-IONOS source is not possible:

In principle, you can only access your MySQL database through applications installed on your IONOS web space, e.g. with your own WordPress installation. Other access paths have been blocked for security reasons.

The way they accomplish this restriction is likely by not publishing public DNS records for their databases, which is why your code complains about not being able to resolve an address for it.

What you're asking for is not possible with this vendor without a special arrangement. If this is an absolute requirement, you should look for an alternative database host.