Fun quiz

I was sad I missed any...
but I didn't use Google for any questions!

Mingle2.com - Free Online Dating

Making a dynamic drop-down list

More code:
Dynamically creating a drop-down list using a database!

Here it is in action:
Pretty cool.

Is there a market for this?

What do you think of this idea?

Check out Masterful!

This is awesome work!

Passing variables using either text boxes or drop down...

Here's the example:
http://killianstudent1.phpnet.us/Plants.htm

Here's the code:
http://www.davidcfreer.com/~David/code%20to%20make%20php%20variables%20pass.txt

Inserting information

http://www.freewebmasterhelp.com/tutorials/phpmysql/4

Look at how expensive!!

FREE iPod Shuffle Offer: MySQL for Database Administrators Training Course in Ft. Lauderdale, FL
(June 25 - 29, 2007)

Questions to ask yourself:

• Is your MySQL database secure? Do your users have the correct privileges and access rights?
• Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
• Do you want to save time using features like Stored Procedures, Triggers and Views?

..then attending the June 25-29th MySQL 5.0 for Database Administrators is exactly what you need! ($2495) Register by Wednesday April 22th, and receive a FREE iPod Shuffle!

An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, secure user privileges, create secure Stored Procedures & Triggers to update and access data, set resource limitations, access controls, and more! More class details can be found at: http://www.mysql.com/training/workshops/mysql_dba.html

Deadline for Registration and to qualify for the iPod Shuffle is Monday, April 23rd

To register for the workshop, simply reply to this email, aalwin@mysql.com,
or call me at 303-990-1382.

We get great feedback from those that attend, so don’t miss out on this great training class with excellent savings - it is filling up fast. Also, join thousands of organizations that cost-effectively scaled-out their infrastructure with MySQL.

Sincerely,

Alexandra Alwin
US Training Representative
MySQL Inc.
Office: 303.990.1382
aalwin@mysql.com

New Groups

JP & Michael - Sports shop
Jorge & Luis- Video game store
Yogan & Kalpesh- Flower shop
Derek & Ian- Hosting company

We will add much more to this
project and it will be spectacular!

Leave a comment here

Leave a comment with your main Braman business page here. On the page you need to have links to the three tables with all the data displayed. Have a link to the letter to Mr. Braman and make sure the Flash ad is online and is easy to access.

Next we will select new groups and new businesses to work with!

Code to insert car tables

$db = new mysqli('sql4.phpnet.us', 'pn_461233', 'student1','pn_461233_test');

/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

$Name = 'Mahogany';
$Size = '25g';
$Cost = 90;
$Quantity = 12;

//if ($mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
// printf("%d Row inserted.\n", $mysqli->affected_rows);

if (mysqli_query($db, "INSERT into plants (Name, Size, Cost, Quantity) VALUES ('Mahogony', 'Size', 23, 22)")) {
printf("%d Row inserted.\n", mysqli_affected_rows($db));
}

$result = mysqli_query($db, 'SELECT * FROM plants');
while ($row = mysqli_fetch_object($result)) {
printf(
htmlspecialchars($row->Name)
);
}
mysqli_close($db);

Differences with computer science

http://compsci.ca/blog/6-degrees-of-computer-science/

The Birth of Linux

Reviews for blog

On your blog, I want you to evaluate the following ideas:

• What do you think of the idea behind: http://www.meetwithapproval.com/?
• Write a post of at least 100 words. Will this site get very popular?
  
• Read this about competition for Wikipedia.
• Write a post examining the pros and cons of this new idea. Also answer the following question: If you were a teacher, would you allow students to use wikipedia as a reference source?

Due today.

What Yahoo is looking for...

Is the same as anyone is looking for:
http://blog.pipes.yahoo.com/pipes-is-hiring#backend

People who are not afraid of problems. People who can solve things and people who know how to think. This class will help you get practice thinking but it won't do anything for you if you fight the process. You have to be willing to actually WRITE the review.

cool site

http://upcoming.yahoo.com/

Please register for the forum...

I finally got the phpBB forum up and running! Please register here:

www.davidcfreer.com

I don't have a way to email passwords (Bellsouth disables port 25), so there will be an error message...but do not despair. Simply go to Login and use the user name and password you just created. Extra credit if you leave a message in one of the forums I created.

Leave your comment here.

250 word review of desktoptwo.com due April 20th 2007 @ 10pm. Leave your comment here.

You may compare it to goowy.com. Do you like the site? Is it useful? What's good? What's bad?

Web OS Assignment

Check this out:
http://desktoptwo.com/

• Write a 250 word review of the service on your blog for a grade.
  
• This is a great overview of the hacking associated with Myspace.com. Check out his hypocrisy at the end of the article.
• Check out the PHP scripts on this page: http://www.hotscripts.com/PHP/Scripts_and_Programs/index.html
• Look at what CSS can do:

Peer-to-peer is quite slow!

Great video! He invented the web.

http://www.brainbell.com/tutorials/php/Retrieving_Results_Of_A_Query_To_MySQL.htm

Try this...

Try typing killiancomputers into Google. Cool.

Here's the PHP code for mysqli

This works:

if ($db = @mysqli_connect('sql4.phpnet.us', 'pn_461233',
'student1')) {
mysqli_select_db($db, 'pn_461233_test');
$result = mysqli_query($db, 'SELECT * FROM
table1');
while ($row = mysqli_fetch_object($result)) {
printf(
htmlspecialchars($row->name)
);
}
mysqli_close($db);
} else {
echo "Connection failed";
}

Google (meaning you) are your best teacher. Don't wait for me to find mysqli connection strings. Oh well.

Newer connection string

This connection string worked for me:

/* Connect to a MySQL server */
$link = mysqli_connect(
'sql4.phpnet.us', /* The host to connect to */
'pn_461233', /* The user to connect as */
'student1', /* The password to use */
'pn_461233_test'); /* The default database to query */

if (!$link) {
printf("Can't connect to MySQL Server. Errorcode: %s\n", mysqli_connect_error());
exit;
}

/* Send a query to the server */
if ($result = mysqli_query($link, 'SELECT * FROM table1')) {

print("Very large cities are:\n");

/* Fetch the results of the query */
while( $row = mysqli_fetch_assoc($result) ){
printf("%s (%s)\n", $row['name']);
}

/* Destroy the result set and free the memory used for it */
mysqli_free_result($result);
}

/* Close the connection */
mysqli_close($link);

No more mysql_...we are in 2007 now!

Learn for the sake of learning!

If you don't learn to love learning and exploring....

Don't ever let a boss talk to you like this:

BEAVER COMPUTER!

http://www.engadget.com/2007/04/13/compubeaver-case-mod-the-pc-stuffed-beaver/

Connect to a database

http://aoitweb.blogspot.com/2006/02/homework-assignment.html

Free software and how much the paid alternative costs

Really interesting.