Home
Videos uploaded by user “Internet Services and Social Networks Tutorials from HowTech”
How to Create Shape Tween in Adobe Flash
 
01:20
This tutorial is about how to create shape tween on flash. This changes the shape of objects over time. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to create a shape tween on flash. This changes the shape of objects over time. Shape tweening is similar to morphing where the shape of the object is targeted. In this tutorial, we will teach you how to shape a tween where the star is going to turn into a circle. Step 1: Create a new Flash Project In order to get started with our "how to shape a tween" guide, open up Flash and create a new Flash project. Step 2: Create a star shape After the project has opened, draw a star using the polystar tool. Do not convert the object to a symbol. Shape tweening is not valid for symbols and groups. Place the star on the upper left corner of the stage. Step 3 -- Insert Key frame Sometimes in flash, the shaped could automatically be converted into a symbol. In that case break them by pressing the "CTRL+B" key Select frame 30 and insert a key Frame. Choose the oval tool and draw a circle on the upper right corner of the stage. Now delete the star shape. Make sure that you do all of the above at frame 30. Step 4 - Execute the tween Now, select frame 1 and open the contextual menu. Choose shape tween. Note that the frames following the tween turn green. This denotes a successful tween setup. You can run the program now to see the star turning into a circle. This is a simple example of how to shape tween on Flash. Shape tweening is the basic of morphing. Sometimes the shape change may not be the one expected. In such cases, shape hints are used. Shape hints are properties used to control the changes that are made in the object.
How to Set ODBC MySQL Driver
 
02:09
Follow this step by step tutorial to learn how to setup MySql ODBC driver for windows and how it is configured. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ ODBC stands for Open Database Connectivity. It is used to provide a connection for the database. It acts like a bridge between the database manager and the Operating System. With this driver installed and configured, we can use our database with various applications such as spreadsheets, reporting tools or various other software suits. In this tutorial we will learn to set up the same my sql ODBC driver Step 1- Download First, let's download my sql ODBC driver. It can be downloaded from dev.mysql.com. Over there, choose the version according to the operating system we are running. For this tutorial, we will be setting the ODBC MySQL driver in windows. Step 2- Installation After finishing with the download, run the setup for installation. Just follow the step by step process of the installation wizard to install the driver. Step 3- System Settings After the installation, we have to configure the connection. For that, open up the Control panel and click on the System and Security option. Step 4-Admin tools A window will open up with several options in it, open up the Administrative Tools option from there. Step 5-Data Source All of the Administrative tools would be displayed in a separate window. We have to setup our database connection, so for that click ODBC Data Sources option. Step 6- Adding System DSN A window will open up having different tabs in it. Choose System DSN tab and then click Add button on right. Step 7- Choosing ODBC option A window will open up having the list of ODBC drivers in it. As we have to configure our ODBC driver for MySQL, choose My SQL ODBC Driver option and click on Finish. Step 8-Configuring the Connection With that done, the odbc mysql configuration window will open up. In that window, give the data source a name, if MySQL instance is installed in the same pc in which we are setting up the ODBC driver, give "localhost" as a name of TCP IP server and leave the port as default. Give the appropriate user name for which you have granted access to your database, here let us assign "root" in user as it has access to all the databases by default and leave password field blank as root is configured with empty password by default. After that, we have to choose the required database which we want to be linked through this connection from the databases drop down menu in the bottom. After that, click OK button. Step 9- Connection Appeared In List The connection would appear in the System DSN Connections list. This connection basically contains the information of the server on which MySQL is installed and the database which has to be used. And this is how MySQL ODBC driver is setup in windows.
How to Unbid on eBay
 
01:40
This tutorial will show you the process for unbidding on eBay. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to unbid on eBay. This is a complex process as retracting a bid is only available in a limited number of situations, such as accidentally bidding the wrong amount. Step # 1 -- When can you Retract a Bid When you bid on an item you are entering into a contract, therefore it is difficult to unbid. Visit the site "pages.ebay.com/help/buy/bid-retract.html" to see when this is possible. As you can see here the options are limited. This tutorial will look at when you have accidentally bid far too much for an item. Here we are going to go to an eBay item and purposefully overbid to show you how this works. We will enter a large sum then click "Place bid", in the dialog box that appears we will click "Confirm bid". Step # 2 -- Starting the Retraction Process Now that our bid has been placed let's look at how to undo that. Click "Close" in the dialog box and copy the item number (found lower down the page) to the clipboard and view the bid history by clicking the link that reads "[X number of] bids". A page will load and at the bottom you need to click the "Learn more" option. This will redirect you to a page about bid retractions. Click the "Bid Retractions form" link and you may need to sign into your account again. Step # 3 -- Retracting the Bid This bid retraction page will load and you need to paste the item number we copied earlier into the first box here. From the drop down box select the reason you are retracting the bid, here "Entered wrong amount" and click "Retract bid". This bid retraction will be confirmed and that is how to unbid on eBay.
How to Open MySQL Database With MS Access
 
01:57
Follow this easy step by step tutorial to learn how to open MySQL database in Microsoft Access, through an ODBC connection. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ It can be needed in many situations to link our MySQL database to any other database, spreadsheets or reporting tool. This tutorial will focus on one of the same scenario in which we will learn to open MySQL database. Step 1- Control Panel To link MySQL with Access, first of all, we would have to make an ODBC connection. For this purpose, open up control panel and click on the System and Security option Step 2-Administrative Tools After that, move to the Administrative Tools option. Step 3-ODBC Connection Option Click on the ODBC data source option. Step 4- Making System DSN ODBC data source admin window will open up. Over here, move to the DSN tab and click on the Add button. Step 5- Driver for MySQL Now scroll down the list, choose MySQL ODBC driver and click on the Finish button. Step 6- Configuring ODBC Connector A configuration window will open up. Give a name to the data source, type "local host" in the server field, specify "root" as a user, because it is a default user in all MySQL instances, and write the name of the desired database in the database field. Finally, click on the Test button. Step 7- Connection TEST A message will pop up confirming that the connection is successful. This means that now we would be able to link MySQL with Access. Step 8- Microsoft Access Now, open up Microsoft access, click on the Blank database option and let's create a new database. Step 9- External Data After that, move to the "External Data" tab and click on the More option. With that done, a drop down menu will appear on the screen. From the menu, choose the ODBC database option. Step 10- Linked Table Within the new window, choose the "Link to data source" option and hit Enter. Step 11- Machine Data Sources A window will open up where we will be required to choose the data source connection. Over here, move over to the Machine Data Source tab, choose the same DSN which was created earlier and hit Enter. Step 12- Selecting tables After that, it will show us all the tables which our database contains. We can choose any table individually or select all of them. For this tutorial, we will select all the tables in the database. Step 13-Database Imported to Access After that, all of the database tables would appear in Microsoft Access And that is how to open Mysql database from Access.
How to Update WordPress Manually
 
04:06
Learn how to manually update WordPress engine. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to update WordPress manually. If you want to update WordPress manually you have to go into the Wordpress admin panel. Before you proceed with the upgrade, we strongly advise you to make the online backup of your WordPress. Go to the dashboard and choose "Plugins" tab. From the drop-down menu choose "Add New". On the next page enter the keyword "backup" into the search bar and press "Enter". Choose the "Online Backup for WordPress" plugin and click "Install Now". In the pop-up window, press "ОК". After the installation is complete, click on "Activate Plugin". On the next page, click on "View Status" of the installed plugin. Go to the "Backup" tab and choose "Download" as the backup type. Click "Start The Manual Backup". After the backup process is complete, press "Download Full Backup" and save it on your hard drive. Go to the "Plugins" tab and choose "Installed Plugins". Disable all the installed plugins to avoid any problems after the upgrade. Now you can install the latest version of the WordPress. Click on the link at the top of the page to download latest version of the WordPress. Download the archive with latest version and save it on your hard drive. Now go to the downloaded archive and extract its contents. Wait until the extraction process is complete and open the "wordpress" folder. Delete the "wp-content" folder. Open the "Filezilla" file manager and enter the address of your FTP server. Select all the files and folders except: "wp-config.php" file; "wp-content" folder; "wp-images" folder; and "Plugins" folder; Right-click on the selected files and press "Delete". In the pop-up window press "Yes". Wait until the removal process is complete. Go to the "wordpress-3.5" folder on the left. Select all files, right-click and choose "Upload". After the upload process is complete, go to the "Failed transfers" tab and press "Process Queue". Now go back to the browser window. Press "F5" to reload the page. Click "Update WordPress Database". Your WordPress database has been successfully updated. Click "Continue". As you can see, the WordPress has been updated to the latest version. Go to the "Installed plugins" and reactivate all the previously disabled plugins. Now the WordPress has been successfully updated.
How to Prevent Emails from eBay
 
01:12
This tutorial will show you how to prevent emails from eBay. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Although many emails from eBay are useful, some are just promotional, in this tutorial you are going to learn how to stop ebay emails. Step # 1 -- Opening Account Settings Navigate to eBay and make sure that you are logged into your account. In the menu at the top click the "My eBay" option. In the new page that loads click on the "Account" tab. Step # 2 -- Viewing the Email Options On the left of the screen there is a menu with some links in it, click on the one that reads "Communication Preferences." On the right an area will load that contains all of the details about the emails you will receive, click "Show All" to see all the settings. As you scroll down you will see that some can't be stopped, but these are generally the most important. Step # 3 -- Stopping Promotional Mail To stop promotional mail, scroll right to the bottom of the page and locate the "Promotions and surveys" area. Uncheck the boxes to the right of these options to prevent the emails from being sent to you. Finally click "Save" and a message will appear confirming the changes and that is how to stop ebay emails.
How to Send an Email to Undisclosed Recipients from Gmail
 
