Simple Inventory System

Submitted by: 
Language: 
Visitors have accessed this post 47216 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-)


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

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

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

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

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

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

sir pagawa ng system sa inyu

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

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

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

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^.^

Please give me username and password for Admin and cashier

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

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

Beginner

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

Aftab

Me too got the same error while importing database content

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

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

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
)

Kindly erase this lines:

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

fld_name
)

Beginner

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

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

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.