Skip to main content

Home/ Web Programming/ Group items tagged mysql

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Rafael Santiago

MySQL :: MySQL 5.0 Reference Manual - 0 views

dev.mysql.com/...index.html

webprog-4-a MySQL Reference documentation

shared by Rafael Santiago on 12 Feb 09 - Cached
  • Rafael Santiago on 12 Feb 09
     
    The official MySQL Reference Manual. This manual provides reference one needs for dealing with MySQL.
Wright Sashagaye

MySQL :: Why MySQL? - 0 views

www.mysql.com/why-mysql

webprog-4-a

shared by Wright Sashagaye on 13 Mar 09 - Cached
  • Wright Sashagaye on 13 Mar 09
     
    Here is a page about MySQL. It explains why MySQL is the world's largest open source database and why it is usually the top choice when selecting database technology.
Mark Zaniewski

Downloading mysql-cheat-sheet-v1.pdf - Added Bytes - 0 views

www.addedbytes.com/...pdf

webprog-4-a MySQL PHP cheat sheet

shared by Mark Zaniewski on 23 Feb 09 - Cached
  • Mark Zaniewski on 23 Feb 09
     
    A MySQL cheat sheet from the folks at Added Bytes. It isn't much for specific syntax, but it gives a broad overview. Explains different types of data used in setting up your database table. Also much date and time info, functions, and some sample select queries. Gives a feel for what's involved with the PHP/MySQL combination.
Marie Shanahan

Creating tables in MySQL - 0 views

www.webdevelopersnotes.com/...ng_course_creating_tables.php3

webprog 4-a mysql

shared by Marie Shanahan on 22 Mar 09 - Cached
  • Marie Shanahan on 22 Mar 09
     
    An online training course from Web Developers Notes that explains the MySQL commands to create database tables: rows, columns, records, assigning unique id numbers to individuals records. At the news organization where I work, developers have used MySQL to create databases for Connecticut high school football and basketball statistics. The stats are all displayed in tables - check it out at http://data.courant.com/highschoolsports/basketball/home.aspx
Jackie Fields

HuffingtonPost CTO to speak on Enterprise MySQL - 0 views

twitter.com/huffingtonpost

CTO MySQL IT Management

shared by Jackie Fields on 06 Aug 09 - No Cached
  • Jackie Fields on 06 Aug 09
     
    HuffingtonPost CTO to speak on Enterprise MySQL: Heavy-Traffic Management on Aug. 11 at the NYC MySQL Group http://www.meetup.com/mysqlnyc/calendar/10930810/
Caruso Nicholas L

MySQL Tutorial - Introduction - 0 views

www.tizag.com/mysqlTutorial

webprog-4-a

shared by Caruso Nicholas L on 13 Feb 09 - Cached
  • DiLieto Lauren M on 13 Feb 09
     
    This is a MySQL tutorial that you can download to help you understand MySQL databases and php.
  • Caruso Nicholas L on 12 Mar 09
     
    The following is a site complete with all sorts of tutorials for PHP and MySQL. It is separated by topics such as Setup, Admin, Syntax, Database, Connect, etc, and allows you to jump in where ever you feel the need to. I'm a newbie, so this site has been great to read through.
Kelly Utt-Grubb

Learn MySQL - About.com - 0 views

php.about.com/...learn_sql_free.htm

webprog-4-a

shared by Kelly Utt-Grubb on 19 Feb 09 - Cached
  • Kelly Utt-Grubb on 19 Feb 09
     
    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.
Lee Howard

InformIT: Working with Data in MySQL > MySQL Data Types - 0 views

www.informit.com/...article.aspx

webprog-4-a

shared by Lee Howard on 21 Feb 09 - No Cached
  • Lee Howard on 21 Feb 09
     
    This is a nice tutorial on how to use MySQL to manipulate data. Really cool!
Katie McLaughlin

MySQL tutorial/beginners' guide - 0 views

www.perlscriptsjavascripts.com/...index.html

webprog-4-a