01:10
In this tutorial, you'll learn how to send e-mail to Undisclosed Recipients from Gmail. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Step # 1 -- Setting up the Undisclosed Recipients Open your Gmail and click "Compose Mail" to create a new message. In the "To:" field, you'll need to type "Undisclosed recipients "[email protected]". "youremailhere" meaning your Gmail address. Step # 2 -- Adding recipients to the e-mail Now, click "Add Bcc" and type all desired recipients of the e-mail into the "Bcc:" field, separating each contact with a comma. Once you've added all of the recipients to the Bcc field and have your undisclosed recipient's information in the "To:" field, go ahead and write a message subject and body. Click "Send" to send the e-mail. Step # 3 -- Checking the Email Here we have sent it to an email address that we also can access so we will just check to make sure that it works. Navigate to this email address and open the email. When you look to see more information about where the email was sent you can see in the "to" field that it says "Undisclosed recipients". This is a valuable way to protect the privacy of the people that you are sending the email to. That's it, you now know how to send an e-mail to Undisclosed Recipients from Gmail.
How to Enable Users to Subscribe to Your Wordpress Blog
 
02:57
Follow this step by step guide to learn how to enable visitors to subscribe for your wordpress blog. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ User subscriptions can be handled in many ways. In this tutorial, we will be discussing a couple of common ways of subscription. One way to do so is by RSS Feeds while the other is by Email Subscriptions. In this tutorial, we will teach you how to subscribe wordpress blog. Step 1 -- Feed Burner First of all, you need to go to feedburner.com. Over here, sign in with your Google Account. Step 2 -- Specify the blog's Address Once you have signed in, a welcome page will open up. In the welcome page, type your wordpress blog's address under the field titled 'Burn a field right this instant'. Once you are done, click on the NEXT button. Step 3 -- Identify the Source With that done, another page will open where you will be asked to identify your feed source. Choose the first option and Click on the NEXT button. Step 4 -- Feed's Title and address As a result, a new page will open up. Here, you can modify your feed's title and address. For the purpose of this tutorial, we will leave it as it is. Click on the NEXT button to proceed further. Step 5 -- Feed's URL In the new page, you will be congratulated and will be displayed with your feed's address. Simply copy the address and sign in to your dashboard. Step 6 -- Add a new plugin Now we have to add a plugin in our wordpress site. In order to do so, go to the plug-ins tab and click on the Add new button. Step 7 -- Install a Plugin In the Search field, type "Social profiles Widget" and hit Search button. You will get a list of widgets in the search results; choose the one by the writer "Nathan Rice". Click on the Install Now button. Step 8 -- Go to Widgets You will be displayed with a confirmation message. Click on the ok button to proceed. Once the installation has completed, click on the Activate Plugin option. Now go to the Appearance tab and click on Widgets. Step 9-- Add a widget With that done, find "Social Profiles" under the Available Widgets and click on Add. Step 10-- Configure the Widget Now give a suitable title to your widget and paste the address given by feed burner under RSS/feed burner URL. Once you are done, click on the Save Widget button. Now visit your blog and you will notice the RSS Feed icon and the title you gave to the widget. Click on the icon and a new page will open where you can see your blog's feed. This was all about the RSS Method. Step 11 -- Publicize Email Now we will teach you about the Email Subscription Method. For this, you will have to open feedburner.com again and click on your wordpress blog's Title. As a result a new page will open up. Over there, click on Publicize tab and then click on the "Email Subscriptions" option. After that Email Subscriptions page will open up. Just click on the Activate Button below to activate this feature. Step 12 - Subscription Link As a result, another page will open up. From here, copy the Subscription Link from the "Preview Subscription Link " section and then move back to your wordpress dashboard. Step 13 - Add text Widget Now you have to use a text widget to insert the Subscription link. For that, go to your dashboard and open Widgets under Appearance tab. From the available widgets, find the "Text" widget and click on the Add button. Step 14 - Set up text widget With that done, the text Widget will open up. Give it a suitable title which you want your visitors to see. Next, Paste the copied Link in the text field and Save the Widget. Now visit your blog and you will notice the Email Subscription Link. Click that link and a new page will open up where visitors can subscribe to your blog after entering their email addresses. And this was all about how to subscribe wordpress blog.
How to Import Powerpoint Presentation to Prezi
 
01:41
Follow this step by step guide to learn how to import powerpoint slides in prezi. Learn how to work in prezi, present the powerpoint slides in a layout, etc. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, we will teach you how to import powerpoint presentation to prezi. We will add teach you how to import powerpoint presentation slides into prezi, present them in a layout and eventually present them in a slideshow. Step 1 -- Go to prezi.com Follow this step by step guide to learn how to import powerpoint presentation to prezi. First of all, open your browser and go to prezi.com. For the purpose of this tutorial, we have already created an account on prezi. Step 2 -- Click on New prezi button Once you are logged in with your account, click on the new prezi button available on the left hand side. Step 3 -- Choose a template A new page will open up in a new tab where you will be asked to choose your template. For the purpose of this tutorial, we will start off with a blank prezi. Step 4 -- Insert powerpoint presentation You will notice a circle where you can add a title. Since we want to add a powerpoint presentation, we will simply delete this and make the prezi blank. Once you are done, go to the top and click on the insert button. From the drop down menu, select the PowerPoint option. Step 5 -- Choose presentation As a result, a window will appear from where you can open the presentation that you want to import here. Step 6 -- Insert all slides Once you have opened the ppt, you can monitor the progress of the upload in the right pane. Once the powerpoint slides have been downloaded, click on the insert all button to add all the powerpoint slides to prezi. Step 7 -- Choose layout As soon as you click on the insert all button, you will be asked to choose a layout for the slides. For the purpose of this tutorial, we will choose the caterpillar layout. You can add a path between your slides by checking the respective option. Click on the insert button to insert the slides in the particular layout onto prezi. Step 8 -- Click on present Click on the green tick mark if you are satisfied with the insertion. You can always zoom in and out of the different circles, increase or decrease the text box size, tilt the text boxes as per your requirement, etc. Once you are done with the changes, click on the present button on the top left corner of the page. As a result, a prezi slideshow will start in full screen. Click on the arrow keys at the bottom to skip from one graphic circle to another the same way you go from one slide to another. In this manner, you can import a powerpoint presentation to prezi.
How to Insert Facebook Like Button on Blogger
 
02:11
This tutorial will show you how to insert a Facebook like button into Blogger. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to insert Facebook like button on Blogger.   Step # 1 -- Navigating to the Developers Part of Facebook To begin, make sure you are logged into your Facebook account, then type the following URL into your browser's address bar: "https://developers.facebook.com/docs/plugins".   Step # 2 -- Entering the URL for the Button Click on the Like Button link, which is the first plugin shown. Next, enter the URL of the web page you would like to add the like button (most likely your blog's homepage) into the "URL to Like" box (be sure to use the full address, starting with http://www.), un-check the "Send Button" box unless you are experienced in Java, choose from the three layout styles, and then choose your remaining options.   Step # 3 -- Adding a Gadget to your Blog Now, click the "Get Code" button (if you chose HTML5 or XFBML, there are two and three, respectively, sets of code; if you choose IFrame or URL, there is only one string of code), then open your Blogger account dashboard (make sure you are logged in) in another window. In the left-hand navigation bar, choose "Layout," then click on the "Add Gadget" link (there may be more than one -- click on any "Add Gadget" link and you can move it where you like later).   Step # 4 -- Completing the Insert Scroll down to the "HTML/JavaScript" option and click the + button on the right. Leave the "Title" field blank, click on the "Create Link" icon, and paste the code into the "Enter URL" field (you will create one, two, or three links based on the type of code you chose as explained above). In this example we just have one bit of code. Click "Ok" and then click "Save." Finally, back on your Blogger layout page, click and drag the like button widget wherever you would like the button to appear on your blog. Well done, you now know how to insert Facebook like button on Blogger.
How to Embed Video to HTML Document
 
01:35
Follow this tutorial you will learn how to Embed Video files using HTML in web pages. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial we are going to show you that how to embed video in HTML document. Videos are the best way for understanding anything. Keeping this in mind, working with HTML embedding videos is growing vigorously and there are special videos search engines available on internet. On the other hand people also embed videos in HTML documents as their resume and sharing links to the employers. Step 1 -- Video tag with width and height Over here, HTML is embedding videos from the desktop which we use as a sample. To get started, first let's right click on the file and click on properties. Here there are three things to remember. One is the name of the video file, the extension of the video file and the height and width of the video. Now let's create an HTML document first. For that, open up notepad, and let's start by first typing in the video tag. In this tag, we will set the dimensions of the video, and make sure that they are the same as the original video. Step 2 -- Location of video in the source tag Now it's time to set the source of the video file. For that, we will create a source tag here. Type "src", followed by an equals to sign. The source link should be in inverted commas here. Now we can type the location of the file within the inverted commas. It is important to note that if your html file and video file is in the same location, you only need to write the name of file with its extension. With that done, we will set the type to video forward slash mp4. This is because our video is in the mp4 format. Step 3 -- Selecting HTML video document location Now let's save this document as an html file. Step 4 -- Video HTML file Now let's save this document as an html file. With that done, let's open up the html document in the browser. Step 5 -- Video without navigations Over here, you will notice that there is no video navigation, for example the play or stop button. Step 6 -- Added control attribute in video tag So let's go back to our html document and in video tag, let's type "controls" after defining the dimensions. Step 7 -- Video with navigations Let's refresh the page now and you can see video is playing as you click on the play button. Step 8 -- Set width for video player You can always resize the dimensions of the video player according to your requirements by changing the width and height in the code. And that's it.
How to Change Wordpress Username and Password from admin
 
01:50
Follow this step by step tutorial to change username and password of any wordpress user from admin account. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ After learning this tutorial you will be able to change username and password of your users of wordpress blog easily. By default wordpress does not allow you to change username once it is created. But there are two ways available. The first one is by creating new user and associate all posts to this user and delete the old one. And the other is to change the username from phpmyadmin and change password from all users page. In this tutorial we are following the 2nd way. By the end of this tutorial you will be able to change username and password for the particular user. Step#1: Login to Control Panel Of Your Website To change username of a particular user you must login to Control panel of your website to change it from database. Step#2: Go to PhpMyAdmin Select Phpmyadmin in order to go to your database   Step#3: Connect to the Database In Phpmyadmin you can see the database of your website. Click on Connect now to connect and access the database. Step#4: Select the Wp_user table All the information about the registered users of your website is stored in the table wp_users. Click on this table to see the users list.   Step#5: Edit the user details On this page you can see all the users registered to your website. Click on edit on the user you want to change the username.   Step#6: Finding the username Field Find user_login field that is the username of that particular user.   Step#7: Editing the username Field Edit the User_login text field. Step#8: Save changes Click on Go and all the settings will be updated. Step#9: Change password From Admin First of all login to your admin account   Step#10: Go to all Users On the Dashboard Click on go to All Users in the users tab.   Step#11: Select the user you want to change password On this page all the users are shown. Click on edit on the user you want to change password. Step#12: Change password Scroll down the page and you will see the new password field. Enter new password and confirm it by re entering and click on save changes.
How to Insert Into Table In SQL
 
