Posts

Showing posts with the label mysql

CRUD in Spring Boot with Spring Data JPA

Image
T utorial about CRUD operations in Spring Boot with Spring Data JPA. Application developed in this tutorial performs adding, editing, updating and deleting contacts. Continue reading here .

Phonebook Application with PHP and MySQL CRUD Operation

Definition It is a simple Web-based phonebook application which stores and displays ID, Name, Contact No, and Address of a person. It is also capable of updating/editing and deleting phonebook entries. Database CREATE TABLE `phonebook` (     `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,     `name` VARCHAR(50) NOT NULL,     `phone_no` VARCHAR(15) NOT NULL,     `address` VARCHAR(50) NOT NULL,     `date_created DATETIME` NOT NULL DEFAULT ‘0000-00-00 00:00:00’,     PRIMARY KEY(`id`) );

Guestbook in PHP and MySQL

Image
Introduction I'm going to create an example of guestbook system using in PHP and MySQL. On the Web, guestbook is a logging system that lets visitor post their message. A visitor can post their thoughts or expressions. In general, it's not a requirement that a visitor create an account.

PHP and MySQL Login System

Image
We are going to create a simple login system written in PHP and using MySQL for the database backend. I hope that this simple tutorial could help a lot especially to beginners in PHP Web development.