shared by Katie McLaughlin on 17 Feb 09 - Cached
  • Sarah-Jane Bolling on 17 Feb 09
     
    This site seems to have some basic (read: semi-easy to understand) information written in non-geek speak. Just the basic opening paragraph explained it to me better than reading a bunch of other pages I found
  • Katie McLaughlin on 13 Mar 09
     
    While by no means a complete reference, this page gives a much more thorough overview on MySQL that a lot of the other sites out there. I especially like the 'tips and functions' section.
Monica Aversa

Creating A Guestbook Using PHP and MySQL - PHP MySQL Tutorial - 0 views

www.php-mysql-tutorial.com/...tbook-using-php-and-mysql.aspx

webprog-4-a

shared by Monica Aversa on 12 Mar 09 - Cached
  • Monica Aversa on 12 Mar 09
     
    For anyone who attempts the guestbook challenges, this tutorial looks like it will offer some solid guidance. Thank goodness for those kind-hearted programmers who do what they can to help the simpletons. :)
Gomez Evamarie

Learn PHP - PHP Tutorials - PHP with MySQL Tutorials - 0 views

php.about.com

webprog-4-a mysql php

shared by Gomez Evamarie on 15 Mar 09 - Cached
  • Gomez Evamarie on 15 Mar 09
     
    This site has some pretty useful information on PHP and MySQL.
Zebeck Jillian

PHP: MySQL - Manual - 0 views

us2.php.net/mysql

webprog-4-a

shared by Zebeck Jillian on 23 Mar 09 - Cached
  • Zebeck Jillian on 23 Mar 09
     
    Here is PHP and MySQL manual that Professor Halavais directed me to when I was having (and still having) trouble with Module 4's challenges.
Lee Howard

MySQL Cheat Sheet - 0 views

www.nparikh.org/mysql.php

webprog-4-a

shared by Lee Howard on 21 Feb 09 - Cached
  • Lee Howard on 21 Feb 09
     
    A handy "cheat sheet" for various problems that can be solved by using MySQL.
Pat Salvas

MySQL :: MySQL Downloads - 0 views

dev.mysql.com/downloads

webprog-4-a mysql

shared by Pat Salvas on 24 Feb 09 - Cached
  • Pat Salvas on 24 Feb 09
     
    I know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the futureI know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the future.
  • Pat Salvas on 24 Feb 09
     
    I know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the future.
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...

started by Caruso Nicholas L on 19 Mar 09 2 follow-ups, last by Alex Halavais on 19 Mar 09
Jackie Fields

IT Management Conference & Expo in NYC Oct.14-16 - 1 views

www.diigo.com/...agement-conference-expo-in-nyc

IT Management Leadership CIO CTO CEO MySQL PHP Zend PMP

shared by Jackie Fields on 26 Jul 09 - Cached
  • Jackie Fields on 26 Jul 09
     
    http://www.manageit.me ---The greatest minds in IT in 50+ presentations : top industry-leaders: Creator of MySQL Michael "Monty" Widenius, Internet Celebrity Gary Vaynerchuk, Co-Creator of PHP & Zend CTO Zeev Suraski, Richard Sheridan, CEO of Menlo Innovations & Pioneer of Agile eXtreme Programmi...
Lee Howard

Simple Counter using mySQL by Laurens Hoek - 0 views

www.planet-source-code.com/...ShowCode.asp

webprog-4-a

shared by Lee Howard on 21 Feb 09 - Cached
  • Lee Howard on 21 Feb 09
     
    Since counters are critical to the usability of MySQL, I thought this copy-and-past version of a counter code would be handy for people.
Chere B

MySQL :: Building a Database-Driven Web Site Using PHP and MySQL - 0 views

dev.mysql.com/...18.html

webprog-4-a

