nette | 👪 METAPACKAGE for Nette Framework components | Application Framework library

1. I used default='' since not all of the pages have those properties (year, type, area)
2. I'm using xpath to find a specific div that has a word in it, and then we get the text of the next sibling.
3. I changed type to type1.

Your alias is wrong note should come after case and there is no use of where as you are handling the geo values using CASE

I overlooked a .htaccess file with "Require all denied". Removing this file (or, in fact, changing the folder structure so that it would deny reasonable things) fixed the issue.

PHP did not support annotations until recently. PHP 8 introduced attributes. It was released in end of November 2020. As of now attributes are not widely supported.

The pseudo-annotations from your example are the current best practice used by most major frameworks and libraries like Doctrine ORM. The latter even provides a doctrine/annotations-library which makes using these user land-annotations more convenient.

As for an authoritative source for whether this is a good practice, it is explicitly mentioned in the RFC for the language feature: https://wiki.php.net/rfc/attributes_v2#userland_use-casemigrating_doctrine_annotations_from_docblocks_to_attributes (the syntax in the RFC looks different than the actual attribute syntax as it was changed).

If you want to use the simpler database explorer API over regular SQL queries through the core API, you will need to set up foreign keys in the database properly.

The explorer API will allow you to work with the table directly, inferring which columns to select and which tables to use automatically:

Nette Database Explorer doesn't return count after insert(). It is not useful information as long as you can count data before insert by yourself.

Your reasoning is correct. The ResultSet returned by most Nette\Database methods is a one way iterator so you cannot use it in multiple execution of a loop body. It is an optimization – once the loop advances the iterator, the previous row can be potentially garbage collected, which is useful to save memory on large database tables.

If you really need to iterate over a table multiple times, you can either:

• create $invoices multiple times
  • possibly moving the whole assignment into the loop inside the template
  • or creating function returning that result and calling it in the template
• or load the whole ResultSet into memory, for example by converting it into array. This is also what the documentation recommends:

  Over the ResultSet is possible to iterate only once, if we need to iterate multiple times, it is necessary to convert the result to the array via fetchAll() method.

But the best solution would be fixing it up to use JOINs, if possible. If you use FOREIGN KEYS in your database, you can avoid writing raw SQL and use the much nicer interface that will create JOINs for you transparently and efficiently, when you try to access data from other table through a column with a foreign key constraint.

I have started a recipe, for now showing how to select a single value (your use case), see https://github.com/cypress-io/cypress-example-recipes/pull/439

• Look at Dockerfile & resources I gave in Install Oracle Instant client into Docker container for Python cx_Oracle which show how to work with Instant Client in Docker.

• From the above references you might intuit the strong suggestion to use ldconfig instead of setting LD_LIBRARY_PATH. The latter is prone to not being passed through to web servers.

• I don't know Nette, but I strongly doubt you should be using jdbc:oracle:thin:@/// as the connect string. PHP is not Java, and a JDBC connection string would be odd. All Oracle's C-based drivers (PHP OCI8, PHP PDO_OCI, Python cx_Oracle, Node.js node-oracledb, etc) use a common connection string format, so you can look at those examples. On top of that you add the PDO prefix and/or whatever Nette needs. In pure PDO a connection would be done like $dbh = new PDO('oci:dbname=hostname/servicename', 'username', 'password'); with your actual hostname, servicename, username and password. I can see some Google hits for Nette and Oracle; I'll let you review them.

• If you can, use PHP OCI8 instead of PDO_OCI, since the former has more functionality and inbuilt features. I see some Google hits that seem to indicate OCI8 can be used; again I'll let you do the searching.