wahyu pramusinto network

Peluang Bisnis Online BlakBlakan

2011-07-14T23:36:00.002+07:00

Peluang Bisnis Online BlakBlakan apaan ya? ada yang tahu apa itu Peluang Bisnis Online BlakBlakan ?

Meriahkan pesta ulang tahun bersama garudafood

2011-04-17T21:44:00.000+07:00

Meriahkan pesta ulang tahun bersama garudafood

keyword di atas menjadi keyword yang sedang diburu oleh para blogger, selain keyword websasdesign.com cinta blogger. Kenapa demikian? karena kedua keyword itu menjadi target dalam kontes seo bulan april 2011 ini.
pesta ulang tahun bisa dimeriahkan oleh paket pesta ulang tahun dari garudafood. paket pesta ulang tahun dari garudafood banyak pilihannya. semua pilihan yang ada isinya banyak dan enak. anak-anak pasti suka jika orang tuanya meriahkan pesta ulang tahun bersama garudafood.
meriahkan pesta ulang tahun bersama garudafood menawarkan beragam paket bingkisan produk GarudaFood untuk pesta ulang tahun anggota keluarga Anda tercinta. Yang lebih spesial, paket bingkisan dikemas dengan menarik, harganya terjangkau, berkualitas karena merupakan produk-produk unggulan GarudaFood dan dapat dipesan secara online untuk mempermudah Anda tanpa harus jauh-jauh dari meja Anda.

Websasdesign.com Cinta Blogger

2011-04-14T09:25:00.000+07:00

Websasdesign.com Cinta Blogger

websasdesign.com cinta blogger merupakan pecinta blogger karena menyediakan domain dan hosting dengan harga murah dan terjangkau untuk blogger.

blogger mencintai websasdesign.com karena websasdesign.com merupakan salah satu web hosting terpercaya sejak tahun 2008.

websasdesign.com cinta blogger juga mengijinkan blogger menginstall script auto content pada hosting yang dibeli di websasdesign.com. Sementara di penyedia hosting lainnya script auto content tidak boleh digunakan.

websasdesign.com telah memiliki banyak pelanggan sampai saat ini dan jumlah pelanggan makin bertambah hingga sekarang.

MP3 Search Engine

2010-12-23T14:11:00.000+07:00

MP3 Search Engine

bukti pembayaran dari neobux

2010-10-21T18:17:00.000+07:00

Hosting Murah Indonesia Indositehost.com

2010-07-05T22:59:00.000+07:00

Hosting Murah Indonesia Indositehost.com merupakan perusahaan hosting di indonesia yang menyediakan domain dan hosting murah

universitas komputer

2010-06-14T13:12:00.000+07:00

toko komputer online

kami menyediakan

komputer murah

laptop murah

ipad

2010-05-12T13:04:00.005+07:00

do you have ipad? you can buy ipad by click above link.
Technical Details
9.7-inch (diagonal) LED-backlit glossy widescreen Multi-Touch display with IPS technology. 1024-by-768-pixel resolution at 132 pixels per inch (ppi).
16GB flash drive with 1Ghz Apple A4 custom-designed system on a chip.
Wi-Fi (802.11a/b/g/n) Bluetooth 2.1 + EDR technology
Box Contents:iPad Dock Connector to USB Cable 10W USB Power Adapter Documentation
› See more technical details

--------------------------------------------------------------------------------
Product Details
Product Dimensions: 9.6 x 7.5 x 0.5 inches ; 1.5 pounds
Shipping Weight: 4 pounds
Shipping: Currently, item can be shipped only within the U.S.
ASIN: B002C7481G
Item model number: 16GB WiFi
Average Customer Review: 3.4 out of 5 stars See all reviews (106 customer reviews)
106 Reviews
5 star: (36)
4 star: (24)
3 star: (13)
2 star: (10)
1 star: (23)

› See all 106 customer reviews...
› See all 21 discussions...

