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

  • admin@niyazi.org
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

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

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,

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.

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