From Core to Advanced
Hi friends, in this tutorial, you will learn how to resolve SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table users add unique users_email_unique(email)). This error occurs when we run the database migrations in any of the Laravel projects with the help of … Read more
Hi friends, in this tutorial, you will learn how to resolve phpmyadmin #1709 – index column size too large. the maximum column size is 767 bytes. This is a specific error in MySQL that occurs at the time of importing sql file or an SQL table to the existing database or at the time of … Read more
Hi friends, in this tutorial, you will learn how to select first 10 rows from MySQL using PHP. This kind of query is required very often when you need a certain number of rows from your MySQL database to display in the application or in the browser. Also read, Delete a row in MySQL There … Read more
Hi friends, in this tutorial, you will learn how to calculate balance from credit and debit using PHP MySQL and get the direct code you can use to calculate running balances from the ledger. If you are wondering how to accomplish this task then you have come to the right place. This is very important and often … Read more
Hi friends, in this tutorial, you will learn how to export data from MySQL to excel using PHP. It is often required in the case of web development or any kind of web application and there are various packages available online to do this task but here I have explained without any package. Also read, … Read more
Hi friends, in this tutorial you will learn how to delete a row in MySQL. Actually, there are two ways by which you can perform the delete operations in MySQL. In order to do so, you must have some data inside the table of your database. Suppose, I have table ‘employee‘ in my database as … Read more
In this tutorial, you will learn how to display data from database in PHP. This is a very common feature and is required in any kind of web application. I will explain in detail from scratch. In order to get the table data from MySQL, we will use PHP code to retrieve data from MySQL … Read more
Hi friends, in this tutorial I will tell you how to resolve the MySQL error #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In the current row format, the BLOB prefix of 0 bytes is stored inline. This kind of error appears at the time of … Read more
Hi friends, in this tutorial we will learn how to get last record in MySQL using PHP. This is very useful and almost required in any kind of web application while creating a dynamic website or any customized software. Actually, there are two ways by which we can get the last inserted record from the … Read more
In this tutorial, we will learn how to get only date from timestamp in PHP. Timestamp or date-time object is very essential in creating dynamic web applications. It helps us to know the exact time and store the time in our MySQL database while inserting the data in the database or updating the data in … Read more