Amazon.com Sales Rank: #8 in Computer & Accessories (See Bestsellers in Computer & Accessories)
Popular in this category: (What's this?)

#1 in Electronics > Computers & Accessories > Tablets

Date first available at Amazon.com: January 27, 2010

Would you like to update product info or give feedback on images?

--------------------------------------------------------------------------------

Product Description
Product Description
A magically and revolutionary product at an unbelievable price.

university domain changes nobility

2010-05-12T12:42:00.001+07:00

university domain changes nobility
by away, under blogs, university nobility
been years since I entered college in 2003 S1, the university has a nobility in http://www.bl.ac.id website address. And in 2010 this was changed to a domain name http://budiluhur.ac.id

But for the changes are not made permanent, but slowly. The old domain is still used, but when the visitors went into www.bl.ac.id will immediately be redirected to new domain http://budiluhur.ac.id

So, if you are a university student nobility .. Biasain open a new domain address is yes ...

http://budiluhur.ac.id

translated from http://away.web.id/perubahan-domain-universitas-budi-luhur/ with google translate

astaga.com lifestyle on the net

2010-01-27T18:15:00.000+07:00

astaga.com lifestyle on the net: "Astaga.com lifestyle on the net ingin reborn astaga.com dengan keyword astaga.com lifestyle on the net"

nowgoogle.com adalah multiple search engine popular

2010-01-27T12:52:00.000+07:00

nowgoogle.com adalah multiple search engine popular: "nowgoogle.com adalah multiple search engine popular yang digunakan untuk mencari di berbagai search engine popular lain"

aku cuma seorang blogger yang cinta seo

2010-01-14T11:30:00.000+07:00

aku menjadi seorang blogger pecinta seo karena aku tertarik menjadi master seo. aku cuma seorang blogger yang cinta seo dan memang berniat menjadi pakar seo. banyak orang yang tadinya cuma blogger cinta seo dan akhirnya menjadi master seo. mereka belajar seo secara otodidak, tapi ada juga yang belajar dari lembaga yang memang mempunyai sertifikasi seo

aku cuma seorang blogger yang cinta seo

2010-01-07T16:42:00.000+07:00

sebagai seorang blogger, saya harus mendapatkan traffic dengan tehnik seo yang saya miliki. aku cuma seorang blogger yang cinta seo dan ingin menjadi master seo dan master blogger

instalasi windows xp

2010-01-07T15:01:00.000+07:00

cara instalasi windows xp

untuk instalasi windows xp diperlukan sebuah cd instalasi
cara install windows xp

ngobrol seputar bisnis online

2009-12-08T18:16:00.000+07:00

ayo dukung saya dalam kontes seo ngobrol seputar bisnis online

jual beli saldo paypal

2009-11-12T09:10:00.002+07:00

siapa yang sedang butuh saldo paypal?
siapa yang ingin menjual saldo paypal?

saya beli saldo paypal anda dengan harga tinggi
saya jual saldo paypal saya dengan harga murah

jika tertarik, baca jual beli paypal

kontes seo kartu pulsa

2009-11-04T18:39:00.001+07:00

Ayo dukung blogku yang lain untuk ikutan kontes SEO. kali ini temanya adalah Kartu-Pulsaku.com Solusi Bisnis Online Anda. ikutan kontes Kartu-Pulsaku.com Solusi Bisnis Online Anda untuk iseng-iseng aja koq

download lagu kpk di dadaku

2009-11-04T15:43:00.002+07:00

musicians in Indonesia create tracks to support kpk (komisi pemberantasan korupsi). they created a song titled "KPK di dadaku". download song kpk di dadaku now!!

test postingan

2009-10-01T19:43:00.000+07:00

this is test

How to be Wealthier

2009-06-20T21:47:00.001+07:00

If you can't afford a vacation home, you're certainly not alone. But many people opt for the next best thing...owning a share of a vacation home or condo that you visit once a year. They're called time shares. Are they for you?.

my article in google translate

2009-01-20T16:56:00.003+07:00

I just opened my website is a long time, and in fact one of the articles there have been translated from English into English. I already have other people who use google translate to translate the page. Original title is cara instalasi xampp
And this is a version of the translation in the English language

XAMPP is an installation package for PHP, Apache and MySQL. By using XAMPP, we do not need to be bothered to install the software that third separately.XAMPP can be downloaded at http://www.apachefriends.org/en/index.html.Here is how to install XAMPP.

Run the file xampp-Win32-1.4.12-installer.exe (or other version)

Then will appear to select a language option during installation to run.Please select the English language or English, unless you take another language. In this example I choose the English language because I love English.

The installation will start. Click forward to get started.

Akan appear license software. Please read it if you want, but I prefer not to read it because too many. Click I Agree to continue.

Then please select your location to install XAMPP. Then click install

Wait a while until the installation is complete.

Installation finished

Until this stage, we have installed XAMPP. That means we have finished installing PHP, Apache and MYSQL. The next step is to run servicenya.

Run the XAMPP Control Panel on the desktop. Or you can also run the XAMPP Control Panel from the Start menu -> All Programs -> apachefriends -> xampp -> xampp control panel.

Turn on Apache and Mysql by clicking the Start button. Open your web browser, and type http://localhost. If it looks like below, then apache is installed correctly.

As information only, document property XAMPP root folder is located on the E: \ Program Files \ apachefriends \ xampp \ htdocs. This is because I install XAMPP folder on the E: \ Program Files \ apachefriends.

you can view the complete article in english here

how to get number of days in the month with php

2009-01-12T11:24:00.000+07:00

if you want to know number of days in the month with php, you can call function cal_days_in_month()
this function returns the number of days in a given month, based on the calendar, month, and year that you specify

the format of this function is
Cal_days_in_month (calendar, Month, year)
This function have three parameters,

calendar, you can fill this parameter with CAL_GREGORIAN
month, you can fill this parameter with month (1 - 12)
year, you can fiil this parameter with 4 digits of year (2008)

example :
$days = cal_days_in_month(CAL_GREGORIAN, 1, 2009) ;
echo "In January 2009 there were $days days";
?>

that example will display
In january 2009 there were 31 days

calculate age with mysql

2008-12-31T09:33:00.004+07:00

you can use mysql to determine how many years old of your employee is. This is just compute the difference in the year part of the current date and the birth date, then subtract one if the current date occurs earlier in the calendar year than the birth date. The following query shows, for each employee, name, birth date, the current date, and the age in the years. In this example I use table employee which has fields : employee_id, employee_name, birthdate

SELECT employee_id, employee_name, birthdate, CURDATE(),
(YEAR(CURDATE())-YEAR(birthdate))
- (RIGHT(CURDATE(),5)<RIGHT(birthdate,5))
AS age
FROM employee

instalasi java di microsoft windows xp

2008-12-07T16:12:00.002+07:00

Java di sini bukan berarti pulau jawa, bahasa jawa maupun hal-hal yang berhubungan dengan jawa. Java di sini adalah sebuah bahasa pemrograman yang digunakan untuk membuat aplikasi berbasis desktop maupun berbasis web.

Di sini saya tidak akan menjelaskan tentang bagaimana membuat hello world di java atau bagaimana cara membuat aplikasi java dengan koneksi database mysql.

Yang akan saya jelaskan di sini adalah bagaimana cara menginstall program java ke dalam komputer yang berbasis Microsoft Windows XP.

Instalasi Java di Microsoft Windows XP

Sebelum melakukan instalasi pastikan Anda sudah mempunyai installer java. Jika belum punya, download java versi terbaru di sun.com. Dalam praktek kali ini saya menggunakan java versi 6. Langkah yang ada di tutorial ini mungkin saja berbeda jika Anda menggunakan java versi lainnya

download terlebih dahulu installer java di sun.com. Yang saya gunakan di sini adalah java versi 6. Jika sudah didownload, klik 2 kali untuk mulai instalasi Klik Next melanjutkan

Muncul License Aggrement. Sebaiknya Anda baca isinya terlebih dahulu. Jika setuju dengan isinya klik Accept. Jika tidak setuju klik Decline.

Tentukan fitur apa saja yang akan diinstall. Ada Development Tools, Demos and Samples, Source Code, Public JRE dan java DB. Secara default semua fitur ini akan diinstal. Anda juga bisa menentukan letak instalasi. Secara default aka diinstal di C:\Program Files\Java\jdk1.6.0_04. Anda bisa mengubah letaknya dengan mengklik Change. Klik Next untuk melanjutkan

Instalasi akan berjalan. Tunggu beberapa saat

Selanjutnya instalasi Java Runtime Environment. JRE ini diperlukan agar java bisa berjalan di windows. Klik Next untuk melanjutkan

Instalasi akan dilanjutkan kembali. Tunggu beberapa saat sampai selesai

Proses instalasi selesai. Klik Finish

Blogger, Let's protect your idea

2008-11-06T05:46:00.001+07:00

Jakarta - Internet technology that lead to developing a new lifestyle, including the development of content. Unfortunately, many developers content including blogs that have not yet know that his work is protected by law when dikomersilkan.

According to Andi Noorsaman Sommeng, Director General of the Department of Property Rights Law and Human Rights, the profits from developing content on the internet can indeed berpromosi free. Still, the creators can only prosecute the people who commercialize the content buatannya.

"What rights will be taken they take, but if the creator does not want to prosecute not do anything," he said, on the sidelines of the Asia-Pacific Symposium World Intelectual Property Organization, which takes place at the Mercure Hotel Ancol, Jakarta.

Rights are protected under Law 19 of 2002 on Copyright, the threat maximum fine of Rp 5 billion and a month in jail. "So there is a publication that, without the need to register • DEPKUMHAM perlindungannya already there," Andi supplement.

Unfortunately, other than the ringback tone content developers, content developers many other bloggers still have not been particularly aware that his work is protected by law. "It is not yet well, the problem of the people of Indonesia and many geographically separated. Hence this symposium aims to create public awarness that, "said Andi.

This law is the product while protecting foreign downloaded through the Internet. "Haki this law applies to members of WIPO because resiprokal system. If we protect their product, the product we also protected by the Law on them, "he continued.

WIPO is an organization under the auspices of the United Nations the right to manage the Intellectual Property (IP). This organization has 180 members around the country.

The symposium itself Andi claimed as the first in the world. Selection of Indonesia as the host because it is based because the U.S. considered superior in the development of content compared to other countries.

"You see, if indeed we lose the software with our hardware, while India lost to Singapore. But if Indonesia ideally in the content, try the song-hardened players who often played in other countries, that can be protected, "Andi umbar.

Meanwhile, WIPO consultant for the Asia Pacific Candra N. Darusman said, so far in Indonesia have not been many reports of violations related to User Generated Content (UGC). "But this issue will be dominant in the next 5 years. The most protected are the creator of songs, and recording companies who have content, "Andi also

diterjemahkan dari http://away.blogsome.com/2008/02/21/bloger-ayo-lindungi-karyamu/
dengan google translate

competition in the world of work

2008-11-01T16:33:00.002+07:00

Should all colleagues is one unit. Fellow co-worker, we must please help. However, not all will forever walk like that. Sometimes there is only a side-sikut there. Jelekkan made in the other fellow, and others like it. Perhaps the person who made jelekkan (abbreviated OYM about) was not able to compete with colleagues who dijelek-jelekkan (abbreviated RYD about).

Fellow co-worker, we can compete. Objectives of this competition are manifold. One to show the boss that we can do the job given to the good. Such competition is a healthy competition. Using a way that positively. Consequently, productivity will be increased.

However, there is only competition that is not healthy. For example of that was made jelekkan friend sekantor. If it happens, so be it, productivity will decrease because a fellow worker colleagues there is no atmosphere of harmony. Mutual blame themselves and feel the most correct. If we feel is correct, we should just concede defeat.

Who Ngalah senses:-p

But most ngalah, can diinjek-injek
If it happens, the supervisors must act immediately.

NB:

* Posts side, this is not the author
* I wish that the competition is not healthy this does not occur in the Air Force and other offices.

diterjemahkan dari persaingan dalam dunia kerja
dengan google translate

funtastic dolphin show

2008-11-01T11:11:00.002+07:00

Hamilton again briefly in the event that any of the title I think it's a good event. Funtastic Dolphin Show . Edutainment is the theme. Funtastic Dolphin Show. "That I end, it's the performance dolphins. But strange events that are not held in Ancol, but in the field castle beta (Hamilton), close to home like "Socialism or DEATH caplang. In the field, established a special building for the exposition. Seperti apa ya acaranya? As the program do? What also take lumbanya-racing?

For the curious, and would also watching. We start date will be held on March 14 2008 - 20 April 2008 at the castle beta II field, Hamilton.

diterjemahkan dari funtastic dolphin show
dengan google translate

Buka puasa

2008-09-21T20:48:00.001+07:00

Buka puasa bersama di pondok lesehan ikan bakar 'lubuk idai'

Sony ericsson j200

2008-09-19T16:26:00.001+07:00

This is my old sony ericsson j200

ADOdb Database Abstraction Library for PHP (and Python)

2008-07-18T13:27:00.000+07:00

ADOdb is a database abstraction library for PHP. There is also a Python version; see the ADOdb for Python docs.

The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions. Here is the complete list of drivers.

Many popular web applications such as ACID, PostNuke, Xaraya, phpWiki, Mambo, PHP GACL, TikiWiki, eGroupWare and phpLens App Server are using ADOdb as their database abstraction layer. Some reasons why ADOdb is popular include:

* Designed for speed. It is probably the fastest open source database abstraction library available for PHP. See benchmarks.
* Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
* Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
* Easy to learn, especially if you have Window's programming experience, as it uses many ADO conventions.
* Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
* Mature, continiously developed since August 2000. Has a large community of users.
* Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release. Also dual-licensed (Lesser GPL).

http://adodb.sourceforge.net/

Tutorial Instalasi Wordpress di komputer pribadi

2008-04-26T14:16:00.005+07:00

Untuk menginstall Wordpress di komputer pribadi, Anda harus menginstall software PHP, Apache dan MySQL. Atau jika tidak ingin repot, silakan install XAMPP. Anda juga membutuhkan wwordpress versi terbaru. Di sini saya menggunakan wordpress versi 2.5. Setelah berhasil mendownload ekstrak wordpress ke dalam document root apache Anda. Jika Anda menggunakan XAMPP, maka document root biasanya terletak di c:/xampp/htdocs atau c:/program files/apache/htdocs. Dalam tutorial ini saya akan mengekstrak wordpress ke dalam folder wordpress25.

Berikut ini adalah langkah-langkah menginstall wordpress di komputer pribadi
1. Buka browser favorit anda dan ketikkan http://localhost/wordpress25. Ini adalah tampilan dari halaman awal instalasi wordpress

2. Klik Create a Configuration File.

3. Klik Let’s go. Masukkan konfigurasi database mysql. Nama database, username, password, lokasi database dan table_prefixs

4. Klik Submit. Jika settingan database sudah benar, akan tampil halaman berikut

5. Klik Run the Install. Masukkan judul blog dan email Anda pada tampilan di bawah ini

6. Klik Install Wordpress. Catat username dan password yang diberikan

7. Sampai di sini kita telah berhasil menginstall wordpress. Untuk melihat hasilnya, ketik lagi http://localhost/wordpress25 pada browser.

8. Untuk mengedit, menambah content, kita harus masuk ke halaman admin. Ketikkan http://localhost/wordpress25/wp-admin pada browser.

9. Masukkan username dan password yang tadi diberikan. Klik Login. Jika username dan password benar, kita akan menuju halaman Dashboard

Jquery and Ajax

2008-02-29T08:47:00.000+07:00

http://docs.jquery.com/Ajax/jQuery.ajax

Load a remote page using an HTTP request.
This is jQuery's low-level AJAX implementation. See $.get, $.post etc. for higher-level abstractions that are often easier to understand and use, but don't offer as much functionality (such as error callbacks).

Warning: All POST are converted to GET when 'script' is the dataType.(because it loads script as a dom script tag)

$.ajax() returns the XMLHttpRequest that it creates. In most cases you won't need that object to manipulate directly, but it is available if you need to abort the request manually.

Note: If you specify the dataType option described below, make sure the server sends the correct MIME type in the response (eg. xml as "text/xml"). Sending the wrong MIME type can lead to unexpected problems in your script. See Specifying the Data Type for AJAX Requests for more information.

$.ajax() takes one argument, an object of key/value pairs, that are used to initialize and handle the request. See below for a full list of the key/values that can be used.
As of jQuery 1.2, you can load JSON data located on another domain if you specify a JSONP callback, which can be done like so: "myurl?callback=?". jQuery automatically replaces the ? with the correct method name to call, calling your specified callback. Or, if you set the dataType to "jsonp" a callback will be automatically added to your Ajax request.

e-government

2008-02-29T08:23:00.001+07:00

from wikipedia
http://en.wikipedia.org/wiki/E-Government

e-Government (from electronic government, also known as e-gov, digital government, online government or in a certain context transformational government) refers to government’s use of information technology to exchange information and services with citizens, businesses, and other arms of government. e-Government may be applied by the legislature, judiciary, or administration, in order to improve internal efficiency, the delivery of public services, or processes of democratic governance. The primary delivery models are Government-to-Citizen or Government-to-Customer (G2C), Government-to-Business (G2B) and Government-to-Government (G2G) & Government-to-Employees (G2E).
Within each of these interaction domains, four kind of activities take place[1] The simplest type of activity is to provide information over the Internet, such as regulatory services, general holidays, public hearing schedules, issue briefs, notifications, etc. The second type of activity allows two-way communicationsbetween the agency and the citizen, a business, or another government agency. In this model, users can engage in dialogue with agencies and post problems, comments, or requests to the agency. The third form of activity that takes place over the Internet involves conducting transactions. The final and fourth form of activity that takes over the web centres on governance, e.g., online polling, voting, and campaigning.
The most important anticipated benefits of e-government include improved efficiency, convenience, and better accessibility of public services.

While e-government is often thought of as "online government" or "Internet-based government," many non-Internet "electronic government" technologies can be used in this context. Some non-internet forms include telephone, fax, PDA, SMS text messaging, MMS, wireless networks and services, Bluetooth, CCTV, tracking systems, RFID, biometric identification, road traffic management and regulatory enforcement, identity cards, smart cards and other NFC applications; polling station technology (where non-online e-voting is being considered), TV and radio-based delivery of government services, email, online community facilities, newsgroups and electronic mailing lists, online chat, and instant messaging technologies. There are also some technology-specific sub-categories of e-government, such as m-government (mobile government), u-government (ubiquitous government), and g-government (GIS/GPS applications for e-government).

There are many considerations and potential implications of implementing and designing e-government, including disintermediation of the government and its citizens, impacts on economic, social, and political factors, and disturbances to the status quo in these areas.

In countries such as the United Kingdom, there is interest in using electronic government to re-engage citizens with the political process. In particular, this has taken the form of experiments with electronic voting, aiming to increase voter turnout by making voting easy. The UK Electoral Commission has undertaken several pilots, though concern has been expressed about the potential for fraud with some electronic voting methods[2].
Contents
[hide]

* 1 History of E-Government
* 2 Development and implementation issues
* 3 See also
* 4 References
* 5 External links
o 5.1 eGovernment news websites
o 5.2 General resources

[edit] History of E-Government

[edit] Development and implementation issues

The development and implementation of e-government involves consideration of its effects on the organisation of the public sector (Cordella, 2007) and on the nature of the services provided by the state including environmental, social, cultural, educational, and consumer issues, among others.

Governments may need to consider the impact by gender, age, language skills, and cultural diversity, as well as the effect on literacy, numeracy, education standards and IT literacy. Economic concerns include the "Digital divide," or the effect of non-use, non-availability or inaccessibility of e-government, or of other digital resources, upon the structure of society, and the potential impact on income and economics.

Economic and revenue-related concerns include e-government's effect on taxation, debt, Gross Domestic Product (GDP), commerce and trade, corporate governance, and its effect on non-e-government business practices, industry and trade, especially Internet Service Providers and Internet infrastructure.

From a technological standpoint, the implementation of e-government has effects on e-enablement, interoperability (e.g., e-GIF) and semantic web issues, "legacy technology" (making "pre-eGovernment IT" work together with or be replaced by e-government systems), and implications for software choices (between open source and proprietary software, and between programming languages) as well as political blogging especially by legislators.

There are also management issues related to service integration, local e-government, and Internet governance including ICANN, IETF and W3C, and financial considerations, such as the cost of implementation / effect on existing budgets, effect on government procurement, and funding.

Legal implications include freedom of information and privacy (e.g. UK Data Protection Act) concerns.

The phrase "e-government" has been a rallying cry for public sector modernization since the 90's, but for many it is now losing its appeal as a slogan or concept. This trend has various drivers. Firstly, there is a wish to mainstream e-government so that best use of technology is integrated into all public sector activity rather than seen as a special interest or add-on. Secondly, many administrations recognise the importance of linking e-government to wider public sector change programmes. Thirdly, the phrase e-government is itself not particularly useful in motivating a change programme. These sorts of considerations have led countries such as the UK to talk of transformational government rather than e-government. Finally, there is the issue of the implications for the public sector of Web 2.0 [3]. All these considerations suggest that e-government is entering a new phase and one in which the term "e-government" is itself becoming less popular.

Javascript Explode Implode

2008-02-19T10:33:00.003+07:00

JavaScript equivalent of PHP explode function

In PHP we can easily break a long string into smaller parts by using the explode() function of PHP. In run rime, this function works like this:

$string="My Name Is Wahyu Pramusinto";
$string2=explode(" ", $string);

After the execution of the second command the variable $string2 is an array such that,

$string2[0]="My"
$string2[1]="Name"
$string2[2]="Is"
$string2[3]="Wahyu"
$string2[4]="Pramusinto"

and so on. So how do we do it in JavaScript. In JavaScript there is a split() function that achieves the same objective, although the syntax is a bit different.

var string="My Name Is Wahyu Pramusinto";
var string2=string.split(" ");

Now the variable string2 has all those words.

How to install windows xp (page 2)

2008-02-08T09:55:00.001+07:00

Sebelum masuk ke tutorial ini, ada baiknya Anda membaca tutorial bagian pertama. Jika sudah membaca bagian pertama, sekarang saya lanjutkan lagi.

Selanjutnya Windows akan meng-copy file-file yang dibutuhkan ke dalam harddisk anda. Proses ini membutuhkan waktu yang agak lama.

Selama proses itu berlangsung, akan muncul beberapa Window untuk konfigurasi. Yang pertama adalah Regional and Language Options.

Klik tombol "Customize" untuk memilih Negara, bahasa dan lainnya. Jika sudah, tekan OK

Pilih Next. Kemudian Windows akan menanyakan nama dan organisasi Anda.

Jika sudah mengisi nama dan organisasi, tekan tombol Next

Selanjutkan anda akan diminta untuk memasukkan serial number. Isilah dengan serial number yang anda miliki.

Jika Anda salah memasukkan serial number, makan akan muncul pesan Error dan proses instalasi tidak akan dilanjutkan sampai anda memasukkan serial number dengan benar. Jika sudah benar tekan Next

Selanjutnya akan muncul tampilan layar Computer and Administrator Password

masukkan nama computer, dan password untuk user administrator. Gunakan password yang mudah diingat. Selanjutnya tekan Next

Kemudian akan muncul layar Date and Time Setting.

Masukkan tanggal dan jam dengan benar. Kemudian tentukan juga TimeZone anda.

Klik tombol Next lagi

Selanjutnya adalah mengkonfigurasi network. Tapi langkah ini akan saya lanjutkan di bagian ketiga.

How to install windows XP (page 1)

2008-02-06T08:18:00.001+07:00

Berikut ini saya sajikan tutorial untuk menginstall windows XP. Untuk menginstall Windows XP kita membutuhkan sebuah komputer dan CD Windows XP. Selain itu sebaiknya siapkan cemilan karena proses instalasi ini akan membutuhkan waktu lama.

Siapkan CD Windows XP lengkap dengan Serial Number nya

Siapkan juga Driver Motherboard agar semua hardware yang ada bisa bekerja secara optimal nantinya

Pastikan computer Anda sudah disetting untuk booting dari CD ROM, kalau belum, silakan ubah melalui BIOS

Boot (nyalakan) komputer anda dan masukkan CD Windows XP

Tunggu beberapa saat sampai muncul tulisan "Press any key to boot from CD" di layar monitor anda.

Silakan tekan "Enter" atau sembarang tombol

Selanjutnya proses instalasi akan mengecek konfigurasi hardware KOMPUTER anda

Akan muncul tulisan "Windows Setup" di bagian kiri atas layar yang berwarna biru.

File-file yang ada di CD ROM akan diload ke dalam memori dalam proses instalasi ini. Selanjutnya layar "Welcome To Set Up Windows" akan tampil.

Tekan "ENTER" untuk menginstall WINDOWS XP. Tekan "R" untuk merepair Windows XP. atau Tekan "F3" untuk keluar dari proses instalasi. Di sini saya akan menekan "Enter" karena kita akan menginstall Windows XP

Selanjutnya akan muncul EULA (End User License Aggrement). Silakan baca dulu dan tekan "F8" jika anda setuju. Atau tekan "ESC" jika tidak setuju dengan isinya

Jika Anda setuju, selanjutnya proses instalasi akan mencari dan membaca partisi harddisk anda

Akan ditampilkan semua partisi harddisk Anda. Anda bisa mengatur partisi harddisk di sini. Untuk mengintall WINDOWS XP, setidaknya kita butuh 1 buah partisi.

untuk membuat partisi baru di area harddisk yang masih kosong, tekan "C". Untuk menghapus partisi yang dipilih, tekan "D". Hati-hati dalam melakukan penghapusan partisi, karena hal ini bisa saja menyebabkan data anda hilang. Setelah partisi dibuat, langkah selanjutnya adalah menentukan di partisi mana WINDOWS XP akan diinstall (biasanya di partisi C). Tekan "ENTER"

Selanjutnya akan permintaan apakah Anda akan memformat partisi yang tadi.

Disarankan untuk memilih NTFS File System

Partisi yang akan digunakan untuk lokasi penginstallan windowws XP anda akan diformat

Setelah harddisk diformat, setup akan mengcopy semua file yang dibutuhkan ke dalam memori. Proses ini akan membutuhkan waktu yang cukup lama.

Sesudah semua file sudah tercopy ke harddisk, setup akan mereboot computer anda

Setelah reboot, akan muncul lagi tulisan "Press Any Key to boot from CD". Kali ini jangan tekan tombol apapun, karena jika kita menekan tombol, kita akan kembali ke proses awal instalasi. Jika Anda tidak menekan tombol apapun, Windows akan tampil di layar secara otomatis

Untuk sementara sekian dulu tahapan instalasi windows xp berhubung akan ada pemadaman listrik dari PLN. Kapan-kapan disambung lagi.

Introduction CakePHP

2008-01-30T10:17:00.000+07:00

Introduction to CakePHP
Section 1
What is CakePHP?

CakePHP is a free open-source rapid development framework for PHP. Its a structure of libraries, classes and run-time infrastructure for programmers creating web applications originally inspired by the Ruby on Rails framework. Our primary goal is to enable you to work in a structured and rapid manner - without loss of flexibility.
Section 2
Why CakePHP?

CakePHP has several features that make it a great choice as a framework for developing applications swiftly and with the least amount of hassle. Here are a few in no particular order:

1.

Active, friendly community
2.

Flexible Licensing
3.

Compatibility with PHP4 and PHP5
4.

Integrated CRUD for database interaction and simplified queries
5.

Application Scaffolding
6.

Model View Controller (MVC) Architecture
7.

Request dispatcher with good looking, custom URLs
8.

Built-in Validation
9.

Fast and flexible templating (PHP syntax, with helpers)
10.

View Helpers for AJAX, Javascript, HTML Forms and more
11.

Security, Session, and Request Handling Components
12.

Flexible access control lists
13.

Data Sanitization
14.

Flexible View Caching
15.

Works from any web site subdirectory, with little to no Apache configuration involved

Section 3
History of CakePHP

In 2005, Michal Tatarynowicz wrote a minimal version of a Rapid Application Framework in PHP. He found that it was the start of a very good framework. Michal published the framework under the MIT license, dubbing it Cake, and opened it up to a community of developers, who now maintain Cake under the name CakePHP.
print chapter

source : http://manual.cakephp.org/chapter/intro, ajax

CodeIgniter

2008-01-28T08:31:00.000+07:00

Welcome to CodeIgniter

CodeIgniter is an Application Development Framework - a toolkit - for people who build web sites using PHP. Its goal is to enable you to develop projects much faster than you could if you were writing code from scratch, by providing a rich set of libraries for commonly needed tasks, as well as a simple interface and logical structure to access these libraries. CodeIgniter lets you creatively focus on your project by minimizing the amount of code needed for a given task.

Please read the Introduction section of the User Guide to learn the broad concepts behind CodeIgniter, then read the Getting Started page.
Who is CodeIgniter For?

CodeIgniter is right for you if:

* You want a framework with a small footprint.
* You need exceptional performance.
* You need broad compatibility with standard hosting accounts that run a variety of PHP versions and configurations.
* You want a framework that requires nearly zero configuration.
* You want a framework that does not require you to use the command line.
* You want a framework that does not require you to adhere to restrictive coding rules.
* You are not interested in large-scale monolithic libraries like PEAR.
* You do not want to be forced to learn a templating language (although a template parser is optionally available if you desire one).
* You eschew complexity, favoring simple solutions.
* You need clear, thorough documentation.

http://codeigniter.com/user_guide/

Getting Started with jQuery

2008-01-07T09:05:00.000+07:00

This guide is an introduction to the jQuery library. Basic knowledge of JavaScript and the document object model (DOM) is required. It starts from ground up and tries to explain details where necessary. It covers a simple hello world example, selector and event basics, AJAX, FX and usage and authoring of plugins.

This guide contains no "click me" examples. The intention of providing only "copy me" code is to invite you to try it for yourself. Copy an example, see what it does, and modify it.

Setup

To start, we need a copy of the jQuery library, which we can get from the main download page. The jQuery Starterkit provides some markup and CSS to work with. After downloading and extracting its content we put jquery.js into the same directory and open starterkit.html and custom.js with our favorite editor and starterkit.html with a browser.

Now we have everything to start with the notorious "Hello world" example.

Hello jQuery

We start with an empty html page:


 <html>                                                                  
 <head>                                                                  
 <script type="text/javascript" src="jquery.js"></script>         
 <script type="text/javascript">                                         
   // we will add our javascript code here                                     
 </script>                                                              
 </head>                                                                 
 <body>                                                                  
   <--- we will add our HTML content here -->                                        
 <body>                                                                 
 <html>

This page just loads the jquery.js library (make sure the URL points to where you stored your copy of jquery! This example assumes that you store it in the same directory as this example file). Two comments indicate where we will expand this template with code.

As almost everything we do when using jQuery reads or manipulates the document object model (DOM), we need to make sure that we start adding events etc. as soon as the DOM is ready.

To do this, we register a ready event for the document.

$(document).ready(function() {
// do stuff when DOM is ready
});

Putting an alert into that function does not make much sense, as an alert does not require the DOM to be loaded. So lets try something a little more sophisticated: Show an alert when clicking the link.

$(document).ready(function() {
$("a").click(function() {
alert("Hello world!");
});
});

This should show the alert as soon as you click on the link.

Lets have a look at what we are doing: $("a") is a jQuery selector, in this case, it selects all a elements. $ itself is an alias for the jQuery "class", therefore $() constructs a new jQuery object. The click() function we call next is a method of the jQuery object. It binds a click event to all selected elements (in this case, a single anchor element) and executes the provided function when the event occurs.

This is similar to the following code:

Link

The difference is quite obvious: We don't need to write an onclick for every single element. We have a clean separation of structure (HTML) and behavior (JS), just as we separate structure and presentation by using CSS.

With this in mind, we explore selectors and events a little further.

J2ME

2007-12-05T08:44:00.000+07:00

Java 2 Micro Edition (J2ME) combines a resource-constrained JVM and a set of Java APIs for developing applications for mobile devices. This article is the first in a series. This time, after a quick introduction to J2ME, I will provide a step-by-step guide to creating J2ME applications, also known as MIDlets, using a simple example. This will cover how to test and deploy these MIDlets as well. Finally, I will round out this installment with a look at the lifecycle of a MIDlet.
J2ME Introduction

What is J2ME? Cut away the hype and the excess fat and you are left with yet another (set of) Java APIs. Since these APIs cannot run on a traditional Java Virtual Machine (JVM), due to the limited size of mobile devices in regards to memory and resource availability, J2ME defines a limited version of the JVM as well. In a nutshell:

J2ME combines a resource constrained JVM and a set of Java APIs for developing applications for mobile devices.

Do you, as a developer, have to install this JVM and the APIs on mobile devices? No. Device manufacturers install and prepackage their devices with this JVM (and associated APIs). As a developer, you only need to develop applications targeting these devices and install them. Easier said than done!

J2ME can be divided into three parts, as shown in Figure 1: a configuration, a profile, and optional packages. A configuration contains the JVM (not the traditional JVM, but the cut-down version) and some class libraries; a profile builds on top of these base class libraries by providing a useful set of APIs; and optional packages, are well, an optional set of APIs that you may or may not use when creating your applications. Optional packages are traditionally not packaged by the device manufacturers, and you have to package and distribute them with your application. The configuration and profile are supplied by the device manufacturers and they embedded them in the devices.

he most popular profile and configuration that Sun provides are the Mobile Information Device Profile (MIDP) and Connected Limited Device Configuration (CLDC), respectively. As the name suggests, CLDC is for devices with limited configurations; for example, devices that have only 128 to 512KB of memory available for Java applications. Consequently, the JVM that it provides is very limited and supports only a small number of traditional Java classes. (This limited JVM is actually called the KVM.) Its counterpart, the Connected Device Configuration (CDC) is for devices with at least 2MB of memory available and supports a more feature-rich JVM (but still not a standard JVM).

The MID profile complements the CLDC configuration very well because it minimizes both the memory and power required for limited devices. It provides the basic API that is used for creating application for these devices. For example, it provides the javax.microedition.lcdui package that allows us to create the GUI elements that can be shown on a (limited) device running the MID profile on top of a CLDC configuration. Note that MIDP cannot be used with CDC devices. CDC devices get their own set of profiles, like the Foundation and Personal profiles. However, I will not cover these profiles or the CDC here, and will concentrate on using MIDP and CLDC only.

The latest versions of MIDP and CLDC are 2.0 and 1.1, respectively. Not many devices currently support these versions, but the list is growing rapidly. Sun maintains a list of devices according to version.
Acquiring and Installing the J2ME Development Kit

Getting started with developing applications (henceforth called "MIDlets") for the J2ME platform is easy. Although device manufacturers install and prepackage their devices with this JVM (and associated APIs), you still need to install the J2ME Wireless Toolkit 2.2 on your development machine. Before that, however, you must also have the Java Development Kit (JDK), version 1.4.2 or greater, installed.

Warning: I had problems getting the Wireless Toolkit to work properly with JDK 5.0. If you don't need the latest features in version 5.0, it is best to stick to any 1.4.2 version. I have used 1.4.2_05 for all examples in this series.

You need this Toolkit because it contains tools that are important in generating MIDlets. This Toolkit provides the development environment for the MIDP 2.0 and CLDC 1.1 (and for MIDP 1.0 and CLDC 1.0, since these parameters are backwards compatible), and it provides the optional packages required for the optional libraries, like 3D and Mobile Media applications. Lastly, it provides the ability to sign your MIDlets so that they can be authenticated before installation on a remote mobile device.

Once you download the installation package for the Toolkit, install it in the directory of your choice. The default, on Windows, is C:\WTK22, and this will be the installation directory for the examples in this series as well. I will not explain the directories created under this folder just now. Before I do that, let us try and understand the process of generating a MIDlet from scratch.

Pages: 1, 2, 3

What is Ubuntu

2007-11-29T08:06:00.000+07:00

What is Ubuntu?

Ubuntu is a community developed operating system that is perfect for laptops, desktops and servers. Whether you use it at home, at school or at work Ubuntu contains all the applications you'll ever need, from word processing and email applications, to web server software and programming tools.

Ubuntu is and always will be free of charge. You do not pay any licensing fees. You can download, use and share Ubuntu with your friends, family, school or business for absolutely nothing.

We issue a new desktop and server release every six months. That means you'll always have the the latest and greatest applications that the open source world has to offer.

Ubuntu is designed with security in mind. You get free security updates for at least 18 months on the desktop and server. With the Long Term Support (LTS) version you get three years support on the desktop, and five years on the server. There is no extra fee for the LTS version, we make our very best work available to everyone on the same free terms. Upgrades to new versions of Ubuntu are and always will be free of charge.

Everything you need on one CD, which provides a complete working environment. Additional software is available online.

The graphical installer enables you to get up and running quickly and easily. A standard installation should take less than 25 minutes.

Once installed your system is immediately ready-to-use. On the desktop you have a full set of productivity, internet, drawing and graphics applications, and games.

On the server you get just what you need to get up and running and nothing you don't.

Reference : http://www.ubuntu.com/products/whatisubuntu

Moontox Bro, ada hubungan apa ya sama rontokbro?

2007-11-26T14:33:00.000+07:00

By: Hacker/Cracker Indonesia ]
---- Paraysutki #VM Community ----
[ SEND TO MALAYSIA/AUSTRALIA

Hentikanlah kebobrokan kalian --
Apa kalian tau rasanya menjadi manusia yang sia-sia?
Apa kalian tau rasanya setiap saat dihina dan tidak mampu merasakan kesenangan kalian?
Apa kalian tau betapa sakitnya kami (TKI) yang disiksa dan di perlakukan seperti binatang oleh majikan kalian? ditendang,dipukuli,dicaci maki,dihina,tidak digajih,dan pulang dengan anggota tubuh yg cacat? itulah yang kami dapatkan sehari-hari selama bekerja di sana
Aku yakin selama hidup kalian tidak pernah sedikitpun merasakan rasa sakit itu?

Wahai kalian yang ada di bumi ini
Kalian yang telah memojokanku dan Kalian yang telah merusak semua kesenanganku
Kalian hanya melihatku sebagai anak yang menyedihkan yang harus kalian singkirkan
kalian hanya memberiku satu-satunya jalan untuk membalas keputusan yang telah kalian buat

...Terima kasih...
kini kalian akan melihat darah di kedua tanganmu yang tak akan pernah bisa di bersihkan
dan kini aku akan hadir membangkitkan generasi yang lemah dan tak berdaya untuk melawan
!!! Bangkitlah Indonesia Raya, Bangsa dan Tanah Airku !!!

Itulah sebuah pesan yang berasal dari virus baru "Moontox Bro". Info lebih lengkapnya baca di sini. Melihat nama virus ini, jadi inget sama virus yang beberapa waktu lalu sempat ngetrend karena merepotkan semua orang, rontokbro. Apa ya hubungan mereka berdua?

Gak penting apa hubungan mereka berdua. Tapi yang jelas, kalo aku ngeliat dari vaksin.com, virus ini lebih berbahaya dibandingkan rontokbro. Kenapa aku bilang demikian? Karena di dalam keterangan vaksin.com, virus ini akan memformat semua partisi harddisk kecuali C:. bahaya bukan?

Kalo dilihat dari pesan yang ada di atas, virus ini berisi kecaman kepada Australia dan Malaysia yang telah berbuat semena-mena. Tapi sungguh aneh, kalo memang tujuannya untuk itu, kenapa virus ini disebarkan di Indonesia? Kenapa tidak disebarkan "hanya" di ke2 negara itu saja?

Btw, udah ada yang kena virus ini belum ya? Mudah2an seh belum ada. Oke, seperti kata pepatah lebih baik mencegah daripada mengobati. Sebelum virus menyerang, ada baiknya kita mencegahnya terlebih dahulu. Apa langkah-langkah yang harus dilakukan?
1. Matikan fasilitas autorun karena virus ini akan menyebar via USB.
2. Cegah file virus agar tidak bisa dieksekusi. Caranya : masuk ke Run -> gpedit.msc.
Akan muncul window Group Policy.

Kemudian masuk ke menu User Configuration -> Administrative Templates -> System. Kemudian di sebelah kanan ada list. Klik 2 kali pada tulisan. "Don't run Specified Windows application". Pilih "Enabled" dan klik tombol "Show". Klik tombol Add dan akan muncul sebuah window baru. Masukkan string Baca_Gue_Goblok.bat. Klik tombol OK. Lakukan hal yang sama untuk string Send To Hell.vbs dan juga Baca_GUe_Goblok.cmd.

Sesudah langkah-langkah di atas diikuti, selanjutnya tinggal berdoa aja. Mudah2an virus tidak akan menjangkiti komputer Anda. amin........

Antivirus Mahadewa.dll.vbs

2007-11-21T16:28:00.000+07:00

bagi yang membutuhkan antivurs untuk mahadewa, silahkan download di
http://groups.yahoo.com/group/virus-collector/files/CleanMaHaDeWa.exe
. Bagi yang mau virusnya silahkan download di http://groups.yahoo.com/group/virus-collector/files/VBS_MaHaDeWa.zip.

makasih untuk mas Harnanto, yang sudah membuat antivirus ini seperti yang ada di blog saya juga. http://away.blogsome.com/2006/11/25/virus-harus-dibasmi/#comment-445

Setelah saya coba, antivirus ini lumayan mujarab. Hanya saja Computer Name dan Organization berubah PJS atau PJB gitu. Tapi gak apa-apa. Bagus koq.... Kalo mau ubah computer name dan organization silakan masuk ke gpedit.msc aja.

Setting Up Your E-mail in Microsoft Outlook

2007-11-16T07:47:00.000+07:00

This tutorial shows you how to set up Microsoft Outlook to work with your e-mail account. This tutorial focuses on setting up Microsoft Outlook 2003, but these settings are similar in other versions of Microsoft Outlook. You can set up previous versions of Microsoft Outlook by using the settings in this tutorial.
To Set Up Your E-mail Account in Microsoft Outlook

1. In Microsoft Outlook, select Tools > E-mail Accounts.

2. On the E-mail Accounts wizard window, select "Add a new e-mail account" and click Next.

3. For your server type, select "POP3" and click Next.

4. # On the Internet E-mail Settings (POP3) window, enter your information as follows:

Your Name
Enter your first and last name.
E-mail Address
Enter your e-mail address.
User Name
Enter your e-mail address, again.
Password
Enter the password you set up for your e-mail account.
Incoming mail server (POP3)
Enter pop.secureserver.net for your incoming mail server.
Outgoing mail server (SMTP)
Enter smtpout.secureserver.net for your outgoing mail server.

Click "More Settings."

NOTE: "smtpout.secureserver.net" is an SMTP relay server. In order to use this server to send e-mails, you must first activate SMTP relay on your e-mail account. Log on to your Manage Email Accounts page to set up SMTP relay. If you do not have SMTP relay set up and your Internet Service Provider (ISP) allows it, you can use the outgoing mail server for your Internet Service Provider. Contact your Internet Service Provider to get this setting.

5. On the Internet E-mail Settings window, select the "Outgoing Server" tab.
6. Select "My outgoing server (SMTP) requires authentication."
7. If you did not change the SMTP relay section, select "Use same settings as my incoming mail server". If you changed the user name and password in the SMTP relay section of your Manage Email Accounts page, select "Log on using" and enter the user name and password. The following example assumes you did not change your SMTP relay section in your Manage Email Accounts page.

8. Select the "Advanced" tab and change the "Outgoing server (SMTP)" port to 80 or 3535.
9. Click OK

10. Click Next.

11. Click Finish

SELECT Syntax MySQL

2007-11-05T08:50:00.000+07:00


SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
      [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
    select_expr, ...
    [FROM table_references
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC], ...]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]
    [PROCEDURE procedure_name(argument_list)]
    [INTO OUTFILE 'file_name' export_options
      | INTO DUMPFILE 'file_name'
      | INTO var_name [, var_name]]
    [FOR UPDATE | LOCK IN SHARE MODE]]

SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries. See Section 12.2.7.3, “UNION Syntax”, and Section 12.2.8, “Subquery Syntax”.

The most commonly used clauses of SELECT statements are these:

*

Each select_expr indicates a column that you want to retrieve. There must be at least one select_expr.
*

table_references indicates the table or tables from which to retrieve rows. Its syntax is described in Section 12.2.7.1, “JOIN Syntax”.
*

The WHERE clause, if given, indicates the condition or conditions that rows must satisfy to be selected. where_condition is an expression that evaluates to true for each row to be selected. The statement selects all rows if there is no WHERE clause.

In the WHERE clause, you can use any of the functions and operators that MySQL supports, except for aggregate (summary) functions. See Chapter 11, Functions and Operators.

SELECT can also be used to retrieve rows computed without reference to any table.

For example:

mysql> SELECT 1 + 1;
-> 2

You are allowed to specify DUAL as a dummy table name in situations where no tables are referenced:

mysql> SELECT 1 + 1 FROM DUAL;
-> 2

DUAL is purely for the convenience of people who require that all SELECT statements should have FROM and possibly other clauses. MySQL may ignore the clauses. MySQL does not require FROM DUAL if no tables are referenced.

In general, clauses used must be given in exactly the order shown in the syntax description. For example, a HAVING clause must come after any GROUP BY clause and before any ORDER BY clause. The exception is that the INTO clause can appear either as shown in the syntax description or immediately preceding the FROM clause.

