In Feburary 2016 30,
Log in into your iPage account. Click on the 'Scripting and Add-Ons' hyperlink in your iPage control panel, and then click on the 'CGI and Scripted Language Support' link.
Click on the 'PHP Scripting' hyperlink in the CGI and Scripted Language Support menu. Set your PHP.INI file's version type. Select either 'PHP4' or 'PHP5' from the menu box in beneath the 'Select Default PHP Version' heading. Click 'Set.'
Edit the values next to each directive you'd like to alter in the PHP.INI file. For example, you'd set your maximum post data and upload size by editing the values next to the 'post_max_size=' and 'upload_max_filesize=' field.
Click on the 'Save' button to store your changes to the PHP.INI file.
In Feburary 2016 30,
Showing posts with label Select. Show all posts
Showing posts with label Select. Show all posts
Tuesday, 1 March 2016
Monday, 29 February 2016
How to Configure DNS 323 With a MacIn Feburary 2016 29,
In Feburary 2016 29,
Make sure the D-Link DNS 323 is powered on and connected to your local network with an ethernet cable.
Click on the 'Finder' icon in the Dock at the bottom of your Mac's screen.
Open the 'Go' menu at the top of the desktop and select the 'Connect to Server' option.
Type 'smb://' followed by the hostname or IP address of your DNS 323 device in the 'Server address' field.
Press the plus button next to the 'Server address' field if you plan to connect to your DNS 323 often. This will add the device's address to the saved list below.
Click on the 'Connect' button at the bottom of the window to initiate a connection to the DNS 323. Once the Mac establishes a connection, a new Finder window will open displaying the files on your DNS 323.
In Feburary 2016 29,
Make sure the D-Link DNS 323 is powered on and connected to your local network with an ethernet cable.
Click on the 'Finder' icon in the Dock at the bottom of your Mac's screen.
Open the 'Go' menu at the top of the desktop and select the 'Connect to Server' option.
Type 'smb://' followed by the hostname or IP address of your DNS 323 device in the 'Server address' field.
Press the plus button next to the 'Server address' field if you plan to connect to your DNS 323 often. This will add the device's address to the saved list below.
Click on the 'Connect' button at the bottom of the window to initiate a connection to the DNS 323. Once the Mac establishes a connection, a new Finder window will open displaying the files on your DNS 323.
In Feburary 2016 29,
How to Use Filezilla With 000WebhostIn Feburary 2016 29,
In Feburary 2016 29,
Log in to your 000Webhost control panel.
Scroll down and locate the 'Files' module.
Click the 'View FTP Details' icon to obtain the login details you will need to begin uploading your files via FTP.
Connect Filezilla to 000Webhost
Open Filezilla to begin the FTP process.
Select 'File' from the menu bar and click the 'Site Manager' option.
Click the 'New Site' button and name your website. Press 'Enter' to save the name change.
Copy and paste the 'FTP host name' from 000Webhost into the 'Host' field in Filezilla. This field is located underneath the 'General' tab.
Type '21' into the 'Port' field.
Locate the 'Logon Type' option and select 'Normal' from the drop-down menu.
Delete the 'anonymous' text within the 'User' field and copy and paste your 'FTP user name' from 000Webhost.
Delete the default characters within the 'Password' field and type your 'FTP password' into this field.
Click the 'Advanced' tab.
Locate the 'Default remote directory' text area and type:/public_html
Click the 'Connect' button to initiate the FTP authentication process.
Begin uploading your website files upon successful connection.
In Feburary 2016 29,
Log in to your 000Webhost control panel.
Scroll down and locate the 'Files' module.
Click the 'View FTP Details' icon to obtain the login details you will need to begin uploading your files via FTP.
Connect Filezilla to 000Webhost
Open Filezilla to begin the FTP process.
Select 'File' from the menu bar and click the 'Site Manager' option.
Click the 'New Site' button and name your website. Press 'Enter' to save the name change.
Copy and paste the 'FTP host name' from 000Webhost into the 'Host' field in Filezilla. This field is located underneath the 'General' tab.
Type '21' into the 'Port' field.
Locate the 'Logon Type' option and select 'Normal' from the drop-down menu.
Delete the 'anonymous' text within the 'User' field and copy and paste your 'FTP user name' from 000Webhost.
Delete the default characters within the 'Password' field and type your 'FTP password' into this field.
Click the 'Advanced' tab.
Locate the 'Default remote directory' text area and type:/public_html
Click the 'Connect' button to initiate the FTP authentication process.
Begin uploading your website files upon successful connection.
In Feburary 2016 29,
How to Enable FTP Traffic in the Windows FirewallIn Feburary 2016 29,
In Feburary 2016 29,
Type 'Control Panel' at the Start screen and click it to open it.
Click on 'Windows Firewall' to open the application.
Click on 'Advanced Settings' in the left side menu.
Click on the 'Inbound Rules' tab in the left menu in the new window. Select 'New Rule' under Actions in the right of the window.
Select 'Port' as the rule type in the New Inbound Rule Wizard window. Click on the 'Next' button.
Check the toggle switches next to 'TCP' and 'Specific Local Ports' in the Protocol and Ports step of the wizard. In the text field next to Specific Local Ports, type in '20, 21.' Click on the 'Next' button.
Select 'Allow the Connection' in the next screen. Click on the 'Next' button.
Select your network configuration from the three options. If you're unsure of which describes your computer connection, you can check all three: Domain, Private and Public. Click on the 'Next' button.
Type in a name and description for the new rule. This step lets you identify the rule more easily if you ever want to go back into Windows Firewall settings to disable it.
Click on the 'Finish' button to apply the new rule and enable FTP traffic on your computer.
In Feburary 2016 29,
Type 'Control Panel' at the Start screen and click it to open it.
Click on 'Windows Firewall' to open the application.
Click on 'Advanced Settings' in the left side menu.
Click on the 'Inbound Rules' tab in the left menu in the new window. Select 'New Rule' under Actions in the right of the window.
Select 'Port' as the rule type in the New Inbound Rule Wizard window. Click on the 'Next' button.
Check the toggle switches next to 'TCP' and 'Specific Local Ports' in the Protocol and Ports step of the wizard. In the text field next to Specific Local Ports, type in '20, 21.' Click on the 'Next' button.
Select 'Allow the Connection' in the next screen. Click on the 'Next' button.
Select your network configuration from the three options. If you're unsure of which describes your computer connection, you can check all three: Domain, Private and Public. Click on the 'Next' button.
Type in a name and description for the new rule. This step lets you identify the rule more easily if you ever want to go back into Windows Firewall settings to disable it.
Click on the 'Finish' button to apply the new rule and enable FTP traffic on your computer.
In Feburary 2016 29,
Sunday, 28 February 2016
How to Sync a Phone With a Car BluetoothIn Feburary 2016 28,
In Feburary 2016 28,
Turn on the stereo in the car and your cell phone.
Press the Bluetooth pairing button on the car stereo to enable the discoverable mode.
Go to the main menu selection for your phone.
Select the 'Settings' option to view the options that are available.
Select the option for 'Bluetooth' or 'Bluetooth Menu' from the list.
Select the 'Add' or 'Sync' option to detect the car stereo. Select the 'Connect' or 'Start' button to begin the connection process.
Wait while the phone searches for devices that are in range.
Select your car stereo from the list of Bluetooth devices that are displayed on your phone.
Enter the pairing number for the car stereo. This can be found in the documentation for the car stereo.
Wait while your phone is synced with the car stereo.
In Feburary 2016 28,
Turn on the stereo in the car and your cell phone.
Press the Bluetooth pairing button on the car stereo to enable the discoverable mode.
Go to the main menu selection for your phone.
Select the 'Settings' option to view the options that are available.
Select the option for 'Bluetooth' or 'Bluetooth Menu' from the list.
Select the 'Add' or 'Sync' option to detect the car stereo. Select the 'Connect' or 'Start' button to begin the connection process.
Wait while the phone searches for devices that are in range.
Select your car stereo from the list of Bluetooth devices that are displayed on your phone.
Enter the pairing number for the car stereo. This can be found in the documentation for the car stereo.
Wait while your phone is synced with the car stereo.
In Feburary 2016 28,
Saturday, 27 February 2016
How to Create a Link to the Home Page in JoomlaIn Feburary 2016 27,
In Feburary 2016 27,
Navigate to the Administrator section of your Joomla website. The login URL for the Administrator section is usually http://www.MyJoomlaSite/administrator, where www.MyJoomlaSite is the URL for the homepage of your website.
Click 'Add New Article' on the Administrator Control Panel page.
Enter a title for your new article. Select a section and category for your article or blog post using the corresponding drop-down boxes. Click the 'Yes' option next to the 'Front Page' label if you want the article to appear on your Joomla site homepage. Otherwise leave the 'No' option enabled.
Enter the text for your article or blog post in the body section of the article editor. Click the 'Add/Insert Image' icon on the toolbar to insert photos into the body of your article. The 'Add/Insert Image' icon has a small picture of a landscape painting on it and is located next to the chain-link icon.
Highlight the text or select the image you want to link to your Joomla homepage. Click the chain-link icon on the toolbar.
Click the plus sign next to the 'Menu' option in the 'Link Browser' list. Click the plus sign next to the 'Main Menu' option.
Click the 'Home' link option, then 'Insert.' Click the 'Save' button at the top of the editor page.
Click the 'Preview' link in the upper right-hand corner of the Admin console page. Your Joomla site homepage opens in a new tab or window. The new article appears on the homepage if you enabled the 'Front Page' option in the article editor. Once you open the article or blog post in your browser, the text link or photo link is active and visitors can use it to return to the front page of your Joomla site.
In Feburary 2016 27,
Navigate to the Administrator section of your Joomla website. The login URL for the Administrator section is usually http://www.MyJoomlaSite/administrator, where www.MyJoomlaSite is the URL for the homepage of your website.
Click 'Add New Article' on the Administrator Control Panel page.
Enter a title for your new article. Select a section and category for your article or blog post using the corresponding drop-down boxes. Click the 'Yes' option next to the 'Front Page' label if you want the article to appear on your Joomla site homepage. Otherwise leave the 'No' option enabled.
Enter the text for your article or blog post in the body section of the article editor. Click the 'Add/Insert Image' icon on the toolbar to insert photos into the body of your article. The 'Add/Insert Image' icon has a small picture of a landscape painting on it and is located next to the chain-link icon.
Highlight the text or select the image you want to link to your Joomla homepage. Click the chain-link icon on the toolbar.
Click the plus sign next to the 'Menu' option in the 'Link Browser' list. Click the plus sign next to the 'Main Menu' option.
Click the 'Home' link option, then 'Insert.' Click the 'Save' button at the top of the editor page.
Click the 'Preview' link in the upper right-hand corner of the Admin console page. Your Joomla site homepage opens in a new tab or window. The new article appears on the homepage if you enabled the 'Front Page' option in the article editor. Once you open the article or blog post in your browser, the text link or photo link is active and visitors can use it to return to the front page of your Joomla site.
In Feburary 2016 27,
How to Back Up a Go Daddy WebsiteIn Feburary 2016 27,
In Feburary 2016 27,
Create a new folder on your computer's desktop, called 'Backup.'
Launch a web browser and go to www.godaddy.com.
Log in to your GoDaddy account, and click 'My Account' to navigate to the Account Manager.
Select 'Web Hosting' in the Products section. When the screen shifts to your hosting account, click the 'Launch' button next to the account that contains the site that you want to back up.
Click the 'Content' tab in the Hosting Control Center, then click 'Java FTP Client.'
Click 'Yes' or 'Trust' if a security window asks you for permission to continue.
Set the left-hand 'Local System' window to the 'Backup' folder on your computer's desktop.
Drag and drop all of the files for the website you are backing up from the right-hand 'Remote System' window into the 'Backup' folder.
Connect an external drive to your computer via a USB port. Depending on the size of your website, this could be as small as a flash drive or as large as an independent hard drive.
Drag and drop the 'Backup' folder into the external drive. Store this drive somewhere safe.
In Feburary 2016 27,
Create a new folder on your computer's desktop, called 'Backup.'
Launch a web browser and go to www.godaddy.com.
Log in to your GoDaddy account, and click 'My Account' to navigate to the Account Manager.
Select 'Web Hosting' in the Products section. When the screen shifts to your hosting account, click the 'Launch' button next to the account that contains the site that you want to back up.
Click the 'Content' tab in the Hosting Control Center, then click 'Java FTP Client.'
Click 'Yes' or 'Trust' if a security window asks you for permission to continue.
Set the left-hand 'Local System' window to the 'Backup' folder on your computer's desktop.
Drag and drop all of the files for the website you are backing up from the right-hand 'Remote System' window into the 'Backup' folder.
Connect an external drive to your computer via a USB port. Depending on the size of your website, this could be as small as a flash drive or as large as an independent hard drive.
Drag and drop the 'Backup' folder into the external drive. Store this drive somewhere safe.
In Feburary 2016 27,
How to Convert Xls to QifIn Feburary 2016 27,
In Feburary 2016 27,
Visit the XL2QIF website (see Resources) and download the XL2QIF Excel Add-In Version 1.1. Unzip the files using an unzipping program and install the program. The program acts as an add-in to Microsoft Excel and it will create a new menu item labeled 'XL2QIF.' Open Microsoft Excel and click on the menu. Scroll down to 'Save to QIF' to save your current file as a QIF file. Select an output folder and an output file name and click 'Convert.'
Open Microsoft Excel. Click 'File' and 'Save As.' Choose CSV (Comma-Separated Values) as the file type and click 'Save.'
Visit the CSV to QIF Free Online Converter page (see Reources). Click on the 'Choose...' button under CSV Import to choose your recently converted CSV file. Click on the button marked 'Save as QIF.' Choose a name for your QIF file and click 'Ok.' A download box will open up and you can click 'Save' to download the QIF file.
Repeat step 2 to change your XLS document into a CSV file. Visit the LC Bell site (see Resources) and download the QIF to CSV converter. Use the unzipping program to unzip the file and double-click on 'QIF-CSV Converter' to install the program. Once installed open the CSV file by clicking 'File' and then 'Open.' Click 'File' and then 'Save As.' Click on the drop-down menu and change the file type to 'QIF' and click 'Save.' Your file will then be converted to a QIF document.
In Feburary 2016 27,
Visit the XL2QIF website (see Resources) and download the XL2QIF Excel Add-In Version 1.1. Unzip the files using an unzipping program and install the program. The program acts as an add-in to Microsoft Excel and it will create a new menu item labeled 'XL2QIF.' Open Microsoft Excel and click on the menu. Scroll down to 'Save to QIF' to save your current file as a QIF file. Select an output folder and an output file name and click 'Convert.'
Open Microsoft Excel. Click 'File' and 'Save As.' Choose CSV (Comma-Separated Values) as the file type and click 'Save.'
Visit the CSV to QIF Free Online Converter page (see Reources). Click on the 'Choose...' button under CSV Import to choose your recently converted CSV file. Click on the button marked 'Save as QIF.' Choose a name for your QIF file and click 'Ok.' A download box will open up and you can click 'Save' to download the QIF file.
Repeat step 2 to change your XLS document into a CSV file. Visit the LC Bell site (see Resources) and download the QIF to CSV converter. Use the unzipping program to unzip the file and double-click on 'QIF-CSV Converter' to install the program. Once installed open the CSV file by clicking 'File' and then 'Open.' Click 'File' and then 'Save As.' Click on the drop-down menu and change the file type to 'QIF' and click 'Save.' Your file will then be converted to a QIF document.
In Feburary 2016 27,
How to Fix Timeouts in FilezillaIn Feburary 2016 27,
In Feburary 2016 27,
Open the FileZilla 'Edit' menu and select 'Settings.' On a Mac, open the 'FileZilla' menu and choose 'Preferences.'
Select the 'FTP' page in the 'Connection' section of the Settings dialog box. Look for the 'FTP Keep-Alive' section of the page.
Activate the 'Send FTP keep-alive commands' box in the 'FTP Keep-alive' section. This sends commands between FileZilla and the FTP server at short intervals, resetting the time-out function and preventing the server from closing the connection.
In Feburary 2016 27,
Open the FileZilla 'Edit' menu and select 'Settings.' On a Mac, open the 'FileZilla' menu and choose 'Preferences.'
Select the 'FTP' page in the 'Connection' section of the Settings dialog box. Look for the 'FTP Keep-Alive' section of the page.
Activate the 'Send FTP keep-alive commands' box in the 'FTP Keep-alive' section. This sends commands between FileZilla and the FTP server at short intervals, resetting the time-out function and preventing the server from closing the connection.
In Feburary 2016 27,
Labels:
choose,
Connection,
dialog,
Edit,
FTP,
menu,
page,
Preferences,
section,
Select
Wednesday, 24 February 2016
How to Export Windows Event Logs to ExcelIn Feburary 2016 24,
In Feburary 2016 24,
Right-click the 'Computer' icon on the desktop. If the 'Computer' icon is not on the desktop, click the 'Start' button to locate the 'Computer' icon from within the Start Menu programs.
Click 'Manage' from the options box to open the Computer Management Tools console.
Click the right-facing arrow in front of the group 'Event Viewer' to open the available Event Viewer logs.
Right-click the log to be exported, such as the 'Security event log.' From the available options, click 'Save all Events as... .'
Click the down arrow in the 'Save as type:' box and select 'CSV (Comma Separated Value) (*CSV).'
Click in the 'File name:' box and type a file name and save location for the file. For example: 'c:\SecurityEventLog' will save the file called SecurityEventLog and place it on the C: drive.
Click 'Save' to save the CSV file to the C: drive.
Close the Computer Management Console by clicking the 'X' in the upper right-hand corner of the console box.
Open CSV File in Excel and Sort by Event ID
Open Microsoft Excel by clicking 'Start,' 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel.'
Click the 'Office' button in the upper left-hand corner of the Excel application and click 'Open.'
Type 'C:\SecurityEventLog.cvs' in the 'file name:' box and click 'Open' to start the Text Import Wizard.
Select 'Delimited' on the first page of the Text Import Wizard and click 'Next.'
Select 'Comma' and deselect 'Tab' under the Delimiters options and click 'Next.'
Select 'General' under the Column data format box and click 'Finish' to open the Event Viewer log in Excel.
Click on the 'Event ID' column heading to highlight the entire column of Event IDs.
Click 'Data' from the menu options at the top of the Excel application.
Click 'Sort' from the Data menu tab, select 'Expand the selection' when the Sort Warning box appears and click 'Sort.'
Click 'Event ID' in the 'Sort by' drop-down box, specify the sort order by selecting from the available options under the 'Order' drop-down box and click 'OK.'
Review the list of Windows event IDs in Excel and save the file for future use.
In Feburary 2016 24,
Right-click the 'Computer' icon on the desktop. If the 'Computer' icon is not on the desktop, click the 'Start' button to locate the 'Computer' icon from within the Start Menu programs.
Click 'Manage' from the options box to open the Computer Management Tools console.
Click the right-facing arrow in front of the group 'Event Viewer' to open the available Event Viewer logs.
Right-click the log to be exported, such as the 'Security event log.' From the available options, click 'Save all Events as... .'
Click the down arrow in the 'Save as type:' box and select 'CSV (Comma Separated Value) (*CSV).'
Click in the 'File name:' box and type a file name and save location for the file. For example: 'c:\SecurityEventLog' will save the file called SecurityEventLog and place it on the C: drive.
Click 'Save' to save the CSV file to the C: drive.
Close the Computer Management Console by clicking the 'X' in the upper right-hand corner of the console box.
Open CSV File in Excel and Sort by Event ID
Open Microsoft Excel by clicking 'Start,' 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel.'
Click the 'Office' button in the upper left-hand corner of the Excel application and click 'Open.'
Type 'C:\SecurityEventLog.cvs' in the 'file name:' box and click 'Open' to start the Text Import Wizard.
Select 'Delimited' on the first page of the Text Import Wizard and click 'Next.'
Select 'Comma' and deselect 'Tab' under the Delimiters options and click 'Next.'
Select 'General' under the Column data format box and click 'Finish' to open the Event Viewer log in Excel.
Click on the 'Event ID' column heading to highlight the entire column of Event IDs.
Click 'Data' from the menu options at the top of the Excel application.
Click 'Sort' from the Data menu tab, select 'Expand the selection' when the Sort Warning box appears and click 'Sort.'
Click 'Event ID' in the 'Sort by' drop-down box, specify the sort order by selecting from the available options under the 'Order' drop-down box and click 'OK.'
Review the list of Windows event IDs in Excel and save the file for future use.
In Feburary 2016 24,
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,
Tuesday, 23 February 2016
How to Make Your Own Joomla TemplateIn Feburary 2016 23,
In Feburary 2016 23,
Launch Joomla. The interface will pull up several tabs.
Click on the template builder tab. This will drop down four settings groups. Select each setting of choice.
Below each group there will be a build template button. Once the build template button is clicked for whichever group chosen, it will load all settings in the preview link. Located in the preview and download tab.
Click on the live preview button to get a live preview of the template. It will pop up another window with the preview. To make changes, click the adjust settings button. Click build template button. Click live preview to view changes.
Click the select all button on preview and download screen. Copy and then paste the template configuration into the template_config.php file. Save file. Upload to server. This will generate the settings to the website.
In Feburary 2016 23,
Launch Joomla. The interface will pull up several tabs.
Click on the template builder tab. This will drop down four settings groups. Select each setting of choice.
Below each group there will be a build template button. Once the build template button is clicked for whichever group chosen, it will load all settings in the preview link. Located in the preview and download tab.
Click on the live preview button to get a live preview of the template. It will pop up another window with the preview. To make changes, click the adjust settings button. Click build template button. Click live preview to view changes.
Click the select all button on preview and download screen. Copy and then paste the template configuration into the template_config.php file. Save file. Upload to server. This will generate the settings to the website.
In Feburary 2016 23,
Sunday, 21 February 2016
How to Set Up OpenCart in Go DaddyIn Feburary 2016 21,
In Feburary 2016 21,
Download OpenCart from its Google Code site.
Extract the Install folder from the downloaded ZIP file using WinRAR or WinZip.
Upload the unzipped Install folder to your Go Daddy host directory using an FTP application such as FileZilla or CyberDuck.
Select 'Web Hosting' from the Products section of your Go Daddy Account Manager. Under Databases, select the MySQL database icon, and click 'Create Database.' Enter the desired database name, and press 'Create.'
Assign a user to the newly created database. Make sure that the username and password are different from your root username and password.
Configuration
Navigate to your store homepage to begin the configuration process.
Read the terms of service, and press 'Accept.'
Press 'Continue' on the diagnostics page to confirm the server's compatibility with OpenCart.
Enter your MySQL database name and the name and password of the user you assigned to it. In most cases, you can leave the default 'localhost' in the Host field. This will allow OpenCart to access your MySQL database.
Press 'Continue' to complete your configuration of OpenCart.
In Feburary 2016 21,
Download OpenCart from its Google Code site.
Extract the Install folder from the downloaded ZIP file using WinRAR or WinZip.
Upload the unzipped Install folder to your Go Daddy host directory using an FTP application such as FileZilla or CyberDuck.
Select 'Web Hosting' from the Products section of your Go Daddy Account Manager. Under Databases, select the MySQL database icon, and click 'Create Database.' Enter the desired database name, and press 'Create.'
Assign a user to the newly created database. Make sure that the username and password are different from your root username and password.
Configuration
Navigate to your store homepage to begin the configuration process.
Read the terms of service, and press 'Accept.'
Press 'Continue' on the diagnostics page to confirm the server's compatibility with OpenCart.
Enter your MySQL database name and the name and password of the user you assigned to it. In most cases, you can leave the default 'localhost' in the Host field. This will allow OpenCart to access your MySQL database.
Press 'Continue' to complete your configuration of OpenCart.
In Feburary 2016 21,
How to Make a Java Game With NetBeansIn Feburary 2016 21,
In Feburary 2016 21,
Download and install the appropriate version of NetBeans for your system. If you are running 64-bit or 32-bit Windows, there are specific versions of the software for both of these operating systems. You will be prompted to set some defaults of the tool. It is best to accept the default values for all of the fields, since not doing so can lead to you being unable to compile your game from within the tool.
Launch NetBeans, then select 'New Java Project' from the file menu. You will be asked to select where you want to save your project. NetBeans projects can be saved anywhere on your hard drive or on a remote network drive. Give it a name that is both descriptive yet simple enough to remember.
Develop or purchase any art assets that you are going to need for your game. Popular illustration tools include Adobe Illustrator, Photoshop, and the free and open source Inkscape. When developing models for the player characters and any other characters that will be utilized in the game, save them as PNGs, since PNGs have transparent backgrounds by default.
Click on the Java file that NetBeans created for you when you created the project. NetBeans has already generated some code for you, including a main method; in Java, the compiler begins running your code starting with the main method. Since there are so many different types of games that can be written in Java, it is impossible to offer any specific code here, but there is one thing that every game is going to have: an update method. The update method checks what changes have been made in the game world periodically.
Hit F5 to compile your project. Any errors that are found in your game will be displayed in the debugging window at the bottom of your screen. These errors will need to be fixed before you can successfully compile your project.
In Feburary 2016 21,
Download and install the appropriate version of NetBeans for your system. If you are running 64-bit or 32-bit Windows, there are specific versions of the software for both of these operating systems. You will be prompted to set some defaults of the tool. It is best to accept the default values for all of the fields, since not doing so can lead to you being unable to compile your game from within the tool.
Launch NetBeans, then select 'New Java Project' from the file menu. You will be asked to select where you want to save your project. NetBeans projects can be saved anywhere on your hard drive or on a remote network drive. Give it a name that is both descriptive yet simple enough to remember.
Develop or purchase any art assets that you are going to need for your game. Popular illustration tools include Adobe Illustrator, Photoshop, and the free and open source Inkscape. When developing models for the player characters and any other characters that will be utilized in the game, save them as PNGs, since PNGs have transparent backgrounds by default.
Click on the Java file that NetBeans created for you when you created the project. NetBeans has already generated some code for you, including a main method; in Java, the compiler begins running your code starting with the main method. Since there are so many different types of games that can be written in Java, it is impossible to offer any specific code here, but there is one thing that every game is going to have: an update method. The update method checks what changes have been made in the game world periodically.
Hit F5 to compile your project. Any errors that are found in your game will be displayed in the debugging window at the bottom of your screen. These errors will need to be fixed before you can successfully compile your project.
In Feburary 2016 21,
Saturday, 20 February 2016
How to Connect Sharepoint Designer With Sharepoint ServerIn Feburary 2016 20,
In Feburary 2016 20,
Open SharePoint Designer. The program is most commonly found in the Windows Start menu at the following location: 'Programs' > 'Microsoft Office' > 'Microsoft Office SharePoint Designer.'
Click 'File' in the menu near the top of the SharePoint Designer screen. Select 'Open Site.'
Enter the URL of your SharePoint site in the 'Site name' field near the bottom of the 'Open Site' dialog box. Click the 'Open' button.
Choose your editing option. Depending on the configuration of your SharePoint site, you can choose to edit the live site, or edit a local copy and publish that copy to the server at a later time. Click the button next to your desired option and select 'OK.'
Enter your username and password when prompted and click 'OK.' SharePoint Designer is now connected with your SharePoint Server site.
In Feburary 2016 20,
Open SharePoint Designer. The program is most commonly found in the Windows Start menu at the following location: 'Programs' > 'Microsoft Office' > 'Microsoft Office SharePoint Designer.'
Click 'File' in the menu near the top of the SharePoint Designer screen. Select 'Open Site.'
Enter the URL of your SharePoint site in the 'Site name' field near the bottom of the 'Open Site' dialog box. Click the 'Open' button.
Choose your editing option. Depending on the configuration of your SharePoint site, you can choose to edit the live site, or edit a local copy and publish that copy to the server at a later time. Click the button next to your desired option and select 'OK.'
Enter your username and password when prompted and click 'OK.' SharePoint Designer is now connected with your SharePoint Server site.
In Feburary 2016 20,
How to Use Dropbox on a MacIn Feburary 2016 20,
In Feburary 2016 20,
Navigate to the Dropbox website (dropbox.com). Click the 'Download Dropbox' button. Dropbox will automatically detect that you are on Mac OS X and direct you to the proper download link.
Double-click the disk icon to mount if it doesn't mount automatically. Drag the Dropbox application icon and, still holding your mouse, move it to your 'Applications' folder. Release your mouse when you see the green '+' sign.
Navigate to your 'Applications' folder and double-click the Dropbox icon to open the application. Click the 'I don't have a Dropbox account' button and click 'Continue' to create a new account.
Enter your first name, last name, email, desired password and the name of your computer. Click the 'Continue' button.
Select your account type. You can create a free account on Dropbox for 2 GB of storage online. If you invite friends and they join Dropbox, you can an acquire an extra free 250 MB on online storage per friend, up to 8 GB. As of March 2011, paid accounts are available with Dropbox for 50 GB of storage at $9.99 per month or 100 GB of storage for $19.99 per month. Click the 'Continue' button.
Select 'Typical' as your setup type. Use the 'Advanced' setup only if you have experience with Dropbox. Click the 'Continue' button. Click the 'Continue' button again to take a five-step tour of the Dropbox application. Click the 'Skip Tour' button to skip the tour, then click the 'Finish' button. Dropbox creates a shortcut link under the 'Places' heading in the right-side menu of your 'Finder' window for easy and direct access.
Create new folders in your Dropbox or drag and drop files to add them to the existing folders. Your 'Public' and 'Photos' folder are automatically shared, but you can create new folders and share them only with specific people. When you add files or folders to Dropbox, you must wait until you see the green check mark next to the files to confirm that they have been uploaded before attempting to share.
Access application options and settings by using the Dropbox menu in your Finder. The Dropbox menu appears in the top of your Finder window after installation and features the Dropbox logo with a small, gray arrow next to it. The menu lets you share folders and browse them on the Dropbox website.
In Feburary 2016 20,
Navigate to the Dropbox website (dropbox.com). Click the 'Download Dropbox' button. Dropbox will automatically detect that you are on Mac OS X and direct you to the proper download link.
Double-click the disk icon to mount if it doesn't mount automatically. Drag the Dropbox application icon and, still holding your mouse, move it to your 'Applications' folder. Release your mouse when you see the green '+' sign.
Navigate to your 'Applications' folder and double-click the Dropbox icon to open the application. Click the 'I don't have a Dropbox account' button and click 'Continue' to create a new account.
Enter your first name, last name, email, desired password and the name of your computer. Click the 'Continue' button.
Select your account type. You can create a free account on Dropbox for 2 GB of storage online. If you invite friends and they join Dropbox, you can an acquire an extra free 250 MB on online storage per friend, up to 8 GB. As of March 2011, paid accounts are available with Dropbox for 50 GB of storage at $9.99 per month or 100 GB of storage for $19.99 per month. Click the 'Continue' button.
Select 'Typical' as your setup type. Use the 'Advanced' setup only if you have experience with Dropbox. Click the 'Continue' button. Click the 'Continue' button again to take a five-step tour of the Dropbox application. Click the 'Skip Tour' button to skip the tour, then click the 'Finish' button. Dropbox creates a shortcut link under the 'Places' heading in the right-side menu of your 'Finder' window for easy and direct access.
Create new folders in your Dropbox or drag and drop files to add them to the existing folders. Your 'Public' and 'Photos' folder are automatically shared, but you can create new folders and share them only with specific people. When you add files or folders to Dropbox, you must wait until you see the green check mark next to the files to confirm that they have been uploaded before attempting to share.
Access application options and settings by using the Dropbox menu in your Finder. The Dropbox menu appears in the top of your Finder window after installation and features the Dropbox logo with a small, gray arrow next to it. The menu lets you share folders and browse them on the Dropbox website.
In Feburary 2016 20,
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,
Labels:
created,
field,
field_name,
query,
returns,
Select,
table,
table_name,
typing,
Write
Friday, 19 February 2016
How to Use the SUM Function in MySQLIn Feburary 2016 19,
In Feburary 2016 19,
Use the SUM aggregate function. SUM will add all of the selected columns together.
Notice how, in this example, you'll sum all of the negative balances to calculate the total amount owed to you by your customers. The result returns in a column called SUM(balance). Example:
SELECT SUM(balance) FROM customers WHERE balance
Use the AVG Function in MySQL
Use the AVG aggregate function. This aggregate is similar to SUM. However, instead of adding the columns, it adds them and then divides by the total number of columns, giving you an average of the column values.
Use AVG in much the same way SUM is used. Here, the example calculates the average amount of money owed by customers. Results return in a column called AVG(balance). Example:
SELECT AVG(balance) FROM customers WHERE balance
Use the COUNT Function in MySQL
Use the COUNT aggregate function. This function is slightly different than SUM or AVG. It returns the number of rows returned, which can be useful in a number of situations--for example, to see the number of customers who owe money.
See how this example counts the customers who owe money and returns the result in a column called COUNT(
). Example:
SELECT COUNT(
) FROM customers WHERE balance
Use the DISTINCT COUNT Function in MySQL
Use the DISTINCT COUNT aggregate function. The function can be used to return the number of distinct rows, meaning those rows with differing values. Theoretically, you might have a lot of customers with the same phone number. To get the number of households your customers live in, you can use this type of query.
Use the following example to return the number of customers with distinct phone numbers. Customers with the same phone number will not be counted. The results are returned in a column called COUNT(DISTINCT ph_number). Example:
SELECT COUNT(DISTINCT ph_number) FROM customers;
In Feburary 2016 19,
Use the SUM aggregate function. SUM will add all of the selected columns together.
Notice how, in this example, you'll sum all of the negative balances to calculate the total amount owed to you by your customers. The result returns in a column called SUM(balance). Example:
SELECT SUM(balance) FROM customers WHERE balance
Use the AVG Function in MySQL
Use the AVG aggregate function. This aggregate is similar to SUM. However, instead of adding the columns, it adds them and then divides by the total number of columns, giving you an average of the column values.
Use AVG in much the same way SUM is used. Here, the example calculates the average amount of money owed by customers. Results return in a column called AVG(balance). Example:
SELECT AVG(balance) FROM customers WHERE balance
Use the COUNT Function in MySQL
Use the COUNT aggregate function. This function is slightly different than SUM or AVG. It returns the number of rows returned, which can be useful in a number of situations--for example, to see the number of customers who owe money.
See how this example counts the customers who owe money and returns the result in a column called COUNT(
). Example:
SELECT COUNT(
) FROM customers WHERE balance
Use the DISTINCT COUNT Function in MySQL
Use the DISTINCT COUNT aggregate function. The function can be used to return the number of distinct rows, meaning those rows with differing values. Theoretically, you might have a lot of customers with the same phone number. To get the number of households your customers live in, you can use this type of query.
Use the following example to return the number of customers with distinct phone numbers. Customers with the same phone number will not be counted. The results are returned in a column called COUNT(DISTINCT ph_number). Example:
SELECT COUNT(DISTINCT ph_number) FROM customers;
In Feburary 2016 19,
How to Create a Catalog in DreamweaverIn Feburary 2016 19,
In Feburary 2016 19,
Open Dreamweaver and on the 'File' menu choose the 'New' command. Dreamweaver will present you with a dialogue box that will ask for server and file setup information. You will need to choose the folder where you want to save the files you create in Dreamweaver as well as the location of the server where the files will be uploaded. The server information you need is available from your web host. Once this information is complete, Dreamweaver presents you with a template dialogue box.
Select a template option from the template dialogue box. Dreamweaver offers several catalog templates to choose from. Clicking on any of the templates will bring it up for you to examine. Look at all of them and determine which one fits your needs. If none of them is quite what you need, choose the closest and modify it. You can easily delete sections of the template or add sections of the template by using the Modify menu.
Replace the Dreamweaver template text with your own text. This will be information about your products, including product descriptions and pricing.
Add pictures of your products to your catalog by using the Insert menu. Dreamweaver allows you to set the display size of the graphic and easily create links to full-size versions.
Upload your catalog to your web host using Dreamweaver's built-in FTP (File Transfer Protocol) feature. Your web catalog will dispplay on your website just as you created it.
In Feburary 2016 19,
Open Dreamweaver and on the 'File' menu choose the 'New' command. Dreamweaver will present you with a dialogue box that will ask for server and file setup information. You will need to choose the folder where you want to save the files you create in Dreamweaver as well as the location of the server where the files will be uploaded. The server information you need is available from your web host. Once this information is complete, Dreamweaver presents you with a template dialogue box.
Select a template option from the template dialogue box. Dreamweaver offers several catalog templates to choose from. Clicking on any of the templates will bring it up for you to examine. Look at all of them and determine which one fits your needs. If none of them is quite what you need, choose the closest and modify it. You can easily delete sections of the template or add sections of the template by using the Modify menu.
Replace the Dreamweaver template text with your own text. This will be information about your products, including product descriptions and pricing.
Add pictures of your products to your catalog by using the Insert menu. Dreamweaver allows you to set the display size of the graphic and easily create links to full-size versions.
Upload your catalog to your web host using Dreamweaver's built-in FTP (File Transfer Protocol) feature. Your web catalog will dispplay on your website just as you created it.
In Feburary 2016 19,
Thursday, 18 February 2016
How to Run a Client Server in NetBeansIn Feburary 2016 18,
In Feburary 2016 18,
Click the 'Start' button and 'All Programs' to expand the Windows application menu. Click the 'NetBeans' folder, then the 'NetBeans' application icon. This will launch NetBeans in a new window.
Right-click the 'EJB' project module and select 'New,' then 'Session Bean.' The NetBeans project configuration screen displays on screen.
Type 'MySession' in the 'EJB Name' box.
Type 'ejb' in the 'Package:' drop-down menu.
Click the 'Stateless' radio button under 'Session Type:.'
Click the 'Remote in project' check box under 'Create Interface:.' Select the 'EJBRemoteInterface' project from the drop-down list and then click the 'Finish' button.
Right-click the 'EntAppClient' enterprise application project and choose 'Run' from the drop-down menu. NetBeans builds the project that contains your application and runs it on a client server.
In Feburary 2016 18,
Click the 'Start' button and 'All Programs' to expand the Windows application menu. Click the 'NetBeans' folder, then the 'NetBeans' application icon. This will launch NetBeans in a new window.
Right-click the 'EJB' project module and select 'New,' then 'Session Bean.' The NetBeans project configuration screen displays on screen.
Type 'MySession' in the 'EJB Name' box.
Type 'ejb' in the 'Package:' drop-down menu.
Click the 'Stateless' radio button under 'Session Type:.'
Click the 'Remote in project' check box under 'Create Interface:.' Select the 'EJBRemoteInterface' project from the drop-down list and then click the 'Finish' button.
Right-click the 'EntAppClient' enterprise application project and choose 'Run' from the drop-down menu. NetBeans builds the project that contains your application and runs it on a client server.
In Feburary 2016 18,
Subscribe to:
Posts (Atom)