Skip to main content

Simple Inventory System

Language


Sorry po sa inconvenience..
Nakalimutan po naming i check ang sa Database, iba pala yung na Export..
Fixed napo e2, download nlng po ninyo ulit..
Salamat ng Marami ^_^

A simple Inventory System..
Just try this one :)

hope u will like it :D

[note: Check the BaseDAO.php file located at app/PHP/CLASSES if there is something you want to change regarding on the connection to database]
[if your database dont have password,just set the $db_user = "root" (usually) and $db_pass = "" ]

cheers! :>

Database Name: IIS_DB (at -db- folder)
By: Marejean Granaderos Perpinosa IMBA (-best prog-)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byAnonymous (not verified)on Wed, 05/29/2013 - 18:11

sir how to solve
Error
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `products`
--
ALTER TABLE table_name ADD CONSTRAINT fk_wew FOREIGN KEY ( fld ) reference tbl_name(

fld_name
) CREATE TABLE IF NOT EXISTS `products` (
`product_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`product_name` VARCHAR( 100 ) DEFAULT NULL ,
`bar_code` VARCHAR( 50 ) DEFAULT NULL ,
`product_price` DOUBLE DEFAULT NULL ,
`number_of_stocks` DOUBLE DEFAULT NULL ,
`stock_unit` VARCHAR( 20 ) DEFAULT NULL ,
`product_genre` VARCHAR( 100 ) DEFAULT NULL ,
PRIMARY KEY ( `product_id` ) showDialogForTransaction
) ENGINE = INNODB DEFAULT CHARSET = latin1 AUTO_INCREMENT =75;

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reference tbl_name(fld_name)

CREATE TABLE IF NOT EXISTS `products` (
`product' at line 7

Submitted byAnonymous (not verified)on Thu, 05/30/2013 - 09:34

In reply to by Anonymous (not verified)

i got the same problem of the DataBase . i think its the version of the DB.... or something not right....can u fix the error...thx.

Submitted byOwner (not verified)on Fri, 07/26/2013 - 18:25

In reply to by Anonymous (not verified)

walang error nman po ah?
kung meron po talaga, I delete po ninyo yung line na2..
ALTER TABLE table_name ADD CONSTRAINT fk_wew FOREIGN KEY ( fld ) reference tbl_name(.
fld_name
)

Submitted byAnonymous (not verified)on Thu, 05/30/2013 - 16:52

Me too got the same error while importing database content

Submitted byAnonymous (not verified)on Wed, 06/05/2013 - 17:27

In reply to by Anonymous (not verified)

he doesnt know how to fix that, i think he is not a programmer

Submitted bydadzkyon Tue, 06/11/2013 - 17:01

Just Download it again..
sorry for the inconvenience..

Submitted byRaghava (not verified)on Fri, 08/02/2013 - 14:22

Please give me username and password for Admin and cashier

Submitted byphphabiton Mon, 08/05/2013 - 08:46

bakit po everytime na mag login ako may error ?? :(
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'student2'@'localhost' (using password: YES)' in C:\wamp\www\DONAYRE_PERPINOSA_IIS\app\PHP\CLASSES\Database_connection.php on line 11
( ! ) PDOException: SQLSTATE[28000] [1045] Access denied for user 'student2'@'localhost' (using password: YES) in C:\wamp\www\DONAYRE_PERPINOSA_IIS\app\PHP\CLASSES\Database_connection.php on line 11

Submitted bymark joseph (not verified)on Mon, 09/23/2013 - 16:05

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'student2'@'localhost' (using password: YES)' in C:\xampp\htdocs\villaflor\workspace\zxc\app\PHP\CLASSES\Database_connection.php:11 Stack trace: #0 C:\xampp\htdocs\villaflor\workspace\zxc\app\PHP\CLASSES\Database_connection.php(11): PDO->__construct('mysql:host=loca...', 'student2', 'password') #1 C:\xampp\htdocs\villaflor\workspace\zxc\app\PHP\CLASSES\iis_functions_home.php(9): Database_connection->open_connection() #2 C:\xampp\htdocs\villaflor\workspace\zxc\app\PHP\OBJECTS\log_in_validation.php(13): Iis_functions_home->check_username('granaderos', 'cashier') #3 {main} thrown in C:\xampp\htdocs\villaflor\workspace\zxc\app\PHP\CLASSES\Database_connection.php on line 11 pano to masolve :/

Submitted bysas (not verified)on Fri, 09/27/2013 - 17:26

sir pagawa ng system sa inyu

great project. made some changes and it works great for me. can you help me by sending me the documentation of the project, or the thesis how you may call it! i would be very grateful to you! ([email protected])thankyou

Submitted byjunnaztic (not verified)on Tue, 03/14/2017 - 15:18

paki upload po ng file, di po ako maka login sa admin side

Submitted byadiccb (not verified)on Sun, 04/02/2017 - 04:53

I had use the user granaderos and password marjiecasosa and I can't enter in the system

Warning: Unknown: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC' for '6.0/no DST' instead in Unknown on line 0 Fatal error: Uncaught exception 'PDOException' with message 'invalid data source name' in D:\www\inven3\PHP\CLASSES\Database_connection.php:11 Stack trace: #0 D:\www\inven3\PHP\CLASSES\Database_connection.php(11): PDO->__construct('localhostdbname...', 'root', '[email protected]') #1 D:\www\inven3\PHP\CLASSES\iis_functions_home.php(9): Database_connection->open_connection() #2 D:\www\inven3\PHP\OBJECTS\log_in_validation.php(13): Iis_functions_home->check_username(' granaderos', 'administrator') #3 {main} thrown

Add new comment

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.