*

A select_expr can be given an alias using AS alias_name. The alias is used as the expression's column name and can be used in GROUP BY, ORDER BY, or HAVING clauses. For example:

SELECT CONCAT(last_name,', ',first_name) AS full_name
FROM mytable ORDER BY full_name;

The AS keyword is optional when aliasing a select_expr. The preceding example could have been written like this:

SELECT CONCAT(last_name,', ',first_name) full_name
FROM mytable ORDER BY full_name;

However, because the AS is optional, a subtle problem can occur if you forget the comma between two select_expr expressions: MySQL interprets the second as an alias name. For example, in the following statement, columnb is treated as an alias name:

SELECT columna columnb FROM mytable;

For this reason, it is good practice to be in the habit of using AS explicitly when specifying column aliases.
*

It is not allowable to use a column alias in a WHERE clause, because the column value might not yet be determined when the WHERE clause is executed. See Section B.1.5.4, “Problems with Column Aliases”.
*

The FROM table_references clause indicates the table or tables from which to retrieve rows. If you name more than one table, you are performing a join. For information on join syntax, see Section 12.2.7.1, “JOIN Syntax”. For each table specified, you can optionally specify an alias.

tbl_name [[AS] alias] [index_hint]

The use of index hints provides the optimizer with information about how to choose indexes during query processing. For a description of the syntax for specifying these hints, see Section 12.2.7.2, “Index Hint Syntax”.

