Welcome dear readers, this article is going to focus on explaining autocomplete search box in PHP and MySQL. I know almost everyone uses Google to search the web. You may have noticed suggestions appearing when you start typing any keyword in Google’s search box. It is actually an autocomplete search box. This functionality makes it easy for …
Welcome to programmopedia! we are going to build an ajax live data search using jquery, PHP, and MySQL in this article. It’s a user-friendly functionality that makes searching easy and simple. When a user types in a character in the search box, it will start displaying the most relevant records to the user. The live search allows …
Welcome to programmopedia! I am writing this article to explain the conversion of HTML to pdf in PHP. Pdf is a fixed-layout format developed by adobe to display text and images. This format is widely used by websites to provide the download of important data. So, in this article, I am going to first fetch dynamic data …
Hello dear readers! We are going to learn about Submitting form without reloading page using ajax. This is a very useful functionality that boosts webpage performance. A lot of static components like navigation bar, sidebar, etc are loaded on every refresh of the webpage which is the cause of performance decline. With AJAX, we can …
Welcome dear readers to another article. We are going to build pagination in PHP from scratch. It’s very essential functionality and almost all websites use it. It’s because if our SQL select query returns hundreds or thousands of records, we can not display them all on a single page. Because it can cause a decline in …
Welcome back, dear readers! This article is focused on deleting a single row of data in PHP. It’s a simple five-step process to delete a specific row of content from our database. Before learning delete operation, we must know how to insert and fetch data from the database. Once we have fetched the data, we need to create a …
Welcome to another tutorial focused on editing data in PHP using an edit form. Before learning the edit operation, you must know how to insert data and how to fetch the inserted data from the database. It’s because we will fetch the data from the database in a table and create an edit button with every …
When developing a website, sometimes we need to fetch data from two or more tables at once using PHP. In such cases, we use joins to display data to our users. In our scenario, we want to display all the books uploaded on our system along with the user information. For that, we will display data of …
How to fetch data from two tables in mysql using php Read More »
As we know that displaying data from database is a common operation while developing a website. We usually display data to our users in different design formats like tables, cards, etc. Every developer aims to display data to users in an attractive way to grab more clients, sales, and hits. As we know, we have already inserted …
Welcome readers! we are back with another article to discuss file upload in PHP. In our previous article, we created an HTML form and Performed the first CRUD operation. We created a “book” table into our “Library” database and inserted the data retrieved from HTML form into our “book” table. We did not explain file …
