Skip to main content

Home/ Web Programming/ Group items tagged Database

Rss Feed Group items tagged

Nancy Hall

Insert Recipe Comments - 0 views

  •  
    Here is my first venture in MySQL. You can leave comments on the bottom of the slightly restyled recipe page. Can't view them yet (that's phase 2), but they insert into the database.
Lee Howard

Blueberry Muffins (with PHP and using MySQL tables) - 0 views

  •  
    The blueberry muffin recipe now includes a way for people to send in their names, email addresses and comments about the recipe, and my database will keep track of all the information, ready to spit it out to me at a moment's notice!
Kelly Utt-Grubb

Learn MySQL - About.com - 0 views

  •  
    About.com is always a good place to start because it provides a general overview with links to other resources. The MySQL article on About.com explains the basics you need to learn SQL code to use with your MySQL database.
Alex Halavais

Web Prog - 1-1: Course Syllabus - 0 views

shared by Alex Halavais on 21 Jan 09 - Cached
  • joining the group
    • Alex Halavais
       
      Here's a sticky note to share with everyone.
  • joining the group
    • Alex Halavais
       
      Hey everyone. If you are a member of the group, you can see what others have to say about pages on the web!
    • Lee Howard
       
      Just wondering if you have specific page numbers of the textbook you want us to read. Do you want us to do all the exercises in the book?
    • Alex Halavais
       
      Ha, I didn't see this hiding up here. It's up to you which (and whether) you want to do the exercizes in the book. The advantage of the book, I think, is that it provides a nice structured approach, it gets you started on the right foot right away, and it focusses on what is important. The downside is that there is some "fluff." Sometime we all need a bit of fluff. So, the long and the short of it is, if I were in your shoes, I would work through the book quickly. Some of what is covered there is also covered in my lectures. In fact, I think this is the largest amount of overlap I have ever had between a text and the lectures. But I suspect you will need more depth in some cases than you get from the lectures. You might try watching the lectures, and then working through the section of the book. It's probably too much to actually "read" during a week (yikes) but it is highly skimable. And there will be an opportunity to return to it, as we move into some of the programming.
    • Monica Aversa
       
      For challenge webprog-1-b: Question about the syllabus (and a suggestion) Question: I've been submitting challenges through adding bookmarks on Diigo; however, I used sticky notes on this one. Do you have a preference of how we submit challenges? Thanks. Suggestion: Very thorough lecture, but in future ones, it might be helpful to mention in computer requirements that Mac users need at least OS X 10.4 to access Firefox, Firebug, etc.
    • Monica Aversa
       
      Challenge for webprog-1-b: question #2 If we want to improve our grade on one of the challenges, are we allowed to redo it?
    • Alex Halavais
       
      Monica: Need to bookmark as well as sticky. I find the assignments according to the tag, so if it's not tagged, I won't find it. Firefox, Firebug, Firezilla, etc. are all available for 10.4 and before. Just google, e.g., "Firefox earlier releases." They may not have the same features as the most recent version. In practice, you can survive without any of these; they are just nice to have. As for your last question: the grade on an assignment is binary: either you get all the points or you don't. If you didn't, you'll need to send me a note when you redo it, so I can recheck it. If it's still before the deadline, you can rec. full points. If it is after the deadline, you get reduced points.
  • ...9 more annotations...
  • A simple comment in the code indicating where you found a particular snippet is enough.
    • Lee Howard
       
      Can you cite where in the book you can find out where in the code to place this acknowledgment?
    • Alex Halavais
       
      In the lecture 2-1 (coming soon!) I touch briefly on this. Generally, you just provide a short comment (see the last question on p. 6 of the book) near where you are borrowing code or ideas.
  • t will be added to the Completed page, at that point, with the associated number of points
    • Caruso  Nicholas L
       
      I just clicked the Completed page and it failed to load. Is this a page that will eventually be up? Will grades also be posted in Blackboard as well as the Completed page?
    • Alex Halavais
       
      Eventually up (soon I hope). And I do not love Blackboard, so no duplication there. They aren't grades, so much as a record of who is doing what.
    • Alex Halavais
       
      I lied :). Now up on Blackboard, by popular demand.
  • bookmark a particular URL
    • Caruso  Nicholas L
       
      For challenge 1-b it says to make sure we bookmark our question. How do we bookmark a highlighted comment? Do we just use the entire URL and you would seek out our question(s)?
    • Alex Halavais
       
      Is this the question you are bookmarking? If so, I think the world is going to expload. Yes, you should bookmark the page you are making the comment on (this one) and be sure to tag it webprog-1-b.
  • database-backed
    • Starr Andrew
       
      You mention MySQL for the db backend. Can you give a list of what we'd need to download from the MySQL site? There appear to be several options. My brain hurts.
    • Alex Halavais
       
      You need not download anything :). That was easy... The database will be on a server.
  • shell account
    • Kuban  Ellise J
       
      what exaclty is a "shell account". I looked it up on Wikipedia (http://en.wikipedia.org/wiki/Shell_provider), but can you try to explain it in English aka understandable terms?
    • Alex Halavais
       
      As it turns out, we probably won't need to access a shell account. Basically, this allows you to directly log in to a server computer, and move around it. You generally have shell access to your own computer (on Windows machines, look under accessories or Run: Command; on OSX, the program is called "Terminal.") This is generally the only way to directly run programs or access detailed information about a web server. Otherwise, you are limited to FTP, which really is just used to copy files to and from the server.
    • Kuban  Ellise J
       
      Thanks, this actually spawned another question, but relating to Diigo. I had no notification (or none that I could see) or anything that you had responded to my sticky note. Is there something I'm missing or should I just remember to check back. Thanks
    • Kuban  Ellise J
       
      and in turn, can you tag sticky-notes? here is my fake tag webprog-1-b
    • Alex Halavais
       
      Yeah, you *should* be able to tag notes, but I guess (for the 1-b, for example), you just have to retag the page...
  • There is a textbook recommended for the course, Head First HTML with CSS & XHTML.
    • Zebeck Jillian
       
      I am wondering how far along we should be in the book during the first two modules?
    • Alex Halavais
       
      Done. It's a pretty quick read. Really, my lectures are a kind of "Cliff Notes" (I guess that's now "Sparc Notes"?) of the book. You won't have a test, but you will find the book helpful in filling in the gaps as you create stuff.
  • create or modify a simple application on the web
  • (if any)
    • Marie Shanahan
       
      Hi Prof. Halavais. You mentioned in the opening syllabus video that you deliberately designed this ICM class to be an "open course," meaning it is open to others who are not tuition-paying QU students. Why make your class materials part of the "creative commons"? I'm also curious to know how QU officials feel about "open courses."
    • Alex Halavais
       
      That's probably a longer question than I can answer. I think there is a mixed feeling about it, and some at QU think we should charge people for knowledge. I guess I'll turn that around and ask: what is it you are paying for when you pay tuition?
    • Marie Shanahan
       
      When I finally finish paying tuition, I'll have that oh-so-valuable piece of paper that says I have a master's degree, right? Tuition also helps to pay you, my professor!
  • form of web server (LAMP
    • Tedd Fox
       
      Are we going to learn the commands that we may have to use on occasion?
    • Alex Halavais
       
      Well, initially I had planned on doing more of this. In the sixth module, we briefly touch on what's available to a user via the *nix "shell," if those are the sort of commands you are thinking of. But I've aleady packpeddled quite a bit from my initial plans.
  •  
    I have highlighted the question :-)
  • ...5 more comments...
  •  
    What pages of the textbook will we need to read in the first module? Should we do the exercises in the book? Also, can you cite how to acknowledge others' work within code?
  •  
    Questions re: the course/syllabus: I just clicked the Completed page and it failed to load. Is this a page that will eventually be up? Will grades also be posted in Blackboard as well as the Completed page? Second, on the 1-b challenge page it said to bookmark our questions...I'm a little confused as to the expectations. To be safe, I commented on/highlighted on the syllabus page and am now bookmarking the Syllabus page as well. Are we supposed to do both for this challenge?
  •  
    Question on MySQL downloads
  •  
    More of a general question towards the course itself....am in trouble if I really have no prior experience writing code/HTML/web programming? I'm a bit nervous to be honest.
  •  
    Question about the Head First HTML textbook...
  •  
    To satisfy challege 1-B, I have asked a good question about the course under the SCHEDULE section. There is a sticky note attached to the words "if any."
  •  
    I have highlighted the question :-)