You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. See Section 5.2.3, “System Variables”.
*

You can refer to a table within the default database as tbl_name, or as db_name.tbl_name to specify a database explicitly. You can refer to a column as col_name, tbl_name.col_name, or db_name.tbl_name.col_name. You need not specify a tbl_name or db_name.tbl_name prefix for a column reference unless the reference would be ambiguous. See Section 8.2.1, “Identifier Qualifiers”, for examples of ambiguity that require the more explicit column reference forms.
*

A table reference can be aliased using tbl_name AS alias_name or tbl_name alias_name:

SELECT t1.name, t2.salary FROM employee AS t1, info AS t2
WHERE t1.name = t2.name;

SELECT t1.name, t2.salary FROM employee t1, info t2
WHERE t1.name = t2.name;

*

Columns selected for output can be referred to in ORDER BY and GROUP BY clauses using column names, column aliases, or column positions. Column positions are integers and begin with 1:

SELECT college, region, seed FROM tournament
ORDER BY region, seed;

SELECT college, region AS r, seed AS s FROM tournament
ORDER BY r, s;

SELECT college, region, seed FROM tournament
ORDER BY 2, 3;

To sort in reverse order, add the DESC (descending) keyword to the name of the column in the ORDER BY clause that you are sorting by. The default is ascending order; this can be specified explicitly using the ASC keyword.

If ORDER BY occurs within a subquery and also is applied in the outer query, the outermost ORDER BY takes precedence. For example, results for the following statement are sorted in descending order, not ascending order:

(SELECT ... ORDER BY a) ORDER BY a DESC;

Use of column positions is deprecated because the syntax has been removed from the SQL standard.
*

If you use GROUP BY, output rows are sorted according to the GROUP BY columns as if you had an ORDER BY for the same columns. To avoid the overhead of sorting that GROUP BY produces, add ORDER BY NULL:

SELECT a, COUNT(b) FROM test_table GROUP BY a ORDER BY NULL;

*

MySQL extends the GROUP BY clause so that you can also specify ASC and DESC after columns named in the clause:

SELECT a, COUNT(b) FROM test_table GROUP BY a DESC;

*

MySQL extends the use of GROUP BY to allow selecting fields that are not mentioned in the GROUP BY clause. If you are not getting the results that you expect from your query, please read the description of GROUP BY found in Section 11.11, “Functions and Modifiers for Use with GROUP BY Clauses”.
*

GROUP BY allows a WITH ROLLUP modifier. See Section 11.11.2, “GROUP BY Modifiers”.
*

The HAVING clause is applied nearly last, just before items are sent to the client, with no optimization. (LIMIT is applied after HAVING.)

A HAVING clause can refer to any column or alias named in a select_expr in the SELECT list or in outer subqueries, and to aggregate functions. However, the SQL standard requires that HAVING must reference only columns in the GROUP BY clause or columns used in aggregate functions. To accommodate both standard SQL and the MySQL-specific behavior of being able to refer columns in the SELECT list, MySQL 5.0.2 and up allows HAVING to refer to columns in the SELECT list, columns in the GROUP BY clause, columns in outer subqueries, and to aggregate functions.

For example, the following statement works in MySQL 5.0.2 but produces an error for earlier versions:

mysql> SELECT COUNT(*) FROM t GROUP BY col1 HAVING col1 = 2;

If the HAVING clause refers to a column that is ambiguous, a warning occurs. In the following statement, col2 is ambiguous because it is used as both an alias and a column name:

SELECT COUNT(col1) AS col2 FROM t GROUP BY col2 HAVING col2 = 2;

Preference is given to standard SQL behavior, so if a HAVING column name is used both in GROUP BY and as an aliased column in the output column list, preference is given to the column in the GROUP BY column.
*

Do not use HAVING for items that should be in the WHERE clause. For example, do not write the following:

SELECT col_name FROM tbl_name HAVING col_name > 0;

Write this instead:

SELECT col_name FROM tbl_name WHERE col_name > 0;

*

The HAVING clause can refer to aggregate functions, which the WHERE clause cannot:

SELECT user, MAX(salary) FROM users
GROUP BY user HAVING MAX(salary) > 10;

(This did not work in some older versions of MySQL.)
*

MySQL allows duplicate column names. That is, there can be more than one select_expr with the same name. This is an extension to standard SQL. Because MySQL also allows GROUP BY and HAVING to refer to select_expr values, this can result in an ambiguity:

SELECT 12 AS a, a FROM t GROUP BY a;

In that statement, both columns have the name a. To ensure that the correct column is used for grouping, use different names for each select_expr.
*

MySQL resolves unqualified column or alias references in ORDER BY clauses by searching in the select_expr values, then in the columns of the tables in the FROM clause. For GROUP BY or HAVING clauses, it searches the FROM clause before searching in the select_expr values. (For GROUP BY and HAVING, this differs from the pre-MySQL 5.0 behavior that used the same rules as for ORDER BY.)
*

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be non-negative integer constants (except when using prepared statements).

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

With one argument, the value specifies the number of rows to return from the beginning of the result set:

SELECT * FROM tbl LIMIT 5; # Retrieve first 5 rows

In other words, LIMIT row_count is equivalent to LIMIT 0, row_count.

For prepared statements, you can use placeholders (supported as of MySQL version 5.0.7). The following statements will return one row from the tbl table:

SET @a=1;
PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?';
EXECUTE STMT USING @a;

The following statements will return the second to sixth row from the tbl table:

SET @skip=1; SET @numrows=5;
PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;

For compatibility with PostgreSQL, MySQL also supports the LIMIT row_count OFFSET offset syntax.

If LIMIT occurs within a subquery and also is applied in the outer query, the outermost LIMIT takes precedence. For example, the following statement produces two rows, not one:

(SELECT ... LIMIT 1) LIMIT 2;

*

The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed. As of MySQL 5.0.19, the character_set_filesystem system variable controls the interpretation of the filename.

The SELECT ... INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT ... INTO OUTFILE. In that case, you should instead use a command such as mysql -e "SELECT ..." > file_name to generate the file on the client host.

SELECT ... INTO OUTFILE is the complement of LOAD DATA INFILE; the syntax for the export_options part of the statement consists of the same FIELDS and LINES clauses that are used with the LOAD DATA INFILE statement. See Section 12.2.5, “LOAD DATA INFILE Syntax”.

FIELDS ESCAPED BY controls how to write special characters. If the FIELDS ESCAPED BY character is not empty, it is used as a prefix that precedes following characters on output:
o

The FIELDS ESCAPED BY character
o

The FIELDS [OPTIONALLY] ENCLOSED BY character
o

The first character of the FIELDS TERMINATED BY and LINES TERMINATED BY values
o

ASCII NUL (the zero-valued byte; what is actually written following the escape character is ASCII “0”, not a zero-valued byte)

The FIELDS TERMINATED BY, ENCLOSED BY, ESCAPED BY, or LINES TERMINATED BY characters must be escaped so that you can read the file back in reliably. ASCII NUL is escaped to make it easier to view with some pagers.

The resulting file does not have to conform to SQL syntax, so nothing else need be escaped.

If the FIELDS ESCAPED BY character is empty, no characters are escaped and NULL is output as NULL, not \N. It is probably not a good idea to specify an empty escape character, particularly if field values in your data contain any of the characters in the list just given.

Here is an example that produces a file in the comma-separated values (CSV) format used by many programs:

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

*

If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file.
*

The INTO clause can name a list of one or more variables, which can be user-defined variables, or parameters or local variables within a stored function or procedure body. The selected values are assigned to the variables. The number of variables must match the number of columns.

Within a stored routine, the variables can be routine parameters or local variables. See Section 18.2.7.3, “SELECT ... INTO Statement”.
*
Note

Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. (You should never run mysqld as root for this and other reasons.) The file thus must be world-writable so that you can manipulate its contents.
*

The SELECT syntax description at the beginning this section shows the INTO clause near the end of the statement. It is also possible to use INTO OUTFILE or INTO DUMPFILE immediately preceding the FROM clause.
*

A PROCEDURE clause names a procedure that should process the data in the result set. For an example, see Section 26.3.1, “Procedure Analyse”.
*

If you use FOR UPDATE with a storage engine that uses page or row locks, rows examined by the query are write-locked until the end of the current transaction. Using LOCK IN SHARE MODE sets a shared lock that allows other transactions to read the examined rows but not to update or delete them. See Section 13.2.10.5, “SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads”.

Following the SELECT keyword, you can use a number of options that affect the operation of the statement.

The ALL, DISTINCT, and DISTINCTROW options specify whether duplicate rows should be returned. If none of these options are given, the default is ALL (all matching rows are returned). DISTINCT and DISTINCTROW are synonyms and specify removal of duplicate rows from the result set.

HIGH_PRIORITY, STRAIGHT_JOIN, and options beginning with SQL_ are MySQL extensions to standard SQL.

*

HIGH_PRIORITY gives the SELECT higher priority than a statement that updates a table. You should use this only for queries that are very fast and must be done at once. A SELECT HIGH_PRIORITY query that is issued while the table is locked for reading runs even if there is an update statement waiting for the table to be free. This affects only storage engines that use only table-level locking (MyISAM, MEMORY, MERGE).

HIGH_PRIORITY cannot be used with SELECT statements that are part of a UNION.
*

STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed in the FROM clause. You can use this to speed up a query if the optimizer joins the tables in non-optimal order. See Section 6.2.1, “Optimizing Queries with EXPLAIN”. STRAIGHT_JOIN also can be used in the table_references list. See Section 12.2.7.1, “JOIN Syntax”.
*

SQL_BIG_RESULT can be used with GROUP BY or DISTINCT to tell the optimizer that the result set has many rows. In this case, MySQL directly uses disk-based temporary tables if needed, and prefers sorting to using a temporary table with a key on the GROUP BY elements.
*

SQL_BUFFER_RESULT forces the result to be put into a temporary table. This helps MySQL free the table locks early and helps in cases where it takes a long time to send the result set to the client.
*

SQL_SMALL_RESULT can be used with GROUP BY or DISTINCT to tell the optimizer that the result set is small. In this case, MySQL uses fast temporary tables to store the resulting table instead of using sorting. This should not normally be needed.
*

SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause. The number of rows can then be retrieved with SELECT FOUND_ROWS(). See Section 11.10.3, “Information Functions”.
*

SQL_CACHE tells MySQL to store the query result in the query cache if you are using a query_cache_type value of 2 or DEMAND. For a query that uses UNION or subqueries, this option effects any SELECT in the query. See Section 6.5.4, “The MySQL Query Cache”.
*

SQL_NO_CACHE tells MySQL not to store the query result in the query cache. See Section 6.5.4, “The MySQL Query Cache”. For a query that uses UNION or subqueries, this option effects any SELECT in the query.

What is favicon.cio

2007-10-31T09:41:00.000+07:00

Favicon is the acronym for ‘Favorites Icon’. The small image displayed at the beginning of the URL bar or address bar of browser is known as the Favicon. That icon is nothing but the small symbol of the whole web page or the site and thus is also known as the pageicon or urlicon.

Creating favicon.ico :
1. Create an image of 16×16 pixels.
2. Save that image as ‘favicon.ico’ .

Placing or Uploading favicon.ico :
Favicon.ico file must be uploaded under the root directory of the web server so that it is automatically displayed on the address bar. And if the favicon.ico is not uploaded in the root directory the developer will have to specify a tag in section of the web page for locating that icon.

<link rel=”shortcut icon” xhref=”/favicon.ico” type=”image/x-icon” />
For XHTML, the link element must be terminated by ” />” instead of “>”.
Give specific path to href attribute so that the favicon.ico will get located.

Most of the browsers available read the faicon.ico file format correctly and thus easily displays the icon in the URL bar. However, now some browsers also support animated GIF and PNG image formats. Older versions of IE dont display this favicon; but now the newer versions support favicons.

Advantages and Limitations of favicon.ico :
The important advantage of using favicon is to make your Favorites entry easier to find. But Favicon also has limitations. Only newer versions of IE shows icon in the Favorites listings as well as in the address bar. While netscape and opera use it only in the address bar and not in the bookmarks list. Also, the icon disappears when the browser cache is emptied.

Fungsi PHP untuk menghitung umur