02:46
Follow this step by step easy tutorial to learn how to insert data into the tables in SQL Server Database via queries. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ The data inside the database is held by the tables. The data can be inserted in these tables either by the queries or even with a straightaway Graphical method. In this tutorial we will see both the methods. Step 1 -- Locating the Appropriate Database First of all, we need to locate and expand the database where that particular table is present. After that, expand the table's directory. Then we will insert the data in the Inventory table. If we move into the column section, it can be seen that there are four fields which have to be added, namely the ID, the Product Name, the Quantity and the Price. Step 2 -- Writing query for inserting record Now to insert in table, SQL query would be: Insert into Inventory (id,Product,quantity,price) values (1,'abc',12,255.32); Make sure that each value is separated by a comma. Once done, simply press F5 to execute the query. At the bottom, in the messages section, a message will appear about table rows that have been affected. Step 3 -- Another Method of Insertion We can also insert data in a table by simply giving the values straight away. For that just write the following query: Insert into Inventory values (1,'ab2',30,300.36); Make sure that the values in query in SQL inserted into table are in the same order as the order of columns in the table. Now let's execute this query and in the messages section, you can see the rows that have been affected. To insert in table, SQL queries are required to be written with much care as error can arise if we just miss to insert ellipsis even. Step 4 -- Viewing Table Data Now let's check the table to see if the data has been inserted correctly. For that let us fetch all records from the inventory table and for that, write: Select * from inventory When we execute the query, you can see all the records in the results section below, and they are exactly the same as we mentioned in the query in earlier steps. Step 5 --Alternate Method of inserting data To insert in table, SQL provides another way through which we don't have to write SQL insert into table queries. For that, just right click on the inventory table and choose the 'Edit top 200 rows' option. Step 6 -- Inserting data in Fields Over here, we can start inserting the data in the table straight away, without using the queries. All we have to do is type the records in the fields and press enter to save the changes made in each field. And that is how data is inserted in tables in SQL using insert keyword.
How to Cite in a Wikipedia Article
 
01:13
This video tutorial is going to show you how to cite in a Wikipedia article Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Wikipedia articles can be cited in different formats. These formats include American Psychological Association (APA) Style, Modern Language Association (MLA) style, Modern Humanities Research Association (MHRA) style, Chicago styles among others. In this video, we are going to show you how to cite Wikipedia in all available styles. Step #1 choose your intended article Choose the article that you intend to cite on Wikipedia. Step #2 Click on tool box and choose cite this page On the left hand of the page, on your toolbox, expand the menu. Click on the link that says 'cite this page.' Step #3 scroll down and select your preferred citation style You will be taken to a new page. Scroll down and select your preferred citation style. Step #4 copy citation and paste it on your article Copy the citation and paste it below your document or article that you are working on. The citation will act as a source of reference. And you are done citing an article in Wikipedia. Thanks for watching this video tutorial, Leave comments and ask your questions by our e-mail [email protected] was Howtech dot TV tutorial. Thank you for watching!
How to Set Up MySQL Replication
 
03:08
In this easy step by step tutorial, you will learn how to replicate the contents of MySQL database. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Introduction MySQL Replication basically allows the contents of the master database server in MySQL to be replicated to other database servers. In this tutorial we will show you how to set up MySQL replication through phpMyAdmin. Step#1: Getting Started with Replication To get started, first of all, log in to your php my admin panel, and then click on the Replication tab on the top. Step#2: Replication Plan From there, click on the Configure option, under the Master Replication section. With that done, the master configuration section will expand, having a list of databases and a replication plan as well. Step#3: Create new Database Here, you can either Replicate All databases while ignoring the ones selected, or the other way round, that is, ignore all the databases and replicate the ones which would be selected. Let's choose the second plan and then select the database named "test" over here. With that done, copy the lines shown below the list. These have to be added in the MySQL "my.ini" file. Step#4: MY.INI File Since we are using the XAMPP server, the "my.ini" file can be fetched by clicking on the Config button and choosing the "my.ini" option against the MySQL Module. Step#5: Setting up MY.INI File Once the file opens up, navigate to the "log_error" parameter, and just paste the copied lines beneath that. With that done, change the "max allowed packet" size to 16 MB. Once you are done with that, scroll down the file and comment out the "server-id" parameter with a hash sign. When you are done with that, save the file and then restart the services of both Mysql and Apache. Step#6: Master Replication Setup After that, switch back to your phpMyAdmin page, and hit the F5 key to refresh the panel. With that done, move over to the Replication tab again. There you will find that the Master Replication has been set up successfully. You can click on the Show Master Status option to see its status. Now, click on the Add Slave Replication user option to add a Replication user Step#7: Creating Replication User Specify the username and the host, and then click on the Go button. A replication user would be added as a result. Step#8: Slave Replication Setup Now open up the Replication tab again, and click on the Configure option under the Slave Replication section. Another page will open up, and from here, copy the Server id which has to be pasted in the "my.ini" file. So let's open up the "my.ini" file again and locate the "server-id " parameter which we had commented earlier. Over here, simply paste the Server id copied from the Slave configuration, save the file and restart the MySQL services. Step#9: Updating Slave Configuration Now switch back to the Slave Replication page again, and specify the user details which were created before. With that done, click on the Go button. A message will appear that the Master server had changed successfully. Step#10: Warning Messages Now, if you open the Replication tab once more, you will notice two warning messages appearing in the Slave Replication portion. One would be regarding the Slave SQL Thread and the other would be regarding the Slave IO Thread, both of which won't be running. To resolve these errors, simply click on the Control Slave option, and Start these threads one after another. You will notice that the warning messages would disappear. Step#11: Verifying Replicated database Now click on the Databases tab and here you can see that the test database has been replicated successfully. This means that we have setup and configured MySQL replication. And this is how to set up MySQL replication using phpMyAdmin.
How to Use Addchild in Action Script
 
02:12
This tutorial is about how to use addchild in action script on flash. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ ActionScript 3.0 uses a very powerful display list through which objects are displayed in flash. The display list can be applied only to objects that are visual, like shapes, text box and lines. Values and variable are non visual objects and cannot be used by display list. Display list uses two important functions; addChild() actionscript 3 and removeChild(). addChild() actionscript is used to display object to the screen and removeChild() to remove the object from the screen. Let's look into a simple example to add a circle shape and a text box. Step 1: Open a new flash project First, let's open a new flash project. ActionScript 3.0 should be the type of the file chosen. Step 2: Create an object Create an object myText of class TextField and instantiate the same. Add some text to myText. To make the objects visible in the stage, use the addChild() actionscript method as follows: This text can be formatted, resized and repositioned. There are functions available for all the text manipulation. Step 3: Creating a symbol Previously in ActionScript 2.0, there were classes to create shapes instantly. This is removed in ActionScript 3.0. So to import the shapes, we should create them manually. To start with, let's create a circle and convert it to a symbol. In the 'convert to symbol' window, choose the option 'Export for ActionScript' in the advanced settings and type in the class name as 'Circle'. This movie clip is now registered in the library. Delete of the circle from the stage area. Step 4: New Circle Similar to the class TextField, we have a class for the circle. To instantiate the class, let's type in the following code followed by the addChild() actionscript 3 function to display on to the stage: Step 5: Remove Circle To view the circle and the text on the stage, test the movie by pressing CTRL+Enter. They are present one after the other. Extend the timeline till frame 60. Now we are going to add the removeChild() function. So at frame 60, the Circle should be removed from the screen. With frame 60 selected, open the action window and type in removeChild(myCircle). We are also adding a stop(); function to the code, to stop the test movie from looping. Now let's test the movie. Notice that the Circle Stays for 2 seconds and disappears. It is due to the removeChild() function. Conclusion The position of the objects can be controlled by altering the x and y axis. Other object properties that can be changed are skew, size, font, font size and many more.
How to Use eBay Turbo Lister
 
01:57
In this tutorial you are going to learn how to use eBay turbo lister. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Step # 1 -- Installing Turbo Lister First you are going to need to download Turbo Lister, visit the site "http://download.ebay.com/turbo_lister2/setupUS.exe" and a file will begin to download to your machine. When the download has finished open the file and click "Yes" in the dialog box that appears. The installer will run, click "Next", accept the license terms and click "Next" again. Click "Next" two more times then click "Install". The installation will run. Step # 2 -- Starting the Program When the install has finished check the "Launch the program" box and click "Finish". The program will begin and it will need to set up for a few minutes. The program will launch and here we are going to choose to explore the sample listing option, this will allow me to explain the program to you. You can later create your own real listings using the program. Close the tip window and you'll have the standard Turbo Lister interface. Step # 3 -- Creating a New Item Let's first have a look at creating a new item, click "New" in the menu bar and from the menu that appears we are going to choose "Create New Item" but if you want to list multiple items at once you can select another option. A window will open which will ask for the standard information eBay requires to make a listing -- spend some time filling this out. When you are done click "Save" and the listing will appear in your Turbo Lister inventory. Step # 4 -- Uploading to eBay As this is just a sample we are not going to be uploading this to eBay, but if you wanted to you can use the "Add to Upload" button at the top which will add the listing to any others that you are ready to add to the site. This is just a basic introduction to eBay turbo lister and you can probably already see the value for sellers who need to list multiple items, especially if they are similar.
How to Motion Tween in Adobe Flash
 