Alex Halavais

Question re: Challenge 4-F - 19 views

Yeah...I've clearly been failing in trying to define the variables. Will try this out...thanks for the tips and response! -Nick Kuban Ellise J wrote: > Hi! > > if im reading your code right...

Alex Halavais

Challenge 4-g - 13 views

This looks to be a connection problem. Hard to say without seeing the whole thing, but I'm about to post to the blog a conversation I had over chat with another student. Need to include the "or die...

Nancy Hall

Pick a Pic, Any Pic - 0 views

  •  
    Here is my variation on the Baseball Cards challenge. There are 3 different images to choose from, and the info displayed after submission (as well as the drop down itself) is generated from a database table. If you'd like to learn more about my friends & family, take a peek!
Nancy Hall

Required Email Addy and Name - 0 views

  •  
    This is a link to a working comments page (linked to a database table) which requires a valid name and email address before submission using Javascript. An error message appears & fades at the bottom of the form if something is omitted. I also made the same thing happen using PHP, so there are also messages at the top of the page from that code. I got the Javascript from http://www.leigeber.com/2008/04/dynamic-inline-javascript-form-validation/, and included this citation in my js page. Upon submission, a thank you message appears at the top of the form.
  •  
    Nice!
Marie Shanahan

Auto-populating Select Boxes using jQuery & AJAX - 0 views

  •  
    In my search for how to use jQuery and AJAX to build a select drop down menu, I found this four part demo - HTML, PHP, jQuery and JSON (JavaScript Object Notation). It also includes an example of how to create multiple select boxes with data populated from a MySQL database.
Ford  James A

Ajax presents...sports! - 0 views

  •  
    This is module 6-e. It was a little tricky to do, but what I found interesting was how there were a few ways to do it. You could connect to a database or you could do it through making individual files. This module is for Northeast sports. Enjoy!
Katie McLaughlin

My Viddler comment @ 6:45 - 0 views

  •  
    I posted a link to a MySQL database tutorial website. Although the video is already a tutorial to demonstrate the basics, as a beginner, it is good to glance at other tutorials as well.
  •  
    I make a comment/ask a question regarding why background images must be as washed out as possible -- and suggest that it really ought to be up to the designer.
Monica Aversa

Angelfire.com Review - 0 views

  •  
    Strengths: Free to join, offers tutorials and widgets, you have access to other Angelfire pages broken up by genre Weaknesses: Once you exceed certain bandwidth, you must pay. Also, I think a page that hadn't been edited in years was deleted.
  •  
    Angelfire's been around for quite a while, though they haven't grown as quickly with people's needs, I think. The downside is no access to databases or programming, which for free is fine. Another upside is that it is a Lycos site, so probably (though I'm not sure) few problems with downtime or slow servers. (+10)
  •  
    I don't remember having problems with downtime or slow servers using Angelfire (are those the same as time out errors?); however, I could see how your additional downsides would affect advanced programmers.
‹ Previous 21 - 32 of 32
Showing 20 items per page