MYSQL

Retrieving Data in MySQL/PHP

Submitted by Yorkiebar on
Introduction: This tutoral will show you how to simply retrieve data using PHP from a MySQL database. Required: Before you can retrieve the data, you must have the following: 1) A webhost or localhost. 2) A database in your MySQL service. 3) A table with data in your MySQL database. Creating a Database: To create a database in your MySQL service, simply go to the MySQL Databases feature of your

Fix N Mix Payroll System

Submitted by janobe on
This Payroll System is the project of the third year bachelor of Science in Information Technology students of Kabankalan Catholic College for their Software Engineering subject. It is made up of Visual Basic 2008 and MySQL for their database. It also generates reports using the Crystal Reports. This system contains the following features: Log In and Log Out. Payroll (adding, listing and searching

Advanced Web Store Using PHP/MySQL

Submitted by donbermoy on
This is an Advanced Web Store of Dadad's Merchandising, a food establishment providing food ingredients. This is designed like the lazada.com as having the shopping cart and an online ordering system. The features of this system are the following: - order product online - add, edit, delete product - shopping cart designed - search product in home tab - send order confirmation via email - manage

Weather Monitoring Station with Flood Monitoring System

Submitted by donbermoy on
Microcontroller-Based Weather Monitoring Station with Flood Monitoring System was my thesis in the degree of Bachelor of Science in Computer Engineering. This device made our group awarded as Best Thesis of the Year. The server station was programmed using Mikro-C and the remote station was programmed through Visual Basic.NET and MySQL as backend. I shared this code so that we can actually

San Ramon Catholic School Enrollment System

Submitted by janobe on
This Enrollment System is made by the fourth year, Graduating students of the Kabankalan Catholic College for their thesis. In this system they used Visual Basic 2008 and MYSQL for their Database. It also generates reports using the Crystal Reports. Its features contain, such as: * Login and Logout * Enrollment Form * Student (List Of Students, List Of Enrolled Students, Student’s Subject and

Sales and Inventory Monitoring System for Maureen's Ukay-Ukay (Visual Basic + MySQL)

Submitted by donbermoy on
This is a work of my programming partner before entitled Sales and Inventory Monitoring System for Maureen's Ukay-Ukay. This is one of the thesis/capstone projects which we have made using Visual Basic 6.0 and MySQL as backend/database that we made for a particular school way back year 2010. This system is for a clothing store establishment. This system features: Transaction Sales Inventory Order

CSSG & Department School Voting System

Submitted by cybernick75 on
The system automates the voting system a college school which has several departments. Functions and Features: ADMIN SIDE; -Manages- Course Department Party Position Candidate CSSG Result Department Result VOTING PROCESS SIDE: - security (the student will enter security code to start voting) - CSSG (the student will select the CSSG candidates to vote) - Department (the student will select the

Product Information System in PHP/MySQL (Shopping Cart)

Submitted by donbermoy on
This is a Simple Product Information System that is capable of adding products with product name, product price, category, sub category, product details. This system can also add image of the product you wanted to add. Then the added products will go to its home tab with its information and images to be the list in shopping cart. Note that this system is not yet complete because i haven't done

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.
Subscribe to MYSQL