Drop all tables, MySQL.
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';
Copy and paste the result and run ...
Featured Website - Planescape Online
The Planescape Online website has been a labor of love. Since the beginning of my time at Conestoga College, in the Web Design and Development program, I have been working very hard on this personal project.
Friday, May 13, 2022
Friday, April 22, 2022
Noob Creating a Shell Script
Using the terminal can be a pain in the ass.
So let's make a shell script, so we can avoid typing in the same commands over and over again.
Connect to your terminal and log in, then type this...
cd ~
...or wherever you want, "~" is the users home directory...
mkdir shellScript
cd shellScript
...note: while you're typing in a file or folder name, type a few letters and press the TAB button, the rest of the name should appear automatically, unless there's another name that starts the same.
Create a script file:
Both "vim" and "nano" are file...
Monday, December 12, 2011
Internet Exploder
Notes on weird IE things:
IMAGES
Images saved in CKMY mode cannot be displayed in IE.
TRANSPARENCYS
img { opacity:0.4; filter:alpha(opacity=40); /* For IE8 and earlier */ }
POSITION ABSOLUTE: IE7 BUG
Beware of the "hasLayout bug" of IE. The relatively positioned parent element doesn't have layout, and hence IE forgets to redraw its children when it gets resized/repositioned.
The problem gets fixed if you add "overflow: hidden;" to the relatively positioned pare...
Tuesday, November 8, 2011
PHP: Ternary Operator, Short 'if' Statement, One Line 'if' Statement
The ternary operator is called so because it takes three operands; a condition, a result for true, and a result for false.
The ternary operator is a shorthand way of writing if statements.
Here's an example:
//Assign a string value to $x
$x = ($myvalue == 10) ? "the value is 10": "the value is not 10";
Breaking it down into its three parts you get this:
Condition: ($myvalue == 10)
Result for true: $x = "the value is 10"
Result for false: $x = "the value is not ...
Wednesday, October 12, 2011
CSS Positioning, Absolute
Here are a few tips for absolute positioning with CSS:
1) Default Position
By default, if you don't give values for the top and left styles, they are set to show the element where it would normally be displayed on the page.
2) Position Relative to a Parent
The element is positioned relative to a parent container. By default, the container is the browser window, but if a parent element has position: relative or absolute set on it, then that will act as the parent for positioning coordinates for its children.
3) Centering an Absolute Element
Here's...
Tuesday, September 27, 2011
Featured Website - Planescape Online
The Planescape Online website has been a labor of love. Since the beginning of my time at Conestoga College, in the Web Design and Development program, I have been working very hard on this personal project.
I'm happy to announce that the website is now in regular use (by my friends and I), and we're quite happy with how it works!
To understand exactly...
Monday, September 26, 2011
Preloading Images and Removing Screen Flicker While SWF Loads
There are many options to preload images in HTML pages. The simplest would be to create a div and move it off the screen.
In this div, I created a list to preload background images into (using CSS). The other images that are loaded up are header images for the other pages in the website. Once loaded they stay in the cache, thus the header images appear instantly when the user navigates to those pages.
<div id="img_preloader">
<ul>
<li>button hover</li>
</ul>
<img...
Monday, September 19, 2011
MYSQL Query tips
Querying for NULL or non NULL values
Since arithmetic comparison operators do not return meaningful results, use the 'IS NULL' and 'IS NOT NULL' operators in your query.
...to be contin...
Sunday, September 18, 2011
PHP here document (also called a here-document, a heredoc, a hereis, here-string or here-script)
Using heredoc in PHP
<?php
echo <<<EOT
<h1>This will display as an h1</h1>
<p>I can use "double quotes"</p>
<h1>and 'single quotes',
<p>plus $variables too, which will
be properly converted to their values,
you can even type EOT.</p>
<p>Make sure your opening EOT has no spaces after it,
and the closing EOT has no spaces infront of i...
Tuesday, May 24, 2011
Creating Websites with Adobe Flash
Compared to Dreamweaver, the process for creating a website in Flash is very simple. Drag and drop to the next level. The actionscript covered in class has been the simple stuff, e.i. goto a specific frame, link to URL.
Something that surprised me while working at home, Flash CS4 does not have a code snippets panel!
Flash allows for visual effects like fades and slides. However, from what I understand, Javascript is more efficient.
I'm looking forward to getting into more complicated Actionscript codi...
Monday, May 9, 2011
Designing websites with Dreamweaver
In this past course we learned about Dreamweaver, and how it's possible to create a decent looking webpage without knowing much about HTML or CSS. However, for me, the benefit to using Dreamweaver is the tips it gives you while typing out the script. Since I can't always remember the HTML tag names or the names of the CSS rules, it's very helpful to have the tip pop up and show the list of possibilities.
Also, the split view between design and code is nice. Getting used to how HTML and CSS work can be tricky, so being able to...
Sunday, April 24, 2011
Database Design
I have been thinking about a new website project. The site would be used to store and categorize information for a role-playing game. There would be a forum, and players would also be able to conduct live gaming sessions online. The database would be required to store data for the forum topics and posts, game system, characters, players and gaming session histo...
Monday, March 28, 2011
PROG1260 - Introduction to Programming with Visual Studio C#.NET
The design process for this course was very different from the last course (customer service). I found that with the customer service project, the goal was to create several different designs based on what the client might like, and let the client's input determine the final product.While programming, the design changed during the process as well, but only because I learned that certain functionality was possible as the project was being created.New features were added and the project grew as I worked on it. With programming, it's like if you...
Monday, February 21, 2011
The Best Portfolio Websites
thibaud.beThis is an amazing site because of it's interactivity. It's fun to just click around and see the pages move around. It loads fast and looks really professional. Very unique, very interesting to look at.fa-d.comVery clean and crisp. I like the style of this site very much. I love the awesome backgrounds that change automatically, it looks really cool on my TV.elliotjaystocks.comThis site is nice and simple. My attention was brought to his projects right away. The simplicity of the site kind of urges you to click around and see...
Saturday, February 12, 2011
Adobe Software
So far we've covered Photoshop, After Effects and Premier Pro. Out of these products, I would say Photoshop has the most functionality for Web Design. As far as designing the web page background, panels, buttons, and layout Photoshop is very useful. With the slicing tool, Photoshop gives you a quick way to cut your image into smaller components, and the 'Save for Web and Devices' option allows you to compare the size and quality of your images in different formats (like gif or jpeg).After Effects is very useful for creating animations and animated...
Thursday, February 3, 2011
3rd Course; Customer Service
As my designer for this customer service course, Bosa was able to take the ideas and strange requests I made and turn it into a very nice looking animated banner. I was impressed by her creativity and design skills today when she showed me what she had been working on. Thanks for the great effort Bo...
Web Design and Development Course List, Conestoga College
Course List
DSGN1210 - Graphic Design using Photoshop
DMED1330 - Video Animation with After EffectsDMED1320 - Video Design and EditingBUS1180 - Customer ServicePROG1260 - Introduction to Programming with Visual Studio C#.NETCOMP1215 - Database DesignPROG1240 - Web Page DesignDMED1300 - Creating Web Sites with DreamweaverDMED1310 - Flash AnimationDMED1340 - Introduction to Animation with Flash ActionScriptDMED1350 - Advanced Animation with Flash ActionScriptPROG1250 - JavaScriptCOMP1215 - Database DesignPROG1260 - Introduction to Programming with...
Monday, January 31, 2011
Second Course; Adobe After Effects
I'm enjoying this program is more and more every day! Now that we've finished the second course, I'm feeling great about where we're going. I'm looking forward to getting more into the programming and flash because I've been working on projects at home and I'm excited about creating some cool gam...
Wednesday, January 12, 2011
First Course; Adobe Photoshop
I've enjoyed the first course very much. It's been a lot of fun and I've enjoyed getting to know my classmates! I've been using Photoshop for a few months previous to this course, but I was still able to learn many new shortcuts and tricks.I'm planning to get the most out of this program by putting in many hours at home. I'm planning on working on the Flash game as an ongoing project that I do for myself. I'm really excited about the Flash cour...
