sneezy Posted September 1, 2011 Share Posted September 1, 2011 Hello there, I am learning php/mysql by doing a small project. The project is like "storing shopping list as a file in database and retrieve it" to update later on or to generate reports. The confusion I am having is: 1. How to store a file with (n) number of records (a user can have (n) number of items in one shopping list). 2. Save this shopping list and retrieve it some other time. 3. How to store "New shopping list for every new trip" in the database? I have 1 database containing 3 tables: shopping_list, item_master and brand_master Any help/ link to the tutorial for working with the files will be appreciated. Thanks Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/ Share on other sites More sharing options...
fenway Posted September 2, 2011 Share Posted September 2, 2011 What do you have so far? Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1264724 Share on other sites More sharing options...
sneezy Posted September 2, 2011 Author Share Posted September 2, 2011 Sorry about that! I have installed XAMPP 1.7.4 on windows XP, mysql version is 5.0.7, php version 5.3.5 Item_Master has 1 column = item_name Brand_Master has 1 column = brand_name shopping_list has 4 columns = item_name, brand_name, quantity, file_name What I want to do is: 1. Before going to shopping, I want to make a list and want that list to be stored in database as a file. This file should be saved as any name given. Later, anytime I should be able to open the file for printing or for any addition/ deletion. 2. So there could be "n" number of shopping lists with "n" number of items as every time we go for shopping we have new items in our list. 3. Lastly (at this moment), I want to generate an itemized report date-wise. So far, what I have done: 1. Created database, tables and forms. 2. Connection between Database and forms (Entries done in Item_Master and Brand_master, shows up as a drop-down list in "shopping_list form" 3. I am trying to save it as a file and retrieve accurate data according to each file but don't know how to do it. Hopefully am going by the rules this time. Thanks! Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1264897 Share on other sites More sharing options...
fenway Posted September 4, 2011 Share Posted September 4, 2011 Well, you'll need table to assign items to lists, and lists to people. Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1265463 Share on other sites More sharing options...
sneezy Posted September 5, 2011 Author Share Posted September 5, 2011 Well, you'll need table to assign items to lists, and lists to people. Could you explain bit in detail or with an example? Or any tutorial/ help file to read will also do...am confused regarding its implementation! Thanks! Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1265541 Share on other sites More sharing options...
fenway Posted September 5, 2011 Share Posted September 5, 2011 What part don't you follow? Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1265731 Share on other sites More sharing options...
sneezy Posted September 6, 2011 Author Share Posted September 6, 2011 Well, you'll need table to assign items to lists, and lists to people. I didn't your statement...table to assign items to lists and lists to people.Table containing what? Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1266100 Share on other sites More sharing options...
fenway Posted September 6, 2011 Share Posted September 6, 2011 Tables containing tuples with those assignments. Link to comment https://forums.phpfreaks.com/topic/246229-storing-retrieving-file-in-database/#findComment-1266101 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.