01:19
Follow this tutorial in order to learn how to create motion tween in flash. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial is about motion tween in flash. It is a very important concept and also the basic of moving objects in flash. This helps modify the properties of a symbol given over a specific time period. Motion Tween can alter many properties of a symbol like the size, transparency, angle, tint and many more. In this tutorial, we will teach you how to motion tween in Flash. First, let's do a basic animation using the concept motion tween in flash. Here we are going to move a circle through four corners of the stage. Step 1: Create a new Flash Project Follow this tutorial to learn how to motion tween in Flash. First of all, open Flash on your computer. Once you are there, create a new Flash project. Choose ActionScript 3.0 as the type. Step 2: Create a basic shape The project opens up a stage area. We will draw a circle with the help of the oval tool. We will place it in the upper left corner of the stage. Convert the circle into a symbol by right clicking on the circle and choosing "Convert to symbol" option in the context menu. Step 3: Create motion tween Next, go to the first frame of the timeline and right click on it. In the context menu, select the option titled "create motion tween". You can always perform the same action by using the menu: Insert / Timeline / Create motion tween. This is the start point of the animation. Step 4 : Setting up the end point for animation Right click on frame 15 and select 'Insert Keyframe' from the context menu. This acts as the end point of the animation. Step 5 : Create multiple intermediating points You don't have to restrict yourself when animating from point A to point B.You can always set up as many intermediate points as you want. Continuing the animation, let's add 3 more keyframes at 30, 45 and 60. Each time the position of the symbol is going to vary. The circle moves through the corner of the stage. To run the animation, go to Control/Play. The circle moves from one corner to another until it reaches the start point. This is a simple example of movement of a symbol. Motion tweening is not just about movement; it can mask, alter and resize any symbol.
How to install WampServer in Windows 7
 
02:12
Learn how to install wampserver in Windows 7. Wamp server is a web development platform on Windows Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Wamp server allows you to create web applications which are dynamic and interactive. It is a Window's based web platform used for developing web applications. In this tutorial, we will show you how to install wampserver in windows 7. Step 1 -- Go to wampserver.com Before we teach you how to install wampserver, you will have to download it first on your computer. Open up the browser and log on to "wampserver.com". Once the web page loads up, move down to the download section and choose the installation file according to the operating system that you are running. Since we are running a 32-bit operating system, we will choose "WAMPSERVER (32 BITS & PHP 5.3)2.2E". Step 2 -- Download installation file With that done, a notification window will open up. Over here, click on the "you can download it directly" option and the downloading will start automatically. Step 3 -- Open Wamp Server Installation Wizard Once the installer has been downloaded, double click on the file to run the installer. With that done, the wamp server installation wizard will open up. Click on the next button to proceed with the process. Step 4 -- Accept the license Over here, you will be required to accept with the license agreement and continue installing wampserver. Step 5 -- Set installation path Now you will be required to set the directory for the installation. Let the default settings remain and do not change the directory over here. Simply click on the next button to continue installing wampserver. In Next Screen, you can create a desktop icon and a quick launch icon for wamp server if you want to. To complete the installation process, simply click on the Install button. Step 6 -- Set the default browser During the installation, you will be asked for the default browser with wamp server. In this tutorial, the installation wizard automatically detected that firefox was our current default manager and whether we want to use it with the wamp server. Simply click on Yes to continue with the installation. Step 7 -- Set up the mail parameters In the next step you can set up the mail parameters. If you working on a test environment, leave the default settings as it is and move on to the next step. Step 8 -- Complete wamp server installation And the installation is now complete. Simply click on the finish button to exit from the window and launch wamp server. Step 9 -- Click on localhost Move to the notification area and click on the "Wamp" Icon to open up the server menu. Over there, click on the "localhost" option. Step 10 -- WampServer Configuration With that done, Firefox will open up and you will see the WampServer Configuration page open up. Scroll down the page and you will see the phpinfo tab, phpmyadmin, sqlbuddy and webgrind. Wamp server has now been successfully installed on your computer.
How to Convert Word to JPG Online
 
01:29
This tutorial will cover how to convert a Word document to a Jpg image. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to convert word to jpg online which is a good step to take if you want to make the document viewable by people who don't have Word. Step # 1 -- Saving the Word Document First of all you need to have a Word document which you want to convert. Save the document with a title you will remember. Step # 2 -- Uploading the File and Choosing Settings Start your preferred internet browser and visit the URL, "www.zamzar.com". You will see several steps on this site for converting your document. First, click the "Choose File" button and upload the document you just created. In "Step 2" choose "jpg" from the dropdown menu, then enter your email address and finally click on "Convert". Click "OK" in the dialog box that appears. Step # 3 -- Finding the Link in Your Email A new page will open that reads "File upload complete". Now you need to go to your email to find the finished file. Open the email from "Zamzar Conversions" and click on the link found under the blue box. Step # 4 -- Downloading and Viewing the jpg File This will take you back to the Zamzar site where you will have two download options, click the bottom "Download Now" button to download the jpg image of your Word doc. This is how to convert word to jpg online and to view the jpg file all you need to do is open it.
How to Make JavaScript Dropdown List
 
02:05
Follow this step by step guide to learn how to make a drop down menu and integrate it with a raw java script. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Drop down menus are nowadays integrated with functions which enhance the web usage. In this tutorial, we will learn how to make javascript dropdown list. Step 1 -- Enter the code for the List After the "body" and "html" tags, start with "form" tag. Give a title to the drop down menu. For the purpose of this tutorial, we want to make a drop down list from where people can choose their favorite sport. Next, open up the "select" tag and give it an id. Then give a function name for changing the list. For that, we have used the "on change" keyword and specified the function as favsports(). Just ignore the function for now as we will define its working later on. Once done with that, insert the different options for your drop down menu. Enclose these options between "option" tags. Once completed, close the select tag. Next, specify a narration for the output in the "p" tag. Choose the character type as text. For the purpose of this tutorial, we will name it as favorite and will specify its size as twenty. With that done, close the form tag. Step 2 -- Coding for the function Now open the script tag right above the body tag. Right beneath the script tag, we will begin with our function definition. In order to do so, specify your function name along with the function keyword, insert parenthesis and then start with the actual definition enclosed in curly brackets. In the function body, we will first explain the chosen element of menu. We are using a function of "get element by id" and specifying the element within the parameters from which we have to pick up the value, which is of course our javascript dropdown menu. It has already been named as mylist earlier. The next line is about displaying the selected option in a text box. For this purpose, we are using the "selected index" function and then passing the value to the text box, which we have named as favorite, with the "get element by id" method. Once you are done, close the script tag and then save the file as html document. Step 3 -- Open the file Now open up any browser and open the file that you just saved. The javascript dropdown list that you created will be available there. Simply choose any option from the dropdown list and it will appear in the text field right below. In this manner, you can create javascript dropdown list.
How to Create a Banner for Etsy
 
01:41
This tutorial shows you how to create a simple banner for your Etsy store. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to create banners for Etsy which is an essential step for giving your store a professional look. Step # 1 -- What is a Banner? The banner on Etsy is the custom image that appears at the top of a sellers shop. Here we have visited an Etsy shop and you can see the banner in place at the top of the page, this is what we are going to be creating in this tutorial. Step # 2 -- Creating the Banner You can create one of these however you wish, but in this example we are going to be using paint - open this program. Click the icon in the top left of the program and in the menu that appears click "Properties". In the window that appears enter a width of 760 and a height of 100 -- click "OK" and the canvas in the Paint window will resize to the correct dimensions for an Etsy banner. This is the space you have to be creative in -- design the banner however you wish. In this example we are just entering some basic text to demonstrate the creation of a banner. Step # 3 -- Uploading the Banner When done click the top left icon again go to "Save As" and click "JPEG Picture". In the window that appears give the picture a name you will remember and click "Save". Now, go back to Etsy and click the "Your Shop" link at the top of the page. Click the "Add shop banner" link that appears on the page that loads. Click "Choose File" then use the window to navigate to the image file we just created. Click "Open". Scroll down to the bottom of the page and click "Save Changes". You will be redirected to a page that lets you view your shop and you can see that the banner has been added successfully and that is how to create banners for Etsy.
How to Keep Wordpress Site Offline
 
01:10
This step by step tutorial will teach you how to keep WordPress site offline using a WordPress offline. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ We can put WordPress site offline by using a number of Plugins available. The Plugins can be installed using the "Built-in Install Plugin" option. When the Plugin is activated, the site becomes unavailable for a casual viewer. Some Plugins offer the exception that the site can be viewed by privileged viewers. Deactiving the Plugin swtiches back the site to online mode. In this tutorial on "how to keep wordpress site offline", we will be using a plugin "Maintenance" to keep our wordpress site offline.   Step 1 : Go to "Plugin" option In order to keep wordpress site offline, first of all, log in to your account and open the "Dashboard". You can see an option "Plugins" is available under the Dashboard panel located at the left side of the screen. Click on this option.   Step 2: Search Plugin When the plugins page has been opened, Click on the "Add new" button adjacent to the "Plugins" heading, at the top of the page. In the Search box provided, type "Maintenance" or "Site Unavailable" and click on the "Search" button. Step 3: Installing the Plugin A number of Plugins will appear on the page. Among them, choose the plugin "Maintenance" and click on the "Install" button, situated right beneath it's name. The Plugin will be installed within a short time.   Step 4: Activating the Plugin When the Plugin will be installed, an option will be provided for activating the plugin. Click on that button to activate the Plugin. You can later activate or deactivate the Plugin by going into the Plugin tab. Step 5: Verify The article has listed all the steps on "how to keep your wordpress site offline".The site is in the offline mode and clients cannot access the website. To verify this, open a new window in your browser and type in the URL of your website. The browser will say that the "website is unavailable".
How to Post Resume on Craigslist
 
