MYSQL

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.

Print PDF file using PHP and MySQL

Submitted by ronard on
Hi to all beginners in PHP and MySQL. This script will show you on how to print a PDF using FPDF in PHP and MySQL. How to install the script? 1. Unzip the downloaded file. Then copy the unzip to this path: xampp/htdocs/. 2. Goto the "db" folder. 3. Inside the "db" folder having a "tutorials" folder. Copy it to this path: xampp/mysql/data. 4. After you finish the above steps. 5. Goto to the web

Count Total Subject/Row and Total Average Using Multiple Queries in One Table in PHP and MySQL

Submitted by ronard on
Hi sourcecodesterian especially for novice in PHP Programming, last time I uploaded was the " Multiple quries in one table using PHP and MySQL". Now I show you a simple queries in MySQL that count the total subject/row of student from table "grades" and display the total average grade from the student. This is just one table nested. Hope it will help. Thanks for reading...

Count Total Time Visited by User using PHP and MySQL

Submitted by ronard on
Hi sourcecodesterian, I would like to share this script that is part of my last project. The feature of this script is it will count the total time visited by user logged to the system. This will help the system admin to track the total time login by the user/client. Hope it will help you. How to install this script, copy the folder "tutorials" inside the "db" directory. And paste it to this path

Count Total Failed Login by the User in PHP and MySQL

Submitted by ronard on
This script will teach you especially for novice in PHP Programming. This script will count the total failed login by the user if the username inputted in the textbox is exists in table users. Then it will add to the table failed login. How to install this script? Unzip the downloaded file. And copy the "tutorials" directory from "db" directory to "mysql/data/". Then copy also the "check_failed

Forum Tutorial - MOTD and Banning Messages

Submitted by Yorkiebar on
Introduction: This tutorial is going to be covering message of the days and banning messages. Database Setup: First we are going to set the database up ready for storing our information, create a new table named "reasons", then give it the following columns of structure: id - INT - 5 Length - Primary Key - Auto Increment (AI/A_I) use - VARCHAR - 255 Length message - VARCHAR - 255 Length additional - VARCHAR - 255 Length We are going to make the use value "motd" for Message of the Day, or "ban" for the banning message.

Multiple Queries in One Table using PHP and MySQL

Submitted by ronard on
Hi, I would like to share this script. For those who are novice in PHP and MySQL. This script will teach you on how to select two tables/multiple tables from your database in one table in html. I used the ID of each student in "tb_students" table and to call thier grades in table of grades/tb_grades. So that the grades are display together with the student info. Hope this will help you to you. For
Subscribe to MYSQL