![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Indulge my Nerdiness for a moment
May. 29th, 2011 05:53 pmWe were making the grocery list today, in our usual way which means sitting down and making our menu for the week and then deciding what we need and e-mailing it to whichever one of us is going to the store, and I said "There's got to be a way to do this where I can input what we buy and then I can just check off the boxes and then it'll e-mail the list to us."
So being the geeks that we are, we talked about it a little more so I can explain what I want and Cayne says that it can be done pretty easily in MySQL. I nudge a bit because he looks reluctant to take it on, and I ask if he thinks it's something I can do as a learning experience. He thinks it's possible, so I'm going to take on this project.
I'm looking for a recommendation for a good MySQL book. There's O'Reilly, of course-I see Head First PHP and MySQL and I see the usual O'Reilly Learning PHP, MySQL and Java Script. Recommendations for one of those or a different option. Something that when combined with W3schools.com will allow me to learn enough to make a household grocery app.
If it matters, what I'm trying to do is build something where I can input our typical household groceries and then as we make the list, just pull up the webpage and check the boxes for what we need or want, and then either access it from my phone and check off items as I put them in the cart or email the list to myself and access the email from my phone as I shop. So for example, suppose I built a master list for my family that included bread, apples, rice, beans, pears, granola bars, milk and this week I only needed bread, milk and apples, I could just go in, check those things off and when I access the "my weekly list" page or something it gave me the list "bread, milk, apples" and allowed me to check off the items as I put them in the cart.
I'm not sure I'll have the skills or patience to handle the e-mailing bit, but that's okay...if I can build the part where one logs in, inputs their grocery lists and then checks off what is needed, I'd be happy. If I can manage the part where I get it to then show up on a separate page as "My Weekly List" I'd be thrilled. If I can manage to build the login page and the e-mail function, I'd be ecstatic. (I'm not even sure I'm going to attempt this part. I may turn that part over to![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
zedrikcayne.)
(If anyone has a better suggestion for something that I can use that's web based/web accessible and easy to learn and will run on my laptop, I'm open to suggestions.)
And then, we'll see what happens.
(PS, I owe you lots of posts about Naomi turning 3, and getting ready for a dance recital and the potty issue that we're having and my family and stuff.)
So being the geeks that we are, we talked about it a little more so I can explain what I want and Cayne says that it can be done pretty easily in MySQL. I nudge a bit because he looks reluctant to take it on, and I ask if he thinks it's something I can do as a learning experience. He thinks it's possible, so I'm going to take on this project.
I'm looking for a recommendation for a good MySQL book. There's O'Reilly, of course-I see Head First PHP and MySQL and I see the usual O'Reilly Learning PHP, MySQL and Java Script. Recommendations for one of those or a different option. Something that when combined with W3schools.com will allow me to learn enough to make a household grocery app.
If it matters, what I'm trying to do is build something where I can input our typical household groceries and then as we make the list, just pull up the webpage and check the boxes for what we need or want, and then either access it from my phone and check off items as I put them in the cart or email the list to myself and access the email from my phone as I shop. So for example, suppose I built a master list for my family that included bread, apples, rice, beans, pears, granola bars, milk and this week I only needed bread, milk and apples, I could just go in, check those things off and when I access the "my weekly list" page or something it gave me the list "bread, milk, apples" and allowed me to check off the items as I put them in the cart.
I'm not sure I'll have the skills or patience to handle the e-mailing bit, but that's okay...if I can build the part where one logs in, inputs their grocery lists and then checks off what is needed, I'd be happy. If I can manage the part where I get it to then show up on a separate page as "My Weekly List" I'd be thrilled. If I can manage to build the login page and the e-mail function, I'd be ecstatic. (I'm not even sure I'm going to attempt this part. I may turn that part over to
zedrikcayne.) (If anyone has a better suggestion for something that I can use that's web based/web accessible and easy to learn and will run on my laptop, I'm open to suggestions.)
And then, we'll see what happens.
(PS, I owe you lots of posts about Naomi turning 3, and getting ready for a dance recital and the potty issue that we're having and my family and stuff.)
