Tutorials

How to Create Profile Information Page in PHP/MySQL

Submitted by argie on

Good day everyone, I am going to create my new tutorial called "Simple Profile Information Page". In this tutorial you can integrate my previous code on How to Create Registration Page in PHP/MySQL and on How to Create Login Page in PHP/MySQL.

To start with, follow the steps below.

How to Create Login Page in PHP/MySQL

Submitted by argie on
Related code: How to Create Secure Login Page in PHP/MySQL. Yesterday I posted a tutorial on how to create a registration page using PHP/MySQL. To make some follow up with my registration page tutorial, I decided to create another tutorial on how to create a login page using PHP/MySQL. The Features of my login page contain input validation using PHP session.

How to Create Registration Page in PHP/MySQL

Submitted by argie on
Related code: How to Create Secure Registration Page in PHP/MySQL This is a simple tutorial that will teach you on how to create a simple registration form using PHP/MySQL with JavaScript for input validation. This tutorial will not teach you on how to create a good design but rather to give you knowledge on how to create a fully functional registration form.

Creating our Table

First we are going to create our database which stores our data. To create a database: 1.

How to Cancel Delete in BindingNavigator

Submitted by admin on
When you add a DataSet to your Windows Form a BindingNavigator is automatically created with navigation to your record and it also includes Delete and Add button. When you click the Delete button there is no confirmation if you want to cancel the operation. The solution to this is to set the DeleteItem to None.

Get the ID of Last Inserted Record in SQL Server

Submitted by admin on

Sometimes you need to know the value of your Primary Key when you insert record in your table. This is true if you have a Master/Detail form and you need to know the Primary key value of the parent table so that you can insert rows in the related table.

Consider the following scenario:

How to Concatenate Column Values from Multiple Rows

Submitted by admin on

Just want to share with you on how to concatenate or combine one or more values from multiple rows. This SQL code is part of my “Online Hotel Reservation” project.

The idea here is to group column values while concatenating the other column to avoid duplicate records.

Here’s an example:

I have the following record on my table:

What is BlueJ

Submitted by onyx_ash08 on
BlueJ is an integrated Java environment specifically designed for introductory teaching. BlueJ was developed at a University specifically for the purpose of teaching object orientation with Java. BlueJ is free!

Solution to “System.Data.InvalidConstraintException: ForeignKeyConstraint” error

Submitted by admin on
If you encounter the following error: System.Data.InvalidConstraintException: ForeignKeyConstraint FK_foreign_key_name requires the child key values (-1) to exist in the parent table. Or The INSERT statement conflicted with the FOREIGN KEY constraint "FK_foreign_key_name ". The conflict occurred in database "YourDatabase", table "dbo.Tablename", column 'YourPrimaryKey'. The statement has been terminated. Probably you are using a Parent-Child table or Master-Detail table.