01:54
This tutorial is going to show you how to post your resume on Craigslist. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial is going to show you how to post your resume on Craigslist which can be a great way to find a job.   Step # 1 -- Finding the City Where You Want to Post Your Resume Start by either creating a resume in Word or opening one that you already have. As you can see here we already have a resume open and this is the one we are going to be posting on Craigslist. Open your preferred internet browser and visit the website "www.craigslist.org". Scroll down the page until you find the city where you want to make your resume available, here we are going to the "Europe" section, then clicking "London". Step # 2 -- Entering Information for the Post On the London page, click the "post to classifieds" link in the top left of the page. On the next page click the "resume" option. In the "Posting Title" section enter something catchy to draw attention to your resume. Also enter a location where you want to work, if you are flexible, say so.   Step # 3 -- Pasting Your Resume Now, go back to the resume in Word and press "Control" and "A" and then "Control" and "C". Go back to Craigslist and click in the "Posting Description" area and press "Control" and "V". Enter your email address into the "Reply to" field twice and make sure that you delete it from any place it appears on your resume. Click "Continue" at the bottom of the page. Step # 4 -- Posting Your Resume You will then see a sample of your resume, read it to make sure there are no mistakes, then click "Publish" in the top right of the window. Now, open a new tab and go to your email inbox. Open the new email from Craigslist and click the link inside it, a new tab will open and you need to click "ACCPET the terms of use". You will then be told that the posting has been completed and you can simply follow the link on this page to see your posting live on Craigslist and that is how to post a resume on Craigslist.
How to Know Where a Photo Was Taken (View Exif Data)
 
01:23
This tutorial is going to how you how to find out where a photograph was taken. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to view exif data on a photograph which might allow you to see where the photograph was taken. It should be noted that currently only a limited number of high end camera record the gps location of a photograph. For this example we have a photograph taken on a Konica Minolta A2. Step # 1 -- Choosing the Image There are several programs that allow you to view exif data, but here we are going to use a website so we don't have to download a program. Go to the site "http://regex.info/exif.cgi" and you will see a very simple page load. Assuming that the photo is stored on your computer click "Choose File", find the image on your computer and click "Open". Step # 2 -- Uploading the Image Now click the "View Image from File" button and the image will start to upload. You can see the progress of this at the bottom of the screen -- this can take some time depending on the size of the image and the speed of your internet connection. Step # 3 -- Viewing the exif Data Once the upload has completed you will be taken to a page which will display the exif data. Much of this is interesting, but what we are interested in here is the "Location" field which tells us the exact location for where the photo was taken. If you don't see this field then the camera that took the photo did not record a gps location. If you click on the "Google" link, you will be taken to maps which will pinpoint the location for you. That is how to view exif data.
Transactions in SQL
 
02:06
Follow this tutorial to learn how to use Transactions in SQL and see how we can roll back to previous changes done in database. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ A transaction in SQL is basically the process of one or more changes being made in the database. In this tutorial we will learn the three basic controls of transactions in SQL which are COMMIT, ROLLBACK, and SAVEPOINT Step 1- Commit Command The Commit command is used to save the changes made in the database. To see its implementation, start by first beginning the transaction. Before starting any Transaction in SQL, we have to write the Begin Transaction statement. After that, write the actual action which is required, for example delete from the employee table, where the salary is greater than $2500. After that, write the Commit keyword which confirms that the query is logically correct and can be executed. The Query in this case would be: begin trandelete from EMP where SAL 2500 commit Now when we run the query, a message appears below the Query Editor which shows the number of rows that have been affected by our query. Step 2- Effect of Commit Command After that, fetch all the records from the employee table and it can be seen that all the records which have a salary above $2500 have been deleted. Step 3- Save Points Now let's examine the SAVE POINT command. To understand the concept, we will take an example of a departmental table. Start writing the query by beginning a transaction and then entering in the "Save Transaction" command followed by the transaction name. After that, let's delete a record with the Department number as 10 and then again save the transaction. This time, define the save point as point2. With that done, delete another department, and save the transaction, defining it as point3. Actual Query would be like this: begin tran save tran point1 delete from DEPT where DEPTNO=10 save tran point2 delete from DEPT where DEPTNO=20 save tran point3 After executing it, 2 rows would get affected. Step 4- Departments Deleted Now, see the department table to view the changes. For that, let's fetch all the records from the table. It can be seen that department "10" and "20" has been deleted from the table. Step 5- Roll Back If we want to track back to the previous changes, we can use the save points created earlier along with the Rollback transaction command. The rollback transaction allows us to remove all the modifications made to the data, either from the start of the transaction or to a defined save point. For that, we will use the rollback transaction statement and define the save point after that. Over here, let's roll back to point number 2. The Query would be: rollback tran point2 select * from DEPT Once we execute the query, and fetch all the records from the table, it can be seen that the table now contains the data up till point number 2 in the query. And this is how we can use Transactions in SQL.
Hide Wordpress Admin Bar for Subscribers and Users
 
01:20
Learn how to hide the wordpress admin bar for all users or certain specific users. We will teach you how to do so with the help of a plugin. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Admin Bar is present at the top of the wordpress site. This bar can be hidden for all the viewers or it can be disabled for certain users. In this article, we will teach you how to hide wordpress admin bar. Step 1 -- Open Dashboard In order to hide the wordpress admin bar, open up the dashboard and go to the plugins tab. Then click on the "add new" option. Step 2 -- Search for Desired Plugin Wordpress admin bar can be disabled easily with the help of a plugin. This plugin can also be configured for specific visitors. To download the plugin, type "Admin Bar Disabler" in the search field and then click on the Search Plugins button. Step 3 -- Install Plugin Several plugins would be displayed as a result .Click on the 'Install now' option for the "Admin Bar Disabler" in order to install it. Step 4 -- Plugin Activation The plugin files will be downloaded and installed automatically. After the installation has been completed, click on the Activate plugin option. Step 5 -- Open the newly Installed Plugin Now, we will configure the plugin that we just installed. In order to do so, go to the settings tab available in the dashboard and click on the Admin Bar Disabler option. Step 6 -- Plugin Configuration This will open up the configuration page of the plugin. We can configure the plugin to work for the viewers specified by us. It can either be configured for the Administrator, Editor, Author, Contributor or the Subscriber. For the purpose of this article, we will disable it for everyone. Click on the save changes button once done with the configuration. Now simply visit the site back to check whether the changes have been implemented or not. It would be noticed that the Admin Bar is no more visible. And this is how we can hide the wordpress admin bar.
How to Add a Print Button to HTML Page
 
01:29
Follow this step by step tutorial to learn how to add a print button in to html page. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ A print button on your web page will allow your visitors to quickly print the contents of the page. When the button is pressed, the browser's print dialog box will pop up. Then all the user has to do is choose his printer from the list, change the properties if he desires, and then click "OK" to print the web page. Step #1 -- Open index.html in editor Open index.html file in any html editor or notepad I use free online html editor. Step # 2 -- Write HTML code You can easily add a print button to your website by adding the onclick="window.print(); script to your anchor tag. Simply put, you're forcing the link you created to open up the browsers' default printer settings instead of opening up a new window or sending a user to a different page. (a title="Print Screen" alt="Print Screen" onclick="window.print();" target="_blank" style="cursor:pointer;" )PRINT BUTTON(/a) Step # 3 -- Submit you code Save the HTML file and upload it to your website. Click the print button to test it out. Step # 4 -- Click print button. That's it for this video on How to add a Print button to your website. .Now you have been successfully installed print button in you webpage.
How to Rotate and Moving Objects in Adobe Flash
 
01:05
This tutorial is about how to rotate moving objects in flash. Follow this tutorial in order to learn how. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Rotation in flash refers to giving additional effect to moving object in animation. Moving objects are produced using the motion tween. These moving objects can be rotated by altering simple properties of the motion tween. Follow this step by step guide in order to learn how to rotate in flash. Step 1: Create a new Flash Project In this tutorial, we will teach you on how to rotate in flash. Open Flash and create a new Flash project of type ActionScript 3.0. Step 2: Import an Image Import an image on to the stage and resize it to give enough space to rotate. Also convert the image to a symbol. Step 3: Go to Rotation Properties Create a Motion Tween. And extend the frame till Frame 60. Insert a KeyFrame at Frame 60. In the properties window, Notice the rotation tab. Type in 2 to rotate 2 times. You can also set the direction of rotation, as clock-wise or anti clock-wise. With Frame 60 selected, Move the image to the other corner of the screen. Note the path of motion is created automatically. Step 4: View output Now run the animation. Press CTRL+Enter to view it as a flash presentation. In the whole of the motion animation, the image rotates as mentioned. In this manner, you can perform rotation in flash.
How to Export Excel to Google Calendar
 
01:23
Learn how to export excel document to google calendar Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this video tutorial we will show you how to export excel to google calendar. In order to export an excel file to google calendar, open your Microsoft Excel document. Click "Office" button, go to "Save as" and choose "Other formats". Select "CSV" file type and press "Save". In the following window press "ok" to save only the active sheet. In the next warning window press "Yes" to keep this format. Open your web browser. Go to "calendar.google.com". Sign in with your email and password. Click on the "arrow" on the right and choose "Settings". On the following web page, choose "Import calendar". In the pop-up window, click "Browse". Select a CSV file from your hard drive. Press "Import". In the next window you will see message "Successfully imported one event". Now your excel data is exported to the google calendar.
How to Use Event Calendar Widget On Wordpress
 
01:33
This tutorial teachesyou how to add an event calendar widget on your wordpress to display the events registered by you. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial teaches you theuse of event calendar widget or wordpress event calendar on your website. Wordpress calendar widget is the calendar on your website that shows name, their location and the date of the Upcoming and past events registered on your page. Event calendar widgetis an alternate for default calendar used in WordPress which also has so many functions previously defined. In this tutorial you will learn how to add an event calendar to your list of active widgets, how to move widgets, how to see the events on the wordpress calendar widget and in the end you will also learn how to remove the widget from the page. Step 1: Opening Widgets Page First of all we are going to admin panel for adding widgets. On the left bottom you will find the appearance tab, click on widgets in the sub menu. Step 2: Adding Event Calendar Widget On the widgets page, find the Event calendar widget. Once your find it click add. Step 3: Setting Up Event Calendar Preferences In the widget admin add title to the widget and define position for it.This is the position of your calendar widget on the sidebar widget area. Step 4: Save widget Save the widget after selecting it from the dropdown list. Step 5: Checking Event Calendar after Publishing Check if your widget is published by going to your site. Refresh the page and you will see the event calendar on the sidebar widget area. You can also see the event details on the calendar by clicking on the marked day. This will open the event details. Here you can see the Event name, time, and venue. Step 6: Moving Widget position On the right side you will see the list of active widgets. Click on edit button. Step 7: Removing Event Calendar To remove a widget click on the edit on the Event calendar on the list of active widget displayed on the right side. Step 8:Delete Event Calendar Click on the delete button and this will delete the widget from your site.
How to Know RGB Color Code
 
