From Core to Advanced
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
Hi friends, in this tutorial you will learn how to perform a PHP MySQL search database and display results in a step-by-step process from scratch. We must know that database searching is very useful in any kind of application or in any dynamic website. Therefore, we can do this with the help of a PHP … 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
Before getting started with the inner join in MySQL with conditions examples, let’s know about the inner join keyword and its syntax. What is inner join in SQL/MySQL? Inner join is used when we want to collect the data or rows between two tables or from multiple tables in the database. When the inner join … Read more
In MySQL, sometimes we need to fetch the particular column value from multiple rows using the same id i.e. the foreign key that belongs to the primary key of the other table. As such, with the help of the GROUP_CONCAT() example in MySQL, we can do this. This function is used very rare but it … Read more