2007-10-26T14:28:00.000+07:00

Umur seseorang dihitung berdasarkan perbedaan tanggal lahirnya dengan tanggal sekarang. Kali ini saya akan memberikan fungsi PHP untuk menghitung umur.


//sebuah function dengan nama hitUmur dan sebuah parameter
function hitUmur($tgllahir) {
        $tgl = explode("-", $tgllahir);
       // memecah $tgllahir yang tadinya YYYY-MM-DD menjadi array
      // $tgl[0] = tahun (YYYY)
     //  $tgl[a] = bulan (MM)
    // $tgl[2] = hari (DD)

        $umur = date("Y") - $tgl[0];  //ini untuk ngitung umurnya
     
        if(($tgl[1] > date("m")) || ($tgl[1] == date("m") && date("d") < $tgl[2])) //ngecek apakah tgl lahir dan bulannya belum lewat?
        {
   
                $umur -= 1;
        }
        return $umur;
} 

//cara mengakses fungsi
$tgllahirku = "1980-10-12";
echo hitUmur($tgllahirku);
?>

Instalasi PHP, APACHE, MYSQL

2007-10-03T10:41:00.000+07:00

bagi anda yang mau instalasi php, apache dan mysql satu-persatu. Bisa diwonload tutorialnya di sini. Tutorial berbentuk file swf....
1. Untuk instalasi di Windows, http://www.megaupload.com/?d=28V56YG8
2. Untuk instalasi di Linux, http://www.megaupload.com/?d=OGGHZH6S

Semoga tutorial di atas dapat membantu.....

Membasmi virus mahadewa labkom ubl

2007-09-26T09:36:00.000+07:00

Belakangan ini banyak rekan-rekan yang berkunjung ke blog saya yang lainnya dan mereka komplain karena komputernya terkena virus mahadewa labkom ubl. Karena itu akan saya berikan cara untuk menghilangkan virus tsb. Ada 2 cara untuk menghilangkan virus tsb.
1. Dengan menggunakan antivirus
Gunakan antivirus ansav yang dapat didownload melalui situs www.ansav.com.

2. Manual
Antivirus memang bisa membersihkan virus tsb, akan tetapi virus tersebut akan masuk ke registry windows kita. Nah, untuk membersihkannya, silakan masuk ke registry. Yaitu dengan menekan Start->Run kemudian ketik regedit.
Sebelum masuk ke regedit, matikan proses wscript.exe yang sedang berjalan melalui task manager. Cara masuk ke task manager yaitu dengan cara Start->Run kemudian ketik taskmgr. Matikan proses yang bernama wscript.exe.
Langkah selanjutnya adalah masuk ke gpedit. Tujuannya adalah untuk mencegah virus kembali berjalan. Cara masuk ke gpedit yaitu dengan cara Start->Run kemudian ketik gpedit.msc. Setelah gpedit muncul, pilih menu user configuration->administrative template->system. Pada jendela yang ada di sampingnya, pilih menu don't run specified windows application dengan cara mengklik 2 kali. Pilih combo box enable. Masukkan wscript.exe, MaHaDeWa.vbs. dll, WinXp.vbs pada textbox yang tersedia.
Selanjutnya bersihkan file induk virus.
a. Hapus file WinXp.vbs di c:\windows\
b. Hapus file MaHaDeWa.vbs.dll di c:\windows\system32

Setelah file indek terhapus, selanjutnya tinggal membersihkan registry. Buka regedit dengan cara Start->Run ketik regedit.
Cari string dalam registry yang mengandung kata mahadewa. CAranya tekan CTRL+F kemudian ketik mahadewa. Hapus deh semua string yang mengandung kata mahadewa...

Semoga virus mahadewa hilang dari komputer Anda dan tidak kembali lagi...
Semoga artikel ini bisa membantu rekan-rekan yang kesulitan akibat virus mahadewa

How To Enable Autorun for Other Removable Media

2007-09-20T08:08:00.000+07:00

How To Enable Autorun for Other Removable Media

Autorun can be enabled or disabled for all Removable media types, such as a floppy or Zip disk. Windows systems are configured to enable CD Notification, other removable media are by default disabled.

The System Properties User interface only exposes the CD Enable or Disable selection. The setting reflected in this dialog makes an entry in the System Registry. It is in this same location that other media types are configured.

Notes:

1. Modifiying the Registry is not for the inexperienced user. Anyone will tell you, be VERY careful.
2. The modifications made in this case use Hex not Decimal numbers. If you are unfamiliar with the Registry or the characteristics of base numbering and Hex, studying these topics prior to making these modifications is advisable.

To Modify these Registry Settings, Use Regedit and navigate to the following Key:

HKEY_CURRENT_USER
Software
Microsoft
Windows
CurrentVersion
Policies
Explorer
"NoDriveTypeAutoRun"

The default value for the setting is 95 0 0 0. Change the first byte to 91. Restart the computer to make the new setting take effect. You may have to right-click on the floppy and choose AutoPlay from the menu to see the AutoPlay behavior.

Using ADOdb with PHP and Oracle: an advanced tutorial

2007-09-19T13:10:00.000+07:00

1. Introduction

Oracle is the most popular commercial database used with PHP. There are many ways of accessing Oracle databases in PHP. These include:

* The oracle extension
* The oci8 extension
* PEAR DB library
* ADOdb library

The wide range of choices is confusing to someone just starting with Oracle and PHP. I will briefly summarize the differences, and show you the advantages of using ADOdb.

First we have the C extensions which provide low-level access to Oracle functionality. These C extensions are precompiled into PHP, or linked in dynamically when the web server starts up. Just in case you need it, here's a guide to installing Oracle and PHP on Linux.
Oracle extension Designed for Oracle 7 or earlier. This is obsolete.
Oci8 extension Despite it's name, which implies it is only for Oracle 8i, this is the standard method for accessing databases running Oracle 8i, 9i or 10g (and later).

Here is an example of using the oci8 extension to query the emp table of the scott schema with bind parameters:

$conn = OCILogon("scott","tiger", $tnsName);

$stmt = OCIParse($conn,"select * from emp where empno > :emp order by empno");
$emp = 7900;
OCIBindByName($stmt, ':emp', $emp);
$ok = OCIExecute($stmt);
while (OCIFetchInto($stmt,$arr)) {
print_r($arr);
echo "

";
}

This generates the following output:
Array ( [0] => 7902 [1] => FORD [2] => ANALYST [3] => 7566 [4] => 03/DEC/81 [5] => 3000 [7] => 20 ) Array ( [0] => 7934 [1] => MILLER [2] => CLERK [3] => 7782 [4] => 23/JAN/82 [5] => 1300 [7] => 10 )

