SQL

Auto Recognise Users via IP Address Through PHP/MySQLi

Submitted by Yorkiebar on
Introduction: This tutorial will show you how to quickly identify your website users through their IP. Database: First we will need a database (mine is 'fln'), a table - 'test', and columns with data. My columns are; id, int, 5 length, primary key, auto increment username, varchar, 255 length ip, varchar, 255 length The IP field does not have to be 255 characters long but it will help to avoid

Computerized Enrollment and Billing System for CRSHS

Submitted by donbermoy on
This is a complete Enrollment and Billing System for Caraga Regional Science High School that has also a grading system. This system is basically a project for Software Engineering Subject made by my classmates with a particular group. It was programmed using Visual Basic 6.0 and SQL Server 2000. This system features: Transaction Student -All Students -Active Students -InActive Students

Complete Video Rental Management System

Submitted by donbermoy on
This system entitled Complete Video Rental and Management System was my project in Software Engineering Subject way back when I was a 3rd Year Computer Engineering Student. This system was programmed through Visual Basic 6.0 and SQL Server 2000. Thanks to my instructor that time because i had high grade in this subject :D This complete system features: Transaction Rent CD/DVD Return CD/DVD New CD

Basic SQL Syntax, Structures, Key words and Queries

Submitted by Yorkiebar on
Introduction: This tutorial is going to be covering the basic syntax of SQL queries in MySQL and MySQLi. MySQL and MySQLi...? MySQLi is an updated version of the original MySQL language. Both versions use almost exactly the same syntax although MySQLi should be used as it is more secure, updated and reliable. Query Syntax: To create a MySQL(i) query, you combine different MySQL(i) keywords together and give it the information required to parse for the necessary returned information.

Task Management System

Submitted by Yorkiebar on
Introduction: This tutorial will is going to be on how to create a task management system in PHP... it's going to be a long one! Pre-creation: First you will need a host for your PHP, either a web host or localhost is fine but you will need PHP and MySQL(i) capabilities. Database: We are going to be storing all of the created tasks in a database named 'tasksTutorial', and in there a table named 'tasks'. Let's create these now; Go to PHPMyAdmin and enter 'tasksTutorial' followed by pressing the 'create' button.

PHP/MySQL/HTML Login Form

Submitted by Yorkiebar on
Introduction: This tutorial will cover creating a login form with PHP/MySQL/HTMl. Pre-creation: First you need to have some user accounts stored in a database, you can check out my profile for a tutorial on creating a register form. Steps of Creation: Step 1: First we need to connect to the database holding the user accounts... mysqli_connect uses the parameters; server, username, password* Step 2

Add/Delete/Insert/Update Java Netbeans and SQL Database Program

Submitted by Josphatwa on
This is a simple program to add, delete, search and update data in a jtable database. To run the program just open your server and create database called hostel and go to dist folder in the zip and run the compiled jar file. for more information contact me [email protected].
Subscribe to SQL