PHP MySQL
Interactive Website Design
We're Being Sued by gettyimages.
I was wondering who would put the final nail in our coffin. Google's done a pretty good job of getting rid of us, but gettyimages is going to get their licks in also.
We bought a disk of 100,000 royalty free images from Serif.com back in 2006. We don't resell images but we do use them in our free web template collections, which is legal by our license agreement.
gettyimages is now informing us that some of the images we bought from Serf.com are theirs.
They are also sueing us for displaying thumbnails of templates that Ucoz.com uses in their website builder.
Sounds to me like they're splitting hairs on that one to make some extra money.
We've been online in some form since 1997. When copyright infringement became the new vehicle for making money, we had removed just about anything we'd added in old days off of scanned calendars and such. We may have missed a couple.
I could see being sued for that, but thumbnails and pictures by guys like Hans Merten and others who sold distribution rights to more than one company, I mean - Get Real!!
Anybody know if Google owns gettyimages?
See all 3 images Here. If you are promoting templates for other companies on your website using thumbnail images, You May Be at RISK!!
I'm old and tired people. Tired of the foolishness the internet has turned into. I'm especially tired of companies like gettyimages who evidently can't make an honest living doing business as usual. Now they're claiming the rights to images they don't own or selling the rights to images that one of their designers sold to several different companies.
I've finished most of the updates to HTML5 in our HTML tutorial. I think I'll publish what's finished and forget the rest.
We'll probably be saying sia nora in a couple of weeks, so get what you can.
We may be on our way out, but we'll make sure to help gettyimages rebuild their corporate image on our way!.
Signed: Sick & Tired
Build a MySQL Database on Your PC then Export it to Your Website
Introduction
The combination of PHP and MYSQL, when used together can create some pretty impressive results for dynamic interactive websites.
Unfortunately, PHP/MySQL has always been a confusing subject for beginner website authors and even some with experience.
It has always been a hassle to create your database on your web host's server and then use scripts to add data or records to to the database and provide access for your website users.
This tutorial will show you A BETTER WAY.
I'll show you how, step by step,to build your database and your scripts right on your PC and then Export everything to your web hosting account after you've worked out all the bugs.
I'll introduce you to 2 tools that will make the experience successful for almost everyone that tries.
TRY This Website Builder FREE!
No Credit Card Needed!
Create beautiful,professional websites
WITHOUT Learning to Code!!
Use this Next Generation Builder
to make blogs, portfolios or
full blown websites.
No Experience Needed!
Professional websites
Without the HASSLE!
The Lessons
The lessons provided in this tutorial will be short and simple. You'll learn to create and manipulate a simple database of names and birthdates.
- Connecting to the MySQL Server
- Creating the Database
- Creating a Table
- Adding a Record
- Displaying Records
- Updating a Record
- Deleting a Record
- Altering Tables
- Exporting to Your Website
Building Your Database on Your PC
In order to build your database on your PC and later Export it to your website requires setting up a localhost server on your PC and finding an HTML editor that will sync up with the server.
If you use Windows, the process of setting up and running a localhost so that you can test and edit scripts and build databases is very easy.
I recommend the IndigoAMPP web server and the HTMLPad 2010 HTML editor.
I recently installed IndigoAMPP for Windows on my Vista system and it ran on the first try after installation. Setting up HTMLPad 2010 to work with it is also an easy process.
Note=> Windows Vista User: You will need to turn off the Windows User Account security feature when installing and using both the IndigoAMPP server and the PostCast mailserver (if using to test email scripts).
(Windows Control Panel - User Account) Just uncheck the box when installing and using these tools.
I created a little tutorial that shows the whole process including how to start the server after you install it.
Go to Tutorial (DO THIS BEFORE YOU START THIS TUTORIAL)
Note: The server is FREE and you can try the HTML editor for 30 sessions or 30 days free. If you can't learn to build your database in that amount of time, don't buy the editor. NO RISK!!
Using Other Editors
You can complete this mini course with an HTML editor other than HTMLPad 2010.
The procedure for looking at your web pages and running scripts will be much more involved.
You will download the scripts to the htdocs folder of the indigoAMPP server.
To run the scripts, you will start the IndigoAMPP server, open your browser and enter the url of the script manually as:
http://localhost/nameofscript.php
When you get tired of doing that, download a free trial of HTMLPad 2010
Download the Scripts
The Birthdays Database management files can be downloaded in a zip file.
If using IndigoAMPP download to c:\indigoampp\apache-2.2.11\htdocs.
Extract there and you'll have a birthdays folder inside your htdocs folder. Run the scripts from there.
The package contains an integrated db management system, with a simple interface.
This Instruction file is included in the download.
Download birthdays_db.zip
Last tested on : August 3, 2010
MySQL Tutorial
To extend your knowledge of MySQL study the Docs and Tutorials at the official MySQL website. MYSQL.com
The best information on using PHP with MySQL will be found at PHP.net