We also have many higher level PHP libraries that allow you to simplify the above code. The most popular are PEAR DB and ADOdb. Here are some of the differences between these libraries:
Feature PEAR DB 1.6 ADOdb 4.52
General Style Simple, easy to use. Lacks Oracle specific functionality. Has multi-tier design. Simple high-level design for beginners, and also lower-level advanced Oracle functionality.
Support for Prepare Yes, but only on one statement, as the last prepare overwrites previous prepares. Yes (multiple simultaneous prepare's allowed)
Support for LOBs No Yes, using update semantics
Support for REF Cursors No Yes
Support for IN Parameters Yes Yes
Support for OUT Parameters No Yes
Schema creation using XML No Yes, including ability to define tablespaces and constraints
Provides database portability features No Yes, has some ability to abstract features that differ between databases such as dates, bind parameters, and data types.
Performance monitoring and tracing No Yes. SQL can be traced and linked to web page it was executed on. Explain plan support included.
Recordset caching for frequently used queries No Yes. Provides great speedups for SQL involving complex where, group-by and order-by clauses.
Popularity Yes, part of PEAR release Yes, many open source projects are using this software, including PostNuke, Xaraya, Mambo, Tiki Wiki.
Speed Medium speed. Very high speed. Fastest database abstraction library available for PHP. Benchmarks are available.
High Speed Extension available No Yes. You can install the optional ADOdb extension, which reimplements the most frequently used parts of ADOdb as fast C code. Note that the source code version of ADOdb runs just fine without this extension, and only makes use of the extension if detected.

PEAR DB is good enough for simple web apps. But if you need more power, you can see ADOdb offers more sophisticated functionality. The rest of this article will concentrate on using ADOdb with Oracle. You can find out more about connecting to Oracle later in this guide.
ADOdb Example

In ADOdb, the above oci8 example querying the emp table could be written as:

include "/path/to/adodb.inc.php";
$db = NewADOConnection("oci8");
$db->Connect($tnsName, "scott", "tiger");

$rs = $db->Execute("select * from emp where empno>:emp order by empno",
array('emp' => 7900));
while ($arr = $rs->FetchRow()) {
print_r($arr);
echo "

";
}

The Execute( ) function returns a recordset object, and you can retrieve the rows returned using $recordset->FetchRow( ).

If we ignore the initial connection preamble, we can see the ADOdb version is much easier and simpler:
Oci8 ADOdb

$stmt = OCIParse($conn,
"select * from emp where empno > :emp");
$emp = 7900;
OCIBindByName($stmt, ':emp', $emp);
$ok = OCIExecute($stmt);

while (OCIFetchInto($stmt,$arr)) {
print_r($arr);
echo "

";
}

$recordset = $db->Execute("select * from emp where empno>:emp",
array('emp' => 7900));

while ($arr = $recordset->FetchRow()) {
print_r($arr);
echo "

";
}

2. ADOdb Query Semantics

You can also query the database using the standard Microsoft ADO MoveNext( ) metaphor. The data array for the current row is stored in the fields property of the recordset object, $rs. MoveNext( ) offers the highest performance among all the techniques for iterating through a recordset:

$rs = $db->Execute("select * from emp where empno>:emp", array('emp' => 7900));
while (!$rs->EOF) {
print_r($rs->fields);
$rs->MoveNext();
}

And if you are interested in having the data returned in a 2-dimensional array, you can use:

$arr = $db->GetArray("select * from emp where empno>:emp", array('emp' => 7900));

Now to obtain only the first row as an array:

$arr = $db->GetRow("select * from emp where empno=:emp", array('emp' => 7900));

Or to retrieve only the first field of the first row:

$arr = $db->GetOne("select ename from emp where empno=:emp", array('emp' => 7900));

For easy pagination support, we provide the SelectLimit function. The following will perform a select query, limiting it to 100 rows, starting from row 201 (row 1 being the 1st row):

$offset = 200; $limitrows = 100;
$rs = $db->SelectLimit('select * from table', $limitrows, $offset);

The $offset parameter is optional.
Array Fetch Mode

When data is being returned in an array, you can choose the type of array the data is returned in.

1. Numeric indexes - use $connection->SetFetchMode(ADODB_FETCH_NUM).
2. Associative indexes - the keys of the array are the names of the fields (in upper-case). Use $connection->SetFetchMode(ADODB_FETCH_ASSOC).
3. Both numeric and associative indexes - use $connection->SetFetchMode(ADODB_FETCH_BOTH).

The default is ADODB_FETCH_BOTH for Oracle.
Caching

You can define a database cache directory using $ADODB_CACHE_DIR, and cache the results of frequently used queries that rarely change. This is particularly useful for SQL with complex where clauses and group-by's and order-by's. It is also good for relieving heavily-loaded database servers.

This example will cache the following select statement for 3600 seconds (1 hour):

$ADODB_CACHE_DIR = '/var/adodb/tmp';
$rs = $db->CacheExecute(3600, "select names from allcountries order by 1");

There are analogous CacheGetArray( ), CacheGetRow( ), CacheGetOne( ) and CacheSelectLimit( ) functions. The first parameter is the number of seconds to cache. You can also pass a bind array as a 3rd parameter (not shown above).

There is an alternative syntax for the caching functions. The first parameter is omitted, and you set the cacheSecs property of the connection object:

$ADODB_CACHE_DIR = '/var/adodb/tmp';
$connection->cacheSecs = 3600;
$rs = $connection->CacheExecute($sql, array('id' => 1));

3. Using Prepare( ) For Frequently Used Statements

Prepare( ) is for compiling frequently used SQL statement for reuse. For example, suppose we have a large array which needs to be inserted into an Oracle database. The following will result in a massive speedup in query execution (at least 20-40%), as the SQL statement only needs to be compiled once:

$stmt = $db->Prepare('insert into table (field1, field2) values (:f1, :f2)');
foreach ($arrayToInsert as $key => $value) {
$db->Execute($stmt, array('f1' => $key, 'f2' => $val);
}

4. Working With LOBs

Oracle treats data which is more than 4000 bytes in length specially. These are called Large Objects, or LOBs for short. Binary LOBs are BLOBs, and character LOBs are CLOBs. In most Oracle libraries, you need to do a lot of work to process LOBs, probably because Oracle designed it to work in systems with little memory. ADOdb tries to make things easy by assuming the LOB can fit into main memory.

ADOdb will transparently handle LOBs in select statements. The LOBs are automatically converted to PHP variables without any special coding.

For updating records with LOBs, the functions UpdateBlob( ) and UpdateClob( ) are provided. Here's a BLOB example. The parameters should be self-explanatory:

$ok = $db->Execute("insert into aTable (id, name, ablob)
values (aSequence.nextVal, 'Name', null)");
if (!$ok) return LogError($db->ErrorMsg());
# params: $tableName, $blobFieldName, $blobValue, $whereClause
$db->UpdateBlob('aTable', 'ablob', $blobValue, 'id=aSequence.currVal');

and the analogous CLOB example:

$ok = $db->Execute("insert into aTable (id, name, aclob)
values (aSequence.nextVal, 'Name', null)");
if (!$ok) return LogError($db->ErrorMsg());
$db->UpdateClob('aTable', 'aclob', $clobValue, 'id=aSequence.currVal');

Note that LogError( ) is a user-defined function, and not part of ADOdb.

Inserting LOBs is more complicated. Since ADOdb 4.55, we allow you to do this (assuming that the photo field is a BLOB, and we want to store $blob_data into this field, and the primary key is the id field):

$sql = "INSERT INTO photos ( ID, photo) ".
"VALUES ( :id, empty_blob() )".
" RETURNING photo INTO :xx";

$stmt = $db->PrepareSP($sql);
$db->InParameter($stmt, $id, 'id');
$blob = $db->InParameter($stmt, $blob_data, 'xx',-1, OCI_B_BLOB);
$db->StartTrans();
$ok = $db->Execute($stmt);
$db->CompleteTrans();

5. REF CURSORs

Oracle recordsets can be passed around as variables called REF Cursors. For example, in PL/SQL, we could define a function open_tab that returns a REF CURSOR in the first parameter:

TYPE TabType IS REF CURSOR RETURN TAB%ROWTYPE;

PROCEDURE open_tab (tabcursor IN OUT TabType,tablenames IN VARCHAR) IS
BEGIN
OPEN tabcursor FOR SELECT * FROM TAB WHERE tname LIKE tablenames;
END open_tab;

In ADOdb, we could access this REF Cursor using the ExecuteCursor() function. The following will find all table names that begin with 'A' in the current schema:

$rs = $db->ExecuteCursor("BEGIN open_tab(:refc,'A%'); END;",'refc');
while ($arr = $rs->FetchRow()) print_r($arr);

The first parameter is the PL/SQL statement, and the second parameter is the name of the REF Cursor.

6. In and Out Parameters

The following PL/SQL stored procedure requires an input variable, and returns a result into an output variable:

PROCEDURE data_out(input IN VARCHAR, output OUT VARCHAR) IS
BEGIN
output := 'I love '||input;
END;

The following ADOdb code allows you to call the stored procedure:

$stmt = $db->PrepareSP("BEGIN adodb.data_out(:a1, :a2); END;");
$input = 'Sophia Loren';
$db->InParameter($stmt,$input,'a1');
$db->OutParameter($stmt,$output,'a2');
$ok = $db->Execute($stmt);
if ($ok) echo ($output == 'I love Sophia Loren') ? 'OK' : 'Failed';

PrepareSP( ) is a special function that knows about bind parameters. The main limitation currently is that IN OUT parameters do not work.
Bind Parameters and REF CURSORs

We could also rewrite the REF CURSOR example to use InParameter (requires ADOdb 4.53 or later):

$stmt = $db->PrepareSP("BEGIN adodb.open_tab(:refc,:tabname); END;");
$input = 'A%';
$db->InParameter($stmt,$input,'tabname');
$rs = $db->ExecuteCursor($stmt,'refc');
while ($arr = $rs->FetchRow()) print_r($arr);

Bind Parameters and LOBs

You can also operate on LOBs. In this example, we have IN and OUT parameters using CLOBs.

$text = 'test test test';
$sql = "declare rs clob; begin :rs := lobinout(:sa0); end;";
$stmt = $conn -> PrepareSP($sql);
$conn -> InParameter($stmt,$text,'sa0', -1, OCI_B_CLOB); # -1 means variable length
$rs = '';
$conn -> OutParameter($stmt,$rs,'rs', -1, OCI_B_CLOB);
$conn -> Execute($stmt);
echo "return = ".$rs."
";

Similarly, you can use the constant OCI_B_BLOB to indicate that you are using BLOBs.
Reusing Bind Parameters with CURSOR_SHARING=FORCE

Many web programmers do not care to use bind parameters, and prefer to enter the SQL directly. So instead of:

$arr = $db->GetArray("select * from emp where empno>:emp", array('emp' => 7900));

They prefer entering the values inside the SQL:

$arr = $db->GetArray("select * from emp where empno>7900");

This reduces Oracle performance because Oracle will reuse compiled SQL which is identical to previously compiled SQL. The above example with the values inside the SQL is unlikely to be reused. As an optimization, from Oracle 8.1 onwards, you can set the following session parameter after you login:

ALTER SESSION SET CURSOR_SHARING=FORCE

This will force Oracle to convert all such variables (eg. the 7900 value) into constant bind parameters, improving SQL reuse.

More speedup tips.

7. Dates and Datetime in ADOdb

There are two things you need to know about dates in ADOdb.

First, to ensure cross-database compability, ADOdb assumes that dates are returned in ISO format (YYYY-MM-DD H24:MI:SS).

Secondly, since Oracle treats dates and datetime as the same data type, we decided not to display the time in the default date format. So on login, ADOdb will set the NLS_DATE_FORMAT to 'YYYY-MM-DD'. If you prefer to show the date and time by default, do this:

$db = NewADOConnection('oci8');
$db->NLS_DATE_FORMAT = 'RRRR-MM-DD HH24:MI:SS';
$db->Connect($tns, $user, $pwd);

Or execute:

$sql = "ALTER SESSION SET NLS_DATE_FORMAT = 'RRRR-MM-DD HH24:MI:SS'";
$db->Execute($sql);

If you are not concerned about date portability and do not use ADOdb's portability layer, you can use your preferred date format instead.

8. Database Portability Layer

ADOdb provides the following functions for portably generating SQL functions as strings to be merged into your SQL statements:
Function Description
DBDate($date) Pass in a UNIX timestamp or ISO date and it will convert it to a date string formatted for INSERT/UPDATE
DBTimeStamp($date) Pass in a UNIX timestamp or ISO date and it will convert it to a timestamp string formatted for INSERT/UPDATE
SQLDate($date, $fmt) Portably generate a date formatted using $fmt mask, for use in SELECT statements.
OffsetDate($date, $ndays) Portably generate a $date offset by $ndays.
Concat($s1, $s2, ...) Portably concatenate strings. Alternatively, for mssql use mssqlpo driver, which allows || operator.
IfNull($fld, $replaceNull) Returns a string that is the equivalent of MySQL IFNULL or Oracle NVL.
Param($name) Generates bind placeholders, using ? or named conventions as appropriate.
$db->sysDate Property that holds the SQL function that returns today's date
$db->sysTimeStamp Property that holds the SQL function that returns the current timestamp (date+time).
$db->concat_operator Property that holds the concatenation operator
$db->length Property that holds the name of the SQL strlen function.
$db->upperCase Property that holds the name of the SQL strtoupper function.
$db->random Property that holds the SQL to generate a random number between 0.00 and 1.00.
$db->substr Property that holds the name of the SQL substring function.

ADOdb also provides multiple oracle oci8 drivers for different scenarios:
Driver Name Description
oci805 Specifically for Oracle 8.0.5. This driver has a slower SelectLimit( ).
oci8 The default high performance driver. The keys of associative arrays returned in a recordset are upper-case.
oci8po The portable Oracle driver. Slightly slower than oci8. This driver uses ? instead of :bindvar for binding variables, which is the standard for other databases. Also the keys of associative arrays are in lower-case like other databases.

Here's an example of calling the oci8po driver. Note that the bind variables use question-mark:

$db = NewADOConnection('oci8po');
$db->Connect($tns, $user, $pwd);
$db->Execute("insert into atable (f1, f2) values (?,?)", array(12, 'abc'));

9. Connecting to Oracle

Before you can use ADOdb, you need to have the Oracle client installed and setup the oci8 extension. This extension comes pre-compiled for Windows (but you still need to enable it in the php.ini file). For information on compiling the oci8 extension for PHP and Apache on Unix, there is an excellent guide at oracle.com.
Should You Use Persistent Connections

One question that is frequently asked is should you use persistent connections to Oracle. Persistent connections allow PHP to recycle existing connections, reusing them after the previous web pages have completed. Non-persistent connections close automatically after the web page has completed. Persistent connections are faster because the cost of reconnecting is expensive, but there is additional resource overhead. As an alternative, Oracle allows you to pool and reuse server processes; this is called Shared Server (also known as MTS).

The author's benchmarks suggest that using non-persistent connections and the Shared Server configuration offer the best performance. If Shared Server is not an option, only then consider using persistent connections.
Connection Examples

Just in case you are having problems connecting to Oracle, here are some examples:

a. PHP and Oracle reside on the same machine, use default SID, with non-persistent connections:

$conn = NewADOConnection('oci8');
$conn->Connect(false, 'scott', 'tiger');

b. TNS Name defined in tnsnames.ora (or ONAMES or HOSTNAMES), eg. 'myTNS', using persistent connections:

$conn = NewADOConnection('oci8');
$conn->PConnect(false, 'scott', 'tiger', 'myTNS');

or

$conn->PConnect('myTNS', 'scott', 'tiger');

c. Host Address and SID

$conn->connectSID = true;
$conn->Connect('192.168.0.1', 'scott', 'tiger', 'SID');

d. Host Address and Service Name

$conn->Connect('192.168.0.1', 'scott', 'tiger', 'servicename');

e. Oracle connection string:

$cstr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=$host)(PORT=$port))
(CONNECT_DATA=(SID=$sid)))";
$conn->Connect($cstr, 'scott', 'tiger');

f. ADOdb data source names (dsn):

$dsn = 'oci8://user:pwd@tnsname/?persist'; # persist is optional
$conn = ADONewConnection($dsn); # no need for Connect/PConnect

$dsn = 'oci8://user:pwd@host/sid';
$conn = ADONewConnection($dsn);

$dsn = 'oci8://user:pwd@/'; # oracle on local machine
$conn = ADONewConnection($dsn);

With ADOdb data source names, you don't have to call Connect( ) or PConnect( ).

10. Error Checking

The examples in this article are easy to read but a bit simplistic because we ignore error-handling. Execute( ) and Connect( ) will return false on error. So a more realistic way to call Connect( ) and Execute( ) is:

function InvokeErrorHandler()
{
global $db; ## assume global
MyLogFunction($db->ErrorNo(), $db->ErrorMsg());
}
if (!$db->Connect($tns, $usr, $pwd)) InvokeErrorHandler();

$rs = $db->Execute("select * from emp where empno>:emp order by empno",
array('emp' => 7900));
if (!$rs) return InvokeErrorHandler();
while ($arr = $rs->FetchRow()) {
print_r($arr);
echo "

";
}

You can retrieve the error message and error number of the last SQL statement executed from ErrorMsg( ) and ErrorNo( ). You can also define a custom error handler function. ADOdb also supports throwing exceptions in PHP5.

Handling Large Recordsets (added 27 May 2005)
The oci8 driver does not support counting the number of records returned in a SELECT statement, so the function RecordCount() is emulated when the global variable $ADODB_COUNTRECS is set to true, which is the default. We emulate this by buffering all the records. This can take up large amounts of memory for big recordsets. Set $ADODB_COUNTRECS to false for the best performance.

This variable is checked every time a query is executed, so you can selectively choose which recordsets to count.

Cara Instalasi XAMPP

2007-09-14T08:17:00.000+07:00

XAMPP merupakan sebuah paket instalasi untuk PHP, APACHE dan MySQL. Dengan menggunakan XAMPP, kita tidak perlu lagi repot menginstall ketiga software itu secara terpisah. XAMPP dapat di download di http://www.apachefriends.org/en/index.html. Berikut ini adalah cara menginstall XAMPP.

1. Jalankan file xampp-win32-1.4.12-installer.exe (atau versi lainnya)

2. Kemudian akan tampil pilihan untuk memilih bahasa ketika proses instalasi berjalan. Silakan pilih bahasa Indonesian atau English, kecuali anda menguasai bahasa lainnya. Pada contoh ini saya memilih bahasa Indonesian karena saya cinta bahasa Indonesia. Memilih bahasa

3. Proses instalasi akan dimulai. Klik Maju untuk memulainya. Mulai Instalasi

4. Akan muncul lisensi software. Silahkan membacanya jika anda mau, tetapi saya lebih suka untuk tidak membacanya karena terlalu banyak. Klik Saya Setuju untuk melanjutkan.Lisensi Software

5. Selanjutnya silakan anda pilih lokasi install untuk XAMPP. Kemudian klik install

6. Tunggu beberapa saat sampai proses instalasi selesai.Tunggu sebentar

7. Instalasi selesai

8. Sampai tahap ini, berarti kita sudah menginstal XAMPP. Itu berarti kita sudah selesai menginstall PHP, APACHE dan MYSQL. Langkah selanjutnya adalah menjalankan servicenya.

9. Jalankan XAMPP Control Panel yang ada di desktop. Atau anda juga dapat menjalankan XAMPP Control Panel dari menu Start -> All Programs -> apachefriends -> xampp -> xampp control panel. xampp control panel

10. Nyalakan Apache dan Mysql dengan mengklik tombol Start. Buka web browser anda, lalu ketikkan http://localhost. Jika tampilannya seperti di bawah ini, maka apache sudah terinstall dengan benar.

11. Sekedar informasi saja, document root milik XAMPP terletak pada folder E:\Program Files\apachefriends\xampp\htdocs. Hal ini disebabkan karena saya menginstall XAMPP pada folder E:\Program Files\apachefriends.

PhpMyAdmin

2007-09-13T08:03:00.000+07:00

Phpmyadmin adalah suatu aplikasi yang dibuat dengan bahasa pemrograman PHP yang ditujukan untuk pengelolaan basis data MySQL melalui Internet. Fungsi phpmyadmin sama dengan fungsi software lain seperti SQLYOG dan MySQLFront. Hanya saja PhpMyAdmin adalah free software. Sebelum mengikuti tutorial ini lebih lanjut, ada baiknya anda mendownload dulu phpmyadmin.

Cara Menggunakan Phpmyadmin

1. Pastikan Apache, PHP dan MySQL sudah terinstall di komputer Anda. Copy file phpMyAdmin-2.5.6.zip ke dalam folder di mana anda menyimpan file php (dalam Document Root)

2. Extract file tersebut sehingga akan terbentuk sebuah folder bernama phpMyAdmin-2.5.6

3. Bukalah web browser dan ketikkan http://localhost, lalu carilah folder tersebut.
Jika web browser anda menampilkan halaman sbb, maka anda harus mengatur / konfigurasi username dan password mysql di phpmyadmin terlebih dahulu.

4. Akan tetapi jika tampilannya sebagai berikut, berarti anda tidak perlu melakukan pengaturan / konfigurasi username dan password mysql di phpmyadmin

5. Jika tampilannya seperti pada gambar 3, maka anda harus melakukan konfigurasi username dan password mysqldi phpmyadmin. Caranya adalah buka folder phpMyAdmin-2.5.6 melalui windows explorer. Kemudian bukalah file config.inc.php (boleh menggunakan Dreamweaver maupun notepad).

6. Ubahlah beberapa settingan sbb :
di baris ke 69 : $cfg[’Servers’][$i][’host’] = ‘localhost’;
$cfg[’Servers’][$i][’host’] berisi host atau komputer tempat database mysql berada. Isi dengan localhost jika database mysql berada di komputer anda

Di baris ke-70 : $cfg[’Servers’][$i][’port’] = ‘’;
$cfg[’Servers’][$i][’port’] adalah port yang digunakan mysql. Kosongkan jika mysql anda menggunakan port standar (3306)

Di baris ke-83 : $cfg[’Servers’][$i][’user’] = ‘root’;
$cfg[’Servers’][$i][’user’] adalah user yang digunakan untuk koneksi ke mysql

Di baris ke-84 : $cfg[’Servers’][$i][’password’] = ‘’;
$cfg[’Servers’][$i][’password’] adalah password yang digunakan untuk koneksi ke mysql

Blog Is ...

2007-09-05T19:15:00.000+07:00

From Wikipedia, the free encyclopedia

For other uses, see Blog (disambiguation).
“Blogger” redirects here. For the blog publishing system, see Blogger (service).

A blog (a portmanteau of web log) is a website where entries are written in chronological order and commonly displayed in reverse chronological order. "Blog" can also be used as a verb, meaning to maintain or add content to a blog.

Blogs provide commentary or news on a particular subject such as food, politics, or local news; some function as more personal online diaries. A typical blog combines text, images, and links to other blogs, web pages, and other media related to its topic. The ability for readers to leave comments in an interactive format is an important part of many blogs. Most blogs are primarily textual, although some focus on art (artlog), photographs (photoblog), sketchblog, videos (vlog), music (MP3 blog), audio (podcasting) or sexual topics (Adult blog), and are part of a wider network of social media. Micro-blogging is another type of blogging which consists of blogs with very short posts.

In May 2007, blog search engine Technorati was tracking more than 71 million blogs

Membuat Halaman Login Dengan PHP, MySQL, AJAX, Script.aculo.us dan Prototype.js (bag 2)

2007-08-20T11:14:00.000+07:00

Oke, sekarang akan saya lanjutkan tutorial yang kedua. Saya anggap Anda sudah mendownload script.acyulo.us dan prototype.js. Kalo belum, silakan anda download lebih dahulu.
Silakan buka file login.php dan ubah menjadi sebagai berikut.
login.php

buat juga CSS nya dan simpan dengan nama style.css

sampai sejauh ini, kita udah membuat 2 buah file, yaitu login.php dan style.css, selanjutnya kita harus membuat satu file lagi yaitu ajax.php yang akan digunakan untuk mengecek login. Kita juga butuh sebuah database yang berisikan username dan password. Tunggu tutorial bagian ke-3 ya....

Membuat Halaman Login Dengan PHP, MySQL, AJAX, Script.aculo.us dan Prototype.js (bag 1)

2007-08-16T08:21:00.000+07:00

Dalam tutorial kali ini, saya akan menjelaskan bagaimana cara membuat halaman login dengan PHP, MySQL, AJAX, ScriptAculous dan Prototype.js. Untuk mengikuti tutorial ini, Anda sebaiknya sudah mengerti konsep webserver, PHP, dan database MySQL. Kalo belum, sebaiknya Anda mempelajarinya terlebih dahulu. Anda juga harus mengerti AJAX, ScriptAculous dan Prototype.js. Kalo belum mengerti, sebaiknya baca tutorialnya di sini dulu.

Oke, kita mulai saja ya... Pertama Anda harus menyiapkan sebuah halaman HTML untuk login. Kita beri nama "login.php".

saya rasa untuk tag HTML tidak perlu saya jelaskan lagi. Itu adalah tag HTML untuk membuat halaman login yang terdiri dari textbox username dan password. Dalam HTML di atas juga saya buatkan sebuah div untuk menampung hasil error ketika proses login berlangsung. Untuk mengikuti tutorial login bagian ke2, sebaiknya Anda download dulu library prototype.js dan scriptaculous. Tunggu tutorial bagian keduanya ya....

The Meaning Of Tutorial

2007-08-02T07:57:00.000+07:00

Based on wiki, the meaning of tutorial is :

is a document, software, or other media created for the purpose of instruction for any of a wide variety of tasks.

Tutorials usually have the following characteristics:

* A presentation of content, usually with an example or examples, often broken up into discrete modules or sections.
* Some method of review that reinforces or tests understanding of the content in the related module or section.
* A transition to additional modules or sections that builds on the instructions already provided. Tutorials can be linear or branching.

While many writers refer to a mere list of instructions or tips as a tutorial, this usage can be misleading.

In computer based education, a tutorial is a computer program whose purpose it is to assist users in learning how to use (parts of) a software product such as an office suite or any other application, operating system interface, programming tool, or game. There are two kinds of software tutorials: movie tutorials that you watch, and interactive tutorials where you follow on-screen instructions (and in some cases watch short instruction movies), whereupon you do the tutorial exercises and get feedback depending on your actions. Some computer based tutorials can also be put up on the web.

Itu adalah arti dari kata tutorial yang ada di wiki. Intinya karena ini adalah blog yang akan berisi tutorial, maka mulai saat ini saya akan mencoba untuk memberikan beberapa tutorial yang berguna. Sedangkan blog saya yang satu lagi, hanya akan berisi tentang lirik lagu, kehidupan saya, motivasi dan renungan.

Kira-kira tutorial apa ya yang akan ditulis di sini? Atau ada rekan-rekan yang ingin request tutorial, silakan berikan komentarnya......

How To Connect PHP - MySQL

2007-07-22T11:00:00.000+07:00

In this post, I will explain you about PHP and MySQL. You can use PHP with MySQL database. You only need a simple script to connect PHP- MySQL.
1. mysql_connect() -- Open a connection to a MySQL Server
This function need several parameters. For example :
mysql_connect("localhost","root","12345")
notes : localhost --> the mysql server name
root --> the mysql username
12345 --> the mysql password

example : $link = mysql_connect("localhost", "mysql_user", "mysql_password")
or die("Could not connect");

2. mysql_select_db() --> Select a MySQL database
You need database name for this function
example : mysql_select_db("mysql")
notes : mysql is the database name is mysql database

3. mysql_query() --> Send a MySQL query
example : $result = mysql_query("SELECT * WHERE user='jhon'")
or die("Invalid query");
notes : SELECT * WHERE user='jhon' is query for mysql.

Date Function on PHP

2007-05-21T15:10:00.000+07:00

to display the time and date in PHP, we can use date function. This function have several parameter. example

<?
date('d-m-y h:i:s')
?>
this syntax will return 21-05-2007 15:25:32.
For other parameters, please try to change the example above.

`format` character	Description	Example returned values
`a`	Lowercase Ante meridiem and Post meridiem	`am` or `pm`
`A`	Uppercase Ante meridiem and Post meridiem	`AM` or `PM`
`B`	Swatch Internet time	`000` through `999`
`d`	Day of the month, 2 digits with leading zeros	`01` to `31`
`D`	A textual representation of a day, three letters	`Mon` through `Sun`
`F`	A full textual representation of a month, such as January or March	`January` through `December`
`g`	12-hour format of an hour without leading zeros	`1` through `12`
`G`	24-hour format of an hour without leading zeros	`0` through `23`
`h`	12-hour format of an hour with leading zeros	`01` through `12`
`H`	24-hour format of an hour with leading zeros	`00` through `23`
`i`	Minutes with leading zeros	`00` to `59`
`I` (capital i)	Whether or not the date is in daylights savings time	`1` if Daylight Savings Time, `0` otherwise.
`j`	Day of the month without leading zeros	`1` to `31`
`l` (lowercase 'L')	A full textual representation of the day of the week	`Sunday` through `Saturday`
`L`	Whether it's a leap year	`1` if it is a leap year, `0` otherwise.
`m`	Numeric representation of a month, with leading zeros	`01` through `12`
`M`	A short textual representation of a month, three letters	`Jan` through `Dec`
`n`	Numeric representation of a month, without leading zeros	`1` through `12`
`O`	Difference to Greenwich time (GMT) in hours	Example: `+0200`
`r`	RFC 822 formatted date	Example: `Thu, 21 Dec 2000 16:01:07 +0200`
`s`	Seconds, with leading zeros	`00` through `59`
`S`	English ordinal suffix for the day of the month, 2 characters	`st`, `nd`, `rd` or `th`. Works well with `j`
`t`	Number of days in the given month	`28` through `31`
`T`	Timezone setting of this machine	Examples: `EST`, `MDT` ...
`U`	Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)	See also time()
`w`	Numeric representation of the day of the week	`0` (for Sunday) through `6` (for Saturday)
`W`	ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0)	Example: `42` (the 42nd week in the year)
`Y`	A full numeric representation of a year, 4 digits	Examples: `1999` or `2003`
`y`	A two digit representation of a year	Examples: `99` or `03`
`z`	The day of the year	`0` through `366`
`Z`	Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.	`-43200` through `43200`

How to Create button in photoshop

2007-04-25T09:40:00.000+07:00

1. Open your photoshop program
2. Make new file with size 100 pixels x 20 pixels and transparent background
3. Click Rectangle Tool and select the style and colour do you want.
4. Fill the layer with rectangle tool

5. Select Type Tool and type the text in the button
6. Move the text to center. Select Type Tool. Select > All. Then click Align Vertical Center and Align Horizontal Center
7. Save your image. File > Save
8. Save for web. File > Save For Web

This is my another blog

2007-04-20T10:59:00.000+07:00

This is my another blog. I just try to write my blog in English. But my English is not very good.
My primary blog is http://away.blogsome.com.