PHP

Adding and Deleting Item(s) in Array using PHP

Submitted by nurhodelta_17 on
In my previous tutorial, I've created the Basic Array Functions. To follow up the tutorials about array, I've created another which will give you knowledge on how to add and delete item/s in array. This tutorial does not include a good design but will give you idea on the topic.

Creating our Form and Script

We create our add form, delete form and our scripts in adding and deleting items. To create the page, open your HTML code editor and paste the code below after the tag.

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 Running Time using PHP and Javascript

Submitted by nurhodelta_17 on
This tutorial will show you how to create a running time using PHP and Javascript. This tutorial does not include a good design but will give you knowledge on how to create a simple running time. Creating our Time Script This script creates our running time. In this script, we have also included a small PHP code to show our running time. So, for us to show the time in our desired page, we just

Easy and Simple Edit/Update MySQL Table using PHP

Submitted by nurhodelta_17 on
This tutorial will show and give you knowledge on how to edit/update MySQL table using PHP. Is this tutorial, I'm gonna show you how to edit using 3 methods namely MySQLi Object-oriented, MySQLi Procedural and PDO. 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 "edit". 3. After creating

Selecting MySQL Table Using Datatable in PHP

Submitted by nurhodelta_17 on
This tutorial will show you how to select mysql table with the use of data table. Datatable is an organize presentation on database table. It is often used in websites and php program because it has an in-built function like the search and pagination. Creating our Database First, we're going to create a database that contains the user data. 1. Open phpMyAdmin. 2. Click databases, create a database

Easy and Simple Adding/Inserting Data into MySQL Database using PHP

Submitted by nurhodelta_17 on
This tutorial will show you an easy and simple way in adding/inserting data into mysql database using 3 methods which are MySQLi Object-oriented, MySQLi Procedural and PDO. This tutorial does not include a good design but will give you knowledge in adding/inserting data into mysql database using the 3 methods. Creating our Database First, we're going to create a database that contains our data. 1