01:21
This tutorial will show you how to find a RGB color code and convert it to a hexadecimal code. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you will learn how to know RGB color code from an image so it can be converted to a hexadecimal code. The only software you will need is Microsoft Paint and a web browser to convert the RGB code to HEX. Step # 1 -- Open the Image in MS Paint To get started, find an image that you want to take the color from and open it in "Microsoft Paint". Step # 2 --Selecting the Color Select the "Color Picker" option from the top and then click on part of the image that you want to get the color from. If it worked, the color from the image will now be set to "Color 1" in Paint. Step # 3 --Finding out the RBG Color Code Towards the top right of Paint you will see the "Edit Colors" button, click on it to find out the RGB color code from the image you selected. A smaller box will pop up with more information about the color you selected; you will see the "Red", "Green", and "Blue" values to the right. The numbers on the RGB code are in this same exact order. Step # 4 -- Converting the RBG Code to HEX for HTML/CSS Go to "http://easycalculation.com/rgb-coder.php" to convert the RGB code so it can be used in HTML. All you have to do is fill in the red, green and blue properties to find out the HEX color code. Now you understand how to know RBG color code to convert a color to HTML hexadecimal.
How to Connect DataBase in ASP.NET
 
01:23
Follow this step by step guide to connect a sql server database in asp.net Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial we will learn about connecting asp.net database, using ASP.net. ASP.net is contained on a .net framework, which is supported by many IDE's. Usually, Visual Studio is used and heard. Database connection needs to be maintained, in order to communicate and manipulate data effectively. It is fetched, inserted, and displayed on your display using the choice of language, or syntax allotted to it. Step # 1 -- Opening your IDE and Selecting ASP.Net First of all we'll need to open our IDE, In my case Visual Studio. Make sure you select the ASP.Net website template in the Visual C#. Step # 2 -- Configuring Data Source Connecting asp.net database is easy, first add a button from the toolbar and name it. Then drag and drop the sqldatasource option from the toolbox. Click on configure data source in order to get your connection string. Step # 3 -- Generating connection string Here we create a new connection by clicking on the button with the same name. Then we put the server name and select a database, I am going to use tempdb as my database. Now click on test connection in order to see if the database connection is established. Step # 4 --Copy connection string Copy the connection string from this window because we'll need it while configuring the button event handler in the code. Step # 5 --Connecting the database In the code, first of all add the sql client system class library. Then paste the connection string behind the event handler of our My connection button and finally in order to establish the connection we use the Open method.
How to Save a Web Page as a PDF
 
01:16
This tutorial will show you how to save a webpage as a PDF file Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to save a web page as a PDF without the use of an extension. This tutorial has been designed for users of Google Chrome -- the process for saving a website as a PDF may differ in other browsers. Step # 1 -- Opening the Print Window First, navigate to the page that you want to save as a PDF file -- here we are looking to save a news article on the CNN website. Now you need to press "Control" and "P" on the keyboard and the print window will appear. Step # 2 -- Saving the File You will then need to change the destination of the print job so click the "Change" button. Look under the "Local Destinations" area and click the "Save as PDF" option, the window will close and the destination will have changed. If you want you can then adjust any of the other settings that you might need to. Here we are just going to click the "Save" button at the top to complete the process. A window will appear and you need to select a destination for the file and click "Save". Step # 3 -- Viewing the PDF Now, to just confirm that the process has worked, navigate to the location on your computer where we just saved the file, locate the PDF and open it. As you can see here we have a PDF copy of the site and that is how to save a web page as a PDF.
How to Create an Online Survey in Gmail
 
01:58
In this tutorial you will learn how to create an online survey in Gmail. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Step 1. Open up a browser window. Go to docs.google.com. Log in with your credentials when required. Step 2. Click on Create. Choose Forms. Google greets you with some senseless templates as always  Choose one or discard them, and proceed to writing your survey. Step 3. Put the right title to your survey. Without a catchy title, users will not spend too much time on your page. Step 4: Ask the necessary questions. Choose the type of questions you want them to be: text, multiple selection, selection box, choose from a list, scale or grid. Add to your survey as many options as it needs. Step 5: Add other questions to the survey if you need them by clicking 'Add element'. Step 6: At the end of your writing, click "Finished" Step 7: You can even choose how your replies will be stored: at the top of your form Google allows you to 'Choose the destination of answers: a new spreadsheet or a new sheet into an existing one. You can opt for always creating a new spreadsheet. Step 8: Click on 'Send'. Google gives you the link for disseminating the form and also the shortcuts for doing it on Google+, Facebook and Twitter. If you know the email addresses of your recipients, you can add them in the text box along with a personal message to them. Result: You have now successfully created and disseminated your online survey.
How to Cancel eBay Commit to Buy
 
01:16
This tutorial will detail how to try and get out of a commitment to buy an item. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Once you have committed to buy an item on eBay you are contractually obliged to pay for it. To attempt to cancel eBay buy it now commitment you will have to contact the seller -- they have the discretion to let you off, but no obligation to. Step # 1 -- Contacting the Seller Go to eBay and make sure that you are logged into your account. At the top of the screen click the "My eBay" link and you will see a list of items you have purchased. Find the item that you have decided not to buy and click the "More actions" option to the right of it. In the menu that appears click "Contact seller". Step # 2 -- Contacting the Seller A page will load and you will see an option called "Request to change an order", click this checkbox. You will see an automated reply below stating that you are obliged to pay for the item -- this is correct, but we are still going to ask the seller to see if it is possible. Check the box next to "No, I want to contact the seller" and click "Continue". Step # 3 -- Asking Nicely for a Cancelation You will then be able to enter a message to the seller about canceling the purchase. Remember that they can force you to pay, so be nice and give a persuasive reason why you need to cancel the purchase. Click "Send" and you will now just have to wait for the seller to get back to you and that is how to cancel eBay buy it now commitment.
How to Create PHP Web Form
 
02:00
Follow this step by step easy guide to learn how to create a web form in php and add a java script function to it. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Almost every web contains a form nowadays. These forms basically function such that they submit the data entered in a separate file or a database in an organized and logical order. In this tutorial, we will teach you how a PHP web form can be created PHP web forms are similar to simple HTML forms; the only difference is that they use PHP script in the action method along with the transaction mode. We can use any editor for the code but for the purpose of this tutorial, we will be using notepad ++ as our code editor. Step 1 -- Form Fields To start with the PHP web form, we have to first specify the php script in the form action tag and then the data transaction mode. For the purpose of this tutorial, we have specified the script as "welcome.php" and the transaction mode is "post" as we have to submit the data. With that done, we created a name field, set its input type as text and assigned its logical name as "fname". Similar pattern was used for another field which goes by the name of age. Next, we will set the input type as submit. After that, we will close all the tags of form, body and html respectively. Once done with that, save the file as Html document and close it. Step 2 -- Defining the Script Functionality Now, we will create a new file for welcome.php. Start with html and body tags. After that, use the echo function with the "$_ post" function and specify fname in the argument. The "Welcome" string is just used for concatenation which will just insert a Welcome statement with the name which will be inserted in the name field. Repeat the same process for the age field. This time, however, use "You are" as text for concatenation. Once done with that, save the file, but this time choose "PHP" as the file type. Name the file as "welcome" because we have specified the same name in the previous HTML code where the form was being coded. Step 3 -- Enter the Values Now open up the Form.html file in the browser. There would be two fields of name and age. Test the form by inserting values in the fields and then click on the Submit button. A new page will open where the output would be printed. In this manner, we can create PHP web forms.
How to Disappear from the Internet
 
04:09
In this tutorial, you will learn how to disappear from Internet. If you have no reasons to become an Internet celebrity, YouTube star or scandalous politician, chances are you might be a bit annoyed by availability your data and info on Internet. In fact, you might want to disappear completely from Internet. That cab be done, if you follow our ultimate “self-eraser” plan!!! We’ll start with pre-requisites: searching yourself on Internet. Depending on your disappearing goals, you might use Google or the most popular search engine of your country. If you live in countries like Russia or China, Google search might not reflect the real picture:). Examine the results: if the size of the “catastrophe” is bearable, you will probably end up with social network results, forum post results, some public records from university, company or healthcare register and alike. So unless you’ve ended up with real bad PR campaign against you, you can handle the disappearing mission on your own. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Step 1: Delete or hide your social network accounts. LinkedIn, Facebook, Twitter and social networks alike all have the “Delete My Account” option. Sometimes it is hard to find, but possible to do. Be aware though that even after account deletion your data can hang on in the search results for couple of weeks or so. If you opt for making your account completely private instead, some basic information about you can still be searchable. NB! With some social networks like Google Plus deletion of your account may mean deletion of your precious email, which is unpleasant, but not impossible. Step 2. Delete or hide your ads, forum posts, dating profiles, etc. Were you posting something on local fitness or travel forum? Delete the post if it’s possible. Usually your nickname can be connected to your email account and linking your real identity with your avatar is easier than you think for other Internet users. Your old dating profile, which they claimed to be private, might be very well indexable by Google. Your house-selling ad can link to your data and even new living place, your post on diet forum can be searched by your new workmates. This list is endless. Delete any of this information, if you can. Step 3: Delete the third party forum posts or articles that mention you, if it’s possible. Let’s say you were involved in some event or club. If any online media or forum has the posts about it and the post was generated by a third party, your only chance to delete it is to write a nice letter to online media editor. If, however, a post about you done by a third party is extreme hate speech, has any erotic material or any false and harmful information that you can prove, you can legally insist on website administrators removing it. Step 4. Removing yourself from public directories. Your country’s directories (for instance, local business directory), usually should have an option for removing your data. Normally it is solved by contacting those websites directly and asking them to remove your data. So go ahead and do ask about being unlisted or having your company unlisted. Step 5. Unsubscribe from mailing lists. This is usually as easy as clicking the “Unsubscribe” link under the regular emails from mailing lists. Step 6. It’s all about emails. Delete your old email accounts. If you cannot do it, switch from well-known email providers to smaller ones or use one of the anonymous email services. Step 7: Search engine check-up. Now when you cleaned your traces, the search engines can still show the old results for some time. Wait for couple of weeks: if the old results are still there, your search engine should have the option of reporting them and asking for their removal. For instance, Google has the URL removal tool performing this function. Step 8: Now when you’ve removed your old traces, it’s important to not make any new ones. Be careful with what you do online. Have fun with being invisible!
How to Use Mouse Events in Adobe Flash
 
