Ivan Chepurnyi
Den Haag, Zuid-Holland, Nederland
3K volgers
Meer dan 500 connecties
Info
A well-known Magento expert, trainer, and speaker. I am recognized for my deep technical…
Services
Artikelen van Ivan
Bijdragen
-
How do you educate and train your PHP developers and users on SQL injection prevention?
It is possible to cover many issues with prepared statements, but I've noticed that many developers overlook a crucial issue when creating base components that allow filtering collections of data from a database—field names. It's crucial to verify if the corresponding column actually exists before blindly using it as a column name in where conditions. To avoid such problems, you can take a couple of steps: - Verify if the column with such a name exists in the table. - Use a database-specific column name quote that is usually different from the way you quote values. For example, in MySQL, it is a backtick (`).
-
How do you educate and train your PHP developers and users on SQL injection prevention?
Prepared statements offer a dual benefit of preventing SQL injections while also reducing the time taken by the database server to parse your query input when it is repeatedly executed. As the server does not need to re-evaluate the entire execution strategy again, it directly executes your query. This results in quicker response times and more efficient use of server resources.
Activiteit
-
✴️#Magento #MySQL #SQL Tips ✴️ 🗒️ SQL to find the top 10 best selling products for your store 👇
✴️#Magento #MySQL #SQL Tips ✴️ 🗒️ SQL to find the top 10 best selling products for your store 👇
Gemarkeerd als interessant door Ivan Chepurnyi
-
Small Christmas present for you all, download images from production based on Magento database: https://lnkd.in/eiinX2_4 Good to spin up realistic…
Small Christmas present for you all, download images from production based on Magento database: https://lnkd.in/eiinX2_4 Good to spin up realistic…
Geplaatst door Ivan Chepurnyi
-
If I have to go more than one level deep into your abstraction, the design is not clean architecture but a landmine of hard-to-read code full of bugs…
If I have to go more than one level deep into your abstraction, the design is not clean architecture but a landmine of hard-to-read code full of bugs…
Gedeeld door Ivan Chepurnyi
Ervaring
Licenties en certificaten
-
Magento Certified Developer Plus Exam
Magento Inc
Toegekend:Certificatienummer: w79dus51e3 -
Zend PHP5 Certification
Zend Technologies Ltd.
Toegekend:Certificatienummer: ZEND013990
Projecten
-
Implementatie Magento webshop www.webprint.nl
-
Systeemontwikkeling, vormgeving en implementatie van webshop Webprint.nl met behulp van Magento EE 1.12.0.2
Klant: WebprintAndere bijdragersProject weergeven -
KLM Duty Free Online Webshop
-
- Shop migration
- Flight reservation system integration
- Complex delivery rules per products
- Integration with airline loyalty system
- Strict admin user restrictions
- Special PDF packing slips
- Special reports
- Special customer recognition system
- Customized checkout flow
- Special price appearance on the frontendAndere bijdragersProject weergeven
Onderscheidingen
-
Magento Master
Magento Inc.
Movers are Magento’s top advocates and ecosystem thought leaders who have demonstrated their expertise in driving innovation through Magento solutions. They are influencers in the industry in delivering best-of-class Magento implementations and advocate for Magento at industry events.
https://magento.com/blog/magento-news/meet-2017-magento-masters-movers
Talen
-
English
Volledige professionele vaardigheid
-
Ukrainian
Moedertaal of tweetalig
-
Dutch
Beperkte werkvaardigheid
Ontvangen aanbevelingen
11 personen hebben Ivan aanbevolen
Word nu lid om dit te bekijkenMeer activiteiten van Ivan
-
One of my favorites in the Magento ecosystem deserves a repost for his work on fixing the indexing process 👇
One of my favorites in the Magento ecosystem deserves a repost for his work on fixing the indexing process 👇
Gemarkeerd als interessant door Ivan Chepurnyi
Overige vergelijkbare profielen
Anderen hebben Ivan Chepurnyi genoemd
1 andere persoon door wie Ivan Chepurnyi is genoemd, gebruikt LinkedIn
Bekijk anderen die Ivan Chepurnyi heten