Posts

Showing posts from December, 2023

Git - How to revert, cancel last changes on remote server

Sometimes you do something wrong. For example, push to master branch dev commits or something else, what does not have to find itself here.  There are present a lot of official recommends how to push revert commits... but honestly, in my case, it does not work in proper way, as you want. So, I found ferroconcrete method how to solve this issue. But it seems to somebody not gracefully, but it works at least. First step: Revert to required commit.  git reset --hard <commit-hash> (This command will reset the branch to the specified commit. Be cautious when using --hard as it will discard changes in your working directory and staging area.) Second step: Create new branch from this point.  git checkout -b <new-branch-name> (This command creates a new branch and switches to it. Replace <new-branch-name> with the desired name for your new branch.) Third step: Remove your damaged branch on server. git push origin --delete <branch-name> (Replace <branch-name> with

Symfony - Doctrine - How to change old attributes in entity to new PHP 8 attributes

Old-Style Annotations: Written as comments, typically using PHPDoc syntax (/** ... */). Annotations are interpreted by external tools or libraries. Doctrine ORM interprets annotations to configure database mappings. Limited flexibility in terms of syntax and available metadata types. May lack type safety and validation. PHP 8 Attributes: Written using the #[...] syntax. Introduced as a language feature in PHP 8 for adding metadata directly to code. Provides a more structured and standardized way of associating metadata with classes, methods, or properties. Attributes are a built-in language feature, eliminating the need for external interpretation in many cases. Attributes are directly handled by the PHP runtime. Offers better type safety and validation compared to traditional annotations. Supports the use of PHP's native types and expressions within attribute values. Attributes support namespacing, allowing for better organization and

JavaScript - How to create select options from array

Define an array with the values you want to populate in the <select> element. var fruits = ["Apple", "Banana", "Orange", "Grapes", "Mango"]; Create a <select> element in your HTML markup. <select id="mySelect"></select> Iterate through the array and create <option> elements for each value, then append them to the <select> element. Here's an example: document.addEventListener("DOMContentLoaded", function () { var fruits = ["Apple", "Banana", "Orange", "Grapes", "Mango"]; var selectElement = document.getElementById("mySelect"); for (var i = 0; i < fruits.length; i++) { var option = document.createElement("option"); option.value = fruits[i]; option.text = fruits[i]; selectElement.appendChild(option); } }); In this example, the JavaScript code runs

Symfony - Doctrine - How to add subquery into where clause

If you want to add subquery into where clause, you need to create subquery firstly: $sub = $this->_em->createQueryBuilder()             ->select('cf.id')             ->from(CustomField::class, 'cf')             ->where('cf.type = :type AND cf.fieldName = :fieldName'); After that you can use this subquery as DQL: $this->_em->createQueryBuilder()->expr()->in('cfv.fieldId', $sub->getDQL()) In that case we use it as IN condition. But it is just example. And finally it will look like that: $this->createQueryBuilder('cfv')             ->update(CustomFieldValue::class, 'cfv')             ->set('cfv.value', ':value')             ->where($this->_em->createQueryBuilder()->expr()->in('cfv.fieldId', $sub->getDQL()))             ->setParameter(':type', 'product')             ->setParameter(':fieldName', $fieldName)            

WordPress - How to create simple plugin with shortcode

Creating a simple WordPress plugin involves a few steps. Below is an example of a minimalistic WordPress plugin that adds a custom shortcode to display a greeting message. Step 1: Set Up Plugin Structure Create a new folder for your plugin in the "wp-content/plugins" directory. Let's call it "simple-greeting-plugin". Step 2: Create the Main Plugin File Inside your plugin folder (simple-greeting-plugin), create a main PHP file, e.g., "simple-greeting-plugin.php". Step 3: Add Plugin Information In your main PHP file, add the plugin information in the comment header. <?php /* Plugin Name: Simple Greeting Plugin Description: A simple WordPress plugin that adds a greeting shortcode. Version: 1.0 Author: Your Name */ Step 4: Add Greeting Shortcode Functionality Now, let's add the functionality to display a greeting message using a shortcode. Update your "simple-greeting-plugin.php" file as follows: <?php /* Plugin Name:

Symfony - How to fix Circular Reference

 A circular reference in Symfony typically occurs when there's a loop in the dependency injection graph. It means that one service depends on another service, which in turn depends on the first one, creating an infinite loop. Check Your Service Definitions: Review your service definitions in the services.yaml or other configuration files. Look for any circular dependencies. A circular reference often occurs when Service A depends on Service B, and Service B depends on Service A. Use Setter Injection: Instead of injecting dependencies through the constructor, use setter injection. In Symfony, you can use setter injection by creating setter methods in your services and injecting dependencies through these methods after the service is instantiated. Lazy Loading: Consider using lazy loading for dependencies. Symfony allows lazy loading of services, which means that the actual instantiation of a service is delayed until it's actually used. You can enable lazy loading for a service b

PHP - How to show expected return array elements

When your function or method returns an associative array, it's beneficial to document the expected structure of that array using PHPDoc type annotations. This practice not only serves as documentation for developers using your code but also enables features like auto-completion in integrated development environments (IDEs). For example: /** * Creates a user. * * @return array{"name": string, "age": int, "married": bool} */ function createUser(): array { return ['name' => 'Nayf', 'age' => 38, 'married' => true]; } In this PHPDoc block, the @return annotation is used to specify that the function returns an associative array with three elements: "name" of type string, "age" of type int, and "married" of type bool. This information provides clarity on the expected structure of the returned array. The PHPDoc type system supports various basic PHP types such as string, bool, in

Symfony - How to generate URL without controller or path

If you need to generate URL out of controller, you need to create you own Route with necessary path. $route = new \Symfony\Component\Routing\Route('/calculator/new'); And add this route to Route Collection: $routes = new \Symfony\Component\Routing\RouteCollection(); $routes->add('calculator_new', $route); After that you can generate URL: $generator = new \Symfony\Component\Routing\Generator\UrlGenerator($routes, new \Symfony\Component\Routing\RequestContext()); $url = $generator->generate('calculator_new'); This returns: "/calculator/new" If you need to add any query parameters: $url = $generator->generate('calculator_new', ['width' => 100]); This will return "/calculator/new?width=100" as the generated URL, including the specified query parameter. In summary, by creating a route, adding it to a collection, and using a URL generator, you can easily generate URLs and include additional query parameters

Javascript - How to build URL with query parameters

If we just need to add GET parameters to current URL: Firstly, let`s create URL object with current link. const url = new URL(window.location.protocol+window.location.host+window.location.pathname); Where: window.location.protocol - https or http; window.location.host - current host; window.location.pathname - current url after host and before query parameter; After that, let`s add necessary query parameters: url.searchParams.set('id', 123); And get URL what we wanted: url.toString(); For example, let`s redirect to new URL: window.location.href = url.toString();

PHP - How to explode empty string with empty array

When you try to explode empty string, you get not empty array, as we would have assumption, but array with one element with blank string. PHP says it is not a bug. So, we need to find a way how to avoid this behavior. As we don`t want to have any element in array after exploding empty string. We want to have empty array as well, obviously. We can use "array_filter" function to remove empty element in array. Example: $correctArray = array_filter(explode(';', ''));

Chrome - This page is not secure (broken HTTPS) How to fix certificate

Today I faced with problem of expired ssl certificate for website. But even after updating (renew) certificate, browser continue to show error "This page is not secure (broken HTTPS)". But at the same time, it shows me that certificate is valid. What didn`t I do: clean cache and cookies where I could find it explored all the settings googled everywhere and nothing helped me. When my patience is over, I just try to open this link in new tab , and it works. Madness.

MySQL - How to copy full Database fast

I know one dirty life-hack, how to copy full data from database with all configs and users. Just copy all files from old base to new one . For example (for Linux): cp -r /var/lib/mysql /new_destination It will transfer not only data from database, but and users with their own passwords and privileges. NOTE: It works only if you database placed on one host (server). I must emphasize that using the method described above to copy a database, including configurations and users, can have serious consequences and is not recommended for various reasons. Firstly, it may violate privacy and security regulations, potentially exposing sensitive information. Secondly, this approach might lead to compatibility issues and corruption of data in the new destination. Moreover, it could compromise the integrity of the database and jeopardize the overall system's stability. It's crucial to follow proper procedures when migrating or copying databases to ensure data security, integrity, and

Wordpress - REST API - How to set up roles

Wordpress REST API allows roles as array. But when you try to set roles as it is, it throws error. Correct list of roles: administrator editor author contributor subscriber customer As you see, all of these role names must be in lower case . For example: $user = WordpressAPI::createUser([ 'username' => 'test', 'email' => 'test@gmail.com', 'password' => '123456QQQ', 'roles' => ['subscriber'] ]); And you can add your own roles that you created in system.

Wordpress - How to log errors

On the first glance, it is easy to answer on this question. But, it is not. Yes, you can simply set WP_DEBUG constant to true, as many sites recommend. But, probably, it comes more problems than convenience. Because, it throws out all unnecessary, for your case, messages on the site, and, most likely, just fall apart whole layout. So, I recommend, do not switch on WP_DEBUG constant, and log what you want silently from users. For that: Set WP_DEBUG constant to true. We need to set up WP_DEBUG_DISPLAY constant to false, to hide errors from users. Write where you need error_log(). After that, you can check your logs and see error messages. If not, try to set up WP_DEBUG_LOG constant. There should be path to log file. wp-config.php file: define( 'WP_DEBUG', true ); define( 'WP_DEBUG_DISPLAY', false ); define( 'WP_DEBUG_LOG', '/path/to/log/file.txt' ); // if needed

Javascript - jQuery - Make menu item Active automatically

There is, as minimum, two ways how to add 'active' class to menu item, to highlight it. First one is on backend side. Second one is on frontend side. Now, I talk about variant with frontend side. So, I choose javascript to decide to add 'active' class to menu item or not. There is a code for this: var pathName = window.location.pathname; // Iterate through each anchor tag within list items $("ul li a").each(function () { // Check if the href attribute matches the current URL if ($(this).attr("href") == pathName) { // If there is a match, traverse up the DOM hierarchy to find the corresponding list item $(this).parents('li').each(function () { // Add the 'active' class to highlight the menu item $(this).addClass("active"); }); } }); This script essentially loops through all anchor "a" tags within list items "li" in the specified unordered list "ul". For each a

Symfony - How to logout locked or banned User automatically

If you want to logout locked or banned User automatically, you need, first of all, add new Listener with onKernelRequest(RequestEvent $event) method. Just FYI, this method Symfony calls every time on every request, so, be careful to use this method. It can shoot yourself in the foot. For example: class SecurityUserListener { public function onKernelRequest(RequestEvent $event) { } } After that, we need to check our User on status: banned or locked (what you need). For this we need to inject Token Storage in class constructor. Token Storage can return User. So, lets do it: class SecurityUserListener { public function __construct(private TokenStorageInterface $tokenStorage) { } public function onKernelRequest(RequestEvent $event) { $user = $this->tokenStorage->getToken()?->getUser(); } } Now, you can examine the user object's status. If it meets your criteria, set the current token to null (indicating no user in the token anymore) and

MySQL - How to rename, replace column

If you are not lucky like me, and do not have MySQL 8.0 version or higher, there is only one way to rename column in table is using CHANGE command. For example: ALTER TABLE products CHANGE old_column new_column INT NOT NULL; For MySQL 8.0 you can use next syntax: ALTER TABLE products RENAME COLUMN old_column TO new_column; But when you use RENAME command, you are not allow to change data type of this column, only name.