Simple Inventory System

Submitted by: 
dadzky
Language: 
PHP
Visitors have accessed this post 47991 times.

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-)

Tags: 
[email protected]
[email protected]

Article by dadzky

dadzky has submitted 1 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

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

nazmulitbd17

Sat, 05/06/2017 - 04:56

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

adiccb (not verified)

Sun, 04/02/2017 - 04:53

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

junnaztic (not verified)

Tue, 03/14/2017 - 15:18

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

dearyl (not verified)

Sat, 02/15/2014 - 09:09

asa man ko mag.start adto?
pwede vb.net 2008 aq gamiton?

violajaupllari

Tue, 01/14/2014 - 22:34

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

sas (not verified)

Fri, 09/27/2013 - 17:26

sir pagawa ng system sa inyu

mark joseph (not verified)

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 :/

Marejean (not verified)

Wed, 08/14/2013 - 20:07

Here it goes. :)
username: granaderos
password: marjiecasosa

muze

Thu, 10/17/2013 - 18:15

i have used those credentials but it says Unknown user's name! what can i do

phphabit

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

^.^wantToBePHPprogrammer^.^

Raghava (not verified)

Fri, 08/02/2013 - 14:22

Please give me username and password for Admin and cashier

17iCia

Mon, 07/29/2013 - 22:56

What's the username and password for the admin? Please. Thank you.

dadzky

Tue, 06/11/2013 - 17:01

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

Beginner

aftabsoomro

Thu, 06/06/2013 - 02:49

Which line of alter to erase there are so many alter options?

Aftab

Anonymous (not verified)

Thu, 05/30/2013 - 16:52

Me too got the same error while importing database content

Anonymous (not verified)

Wed, 06/05/2013 - 17:27

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

Anonymous (not verified)

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

Owner (not verified)

Fri, 07/26/2013 - 18:25

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
)

dadzky

Fri, 05/31/2013 - 08:10

Kindly erase this lines:

ALTER TABLE table_name ADD CONSTRAINT fk_wew FOREIGN KEY ( fld ) reference tbl_name(

fld_name
)

Beginner

Anonymous (not verified)

Sat, 06/01/2013 - 04:37

i removed that line, but still the same
do you how to fixed it?

Anonymous (not verified)

Thu, 05/30/2013 - 09:34

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.

Add new comment

More information about text formats

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.