In this JQuery Video Tutorial I will cover numerous topics with a focus on Event Handling. If you missed part 1 check it out first JQuery Video Tutorial.
I’ll show you below how to:
In this part of the JavaScript Video tutorial I will introduce Regular Expressions. A large number of people have trouble with Regular Expressions. I think it is because the name is so confusing? They aren’t!
A Regular Expression is a series of codes used to describe a series of characters in a string.
They are used to search for a specific string of characters in another string.
In this video tutorial I cover how to do numerous things with MySQL. I show you how to:
And a bunch more…
All of the MySQL statements follow the video. If you have any questions or comments leave them below.
In the next tutorial I’ll be getting into how to use MySQL with PHP.
SQL Statements from the Video
select prod_type,pt_id from product_id;
describe manufacturer_id;describe model_numbers;
SELECT DISTINCT Manufacturer_ID.Manufacturer,Manufacturer_ID.Man_ID FROM Manufacturer_ID, Model_Numbers
WHERE ((Manufacturer_ID.Man_ID = Model_Numbers.Man_ID) AND (Model_Numbers.PT_ID = 45)) order by Manufacturer;
use customer;
show tables;
describe customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index phone_id(phone_id);
drop index state_id on customer;
alter table customer add UNIQUE state_id(state_id);
drop index state_id on customer;
alter table customer add index state_id (state_id);
describe customer;
alter table customer add index order_id(order_id);
create index index_name on tbl_name(columnsToIndex);
alter table customer add column comments varchar(40);
describe customer;
alter table customer change column comments comments text;
describe customer;
alter table customer rename as newTableName;
alter table customer add fulltext index (comments);
show create table customer \G
select * from customer;
describe phone;
insert into phone values (NULL, ‘412-876-7878′,’Work’);
insert into customer values(‘Sally’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘Monkey2′),2,NULL,NULL,’Really nice lady who loves cats’);
update customer set comments=’Crazy man who has 2 cats named Peekaboo and Sophie’ where cust_id=1;
insert into customer values(‘Paul’,’Smith’,’234 Main St’,’Happy Town’,3,15234,SHA(‘pw1234′),2,NULL,NULL,’Sally Smiths husband he wants a dog’);
select first_name, comments from customer where match (comments) against (‘crazy’);
insert into customer values(‘Mark’,’Marks’,’194 South St’,’Happy Town’,3,15234,SHA(‘abc1234′),3,NULL,NULL,’Craziest man I ever met. Loves dogs’);
select first_name, last_name, comments from customer where match(comments) against(‘craz*’ in boolean mode);
select first_name, last_name, comments from customer where match(comments) against(‘+craz* -cat*’ in boolean mode);
In this video tutorial I will tackle Regular Expressions. People think Regular Expressions are too hard to use. And, while I have received many thank you’s for creating my last Regex Tutorial. Here I’m going to finish up where I left off.
Before you proceed you should most definitely take a look at those Web Design and Programming tutorials that came previous to this one. This tutorial starts with this article Web Design and Programming.
Based off of the best statistics, I’ve found, there are over 187 million blogs. People obviously love reading and writing blogs. There is little doubt then, that a business that doesn’t speak to its customers through blogging, is definitely alienating its customers.
In this day in age, it is very easy for any business owner, no matter how small, to create a website. These websites must build customer relationships, while pulling in business from all over the world. In the past, business owners needed to rely on extremely expensive web design companies to build them a site. Those days are now in the past, thanks to a fabulous program called WordPress.
WordPress, is a free blogging tool kit, that brings the power of internet blogging to the people. WordPress is the largest self-hosted blogging tool in the world, used on millions of sites and seen by tens of millions of people every day. The goal of this series of articles is to help people get started with WordPress. It really is quite easy.
There are two versions of WordPress. There is the blogging software you can use with WordPress, at wordpress.com. This operates in a way similar to most social networking systems like Myspace, Facebook, etc. There is another version, that you host on a hosting company, such as GoDaddy. This version can be downloaded from wordpress.org. If this is a bit confusing don’t worry. The video tutorials will show you exactly how to set up both of these versions of WordPress.
WordPress is so easy to use, because it takes care of all the technical stuff. This allows you, to spend all of your time writing. Whats better, is that WordPress allows you to easily create amazing tools and new web designs, with ease. We’ll get to them later.
A Few more Reasons why WordPress is Amazing
The Difference between WordPress.com & WordPress.org Websites
As I mentioned before, a WordPress.com site is similar to a social networking site. It is hosted on WordPress computers. It is free, for the most part, and extremely easy to set up. Almost every technical activity is taken care of for you such as: saving your content, blocking spam, security, upgrading, and promotion.
Let’s go back to that free sort of comment. First, in my opinion, WordPress deserves every dollar they make. I just want to make that clear. Either way, if you want to gain special benefits at WordPress.com you must pay for the following (prices on December 2nd, 2009):
Now if you want to host your own site and control everything, the version of WordPress found on wordpress.org, is the way to go. You will gain access to a larger number of web site designs, called themes. You will only be limited in size by your chosen hosting company. You will also gain access to a larger number of tools, called plug-ins. Plug-ins, give you access to tools such as: e-commerce systems, a wide assortment of media tools, and basically anything else you can imagine.
The negatives of hosting your own site include: you must pay a hosting site to host your site (avg. cost: $7 to $15 / month), it is more complicated to set up (many hosting companies will set upWordpress for you), you are responsible for upgrading your software, and your sites up time will only be as good as the hosting company. I personally, use GoDaddy for hosting, but there are a large number of other great hosting companies.
The minimum requirements a hosting company must meet include having, PHP version 4.3 or greater and MySQL version 4.0 or greater installed. It’s also probably in your best interest to install on a Linux rather than a Windows server. The best hosting companies include: Blue Host,DreamHost, MediaTemple, and GoDaddy.
In the next article, I will go into detail on how to create a WordPress.com account. You should do this even if you plan to host on your own site to gain access to Akismet, a great anti-spam tool. An additional benefit to starting with a WordPress.com account is that it gives you the opportunity to see if WordPress is right for you. Whether you chose to host on WordPress or from your own hosting company, the interface of WordPress is nearly identical. So, if you learn how to operate a blog on WordPress.com, you’ll know how to run WordPress on a separate hosting plan as well.
I hope this clears up any questions about using WordPress. Next, I’ll dispel any beliefs that WordPress is complicated to set up. If I missed anything, please tell me how I might improve the post.