02:19
This tutorial is about mouse events in flash. We will show you how to create a mouse event in flash. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ This tutorial deals with the basics of mouse events in Flash. Buttons are the only objects available in flash which are interactive. They can detect the different events raised by a mouse. So we shall create a simple button and Implement ActionScript to record the events of the mouse. Step 1: Create a new Flash Project Open Flash and create a new Flash project. Choose ActionScript 3.0 as the type. Step 2: Go to properties Create a rectangle using the rectangle tool. Open the context menu for the shape and choose "Convert to symbol". Convert it to a button. In the properties tab, insert the instance name as 'button'. Step 3: Change mode to dynamic text Now let's create a dynamic text area to record the events raised by the text. Choose the 'Text' tool and create a space for text. In the properties tab, insert the instance name as 'output' and change the mode of the text to 'dynamic text'. Step 4: Add event listeners Now create a new layer to add the ActionScript to record the events. Open the actions window, while Layer 2 and Frame 1 are in selection. Here let's input the following code. First, EventListener should be added for each mouse event. Mouse events that we are recording are the basic four states: up, down, over and leave. There are other states that are not implemented in this example. Step 5: Add event handlers Next is the action that needs to be taken whne anyone of the activity occurs. This is done by adding the functionalities to the respective functions. The functions act as event handlers. Here we are going to dynamically add text to the text area depending on the mouse event. Thus the event handlers or the functions are mapped to their respective flash mouse event. So now if the movie is tested, the mouse events will be recorded and the events will be handled. To test the movie, Press CTRL+Enter. In this manner, you can work with mouse events in flash.
How to Set Up Java Classpath on Windows
 
01:27
Follow this step by step guide to learn how to set Java Classpath on windows through environmental variable. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Java Classpath is basically a path to the directory which is used by Java Class Loaders to find and load the appropriate class in Java Program. The procedure to set it varies from one operating system to another. In this article, we will teach you how to set java classpath on windows. Step 1 -- Open Advanced System Settings First of all, open the control panel and click on the "system and security" option. Once inside the system & security window, click on the "Advanced system settings" option there. Step 2 -- Click on the Environmental variables button As a result, the system properties window will open up. Over there, click on the Environment variables button. Step 3 -- Create a Classpath Now go to the system variables portion and click on the new button. A new window will appear where we can create a new system variable. Type "CLASS PATH" inside variable name field. For the variable value, we have to give the full path of the "JDK folder" on our system Once done with that, click on the OK button. Step 4 -- Check if classpath was configured correctly After that our variable would appear under the system variables portion. Now let us check whether we have configured our java classpath correctly or not. For that, open the command prompt, type "java" and hit enter. It would be noticed that the command prompt will recognize this command which means that windows has been integrated with the Java Classes Library through environmental variable. In this manner, you can set java classpath on windows.
How to Report Craigslist Scam
 
01:21
This tutorial will show you how to report a suspected scam on Craigslist. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Craigslist can be a great way to buy and sell online but as with any marketplace there are occasional scams. You must be very careful to avoid these and if you suspect something of being a scam it is best to report craigslist scam to the support team.   Step # 1 -- Flagging the Posting Itself The first method to report a scam is to go to the advert that you believe to be a scam. Visit your local Craigslist, here we are using "london.craigslist.co.uk", navigate to the right section and click on the advert. At the top you will see a section labeled "flag" and to report spam you should click the "prohibited" link. As this is just an example, we won't flag this posting as spam, but that is how to.   Step # 2 -- Reporting Scam Emails If you have gone further down the line and have now realized that you might be being scammed it can be a good idea to email any correspondence you have received to Craiglist support. Navigate to your email account, load the suspicious email and click the forward option. Write an explanation about the scam and send the email to "[email protected]", again, we won't actually send this mail now, but that is how to report a scam. Of course, if you have been the victim of a serious illegal scam you may want to report craigslist scam to the police.
How to Host Your Personal Website On Google’s Servers
 
04:48
If you wish to host your own personal website for free, you can host a basic website on Google’s servers for free. Google does not provide free hosting solutions, but they do provide a Platform As A Service known as “Google App Engine” (GAE). Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Step # 1 - Create your personal website First you’ll need to create your personal website. You can build a website if you have experience as a web designer or you can work on a web template and customize it. In this case we’ll download a template from this website: “www.freehtml5templates.com”. Just choose the one you like, click on the name and then click the “Download here” button. Step # 2 - Edit your personal website To customize it, you’ll need to unzip the files and edit the index.html or other .html files. You can use any text editor like “Notepad” or “WordPad” to edit these files. Add your information and save the file. Step # 3 - Download Python Now you'll need to download Python and GAE SDK. To download python type this web address: “www.python.org/download/releases/2.7.6/” and download the right installer according to your operating system. Then open the installer and follow the instructions to install the app. Step # 4 - Download Google App Engine SDK Then go to your browser once more and type this web address to download” Google App Engine: “developers.google.com/appengine/downloads” The link is quite long but it will take you directly to the downloader, as the website is complex. Download the version for your system. Run the installer and follow the instructions to install it. Step # 5 - Sign Up For Google App Engine Now, you'll need to sign up for an account at “Google App Engine”. If you already have a Gmail account, you just have to sign it. Open your browser and go to: “https://appengine.google.com/”. If you don’t have a gmail account press the “Create an account” link and enter required details to create an account. Step # 6 - Create an App at Google App Engine Now, you need to create an application on GAE. Click the “Create Application” button. You may be asked to verify your account. Enter the address you want in “Application Identifier”. This name will create your sub-domain address, for example: “your-name.appspot.com”. Keep in mind that, once given a name, the application identifier cannot make changes. Next enter “Application Title” in the second text field. This name will be displayed when people access your app on the GAE. For “Authentication Options”, leave it in the default option: “Open to all Google Account users”. Accept the terms and click on the “Create Application” button. You will see a page stating that the "Application Registered Successfully". Step # 7: Open Google App Engine Launcher Now you need to develop your GAE app on your system using Python and App Engine Python SDK. Open “Google App Engine Launcher” app on your system. Then Open “File” menu and go to “Create New Application”. Enter your application identifier in the field Application Name. Choose a local parent directory for your app by clicking on the “Browse” button. Your app’s directory will be created inside this directory. Leave the “Port” and “Admin Port” on default values. Click on the “Create” button. Step # 8: Edit your local GAE apps’s settings. To edit your local GAE app’s settings choose your app in GAE Launcher. Click on “Edit” and your app’s "app.yaml" file will open in WordPad. Replace “your-app-name-here” with your application identifier on the first line of this file. Then save it and close WordPad. Step # 9: Add your personal website’s file to your local GAE app To add your personal website’s files to your local GAE app open the local parent directory of your GAE app. Open your app’s directory. Delete the files named “favicon.ico” and “main.py”. Create a new folder named “www” inside this directory. Copy your website’s files to this “www” directory. Step # 10: Deploy your custom app to GAE Servers Now you need to check and deploy your app to GAE servers. To check your local GAE app you need to choose your app in GAE Launcher and click on “Run”. You will be shown your website in the web browser on your computer. To deploy your GAE app you need to choose your app in GAE Launcher. Click on “Deploy”. You will be asked for your gmail id and password. Enter your account’s credentials and press “OK”. You will see a Python window detailing the progress of the upload operation. It will take some time to upload your app depending on your Internet connection’s speed.
How to Update Flash Player in Windows
 
01:44
In this tutorial, we will teach you how to update Flash Player in Windows. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Learn how to update the flash player version on your computer by following this step by step guide. Follow this step by step guide to learn how to upgrade your flash player. Step 1 -- Open Control Panel First of all, go to the start button and from the start menu, click on the control panel option. Step 2 -- Open Flash Player Manager You will find flash player in the control panel if you have it installed on your computer. Simply click on it in order to open the flash player manager. Step 3 -- Player Download center option As a result, the adobe flash player web page will open up in your default browser. Once the web page loads, click on the player download center option. From here, you'd be able to download the flash player update for windows. Step 4 -- Download flash player In the next page, you will be displayed with your system information and details about the flash player. For the purpose of this tutorial, we will uncheck the optional McAfee Security scan as we just want to install the flash player. Once you are done, click on the download now button. In this manner, you will be able to download the flash player update for windows. Step 5 -- Run button A new web page will open where you can see the screenshots of the installation. A dialog box will appear on your screen. Click on the save file button to download the exe file. Once the download has finished, click open it. You might be given a security warning when opening the exe file. Click on the run button to proceed with the installation. Step 6 -- Choose an update option As a result, the Adobe Flash Player installer will open up. It will take a few moments to initialize. You can then choose one of the update options. For the purpose of this tutorial, we will select the "notify me to install updates" option. Once you are done selecting, click on the next button to continue further. As a result, the downloading will begin. You can monitor the progress of the download here. Once the download has completed, go to the control panel and open flash player from there. In the flash player settings manager, go to the advanced tab and you will be able to view the flash plug-in version that you just upgraded to. In this manner, you can update the Flash player in windows.
How to Create Zoom Effect in Adobe Flash
 
