In Feburary 2016 30,
Open SQL Developer. Click 'File' in the top toolbar menu and click 'Open connection.'
Click the 'DB2' tab in the Connection dialog box. Enter the name of the DB2 database in the first box. Enter the host and port information, as well as the driver type. You can choose between entering 'IBM DB2 Application Driver' or 'IBM DB2 Network Driver' for the driver type. Enter the user name and password to access the DB2 database.
Click 'Info' at the bottom of the Connection dialog box to test the connection with the settings you entered. Click 'OK' to create the connection to the DB2 database.
In Feburary 2016 30,
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
Tuesday, 1 March 2016
How to Register a Web Site With Search EnginesIn Feburary 2016 30,
In Feburary 2016 30,
Use meta tags and keywords on your Web pages. Keywords are used by search engines to index pages into a searchable database. See Related eHows for more.
Register with individual search engines, such as Yahoo, by going to the search engine's home page and looking for a button or text link called Add URL or Add Web Page.
Click on this link to get directions for submitting your Web site.
Several sites offer site submission services. The most popular service, Submit It, allows you to enter keywords and descriptions, and choose which sites to submit your page to.
In Feburary 2016 30,
Use meta tags and keywords on your Web pages. Keywords are used by search engines to index pages into a searchable database. See Related eHows for more.
Register with individual search engines, such as Yahoo, by going to the search engine's home page and looking for a button or text link called Add URL or Add Web Page.
Click on this link to get directions for submitting your Web site.
Several sites offer site submission services. The most popular service, Submit It, allows you to enter keywords and descriptions, and choose which sites to submit your page to.
In Feburary 2016 30,
Monday, 29 February 2016
How to Import a MySQL DatabaseIn Feburary 2016 29,
In Feburary 2016 29,
Install phpMyAdmin software on your computer if it is not already installed. You can find phpMyAdmin software online at the phpMyAdmin homepage (see Resources below).
Log onto the phpMyAdmin page from your Web space. You will need the username and password assigned to you by your Web-hosting provider.
Select the database you wish to import the old data into from the drop-down Database Selection box on the left of the page.
Click the SQL tab toward the top of the interface.
Click the Browse button located toward the bottom of the page.
Find the .SQL file where it is saved on your hard drive, select it and click 'Open.'
Click the Go button. The data in your SQL file has now been imported into your database.
Using the SSH Command Line
Contact your hosting provider to gain SSH access.
Log into your Web space using an FTP client. You will need to know your username and password.
Find your existing .SQL database and upload it to your Web space using your FTP client. It doesn't matter where in your Web space you upload it to, as long as you execute the SSH command when you're in this folder.
Close your FTP program.
Log into your Web space using the appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own database name, file name, username and password instead of the words in capitals.mysql -uUSERNAME -pPASSWORD DATABASENAME
In Feburary 2016 29,
Install phpMyAdmin software on your computer if it is not already installed. You can find phpMyAdmin software online at the phpMyAdmin homepage (see Resources below).
Log onto the phpMyAdmin page from your Web space. You will need the username and password assigned to you by your Web-hosting provider.
Select the database you wish to import the old data into from the drop-down Database Selection box on the left of the page.
Click the SQL tab toward the top of the interface.
Click the Browse button located toward the bottom of the page.
Find the .SQL file where it is saved on your hard drive, select it and click 'Open.'
Click the Go button. The data in your SQL file has now been imported into your database.
Using the SSH Command Line
Contact your hosting provider to gain SSH access.
Log into your Web space using an FTP client. You will need to know your username and password.
Find your existing .SQL database and upload it to your Web space using your FTP client. It doesn't matter where in your Web space you upload it to, as long as you execute the SSH command when you're in this folder.
Close your FTP program.
Log into your Web space using the appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own database name, file name, username and password instead of the words in capitals.mysql -uUSERNAME -pPASSWORD DATABASENAME
In Feburary 2016 29,
Saturday, 27 February 2016
How to Add a WordPress Blog to Your Zen Cart StoreIn Feburary 2016 27,
In Feburary 2016 27,
Right-click inside your hosting folder and select “New Folder.”
Name the folder “Blog.”
Download and unzip WordPress to your computer.
Log in to the cPanel of your Web-hosting account and create a new database for your WordPress installation.
Open the WordPress folder on your computer.
Rename the 'wp-config-sample.php' file to 'wp-config.php.'
Open the 'wp-config.php' file using Notepad.
Type your database name and database username and password from Step 5. Save the file.
Copy the WordPress files located on your computer to the Blog folder on your Web server.
Log in to your Zen Cart Admin Dashboard at mydomain.com/zencart/admin. Replace “mydomain.com” with the URL of your website.
Click “Tools” and “EZ Pages.” Click the “New File” button.
Type “yoursite.com/blog,” replacing “yoursite.com” with the URL of your site in the “Link URL” box.
Click “Insert.”
In Feburary 2016 27,
Right-click inside your hosting folder and select “New Folder.”
Name the folder “Blog.”
Download and unzip WordPress to your computer.
Log in to the cPanel of your Web-hosting account and create a new database for your WordPress installation.
Open the WordPress folder on your computer.
Rename the 'wp-config-sample.php' file to 'wp-config.php.'
Open the 'wp-config.php' file using Notepad.
Type your database name and database username and password from Step 5. Save the file.
Copy the WordPress files located on your computer to the Blog folder on your Web server.
Log in to your Zen Cart Admin Dashboard at mydomain.com/zencart/admin. Replace “mydomain.com” with the URL of your website.
Click “Tools” and “EZ Pages.” Click the “New File” button.
Type “yoursite.com/blog,” replacing “yoursite.com” with the URL of your site in the “Link URL” box.
Click “Insert.”
In Feburary 2016 27,
What is an Oracle Database Client?In Feburary 2016 27,
In Feburary 2016 27,
A server is a computer that hosts software which users can access through their client computers. The server and its clients are connected through a network, which allows users on client machines to use the services provided by the server.
Relational Database
A relational database organizes data into normalized tables, which are individual tables that don't contain data redundancies and that have a primary key, which is a unique identifier for each row of data in the table. A relational database can combine data from multiple tables by joining tables that share the same primary key through a query language, such as SQL.
The Oracle Database Client
Users can access the Oracle database through their client computers and submit requests for information, which the Oracle server will respond to. At a bank that uses Oracle database software, a teller could submit a query from her computer, the Oracle database client, to the Oracle server to retrieve a customer's account information.
In Feburary 2016 27,
A server is a computer that hosts software which users can access through their client computers. The server and its clients are connected through a network, which allows users on client machines to use the services provided by the server.
Relational Database
A relational database organizes data into normalized tables, which are individual tables that don't contain data redundancies and that have a primary key, which is a unique identifier for each row of data in the table. A relational database can combine data from multiple tables by joining tables that share the same primary key through a query language, such as SQL.
The Oracle Database Client
Users can access the Oracle database through their client computers and submit requests for information, which the Oracle server will respond to. At a bank that uses Oracle database software, a teller could submit a query from her computer, the Oracle database client, to the Oracle server to retrieve a customer's account information.
In Feburary 2016 27,
Tutorial for Crystal ReportsIn Feburary 2016 27,
In Feburary 2016 27,
After you choose Crystal Reports from the Start menu, it opens to the Start Page with three drop-down menus across the top: File, View and Help. In the body of the page, it gives you choices to either start a new report or open recent reports. If you choose to start a new report, you have several options. You can either design your own report from scratch using a blank report or you can use one of several wizards. It will be easiest to start with the report wizard.
Designing and Building Your First Report
Before you start up the wizard, think about what information you need and who needs your report. You'll get a much clearer report if you limit it as closely as possible to only the information your audience needs.When you select report wizard, a window opens up that helps you connect to your database. If your database is not listed under existing connections, you'll have to create a new connection to it. You'll need to tell it what kind of database you're connecting to. Your simplest starting point is to select an Access/DAO database. A window will open that asks for the database name. If you don't know the name, click the ellipsis [...] next to 'database name', to browse. The wizard will walk you through selecting your tables and fields. Make your first report without using grouping.When you get to the record selection window, you can narrow down your data, adding fields into the filter fields section, then using the drop-downs below to specify what data you do and don't want.
Your Report's Appearance
When you finish filtering and click Finish, Crystal Reports will select your data and display it to you on the Preview tab. Click the Design tab. You can add headers and footers here, change their appearance and change the size and name of columns. You have three tool bars at the top of your window. In the lowest one down, the leftmost section is the one that lets you insert text objects, images, charts and such. Experiment. If you're familiar with MS Office or its competitors, the choices will be pretty intuitive.
Publishing Your Report
Under the File menu, you can print your report or export it to other applications such as Word and Excel or as a PDF. You can make it editable or read only. You can export your data into a flat file if that's what you need. Using the print option, you can send your report out as a fax. Export options also let you send your report directly to one of several email applications.
In Feburary 2016 27,
After you choose Crystal Reports from the Start menu, it opens to the Start Page with three drop-down menus across the top: File, View and Help. In the body of the page, it gives you choices to either start a new report or open recent reports. If you choose to start a new report, you have several options. You can either design your own report from scratch using a blank report or you can use one of several wizards. It will be easiest to start with the report wizard.
Designing and Building Your First Report
Before you start up the wizard, think about what information you need and who needs your report. You'll get a much clearer report if you limit it as closely as possible to only the information your audience needs.When you select report wizard, a window opens up that helps you connect to your database. If your database is not listed under existing connections, you'll have to create a new connection to it. You'll need to tell it what kind of database you're connecting to. Your simplest starting point is to select an Access/DAO database. A window will open that asks for the database name. If you don't know the name, click the ellipsis [...] next to 'database name', to browse. The wizard will walk you through selecting your tables and fields. Make your first report without using grouping.When you get to the record selection window, you can narrow down your data, adding fields into the filter fields section, then using the drop-downs below to specify what data you do and don't want.
Your Report's Appearance
When you finish filtering and click Finish, Crystal Reports will select your data and display it to you on the Preview tab. Click the Design tab. You can add headers and footers here, change their appearance and change the size and name of columns. You have three tool bars at the top of your window. In the lowest one down, the leftmost section is the one that lets you insert text objects, images, charts and such. Experiment. If you're familiar with MS Office or its competitors, the choices will be pretty intuitive.
Publishing Your Report
Under the File menu, you can print your report or export it to other applications such as Word and Excel or as a PDF. You can make it editable or read only. You can export your data into a flat file if that's what you need. Using the print option, you can send your report out as a fax. Export options also let you send your report directly to one of several email applications.
In Feburary 2016 27,
Friday, 12 February 2016
How to Connect PHP to MySQL Using WAMPIn Feburary 2016 12,
In Feburary 2016 12,
Launch a plain text editor, such as the Notepad, and create a new file.
Enter the script to connect PHP to a MySQL database by passing the hostname, username and password. For example, type:<?php
mysqli_connect('localhost', 'username', 'password') or die('Connection failed! ' . mysqli_error());
echo 'Connection successful!';
?>
Save the file as 'connect.php' and place it in the 'htdocs' directory for your WAMP implementation.
Test the connection by opening
connect.php in a Web browser and confirm that the connection was successful.
In Feburary 2016 12,
Launch a plain text editor, such as the Notepad, and create a new file.
Enter the script to connect PHP to a MySQL database by passing the hostname, username and password. For example, type:<?php
mysqli_connect('localhost', 'username', 'password') or die('Connection failed! ' . mysqli_error());
echo 'Connection successful!';
?>
Save the file as 'connect.php' and place it in the 'htdocs' directory for your WAMP implementation.
Test the connection by opening
connect.php in a Web browser and confirm that the connection was successful.
In Feburary 2016 12,
Wednesday, 10 February 2016
How to Create a MySQL DatabaseIn Feburary 2016 10,
In Feburary 2016 10,
Log into the phpMyAdmin interface on your Web space. You will need the username and password assigned by your Web-hosting provider.
Find the text 'Create New Database' on the main frame of the page.
Enter a name for your new database into the blank text field provided.
Click 'Create.' You will get a confirmation page telling you that your database has been created.
Using the SSH Command Line
Log into your Web space using an appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own username and password instead of the words in capitals:
mysql -uUSERNAME -pPASSWORD
Enter the following into the MySQL prompt that you will be given, with your database's proposed name instead of NAME:
create database NAME;
Your database has now been created.
In Feburary 2016 10,
Log into the phpMyAdmin interface on your Web space. You will need the username and password assigned by your Web-hosting provider.
Find the text 'Create New Database' on the main frame of the page.
Enter a name for your new database into the blank text field provided.
Click 'Create.' You will get a confirmation page telling you that your database has been created.
Using the SSH Command Line
Log into your Web space using an appropriate SSH client. You will need the username and password assigned to you by your Web-hosting provider.
Enter the following into the command line, using your own username and password instead of the words in capitals:
mysql -uUSERNAME -pPASSWORD
Enter the following into the MySQL prompt that you will be given, with your database's proposed name instead of NAME:
create database NAME;
Your database has now been created.
In Feburary 2016 10,
Tuesday, 9 February 2016
How to Insert HTML Values Into an Oracle DatabaseIn Feburary 2016 09,
In Feburary 2016 09,
Create the web page in HTML. Make sure the page includes two text input fields named 'user' and 'password.' Set the form action to call 'input.cgi' from the cgi-bin on your server. Save the HTML as 'info.html.'
Create the server side script. For PERL to speak to a database, you must use the DBI module. The following script shows how to connect to the database:!/usr/bin/perl -wuse CGI;
use DBI;
print 'Content-type: text/html\n\n';
$cgi = CGI->new();
$user = $cgi->param('user');
$password = $cgi->param('password');
$dbh = DBI->connect( 'dbi:Oracle:your_Database_name', 'your_username', 'your_password' )
or die 'Can't connect to Oracle database: $DBI::errstr\n';
You must get the values for 'your_Database_name,' 'your_username,' and 'your_password' from your server administrator. For this tutorial, it is assumed you already have this information.
Write the SQL. To do this, you must have a table set up in Oracle that can receive the two fields. Call the table 'user_auth' and make sure it has a column called 'user' and another one called 'pwd.' The following SQL statement will insert the data into the table:
$sqlstatement='INSERT INTO user_auth VALUES ('$user','$password')';
$sth=$dbh->prepare($sqlstatement);
$sth->execute || print $sqlstatement;
Confirm the data have been entered by including a print command. To do this, add the following line of code to the end of the program:
print 'Information accepted';
If this does not print out, then you can be sure the information was not sent. You must go back and check the database settings. Save the script as 'input.cgi.'
Upload the HTML and CGI files to the server. The HTML must go in docs area, and the CGI must be uploaded to the cgi-bin.
Execute the program. Do this by opening the HTML document in a browser and entering some mock information. Once you submit it, you should see the confirmation printout. If you see the printout, the information has been sent to the database.
In Feburary 2016 09,
Create the web page in HTML. Make sure the page includes two text input fields named 'user' and 'password.' Set the form action to call 'input.cgi' from the cgi-bin on your server. Save the HTML as 'info.html.'
Create the server side script. For PERL to speak to a database, you must use the DBI module. The following script shows how to connect to the database:!/usr/bin/perl -wuse CGI;
use DBI;
print 'Content-type: text/html\n\n';
$cgi = CGI->new();
$user = $cgi->param('user');
$password = $cgi->param('password');
$dbh = DBI->connect( 'dbi:Oracle:your_Database_name', 'your_username', 'your_password' )
or die 'Can't connect to Oracle database: $DBI::errstr\n';
You must get the values for 'your_Database_name,' 'your_username,' and 'your_password' from your server administrator. For this tutorial, it is assumed you already have this information.
Write the SQL. To do this, you must have a table set up in Oracle that can receive the two fields. Call the table 'user_auth' and make sure it has a column called 'user' and another one called 'pwd.' The following SQL statement will insert the data into the table:
$sqlstatement='INSERT INTO user_auth VALUES ('$user','$password')';
$sth=$dbh->prepare($sqlstatement);
$sth->execute || print $sqlstatement;
Confirm the data have been entered by including a print command. To do this, add the following line of code to the end of the program:
print 'Information accepted';
If this does not print out, then you can be sure the information was not sent. You must go back and check the database settings. Save the script as 'input.cgi.'
Upload the HTML and CGI files to the server. The HTML must go in docs area, and the CGI must be uploaded to the cgi-bin.
Execute the program. Do this by opening the HTML document in a browser and entering some mock information. Once you submit it, you should see the confirmation printout. If you see the printout, the information has been sent to the database.
In Feburary 2016 09,
Sunday, 7 February 2016
How to Create a Forum WebsiteIn Feburary 2016 07,
In Feburary 2016 07,
Register a domain name for your website at a domain name registrar such as FreeHostia or GoDaddy (see Resources).
Buy a web hosting package to host your website online. Hosting is available from the domain name registrars listed above and many different sites. Buy a package that includes at least one MySQL database.
Download and extract the newest version of the phpBB Installation Package from its official website (see Resources).
Upload every file and folder you just downloaded into the same public location on your website (such as yoursite.com/forum).
Open a web browser and navigate to the 'install' folder of wherever you put phpBB. If you put it in yoursite.com/forum, go to yoursite.com/forum/install.
Click on the 'Install' tab and follow the on-screen instructions to install phpBB. If you get stuck, you can find detailed installation instructions in INSTALL.html and README.html, in the 'docs' folder.
Find extra add-ons for your forum and different visual styles from the phpBB website (see Resources).
Tell people to come to your site and start talking.
In Feburary 2016 07,
Register a domain name for your website at a domain name registrar such as FreeHostia or GoDaddy (see Resources).
Buy a web hosting package to host your website online. Hosting is available from the domain name registrars listed above and many different sites. Buy a package that includes at least one MySQL database.
Download and extract the newest version of the phpBB Installation Package from its official website (see Resources).
Upload every file and folder you just downloaded into the same public location on your website (such as yoursite.com/forum).
Open a web browser and navigate to the 'install' folder of wherever you put phpBB. If you put it in yoursite.com/forum, go to yoursite.com/forum/install.
Click on the 'Install' tab and follow the on-screen instructions to install phpBB. If you get stuck, you can find detailed installation instructions in INSTALL.html and README.html, in the 'docs' folder.
Find extra add-ons for your forum and different visual styles from the phpBB website (see Resources).
Tell people to come to your site and start talking.
In Feburary 2016 07,
Saturday, 6 February 2016
How to Check MySQL Null on PHPIn Feburary 2016 06,
In Feburary 2016 06,
Open your PHP source file in a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to send a MySQL query to the active database. For example, '$result=mysql_query('Select my_var from my_table');'.
Use the 'mysql_fetch_assoc(result)' function inside a 'while' loop to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($result)) {'.
Use the 'is_null(variable)' function inside the 'while' loop to determine if a field from a returned row has a NULL value. For example, if (is_null($my_values['my_var'])) { echo 'is NULL'; } }' will print 'is NULL' for any values of 'my_var' that are NULL.
Save the PHP file.
In Feburary 2016 06,
Open your PHP source file in a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to send a MySQL query to the active database. For example, '$result=mysql_query('Select my_var from my_table');'.
Use the 'mysql_fetch_assoc(result)' function inside a 'while' loop to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($result)) {'.
Use the 'is_null(variable)' function inside the 'while' loop to determine if a field from a returned row has a NULL value. For example, if (is_null($my_values['my_var'])) { echo 'is NULL'; } }' will print 'is NULL' for any values of 'my_var' that are NULL.
Save the PHP file.
In Feburary 2016 06,
How to Create a Table in GoDaddy With MySQLIn Feburary 2016 06,
In Feburary 2016 06,
Open a Web browser. Navigate to the GoDaddy website and log in to your customer account. At the top of the window, click the 'Database' tab to open a list of database management features.
Click the 'Run Query' link to open a query manager. Click 'MySQL' to open a view of your database. You can create tables, delete tables and edit table information in the phpMyAdmin application.
Type the following code to create a GoDaddy table:create table customer(id int,name varchar(50))In this example, a customer table is created with two columns: ID and name. You can add as many columns as you need in the table. Separate each column definition with a comma.
Click the 'Run' button. The application creates the table and sets up the columns. After the page refreshes, the new table is displayed in the phpMyAdmin window.
In Feburary 2016 06,
Open a Web browser. Navigate to the GoDaddy website and log in to your customer account. At the top of the window, click the 'Database' tab to open a list of database management features.
Click the 'Run Query' link to open a query manager. Click 'MySQL' to open a view of your database. You can create tables, delete tables and edit table information in the phpMyAdmin application.
Type the following code to create a GoDaddy table:create table customer(id int,name varchar(50))In this example, a customer table is created with two columns: ID and name. You can add as many columns as you need in the table. Separate each column definition with a comma.
Click the 'Run' button. The application creates the table and sets up the columns. After the page refreshes, the new table is displayed in the phpMyAdmin window.
In Feburary 2016 06,
Friday, 5 February 2016
How to Display Text From MySQL in PHPIn Feburary 2016 05,
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Open your PHP source file with a text editor, such as Windows Notepad.
Use the 'mysql_query(query)' function to read a TEXT field from the active MySQL database. For example, '$my_result=mysql_query('Select my_var from my_table');' where 'my_var' is a TEXT field.
Use a 'while' loop and the 'mysql_fetch_assoc(my_result)' function to fetch rows from the MySQL result. For example, 'while ($my_values=mysql_fetch_assoc($my_result)) {}'.
Store the TEXT field value in a PHP variable, inside the 'while' loop. For example, '$str = $my_values['my_var'];'.
Use the 'nl2br' function to replace newline '\n' characters with ''. MySQL uses '\n' to signify a newline, but HTML uses ''. For example, 'echo nl2br($str);' will return the TEXT field with proper line breaks.
Save the PHP file.
In Feburary 2016 05,
Wednesday, 3 February 2016
How to Convert SQLite to TextIn Feburary 2016 03,
In Feburary 2016 03,
Load a SQLite database and enter the sqlite3 environment by typing the following text at the command prompt:$ sqlite3 mydb.dbReplace 'mydb.db' with the name of your database. A database with the specified name will be created if none already exists.
Convert a value to the TEXT data type with the 'CAST' expression by typing the following command at the command prompt:$ sqlite3 my_db.db INSERT INTO my_table VALUES(CAST(97 AS TEXT))Replace 'my_table' with the name of your table. In the code, the number 97 is inserted into the table as a TEXT value.
Exit the sqlite3 environment by typing '.quit', '.q' or '.exit.' and pressing the 'Enter' key.
In Feburary 2016 03,
Load a SQLite database and enter the sqlite3 environment by typing the following text at the command prompt:$ sqlite3 mydb.dbReplace 'mydb.db' with the name of your database. A database with the specified name will be created if none already exists.
Convert a value to the TEXT data type with the 'CAST' expression by typing the following command at the command prompt:$ sqlite3 my_db.db INSERT INTO my_table VALUES(CAST(97 AS TEXT))Replace 'my_table' with the name of your table. In the code, the number 97 is inserted into the table as a TEXT value.
Exit the sqlite3 environment by typing '.quit', '.q' or '.exit.' and pressing the 'Enter' key.
In Feburary 2016 03,
Subscribe to:
Posts (Atom)