Wednesday, April 25, 2007

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

Tuesday, April 24, 2007

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!

Monday, April 23, 2007

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.

Sunday, April 22, 2007

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.

Saturday, April 21, 2007

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.

Friday, April 20, 2007

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/

Tuesday, April 17, 2007

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.

Monday, April 16, 2007

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!