In Feburary 2016 27,
Start a new account with the web hosting service of your choice, but do not close your account with your current host. Otherwise, you risk permanently losing your website and email information.
Make a note of every email account hosted on your website. Write down each email address–and password if you want to keep them the same–or type them in a file and save the file. Keep this information private so that no one can access your email accounts without your permission.
Back up your website. Access the backup tool on your user panel with your current hosting service and select the options necessary to do a complete site backup, rather than any kind of partial backup. Save the resulting file on your computer.
Access the backup tool on your user panel with your new hosting service. Select the option to upload a complete site backup. Find your site backup, upload it and select the option to complete the backup upload process.
Create all the same email accounts you have on your current server on your new server. Use the passwords you saved in step 1 if you wish to keep them the same, or make up new passwords if you prefer. Be sure to use passwords that you will remember but that would be difficult for someone else to guess.
Close your account with your current hosting service.
In Feburary 2016 27,
Showing posts with label Write. Show all posts
Showing posts with label Write. Show all posts
Saturday, 27 February 2016
Wednesday, 24 February 2016
How to Check a String to See if the Value Is Numeric in SQLIn Feburary 2016 24,
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Run your database, and open your usual textual SQL query generator.
Write a query that includes the value you want to check. Using SQL, you can check a field's value by using a regular expression. For example,SELECT DISTINCT my_data FROM my_tableWHERE my_data REGEXP ('[0-9]');Substitute the value 'my_data' with your field name and 'my_table' with your table name. Construct your query using the above as an example of how to determine whether a field is numeric or not.
Execute your query on some test data first. Check that the output matches what you expect to happen before using the query on live data.
In Feburary 2016 24,
Sunday, 21 February 2016
How to Connect FileZilla With an iPhoneIn Feburary 2016 21,
In Feburary 2016 21,
Tap 'Settings' on your iPhone's homescreen, then tap 'Wi-Fi.' Select your current Wi-Fi network. Tap the blue arrow to display the advanced settings menu. This will display your iPhone's IP address. Write down the IP address.
Launch Filezilla on your computer. Type the IP address from step one into the 'Host' field near the top of the Filezilla window. Type in 'root' as the username (this is case sensitive, so do not use capital letters). By default, the iPhone's root password is 'alpine.' If you changed your iPhone's password after jailbreaking it, enter your personalized password instead. Click the 'Quickconnect' button. The status window directly below these text fields will let you know when a connection has been established.
Expand the directories within the 'Local Site' (your computer) and 'Remote site' (your iPhone) panels. Click and drag files from one directory to another in order to transfer them.
In Feburary 2016 21,
Tap 'Settings' on your iPhone's homescreen, then tap 'Wi-Fi.' Select your current Wi-Fi network. Tap the blue arrow to display the advanced settings menu. This will display your iPhone's IP address. Write down the IP address.
Launch Filezilla on your computer. Type the IP address from step one into the 'Host' field near the top of the Filezilla window. Type in 'root' as the username (this is case sensitive, so do not use capital letters). By default, the iPhone's root password is 'alpine.' If you changed your iPhone's password after jailbreaking it, enter your personalized password instead. Click the 'Quickconnect' button. The status window directly below these text fields will let you know when a connection has been established.
Expand the directories within the 'Local Site' (your computer) and 'Remote site' (your iPhone) panels. Click and drag files from one directory to another in order to transfer them.
In Feburary 2016 21,
Saturday, 20 February 2016
SQL Scripting TutorialIn Feburary 2016 20,
In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,
Open up the database program of your choice. This could be Microsoft Access, SQL Server, or Oracle. Create a few sample fields, such as First Name, Last Name, Address, City, State, and Zip. Then add a few sample records to test on.
Write your first query by typing out 'SELECT
FROM table_name' where table_name is the name of the table you created. This example returns every value from every field in the table within your database (the
indicates all). You can also say 'SELECT field_name FROM table_name' to select only the field_name field from your table.
Add to your last statement with the WHERE clause. The WHERE clause specifies which fields you want to return based on a certain value. 'SELECT * FROM table_name WHERE last_name = 'Morgan' ' will search for 'Morgan' in the last_name field and returns all records from the table in which the person's last name is Morgan. Note that if you are searching for a string (letters or words), you will need single quotes around the name. If you are searching for a number, you don't need the quotes.
Add to your last statement once again by using the ORDER BY clause. 'SELECT
FROM table_name ORDER BY last_name' will order your recordset by the person's last name in alphabetical order. You can also do 'SELECT
FROM table_name ORDER BY age' and it will order by the person's age (add DESC after the field name you wish to order by to list the names in descending order).
Create a new query by typing the INSERT INTO statement. The INSERT INTO statement inserts a new row into the table that you specify. 'INSERT INTO table_name VALUES ('Courtney','Morgan',14)' will add the first name of Courtney, the last name of Morgan, and the age of 14 into your table. Likewise, if you want to delete someone from your table, you will use the DELETE statement. 'DELETE FROM table_name WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will delete Courtney Morgan from your table.
Create another new query. Use the UPDATE statement. This will update a record instead of adding or deleting one. 'UPDATE table_name SET address = '555 Hollywood Blvd', city = 'Los Angeles' WHERE last_name = 'Morgan' AND first_name = 'Courtney' ' will update Courtney Morgan's address to 555 Hollywood Blvd and her city to Los Angeles.
In Feburary 2016 20,
Thursday, 18 February 2016
How to Get TD Class Value in JqueryIn Feburary 2016 18,
In Feburary 2016 18,
Open the Web page in Notepad or a code editor, and look for the jQuery library file. If your code contains no reference to this file, add this code:Place this reference between the '
' tags of your Web page code or just above the closing '
' tag.
Add a pair of 'Write all jQuery code between the '
' tags.
Write a function to check for when the document finishes loading. This is also known as the 'document ready' function:$(function () {});The above code is short-hand for '$(document).ready()'.
Declare an array type variable that will hold the class values of your '' tags:var tdValue = [];Add this code between the curly braces of the 'document ready' function.
Iterate through each instance of '' in the Web page code by creating an 'each()' loop:$('td').each(function(i) {});This code goes after the array declaration. Note that 'each()' attaches to the 'td' selector, and a variable 'i' is passed as a parameter in the function. You need the 'i' variable to get values from the array.
Set your array equal to the results of the 'attr()' function inside the 'each()' loop:tdValue[i] = $(this).attr('class');The 'this' selector gets the parent selector, in this case 'td' from the selector in the line of code above it. Use 'class' inside 'attr()' to get the value of the class attribute for each '' tag.
Output the class name for each '' tag as text in each table cell by adding this line of code after the line containing your 'attr()' function:$(this).text(tdValue[i]);The finished script should look like this:$(function() {var tdValue = [];$('td').each(function(i) {
tdValue[i] = $(this).attr('class');$(this).text(tdValue[i]);
});});
In Feburary 2016 18,
Open the Web page in Notepad or a code editor, and look for the jQuery library file. If your code contains no reference to this file, add this code:Place this reference between the '
' tags of your Web page code or just above the closing '
' tag.
Add a pair of 'Write all jQuery code between the '
' tags.
Write a function to check for when the document finishes loading. This is also known as the 'document ready' function:$(function () {});The above code is short-hand for '$(document).ready()'.
Declare an array type variable that will hold the class values of your '' tags:var tdValue = [];Add this code between the curly braces of the 'document ready' function.
Iterate through each instance of '' in the Web page code by creating an 'each()' loop:$('td').each(function(i) {});This code goes after the array declaration. Note that 'each()' attaches to the 'td' selector, and a variable 'i' is passed as a parameter in the function. You need the 'i' variable to get values from the array.
Set your array equal to the results of the 'attr()' function inside the 'each()' loop:tdValue[i] = $(this).attr('class');The 'this' selector gets the parent selector, in this case 'td' from the selector in the line of code above it. Use 'class' inside 'attr()' to get the value of the class attribute for each '' tag.
Output the class name for each '' tag as text in each table cell by adding this line of code after the line containing your 'attr()' function:$(this).text(tdValue[i]);The finished script should look like this:$(function() {var tdValue = [];$('td').each(function(i) {
tdValue[i] = $(this).attr('class');$(this).text(tdValue[i]);
});});
In Feburary 2016 18,
Saturday, 13 February 2016
How Do I Offer a Giveaway on My Blog?In Feburary 2016 13,
In Feburary 2016 13,
Giveaways differ in the way winners are chosen and in the laws by which they are governed. A prize giveaway where winners are chosen at random is known as a “sweepstakes,” the most common type of blog giveaway. In a “contest,” winners are chosen based on some skill or merit. In a “lottery,” an entrant must pay for a chance to win. Before beginning your giveaway, read up on the laws to ensure compliance.
Prize Selection
For your promotion to perform well, your prize should be aligned to your blog audience and be something people really want. Buy the item yourself or team up with a company to provide the prize. Register your blog at Giveaway.ly, for example, and you can accept offers from advertisers interested in co-hosting promotions. You can also make money from the giveaway by charging the sponsor a small fee.
Set-up and Management
Write a post announcing your giveaway. Include prize details, entry requirements, eligibility information, giveaway dates, how the winner will be chosen and how the prize is to be claimed. Customize your entry form using sites such as Giveaway.ly, Rafflecopter, PunchTab and Giveaway Tools. Each one provides an embeddable widget that automates the entire giveaway process, from collecting entries and site statistics to choosing and announcing a winner. Entry options can be as simple as leaving a comment on a post. You can also give entrants the option for “bonus” entries by having them like a sponsor’s Facebook page or subscribe to a newsletter. In addition, it’s a good idea to set up an email so that entrants can inform you of any technical issues they encounter or questions they have.
Promotion and Conclusion
Remind people about the giveaway often through social media, starting with your own and friends’ networks. Ask your sponsor to help spread the word. In addition, tap into your blog community. Bloggers in similar niches often like to run giveaway “linkys” where you can post the link to your giveaway. When the sweepstakes period ends, the giveaway widget picks the winner. Notify the winner and make an announcement on your blog. The sponsor is typically responsible for shipping the prize within a certain period of time and paying all shipping costs.
Sponsor Follow-Up
Let sponsors know the outcome of the giveaway by providing key site statistics, such as how many visitors you received and other information collected by the giveaway widget. Thank the sponsor for participating in the giveaway and forward the winner’s name and contact information. This builds good relationships with sponsors and creates a potential for future opportunities when they see the value in working with you.
In Feburary 2016 13,
Giveaways differ in the way winners are chosen and in the laws by which they are governed. A prize giveaway where winners are chosen at random is known as a “sweepstakes,” the most common type of blog giveaway. In a “contest,” winners are chosen based on some skill or merit. In a “lottery,” an entrant must pay for a chance to win. Before beginning your giveaway, read up on the laws to ensure compliance.
Prize Selection
For your promotion to perform well, your prize should be aligned to your blog audience and be something people really want. Buy the item yourself or team up with a company to provide the prize. Register your blog at Giveaway.ly, for example, and you can accept offers from advertisers interested in co-hosting promotions. You can also make money from the giveaway by charging the sponsor a small fee.
Set-up and Management
Write a post announcing your giveaway. Include prize details, entry requirements, eligibility information, giveaway dates, how the winner will be chosen and how the prize is to be claimed. Customize your entry form using sites such as Giveaway.ly, Rafflecopter, PunchTab and Giveaway Tools. Each one provides an embeddable widget that automates the entire giveaway process, from collecting entries and site statistics to choosing and announcing a winner. Entry options can be as simple as leaving a comment on a post. You can also give entrants the option for “bonus” entries by having them like a sponsor’s Facebook page or subscribe to a newsletter. In addition, it’s a good idea to set up an email so that entrants can inform you of any technical issues they encounter or questions they have.
Promotion and Conclusion
Remind people about the giveaway often through social media, starting with your own and friends’ networks. Ask your sponsor to help spread the word. In addition, tap into your blog community. Bloggers in similar niches often like to run giveaway “linkys” where you can post the link to your giveaway. When the sweepstakes period ends, the giveaway widget picks the winner. Notify the winner and make an announcement on your blog. The sponsor is typically responsible for shipping the prize within a certain period of time and paying all shipping costs.
Sponsor Follow-Up
Let sponsors know the outcome of the giveaway by providing key site statistics, such as how many visitors you received and other information collected by the giveaway widget. Thank the sponsor for participating in the giveaway and forward the winner’s name and contact information. This builds good relationships with sponsors and creates a potential for future opportunities when they see the value in working with you.
In Feburary 2016 13,
Friday, 12 February 2016
How to Word Italian Dinner Party InvitationsIn Feburary 2016 12,
In Feburary 2016 12,
Decide on whether you want to purchase store-bought invitations, make your own or simply send an email invitation to your guests. Email is acceptable if the evening will be casual, but paper invitations are preferred for fancy affairs.
Pick an invitation design that reflects Italian culture. Images that show bottles of wine, garlic, olives or bowls of pasta let your guests know the kind of food you will serve.
Write a headline on your invitation. Use Italian words or phrases so that your guests immediately know the dinner party will focus on Italian food. Some examples are: “Join Us In Our Cucina,” “Buon Appetito,“ 'Mangia! Mangia!' and “A Taste of Italy.”
Write a brief introduction. Something as simple as 'We invite you to share an authentic Italian dinner with us' will make the theme clear to your guests. You may want to choose more casual wording for a relaxing evening. An example is, 'Mamma mia! We're cooking up some fun.' Be creative and make sure your words match the tone of your party.
Include the party details. Give out your name (or the host's name if it is someone else), the address where you’ll host the party, your telephone number and your email address. Remember to include an RSVP date if you need a head count before the day of the party. The RSVP date should be three to four days before the date of the dinner party.
Ask each guest to bring something different. Dinner guests inevitably want to bring something, so feel free to specify what you need. For example, ask different guests to bring bread, wine, an appetizer or a dessert. Encourage them to be inspired by Italian cuisine.
Include directions or a map if your guests are not familiar with the dinner party location.
Stuff the invitations into envelopes, address them and add a stamp.
Mail the dinner party invitations two weeks before the event.
In Feburary 2016 12,
Decide on whether you want to purchase store-bought invitations, make your own or simply send an email invitation to your guests. Email is acceptable if the evening will be casual, but paper invitations are preferred for fancy affairs.
Pick an invitation design that reflects Italian culture. Images that show bottles of wine, garlic, olives or bowls of pasta let your guests know the kind of food you will serve.
Write a headline on your invitation. Use Italian words or phrases so that your guests immediately know the dinner party will focus on Italian food. Some examples are: “Join Us In Our Cucina,” “Buon Appetito,“ 'Mangia! Mangia!' and “A Taste of Italy.”
Write a brief introduction. Something as simple as 'We invite you to share an authentic Italian dinner with us' will make the theme clear to your guests. You may want to choose more casual wording for a relaxing evening. An example is, 'Mamma mia! We're cooking up some fun.' Be creative and make sure your words match the tone of your party.
Include the party details. Give out your name (or the host's name if it is someone else), the address where you’ll host the party, your telephone number and your email address. Remember to include an RSVP date if you need a head count before the day of the party. The RSVP date should be three to four days before the date of the dinner party.
Ask each guest to bring something different. Dinner guests inevitably want to bring something, so feel free to specify what you need. For example, ask different guests to bring bread, wine, an appetizer or a dessert. Encourage them to be inspired by Italian cuisine.
Include directions or a map if your guests are not familiar with the dinner party location.
Stuff the invitations into envelopes, address them and add a stamp.
Mail the dinner party invitations two weeks before the event.
In Feburary 2016 12,
Thursday, 4 February 2016
How Do I Change My Linksys NAT Settings?In Feburary 2016 04,
In Feburary 2016 04,
Locate the IP address of the computer that you want to change the NAT settings for. Go to 'Start --> Run.' In the run window, type in the command 'cmd.exe'. This will open up a command window. Type 'ipconfig' at the command line. When you see the line 'IP V4 address,' write down the numbers that follow. They will be in the form of four numbers separated by dots, like so: 192.168.1.4. Write this number down.
Open up a web browser and type in the following address 'http://192.168.1.1'. You will be prompted for your Netgear's admin login and password. If you haven't changed the default settings, login with the username 'admin' and password 'password' (no quotes).
Scroll odwn to the bottom of the administration menu. Look on the left-hand side of the screen, underneath the 'Advanced' section. Click the button marked 'Port Forwarding.'
Select the protocol that you want to change the NAT settings for, either 'HTTP' (for web services, such as a proxy server) or 'FTP' (for FTP servers).
Type the IP address of the computer that you looked up in Step 1 in the 'Server' box. In the drop-down menu, select the 'TCP/UDP' option. Click the 'Apply' button.
In Feburary 2016 04,
Locate the IP address of the computer that you want to change the NAT settings for. Go to 'Start --> Run.' In the run window, type in the command 'cmd.exe'. This will open up a command window. Type 'ipconfig' at the command line. When you see the line 'IP V4 address,' write down the numbers that follow. They will be in the form of four numbers separated by dots, like so: 192.168.1.4. Write this number down.
Open up a web browser and type in the following address 'http://192.168.1.1'. You will be prompted for your Netgear's admin login and password. If you haven't changed the default settings, login with the username 'admin' and password 'password' (no quotes).
Scroll odwn to the bottom of the administration menu. Look on the left-hand side of the screen, underneath the 'Advanced' section. Click the button marked 'Port Forwarding.'
Select the protocol that you want to change the NAT settings for, either 'HTTP' (for web services, such as a proxy server) or 'FTP' (for FTP servers).
Type the IP address of the computer that you looked up in Step 1 in the 'Server' box. In the drop-down menu, select the 'TCP/UDP' option. Click the 'Apply' button.
In Feburary 2016 04,
Wednesday, 3 February 2016
How Do I Play a PHP File?In Feburary 2016 03,
In Feburary 2016 03,
Adobe Dreamweaver is a web-designing program that is very effective in reading and playing PHP files. Dreamweaver is one of the most popular web design programs in the world and it can be used to create, edit, and delete various web programs and files that create a web page. Dreamweaver MX can be used to write and create PHP applications and can open and read pre-existing applications. Just open the file you need to look at and Dreamweaver will read it and convert it into a legible format so you can read the code.
Web Browser
If you are simply trying to view the end result of the PHP programming and not actually edit it, any web browser should be able to open and play the PHP files so long as there are no errors in the programming. If the PHP scripts have errors in them, the browser will likely not play the file or show an error message. Otherwise, the browser will open the PHP files as the web server converts it into an HTML coding that the browser can read. Just go to the website that has the PHP files in question and the browser should open it. If the file is actually on your computer, use a browser to open it and you may still be able to see it, depending on the browser.
In Feburary 2016 03,
Adobe Dreamweaver is a web-designing program that is very effective in reading and playing PHP files. Dreamweaver is one of the most popular web design programs in the world and it can be used to create, edit, and delete various web programs and files that create a web page. Dreamweaver MX can be used to write and create PHP applications and can open and read pre-existing applications. Just open the file you need to look at and Dreamweaver will read it and convert it into a legible format so you can read the code.
Web Browser
If you are simply trying to view the end result of the PHP programming and not actually edit it, any web browser should be able to open and play the PHP files so long as there are no errors in the programming. If the PHP scripts have errors in them, the browser will likely not play the file or show an error message. Otherwise, the browser will open the PHP files as the web server converts it into an HTML coding that the browser can read. Just go to the website that has the PHP files in question and the browser should open it. If the file is actually on your computer, use a browser to open it and you may still be able to see it, depending on the browser.
In Feburary 2016 03,
Subscribe to:
Comments (Atom)