Programming

How to Download File using PHP/MySQLi

Submitted by nurhodelta_17 on
In my previous tutorial, I've created a Simple File Upload using PHP/MySQLi. As a follow-up, I've created another tutorial on how to create a Simple File Download. Most files can be easily download by clicking their link. However, some files cannot be downloaded by doing so. Thus, I've created this tutorial. This tutorial will not give you a good design, but will give you a good idea about the

Getting the Last Inserted ID in MySQL Table using PHP

Submitted by nurhodelta_17 on
In this tutorial, I'm going to show you how to get the last inserted id in our database table. In this tutorial, I have set up an Insert Form to show the id that will be inserted in our MySQL database. I've included 2 mysqli methods in this tutorial in the comments. So, feel free to switch between the two. Creating our Database First, we're going to create a database that contains our data. 1

Converting From MySQL DateTime to another Format in PHP

Submitted by nurhodelta_17 on
In this tutorial, Im going to show you how to convert mysql datetime format into your desired format. I've added symbols and their value for you to further understand the conversion. This tutorial uses two mysqli methods that I have included in the comments. So, feel free to switch between the two. Creating our Database First, we're going to create a database that contains our data. 1. Open

How to Select Data By Month and Year in PHP/MySQL

Submitted by nurhodelta_17 on
In my previous tutorial, I've discussed How to Select Data between two Dates. So, I've created another topic regarding selecting data with dates which is on How to Select Data by Month and Year using PHP. Also, in this tutorial, I've created two mysqli methods that I've added in the comment so feel free to switch between them. Creating our Database First, we're going to create a database that

Selecting Rows from MySQL Table using checkbox in PHP/MySQL

Submitted by nurhodelta_17 on
In this tutorial, I'm going to show you how to select rows from MySQL Table using checkbox in PHP/MySQLi. This tutorial does not include a good design but will give you knowledge on the said topic. Creating our Database First, we're going to create a database that contains our data. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "checkbox". 3. After creating a database

Setting up Cookie upon Login using PHP/MySQLi

Submitted by nurhodelta_17 on
In my previous post, I created a Simple Login with Validation, so I've decided to create another tutorial to show how to set up cookie upon user login. But in this tutorial, I have created a simple login since the focus of this tutorial is to give you knowledge on how to set up cookie. Cookies are small amount of data that has been stored in user's computer. This is used so that when the same

Simple Carousel using Bootstrap/Javascript

Submitted by nurhodelta_17 on
This tutorial will show you how to create a simple carousel using Bootstrap and Javascript. In this tutorial, I've prepared sample pictures that we are going to use in our carousel. To start with, let's create our slide page. This is the page that will show our images in a slider. Also included on the page, are the scripts used to make the slider. To create the page, open your HTML code editor and