Sunday, September 14, 2014
SQL QUERY LANGUAGE
SQL kependekan dari Structured Query Language, adalah bahasa standar yang digunakan untuk berkomunikasi dengan database relasional. Karena merupakan bahasa standar untuk mengakses database relasional, maka perintah dalam SQL dapat diterapkan untuk banyak database management system (DBMS). Hampir semua DBMS seperti MySQL, Microsoft SQL Server, Oracle, DB2, PostgreSQL dan lain-lain mengenal dan mengerti SQL. Perintah standar SQL pada beberapa DBMS tersebut hampir sama, meskipun masing-masing mungkin juga memiliki “dialect of SQL” sendiri yang akan memberikan tambahan atau perluasan pada perintah standar tersebut.
Perintah dalam SQL dapat diklasifikasikan menjadi enam bagian yaitu Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL) dan Data Control Language (DCL).
- Data Definition Language (DDL)adalah perintah-perintah SQL yang digunakan untuk mendefinisikan struktur dan skema database. Perintah-perintah SQL yang masuk klasifikasi ini antara lain CREATE (membuat obyek di database), ALTER (merubah struktur database), DROP (menghapus obyek database), TRUNCATE (menghapus semua record dari sebuah tabel termasuk semua ruang yang dialokasikan), COMMENT (menambahkan komentar ke kamus data | data dictionary) dan RENAME (memberi nama ulang sebuah obyek).
Jenis – Jenis Algoritma
Terdapat beragam klasifikasi algoritma dan setiap klasifikasi mempunyai alasan tersendiri. Salah satu cara untuk melakukan klasifikasi jenis-jenis algoritma adalah dengan memperhatikan paradigma dan metode yang digunakan untuk mendesain algoritma tersebut. Beberapa paradigma yang digunakan dalam menyusun suatu algoritma akan dipaparkan dibagian ini. Masing-masing paradigma dapat digunakan dalam banyak algoritma yang berbeda.
algoritma Brute force
Algoritma Brute Force adalah sebuah pendekatan
yang lempang (straightforward) untuk memecahkan
suatu masalah, biasanya didasarkan pada pernyataan
masalah (problem statement) dan definisi konsep
yang dilibatkan.
JENI PEMBELAJARAN JAVA
ini adalah daftar dari pembelajaran java yang mudah dan ringkas
untuk modul sekolah dan modul kuliah.
Sunday, October 07, 2012
<?php
/*
=====================================================
MEKO CORPORATION
-----------------------------------------------------
compliments of http://smkpalapasmg.co.cc/
=====================================================
*/
$mobile = "http://smkpalapasmg.co.cc";
$text = $_SERVER['HTTP_USER_AGENT'];
$var[0] = 'Mozilla/4.';
$var[1] = 'Mozilla/3.0';
$var[2] = 'AvantGo';
$var[3] = 'ProxiNet';
$var[4] = 'Danger hiptop 1.0';
$var[5] = 'DoCoMo/';
$var[6] = 'Google CHTML Proxy/';
$var[7] = 'UP.Browser/';
$var[8] = 'SEMC-Browser/';
$var[9] = 'J-PHONE/';
$var[10] = 'PDXGW/';
$var[11] = 'ASTEL/';
$var[12] = 'Mozilla/1.22';
$var[13] = 'Handspring';
$var[14] = 'Windows CE';
$var[15] = 'PPC';
berbagai maca script ms dos pada windows
All DOS command
ADDUSERS Add or list users to/from a CSV file
ARP Address Resolution Protocol
ASSOC Change file extension associations
ASSOCIAT One step file association
AT Schedule a command to run at a later time
ATTRIB Change file attributes
BOOTCFG Edit Windows boot settings
BROWSTAT Get domain, browser and PDC info
CACLS Change file permissions
CALL Call one batch program from another
CD Change Directory - move to a specific Folder
CHANGE Change Terminal Server Session properties
CHKDSK Check Disk - check and repair disk problems
CHKNTFS Check the NTFS file system
CHOICE Accept keyboard input to a batch file
CIPHER Encrypt or Decrypt files/folders
CleanMgr Automated cleanup of Temp files, recycle bin
CLEARMEM Clear memory leaks
CLIP Copy STDIN to the Windows clipboard.
CLS Clear the screen
CLUSTER Windows Clustering
CMD Start a new CMD shell
COLOR Change colors of the CMD window
COMP Compare the contents of two files or sets of files
COMPACT Compress files or folders on an NTFS partition
COMPRESS Compress individual files on an NTFS partition
CON2PRT Connect or disconnect a Printer
CONVERT Convert a FAT drive to NTFS.
COPY Copy one or more files to another location
CSVDE Import or Export Active Directory data
Thursday, October 13, 2011
form upload image with PHP
to upload a file or image is usually in PHP usually people think veryhard but this time it will no longer
try to download below
try to download below
Monday, July 25, 2011
How to Set IP Address and Other Network Information in Windows XP
1) Go to Start and click on Control Panel.
2) Control Panel window will appear. Double click on Network Connections.
3) Network Connections window will appear. Right click correct Local Area Connection by identifying correct network card and click Properties.
4) Select Internet Protocol (TCP/IP). Click on Properties.
Manual IP Assigning
You can now key in the IP address, Subnet mask, Default gateway and DNS servers. Here is IP logical network Designing Guide.
Note: IP address of your computer must be unique. None of the 2 computers in the network can share same IP address, it causes IP address conflict.
Note: Default gateway is a router that can route the traffic to the other network or Internet. DNS server is an application server that can translate URL to IP address. As an example, www.cert.org is URL and it can be translated to 192.88.209.6 by DNS server. Check with your ISP on what DNS servers you should use. If not, you can try this free Opendns.
IP Assigned by DHCP server
If you have DHCP server setup on your router or you have DHCP server in home network, your computer can be assigned IP address automatically by selecting Obtain an IP address automatically and Obtain DNS server address automatically.
You can also check out simple way to check IP address after knowing the way to set IP.
Note: If you have a notebook, using static IP at home and the IP assigned by DHCP server at the office, you can make use of alternate configuration to set IP and network information for these 2 different network.
Set Obtain an IP address automatically on General tab which is same as what I specified above, so that the notebook will be assigned IP addresses automatically at the office. After that, click Alternate Configuration tab, select User configured option and key in your home network’s static IP information. By setting this, when there is no IP information assigned due to no DHCP server at home, this alternate configuration will be applied automatically, so that you don’t have to set IP manually every time at home.
2) Control Panel window will appear. Double click on Network Connections.
3) Network Connections window will appear. Right click correct Local Area Connection by identifying correct network card and click Properties.
4) Select Internet Protocol (TCP/IP). Click on Properties.
Manual IP Assigning
You can now key in the IP address, Subnet mask, Default gateway and DNS servers. Here is IP logical network Designing Guide.
Note: IP address of your computer must be unique. None of the 2 computers in the network can share same IP address, it causes IP address conflict.
Note: Default gateway is a router that can route the traffic to the other network or Internet. DNS server is an application server that can translate URL to IP address. As an example, www.cert.org is URL and it can be translated to 192.88.209.6 by DNS server. Check with your ISP on what DNS servers you should use. If not, you can try this free Opendns.
IP Assigned by DHCP server
If you have DHCP server setup on your router or you have DHCP server in home network, your computer can be assigned IP address automatically by selecting Obtain an IP address automatically and Obtain DNS server address automatically.
You can also check out simple way to check IP address after knowing the way to set IP.
Note: If you have a notebook, using static IP at home and the IP assigned by DHCP server at the office, you can make use of alternate configuration to set IP and network information for these 2 different network.
Set Obtain an IP address automatically on General tab which is same as what I specified above, so that the notebook will be assigned IP addresses automatically at the office. After that, click Alternate Configuration tab, select User configured option and key in your home network’s static IP information. By setting this, when there is no IP information assigned due to no DHCP server at home, this alternate configuration will be applied automatically, so that you don’t have to set IP manually every time at home.
Friday, March 11, 2011
How to Make IP By Text: and grafis
How to Make IP By Text:
1. Open up Terminal dg clicking Applications and then select Acessoris and click Terminal.
2. Then go pd dg Root login SU typing commands and enter the password.
3. Type lspci to find out whether the computer Ethernet card is active or detected.
4. Then type ifconfig.
5. After that, type the IP number that will be made dg typing ifconfig eth0 xxx.xxx.xxx.xxx (the IP number).
How to Make IP In Graphics:
1. Select Desktop and then select Administration then select and click on Networking.
2. If the exit command dialog box to enter a password then entering the password of your root.
3. In the Connection dialog box click 2x on an Ethernet Connection or dg can also click on the Properties box.
4. In Configuration select Static IP Address.
5. Then in the IP Address box: write an IP number that will be made.
6. And in the Subnet Mask box will automatically exit from the Subnet Mask number after we write our IP numbers.
7. After that the Gateway Address box: write the number gateway.
8. Then click OK.
or dowload my file
make mikrotic
1. Open up Terminal dg clicking Applications and then select Acessoris and click Terminal.
2. Then go pd dg Root login SU typing commands and enter the password.
3. Type lspci to find out whether the computer Ethernet card is active or detected.
4. Then type ifconfig.
5. After that, type the IP number that will be made dg typing ifconfig eth0 xxx.xxx.xxx.xxx (the IP number).
How to Make IP In Graphics:
1. Select Desktop and then select Administration then select and click on Networking.
2. If the exit command dialog box to enter a password then entering the password of your root.
3. In the Connection dialog box click 2x on an Ethernet Connection or dg can also click on the Properties box.
4. In Configuration select Static IP Address.
5. Then in the IP Address box: write an IP number that will be made.
6. And in the Subnet Mask box will automatically exit from the Subnet Mask number after we write our IP numbers.
7. After that the Gateway Address box: write the number gateway.
8. Then click OK.
or dowload my file
make mikrotic
Thursday, March 10, 2011
mSQL connection to php
The author would like to present this simple article about how to connect from PHP to MySQL database. This is the result of some feedback that go into Sony AK Knowledge Center and we want to share it in writing. Moreover, there are a lot who are interested in web-based programming with open source solutions, because of free and cheap.
Preparation
In this case the author uses the Win32 version of Apache web server 1.3.33, Windows XP and PHP version 4.3.11. For MySQL, I use version 4.1.11 for Win32. Apache can you download at http://www.apache.org/, can be found at http://www.php.net/ PHP and MySQL can be downloaded from http://www.mysql.com/. The author assumes you've installed all these components and has been running well. Turn all the necessary services, to run the Apache service then type net start apache from the command prompt on Windows. Similarly to the MySQL service, type net start mysql from the command prompt to turn it on. After all ready let's make way connection from PHP to MySQL her.
Sample connection
To connect to MySQL there are two functions that can be used. The first is to use the function mysql_connect. Function syntax is as follows.
resource mysql_connect ([string server [, string username [, string password [, bool new_link [, int client_flags ]]]]])
Examples of its use are as follows.
$ conn = mysql_connect ('localhost', 'root', 'passwordku');
if (! $ conn) {
die ('Connection to MySQL failed:'. mysql_error ());
}
echo 'Connection to MySQL with mysql_connect success!';
mysql_close ($ conn);
?>
We see above there mysql_connect command whose main function is to connect to the MySQL database. As the above example the MySQL server is on localhost with the username root and password is passwordku. There are important notes to remember here. Since version 4.1, MySQL has been using a new system of authentication protocol based on hashing algorithms. This makes the connection using the old client will fail and will generate an error message like the following.
Client does not support authentication protocol requested by server; Consider upgrading MySQL client
During the hold connection then this function will look for a persistent link else already connected to the host, username and password are the same. If the link is found then the identifier of the connection or link will be provided to the client and the client will not be entered into a new connection to the server dataase.
Connection to the database will not be closed when the execution of an SQL script is complete. In the mysql_connect function, the connection will be disconnected automatically shortly after a SQL script is executed. In the mysql_pconnect function, connection to the database will continue to occur and not be disconnected even if you use the mysql_close function.
Basic syntax of the use mysql_pconnect function is as follows.
resource mysql_pconnect ([string server [, string username [, string password [, int client_flags ]]]])
Example of PHP code it from mysql_pconnect function can be seen in the following code.
$ conn = mysql_pconnect ('localhost', 'root', 'ariesa2001');
if (! $ conn) {
die ('Connection to MySQL failed:'. mysql_error ());
}
echo 'Connection to MySQL successfully with mysql_pconnect!!';
?>
In PHP 5, for connection to MySQL already using MySQLi extension (whichabbreviation of MySQL Improved ) . Further information about this can be seen at www.php.net / MySQLi. Writing about these MySQLi hopefully we discuss on another occasion.
Thus the simple inscription on how to connect from PHP to MySQL. May be useful for you all. If any comments or suggestions can be sent to pratiwi.mileniawati @ gmail.com. To read other interesting sites please go to Sony AK Knowledge Center at the address http://www.sony-ak.com/.
Subscribe to:
Posts (Atom)