Simple Inventory System
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
nazmulitbd17
Sat, 05/06/2017 - 04:56
Permalink
when i login the showing problem please replay me
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
Permalink
Administrator login
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
Permalink
no BASEdao.php file
paki upload po ng file, di po ako maka login sa admin side
dearyl (not verified)
Sat, 02/15/2014 - 09:09
Permalink
asa man ko mag.start adto?
asa man ko mag.start adto?
pwede vb.net 2008 aq gamiton?
violajaupllari
Tue, 01/14/2014 - 22:34
Permalink
great project. made some
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
Permalink
sas
sir pagawa ng system sa inyu
mark joseph (not verified)
Mon, 09/23/2013 - 16:05
Permalink
error
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
Permalink
username and password for administrator
Here it goes. :)
username: granaderos
password: marjiecasosa
muze
Thu, 10/17/2013 - 18:15
Permalink
username and password for administrator
i have used those credentials but it says Unknown user's name! what can i do
phphabit
Mon, 08/05/2013 - 08:46
Permalink
error in LOGIN
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
Permalink
Username and Password
Please give me username and password for Admin and cashier
17iCia
Mon, 07/29/2013 - 22:56
Permalink
Can't login as admin
What's the username and password for the admin? Please. Thank you.
dadzky
Tue, 06/11/2013 - 17:01
Permalink
Problem Fixed
Just Download it again..
sorry for the inconvenience..
Beginner
aftabsoomro
Thu, 06/06/2013 - 02:49
Permalink
please guide the clear.
Which line of alter to erase there are so many alter options?
Aftab
Anonymous (not verified)
Thu, 05/30/2013 - 16:52
Permalink
Error
Me too got the same error while importing database content
Anonymous (not verified)
Wed, 06/05/2013 - 17:27
Permalink
still not work
he doesnt know how to fix that, i think he is not a programmer
Anonymous (not verified)
Wed, 05/29/2013 - 18:11
Permalink
Error on database
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
Permalink
No error
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
Permalink
Solution to the error.
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
Permalink
still not work
i removed that line, but still the same
do you how to fixed it?
Anonymous (not verified)
Thu, 05/30/2013 - 09:34
Permalink
Error in Database
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