Archive for the 'Database' Category « Previous Entries Next Entries » PHP Tutorial – Lesson 13 Looping, looping, looping, looping, looping, looping, looping, looping… Friday, February 17th, 2006 There are 4 main concepts that you have to understand inside and out to be a good programmer. Variables Arrays Choices (if statements) Looping We have talked about variables (those named containers where we can store information) and we have talked about choices. We have also touched on arrays (remember $_GET and $_POST?). Remember arrays [...] Posted in Database, MySQL, PHP Class | No Comments » PHP Tutorial – Lesson 12 Hello!? Are you there?! – Using the SELECT statement Monday, February 13th, 2006 This is both the easiest and most difficult of the four SQL statements. The SELECT statement. We have covered putting data in the database (INSERT), removing data (DELETE), and changing data that already exists (UPDATE). Aside from the INSERT statement, which simply jams data into a table, you append a WHERE clause onto your statements [...] Posted in Database, MySQL, PHP Class | No Comments » PHP Tutorial – Lesson 11 Just make it go away! – Using the DELETE statement Tuesday, January 31st, 2006 The next of the big four SQL statements that you need to master on this long and bumpy road is the DELETE statement. At some point, a customer will leave, or an item will permanently go out of stock or some other reason will pop up where you will need to remove data that is [...] Posted in Database, MySQL, PHP Class | No Comments » PHP Tutorial – Lesson 10 Ooops… I messed up, can I start over? – Using the UPDATE statement Tuesday, January 24th, 2006 We always have to make changes. In fact, I think that is one of the first things that people quote as an advantage of using computers, “it’s easy to change!”. That is right up there with “these are real time savers!”. Your mileage will vary I am sure… Information in the database is easy to [...] Posted in MySQL, PHP Class | No Comments » PHP Tutorial – Lesson 9 Putting data in the database – Using the INSERT statement Tuesday, January 24th, 2006 Ok, take two. The web can be unreliable at times, and it is never more frustrating than when you complete an article and hit save only to have the post fail. My impatience may result in a slightly abbreviated version of the last attempt. Remember folks, always copy long articles before submitting them on the [...] Posted in MySQL, PHP Class | No Comments » « Previous Entries Next Entries »

Article Search You are currently browsing the archives for the Database category. Pages Web Hosting with Computer Magic Archives September 2010 December 2009 September 2009 April 2009 March 2009 January 2009 December 2008 November 2008 August 2008 June 2008 May 2008 November 2007 September 2007 August 2007 July 2007 June 2007 December 2006 November 2006 October 2006 July 2006 June 2006 May 2006 April 2006 March 2006 February 2006 January 2006 December 2005 Categories *nix (5) AJAX (6) Apache (3) ASP.NET (8) Boot Linux from USB Hard drive (3) CMTK (1) Configuration (2) CPanel (1) Database (8) DOT NET (6) E-mail (1) Humor (2) IIS (2) Java Script (2) JSON (JavaScript Object Notation) (1) MS SQL (2) MySQL (10) PHP (4) PHP Class (15) Products (1) Python (1) Python.NET (1) Quick Scan (1) Report Viewer (1) Ruby (1) Server Admin (4) Student Loans (1) Tech Rambling (17) Uncategorized (10) Win Foms (3) windows (2) XML (1)