|
Archive for the 'Database' Category
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 | Comments Off on PHP Tutorial – Lesson 13 Looping, looping, looping, looping, looping, looping, looping, looping…
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 | Comments Off on PHP Tutorial – Lesson 12 Hello!? Are you there?! – Using the SELECT 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 | Comments Off on PHP Tutorial – Lesson 11 Just make it go away! – Using the DELETE 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 | Comments Off on PHP Tutorial – Lesson 10 Ooops… I messed up, can I start over? – Using the UPDATE 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 | Comments Off on PHP Tutorial – Lesson 9 Putting data in the database – Using the INSERT statement
|
|
