M. Niyazi Alpay
M. Niyazi Alpay
M. Niyazi Alpay

I've been interested in computer systems since a very young age, and I've been programming since 2005. I have knowledge in PHP, MySQL, Python, MongoDB, and Linux.

 

about.me/Cryptograph

Pulling Information by Associating Tables in Database (Inner Join)

Pulling Information by Associating Tables in Database (Inner Join)

To fetch data from the database, we use the SELECT command. With a command like SELECT * FROM table_name, we retrieve our data from the table_name table. If we need to fetch data based on a condition,

Batch Configuration of Directory and File Permissions for Web Sites on Linux Server

Batch Configuration of Directory and File Permissions for Web Sites on Linux Server

Setting file and directory permissions for websites on a Linux server can sometimes be time-consuming. For example, when using FileZilla with the option to apply to subdirectories selected, or when ap

Running a Query in C# Database

Running a Query in C# Database

In C#, we use the SqlCommand command to execute queries in the database. Since I will continue with MySQL for our example, I will use the MySqlCommand command. Start a new Windows Forms application a

PHP In-site Search Engine Construction

PHP In-site Search Engine Construction

Sometimes we need a simple search engine within our websites to find topics. Let me explain this with a simple example: HTML codes for the form that will perform the search: <form action="result.

Laravel and WebAuthn

Laravel and WebAuthn

In my previous article, I provided information about WebAuthn. In this article, I will explain how to implement it with Laravel. First, we include the laragear/webauthn package in our project. compo

What are Modem and Router? Cable Modem and TP-Link Connection

What are Modem and Router? Cable Modem and TP-Link Connection

Hello, due to my busy schedule, I can't create topics frequently, but I'm trying to change that. First, I'd like to explain what modem and router concepts are. Modem; The word "modem" is a combinatio

MongoDB Installation and Configuration (User Authorization and SSL Installation)

MongoDB Installation and Configuration (User Authorization and SSL Installation)

For installing MongoDB on a Linux operating system, you first need to add the MongoDB repositories to your system. Linux Redhat / CentOS Step 1: You need to add the following information into the fi

PHP Data Object - PDO

PHP Data Object - PDO

I had explained how to connect to a database and execute queries in PHP.Classic database connection is done with the mysql_connect() command, and query execution is done with mysql_query(), but the PD

Listing Users by Number of Topics in Mysql

Listing Users by Number of Topics in Mysql

We have two different tables, one for topics opened and the other for users.In the system, the id information of the user who opens the topic is also kept in the table where the topics are found.In th

PHP - Connecting to MySQL Database and Reading Information (Illustrated Explanation)

PHP - Connecting to MySQL Database and Reading Information (Illustrated Explanation)

The database we will connect to: ornek_veritabani We have created our database and our table named isim_listesi. We defined the type of the column named id as int, which means integer, and defined