shared by Chere B on 18 Feb 09 - Cached
  • Chere B on 18 Feb 09
     
    This site is very helpful for review. While I was able to complete the PHP assignments some of the concepts were a little hazy. This site is helpful if you would like further explanation. The author provides example code and breaks down each step in a way that is easy to understand. For instance. Here was one of the basic examples:\n\nLoops like these come in handy whenever you're working with long lists of things (such as jokes stored in a database... hint-hint!), but for now we'll illustrate with a trivial example: counting to ten.\n\n$count = 1;\nwhile ($count );\n $count++;\n}\n\nKind of scary-looking, I know, but let me talk you through it line by line.
Caruso Nicholas L

PHPFAQ - MySQL PHP Questions and Answers - 0 views

www.alt-php-faq.org

webprog-4-a

shared by Caruso Nicholas L on 12 Mar 09 - No Cached
  • Caruso Nicholas L on 12 Mar 09
     
    This page has a number of assorted questions and answers regarding php and MySQL. Good to browse through should you find yourself stuck on something.
Alex Halavais

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

webprog.halavais.net/1-1

shared by Alex Halavais on 21 Jan 09 - Cached
  • joining the group
    • Alex Halavais
      Alex Halavais on 21 Jan 09
       
      Here's a sticky note to share with everyone.
  • joining the group
    • Alex Halavais
      Alex Halavais on 21 Jan 09
       
      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
      Lee Howard on 22 Jan 09
       
      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
      Alex Halavais on 22 Jan 09
       
      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
      Monica Aversa on 23 Jan 09
       
      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
      Monica Aversa on 23 Jan 09
       
      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
      Alex Halavais on 24 Jan 09
       
      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
      Lee Howard on 22 Jan 09
       
      Can you cite where in the book you can find out where in the code to place this acknowledgment?
    • Alex Halavais
      Alex Halavais on 22 Jan 09
       
      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
      Caruso Nicholas L on 22 Jan 09
       
      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
      Alex Halavais on 24 Jan 09
       
      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
      Alex Halavais on 03 Feb 09
       
      I lied :). Now up on Blackboard, by popular demand.
  • bookmark a particular URL
    • Caruso Nicholas L
      Caruso Nicholas L on 22 Jan 09
       
      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
      Alex Halavais on 24 Jan 09
       
      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
      Starr Andrew on 24 Jan 09
       
      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
      Alex Halavais on 24 Jan 09
       
      You need not download anything :). That was easy... The database will be on a server.
  • shell account
    • Kuban Ellise J
      Kuban Ellise J on 28 Jan 09
       
      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
      Alex Halavais on 28 Jan 09
       
      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
      Kuban Ellise J on 29 Jan 09
       
      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
      Kuban Ellise J on 29 Jan 09
       
      and in turn, can you tag sticky-notes? here is my fake tag webprog-1-b
    • Alex Halavais
      Alex Halavais on 03 Feb 09
       
      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
      Zebeck Jillian on 30 Jan 09
       
      I am wondering how far along we should be in the book during the first two modules?
    • Alex Halavais
      Alex Halavais on 03 Feb 09
       
      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
      Marie Shanahan on 03 Feb 09
       
      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
      Alex Halavais on 03 Feb 09
       
      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
      Marie Shanahan on 04 Feb 09
       
      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
      Tedd Fox on 13 Feb 09
       
      Are we going to learn the commands that we may have to use on occasion?
    • Alex Halavais
      Alex Halavais on 14 Feb 09
       
      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.
  • Alex Halavais on 21 Jan 09
     
    I have highlighted the question :-)
  • ...5 more comments...
  • Lee Howard on 22 Jan 09
     
    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?
  • Caruso Nicholas L on 22 Jan 09
     
    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?
  • Starr Andrew on 24 Jan 09
     
    Question on MySQL downloads
  • Sorteberg Matthew T on 26 Jan 09
     
    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.
  • Zebeck Jillian on 30 Jan 09
     
    Question about the Head First HTML textbook...
  • Marie Shanahan on 03 Feb 09
     
    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."
  • Tedd Fox on 13 Feb 09
     
    I have highlighted the question :-)
1 - 20 of 45 Next › Last »
Showing 20▼ items per page