01:07
In this effect an image will get scaled up and again it will get scaled down thereby creating a zoom-in and a Zoom-out effect. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you will learn how to create a zoom effect. In this effect an image will get scaled up and again it will get scaled down thereby creating a zoom-in and a Zoom-out effect. We will do the zooming with the basic of Motion tweening in Flash. With the help of this tutorial, you will learn how to zoom in Flash on the prescribed frames. Step 1: Create a new Flash Project In this tutorial, we will teach you how to zoom in flash. Open Flash and create a new Flash project. Step 2: Import an Image Import an image on to the stage and resize it to give enough space to rotate. Also convert the image to a symbol. Place the image in the center of the stage. Step 3: Set transform properties Create a Motion Tween and extend the frame till Frame 60. Insert a KeyFrame at Frame 60 and Frame 30. With Frame 30 selected, transform the image. Resize the image to 300%. Similarly, select Frame 60 and set the size value to 100%. Up until Frame 30 the image Zooms in and is followed by zoom out in Flash till Frame 60. Now run the animation. Press the CTRL+Enter key to view it as a flash presentation. In the whole of the motion animation, the image zooms in and zooms out in Flash on the specified frames.
How to Insert Page Break via CSS
 
01:09
Follow this step by step easy tutorial to learn how to insert page breaks in web pages via CSS. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ Page breaks are used for printing purpose, as it can be set for the content to be printed in separated pages and in this tutorial we will learn to insert page break in CSS. Step 1 - Page - Break Code Structure First of all, write the content which is to be displayed on the first page. After that, open up the heading tag and use the break class. With that done, write the title of the heading which would be displayed on the second page. Then close the heading tag and type in the content for the next page after that. Having done that, open up the heading tag and in a similar way as before, add a page break over there. The code would be: contents on first page 'h1 class="break"' Heading Of Second Page'/h1' Contents On second Page 'h1 class="break"' Heading Of Third Page'/h1' Step 2 - Break Class Definition With that done, define what the break class would actually do. For that, we will move up and before the body tag, insert a style tag. Inside the style tag, we will specify the class properties. Over here, we will be inserting a page break before the element on the document, which will be defined with the break class. The CSS style code would be: 'style' .break {page-break-before:always; } '/style' The concept behind CSS page break before the attribute is that, it will first take the control to the new page and then display the content. After that, save the HTML document and open up the file in the browser. Step 3 - Print Preview With the page opened up, open its print preview and over there, see that wherever we have used the CSS page break class in the document, the content appears in a new page accordingly. And that's how we can insert page break in CSS.
How to Post a Job on Craigslist
 
02:00
In this tutorial you are going to learn how to post a job opening on Craigslist. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial you are going to learn how to post a job on Craigslist which can be a great way to fill an open position at your company.  Step # 1 -- Navigating to the Posting Area Craigslist works on a local basis so you will need to visit the site that is specifically for your local area. Here we are using the London Craigslist at "www.london.craigslist.co.uk". At the top left of the page click on the "post to classifieds" link. Step # 2 -- Choosing the Nature of the Job On the page that loads click on the "job offered" option. On the next page you will have to read and agree to some conditions, it is worth reading these through as jobs that do not meet these will be removed. If you want to continue click "I will abide by these guidelines". Now a list of job types will appear, click on the one that best suits the position that you are offering. Here we are offering an "Admin" job.   Step # 3 -- Entering Information About the Job You will now need to enter information about the job. Remember that the more information you offer about the job, the more chance you have of finding the right candidate. Give a detailed "Posting Title" and "Location". Enter the email address where applicants will have to send their details to. In the "Posting Description" area enter all of the information you have about the job, be detailed. In the "Compensation" area type how much the position pays. Finally check any boxes at the bottom that are relevant to your posting and click "Continue". Step # 4 -- Completing the Posting You will now be able to review the ad and if you are happy with it click "Continue". You will now need to confirm the posting so navigate to your email inbox and open the email from Craigslist. In the email click the confirmation link and you will be taken back to the Craigslist site. Click "ACCEPT the terms of use" and your advert will go live -- you can see it by clicking the link on this page and that is how to post a job on craigslist.
How to Start Apache from Command Line
 
01:36
Learn how to disable apache service. Furthermore, learn how to re-enable it with the help of command line by changing the httpd configuration file. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, we will guide you on how to start apache from command line. In this tutorial, we will teach you how to check whether the apache service is working or not. Furthermore, we will teach you how to work with apache in the command line, how to make changes to the httpd configuration file, etc. Step 1 -- type localhost Follow this detailed step by step guide in order to learn how to start apache from command line. First of all, open up the browser and in the address bar, type localhost before you hit the "enter" key. With that done, you will see "it works" being displayed on your screen. This means that the apache services are running. Step 2 -- Open Services.msc Now move on to the services window by opening up the run command, typing in services.msc and hitting the enter key. Step 3 -- Stop apache service With that done the services window will open up. Over there, let's stop the Apache service for now. Step 4 -- Check if apache is running Now let's go back to the browser and refresh the page. You will notice that this time, the localhost page doesn't open up. This means that the apache server has stopped. Step 5 -- Open command prompt Now let's open up the command prompt. With that done, let's go to the bin directory in the apache folder. Step 6 -- Locate httpd.exe Over there in the bin directory, you can see the httpd.exe file. Step 7 -- Resume service If we type httpd and hit the enter key, you will see that the service starts but prompts an error in the process. The error is displayed because the domain name used is not a qualified one. None the less, the service has started. Step 8 -- Open config file Now let's move to the configuration directory in the apache folder. Over there, let's open the httpd.conf file in the notepad. Step 9 -- Make changes to config file Over there, find the "localhost:80" text in the notepad and remove the hash from the beginning of that line. With that done, save the file and close the notepad. Step 10 -- Apache will start Now let's go back to the command prompt, type httpd once again and hit the enter key. With that done, you will see that the apache has started in command line without prompting any error. Step 11 -- Check if apache is working In the browser, let's refresh the page again and you will see this web page will open up. This means that you have successfully started the apache server from the command line.
How to Send Facebook Video to Youtube
 
01:35
This tutorial will show you how to send a facebook video to youtube. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ There is no quick way to send a Facebook video to YouTube. This tutorial will show you how to send facebook video to youtube by downloading and uploading the video.   Step # 1 -- Copying the URL of the Video In Facebook find the video that you want to share on YouTube, open it by clicking on the thumbnail image. A new frame will appear and the video will start to play, you need to copy the URL of the video from the address bar.   Step # 2 -- Downloading the Facebook Video Open a new tab and visit "www.downvids.net" and paste the copied URL into the white text box and click on the grey download button. The website will load the video for a moment and then it will appear below. Right click on the "Download this Video" button and click "Save link as...", name the video and save it to your computer.   Step # 3 -- Starting the Upload to YouTube Once the download has finished navigate to YouTube and make sure you are logged into your account. Click the "Upload" button and then the large upload icon in the center of the new page. Locate the video we just downloaded on the computer and click "Open" to start the upload.   Step # 4 -- Viewing the Video Enter some details about the video, such as a "Title" and "Description" and wait for the video to be uploaded and processed. To view this video click the "Video Manager" button at the top of the screen and on the new page that loads you should see the video, click on its thumbnail to view it. That is the rather complex procedure for learning how to send facebook video to youtube.
How to Import Blog from Wordpress to Blogger
 
02:07
This tutorial will show you how to move your blog from Wordpress to Blogger. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ There are many reasons why you might decide to move your blog to another platform. This tutorial will show you the steps for doing an import from Wordpress to Blogger. Step # 1 -- Navigating to the Export Option Start at your Wordpress site -- here you can see that we have a simple blog that we are going to move. Assuming that you are logged into your blog you will see a toolbar at the top with the name of your blog, here "Testing area". Hover your mouse over this area and click "Dashboard" in the menu that appears. On the new page locate the "Tools" tab on the left, mouse over it and in the options that appear click "Export". Step # 2 -- Converting the Wordpress Blog On the next page click the blue "Download Export File" button and wait for it to download to your machine. Now, open a new tab and visit the site "wordpress2blogger.appspot.com", on the page that loads click the "Choose file" button and locate the file we just downloaded from Wordpress on the computer and click "Open". Now, click the "Convert" button. The file will begin to download, if any security questions appear, allow the file to continue to download. Step # 3 -- Creating a Blog on Blogger Now we are going to need to import this file into our Blogger account, visit the site "www.blogger.com" and make sure that you are logged into your account. Click the "New Blog" button and enter a title and web address for the blog, click the "Create blog!" button. Wait for a moment while the blog is created. Step # 4 -- Importing the Blog In your new blog click on the "Settings" option in the menu on the left and click "Other" in the list that appears. On the right click on the "Import blog" link and in the window click "Choose File" and locate the "blogger-export.xml" file on your computer. Now, enter the CAPCHA code and click "Import Blog". Now click the "View Blog" option at the top of the page and you will be redirected to your new Blogger page that has all of the data that was in your previous blog and that is how to import from Wordpress to Blogger.
How to Use Sealed Classes and Methods in C#
 
01:20
This tutorial is about how to create use sealed classes and methods in C#. You can restrict your class from being extended by using the 'sealed' keyword. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ There will be times when you don't need your class to be inherited by another class. You can restrict your class from being extended by using the 'sealed' keyword. The syntax is: sealed class classname { //statements } No class can be derived from a sealed class in C#. A sealed class cannot be declared abstract as well. Similarly, a method can also be sealed to prevent it from overriding. Only methods with 'override' keyword can be sealed. When an override method is sealed, the base method is successfully overriden while this method cannot be overriden further. Structs and properties can also be sealed. Structs are implicitly sealed and are not inherited. Step 1: Implementation -- Sealed class The preceding code is an example of a sealed class in C#. When the sealed class Final is inherited by the class program, it results in an error. A sealed class cannot be inherited but the members of the sealed class can be accessed by instantiating the sealed class. Thus a sealed class is similar to any other class without inheritance. Step 2 -- Implementation -- Sealed methods The usuage of a sealed method in C# is similar to any method. Note that a sealed method must be only used to override a method in the base class while the sealed method cannot be overriden by methods of another class. When a sealed class is overriden by the inherited class, it results in error. The class Third inherits from the class Second and the Method() is succesfully overriden and sealed. When this sealed Method() is overriden in the derived class Fourth, the compiler forces an error. Thus the main advantage of using the sealed classes and sealed methods in C# is to take away the inheritance and define the boundary for the usage.